Since phpMyAdmin is written in php, all we need to do is change the file upload limit in the php.ini file. On CentOS and RHEL distributions, this file is located in /etc/php.ini
Find this section:
;;;;;;;;;;;;;;;;
; File Uploads ;
;;;;;;;;;;;;;;;;
; Whether to allow HTTP file uploads.
file_uploads = On
; Temporary directory for HTTP uploaded files (will use system default if not
; specified).
;upload_tmp_dir =
; Maximum allowed size for uploaded files.
upload_max_filesize = 2M
Change the 2M to something bigger, say 100M.
Please note that this is a server wide setting and as such will affect all users on your server.
Where’s the phpmyadmin.ini file?
I don’t think phpmyadmin.ini exists, Carols. Instead there’s a config file for phpMyAdmin as explained in this article: http://wiki.phpmyadmin.net/pma/Quick_Install#Manually – but I”m not sure if you can change the upload limit just for phpMyAdmin.
I’ll amend my post to reflect this, thanks for bringing it up.