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 Comments

  1. Tix says:

    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. Marques says:

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

  3. thor says:

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

Leave a Comment