Backup points for the innodb library (the solution caused by phpmyadmin)

  • 2020-06-03 08:37:45
  • OfStack

Since mysql's default engine is innodb, phpmyadmin does not specify the engine when creating the table, so innodb is used as the default. The engine is related to ibdata1, ib_logfile0, ib_logfile1 in the mysql/data/ directory. The three files add up to 40Mb, so xampps cannot pack it in. ib_logfile0, ib_logfile1 3 files will affect the reading of all innodb engine tables.

If accidentally deleted, can only be used to restore the way, seems to be very complicated. And you can refer to this article https: / / www ofstack. com article / 45052. htm
I hope it helps.

As for the phpmyadmin table, how to solve this problem? The fact that phpmyadmin table only saves 1 event operation is not very important, in fact, it is ok to select MyISAM, then go ahead and modify phpmyadmin\examples\ create_tables.sql create table, and prefix all the create statements with the specified engine type, such as:


After importing mysql here, phpmyadmin library in data/ directory can be used on other computers.

Attached is the phpmyadmin library file that I modified successfully. Download address

Related articles: