baby names

Registered
Feb 18, 2011
2
0
51
I own an unmanaged LINUX VPS with cpanel



in one websie i'm getting following error

Invalid query: Got a packet bigger than 'max_allowed_packet' bytes

Where to edit and how to edit through whm
 

cPanelTristan

Quality Assurance Analyst
Staff member
Oct 2, 2010
7,607
40
248
somewhere over the rainbow
cPanel Access Level
Root Administrator
The file is at /etc/my.cnf in root SSH, since the full path wasn't noted previously. Upon making any changes to /etc/my.cnf file, please restart MySQL for those changes to take effect.
 
Jul 30, 2011
11
0
51
India
cPanel Access Level
Root Administrator
The file is at /etc/my.cnf in root SSH, since the full path wasn't noted previously. Upon making any changes to /etc/my.cnf file, please restart MySQL for those changes to take effect.
Oops I missed that, thanks for stepping in and providing the OP with the complete path.
 

james-r

Registered
Dec 28, 2012
1
0
1
cPanel Access Level
DataCenter Provider
Hello people!

I see this forum gives some information; however, its seems to be lacking easy steps for a beginner. I have an article on this that shows how to cat, nano, and view through shell the my.cnf settings.

/http://www.inmotionhosting.com/support/website/general-server-setup/edit-mysql-my-cnf

The my.cnf may not have the setting in it when you view it through shell.

Viewing the MySQL variables through shell.
  1. Login to your server via SSH
  1. Type the following command: myasqladmin variables
You can also view the settings for MySQL in PhpMyAdmin.
  1. Log into your phpMyAdmin
  1. Click the Variables tab at the top right.

That way you can get the exact MySQL settings available to edit in the my.cnf as well.

Regards,
James R


Oops I missed that, thanks for stepping in and providing the OP with the complete path.
 

linux7802

Well-Known Member
Dec 14, 2007
232
1
68
cPanel Access Level
Root Administrator
I would like to recommend you, if you are not sure about correct mysql parameter for your server which will increase the server performance then run the mysqltunner and make the necessary changes in the my.cnf file but make sure that you have taken a backup for the original my.cnf file. The incorrect values in the my.cnf file can cause the major problem to your server performance, so be careful while making changes.