OTRS Instance Rehosting

Moderator: crythias

Locked
tripti_rai2005
Znuny newbie
Posts: 67
Joined: 14 Mar 2012, 15:08
Znuny Version: OTRS2

OTRS Instance Rehosting

Post by tripti_rai2005 »

I have currently one OTRS instance running on one machine, but I am planning on installing a new (fresh) OTRS instance on a larger server and rehosting the fresh system with entire database and configurations from my current instance of OTRS. Therefore I am interested in hearing about best practices and experiences on how to export data from one OTRS instance to another.

- Can I just export the whole database?
- Or should I rather export data from a few tables?

All suggestions are welcome
■ TRIPTI RAI // PROJECT ENGINEER, ETIM GTEC
Office: +91 20 66056464 //Mobile: +91 9503019176 // // Whirlpool Corporation // www.WhirlpoolCorp.com
Whirlpool Corporation // www.WhirlpoolCorp.com
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: OTRS Instance Rehosting

Post by jojo »

you need to export the whole database
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
tripti_rai2005
Znuny newbie
Posts: 67
Joined: 14 Mar 2012, 15:08
Znuny Version: OTRS2

Re: OTRS Instance Rehosting

Post by tripti_rai2005 »

in the fresh instance when i try to import the whole database.A lot of primary key violations occur.So should i empty all the tables in fresh instance and then import database.
■ TRIPTI RAI // PROJECT ENGINEER, ETIM GTEC
Office: +91 20 66056464 //Mobile: +91 9503019176 // // Whirlpool Corporation // www.WhirlpoolCorp.com
Whirlpool Corporation // www.WhirlpoolCorp.com
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: OTRS Instance Rehosting

Post by jojo »

the dump should contain the creat table statement. The target database should be empty (no tables at all)
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
tripti_rai2005
Znuny newbie
Posts: 67
Joined: 14 Mar 2012, 15:08
Znuny Version: OTRS2

Re: OTRS Instance Rehosting

Post by tripti_rai2005 »

For The file system (what makes the program run, and its accompanying config files.) replication.
My fresh instance is hosted on Windows OS and the current OTRS instance is installed on Linux box which has to be replicated onto my fresh instance.
How do you think is it going to affect the directory structure and entire file system directory replication.
■ TRIPTI RAI // PROJECT ENGINEER, ETIM GTEC
Office: +91 20 66056464 //Mobile: +91 9503019176 // // Whirlpool Corporation // www.WhirlpoolCorp.com
Whirlpool Corporation // www.WhirlpoolCorp.com
Locked