phpMyAdmin import file Max 2M limit

Unblock phpmyadmin import file by 2M Max limit

In the usual development of the application often meet the need to import a database larger than the phpmyadmin limit of 2M, how to solve? Please see below

Modify the C:\windows\php.ini file.
If it is a Win2000 machine, it should be c\winnt\php.ini, open the php.ini file with WordPad:

1, find post_max_size, refers to through the form post to PHP can receive the maximum value, including all the values in the form, the default is 8M, see you need to change.
2, find file uploads, first confirm file_uploads = on, whether to allow the switch to upload files via HTTP, the default is on is on. Upload_tmp_dir;
Find upload_max_filesize; That is, the maximum number of file sizes allowed to upload. The default is 2M.
3, if you want to upload >8m files, then only set the above four items can not be certain. It is best to set the following parameters as well:
Find max_execution_time = 600; The maximum time value (in seconds) for each PHP page to run, default 30 seconds.
Max_input_time = 600; The maximum time required for each PHP page to receive data, default 60 seconds.
Memory_limit = 8M; The maximum memory eaten by each PHP page, the default 8M.

Modify the c:\phpmyadmin\import.php file.
Open import.php file with WordPad:
1, find $memory_limit, the default is $memory_limit = 2 * 1024 * 1024;
2, the bottom three or four line position has the same statement, modifies itself.

Then restart the service to see if the phpMyAdmin limit is changed.

Transfer to original

?

