Re: mysqldump error 1064 for database Use command
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 To: win.a Cc: "mysql@lists.mysql.com" 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 > 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 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: jang...@yahoo.com > > > > > Skype: jangita | GTalk: jangita.nyag...@gmail.com > > > > > > > > > > -- > > > > > MySQL General Mailing List > > > > > For list archives: http://lists.mysql.com/mysql > > > > > To unsubscribe: > > > > http://lists.mysql.com/mysql?unsub=manasi.s...@artificialmachines.com > > > > > > > > > > > > > > > > > > > > > > -- > > > > MySQL General Mailing List > > > > For list archives: http://lists.mysql.com/mysql > > > > To unsubscribe: http://lists.mysql.com/mysql?unsub=win@gmail.com > > > > > > > > > > > > > > > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=ntn...@yahoo.com
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 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: jang...@yahoo.com > > > > > Skype: jangita | GTalk: jangita.nyag...@gmail.com > > > > > > > > > > -- > > > > > MySQL General Mailing List > > > > > For list archives: http://lists.mysql.com/mysql > > > > > To unsubscribe: > > > > http://lists.mysql.com/mysql?unsub=manasi.s...@artificialmachines.com > > > > > > > > > > > > > > > > > > > > > > -- > > > > MySQL General Mailing List > > > > For list archives: http://lists.mysql.com/mysql > > > > To unsubscribe: http://lists.mysql.com/mysql?unsub=win@gmail.com > > > > > > > > > > > > > > > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.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: jang...@yahoo.com > Skype: jangita | GTalk: jangita.nyag...@gmail.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=manasi.s...@artificialmachines.com > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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: jang...@yahoo.com Skype: jangita | GTalk: jangita.nyag...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: mysqldump error 1064 for database Use command
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 PMSubject: mysqldump error 1064 for database Use commandHi 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
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
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
- Original Message - From: "David & Angela Ehmer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, January 04, 2003 11:00 PM Subject: mysqldump ERROR 1064 > Hi > > I am having problems generating the mysqldump file. I have tried a range of > options and carefully studied several tutorials I have on using this > command. Each time I get the following errror. > > ERROR 1064 you have an error in your SQL syntax near 'mysqldump -u root -p > adrienne netno_db >sql.dump' at line 1. > > I appear to have other problems with some commands. For example if I type; > > mysqladmin --help > > at the command line I get the 1064 ERROR > > Appreciate any suggestions about what may be the problem here > > David > It looks like you're trying to run the mysqldump and mysqladmin commands from within the mysql client rather than from the shell's command line. Quit out of the mysql client and try running them from the command line. And when you specify the -p password on the command line, do not include a space between the -p and the password. Try instead: mysqldump -u root -padrienne netno_db >sql.dump Best regards, Bruce - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqldump ERROR 1064
On Sun, 2003-01-05 at 00:00, David & Angela Ehmer wrote: > Hi > > I am having problems generating the mysqldump file. I have tried a range of > options and carefully studied several tutorials I have on using this > command. Each time I get the following errror. > > ERROR 1064 you have an error in your SQL syntax near 'mysqldump -u root -p > adrienne netno_db >sql.dump' at line 1. > Don't have a space between p and password it should be as : mysqldump -u root -padrienne netno-db > sql.dump - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqldump ERROR 1064
Hi I am having problems generating the mysqldump file. I have tried a range of options and carefully studied several tutorials I have on using this command. Each time I get the following errror. ERROR 1064 you have an error in your SQL syntax near 'mysqldump -u root -p adrienne netno_db >sql.dump' at line 1. I appear to have other problems with some commands. For example if I type; mysqladmin --help at the command line I get the 1064 ERROR Appreciate any suggestions about what may be the problem here David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php