Setup phpMyAdmin Max Upload Size

When working on a website when you setup phpMyAdmin to easily manage your open-source MySQL database. When it comes time to import large databases you may encounter a problem and receive this rather vague error:

phpMyAdmin Upload Error

The phpMyAdmin configuration has two default values: a maximum file size and a maximum file size that is allowed to be transmitted. These variables can be easily changed to fix this error and solve the upload limit issues. Here’s how its done:

  1. Open the php.ini configuration file with notepad or similar
  2. Find the line starting with: post_max_size
    This represents the amount of megabytes that the server will accept to upload. Make sure you increase this to the size of the file you want to upload. The line would look something like this if I were uploading an approximate 8M file: post_max_size = 8M
  3. Find the line starting with: upload_max_filesize
    This represents the maximum amount of megabytes that the server will accept to upload. Make sure you increase this to the size of the file you want to upload. The line would look something like this if I were uploading an approximate 8M file: post_max_size = 8M
  4. Save the file
  5. Restart your server

php.ini

post_max_size = 8M
upload_max_filesize = 2M

You must ensure that post_max_size is the same or larger than upload_max_filesize.

These settings can be changed globally by changing them in your php.ini file (its

location varies depending on your system). After changing the settings, remember to

restart your web server.

You may be able to change these settings locally if you’re using Apache by putting

a “.htaccess” file in phpMyAdmin’s directory. The contents of the file should be:

php_value post_max_size 20M
php_value upload_max_filesize 20M

Change ’20M’ to however large you want it to be. You shouldn’t need to restart the web

server for these changes to take effect, but if you start getting Internal Server

Errors (500) then this probably means your host does not allow you to change these

settings and you need to remove those settings.

phpmyadmin max upload size
phpmyadmin max upload
phpmyadmin upload limit
phpmyadmin upload size
phpmyadmin configuration
access to phpmyadmin
setup phpmyadmin