What should I do if mysql import does not exceed 2m?

The solution to mysql import not exceeding 2m: first open php.ini and modify the "upload_max_filesize, memory_limit, post_max_size" parameters; then restart the system; and finally re-execute the import command.

Recommended: "mysql video tutorial"

mysql import data size setting method

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

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 memory_limit is only 128M. The maximum size of Post is also 2M)

2. Make the following changes according to the actual performance configuration of your server: (Note: The following is based on my server performance and Changes in 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 memory of the server is 2GB, so adding it to 512M is not excessive, haha)

post_max_size = 8M (Post data The maximum 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.

(Shows the import success, how many requests were processed successfully...)

(Note: After the modification, when you go to the import command line of phpMyadmin, although (sometimes it may still be displayed as: Maximum limit: 2048KB/Max: 2,048KiB); but in fact you can import MySQL no more than 8M The backup file exported by database .sql is now! In addition, after changing php.ini, don’t forget to restart the web service or server! It will take effect after restarting!)

This is recorded, I hope it will be helpful to friends who encounter the same problem~

For local testing of php programs, it is often necessary to import database files through Phpmyadmin. When encountering phpmyadmin import There is an error with the maximum data 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 php.ini under the PHP5 folder is modified. upload_max_filesize in , but after modifying this, this problem is still prompted;

Then change the following:

Modify PHP.ini

file_uploads on Switch whether to allow file uploads via HTTP. 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 allowed file size for uploading. 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

Description

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

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

max_input_time 300 Maximum time required for each PHP page to receive data, default 60 seconds

memory_limit 80m Each PHP page The maximum memory consumed defaults to 8M. If your machine's memory is large enough, you can 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.

Attached is an effective method to restart iis:

Save the following content as iisadmin.bat and run it to restart

@ ECHO

## IIS restart

## @pause

net stop w3svc

net stop iisadmin

net start w3svc

### net start iisadmin###

How to implement MySQL import and export data. Most people use the database import and export functions in phpmyadmin, which is very convenient. However, in practical applications, I found the following problems:

1. The database exceeds a certain size, such as 6M. In this case, exporting is generally no problem and can be done correctly. Save to the local hard disk, but importing does not work! The reason is: the general PHP.INI sets the size limit of temporary files/uploaded files to 2M, and 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. It can only be imported with 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 a file!

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

The above is the detailed content of What should I do if mysql import does not exceed 2m?. For more information, please follow other related articles on the PHP Chinese website!