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 -the process is described in the post on joomla security patch where you can read the steps to backup your database – 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
php.ini file can be found into
C:\Program Files\PHP5. installed, then probably the
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
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.
*This post is intended to help users import their databases into local installations. In web hosting things differ from host to host. A good practice is to check your phpMyAdmin limit (my web host limit is 51MB) located in your
phpMyAdmin and selecting the tab
Import. If your database is larger than the limit of your web host you should message them for arrangements.