Break through the phpMyadmin file size limit of 2 MB

Break through the phpMyadmin file size limit of 2 MB when using phpMyadmin to import the database, because the response time of the script during the upload is too long, resulting in data larger than 2 MB may occasionally fail to import. In addition, most default settings can only import 2 MB of data. In this case, we can modify the size limit of $ memory_limit corresponding to PHP. ini and import. php. You can also directly import SQL files of any size on the server. This section breaks through the phpMyadmin file size limit of 2 MB.

When using phpMyadmin to import data to the database, because the response time of the script during upload is too long, data larger than 2 MB may occasionally fail to be imported. In addition, most default settings can only import 2 MB of data.

In this case

We can modify the size limit of $ memory_limit corresponding to PHP. ini and import. php. You can also directly import SQL files of any size on the server.

Here we will talk about the second method:

First, open the config. inc. php file under the phpMyAdmin root directory, and find

$cfg['UploadDir']

Change

$cfg['UploadDir'] = ‘ck-import’

Then, upload the database to the ck-import folder through FTP.

After saving the code, one more (web server upload directory) will be displayed on the phpMyadmin background operation page ). Select the database you want to import from the drop-down list to import large files:

?

Similarly, when backing up a database, you can directly save it on the server and modify the $ cfg ['savedir'] = 'backup 'parameter.

?