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

2010-06-18

in

LAMP, phpMyAdmin, Ubuntu

by

Daniel

Tags:

Comments

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

Tix

2012-06-26

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)!
Marques

2014-06-20

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

2015-06-11

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

Leave a Reply

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