Manivannan S MySQL Variable size usage in shell prompt
Jun 16, 2015; 13:28
Manivannan S
MySQL Variable size usage in shell prompt
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 -u<username> -p < /path/file.sql
After increasing the variable size also we got same error. Later we converted the value from 128M to 134217728 Bytes, then restore done successfully.
In case my.cnf, when we pass the value for MySQL variables its accepting either in bytes, K, M or G.
Why it doesn't consider128M in MySQL prompt while restoring the dump file?
Regards Manivannan S
DISCLAIMER: This email message and all attachments are confidential and may contain information that is Privileged, Confidential or exempt from disclosure under applicable law. If you are not the intended recipient, you are notified that any dissemination, distribution or copying of this email is strictly prohibited. If you have received this email in error, please notify us immediately by return email to mailadmin@spanservices.com and destroy the original message. Opinions, conclusions and other information in this message that do not relate to the official of SPAN, shall be understood to be nether given nor endorsed by SPAN.
Jun 16
wagnerbianchi.com Re: MySQL Variable size usage in shell prompt
Jun 16, 2015; 10:36
wagnerbianchi.com
Re: MySQL Variable size usage in shell prompt
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!