RE: DB not restoring from dump file

2003-10-29 Thread Chris W. Parker
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

RE: DB not restoring from dump file

2003-10-29 Thread Andy Bakun
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

RE: DB not restoring from dump file

2003-10-29 Thread Chris W. Parker
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. --

DB not restoring from dump file

2003-10-27 Thread Chris W. Parker
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

Re: DB not restoring from dump file

2003-10-27 Thread jeffrey_n_Dyke
: Subject: DB not restoring from dump file 10/27/2003 01:45

RE: DB not restoring from dump file

2003-10-27 Thread Dathan Vance Pattishall
---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

RE: DB not restoring from dump file

2003-10-27 Thread Chris W. Parker
[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

RE: DB not restoring from dump file

2003-10-27 Thread Dathan Vance Pattishall
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

RE: DB not restoring from dump file

2003-10-27 Thread Chris W. Parker
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

RE: DB not restoring from dump file

2003-10-27 Thread Dathan Vance Pattishall
: 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

Re: DB not restoring from dump file

2003-10-27 Thread Matt W
- 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