Freezy old 3.0 pandora

[daniels]

Hi everybody.

Is it possible to freezy my 3.0 version of pandora?

I would like to install the new 3.1 version, but the upgrade is not good to me (my database is not very well after the last upgrades). So, I would like to do a new fresh install, but I would like to keep the old (3.0) pandora to get the historical data. Is it possible? Is there a easy way to do that? Any suggestions are welcome.

Regards.

[rnovoa]

Hi Daniels,

I would try to dump the contents of the data tables (tagente_datos, tagente_datos_inc and tagente_datos string), tagente_modulo, tagente_estado and tagente and try to restore them in a clean 3.1 install.

[raul]

I had pandora 2.0 and 3.0 in the same box, using different databases. In the installation you can choose which is the pandora database, by default pandora.

BE CAREFUL WITH THIS PROCEDURE, AT YOUR OWN RISK (TEST BEFORE):

- First, put the console in a different directory

- Second, in the console install, you can use a pandora31 as new database.

- Third, in the pandora_server_installer script, change the values of the default variables (by example, I had:

PANDORA_SPOOL=/var/spool/pandora31 (if you want to have both at the same time)
PANDORA_HOME=/usr/share/pandora_server31
PANDORA_CFG_DIR=/etc/pandora31
PANDORA_LOG=/var/log/pandora31
PANDORA_SERVER=/etc/init.d/pandora_server31
PANDORA_CFG_FILE=/etc/pandora/pandora_server31.conf

You don't need to change tentacle

- Fourth, edit /etc/pandora/pandora_server31.conf to change the database from pandora to pandora31

Maybe I'm missing something... Anyway, you can backup your data and use the RENAME MySQL command to rename your current database and make a new install...

[daniels]

Thank you guys. I will try your suggestions and post here the results.

Regards.