Re: [otrs] OTRS 3.2.3 on CentOS Linux Version 6.4 server edition

Yes that should work for a simple backup/restore of the database. As far as I know the files are for the following (someone correct me if I'm wrong)... Kernel/Config.pm contains your main config. Kernel/Config/GenericAgent.pm contains any generic agent jobs you have manually created. Kernel/Config/Files/ZZZAuto.pm contains any configuration settings from SysConfig. Steve On 6 April 2013 11:44, Kaushal Shriyan wrote:

On Sat, Apr 6, 2013 at 12:35 PM, Steven Carr wrote:

...

On 6 April 2013 05:11, Kaushal Shriyan wrote:

...

Hi Again,

I have installed the new version OTRS 3.2.4 on CentOS 6.4. I have doubt about backup. I have taken MySQL Data Backup as of now from the old server. Not sure how do i backup all queues,agents,groups,email address details and etc.... from the old server and populate it to the new server so that i do not miss any piece which were configured in the old server.

Please suggest.

Regards,

Kaushal

That information is all stored in the database, the only additional things you need to backup/copy across are those mentioned in the UPGRADING document.

Kernel/Config.pm Kernel/Config/GenericAgent.pm Kernel/Config/Files/ZZZAuto.pm var/*

Though be careful with copying all of var/* as some stuff might have changed in the new version, I tend to copy just var/article, var/log and any custom files I've put into var/httpd/htdocs, but YMMV.

Make sure you change Config.pm to reflect the new database location. And then follow the UPGRADING guide on running the various scripts to migrate the database from your old version to the new version.

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

Thanks Steven for clear and precise explanation. Much appreciated. Have few questions about database backup. I have taken backup of otrs database using the below command

On the old server *mysqldump -u root -p password otrs > /tmp/otrs.sql*

On the new server *mysql -u root -p password otrs < /tmp/otrs.sql*

Is the above method the right way of backing mysql data on the old server and restoring it to the new server? Also please help me understand the significance and purpose of the below files

Kernel/Config.pm Kernel/Config/GenericAgent.pm Kernel/Config/Files/ZZZAuto.pm

Thanks and Regards,

Kaushal

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs