Matt W mailto:[EMAIL PROTECTED]
on Monday, October 27, 2003 5:29 PM said:
As to why mysqldump would create a dump file with a syntax error in
it, that's because *you* (or the application creator) used a reserved
word for a column/index name (bad idea) and mysqldump
I always try to be
On Wed, 2003-10-29 at 14:18, Chris W. Parker wrote:
Matt W mailto:[EMAIL PROTECTED]
on Monday, October 27, 2003 5:29 PM said:
As to why mysqldump would create a dump file with a syntax error in
it, that's because *you* (or the application creator) used a reserved
word for a
Andy Bakun mailto:[EMAIL PROTECTED]
on Wednesday, October 29, 2003 12:27 PM said:
It may be best to always use the --quote-names option to mysqldump,
which would avoid any problems you might encounter with reserved words
being used in column and table names.
Already done. :)
Chris.
--
Hey everyone,
First post to the MySQL list so please be gentle.
I recently emptied some tables I shouldn't have in a db of mine and I
want to restore the data from a dump file made a few days ago.
MySQL version is 3.23.
This is the command I used to create the dump:
mysqldump --opt -u root
:
Subject: DB not restoring from dump
file
10/27/2003 01:45
---Original Message-
--From: Chris W. Parker [mailto:[EMAIL PROTECTED]
--Sent: Monday, October 27, 2003 10:46 AM
--To: [EMAIL PROTECTED]
--Subject: DB not restoring from dump file
--
--Hey everyone,
--
--First post to the MySQL list so please be gentle.
--
--
--I recently emptied some
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
on Monday, October 27, 2003 10:52 AM said:
can you send the contents of your dumpfile up to this point.
assuming its line 118 of hte dumpfile and 21 of this build table query
Line 118 is the beginning of the 'customers' table definition and line
Try changing the keyname unique to email.
SO:
UNIQUE KEY email (email)
---Original Message-
--From: Chris W. Parker [mailto:[EMAIL PROTECTED]
--Sent: Monday, October 27, 2003 11:04 AM
--To: [EMAIL PROTECTED]
--Cc: [EMAIL PROTECTED]
--Subject: RE: DB not restoring from dump file
Dathan Vance Pattishall mailto:[EMAIL PROTECTED]
on Monday, October 27, 2003 11:28 AM said:
Try changing the keyname unique to email.
UNIQUE KEY email (email)
Thanks, this worked.
I ended up having to change two more instances of the same error in
different tables.
Why would the
: Monday, October 27, 2003 1:32 PM
--To: Dathan Vance Pattishall; [EMAIL PROTECTED]
--Cc: [EMAIL PROTECTED]
--Subject: RE: DB not restoring from dump file
--
--Dathan Vance Pattishall mailto:[EMAIL PROTECTED]
--on Monday, October 27, 2003 11:28 AM said:
--
-- Try changing the keyname unique
- Original Message -
From: Dathan Vance Pattishall
Sent: Monday, October 27, 2003 4:02 PM
Subject: RE: DB not restoring from dump file
It dumps the contents of the db table in its original form. If you
upgrade to a new version-mysql will respect the old table format even if
some
11 matches
Mail list logo