Edit my.cnf file

You are here: Index > Webuzo > General Support > Topic : Edit my.cnf file

Edit my.cnf file, my.cnf file path (3 Replies, Read 20612 times)

maverick129	# January 13, 2018, 8:45 pm
Group: Member Post Group: Newbie Posts: 3 Status:	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
IP: --

Edit my.cnf file

lesmond	# January 13, 2018, 11:31 pm \| Post: 1
Group: Member Post Group: Working Member Posts: 105 Status:	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
IP: --

Edit my.cnf file

maverick129	# January 14, 2018, 5:40 am \| Post: 2
Group: Member Post Group: Newbie Posts: 3 Status:	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
IP: --

Edit my.cnf file

webuzo_manager	# January 15, 2018, 5:59 am \| Post: 3
Group: Member Post Group: Elite Member Posts: 268 Status:	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
IP: --

Jump To :

Users viewing this topic
	1 guests, 0 users.

All times are GMT. The time now is April 16, 2024, 10:08 pm.

Queries: 11 | Page Created In:0.026