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
