The role of ibdata in mysql Innodb and the separation of ibdata In the mysql INNODB data state is used to store file data, while the table files in the folder of the database name are only structured. Be careful, you must be careful not to delete it. In the shared tablespace management, the table space cannot be reduced after it is allocated, so it will become larger and larger. Therefore, it is necessary to separate the independent tablespace parameters of INNODB:
Innodb_file_per_table
The procedure is as follows:
1. Backup database mysqldump-uroot-p -- all-database> c: \ all_back_database.sql2. Stop database mysqladmin -- host = localhost -- user = root -- password shutdown3. Delete related files ibdata1ib_logfile * 4. manually delete all database folders except Mysql, then start the Database net start mysql5 and restore the data mysql-uroot-p <c: \ all_back_database.sq