Backup fails with mySQL error message
Permalink
Dear all,
I'm using concrete 5 on a server of the German provider 1&1 (means with limited access to the system). In the past I could create new backups successfully but since a few weeks the backups fails and the system shows the following error message: "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 'Group' at line 1] in EXECUTE("SELECT * FROM Group")".
I'm not an expert but I have the impression that the problem is caused by the name of the table Group, which is a reserved expression for the mySQL database.
All updates of the concrete system are managed by the provider therefore I can't update to the most current version. Currently I'm using version 5.4.1.
Does anyone of you have any idea how I could solve this problem. I have to admit that I'm a newbie so I would appreciate very much if you could provide a documentation for dummies. ;-)
Thanks in advance!
Best regards,
Christian
I'm using concrete 5 on a server of the German provider 1&1 (means with limited access to the system). In the past I could create new backups successfully but since a few weeks the backups fails and the system shows the following error message: "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 'Group' at line 1] in EXECUTE("SELECT * FROM Group")".
I'm not an expert but I have the impression that the problem is caused by the name of the table Group, which is a reserved expression for the mySQL database.
All updates of the concrete system are managed by the provider therefore I can't update to the most current version. Currently I'm using version 5.4.1.
Does anyone of you have any idea how I could solve this problem. I have to admit that I'm a newbie so I would appreciate very much if you could provide a documentation for dummies. ;-)
Thanks in advance!
Best regards,
Christian
Have a look at
http://www.concrete5.org/documentation/how-tos/developers/backup-a-...
You may be able to backup through phpMyAdmin.
If you are really serious about backups, have a look at Backup Voodoo.
http://www.concrete5.org/marketplace/addons/backup-voodoo/...
If Backup Voodoo gives any issues with table names, open a support request and I will make sure it is fixed (though I have not had any issues with table names yet). Backup Voodoo is already in use on several 1&1 shared hosting accounts.