Tickets backup for another OTRS instance

Moderator: crythias

Locked
altronrain
Znuny newbie
Posts: 14
Joined: 15 Apr 2019, 11:07
Znuny Version: 6.0.17
Real Name: Kirill
Company: NumaTech

Tickets backup for another OTRS instance

Post by altronrain »

Hello!
I'm interested in finding a way to backup tickets only from one OTRS instance (that is prod solution) to Test-OTRS instance (where were implemented a bunch of changes to many aspects including queues, services, sla, acl, ga, dynamic_fields..e.t.c) and how risky is to do such thing?
I don't want to make all the changes from test-OTRS to prod by hands (again). But available options only [fullbackup & notfullbackup (what's the difference between them?) + dbonly]. Dbnly also contains queue, service, sla, ga e.t.c info so I can't use it.
Are there any solutions? Or, perhabs, list of tables that should be dumped to backup/restore tickets only? (Also it would be great option to use 'from the box' community-edition distribution)
zzz
Znuny superhero
Posts: 914
Joined: 15 Dec 2016, 15:13
Znuny Version: All
Real Name: Emin
Company: Efflux GmbH
Contact:

Re: Tickets backup for another OTRS instance

Post by zzz »

Hey,

Exporting and importing tables from two different systems can really mess up the data integrity.

You're almost always better of copying your settings from one system to the other, sorry.
Be aware that you can export/import the system configuration and ACLs, which should help you a little bit.

Best regards
Emin
Professional Znuny and OTRS services: efflux.de | efflux.de/en/

Free and premium add-ons: German | English
altronrain
Znuny newbie
Posts: 14
Joined: 15 Apr 2019, 11:07
Znuny Version: 6.0.17
Real Name: Kirill
Company: NumaTech

Re: Tickets backup for another OTRS instance

Post by altronrain »

Ough. Okay. I understand.
Yesterday I tried Import/Export addition but it couldn't install properly, so I gave up this idea.
root
Administrator
Posts: 4251
Joined: 18 Dec 2007, 12:23
Znuny Version: Znuny and Znuny LTS
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: Tickets backup for another OTRS instance

Post by root »

altronrain wrote: 31 Jan 2020, 08:17 Yesterday I tried Import/Export addition but it couldn't install properly, so I gave up this idea.
Hi,

If the ImportExport add-on could help, I'm pretty sure zzz would have mentioned it. This is only about importing or exporting ConfigurationItems.

- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know where it goes ?
Locked