How to fix database inconsistency without access to shell

Question

How to access a database in order to fix database inconsistency, when there is no access to the server?

Answer

It is possible to access the database through Plesk directly using database management tools which provide a web interface for databases administration:

• phpMyAdmin
• pgMyAdmin
• myLittleAdmin

To access database through Plesk go to:

Tools and Settings > Database Servers > Access this server via DB webadmin

Or, for a particular domain:

Domains > example.com > Databases > click on database management tool (for example, phpMyAdmin)

To run a certain query in database management tool, choose the table in question and click SQL tab.

Learn more about Database Management Tools here .

More details about creating a database for a particular domain are available here .