I have newly installed mysql on this server.
mysql> Select version();
+-----------------------------+
| version() |
+-----------------------------+
| 5.1.22-rc-Debian_2~ppa5-log |
+-----------------------------+
Earlier I use to run the same command on Fedora-with same mysql version. I could not possibly change the database name. There are quite a few databases I have on the system.
--
Regards,
Manasi Save
On Sat, 4 Sep 2010 21:00:22 -0700 (PDT), Nitin Mehta wrote:
Hi,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.Regards,Nitin
From: Manasi Save <manasi.s...@artificialmachines.com>
To: "mysql@lists.mysql.com" <mysql@lists.mysql.com>
Sent: Sat, September 4, 2010 12:06:27 PM
Subject: mysqldump error 1064 for database Use command
Hi All,
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 following error:
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 error.
Any input will be a great help.
Thanks in advance.
--
Regards,
Manasi Save
