Databases are not listed in Plesk web interface

Symptoms

• Databases disappeared from the subscription example.com ( Subscriptions > example.com > Databases ).
• Physically databases exist on MySQL server and can be accessed via PHPmyAdmin.

Cause

Absent records in Plesk database in data_bases and db_users tables.

Resolution

Absent records can be retrieved from Plesk database daily dumps:

1. Create Plesk database dump:

   # plesk db dump psa > /root/psa.dump.`date +%Y%m%d.%H%M`

2. Check Plesk database dumps in /var/lib/psa/dumps/ mysql.daily.dump.* for records regarding missing database (e.g, wordpress_db ). For searching use the database name:

   # zless /var/lib/psa/dumps/mysql.daily.dump.0.gz
   ...
   (2,'wordpress_db','mysql',7,3,NULL)
   ...

3. Insert the above record in data_base table:

   # plesk db
   mysql> INSERT INTO data_bases VALUES (2,'wordpress_db','mysql',7,3,NULL);
   

4. Find missing entry for db_users table using the same approach where db_id is equal to the id from previous step (2, in this example) and insert it:
   

   mysql> INSERT INTO `db_users` VALUES (8,'wordpress_user',4,2,'normal',12,1,'',NULL,'readWrite');

In case of difficulties, please contact Plesk Technical Support .