List:General Discussion« Previous MessageNext Message »
From:Nitin Mehta Date:September 8 2010 3:22pm
Subject:Re: mysqldump error 1064 for database Use command
View as plain text  
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.save@stripped>
To: win.a <win.acc@stripped>
Cc: "mysql@stripped" <mysql@stripped>
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.save@stripped> 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.save@stripped> 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:
jangita@stripped
> >  > >  > Skype: jangita | GTalk: jangita.nyagudi@stripped
> >  > >  >
> >  > >  > --
> >  > >  > MySQL General Mailing List
> >  > >  > For list archives: http://lists.mysql.com/mysql
> >  > >  > To unsubscribe:
> >  > >
 http://lists.mysql.com/mysql?unsub=1
> >  > >  >
> >  > >  >
> >  > >
> >  > >
> >  > > --
> >  > > MySQL General Mailing List
> >  > > For list archives: http://lists.mysql.com/mysql
> >  > > To unsubscribe:  
 http://lists.mysql.com/mysql?unsub=1
> >  > >
> >  > >
> >  >
> >  >
> >
> >
>
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1


      
Thread
mysqldump error 1064 for database Use commandManasi Save4 Sep
  • Re: mysqldump error 1064 for database Use commandNitin Mehta5 Sep
Re: mysqldump error 1064 for database Use commandManasi Save6 Sep
  • Re: mysqldump error 1064 for database Use commandJangita6 Sep
Re: mysqldump error 1064 for database Use commandManasi Save6 Sep
Re: mysqldump error 1064 for database Use commandManasi Save8 Sep
  • Re: mysqldump error 1064 for database Use commandNitin Mehta8 Sep