From: Nitin Mehta Date: September 8 2010 3:22pm Subject: Re: mysqldump error 1064 for database Use command List-Archive: http://lists.mysql.com/mysql/222885 Message-Id: <472303.22413.qm@web57001.mail.re3.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1422836524-1283959329=:22413" --0-1422836524-1283959329=:22413 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable I'm not sure but you might try with sql_mode set to ANSI. Otherwise try the= dump =0Aremotely from a Linux box.=0A=0A=0ARegards,=0ANitin=0A=0A=0A=0A=0A= ________________________________=0AFrom: Manasi Save =0ATo: win.a =0ACc: "mysql@stripped= " =0ASent: Wed, September 8, 2010 3:57:40 PM=0ASubje= ct: Re: mysqldump error 1064 for database Use command=0A=0AHi win.a,=0A=A0= =0AI tried with another user the problem still persists. I am getting same= =0Aerror for another user as well.=0A=0A--=0ARegards,=0AManasi Save=0A=0AOn= Tue, 7 Sep 2010 11:41:35=A0 0800, "win.a"=A0 wrote:=0Ause another user and= dump the data ,eg the root .=0A> mysqldump -uroot -p --al-databases=A0 >Al= lNew_Databases_20100904.sql=0A>=0A> All you best=0A> ----------------------= --=0A> What we are struggling for ?=0A> The life or the life ?=0A>=0A>=0A>= =0A>=0A> On Mon, Sep 6, 2010 at 8:33 PM, Manasi Save=0A> wrote:=0A> > Hi win.a,=0A> >=0A> > How am I suppose put = that command. Could you help me with the syntax:=0A> >=0A> > If I am giving= it this way:-=0A> > mysqldump --all-databases >=A0AllNew_Databases_2010090= 4.sql=0A> >=0A> > then it says it will not work with my system user.=0A> >= =0A> > nor with this it is working :-=0A> >=0A> > mysqldump -u --all-databa= ses >=A0AllNew_Databases_20100904.sql=0A> >=0A> > =A0--=0A> > Regards,=0A> = > =A0Manasi Save=0A> >=0A> > On Mon, 6 Sep 2010 20:12:26 =A00800, "win.a" = =A0wrote:=0A> > try it without username and password in command line,type i= t it=0Aprompts. =A0>=0A> > =A0>=0A> > =A0> All you best=0A> > =A0> --------= ----------------=0A> > =A0> What we are struggling for ?=0A> > =A0> The lif= e or the life ?=0A> > =A0>=0A> > =A0>=0A> > =A0>=0A> > =A0>=0A> > =A0> On M= on, Sep 6, 2010 at 3:28 PM, Manasi Save=0A> > =A0> wrote:=0A> > =A0> > No it does not. But when I dump database n= ame "mydb" it=0Adoes. but not=0A> > the=0A> > =A0> > database with name "1"= . =A0> > =A0--=0A> > =A0> > Regards,=0A> > =A0> > =A0Manasi Save=0A> > =A0>= >=0A> > =A0> > On Mon, 06 Sep 2010 09:23:21 =A00200, Jangita =A0wrote:=0A>= > =A0> > On 06/09/2010 6:54 a, Manasi Save wrote:=0A> > =A0> > =A0> > Dear= Nitin,=0A> > =A0> > =A0> >=0A> > =A0> > =A0> > I have newly installed mysq= l on this server. =A0> >=0A> > =A0> > =A0> > mysql> Select version();=0A> >= =A0> > =A0> > =A0-----------------------------=0A> > =A0> > =A0> > | versi= on() |=0A> > =A0> > =A0> > =A0-----------------------------=0A> > =A0> > = =A0> > | 5.1.22-rc-Debian_2~ppa5-log |=0A> > =A0> > =A0> > =A0-------------= ----------------=0A> > =A0> > =A0> >=0A> > =A0> > =A0> > Earlier I use to r= un the same command on Fedora-with=0Asame mysql=0A> > =A0> > version. =A0> = > I could not possibly change the database=0Aname. There are=0A> > quite=0A= > > =A0> > a few=0A> > =A0> > =A0> > databases I have on the system. =A0> >= =0A> > =A0> > =A0> > --=0A> > =A0> > =A0> > Regards,=0A> > =A0> > =A0> > Ma= nasi Save=0A> > =A0> > =A0> >=0A> > =A0> > =A0> Does it work when you dump = only the database `1`?=0A> > =A0> > =A0>=0A> > =A0> > =A0> --=0A> > =A0> > = =A0> Jangita | =A0256 76 91 8383 | Y! & MSN: jangita@stripped=0A> > =A0> >= =A0> Skype: jangita | GTalk: jangita.nyagudi@stripped=0A> > =A0> > =A0>= =0A> > =A0> > =A0> --=0A> > =A0> > =A0> MySQL General Mailing List=0A> > = =A0> > =A0> For list archives: http://lists.mysql.com/mysql=0A> > =A0> > = =A0> To unsubscribe:=0A> > =A0> >=0A=A0http://lists.mysql.com/mysql?unsub= =3Dmanasi.save@stripped=0A> > =A0> > =A0>=0A> > =A0> > =A0>= =0A> > =A0> >=0A> > =A0> >=0A> > =A0> > --=0A> > =A0> > MySQL General Maili= ng List=0A> > =A0> > For list archives: http://lists.mysql.com/mysql=0A> > = =A0> > To unsubscribe: =A0=0A=A0http://lists.mysql.com/mysql?unsub=3Dwin.ac= c@stripped=0A> > =A0> >=0A> > =A0> >=0A> > =A0>=0A> > =A0>=0A> >=0A> >=0A>= =0A>=0A=0A=0A--=0AMySQL General Mailing List=0AFor list archives: http://li= sts.mysql.com/mysql=0ATo unsubscribe:=A0 =A0 http://lists.mysql.com/mysql?u= nsub=3Dntnmht@stripped=0A=0A=0A --0-1422836524-1283959329=:22413--