MySQL database backup of routines

2 posts / 0 new
Last post
#1 Wed, 07/28/2010 - 06:12
juicymedia

MySQL database backup of routines

Hi Guys,

Just to double check; when virtualmin/webmin does a database backup, does it also dump any routines that may also exist with the MySQL database? I checked the mysql-lib.pl and it seems to imply that it should in the "supports_routines" subroutine if the output from "mysqldump --help" has routine set to "true".

In the case of my development box I spotted that mysqldump was set to false, so for anybody else with this incorrectly set the following block in your my.cnf:

[mysqldump]
quick
quote-names
routines

Will see what happens after it backs up!

Thanks, Pete

Wed, 07/28/2010 - 09:33
andreychek

Thanks for the info Pete, that's good to know!

Virtualmin does indeed just use mysqldump, so I suspect the setting you changed will work just fine.

-Eric

Topic locked