Re: Importing MYSQL DB Lock?
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
Subject
Views
Written By
Posted
2497
July 07, 2014 12:32PM
1393
July 07, 2014 12:34PM
1508
August 08, 2014 05:09AM
Re: Importing MYSQL DB Lock?
1338
August 30, 2014 05:33AM
1274
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.