Submitted by Jesse OBrien on Sun, 09/07/2014 - 09:36
When restoring from a backup with a different datadir configured in my.cnf:
[mysqld] ... datadir = /mnt/RAID
Virtualmin restore does not change permissions on the correct datadir, it tries (and fails, for me) to apply those permissions to /var/lib/mysql/. I temporarily solved this problem with a symbolic link between /var/lib/mysql and /mnt/RAID on this system. If this had been an emergency situation, the time spent troubleshooting this issue could have been catastrophic.
Status:
Active
Comments
Submitted by JamieCameron on Sun, 09/07/2014 - 11:27 Comment #1
That's odd, because Virtualmin actually should already read that datadir line to work out the MySQL data directory.
Can you post the
/etc/webmin/mysql/configfile from your system? And check that themy_cnf=line has the correct path tomy.cnfon your system.