Routines (functions or procedures) in databases are not migrated during account migration in Plesk. The
mysql.proc table is empty.
Routines are not migrated by default. Such a behavior has been considered as internal software issue with ID #PMT-2366 , which is fixed in Plesk Migrator version 0.1.12.
Install latest Plesk microupdates: Home > Install Plesk updates .
Create dump of the required database on the source server, including routines:
# mysqldump --routines -uadmin -p`cat /etc/psa/.psa.shadow` example > /root/example.sql
Restore the database on the target server:
# mysql -uadmin -p`cat /etc/psa/.psa.shadow` example < /root/example.sql