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

http://www.bkjia.com/PHPjc/1048720.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/1048720.htmlTechArticleTo solve the problem of MySQL importing large sql file size limit, the mysqlql solution process is as follows: 1. Since mysql can parse sql Compress the file, so 200M is compressed to 5M. 2. By default:...