Breakthrough phpMyAdmin upload file 2M size limit
When importing a database using phpMyAdmin, because the script responds too long at upload time, data that is larger than 2M will occasionally fail to import. And most of the default settings, only 2M of data can be imported.
Encountered this situation
We can modify the php.ini and import.php corresponding $memory_limit size limits. You can also import SQL files of any size directly on the server.
Here's a second way:
First, open the config.inc.php file under the phpMyAdmin root directory and find
$cfg [' Uploaddir ']
Revision changed to
$cfg [' uploaddir '] = ' ck-import '
The database is then uploaded to the Ck-import folder via FTP.
After the code is saved, the phpMyAdmin background Operations page will have one more (Web server upload directory). In the drop-down list, select the database you want to import, you can import large files:
?
Similarly, when backing up the database can also be stored directly on the server, modify the $cfg [' savedir '] = ' backup ' parameters.
?