Notes for innodb Database Backup (solution caused by phpmyadmin)

Source: Internet
Author: User

Because the default mysql engine is innodb, no engine is specified when phpmyadmin creates a table, that is, the default innodb is used. this engine is connected to ibdata1, ib_logfile0, and ib_logfile1 In the mysql/data/directory. These three files add up to 40 Mb, and xampps cannot be packed in. when the database has innodb Engine tables, deleting the three files [ibdata1, ib_logfile0, ib_logfile1] will affect the reading of all innodb Engine tables. I think the problem is quite serious. What should I do if the user accidentally deletes it?

If accidentally deleted, it can only use the recovery method, it seems very complicated., can refer to this article http://www.jb51.net/article/45052.htm
I hope to help you.

How to solve this problem in the phpmyadmin table. in fact, the phpmyadmin table only saves some event operations and is not particularly important. In fact, you can also select MyISAM, so you can create and modify the phpmyadmin \ examples \ create_tables. SQL table, add the specified engine type before all the table creation statements, for example:
Copy codeThe Code is as follows:
ENGINE = MyISAM default character set utf8 COLLATE utf8_bin;

After importing the data to mysql, you can copy the phpmyadmin library in the data/directory to another computer.

The attachment contains the modified phpmyadmin library file.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.