Moving mysql var/lib/mysql to /home/mysql

ساخت وبلاگ

آخرین مطالب

امکانات وب

Moving mysql var/lib/mysql to /home/mysql

Hi,

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 running and functioning correctly, remove the old data:
rm -rf mysql_old
My question, is there any difference when installed Mysql with Mariadb?

And finally, let´s assume something gone wrong, how to revert it quickly?

DirectAdmin Forums...
ما را در سایت DirectAdmin Forums دنبال می کنید

برچسب : نویسنده : ایمان اصلاحی directadmin بازدید : 377 تاريخ : يکشنبه 22 بهمن 1396 ساعت: 20:12

آرشیو مطالب

پيوندهای روزانه

لینک دوستان

خبرنامه