Forums

Database back-up error

Permalink
Hi fellow C5 fans

When running the back-up, I get the following error message:

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 '-a-concr-1' at line 1] in EXECUTE("SHOW TABLES FROM web54-a-concr-1")

Does anyone know how to fix this?

Regards from a C5 newbie

Pete
peterfinch
 
chico replied on at Permalink Reply
Hi,

please look here
http://www.concrete5.org/community/forums/chat/back-up-error#97868/...

Regards

Jens
peterfinch replied on at Permalink Reply
peterfinch
Thanks Jens

Yes, the name of the database contains a hyphen. I'm not sure how to, or if I can, change the name of the database though. However, I have managed to back-up the database from my host control panel. If I was to delete the database, create a new one and restore the data to it, would C5 recognise it with the new name?

Also, there are two databases. Is this normal or is one perhaps from a previous installation and I've forgotten to delete it (perhaps further compounding the name problem)?

Thanks

Regards

Pete
chico replied on at Permalink Best Answer Reply
Hi Pete

if you can manage the database from your host control panel and you can import the back-up file to the database without errors it's o.k. If you can't rename the database, this is the only way to do a back-up as far as I know.
If you rename a database, you have to change the database-name in the file config/site.php line 5. If the user name and the password had changed too, change it in line 3 and 4.
C5 needs only one database.
Good luck

Regards
Jens
peterfinch replied on at Permalink Reply
peterfinch
Thanks Jen

I'll take a look at that tomorrow.

The other database must have been one I neglected to delete after a prior installation.

Thanks again for your support.

Regards

Pete