In security-conscious setups (isolating sensitive databases from each other), I do the following:
- Create a MySQL database using Virtualmin, as part of one of the virtual servers
- Log into MySQL as root, and revert all access rights from the server-user
- Create a new MySQL user with full access to that database.
The issue is that when the backup script runs, it is executed as the server-user, which of course has no read access to these special security-conscious tables:
Creating backup for virtual server ExampleServer .. Copying virtual server configuration .. .. done Backing up Cron jobs .. .. none defined. Saving mail aliases .. .. done Saving mail and FTP users .. .. done Backing up mail and FTP user Cron jobs .. .. none to backup Dumping MySQL database ExampleServer .. .. done Dumping MySQL database ExampleServer_roundcube .. .. dump failed! sh: /home/ExampleServer/.backup/ExampleServer_mysql_ExampleServer_roundcube: No such file or directory Dumping MySQL database ExampleServer_pma .. .. dump failed! sh: /home/ExampleServer/.backup/ExampleServer_mysql_ExampleServer_pma: No such file or directory Dumping MySQL database ExampleServer_piwik .. .. dump failed! sh: /home/ExampleServer/.backup/ExampleServer_mysql_ExampleServer_piwik: No such file or directory
Would it be possible for you to change the Virtualmin backup process so that all database dumps run as the root user?