Description
When migrating a website running Magento, the migrated website will not function as the migration proces does not dump MySQL views. We see this issue on some, but not all, Magento sites. It could be that views are not used by default in Magento or perhaps in just a module. However, views should be migrated regardless.
Version
Plesk Onyx on Debian Jessie with all updates for both Debian as Plesk installed.
How to reproduce?
1. Create a view in MySQL in a database belonging to a subscription.
2. Migrate the subscription to another server.
3. Notice that all your data in the MySQL database is migrated, except for the views
Expected result
I expect a 1:1 copy.
Fix
Plesk should dump databases with the --routines parameter in 'mysqldump'.
A manual dump with the --routines parameter solves the issue, so it seems Plesk does not include this parameter.
Notes:
Dumping routines required SELECT on mysql.proc, this probably means the dump should be done as the MySQL root user.
When migrating a website running Magento, the migrated website will not function as the migration proces does not dump MySQL views. We see this issue on some, but not all, Magento sites. It could be that views are not used by default in Magento or perhaps in just a module. However, views should be migrated regardless.
Version
Plesk Onyx on Debian Jessie with all updates for both Debian as Plesk installed.
How to reproduce?
1. Create a view in MySQL in a database belonging to a subscription.
2. Migrate the subscription to another server.
3. Notice that all your data in the MySQL database is migrated, except for the views
Expected result
I expect a 1:1 copy.
Fix
Plesk should dump databases with the --routines parameter in 'mysqldump'.
A manual dump with the --routines parameter solves the issue, so it seems Plesk does not include this parameter.
Notes:
Dumping routines required SELECT on mysql.proc, this probably means the dump should be done as the MySQL root user.