How to increase the space for MySQL innodb_data files

Today in MySQL to create a table, how not successful, a check, found that the Innodb_data file Ibdata1 is located in the D disk is full, so want to add a file in e-disk,

Check the information, in fact, it is simple.

First close the database

Mysqladmin-u root-p shutdown

Then locate the My.ini file under the MySQL installation path, locate the Innodb_data_home_dir, and change it to

#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

This will specify two files.

and start the database.

\mysql Server 5.0\bin>mysqld-nt

Referenced by: http://blog.chinaunix.net/uid-77311-id-4478378.html

http://jazka.blog.51cto.com/809003/328955/

Very well written, thank you.

How to increase the space for MySQL innodb_data files