RE: DB not restoring from dump file

Andy Bakun 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.

RE: DB not restoring from dump file

On Wed, 2003-10-29 at 14:18, Chris W. Parker wrote: > Matt W > 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

RE: DB not restoring from dump file

Matt W 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 b

Re: DB not restoring from dump file

ing. :-( Matt - 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 tab

RE: DB not restoring from dump file

TECTED] -->Sent: 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 A

RE: DB not restoring from dump file

Dathan Vance Pattishall 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 m

RE: DB not restoring from dump file

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 restor

RE: DB not restoring from dump file

[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 l

RE: DB not restoring from dump file

-->-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 emp

Re: DB not restoring from dump file

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 Jeff