How to Increase Import File Size in phpMyAdmin [WordPress]

Increase Import File Size in phpMyAdmin

In this article i”ll Guide you how to increase Import File size in phpMyAdmin, If you are working on some big website like eCommerce, multi-vendor or some large database website you have to increase phpMyAdmin upload size. By default when you import file from SQL then the max import file size is 2 MB. if you want to upload above 2 MB file then you have to do phpmyadmin max file size increment. for that, you have to follow some steps.

Step 1 Find php.ini file

$ locate php.ini
/etc/php5/apache2/php.ini
/etc/php5/cli/php.ini
/usr/share/doc/php5-common/examples/php.ini-development
/usr/share/php5/php.ini-production
/usr/share/php5/php.ini-production-dist
/usr/share/php5/php.ini-production.cli
/var/www/php.ini

Step 2 Edit php.ini file

$ vim /etc/php5/apache2/php.ini

Step 3 Find upload max file size and update it as you required

post_max_size = 8M
upload_max_filesize = 2M
max_execution_time = 30
max_input_time = 60
memory_limit = 8M

after completion of the above step restart your apache to take effect.

Now the question is where to find php.ini File?, There are two ways, local Wamp Server and Live server.

Local Wamp Server
if you are using wamp then you should click on your wamp icon

after that PHP section then select php.ini

Live Server
if you are using live server then this depends on your hosting, like if you are using shared hosting then you can’t find php.ini, alternate you can use .httacces file to add some code like that.

Update .htaccess file

php_value upload_max_filesize 128M
php_value post_max_size 128M
php_value memory_limit 256M
php_value max_execution_time 300
php_value max_input_time 300

Or if you are using WordPress then you can also increase memory by wp-config.php, simply put this code on that file

@ini_set( ‘upload_max_filesize’ , ‘128M’ );
@ini_set( ‘post_max_size’, ‘128M’);
@ini_set( ‘memory_limit’, ‘256M’ );
@ini_set( ‘max_execution_time’, ‘300’ );
@ini_set( ‘max_input_time’, ‘300’ );

I hope above mention steps help you to Increase your PHP upload memory and now you are able to upload your heavy Files. If you like this article to then share it with the social platform you can also join our social community.