I use mysqldump for MySQL Backup.
mysqldump --lock-tables....
The DB is about 2GB, hence mysqldump takes a long time.
If anyone tries to access the DB during backup, I would like to flash a message saying "the DB is being backed-up, please return back after 10 minutes"
My questions is using PHP script, how can I check if mysql table is locked or not.
Thank you in advance.
Best regards,
Sanjay
解决方案
Prefer method will be setup replication,
and mysqldump on the slave instead on master (assuming only master is serving requests)
So, you never experiencing downtime