Edit rc.mysqld or create my.cnf to change MySQL datadir?

adkPrasanna · 12-31-2016, 01:48 AM

I want to change the data directory of MySQL Server. Which one is better? Edit rc.mysqld or create a new file my.cnf in /etc ?

Alien Bob · 12-31-2016, 04:11 AM

Another option which works better with package upgrades: make the original mysql datadir into a symbolic link pointing to the actual location where you created your datadir.
No need to edit any file that way.

adkPrasanna · 12-31-2016, 11:32 PM

Thanks Alien Bob for replying

I have root in /dev/sda8 where /var/lib/mysql is situated

If I format /dev/sda8 I will lost all of the MySQL data. So I want to keep /home/userName/MySQL as datadir.

If I created symbolic link, then will I be able to get data if I format /dev/sda8 and reinstall Slackware again? I'm little bit of unsure.

I tried creating hardlink but, it is not allowing for directories.

So I tried editing /etc/my.cnf for changing the datadir. But MySQL says, mysql.sock doesn't exist. It would be a great help if you guide me or suggest me some tutuorials..

Alien Bob · 01-01-2017, 06:00 AM

It should be sufficient to do:

Code:

/etc/rc.d/rc.mysql stop
mv /var/lib/mysql /var/lib/mysql.orig
ln -s /home/userName/MySQL /var/lib/mysql
/etc/rc.d/rc.mysql start

Richard Cranium · 01-01-2017, 02:48 PM

Drop a new file in /etc/my.cnf.d/ that changes the config for you.