What if phpMyAdmin can't import large files?

This article mainly introduces how phpMyAdmin can not import large files, the article is very detailed, has a certain reference value, interested friends must read it!

The solution that phpMyAdmin can not import large files

The default upload size of phpMyAdmin is only 2m. Importing large files is bound to fail. You can modify two parameters of php.ini by hand.

1. Upload_max_filesize is changed to 20m (that is, the maximum file size allowed to be uploaded is 2m by default, and the modified value is customized)

2. Change post_max_size to 30m (refers to the maximum value that can be received to PHP through the form POST, including all values in the form, default is 8m)

Continue to change the value of max_allowed_packet, which limits the size of packets received by the mysql server, so if the imported file is too large, it may exceed the value of this setting and cause the import to be unsuccessful.

Recommended: phpMyAdmin usage tutorial

Cmd and database modification corresponding information:

Run separately:

Show global variables like 'max_allowed_packet'; View default size set global max_allowed_packet=67108864; setting size

The above is all the contents of this article "what to do if phpMyAdmin can't import a large file". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!