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
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 ;
How now is the PhpMyadmin Import Limit to 128 M, it’s easy, not now to maximize the limit in PhpMyadmin.
