Issue Plesk Migration tool does not backup MySQL views

Discussion in 'Plesk Suggestions and Feedback' started by Tozz, Feb 16, 2017 at 7:06 AM.

  1. Tozz

    Tozz Regular Pleskian

    16
    35%
    Messages:
    167
    Likes Received:
    3
    Trophy Points:
    227
    Location:
    Netherlands
    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.
     
  2. Alina Dmi

    Alina Dmi Plesk Team Plesk Team

    7
    60%
    Messages:
    34
    Likes Received:
    4
    Trophy Points:
    76
    Hello!
    Thank you for your clear, full report!
    I was not able to reproduce your problem on our testing environment: I`ve successfully migrated database with several views between 12.5 and Onyx. Also, Plesk Migrator uses --routines parameter(if source mysqldump supports this option) and creates dumps under admin and as I see from your message, your mysqldump on source supports this option. So, please, provide ssh access to your source and target servers in private conversation(if it possible) or create support ticket, we`ll investigate the problem.
     

Share This Page

Loading...