Errors when importing MySQL from UpdraftPlus
Posted: Fri Aug 20, 2021 4:42 am
I have been attempting to restore backups generated by the WordPress plugin UpdraftPlus.
When I do I get errors, no matter how I do it. This happens if I use Sequel Ace or phpMyAdmin or the command line.
Here's the full comms with UpdraftPlus: https://updraftplus.com/forums/topic/multiple-problems/
But the short version is that UpdraftPlus adds conditional comments in the backup and the version of MySQL that MAMP uses can't seem to handle those.
The folks at Updraft installed MAMP and tried it themselves, and got the same errors. They switched to another non-MAMP stack and did not get the errors.
Is there a known solution to this?
Note this does not seem to occur with phpMyAdmin-generated backups, or those generated by WP Migrate DB.
It looks like I'm running MySQL 5.7.32. I haven't changed this since I started working with MAMP Pro.
Thanks!
- Bob
When I do I get errors, no matter how I do it. This happens if I use Sequel Ace or phpMyAdmin or the command line.
Here's the full comms with UpdraftPlus: https://updraftplus.com/forums/topic/multiple-problems/
But the short version is that UpdraftPlus adds conditional comments in the backup and the version of MySQL that MAMP uses can't seem to handle those.
The folks at Updraft installed MAMP and tried it themselves, and got the same errors. They switched to another non-MAMP stack and did not get the errors.
Is there a known solution to this?
Note this does not seem to occur with phpMyAdmin-generated backups, or those generated by WP Migrate DB.
It looks like I'm running MySQL 5.7.32. I haven't changed this since I started working with MAMP Pro.
Thanks!
- Bob