[opencms-dev] Re: max_allowed_packet query

[Joe Desbonnet]

I've started a Wiki page on this topic:
http://cms.galway.net:8080/OpenCmsWiki/Wiki.jsp?page=HowtoBackup
Please feel free to edit. If it becomes a good Howto doc I'll post
back to the list.

I did find more doc on backups after a more thorough scan of the MySQL
documentation:
http://dev.mysql.com/doc/refman/4.1/en/backup.html

It seems my best bet is to use the 'mysqlhotcopy' script. As stated
earlier mysqldump produces an output which does not always re-import
(even after the my.cnf adjustments)

Joe

On 11/11/05, Joe Desbonnet <jdesbonnet at gmail.com> wrote:
> 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
> >
>