Follow the below steps.
1. sudo /etc/init.d/mysqld stop
2. Copy the existing data directory (/var/lib/mysql) to a new path (/data/mysql).
sudo cp -R -p /var/lib/mysql /data/mysql
3. gedit /etc/my.cnf
Change the data directory path in my.cnf to the new data dir / socket file path.
4. Give the permissions.
Chown -R mysql:mysql /data/mysql (New path)
5. Rename the old Directory.
mv /var/lib/mysql /var/lib/mysql-old
6. Create a symbolic link.
ln -s /data/mysql /var/lib/mysql
No comments:
Post a Comment