Announcement

Collapse
No announcement yet.

Backup creation fails in Plesk: Cannot dump database content of type 'mysql'

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Backup creation fails in Plesk: Cannot dump database content of type 'mysql'

    Symptoms

    1. Backup fails with the following errors:

      Error: domain "example.com"
      Cannot dump database content 'db_example' of type 'mysql'
      Cannot backup content of database 'db_example'. The mysqldump utility has returned '2'.
      STDERR: mysqldump: Got error: 1049: Unknown database 'db_example' when selecting the database

      Or

      Warning:
      Deployer has been terminated by exception: Line 70 Position 4 Error: The element 'migration-dump' has invalid child element 'role'. List of possible elements expected: 'reseller-info, client-info, domain-info, server'.
    2. Database db_example does not exist on the server, however, psa database contains a record about it:
      mysql> select * from data_bases where name='db_example'; +----+-----------------+-------+--------+--------------+-----------------+ | id | name | type | dom_id | db_server_id | default_user_id | +----+-----------------+-------+--------+--------------+-----------------+ | 1 | db_example | mysql | 1 | 1 | 1 | +----+-----------------+-------+--------+--------------+-----------------+
    Cause

    Plesk database inconsistency.

    Question:

    How to solve this problem?

  • #2
    Hi,

    Could you please provide the following information? You can send the information to - https://help.navicat.com/hc/en-us/requests/new . We will get back to you by email.

    1. Your MySQL Server version, e.g. MySQL 5.7
    2. Your Navicat version, e.g. Navicat for MySQL (Windows) 12.1.10
    2. Screenshots showing how to reproduce the problem and all error messages.

    Comment

    Working...
    X