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: mysql
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_Databa
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.
> >
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
: "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 opt
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
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
- 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
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
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.du
10 matches
Mail list logo
