max_allowed_packet ??

[seachen]

Unable to restore database sherly_bbs.sql to sherly_bbs : ERROR 1153 (08S01) at line 1949 in file: '/home/sherly/backups/backup/sherly_bbs.sql': Got a packet bigger than 'max_allowed_packet' bytes

May i know how to solved this?

 

[Michael.Terence]

That variable is set in your my.cnf file

find / -name my.cnf

 

[seachen]

It show this, after that what should I do?

Can you guide me? Thanks

 

[Michael.Terence]

nano /etc/my.cnf

Decide how large of a packet you want to accept, replace X with the number you decide on and paste into the my.cnf file

max_allowed_packet = XM

instructions for saving and exiting nano are displayed at the bottom of your terminal window.

 

[seachen]

nano /etc/my.cnf

Decide how large of a packet you want to accept, replace X with the number you decide on and paste into the my.cnf file

max_allowed_packet = XM

instructions for saving and exiting nano are displayed at the bottom of your terminal window.

Hi, Thannk.

But it show as below when i type nano cmd.

 

[nobaloney]

By default DirectAdmin doesn't include a full my.cnf file. See this article in the knowledgebase for more information.

Jeff