Shulou(Shulou.com)06/01 Report--

This article mainly introduces the sql file is too large to import phpmyadmin solution, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian with you to understand.

1. Open php.ini.

Find the three parameters upload_max_filesize, memory_limit, and post_max_size!

(by default, phpmyadmin only allows a maximum upload data of 2m, while the maximum memory usage memory_limit is only 128m and 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. The default value is 300, which needs to be modified to 0, that is, there is no time limit.

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

As shown in the following figure:

Description: preferred to read the php.ini configuration file in the memory configuration option memory_limit, if empty, the default memory size is limited to 2m, if there is no limit, the memory size is limited to 10m, you can modify this code with the relevant information in your php.ini configuration file.

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

Import has been successfully finished, 399 queries executed. Thank you for reading this article carefully. I hope the article "sql file is too big to import phpmyadmin solution" shared by the editor will be helpful to everyone. At the same time, I also hope you can support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.