mysql dump question

[0ptima]

Is it OK to do do a mysql dump when the forum is open with 50 people on?

[Steve Machol]

I wouldn't recommend this. It could cause db problems if you restore that backup.

[eva2000]

it's fairly okay provided your use mysqldump --opt command but for 100% in sync database you could temporarily close forum for the dump.. small forums won't take more than 1-15mins to dump their database to sql file

[0ptima]

I use mysqldump --opt -Q

[Byron]

I thought it should be lowercase -q and not -Q?

http://www.vbulletin.com/forum/showpost.php?p=831873&postcount=10

mysqldump --opt -q -uADMIN -pPASSWORD DATABASENAME | gzip > /Server/Path/BackupFileName.sgl.gz

[Icheb]

Actually it's no problem at all to run mysqldump because it automatically locks the entire database before performing the backup.