MySQL database backup question

Webmin
1

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?

2

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.

3

I hope so too! :slight_smile:

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

4

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

5

Excellent.

Thanks Scott!