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


Posted

in

, ,

by

Tags:

Comments

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

  1. Tix Avatar
    Tix

    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 Avatar
    Marques

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

  3. thor Avatar
    thor

    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. Required fields are marked *

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