MySQL Forums
Forum List  »  Data Recovery

Re: Importing MYSQL DB Lock?
Posted by: Stacey Michelle
Date: August 30, 2014 05:33AM

When importing my_database_data.sql

LOCK the tables fully (even ignoring PRIMARY key counter checks)
INSERT all data (incl. primary keys)
Set the PRIMARY key counter back to what was saved
UNLOCK the tables again

Options: ReplyQuote


Subject
Views
Written By
Posted
2265
July 07, 2014 12:32PM
1244
July 07, 2014 12:34PM
1310
August 08, 2014 05:09AM
Re: Importing MYSQL DB Lock?
1213
August 30, 2014 05:33AM
1156
September 19, 2014 01:06AM


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.