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
OTRS Instance Rehosting
Moderator: crythias
-
- Znuny newbie
- Posts: 67
- Joined: 14 Mar 2012, 15:08
- Znuny Version: OTRS2
OTRS Instance Rehosting
■ TRIPTI RAI // PROJECT ENGINEER, ETIM GTEC
Office: +91 20 66056464 //Mobile: +91 9503019176 // // Whirlpool Corporation // www.WhirlpoolCorp.com
Whirlpool Corporation // www.WhirlpoolCorp.com
Office: +91 20 66056464 //Mobile: +91 9503019176 // // Whirlpool Corporation // www.WhirlpoolCorp.com
Whirlpool Corporation // www.WhirlpoolCorp.com
Re: OTRS Instance Rehosting
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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- Znuny newbie
- Posts: 67
- Joined: 14 Mar 2012, 15:08
- Znuny Version: OTRS2
Re: OTRS Instance Rehosting
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
Office: +91 20 66056464 //Mobile: +91 9503019176 // // Whirlpool Corporation // www.WhirlpoolCorp.com
Whirlpool Corporation // www.WhirlpoolCorp.com
Re: OTRS Instance Rehosting
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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- Znuny newbie
- Posts: 67
- Joined: 14 Mar 2012, 15:08
- Znuny Version: OTRS2
Re: OTRS Instance Rehosting
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.
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
Office: +91 20 66056464 //Mobile: +91 9503019176 // // Whirlpool Corporation // www.WhirlpoolCorp.com
Whirlpool Corporation // www.WhirlpoolCorp.com