Mysql import data size setting method

Solution to the maximum limit of 2048KB for MySQL database file import and 2048KB for phpmyadmin import data

Solution:

1. Open php.ini. Find the three parameters upload_max_filesize, memory_limit, and post_max_size!

　　(By default, PHP only allows the maximum upload data to be 2M, which is 2048KB, and the maximum maximum memory used memory_limit is only 128M, and the maximum of Post is also 2M)

　　2. Make the following changes according to the actual performance configuration of your server: (Note: The following are the changes based on my server performance and hardware configuration..)

　 upload_max_filesize = 8M (The maximum upload limit is set to 8M, which should be enough for general file WEB upload)

　 memory_limit = 512M (Because the server's memory is 2GB, so adding 512M here is not excessive. Ha)

Post_max_size = 8M (The maximum Post data is also set to 8MB, which is the same as upload_max)

　 3. After the change, I restarted the system and re-executed the import command:

　　　Import has been successfully finished, 399 queries executed.

　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　　 since in in inturn in phpMyadmin (Note: After the change, when you go to the import command of phpMyadmin When running, although (sometimes it may still be displayed as: Maximum limit: 2048KB/Max: 2,048KiB); but you can actually import the MySQL database .sql exported backup file that does not exceed 8M! In addition, after changing PHP .ini, don’t forget to restart the web service or server! It will take effect after restarting!)

I will record this, I hope it will be helpful to friends who encounter the same problem~

　 When testing PHP programs locally, it is often necessary to import database files through Phpmyadmin, but an error occurs when phpmyadmin imports data with a maximum limit of 2048KB.

　　Error message: You PRobably tried to upload too large file. Please refer to documentation for ways to workaround this limit.

　 It turns out that when using phpmyadmin to import the mysql database, the default mysql database can only import a maximum of 2M.

The solution is given below:

In most cases, the upload_max_filesize in php.ini under the PHP5 folder is modified, but after modifying this, this problem is still prompted;

　 Then change the following:

　 Modify PHP.ini

　 file_uploads on 　　 Whether to allow file uploading via HTTP switch. The default is ON, that is, upload_tmp_dir -- Files are uploaded to the server where temporary files are stored. If not specified, the system default temporary folder will be used. upload_max_filesize 20m Wangwen Business, that is, the maximum size of files allowed to be uploaded. . The default is 2M

　post_max_size 30m 　　Refers to the maximum value that can be received through form POST to PHP, including all values ​​in the form. The default is 8M

　Explanation

Generally, after setting the above four parameters, if the network is normal, uploading a large file of 8M will definitely work if only the above four parameters are set. Unless your network really has a 100M/S upload speed, you have to continue to set the following parameters, that is, set its time,

　 max_execution_time 300 The maximum time value (seconds) for each PHP page to run, the default is 30 seconds

max_input_time 300 The maximum time required for each PHP page to receive data, the default is 60 seconds

Memory_limit 80m The maximum memory consumed by each PHP page, the default is 8M, if your machine has enough memory If it is larger, you can also set it larger

Set the maximum size allowed for POST data. This setting also affects file uploads. To upload large files, this value must be greater than upload_max_filesize.

　 If memory limit is activated in the configuration script, memory_limit will also affect file upload. Generally speaking, memory_limit should be larger than post_max_size. @ pause

　net stop w3svc

　net stop iisadmin

　net start w3svc

　net start iisadmin

　MySQL import and export data implementation method is generally used phpmyadmin The database import and export functions inside are very convenient . However, in practical applications, I found the following problems:

　　1. The database exceeds a certain size, such as 6M. At this time, exporting is generally no problem and can be correctly saved to the local hard disk, but importing No! The reason is: the general PHP.INI sets the size limit for temporary files/uploaded files to 2M, but phpmyadmin uses the upload method, causing failure.

　2 When importing the .SQL file exported to the hard disk, it often fails due to some problems with single quotes, causing the import to fail and can only be imported using applications such as mysql.

　My database has exceeded 10M, so this problem must be solved. My idea:

Export: Use phpmyadmin to save the database/table structure, use a script to read the database content and save it to the file!

Import: Use phpmyadmin to restore the database/table structure, use a script to read the file, and then save it to the library Inside!

The above is the content of the mysql import data size setting method. For more related content, please pay attention to the PHP Chinese website (www.php.cn)!