Dear Nitin,
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
To: "mysql@stripped"
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
Attachment: [text/html] HTML Version of Message
Attachment: [text/html] HTML Version of Message
