Title: Error restoring tables using migrate Last modified: August 21, 2016 --- # Error restoring tables using migrate * Resolved [robansell](https://wordpress.org/support/users/robansell/) * (@robansell) * [12 years, 10 months ago](https://wordpress.org/support/topic/error-restoring-tables-using-migrate/) * Hi There * Yesterday I bought your migration tool, and have tried to use it twice without success. When doing the restore, I am getting 31 errors relating to the syntax of the SQL. * There errors all look more or less the same, so I am just posting one here for you to have a look at and advise. Here it is : * Restoring table: wp_site An error (25) occured: – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘PAGE_CHECKSUM=1’ at line 1 – the database query being run was: CREATE TABLE `wp_site` ( `id` bigint(20) NOT NULL AUTO_INCREMENT,` domain` varchar(200) NOT NULL DEFAULT ”, `path` varchar(100) NOT NULL DEFAULT”, PRIMARY KEY (`id`), KEY `domain` (`domain`,`path`)) ENGINE=Aria AUTO_INCREMENT =2 DEFAULT CHARSET=utf8 PAGE_CHECKSUM=1 ; An error (26) occured: – Table ‘robansell11. wp_site’ doesn’t exist – the database query being run was: INSERT INTO `wp_site` VALUES (1, ‘bidnstay.co.za’, ‘/’); * I look forward to hearing back from you. Regards Rob * [http://wordpress.org/extend/plugins/updraftplus/](http://wordpress.org/extend/plugins/updraftplus/) Viewing 12 replies - 1 through 12 (of 12 total) * Plugin Author [David Anderson / Team Updraft](https://wordpress.org/support/users/davidanderson/) * (@davidanderson) * [12 years, 10 months ago](https://wordpress.org/support/topic/error-restoring-tables-using-migrate/#post-3897722) * Hi Rob, * Thanks for the purchase! * The problem is that the MySQL server on the ‘old’ site hosting is producing output that is not accepted by the MySQL server on the ‘new’ side. i.e. They either they are different versions, and sufficiently different that their output is mutually incompatible, or they are similar versions but (I think this is more likely, looking at your info) the ‘new’ side has functionality missing that the‘ old’ side was using. * This is easily fixable, so don’t worry! We may just need a few goes to find out exactly which bit it does not like. * Firstly – are you able to find out the MySQL versions on both sides? In UpdraftPlus, scroll down to the “Show expert settings” link, and click it. Then scroll down again, and find the “show PHP information (phpinfo)” link and click that. In the dialog that opens, search for “Client API library version”, and note the version number. Do this on both ‘old’ and ‘new’ sites. This information will help us to automate the next step for the future. * Secondly, to fix the actual problem. The db.gz file that is your database backup needs to have a search-and-replace done upon it by hand. Either email it to us, or * 1) decompress it (using [http://7-zip.org](http://7-zip.org)) open it up in a text editor. * 2) experiment with editing (via search-and-replace) every CREATE TABLE statement( it sounds like there are 21). This will be the problematic bit: * ENGINE=Aria AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 PAGE_CHECKSUM=1; * Likely problems are that: i) Your new server supports TYPE=Aria instead of ENGINE =Aria. ii) Your new server does not have the Aria engine at all – replace “ENGINE =Aria” with “Engine=MyISAM” and remove “PAGE_CHECKSUM=1”. * ii) is the much more likely one, as Aria is a not very widespread engine. So try that first unless you’re confident that your new server has the Aria engine. * Then, * 3) Re-compress the database file so that it is again a db.gz file. * 4) You can now use your altered file for the migration. * If you have any trouble, then just email the db.gz file to [contact@updraftplus.com](https://wordpress.org/support/topic/error-restoring-tables-using-migrate/contact@updraftplus.com?output_format=md), and we’ll alter it for you. * Best wishes, David * Thread Starter [robansell](https://wordpress.org/support/users/robansell/) * (@robansell) * [12 years, 10 months ago](https://wordpress.org/support/topic/error-restoring-tables-using-migrate/#post-3897727) * Hi David * Thanks for the comprehensive answer : * Old Client API library version : mysqlnd 5.0.10 – 20111026 – $Id: e707c415db32080b3752b232487a435ee0372157 $ New Client API library version : 5.1.66 * I have emailed the db.gz file to you to have a look at. * I will be needing to do this quite a bit in the next few weeks, so would really appreciate if we could automate the process. * Thanks and regards Rob * Plugin Author [David Anderson / Team Updraft](https://wordpress.org/support/users/davidanderson/) * (@davidanderson) * [12 years, 10 months ago](https://wordpress.org/support/topic/error-restoring-tables-using-migrate/#post-3897804) * Hi Rob, * I’ve emailed you now with the development version of UpdraftPlus + Migrator, which now handles this situation. The problem was the PAGE_CHECKSUM=1 part of the “CREATE TABLE” statement, which was not supported on your importing MySQL server. This is now detected + handled. * David * Thread Starter [robansell](https://wordpress.org/support/users/robansell/) * (@robansell) * [12 years, 10 months ago](https://wordpress.org/support/topic/error-restoring-tables-using-migrate/#post-3897840) * Thanks David * I still encountered a problem with the new plugin, but only 1 problem as apposed to the 31 problems that I had yesterday!! I have emailed you a copy of the error, and look forward to hearing back from you. * Regards Rob * Plugin Author [David Anderson / Team Updraft](https://wordpress.org/support/users/davidanderson/) * (@davidanderson) * [12 years, 10 months ago](https://wordpress.org/support/topic/error-restoring-tables-using-migrate/#post-3897841) * Hi Rob, * Thank you – that’s a slightly different, but related, problem. I’ve emailed you a new version – please let me know how you get on with it. * David * Thread Starter [robansell](https://wordpress.org/support/users/robansell/) * (@robansell) * [12 years, 10 months ago](https://wordpress.org/support/topic/error-restoring-tables-using-migrate/#post-3897842) * Hi David * Thanks – I have sent you another email. Getting better, but still having a problem! * Regards Rob * Thread Starter [robansell](https://wordpress.org/support/users/robansell/) * (@robansell) * [12 years, 10 months ago](https://wordpress.org/support/topic/error-restoring-tables-using-migrate/#post-3897900) * Hi David * Sent you another email this morning – still having issues – this time, with permalinks. I am pulling my hair out! * Regards Rob * Thread Starter [robansell](https://wordpress.org/support/users/robansell/) * (@robansell) * [12 years, 10 months ago](https://wordpress.org/support/topic/error-restoring-tables-using-migrate/#post-3897901) * HI David * I think I may have found the problem. Something to do with mod-rewrite on my server. Trying to turn it on now, and will try again! * Regards Rob * Plugin Author [David Anderson / Team Updraft](https://wordpress.org/support/users/davidanderson/) * (@davidanderson) * [12 years, 10 months ago](https://wordpress.org/support/topic/error-restoring-tables-using-migrate/#post-3897902) * Hi Rob, * Do let me know if you find out the cause, and the resolution, etc… even if it wasn’t a UD issue, it helps everyone (on our side, we get less support calls!) if we can detect + advise the user of what’s up and what to do. If you need me to log in, then please send details to [contact@updraftplus.com](https://wordpress.org/support/topic/error-restoring-tables-using-migrate/contact@updraftplus.com?output_format=md). * Best wishes, David * Thread Starter [robansell](https://wordpress.org/support/users/robansell/) * (@robansell) * [12 years, 10 months ago](https://wordpress.org/support/topic/error-restoring-tables-using-migrate/#post-3897903) * Hi David * I have fixed the problem with the permalinks. I had to enable mod_rewrite on my server which proved quite problematic, but I got there eventually! * So, everything is working now, with the exception of the images, and I have sent you a separate email about that. * Kind regards Rob * Thread Starter [robansell](https://wordpress.org/support/users/robansell/) * (@robansell) * [12 years, 10 months ago](https://wordpress.org/support/topic/error-restoring-tables-using-migrate/#post-3897904) * I found these articles useful in resolving my mod_rewrite issue : * [http://xmodulo.com/2013/01/how-to-enable-mod_rewrite-in-apache2-on-debian-ubuntu.html](http://xmodulo.com/2013/01/how-to-enable-mod_rewrite-in-apache2-on-debian-ubuntu.html) * [http://www.lavluda.com/2007/07/15/how-to-enable-mod_rewrite-in-apache22-debian/](http://www.lavluda.com/2007/07/15/how-to-enable-mod_rewrite-in-apache22-debian/) * Plugin Author [David Anderson / Team Updraft](https://wordpress.org/support/users/davidanderson/) * (@davidanderson) * [12 years, 10 months ago](https://wordpress.org/support/topic/error-restoring-tables-using-migrate/#post-3897910) * Hi Rob, * Glad you got it all fixed! * David Viewing 12 replies - 1 through 12 (of 12 total) The topic ‘Error restoring tables using migrate’ is closed to new replies. * ![](https://ps.w.org/updraftplus/assets/icon-256x256.jpg?rev=1686200) * [UpdraftPlus: WP Backup & Migration Plugin](https://wordpress.org/plugins/updraftplus/) * [Frequently Asked Questions](https://wordpress.org/plugins/updraftplus/#faq) * [Support Threads](https://wordpress.org/support/plugin/updraftplus/) * [Active Topics](https://wordpress.org/support/plugin/updraftplus/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/updraftplus/unresolved/) * [Reviews](https://wordpress.org/support/plugin/updraftplus/reviews/) * 12 replies * 2 participants * Last reply from: [David Anderson / Team Updraft](https://wordpress.org/support/users/davidanderson/) * Last activity: [12 years, 10 months ago](https://wordpress.org/support/topic/error-restoring-tables-using-migrate/#post-3897910) * Status: resolved