Softaculous

Topic : Edit my.cnf file

Posted By: maverick129 on January 13, 2018, 8:45 pm

Hi,

I am trying to upload a db file of size 22 MB. Each time I try to upload either through PhpMyAdmin or by MySql Workbench, the upload fails.

I have updated the php.ini file with the below changes

max_execution_time = 6000
max_input_time = 5000
max_input_vars = 5000
memory_limit = 256M
upload_max_filesize = 100M
post_max_size = 100M
max_file_uploads = 20

The above changes have updated the PhpMyAdmin File Upload size limit, however, it still times out.

Please find attached screenshots of the error message in PhpMyAdmin and MySql Workbench

I did some google search on my issue and the probable solution is to update the
"max_allowed_packet" which is in the my.cnf file.

I am unable to find the file.

Could someone guide me to the path or an alternative solution to the issue?

Thanks

Posted By: lesmond on January 13, 2018, 11:31 pm | Post: 1

root/usr/local/webuzo/conf/webuzo/emps/ php.ini

find.. "upload_max_filesize" change too 500M or whatever limit you need

; Maximum allowed size for uploaded files.
; http://php.net/upload-max-filesize
upload_max_filesize = 50M

from command line enter service webuzo restart

[root@server ~]# service webuzo restart

-----------------------
Buildz Hosting

Posted By: maverick129 on January 14, 2018, 5:40 am | Post: 2

Thank you for the details. I have already updated the same.

The issue, it seems, is not of the size of the file, but more of time limit.

From the details in PhpMyAdmin, it gives out error "#2006 - MySQL server has gone away"

similarly in Mysql Workbench, I get error "ERROR 1153 (08S01) at line 680: Got a packet bigger than 'max_allowed_packet' bytes

Operation failed with exitcode 1"

For the above, I believe I need to edit the my.cnf file to update the max_allowed_packet.

Could you guide me to the correct path to edit the same?

Thanks

Posted By: webuzo_manager on January 15, 2018, 5:59 am | Post: 3

Hi maverick129,

If you are using MySQL 5.5:
/usr/local/apps/mysql/etc/

for MySQL 5.6:
/usr/local/apps/mysql56/etc/

PS: If you are uploading anything above 10 - 15 MB I suggest that you upload it via FTP and import it via Command Line