Have you read the UPGRADING file? it explains which files to backup. Copy those files (and any additional modifications that you made to OTRS) to a new "test" system. Then test to make sure everything is working, fix things that aren't and make sure you document what you have done. Repeat with migrating the live system using the notes you made from the test system. On 1 April 2013 00:36, Kaushal Shriyan wrote:

On Fri, Mar 29, 2013 at 11:28 AM, Kaushal Shriyan < kaushalshriyan@gmail.com> wrote:

...

Hi,

I am migrating from the current live setup of OTRS Application Version 3.1.7 running on CentOS Linux Version 5.8 server to a new OTRS server running OTRS Application Version 3.2.3 hosted on CentOS 6.4.

Any prerequisites i need to take care while migrating from one box to another box? I can think of only backing up MySQL DB otrs and populating the data to the new box. Any thing else to be taken care to carryout the migration without any glitch, please suggest.

Regards,

Kaushal

Hi,

checking in again for my earlier post to this mailing list. Any suggestions please?

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

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.

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