MySQL database backup question

In the MySQL Database Sever module in Webmin there is a backup feature. (Yeah!)

My question is how does this handle the dbs during the backup process? Does it lock them?

All database backup functionality in Webmin and Virtualmin uses the dump feature of the database. What that means with regard to locking, I don’t know. I’m going to assume that dump provides data integrity. At least, I would certainly hope so.

I hope so too! :slight_smile:

I will do a little research on dd and post what I find.

MySQL will pause any writes until the dump is done which usually takes a matter of seconds. MySQL does not lock for reads though.


Thanks Scott!