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 <manasi.s...@artificialmachines.com> To: win.a <win....@gmail.com> Cc: "mysql@lists.mysql.com" <mysql@lists.mysql.com> Sent: Wed, September 8, 2010 3:57:40 PM Subject: Re: mysqldump 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 . > mysqldump -uroot -p --al-databases >AllNew_Databases_20100904.sql > > All you best > ------------------------ > What we are struggling for ? > The life or the life ? > > > > > On Mon, Sep 6, 2010 at 8:33 PM, Manasi Save > <manasi.s...@artificialmachines.com> wrote: > > Hi win.a, > > > > How am I suppose put that command. Could you help me with the syntax: > > > > If I am giving it this way:- > > mysqldump --all-databases > AllNew_Databases_20100904.sql > > > > then it says it will not work with my system user. > > > > nor with this it is working :- > > > > mysqldump -u --all-databases > AllNew_Databases_20100904.sql > > > > -- > > Regards, > > Manasi Save > > > > On Mon, 6 Sep 2010 20:12:26 0800, "win.a" wrote: > > try it without username and password in command line,type it it prompts. > > > > > > > All you best > > > ------------------------ > > > What we are struggling for ? > > > The life or the life ? > > > > > > > > > > > > > > > On Mon, Sep 6, 2010 at 3:28 PM, Manasi Save > > > <manasi.s...@artificialmachines.com> wrote: > > > > 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. > > > > > > > > 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 > > > > > > > > > > > Does it work when you dump only the database `1`? > > > > > > > > > > -- > > > > > Jangita | 256 76 91 8383 | Y! & MSN: jang...@yahoo.com > > > > > Skype: jangita | GTalk: jangita.nyag...@gmail.com > > > > > > > > > > -- > > > > > MySQL General Mailing List > > > > > For list archives: http://lists.mysql.com/mysql > > > > > To unsubscribe: > > > > http://lists.mysql.com/mysql?unsub=manasi.s...@artificialmachines.com > > > > > > > > > > > > > > > > > > > > > > -- > > > > MySQL General Mailing List > > > > For list archives: http://lists.mysql.com/mysql > > > > To unsubscribe: http://lists.mysql.com/mysql?unsub=win....@gmail.com > > > > > > > > > > > > > > > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=ntn...@yahoo.com