- Plesk 12.5 for Linux
Note: This article has the reference to the issue with the fix available:
- #PMT-2366 "Stored MySQL procedures were not transferred."
- Plesk Migrator 30 November 2015
Routines (functions or procedures) in databases are not migrated during account migration in Plesk. The
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