Well, I recently installed MySQL plugin to store the databases for Owncloud and Wordpress plugins but I found that the databases are stored in the boot disk. Call me paranoid, but if the boot disk fails, I could restore it using Clonezilla. But the image that Clonezilla took, in case the boot disk breaks, has an old database. To solve that, I managed to do a scheduled backup of the MySQL plugin automatically every day and save it to a shared folder in a data drive.
My question is: could it be possible to directly change the default location of the MySQL plugin (/var/lib/mysql) to store the database directly to a data disk? That would be useful so in case something in the system disk fails, when I restore it, the database would not be affected.
Hope someone can help me
Thanks in advance.
EDIT: it seems like an older version of the MySQL plugin allowed us to select a shared folder to store the data. Why it has been removed in newer versions?
Guillem