Re: mysqldump error 1064 for database Use command

2010-09-08 Thread Nitin Mehta
dump error 1064 for database Use command 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 . &

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
name (of database in your case). Hope that helps. Regards, Nitin From: Manasi Save To: "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

mysqldump error 1064 for database Use command

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