Backup points for InnoDB libraries (solutions caused by phpMyAdmin) _mysql

Because the MySQL default engine is InnoDB, phpMyAdmin does not specifically specify the engine when creating the table, which is using the system default InnoDB. The use of this engine with the mysql/data/directory of Ibdata1, IB_LOGFILE0, ib_logfile1 related, the three files add up to 40Mb, Xampps can not pack it in. When the database has a InnoDB engine table, deleting [Ibdata1, IB_LOGFILE0, Ib_logfile1] Three files will affect the reading of all InnoDB engine tables. Feel the problem is very serious, if the user accidentally deleted, how to do?

If accidentally deleted, can only use the way of recovery, it seems very complex. You can refer to this article http://www.jb51.net/article/45052.htm
Hope to be helpful to everyone.

As for the phpMyAdmin table, how to solve the problem. In fact, phpMyAdmin table just to save some event operations, is not particularly important, in fact, the choice of MyISAM is also possible, then the Phpmyadmin\examples\create_tables.sql to create a table to modify, Precede all creation table statements with the specified engine type, such as:

Copy Code code as follows:

Engine=myisam DEFAULT CHARACTER SET UTF8 COLLATE utf8_bin;

After the import into MySQL, the data/directory of the phpMyAdmin library, you can copy to another computer to use.

The attachment is the phpMyAdmin library file that I modified successfully. Download Address