• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

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