Hi Marco, hi Vladimir, On Wed, Nov 06, 2002 at 07:36:01PM +0100, Marco Cintolesi wrote:
i have the same problem of Vladimir........i have to move the test server to production next week and i have to clear all the tickets WITHOUT clearing queues, users, groups, responses etc...
I think a function to "wipe" all the content (read "tickets" with history) and not the configuration (read "queues, users, groups etc") may be very very useful.
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/) Done.
I'd like also to see the "graphics" of the relations between tables in the MySQL db.....maybe i can try to make that (without a due date hehehe)
Jaa! :-)
Thanks a lot
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- Old programmers never die. They just branch to a new address.