Import database larger then 2mb via phpMyAdmin

To import databases larger then 2MB you need to edit /etc/php5/<flavour>/php.ini.

Edit the existing parameters in  php.ini, if they does not exists add them at the end of the file:
post_max_size = 50M
upload_max_filesize = 50M

Restart the webserver. If you are using Apache: sudo /etc/init.d/apache2 restart

, ,

3 responses to “Import database larger then 2mb via phpMyAdmin”

  1. Thank you so much for this information. I was desparate because I thought I wouldn’t be able to restore the one database backup I had (larger than 2MB)!

  2. Worked for me, but my php.ini file was just located in /ect.

  3. my database is 200 mb file size and this method is not working on me

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.