更改 MySQL 資料庫檔案存放的資料夾

1. Stop mysqld
2. mv /var/lib/mysql /data/mysql
3. Modify MySQL configuration file (/etc/mysql/my.cnf or C:\Program Files\MySQL\MySQL Server 5.1\my.ini)

datadir=/data/mysql

4. Start mysqld




Reference :
Changing the MySQL Application Data Directory path on Windows / XP / Vista | opensourcevarsity.com
Moving MySQL datafile to another location