Database backup error - help!
Permalink
Hi There
I've tried to run a backup on my client's website but the following error occurs:
The following errors occurred when attempting to process your request:
mysql error: [1064: 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 '-spadb22' at line 1] in EXECUTE("SHOW TABLES FROM web81-spadb22")
We're using version 5.4.2.2. so obviously want to update this, but really want to do a backup before hand.
Also are there any issues for upgrading from this to 5.4.1.1 I need to be aware of?
thanks
Louisa
I've tried to run a backup on my client's website but the following error occurs:
The following errors occurred when attempting to process your request:
mysql error: [1064: 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 '-spadb22' at line 1] in EXECUTE("SHOW TABLES FROM web81-spadb22")
We're using version 5.4.2.2. so obviously want to update this, but really want to do a backup before hand.
Also are there any issues for upgrading from this to 5.4.1.1 I need to be aware of?
thanks
Louisa
Looking at the core code, the '-' issue has been fixed in later versions of concrete5.
You can probably backup the database from phpMyAdmin, as per:
http://www.concrete5.org/documentation/how-tos/developers/backup-a-...
Backup Voodoo should also help because it escapes the table name, so I expect it would not run into the same mySQL issue you are getting with the concrete5 internal backup.
http://www.concrete5.org/marketplace/addons/backup-voodoo/...
Backup Voodoo is also great for cloning a site before moving it.