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 increase file size. for that, you have to follow some steps.

Top 150+ High PR DoFollow Backlinks Site List

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

Increase Import File Size in phpMyAdmin
  • Save

after that PHP section then select php.ini

Increase Import File Size in phpMyAdmin
  • Save

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’ );

Also Read:
How to make a festival wishing website script free
How to use WhatsApp without a phone number

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.

Photo of author

Virender Jaiswal

Hi My Name is Virender Jaiswal, I have 10+ years of experience in Web Development industry. In this Blog I Publish Article of web development, SEO, Affiliate Marketing, WordPress Tutorial, Ecommerce Store, Blogging and many more.

2 thoughts on “How to Increase Import File Size in phpMyAdmin [WordPress]”

    • You can easily increase your upload limit with the help of this article. I show you all ways which helps to increase the upload limit.

      Reply

Leave a Comment

subscribe newsletter

Subscribe Our Newsletter For Freebies, Hosting Deals & SEO Tools Offers!

Join My Mailing List For WordPress News And Tips!

Share via
Copy link
Powered by Social Snap