List:General Discussion« Previous MessageNext Message »
From:Manasi Save Date:September 8 2010 10:27am
Subject:Re: mysqldump error 1064 for database Use command
View as plain text  
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
  > >  > >
  > >  > >
  > >  >
  > >  >
  > >
  > >
  >
  >

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