Hi There,
How to clean up the OTRS database in order to exclude all tickets before the system goes live?
tks!
Gustavo
OTRS Database clean up
Moderator: crythias
-
crythias
- Moderator
- Posts: 10170
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: OTRS Database clean up
use generic agent to delete tickets.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
-
gmarassi
- Znuny newbie
- Posts: 2
- Joined: 10 Jul 2011, 17:13
- Znuny Version: 3.0.7
- Real Name: Gustavo
- Company: ARPIA
Re: OTRS Database clean up
Hi,
I could clear the database as follows:
"The easiest way to delete "all" tickets (without new db init) is:
a) Connect to MySQL via mysql-shell (mysql -u <otrs-user> -p <otrs-db>)
b) mysql> DELETE FROM ticket
c) mysql> DELETE FROM article
d) mysql> DELETE FROM ticket_history
e) Delete all plain emails form filesystem
(rm -rf /opt/OpenTRS/var/article/2002/) "
this correct?
tks!
I could clear the database as follows:
"The easiest way to delete "all" tickets (without new db init) is:
a) Connect to MySQL via mysql-shell (mysql -u <otrs-user> -p <otrs-db>)
b) mysql> DELETE FROM ticket
c) mysql> DELETE FROM article
d) mysql> DELETE FROM ticket_history
e) Delete all plain emails form filesystem
(rm -rf /opt/OpenTRS/var/article/2002/) "
this correct?
tks!