calabiyau Posted February 19, 2007 Share Posted February 19, 2007 Is there a way to do this? I need to run a cron job that transfers database information from one database to another and it is very important that the primary keys don't get messed up. I know you can lock a table but is there a way to lock a whole database while running a long series of queries that go back and forth between multiple tables? Link to comment https://forums.phpfreaks.com/topic/39234-locking-a-whole-database-while-running-queries/ Share on other sites More sharing options...
calabiyau Posted February 19, 2007 Author Share Posted February 19, 2007 Okay I finally discovered GET_LOCK('$mydtb.mylock',10) I've been testing it at home, by running the script with the lock in it but not releasing the lock. Then I used a second script to try to access the same database and I am able to. Would the lock not stay in effect? Or does it end when the script ends? Link to comment https://forums.phpfreaks.com/topic/39234-locking-a-whole-database-while-running-queries/#findComment-189059 Share on other sites More sharing options...
skali Posted February 20, 2007 Share Posted February 20, 2007 The lock will release when you call RELEASE_LOCK(), call a new GET_LOCK() or your connection terminates. Link to comment https://forums.phpfreaks.com/topic/39234-locking-a-whole-database-while-running-queries/#findComment-189340 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.