Hi, I would like to increase the file size to import text files in phpMyAdmin. I tried changing the php.ini file, upload_max_filesize = 10M post_max_size = 20M and memory_limit=64M But it doesnt work. Please help, how to increase the file size in phpMyAdmin. Thanks, Rosy.
Did u reboot apache? Also, phpMyAdmin may have its own settings that are independent of PHP's defaults.
mysql also has a setting in my.cnf
On *nix edit the /etc/my.cnf
under the [mysqld] section change or add max_allowed_packet=20MB
or how ever big you want it.
you will need to restart/reload mysql for this to take effect.
Hope that helps.
