Author Topic: can't move mysql datadir  (Read 921 times)

0 Members and 1 Guest are viewing this topic.

can't move mysql datadir
« on: March 19, 2017, 12:49:06 PM »
somebody can help me ?
how to move data dir mysql on CWP Centos7 ?
i was try follow tutorial on CWP wiki about "How to change MySQL Location" but fail always return
Code: [Select]
Restarting mysqld (via systemctl):  Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.
please somebody help.

Re: can't move mysql datadir
« Reply #1 on: April 04, 2017, 01:58:51 PM »
Same as me! :'(

I spend more than 5 hours, do random things to make this work but it didn't
I want to make this work on Centos 7. For now I have to fallback to Centos 6 because of this

If anyone found solution for this please reply in this topic, thanks

Re: can't move mysql datadir
« Reply #2 on: April 05, 2017, 10:27:27 AM »
this works fine did that multiple times, make sure mysql is down when you do this things and check the logs if you have some errors!
AntiDDoS Protection (web + mail)

Join our Development Team and get paid !

Services Monitoring & RBL Monitoring

Do you need Fast and FREE Support included for your CWP linux server?
Installation Instructions
Get Fast Support Here

Re: can't move mysql datadir
« Reply #3 on: May 01, 2017, 04:49:01 PM »
service mysqld stop
cd /var/lib
chown -R mysql:mysql YOUR_NEW_LOCATION_PATH
service mysqld start