看你的my.ini配置文件,我的如下 #Path to the database root datadir="C:/ProgramData/MySQL/MySQL Server 5.1/Data/" 如果是innodb引擎,数据存放在C:\MySQL Datafiles\ibdata1(这个也是自己配置的)
这是innodb的,不同引擎有不同的配置 #*** INNODB Specific options *** innodb_data_home_dir="C:/MySQL Datafiles/"
执行下面命令,就在这个目录下。每个数据库都会有一个自己的目录mysql> select @@datadir; +--------------------------------------------------------+ | @@datadir | +--------------------------------------------------------+ | C:\Users\xxxxxx\myData\MySQL\mysql-5.1.52-win32\data\ | +--------------------------------------------------------+ 1 row in set (0.19 sec)mysql>
#Path to the database root
datadir="C:/ProgramData/MySQL/MySQL Server 5.1/Data/"
如果是innodb引擎,数据存放在C:\MySQL Datafiles\ibdata1(这个也是自己配置的)
#*** INNODB Specific options ***
innodb_data_home_dir="C:/MySQL Datafiles/"
+--------------------------------------------------------+
| @@datadir |
+--------------------------------------------------------+
| C:\Users\xxxxxx\myData\MySQL\mysql-5.1.52-win32\data\ |
+--------------------------------------------------------+
1 row in set (0.19 sec)mysql>