Shulou(Shulou.com)05/31 Report--

This article will explain in detail for you how to solve the problem of how to solve the maximum limit of 2048KB for MySQL database files. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

Introduction:

Today, in order to transfer the server space ~ ~ first successfully export the Mysql database with myadmin ~ ~

Then build it on the new server and import it! But because the .sql file of the MySQL database is larger than 2MB. So in the import on the prompt that more than the 2048KB error, do not allow the import. . So it leads to the solution of this article, hehe.

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 uploaded data to be 2m, that is, 2048KB, and the maximum memory usage memory_limit is only 128m, which is 2m for Magi Post)

2. Make the following changes according to the actual performance configuration of your server: (note: the following are the changes made according to 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 uploads)

Memory_limit = 512m (since the memory of the server is 2GB, it's not too much to add 512m here, huh)

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 restart the system, and then execute the import command again:

Import has been successfully finished, 399 queries executed.

(shows how many requests were successfully processed after the import was successful.)

(note: after the change, when you are on the import command line of phpMyadmin, although (sometimes it may still show as: maximum limit: 2048KB/Max: 2048KiB), you can actually import backup files exported by MySQL database .sql of no more than 8m! In addition, after changing the php.ini, don't forget to restart the web service or the server! It will be effective after reboot!)

On "how to solve the MySQL import database file maximum limit 2048KB problem" this article is shared here, I hope the above content can be of some help to you, so that you can learn more knowledge, if you think the article is good, please share it out for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.