Article ID: 124536, created on Feb 24, 2015, last review on Feb 24, 2015

  • Applies to:
  • Plesk 11.0 for Linux
  • Plesk 11.5 for Linux


Backup creation fails with the following error:

Error:  mysql "db_name"

Cannot connect to mysql localhost:3306 (database 'db_name')

The following error appears in /usr/local/psa/PMM/sessions/YYYY-MM-DD-hhmmss.XXX/psadump.log:

DBI connect('dbname=db_name;host=localhost;port=3306','admin',...) failed: Unknown database 'db_name' at /usr/local/psa/PMM/agents/shared/Db/ line 47
ERROR 1049 (42000): Unknown database 'db_name'


The backup creation fails because db_name database does not exist in MySQL server, most likely it was removed not via Plesk interface, but via MySQL command line.

mysql> use db_name;
ERROR 1049 (42000): Unknown database 'db_name'


In order to remove it properly from Plesk follow the steps:

  1. Create an empty database with db_name name via MySQL command line:

    mysql> create database <database_name>;
    Query OK, 1 row affected (0.00 sec)
  2. Remove it properly via Plesk interface under Home - Subscriptions - - Websites & Domains - Databases

    Also you can remove a database using CLI utility /usr/local/psa/bin/database

    # /usr/local/psa/bin/database -r db_name

After that rerun backup creation task.

Search Words

backup error

Unknown database

Error: mysql Cannot connect to mysql localhost:3306

mysql backup error

backup generation throws error

Error: unable to execute SHOW TABLES:

Not valid XML document is returned from Panel Business Logic

Plesk backup task status is error

Connection error

a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c 01bc4c8cf5b7f01f815a7ada004154a2 29d1e90fd304f01e6420fbe60f66f838 0a53c5a9ca65a74d37ef5c5eaeb55d7f aea4cd7bfd353ad7a1341a257ad4724a

Email subscription for changes to this article
Save as PDF