[opencms-dev] Large import fails

[David García González]

If you want to clone a cms portal, you could try: 
Clone your bd schema
Copy the folder of the opencms application and rename it
Modify the web.xml and rename the <param-value>
Modify the opencms.properties to point to the new bd schema.

***********************************************************************

David García González

Fundación CTIC

-Centro Tecnológico de la Información y la Comunicación-

E-mail: david.garciag at fundacionctic.org

Tfno: +34 984 29 12 12

-Parque Científico y Tecnológico Gijón-Asturias-Spain

www.fundacionctic.org

***********************************************************************

 

-----Mensaje original-----
De: opencms-dev-bounces at opencms.org [mailto:opencms-dev-bounces at opencms.org] En nombre de spyros
Enviado el: jueves, 23 de marzo de 2006 13:07
Para: The OpenCms mailing list
Asunto: Re: [opencms-dev] Large import fails

Someone from the list once reported that there is a memory problem with 
OpenCms preventing the import of large databases with this procedure. 
Although they are exported normally, they cannot be imported. How about 
trying normal mysqldump?

Spyros Michas



----- Original Message ----- 
From: "Sami Honkonen" <sami.honkonen at ri.fi>
To: <opencms-dev at opencms.org>
Sent: Thursday, March 23, 2006 11:27 AM
Subject: [opencms-dev] Large import fails


>I did a database export on a production server and the size of the file
> is close to 500 MB. When I try to import it to a development server with
> "Import File from Server" the import just stops at file number 912 out
> of 7062 and the "OK" button becomes enabled.
>
> My max_allowed_packet in /etc/my.cnf is set to 1000M. I also tried
> adding "ulimit -d 256000" to the beginning of the mysqld_safe script as
> instructed here
> http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html
> but it doesn't help.
>
> I tried an older backup (size about 240 MB) and it fails in the same
> way. If I try a test database (size 17MB) the import finishes correctly.
>
> There's nothing in the logs files of OpenCMS or MySQL about the failure.
>
> The production server is running 6.0.4 and the development server is
> running 6.2 beta. MySQL daemon on both is 4.1.
>
> Are there some other restrictions (on top of max_allowed_packet) that
> I'm not aware of?
>
> -- 
> Sami Honkonen
> Reaktor Innovations Oy, http://www.ri.fi
> sami.honkonen at ri.fi
> +358 40 535 3463
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev
> 


_______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/mailman/listinfo/opencms-dev