mysqldump error 1064 for database Use command

--=_3ynhl8us2kn4
Content-Type: text/plain;
charset=UTF-8
Content-Description: Plaintext Version of Message
Content-Disposition: inline
Content-Transfer-Encoding: 7bit

Hi All,

I have 10 mysql databases all the tables use MyIsAm mysql storage engine.
Database names are 1,2,3,4,...10.

When I use mysqldump command with --all-databases option. This gives me following error:

mysqldump -u myuser -p --all-databases > AllNew_Databases_20100904.sql

ERROR MESSAGE :-

mysqldump: Couldn't execute 'use 1': You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1' at line 1 (1064)

Can anyone provide any input on this. I have never got this error before. The backups uptill now was happening properly. Please let me know if I am missing out any information which should be provided to get more clear idea about this error.

Any input will be a great help.

Thanks in advance.
--
Regards,
Manasi Save


--=_3ynhl8us2kn4
Content-Type: multipart/related;
boundary="=_4558puanfojk";
start="4568ip1zoxz4@mail.artificialmachines.com"
Content-Transfer-Encoding: 7bit

This message is in MIME format.

--=_4558puanfojk
Content-Type: text/html;
charset=UTF-8
Content-Description: HTML Version of Message
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
Content-ID: 4568ip1zoxz4@mail.artificialmachines.com

Hi All,

 

I have 10 mysql databases all the tables use MyIsAm mysql storage
engine. 

Database names are 1,2,3,4,...10.

 

When I use mysqldump command with --all-databases option. This gives me
following error:

 

mysqldump -u myuser -p --all-databases > AllNew_Databases_20100904.sql

 

ERROR MESSAGE :-

 

mysqldump: Couldn't execute 'use 1': You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right syntax to
use near '1' at line 1 (1064)

 

Can anyone provide any input on this. I have never got this error before. The
backups uptill now was happening properly. Please let me know if I am missing
out any information which should be provided to get more clear idea about this
error.

 

Any input will be a great help. 

 

Thanks in advance.
--

Regards,
Manasi Save



--=_4558puanfojk--

--=_3ynhl8us2kn4--

Re: mysqldump error 1064 for database Use command

--0-457758782-1283659222=:77339
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi, Have you recently upgraded your MySQL installation? 1064 in earlie=
r days used to =0Amean use of reserved word. Few clients have reported this=
error in last couple =0Aof months after they upgraded from 5.1.41 to highe=
r versions. As of now, I don't =0Ahave a solution other than changing the n=
ame (of database in your case). Hope that helps. Regards,=0ANitin=
=0A________________________________=0AFrom: Manasi Save ..save@artificialmachines.com>=0ATo: "mysql@lists.mysql.com" sql.com>=0ASent: Sat, September 4, 2010 12:06:27 PM=0ASubject: mysqldump er=
ror 1064 for database Use command Hi All,  =0AI have 10 mysql data=
bases all the tables use MyIsAm mysql storage engine.  Database names a=
re 1,2,3,4,...10.  =0AWhen I use mysqldump command with --all-databases=
option. This gives me =0Afollowing error:  =0Amysqldump -u myuser -p -=
-all-databases > AllNew_Databases_20100904.sql  =0AERROR MESSAGE :-=0A=
  mysqldump: Couldn't execute 'use 1': You have an error in your SQL sy=
ntax; check =0Athe manual that corresponds to your MySQL server version for=
the right syntax to =0Ause near '1' at line 1 (1064)  =0ACan anyone pr=
ovide any input on this. I have never got this error before. The =0Abackups=
uptill now was happening properly. Please let me know if I am missing =0Ao=
ut any information which should be provided to get more clear idea about th=
is =0Aerror.  =0AAny input will be a great help.    Thanks in a=
dvance.=0A--=0ARegards,=0AManasi Save =0A
--0-457758782-1283659222=:77339--

Re: mysqldump error 1064 for database Use command

--=_4ujlwjk3xd6o
Content-Type: text/plain;
charset=UTF-8;
format="flowed"
Content-Description: Plaintext Version of Message
Content-Disposition: inline
Content-Transfer-Encoding: 7bit

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

On Sat, 4 Sep 2010 21:00:22 -0700 (PDT), Nitin Mehta wrote:

Hi,

Have you recently upgraded your MySQL installation? 1064 in earlier
days used to mean use of reserved word. Few clients have reported this
error in last couple of months after they upgraded from 5.1.41 to
higher versions. As of now, I don't have a solution other than changing
the name (of database in your case).

Hope that helps.

Regards,
Nitin

-------------------------
From: Manasi Save
To: "mysql@lists.mysql.com"
Sent: Sat, September 4, 2010 12:06:27 PM
Subject: mysqldump error 1064 for database Use command

Hi All,

I have 10 mysql databases all the tables use MyIsAm mysql storage engine.
Database names are 1,2,3,4,...10.

When I use mysqldump command with --all-databases option. This gives me
following error:

mysqldump -u myuser -p --all-databases > AllNew_Databases_20100904.sql

ERROR MESSAGE :-

mysqldump: Couldn't execute 'use 1': You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use near '1' at line 1 (1064)

Can anyone provide any input on this. I have never got this error
before. The backups uptill now was happening properly. Please let me
know if I am missing out any information which should be provided to
get more clear idea about this error.

Any input will be a great help.

Thanks in advance.
--
Regards,
Manasi Save



--=_4ujlwjk3xd6o
Content-Type: multipart/related;
boundary="=_6vxa299x1hj4";
start="6vyba5ly0s1s@mail.artificialmachines.com"
Content-Transfer-Encoding: 7bit

This message is in MIME format.

--=_6vxa299x1hj4
Content-Type: text/html;
charset=UTF-8
Content-Description: HTML Version of Message
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
Content-ID: 6vyba5ly0s1s@mail.artificialmachines.com

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



On Sat, 4 Sep 2010 21:00:22 -0700 (PDT), Nitin Mehta wrote:

Hi,

 

Have you recently upgraded your MySQL installation? 1064 in earlier days
used to mean use of reserved word. Few clients have reported this error in last
couple of months after they upgraded from 5.1.41 to higher versions. As of now,
I don't have a solution other than changing the name (of database in your
case).

 

Hope that helps.

 

Regards,

Nitin

---

From: Manasi Save
<manasi.save@artificialmachines.com>
style="font-weight: bold;">To: "mysql@lists.mysql.com"
<mysql@lists.mysql.com>
Sent: Sat, September 4, 2010 12:06:27 PM />Subject: mysqldump
error 1064 for database Use command

Hi All,
 
I
have 10 mysql databases all the tables use MyIsAm mysql storage engine.  />Database names are 1,2,3,4,...10.
 
When I use mysqldump
command with --all-databases option. This gives me following error: /> 
mysqldump -u myuser -p --all-databases >
AllNew_Databases_20100904.sql
 
ERROR MESSAGE :-
  />mysqldump: Couldn't execute 'use 1': You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the right
syntax to use near '1' at line 1 (1064)
 
Can anyone provide any
input on this. I have never got this error before. The backups uptill now was
happening properly. Please let me know if I am missing out any information which
should be provided to get more clear idea about this error.
 
Any
input will be a great help. 
 
Thanks in advance.
-- />Regards,
Manasi Save

Re: mysqldump error 1064 for database Use command

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@yahoo.com
Skype: jangita | GTalk: jangita.nyagudi@gmail.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: mysqldump error 1064 for database Use command

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@yahoo.com
> Skype: jangita | GTalk: jangita.nyagudi@gmail.com
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=manasi.save@artificialmac hines.com
>
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

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
> 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
> >  > 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  wrot=
e:
> >  > > On 06/09/2010 6:54 a, Manasi Save wrote:
> >  > >  > > Dear Nitin,
> >  > >  > >
> >  > >  > > I have newly installed mysql on this server. =C2=
=A0> >
> >  > >  > > mysql> Select version();
> >  > >  > >  -----------------------------
> >  > >  > > | version() |
> >  > >  > >  -----------------------------
> >  > >  > > | 5.1.22-rc-Debian_2~ppa5-log |
> >  > >  > >  -----------------------------
> >  > >  > >
> >  > >  > > Earlier I use to run the same command on Fedora-w=
ith
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@=
yahoo.com
> >  > >  > Skype: jangita | GTalk: jangita.nyagudi@gmail.com
> >  > >  >
> >  > >  > --
> >  > >  > MySQL General Mailing List
> >  > >  > For list archives: http://lists.mysql.com/mysql
> >  > >  > To unsubscribe:
> >  > >
 http://lists.mysql.com/mysql?unsub=3Dmanasi.save@artif icialmachines.c=
om
> >  > >  >
> >  > >  >
> >  > >
> >  > >
> >  > > --
> >  > > MySQL General Mailing List
> >  > > For list archives: http://lists.mysql.com/mysql
> >  > > To unsubscribe:  
 http://lists.mysql.com/mysql?unsub=3Dwin.acc@gmail.com
> >  > >
> >  > >
> >  >
> >  >
> >
> >
>
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: mysqldump error 1064 for database Use command

--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. =0ARegards,=0ANitin =0A=
________________________________=0AFrom: Manasi Save lmachines.com>=0ATo: win.a =0ACc: "mysql@lists.mysql.com=
" =0ASent: Wed, September 8, 2010 3:57:40 PM=0ASubje=
ct: Re: mysqldump error 1064 for database Use command Hi win.a,  =
=0AI tried with another user the problem still persists. I am getting same=
=0Aerror for another user as well. --=0ARegards,=0AManasi Save On=
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> icialmachines.com> 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> achines.com> 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@yahoo.com=0A> > =A0> >=
=A0> Skype: jangita | GTalk: jangita.nyagudi@gmail.com=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> >  http://lists.mysql.com/mysql?unsub=
=3Dmanasi.save@artificialmachines.com=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:   =A0http://lists.mysql.com/mysql?unsub=3Dwin.ac=
c@gmail.com=0A> > =A0> >=0A> > =A0> >=0A> > =A0>=0A> > =A0>=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@yahoo.com =0A
--0-1422836524-1283959329=:22413--