how to change mysql data directory

Question

I use FreeBSD 8.2, mysql 5.1.58. I want change mysql default directory. I config datadir= /path OR my-data-dir= /path on my.cnf but not done. Note: i permission for /path is 755 and owner mysql:mysql. By another way, i set in /etc/rc.conf but not done

This is error, when restart mysql services.

usr/local/etc/rc.d/mysql-server restart mysql not running? (check /var/db/mysql/bsd1.abc.com.pid).

Help me.

When you do this and restart mysql, are you getting errors - how are you working out it is not working? — Paul, Sep 22 '11 at 03:48

score 2 · Answer 1 · answered Sep 22 '11 at 21:09

I assume your current MySQL data directory is the default /var/db/mysql.

Stop MySQL (service mysql-server stop)
Change the datadir in rc.conf (mysql_dbdir="/another/directory")
mv /var/db/mysql /another/directory
Start MySQL again (service mysql-server start)

If there are still problems, ensure that the directory itself and all directories inside belong to user and group mysql. (chown -R mysql:mysql /another/directory; chmod 600 /another/directory)

Korjavin Ivan · Answer 2 · 2011-09-22T21:14:30.987

0

another way is:

move and 'ln -s' /var/db/mysql somewhere.

edited Sep 22 '11 at 21:14

answered Sep 22 '11 at 04:44

Korjavin Ivan

2,250
2
26
41

score 0 · Answer 3 · edited Jun 11 '20 at 10:02

Stop MySQL

service mysql stop

Make new directory for MySQL data

mkdir /new/dir/for/mysql

Set ownership of new directory to match existing one

chown --reference=/var/lib/mysql /new/dir/for/mysql

Set permissions on new directory to match existing one

chmod --reference=/var/lib/mysql /new/dir/for/mysql

Copy all files in default directory, to new one, retaining perms (-p)

cp -rp /var/lib/mysql/* /new/dir/for/mysql/

Edit the /etc/my.cnf file, and under [mysqld] add this line:

datadir=/new/dir/for/mysql/

Start MySQL

service mysql start