This website is deprecated, and remains online only for historic access to old issues and docs for historic versions of Virtualmin. It has been unmaintained for several years, and should not be relied on for up-to-date information. Please visit www.virtualmin.com instead.

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