Solve the problem of 20MB size limit for importing MYSQL database using WDCP panel PHPMYADMIN tool

In view of some projects and user operating habits, some users prefer to directly use the PHPMYADMIN tool to import, restore and back up MYSQL data. Later, a netizen mentioned to Snail that when he was using the WDCP panel to manage his website, the size of his MYSQL database exceeded 20MB during the move, and the default setting of the WDCP panel was a maximum import limit of 20MB. This problem needed to be solved.

A few years ago, Lao Niu also had such a problem when he was relocating his website. At that time, Snail found a solution from the Internet and posted it for him to use. He estimated that it should also be able to solve it. It seems that there are many students who need to solve this problem. Snail will try it himself to see how to solve this problem.

First, the MYSQL tool import limit in the default WDCP panel is 20MB

If we import a MYSQL database by default, it cannot be imported if it exceeds 20MB. We need to adjust the system settings.

Second, modify the php.ini system settings to set the MYSQL size parameters

Find the \\"/www/wdlinux/wdphp/lib/php.ini\\" file and modify the following parameters.

A – Change the parameter after max_execution_time to 0 (default is 30)

B – Change upload_max_filesize from the default 20M to the size you need, for example I can change it to 500M

C – Change post_max_size from the default 20MB to the same size as above, for example, I also changed it to 500M

Third, restart the WEB server to take effect

service wdapache restart

Here, we mainly modify the size of the uploaded database, and then after restarting, we can see in the imported database in the PHPMYADMIN panel that the original 20MB has become 500MB.

Finally, Snail used to prefer to use this method to import and backup the database, but if the database is large, it is not efficient, and sometimes the machine speed is slow and timeout is troublesome. The best way is to import it through commands.

mysql -ulaozuo -plaozuo.org laozuo < laozuo.sql

For details, please refer to the articles \\"Linux VPS using commands to quickly import/backup MYSQL database\\" and \\"Detailed explanation of using the mysqldump command to back up and restore MySQL data usage\\" articles. Using command operations can not only improve efficiency , and can ensure the integrity of import and import.

Recommended site search: domain name directory, foreign server vps, foreign server vps, overseas virtual host space, free website application domain name, which is the best foreign server rental, Hong Kong cloud server, game server rental, Wanwang space price, Beijing virtual Host rental,