2

I am going to migrate a LAMP server tonight, it uses php and mysql with apache on centos. I want to stop people from accessing the site/database while I back it up. Will stopping httpd be a sufficient way to stop people from accessing the DB, and will I be able to do mysqldump during this time? There are no other DB connectors that connect to this mysql other than the php running as an apache mod.

2

Just issue a:

mysql> FLUSH TABLES WITH READ LOCK;

Then back up your database.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy