Home Web Front-end JS Tutorial Solution to the problem that PHPMyAdmin prompts that the file size exceeds the PHP limit when importing_javascript skills

Solution to the problem that PHPMyAdmin prompts that the file size exceeds the PHP limit when importing_javascript skills

May 16, 2016 pm 04:07 PM
phpmyadmin import

I encountered this problem when the website was moved, because the data has been backed up and restored using the PhpMyAdmin tool. However, as the website has more and more data, the database is getting larger and larger. After compression, it still remains. There is 4M of data, but when importing the data in PhpMyAdmin, an error message appears.

The picture above shows the prompt in PhpMyAdmin "No data to be imported was received. It may be that the file name was not submitted, or the file size exceeded the PHP limit. See FAQ 1.16.".

After searching on the Internet, I found a solution. The reason is that PHP limits uploaded files to 2M by default, and we only need to modify this default limit.

How to operate: Open the PHP configuration file PHP.ini, search for "upload_max_filesize" and change the default 2M to a larger size.

If changing the default value still does not solve the problem, please try the following operations.

Search memory_limit and post_max_size respectively and modify their values, of course to make them larger.

memory_limit explanation: setting memory;

post_max_size explanation: the maximum value of submitted data;

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot Article Tags

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

How to set primary key in phpmyadmin How to set primary key in phpmyadmin Apr 07, 2024 pm 02:54 PM

How to set primary key in phpmyadmin

Where does the wordpress database exist? Where does the wordpress database exist? Apr 15, 2024 pm 10:39 PM

Where does the wordpress database exist?

How to add foreign keys in phpmyadmin How to add foreign keys in phpmyadmin Apr 07, 2024 pm 02:36 PM

How to add foreign keys in phpmyadmin

What is the password for the phpmyadmin account? What is the password for the phpmyadmin account? Apr 07, 2024 pm 01:09 PM

What is the password for the phpmyadmin account?

How to delete data table in phpmyadmin How to delete data table in phpmyadmin Apr 07, 2024 pm 03:00 PM

How to delete data table in phpmyadmin

Where is the phpmyadmin log? Where is the phpmyadmin log? Apr 07, 2024 pm 12:57 PM

Where is the phpmyadmin log?

How to import local songs from NetEase Cloud Music How to import local songs How to import local songs from NetEase Cloud Music How to import local songs Mar 13, 2024 am 11:19 AM

How to import local songs from NetEase Cloud Music How to import local songs

why phpmyadmin access denied why phpmyadmin access denied Apr 07, 2024 pm 01:03 PM

why phpmyadmin access denied

See all articles