Hi,
Please follow below steps
- Have you restarted mysql service after changing my.ini?
- Run query
SHOW GLOBAL VARIABLES LIKE 'max_allowed_packet'
and see the value. It should be 500MB (Equal bytes)
- If the above query does not return 500M, then try running
SET GLOBAL max_allowed_packet = 500 * 1024 * 1024
. Then repeat step 2.
- If value is shown as 500 M repeat your file upload.
Or
To resolve your issue you have to increase the value of the innodb_log_file_size option in your my.ini
below the [mysqld]
section. Its default value is 48M
. Setting it to
innodb_log_file_size=256M
I hope this will help you out.