How to solve the size limit problem of importing large sql files into MySQL, mysqlql_PHP tutorial

To solve the problem of MySQL importing large sql file size limit, mysqlql

The solution process is as follows:

1. Since mysql can parse sql compressed files, 200M is compressed into 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 relevant parameters in php.ini:

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

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