The sql file is too large and cannot be imported into phpmyadmin

1. Open php.ini.

Find these three parametersupload_max_filesize,memory_limit,post_max_size!

(By default, phpmyadmin only allows the maximum upload data to be 2M, and the maximum memory usagememory_limitis only 128M, and the maximum numberPostis also Only 2M)

2. Make the following changes according to the actual performance configuration of your server:

upload_max_filesize = 8M

memory_limit = 512M

post_max_size = 8M

3. Modify the$cfg['ExecTimeLimit']configuration option in the phpmyadmin configuration file config, default The value is 300 and needs to be modified to 0, which means there is no time limit.

4. Modify $memory_limit in the import page in the root directory of the phpmyadmin installation

as shown below:

Description: First choice Read the memory configuration option memory_limit in the php.ini configuration file. If it is empty, the default memory size limit is 2M. If there is no limit, the memory size is limited to 10M. You can modify it based on the relevant information in your php.ini configuration file. this code.

5. After the modification, restart the server and re-execute the import command

Import has been successfully finished, 399 queries executed.

Recommended related articles and tutorials:phpmyadmin tutorial

The above is the detailed content of The sql file is too large and cannot be imported into phpmyadmin. For more information, please follow other related articles on the PHP Chinese website!