MySQL Forums
Forum List  »  Backup

Re: mysqldump restore triggers error 1062
Posted by: David Mackintosh
Date: April 10, 2006 08:57AM

Okay...

This lets me import the database; however, I still have two questions:

1. When I dump the imported database back out, all my keys are shifted; ie instead of

INSERT INTO groups VALUES (0,'Administrators'),(1,'Anonymous'),(2,'File Admin'),(3,'Company');

...it says:

INSERT INTO groups VALUES (1,'Administrators'),(2,'Anonymous'),(3,'File Admin'),(4,'Company');

Is that going to be a problem if my group keys have all changed by one? Especially since no other tables have changed? (ie this, plus the server version, is the only line that is detected as a change when I diff the original dump and the dump of the restored database).

2. Is there some way to make mysqldump export the file in such a way that it will import back in cleanly? It seems wrong to have to mess with the dump file just to make it import again.



Edited 1 time(s). Last edit at 04/10/2006 09:11AM by David Mackintosh.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: mysqldump restore triggers error 1062
4255
April 10, 2006 08:57AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.