How to purge our MySQL OTRS DB...

Moderator: crythias

Locked
juanperiz
Znuny newbie
Posts: 3
Joined: 27 Oct 2011, 21:03
Znuny Version: 3.0.10
Real Name: Sebastián Maruca
Company: Universidad de Buenos Aires

How to purge our MySQL OTRS DB...

Post by juanperiz »

Hi to all OTRS' Members and Staff... I'd like to know if is there any concern purgeing OTRS DB... would do any harm just to use traditional method of delete every record keeping DB structure intact??? Is there any other correct way to get it done (considering FREE MySQL doesn't handle partiotions)???? Thanks a lot!
Top
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:
Contact jojo

Re: How to purge our MySQL OTRS DB...

Post by jojo »

If you wan't to delete the tickets, use the generic agent.

If you want to go back to the initial setup, you need to drop the database and run the 3 initial database scripts after creating a new 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
Top
juanperiz
Znuny newbie
Posts: 3
Joined: 27 Oct 2011, 21:03
Znuny Version: 3.0.10
Real Name: Sebastián Maruca
Company: Universidad de Buenos Aires

Re: How to purge our MySQL OTRS DB...

Post by juanperiz »

(Wow... that was very fast for an OpenSource forum! ;) )... Ok, I didn't know what to do at my Testing ITSM when I realized running "www-root/otrs/installer.pl" won't do the magic I expected to (at a first glance...)

So I'll just stick to CREATE DATABASE otrs; run otrs-schema.mysql.sql, otrs-initial_insert.mysql and otrs-schema-mysql.sql...

Many thanks to all of you!!!
Top
Locked

Return to “General”