Solve the problem of large SQL file size limit for MySQL import, mysqlql. Solve the problem of large SQL file size limit for MySQL import. the mysqlql solution process is as follows: 1. mysql can parse SQL compressed files, so MB is compressed to 5 MB. 2. by default, mysqlql
The solution is as follows:
1. because mysql can parse SQL compressed files, MB is compressed to 5 MB.
2. by default, the size of the MySQL imported file is limited to 2 MB. Therefore, when the file is large, it cannot be imported directly. you can modify the php. ini parameter to adjust it:
Modify related parameters in php. ini:
There are three parameters that affect the size of the MySQL Import File :,
Memory_limit = 128 M, upload_max_filesize = 2 M, post_max_size = 8 M
The mysqlql solution is as follows: 1. mysql can parse SQL compressed files, so MB is compressed to 5 MB. 2. default :...