1、查看mysql数据库data目录位置
mysql> show variables like 'datadir';
+---------------+---------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value |
+---------------+---------------------------------------------------------------------------------------------------------------------+
| datadir | C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.5/Data/ |
+---------------+---------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
2、修改%MYSQL_HOME%\my.ini数据存放路径
datadir="E:/MySQL 5.5/MySQL Server 5.5/Data/"
3、关闭mysql服务,手动把原来的数据目录copy到新设置的目录,重新启动mysql服务即可。