Have you recently upgraded your MySQL installation? 1064 in earlier days used to
mean use of reserved word. Few clients have reported this error in last couple
of months after they upgraded from 5.1.41 to higher versions. As of now, I don't
have a solution other than changing the name (of database in your case).
Hope that helps.
From: Manasi Save <manasi.save@stripped>
To: "mysql@stripped" <mysql@stripped>
Sent: Sat, September 4, 2010 12:06:27 PM
Subject: mysqldump error 1064 for database Use command
I have 10 mysql databases all the tables use MyIsAm mysql storage engine.
Database names are 1,2,3,4,...10.
When I use mysqldump command with --all-databases option. This gives me
mysqldump -u myuser -p --all-databases > AllNew_Databases_20100904.sql
ERROR MESSAGE :-
mysqldump: Couldn't execute 'use 1': 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 '1' at line 1 (1064)
Can anyone provide any input on this. I have never got this error before. The
backups uptill now was happening properly. Please let me know if I am missing
out any information which should be provided to get more clear idea about this
Any input will be a great help.
Thanks in advance.