Re: mysqldump error 1064 for database Use command

2010-09-08 Thread Nitin Mehta
I'm not sure but you might try with sql_mode set to ANSI. Otherwise try the dump remotely from a Linux box. Regards, Nitin From: Manasi Save To: win.a Cc: "mysql@lists.mysql.com" Sent: Wed, September 8, 2010 3:57:40 PM Subject: Re: mysql

Re: mysqldump error 1064 for database Use command

2010-09-08 Thread Manasi Save
Hi win.a,   I tried with another user the problem still persists. I am getting same error for another user as well. -- Regards, Manasi Save On Tue, 7 Sep 2010 11:41:35 0800, "win.a" wrote: use another user and dump the data ,eg the root . > mysqldump -uroot -p --al-databases >AllNew_Databa

Re: mysqldump error 1064 for database Use command

2010-09-06 Thread Manasi Save
No it does not. But when I dump database name "mydb" it does. but not the database with name "1". -- Regards, Manasi Save On Mon, 06 Sep 2010 09:23:21 0200, Jangita wrote: On 06/09/2010 6:54 a, Manasi Save wrote: > > Dear Nitin, > > > > I have newly installed mysql on this server. > >

Re: mysqldump error 1064 for database Use command

2010-09-06 Thread Jangita
On 06/09/2010 6:54 a, Manasi Save wrote: 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

Re: mysqldump error 1064 for database Use command

2010-09-05 Thread Manasi Save
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-wi

Re: mysqldump error 1064 for database Use command

2010-09-04 Thread Nitin Mehta
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