Migrate to mariadb with databases in /home

[benito]

Hello!

It is safe migrate to mariadb if i move all the databases to /home in mysql?

Thanks

 

[cPanelMichael]

Hello,

Could you verify the steps you took to move your databases to the /home partition?

Thank you.

 

[benito]

Hello,

Could you verify the steps you took to move your databases to the /home partition?

Thank you.

Yes its simple, just move and symbolic link. I followed this steps.

/etc/init.d/mysql stop
mkdir /home/var_mysql
mv /var/lib/mysql /home/var_mysql
chown -R mysql:mysql /home/var_mysql/mysql
ln -s /home/var_mysql/mysql /var/lib/mysql
/etc/init.d/mysql start

 

[cPanelMichael]

Hello,

The upgrade should work, but I strongly recommend backing up your databases beforehand because this is an unsupported configuration. You should consider reverting this change if you have the available disk space, and then moving it back into place once the upgrade finishes.

Thank you.

 

[benito]

Thanks Michael