Title: [plugin Duplicator] DB query errors on restore
Last modified: September 1, 2016

---

# [plugin Duplicator] DB query errors on restore

 *  Resolved [anatoli](https://wordpress.org/support/users/anatoli/)
 * (@anatoli)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/plugin-duplicator-db-query-errors-on-restore/)
 * Hi, i’ve got a DB problem in restoring the site.
 * I’m using altervista.org host and at the end of the steps restore i’ve got this
   message:
 *     ```
       Queries that error during the deploy step are logged to the install-log.txt file and marked '**ERROR**'.
   
       Common Fixes:
       Query size limits: Update your MySQL server with the max_allowed_packet setting to handle larger payloads.
       Unknown collation: The MySQL Version is too old see: What is Compatibility mode & 'Unknown collation' errors?
       ```
   
 * I’ve searched a lot on internet about it but i’ve not found a solution. Is it
   a problem of my host (so i’ve to give up) or i can do something to solve it?
 * Thanks
 * [https://wordpress.org/plugins/duplicator/](https://wordpress.org/plugins/duplicator/)

Viewing 10 replies - 1 through 10 (of 10 total)

 *  [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * (@corylamleorg)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/plugin-duplicator-db-query-errors-on-restore/#post-7580730)
 * It could be… What version of MyServer is the host running?
 *  Thread Starter [anatoli](https://wordpress.org/support/users/anatoli/)
 * (@anatoli)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/plugin-duplicator-db-query-errors-on-restore/#post-7580748)
 * Hi Cory,
    Thanks for your reply.
 * I checked the MyServer version and i found the problem.
 * Is the utf8mb4 db chars code that is not supported by my host.
 * The upgrade to WP 4.5.3 did the damage :).
 * Maybe could be interesting add an option, in your amazing plugin, for retro-compatibility?
 * Anyway thanks a lot, after converted DB to utf8 the problem is gone.
    Thanks
 *  [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * (@corylamleorg)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/plugin-duplicator-db-query-errors-on-restore/#post-7580781)
 * Hey Anatoli,
 * When you create the package you can try the compatibility mode option on the 
   database tab. It may not fix your exact issue, but its worth a shot.
 * Cheers~
 *  Thread Starter [anatoli](https://wordpress.org/support/users/anatoli/)
 * (@anatoli)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/plugin-duplicator-db-query-errors-on-restore/#post-7580842)
 * Thanks Cory,
    i’m going to try your trick but i don’t find the option you’re 
   talking about.
 * Where i can find it?
 * I’m using Duplicator 1.1.14
 *  [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * (@corylamleorg)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/plugin-duplicator-db-query-errors-on-restore/#post-7580847)
 * Goto: Duplicator > Packages > Create New > Archive Section > Database Tab > Compatibility
   Mode
 * Thanks~
 *  Thread Starter [anatoli](https://wordpress.org/support/users/anatoli/)
 * (@anatoli)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/plugin-duplicator-db-query-errors-on-restore/#post-7580848)
 * Hi Cory,
    ok that’s the answer… “This option is only availbe with mysqldump mode.”
 * I’ve used it in “php mode” so no one checkbox are shown in Database Tab.
 * I’m going to try your trick.
 *  [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * (@corylamleorg)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/plugin-duplicator-db-query-errors-on-restore/#post-7580856)
 * Sounds Good! I would really try to work with your host to get the proper version
   of MySQL, that is going to be the proper solution.
 * Thanks
 *  Thread Starter [anatoli](https://wordpress.org/support/users/anatoli/)
 * (@anatoli)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/plugin-duplicator-db-query-errors-on-restore/#post-7580857)
 * Great!
    If you find something, please let me know.
 * Thanks a lot.
 *  [Cory Lamle](https://wordpress.org/support/users/corylamleorg/)
 * (@corylamleorg)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/plugin-duplicator-db-query-errors-on-restore/#post-7580865)
 * At this point you may have to try some manual procedures, there are a few that
   you can [try here](https://wordpress.org/support/topic/duplicator-creates-a-new-install-not-a-duplicate?replies=18#post-6960005).
 *  [bnk73](https://wordpress.org/support/users/bnk73/)
 * (@bnk73)
 * [9 years, 6 months ago](https://wordpress.org/support/topic/plugin-duplicator-db-query-errors-on-restore/#post-8474926)
 * Hi Cory,
 * I use ServerPress (base on XAMPP) on Mac.
 * I go on /wp-admin/admin.php?page=duplicator&tab=new1
    Then on database tab : 
   Compatibility Mode [details] This option is only availbe with mysqldump mode
 * -> is there any “tutorial for dummy” to use that mode on Mac !?
 * My global problem is the host has an older version of MySQL than my local server
   has. I tried several things, no success so far.
 * Thanks for your help

Viewing 10 replies - 1 through 10 (of 10 total)

The topic ‘[plugin Duplicator] DB query errors on restore’ is closed to new replies.

 * ![](https://ps.w.org/duplicator/assets/icon-256x256.png?rev=2906985)
 * [Duplicator - Backups & Migration Plugin - Cloud Backups, Scheduled Backups, & More](https://wordpress.org/plugins/duplicator/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/duplicator/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/duplicator/)
 * [Active Topics](https://wordpress.org/support/plugin/duplicator/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/duplicator/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/duplicator/reviews/)

 * 10 replies
 * 3 participants
 * Last reply from: [bnk73](https://wordpress.org/support/users/bnk73/)
 * Last activity: [9 years, 6 months ago](https://wordpress.org/support/topic/plugin-duplicator-db-query-errors-on-restore/#post-8474926)
 * Status: resolved