MySQL Backups

5 posts / 0 new
Last post
#1 Sat, 07/12/2014 - 20:13
kelv1n

MySQL Backups

Hi

When a backup is run and the MySQL databases are dumped, how do I tell Virtualmin to run the dump with "--single-transaction"?

I found the following link showing how to do it in Webmin, But the option is not available in the Virtualmin backup area -

http://t134164.web-webmin-general.webdiscuss.info/using-single-transacti...

Thanks

Sun, 07/20/2014 - 07:29
Locutus

I haven't tested this, but maybe the option in Webmin also takes effect for Virtualmin database backups? Did you try this?

Mon, 07/21/2014 - 09:23
andreychek

Howdy,

Yeah, I believe Locutus is correct here, that should resolve it (although I haven't tested it either :-)

But in general, whenever Virtualmin interacts with your system, it uses Webmin (and it's related settings) to do so.

-Eric

Wed, 07/30/2014 - 06:23
kelv1n

Thank guys, I think this is working ok. Unfortunately its difficult to say with 100% certainty as I don't know if Webmin logs these calls :)

Wed, 07/30/2014 - 06:35
Locutus

Webmin has a "debug log" feature, which, when turned on, should log all calls that it makes, files that it opens etc. You can turn it on under "Webmin -> Webmin Configuration -> Debugging Log File".

Topic locked