MySQL database backup question

5 posts / 0 new

Topic locked

Last post

#1 Tue, 06/10/2008 - 14:08

velvetpixel

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?

#2 Tue, 06/10/2008 - 14:15

Joe

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.

--

Check out the forum guidelines!

#3 Tue, 06/10/2008 - 14:26 (Reply to #2)

velvetpixel

I hope so too! :)

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

#4 Tue, 06/10/2008 - 22:23 (Reply to #3)

sgrayban

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 Tue, 06/10/2008 - 23:54 (Reply to #4)

velvetpixel

Excellent.

Thanks Scott!

Topic locked