PhpMyAdmin allows you to import only 2 MB – 8 MB file by default. This was creating problems for me when I wanted to restore a WordPress database which was around 10 MB.
The solution is really simple just to go to the php.ini file and edit the arguments
usually in your
c:\xampp\php folder (if using xampp) or
C:\wamp\bin\apache\apache2.2.22\bin (if using wamp)
So in your php.ini change import the desired value for example 20 MB by searching for post_max_size, upload_max_filesize:
post_max_size = 20M
upload_max_filesize = 20M
Now try using the import function again and it will work for sure. Simple and easy 🙂
For more information visit the official site: http://www.phpmyadmin.net/
