Issue Migration & Transfer Manager - DB migration error

[cladem]

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 ?

 

[IgorG]

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