The default file import/upload size in phpMyAdmin is 2MB, For expanding file import size You have to do a few changes in php.ini file and restart apache server. Subsequent to changing after parameter you’ll ready to import big .sql file easily.
how to increase import file size in phpmyadmin in wamp, how to increase phpmyadmin import file size cpanel, how to increase upload file size in xampp, increase phpmyadmin upload limit cpanel, increase phpmyadmin upload limit ubuntu, where is php.ini file in xampp
Here i am going to take example of ubantu LAMP server , find php.ini file and open it on any text editor.
sudo vim /etc/php5/apache2/php.ini
if you are using any other server like WAMP, XAMPP similar find php.ini and open it on text editor
Find and Change these values in php.ini file.
post_max_size = 500M
upload_max_filesize = 500M
max_execution_time = 5000
max_input_time = 5000
memory_limit = 1000M
Note: don’t forget to allocate larger value to memory_limit then post_max_size.
Finally restart apache server and your new upload size will be visible on phpMyAdmin file import section, You you can upload larger file.
sudo service apache2 restart