[SOLVED] Restore Applications and Config without script ??

[florifreeman]

Hi there !

Is there any chance to restore the Application.tar.gz and the Config.tar.gz without the restore.pl script? I had problems with this script while importing my SQL DB, so i had to import the Database manually using the mysql dumb function. That works pretty good for now.

Problem is: All my config and apps are lost now, but i need them. Any chance to restore them manually, too ?

Regards,
Florian Ewers

[RStraub]

You could just unzip them and then move it to your otrs-home folder.

[florifreeman]

ALL of them ?! Some of them are doubled. For e.g. : Conf.tar => includes /Kernel; Apps.tar => includes /Kernel

You could just unzip them and then move it to your otrs-home folder.

[RStraub]

Well... yes.

The Conf.tar contains (beside other files) the Config.pm (which is important for your DBI), the .xml files (which is important if you added custom .xml files) and the ZZZAuto.pm (which is important for all changes you made in the SysConfig).

Those files are located under: Kernel/Config/Files/...

The Apps.tar contains all the other files, like perl-modules and .dtl / .tt templates.

Those files are also located under Kernel/...

So yes, the "root" folder Kernel does exist in both archives, but they don't contain the same files.

[florifreeman]

Okay, now it is much clearer. Any chance to bring those two folders together ? Just copy & paste via WinSCP ?

[RStraub]

I don't know how WinSCP behaves, it might work.

Or you could use the "mv" command in a shell.

[florifreeman]

I tried to use the restore.pl script again, this time as otrs-user. At the beginning it looks pretty good, he restores Apps & Conf, but then comes :
ERROR 2006 (HY000): MySQL server has gone away
Compress

I have absolutely no clue how to fix this. Checked my DB ten times, user + pw.

[RStraub]

Right, but that is probably not a otrs problem.

Can you open your mysql config file (on ubuntu it's under "/etc/mysql/my.cnf") and look for the entry max_allowed_packet ?

Tell us what's configured there (it appears twice, once for the normal handling, once for dumps).

[florifreeman]

In /mysql/my.cnf i have max_allowed_packet = 16000M (on dump and Fine Tuning). Is this too much ?

The size of my DB is ~900MB´s.

EDIT: Worked ! Put it down to 1200M!

Another Problem (like when importing it by manually) => All my Queues are gone ! Where do i find them to restore ?

EDIT2: RestoreDB and DeleteCache brought back the Queues and stuff

[RStraub]

Why did you put it on 16000M ? I don't know enough about MySQL to know if there's some kind of upper bound but... just as reference, if you install ITSM package it asks you to set it to 20M (or 16?), anyhow, having it factor 1000 higher seems like overkill.

Queues should definitively be contained in the backup. You could open the .sql file and search for:

Code: Select all

INSERT INTO `queue` VALUES

If you're only lacking the Queues, copy that block into a new .sql file and restore that new dump.