How to solve the problem of size limit for importing large sql files into MySQL

The solution process is as follows:

1. Since mysql can parse sql compressed files, 200M is compressed to 5M.

2. By default: MySQL import file size is limited, the maximum is 2M, so when the file is very large, it cannot be imported directly. You can modify the php.ini parameter adjustment:

Modify the relevant parameters in php.ini:

There are three parameters that affect the size of MySQL import files:,

memory_limit=128M, upload_max_filesize=2M, post_max_size=8M

The above introduces the solution to the problem of MySQL importing large sql file size limit, including the relevant aspects. I hope it will be helpful to friends who are interested in PHP tutorials.