Welcome Guest. Please Login or Register  


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



Threaded Mode | Print  

 Edit my.cnf file, my.cnf file path (3 Replies, Read 1411 times)
maverick129
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
Group: Member
Post Group: Working Newbie
Posts: 87
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
IP: --   

Edit my.cnf file
maverick129
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
nikhil.m
Group: Webuzo Team
Post Group: Elite Member
Posts: 252
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: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is August 18, 2018, 2:01 pm.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.434