如何增mysql innodb

2025-05-12 21:32:36
推荐回答(1个)
回答1:

1首先关闭数据库
mysqladmin -u root -p shutdown
2找mysql安装路径my.ini文件找其innodb_data_home_dir,其改
#innodb_data_home_dir="D:/MySQL
Datafiles/"innodb_data_home_dir=innodb_data_file_path=D:/MySQL
Datafiles/ibdata1:10M;E:/MySQL Datafiles/ibdata2:50M:autoextend
3启数据库
\MySQL Server 5.0\bin>mysqld-nt