Hi all, 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. 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) Thanks a lot Marco Cintolesi NOC Director. TECHNETS - Italy ----- Original Message ----- From: "Vladimir Gerdjikov" To: Sent: Wednesday, November 06, 2002 12:54 PM Subject: [otrs] clear start

Hi all, at last I'm at the end of test period with OTRS and must implement this system in real work (fortunately :D) My question is: how can I drop only queues and ticket# with test data and leave any valued data? Sorry for this question, but I'm not SQL master :) Is it enough to drop (which?) databases? I intend to use "OpenTRS-schema.mysql.sql" as example (my server is MySQL) for commands.

Any help (ideas) will be appreciated.

Best regards,

Vladimir Gerdjikov, Communication and NOS Manager, HebrosBank Head Office, +359 32/903435, +359 88 578 458 mailto:vladimir.gerdjikov@hebros.bg ----------------------------------------------------------------

_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs