[opencms-dev] Re: max_allowed_packet query

[Joe Desbonnet]

Thanks for the suggestions. None worked I'm afraid :(.  In the end I
recreated the db by extracting the table definitions with "mysqldump
--no-data" (thankfully my faulty disk was still functional enough for
this) and then overwriting the *.MYD and *.MYI files in
/var/lib/mysql/opencms which I got from a recent file system backup.

So this leaves me with a very important question which I have found no
answer to either on the mysql.com site or by googling around.

Question: How do you (reliably) dump a OpenCms MySQL database so that
it can be read back (by the same version)?  It does not seem possible
with the tools privided in the MySQL distribution!!

Joe.






On 11/10/05, Thomas März <thomas.maerz at gmail.com> wrote:
> Joe Desbonnet <jdesbonnet at gmail.com> writes:
>
> > But still I get
> > ERROR 1153 (08S01) at line 45: Got a packet bigger than
> > 'max_allowed_packet' bytes
>
> Does this help?
>
> ,----[ http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html ]
> | Yeah, I've been having the same problem with installing 4.1.7 from
> | source too. I too tried incrementing the packet limit upwards (right
> | up to 1GB) and it still say the packet was too large.
> |
> | The solution is a simple one though thankfully.
> |
> | In the my.cnf file, there is a line that reads:
> |
> | net_buffer_length = 8K
> |
> | It was on line 34 in the my.cnf file on my system. Simply remove that
> | line and you will no longer have the error message. Whether or not
> | this will cause problems elsewhere or not remains to be seen, as I've
> | just this minute found this solution.
> `----
>
>
> Regards,
> Thomas
>
>
>
> _______________________________________________
> This mail is send to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://mail.opencms.org/mailman/listinfo/opencms-dev
>