MySQL Data Catalog Replacement

MySQL default data file storage directory is/var/lib/mysql, if you want to move the directory to the/data need to take the following steps:

1. Set up data Directory

mkdir data

2. Stop MySQL Service

Service Mysqld Stop

3. Move/var/lib/mysql Entire directory to/data
mv/var/lib/mysql/data/

4. Modify the MY.CNF configuration file

Vim/etc/my.cnf

5. Restart MySQL Service

Service mysqld Start

Issue: ERROR 2002 (HY000): Can ' t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock ' (2)

Workaround: Add the [MySQL] field in/etc/my.cnf to specify the location of the socket to the location after our transfer

MySQL Data Catalog Replacement