These forums are locked and archived, but all topics have been migrated to the new forum. You can search for this topic on the new forum: Search for MySQL database backup of routines on the new forum.
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
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