MySQL Forums
Forum List  »  Data Recovery

Re: Importing MYSQL DB Lock?
Posted by: Luke Taylor
Date: September 19, 2014 01:06AM

When importing my_database_data.sql do the following steps.

-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
2266
July 07, 2014 12:32PM
1244
July 07, 2014 12:34PM
1310
August 08, 2014 05:09AM
1214
August 30, 2014 05:33AM
Re: Importing MYSQL DB Lock?
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.