Methods to resolve Web site phpMyAdmin cannot import large databases

In fact, once wrote a phpmyadmin can not import large file solution, but some things, if not, there will be a large number of netizens do not understand how to operate. So I only tell the steps, no longer speak any principle, it turns out that any principle, understand people do not need to see, do not understand people they will not go to see, even if the principle is very superficial.

consider using the imperial backup King can ignore this article , but the method is still worth understanding learning.

First, the MySQL database is exported in two steps in the original phpMyAdmin

Please export in two steps

First step: Export the database structure. Database structure files are generally very small, almost impossible to exceed 2M, so you can directly on the other phpmyadmin directly above the recovery;

Step two: Export the data content. If this file is too large, you can use Cosbeta write program to restore (program download at the end of this page, do not worry, please read the steps to download).

Export database structure

Enter phpMyAdmin and export the data according to the following screenshot:

1. Click the name of the database you want to export

2. Click the Export button.

3. Select Export Structure only

Take a closer look at the above options, just remove the data that tick. Only export the data on the contrary, the structure hook out, the data on the tick

4. Download database structure

The database structure of the file is very small, so generally a few seconds can be done.