Solution to the problem that phpmyadmin cannot import large SQL files

PHPMyAdmin cannot import large SQL files. Friends in need can refer to it. If you can only use phpmyadmin, open the configuration file in the phpMyAdmin directory: config.inc.php

PHPMyAdmin cannot import the solution to large SQL files. Friends in need can refer to it.

If you can only use phpmyadmin, open the configuration file in the phpMyAdmin directory: config.inc.php

Please pay attention to these two parameters: $cfg['UploadDir'] ='A'; $cfg['SaveDir'] ='B';

Create folders A and B in the phpMyAdmin directory to correspond to UploadDir (import directory) and SaveDir (export directory).

Export operation: 1. Log in to phpMyAdmin 2. Select the database you want to backup and export on the left 3. Find "Export" in the right window 4. Select "Save in server's B/ directory" at the bottom of the right window. 5. Select the compression mode and submit "Execute" to find the exported data of the database in the B folder.

Import operation: 1. Upload the data file to be imported to the A directory 2. Log in to phpMyAdmin 3. Select the database you want to back up and export on the left 4. Find “Import” in the right window 5. Select the data file to be imported in the "Website Server Upload Directory" in the right window and submit "Execute" to complete the import

Method 2: http://faq.1and1.com/web_space__access/mysql/13.html

Can import and export I have tried exporting 600MB SQL on fatcow without any problem. http://www.ozerov.de/bigdump/usage/

Only import I also tried importing 600MB of SQL on fatcow, no problem