MySQL database backup of routines

Virtualmin
1

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

2

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