SoFunction
Updated on 2025-03-10

Share the method to solve the limitation of importing large files of more than 2M in PhpMyAdmin

To deal with this problem, after some research, there are two ways:

Method 1:

Find these 3 places to search upload_max_filesize , memory_limit and post_max_size
Just modify the value after them to be larger than the database size you need to import.
Then restart the PHP environment.

Method 2: Taking phpMyAdmin-3.1.0-all-languages ​​as an example, my installation directory E:\wwwroot\phpMyAdmin\

1. Create a new directory in the phpmyadmin directory upload.

2. Open phpmyadmin, find the E:\wwwroot\phpMyAdmin\ file, find and modify it to $cfg['UploadDir'] = "upload"; and then click Save.

Open the E:\wwwroot\phpMyAdmin\libraries\ file, find and modify it to $cfg['UploadDir'] = "upload"; then click Save.

3. Upload the SQL file you need to import into phpmyadmin/upload/

4. Visit phpmyadmin, click Import, and the drop-down box for selecting files on the server will appear, and select the SQL file uploaded using FTP. This is perfectly solved.

Finally, after logging in /phpmyadmin/, click import to see.