Is there a way to do this without locking the production database? I'm currently using: mysqldump -u root --password=xxx -h xxx my_db1 | mysql -u root ...
stackoverflow.com/questions/.../run-mysqldump-without-locking-tables - Cached - Similar
Sep 15, 2008 ... I am trying to delete several rows from a MySQL 5.0.45 database: delete from ... Lock wait timeout exceeded; try restarting transaction ...
stackoverflow.com/questions/.../mysql-lock-wait-timeout-exceeded - Cached - Similar
May 16, 2011 ... i was wondering if anyone knew how to lock a database, and then dequeue the waiting jobs. so i have a hashtable in a database, and im ...
stackoverflow.com/.../how-to-have-a-lock-on-a-mysql-database-and-dequeue -the-waiting-jobs - Cached - Similar