[How To] Increase import file size in phpmyadmin

[How To] Increase import file size in phpmyadmin



By default when you want to import sql file in phpmyadmin, in “File to Import:” section you can see (Max: 2MiB).
That is php’s file upload limit. To increase it find php.ini file

$ locate php.ini
/etc/php5/apache2/php.ini
/etc/php5/cli/php.ini
/usr/share/doc/php5-common/examples/php.ini-development
/usr/share/php5/php.ini-production
/usr/share/php5/php.ini-production-dist
/usr/share/php5/php.ini-production.cli
/var/www/php.ini
root@Gevorg-VM:/home/gevorgh#

and edit

$ vim /etc/php5/apache2/php.ini

Find these variables and change to values you want:

post_max_size = 8M
upload_max_filesize = 2M
max_execution_time = 30
max_input_time = 60
memory_limit = 8M

Then restart apache to take effect

$ service apache restart

For this example I used Ubuntu 11.10

4 Responsesto “[How To] Increase import file size in phpmyadmin”

  1. Arjun says:

    use “getid” in place of “vim”

  2. Hi Gev, great to see another Armenian posting on here. Also we should mention if you increase the upload_max_filesize say above 8mb then you need to also increase the post_max_size to be greater than 8mb or else it caps you at 8mb.

  3. Jody Banim says:

    is this for Ubuntu too?

  4. Kishor says:

    You may also follow the steps shown in Video

    https://www.youtube.com/watch?v=h1NebNFW0mA

Leave a Reply

Your email address will not be published. Required fields are marked *