The default import limit in phpMyAdmin is 2MB. In this post I will show how you can overcome this problem and import your large database backup.Let’s take for example that you have successfully exported a backup of your website database in SQL format having a size of 15MB.

With apache2 and php5 installed you need to make three changes in the file sudo gedit /etc/php5/apache2/php.ini. If you have XAMPP installed, then probably the php.ini file can be found into .\xampp\apache\bin\php.ini. For WAMP into C:\Program Files\PHP5.

Search first for the entry post_max_size = 2M where you need to enter a larger number than the size of your database (15M in this case) i.e. 25M, then edit the memory_limit and give a larger number than the one given to post_max_size. Finally, edit the entry upload_max_filesize with a value smaller than post_max_size.

Starting from bigger values the order should go like this 1.memory_limit, 2.post_max_size, 3.upload_max_filesize

Restart apache and you are set.