• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

Issue Migration & Transfer Manager - DB migration error

cladem

New Pleskian
Hi - when trying to migrate subscription from Server A (Plesk Obsidian installed on Debian 9) on Server B (Plesk Obsidian installed on Debian11) i receive the following error:

Failed to copy content of database 'XXX'
Migration tools tried to perform operation in 3 attempts: Command execution failed on the source server 'source' (x.x.x.x.) with non-zero exit code.
command: MYSQL_PWD="$(cat)" mysqldump --no-defaults -h localhost -P 3306 -uadmin --quick --quote-names --add-drop-table --default-character-set=utf8 --set-charset --routines --events XXX > /root/plesk_migrator/plesk_migrator-yyy/db-dumps/xxx.sql
exit code: 2
stdout:
stderr: mysqldump: Couldn't execute 'show events': Cannot proceed, because event scheduler is disabled (1577)

can you help me ?
 
Enable the event_scheduler using the following steps:

Create a backup of MySQL configuration file:

# cp -a /etc/my.ini{,.bak}

Open my.ini or my.cnf with a text editor.

Add the following records under the [mysqld] section:

event_scheduler=ON

Restart MySQL service:

# service mysql restart
 
Back
Top