[opencms] [opencms-dev] (6b3) MySql Backup problem, one long line --> SOLUTION

[Jorge Gonzalez]

The backup was totally correct, but the mysql server config was not, so here
is the solution


mysql> SET max_allowed_packet = 100 * 1024 * 1024;

With this command, the server doesn't break the connection when the backup
contains "long" lines.

This is a simple thing, but i've lost a lot of time with it :(

There are a pair of files in the default opencms distribution (jar files)
larger than 1 MB (this is the max allowed by the default server)

SO if you are recovering a backup, use the above command, or put this into
my.ini file

----
set-variable=max_allowed_packet=100M
----

By the way, the backup was ok until i did a complete site sync, it stopped
with a disgusting "Resource not found" error.

Long live to the mysql documentation !

Bye


-----Mensaje original-----
De: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org]En nombre de Jorge Gonzalez
Enviado el: jueves, 12 de mayo de 2005 19:10
Para: 'The OpenCms mailing list'
Asunto: RE: [opencms] [opencms-dev] (6b3) MySql Backup problem, one long
line


I've found exactly 2 long lines problem in the mysql database.

After deleting both lines in the backup file, the restore procedure is
correct.

It only happens to me ?



_______________________________________________
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