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? Quote Link to comment 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? Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.