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
2274
July 07, 2014 12:32PM
1249
July 07, 2014 12:34PM
1318
August 08, 2014 05:09AM
1219
August 30, 2014 05:33AM
Re: Importing MYSQL DB Lock?
1163
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.