[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

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

3 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?

Leave a Reply

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