How To Increase Import Size Limit PhpMyadmin On Vps

 Increase Import Size Limit PhpMyadmin
Increase Import Size Limit PhpMyadmin

Friends,When you want to retrieve the database in PhpMyadmin after Migration/Backup then Restore, but the import limit is limited, of course the limit is 2M/8M less for the old website/lots of databases on the website.

Don’t worry, we can maximize it by editing php.ini

1.Check the installed php version ;

php –version

 Increase Import Size Limit PhpMyadmin
Increase Import Size Limit PhpMyadmin

2. nano /etc/php/7.4/apache2/php.ini      (adjust to php version)

Find the text below ; (Ctrl+W) together, for easy search in nano editor ;

file_uploads = On

upload_max_filesize =128M

max_file_uploads =20

post_max_size =256

max_execution_time = 300

3. add .htaccess ; (this option is only an addition to the most important step no 2)

copy and paste scripts below add under .htaccess

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

Then restart apache ;

systemctl restart apache2 

Enter again into PhpMyadmin then see the maximum import ;

 Increase Import Size Limit PhpMyadmin
Increase Import Size Limit PhpMyadmin

How now is the PhpMyadmin Import Limit to 128 M, it’s easy, not now to maximize the limit in PhpMyadmin.

Hopefully this short article about Increase Import Size Limit PhpMyadmin can be useful for all of you.

https://coblong.com

About the author

I Like Linux Although Sometimes it's Hard I Believe I Can, I Definitely Can and I Should be Able to. I Also Loves Websites, Php, Python and All About Linux.

Leave a Comment