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
Subject
Views
Written By
Posted
2428
July 07, 2014 12:32PM
1356
July 07, 2014 12:34PM
1472
August 08, 2014 05:09AM
1311
August 30, 2014 05:33AM
Re: Importing MYSQL DB Lock?
1249
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.