When my server was running MySQL 4.1 I used mysqldump for backup with no
errors - Redhat Linux 9. In fact when the server crashed and I had to
restore the whole box I used the backups from mysqldump to restore all
the databases and tables including the users. However, the server is now
running
how it was resolved.
Rhino
- Original Message -
From: Rhino [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]; gerald_clark
[EMAIL PROTECTED]
Cc: mysql mysql@lists.mysql.com
Sent: Thursday, January 19, 2006 11:15 AM
Subject: Re: Error from mysqldump
Just as a followup to my own remarks
Hello.
If you switch to the debug binary of the mysqldump, you will be able to
find the query which causes 1064 error. See:
http://dev.mysql.com/doc/refman/5.0/en/debugging-client.html
Rhino wrote:
Just as a followup to my own remarks, I've tried running my backup
script with the new syntax
I have an automated backup script that has been running daily for a couple
of years now. It has never given me trouble until the last two days. For the
last two days, I have been getting this message when backing up my newest
database:
/usr/bin/mysqldump: Got error: 1064: You have an error
Rhino wrote:
I have an automated backup script that has been running daily for a
couple of years now. It has never given me trouble until the last two
days. For the last two days, I have been getting this message when
backing up my newest database:
/usr/bin/mysqldump: Got error: 1064: You
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]
Cc: mysql mysql@lists.mysql.com
Sent: Thursday, January 19, 2006 9:30 AM
Subject: Re: Error from mysqldump
Rhino wrote:
I have an automated backup script that has been running daily for a
couple
[EMAIL PROTECTED]
Cc: mysql mysql@lists.mysql.com
Sent: Thursday, January 19, 2006 10:53 AM
Subject: Re: Error from mysqldump
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]
Cc: mysql mysql@lists.mysql.com
Sent: Thursday, January 19, 2006 9:30 AM
Hello all,
When testing some of our Perl/DBI code, we made a couple of tables with
numeric names (e.g. test.1 test.2 etc), because the code we're making has to
be able to handle them correctly. It does, w/o any problem, but mysqldump
doesn't: I get a message mysqldump: Got error: 1064: You have
a message mysqldump: Got error: 1064: You have an error in
your SQL syntax near '1 READ /*!32311 LOCAL */' at line 1 when doing LOCK
TABLES while dumping test.1.
The syntax for mysqldump is:
mysqldump --quick --lock-tables --add-drop-table --user=root test
You also need the --quote-names option
: I get a message mysqldump: Got error: 1064: You have an error in
RL your SQL syntax near '1 READ /*!32311 LOCAL */' at line 1 when doing LOCK
RL TABLES while dumping test.1.
RL The syntax for mysqldump is:
RL mysqldump --quick --lock-tables --add-drop-table --user=root test
RL mysqldump Ver 8.14
10 matches
Mail list logo