MYSQL Import data size limit settings

Upload_max_filesize = 2M,//MAX upload display
Memory_limit = 128M;
Post_max_size = 8M. // if it is larger than upload_max_filesize,theupload_max_filesize setting will work.



The most straightforward solution of course is to modify the settings of the php.ini configuration file, that is, modify the default upload_max_filesize = 2M, memory_limit = 128M; Post_max_size = 8M. For example, if I want to upload a 27M SQL database file, it can be modified to Upload_max_filesize = 32M, post_max_size = 32m,post_max_size and memory_limit value at least greater than or equal to upload The setting value of the _max_filesize. After adding the maximum upload settings data in php.ini, restart the Apache database, then open phpmyadmin to upload large SQL database files and so on.

MYSQL Import data size limit settings