phpMyAdmin Max Filesize Help

cabaz777

Im having problems retoring a 15mb sql through phpMyAdmin
Even I changed php.ini to allow max_upload_filesize to 20M and restarted the server, phpmyadmin still says it can only import a sql file up to 2mb only.

Im not sure where phpmyadmin looks to say just 2Mb, I believe it was just the php.ini so Im frozen here.
btw, phpmyadmin launchs from plesk 7.5 reloaded

Any help would be appreciated.
txs in adv

bogu

View source the page from phpmyadmin that upload the sql file; u will notice a field just like this one:

<input type="hidden" name="MAX_FILE_SIZE" value="2097152" />

Change that value, and it should be ok ...

iamtheironman

I'm not sure this is the fix but check the value of max allowed packet in Phpmyadmin system variables. Go to the main page and click "Show MySQL system variables".

The default size is something like 16mb I think.
I don't know how one changes it though.