I need to move mysql from var/lib/mysql to home/mysql.
I found this help to do:
https://help.directadmin.com/item.php?id=12
Code:
cd /home mkdir mysql chown mysql:mysql mysql cd mysql perl -pi -e 's/mysqld=ON/mysqld=OFF/' /usr/local/directadmin/data/admin/services.status /sbin/service mysqld stop cp -Rp /var/lib/mysql/* . cd /var/lib mv mysql mysql_old ln -s /home/mysql ./mysql /sbin/service mysqld start perl -pi -e 's/mysqld=OFF/mysqld=ON/' /usr/local/directadmin/data/admin/services.status #once satisfied that mysqld is ruing and functioning correctly, remove the old data: rm -rf mysql_old
And finally, let´s assume something gone wrong, how to revert it quickly?
برچسب:
نویسنده: ایمان اصلاحی