Re: MySQL Variable size usage in shell prompt

2015-06-16 Thread wagnerbianchi.com
Not sure about the size of your dump, but, have you tried to set the new value on the server and client side? you can increase max_allowed_packet up to 1G. Let us know after you tried that, and maybe other guys have another solution to share... -- *Wagner Bianchi, +55.31.8654.9510* Oracle ACE

MySQL Variable size usage in shell prompt

2015-06-16 Thread Manivannan S
Hi, When we are trying to restore the dump file, we got an error like Got a packet bigger than max_allowed_packet. Then we increased max_allowed_packet variable size and passed along with MySQL restore command. mysql -max_allowed_packet=128M -uusername -p /path/file.sql After increasing the