Databases are not listed in Plesk web interface

Created:

2016-11-16 12:45:37 UTC

Modified:

2017-04-24 11:16:21 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Databases are not listed in Plesk web interface

Applicable to:

  • Plesk for Linux

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 .

Have more questions? Submit a request
Please sign in to leave a comment.