How to Increase Import File Size in phpMyAdmin ?

Hi all, 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 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 complition of above step restart your apache to take effect.

Now the question is where to find php.ini File?, There are two way, 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 depend 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, simple 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 uploade memory and now you are able to upload your heavy Files. If you like this article to then share it to social platform you can also join our social community.