[opencms-dev] max_allowed_packet query

[Arash Kaffamanesh]

Joe,

Have a look on this threads on our site:

http://www.pomegranate.de:9000/cms/forum/viewthread?thread=17

http://www.pomegranate.de:9000/cms/forum/viewthread?thread=23

HTH,

Kind Regards,
Arash

-----Original Message-----
From: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] On Behalf Of Joe Desbonnet
Sent: Donnerstag, 10. November 2005 17:20
To: The OpenCms mailing list
Subject: [opencms-dev] max_allowed_packet query


Sorry not stricly OpenCms related: I'm doing an emergency restoration of
an OpenCms installation after a disk failure. Despite being good about
keeping regular backups I had never tried doing a test restoration.

My problem is the dreated max_allowed_packet of MySQL. I'm just focusing
on importing CMS_OFFLINE_CONTENTS right now. Its a 67MB file. I've set
/etc/my.conf as follows:

[mysql.server]
user=mysql
basedir=/var/lib
max_allowed_packet=298M

And my import command loooks like this:
 mysql --user=root --max_allowed_packet=210M opencms <
CMS_OFFLINE_CONTENTS.dump

But still I get
ERROR 1153 (08S01) at line 45: Got a packet bigger than
'max_allowed_packet' bytes

I'm missing something... (?)

Thanks
Joe.


_______________________________________________
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