MySQL import large SQL file size limit problem resolution, mysqlql_php tutorial

MySQL import large SQL file size limit problem resolution, MYSQLQL

The resolution process is as follows:

1. Since MySQL can parse the compressed file of SQL, it will compress 200M to 5 m.

2, by default: MySQL import file size is limited, the maximum is 2M, so when the file is very large, directly unable to import, can modify the php.ini parameter adjustment:

To modify the 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.html www.bkjia.com true http://www.bkjia.com/PHPjc/1048720.html techarticle mysql import large SQL file size limit problem resolution, MYSQLQL the process is as follows: 1, because MySQL can parse the SQL compressed file, so the 200M compressed 5 m. 2, by default: ...

