[rt-users] How-to delete tickets?

[Scott McClelland]

An easy way to do it is with a mysql database backup and restore.  

If you have webmin installed, 
http://www.webmin.com/
you can use it to create a backup script.  Then you can cat the file, and
pipe it to grep to remove lines from a specific user or with a string (like
"this is a test"), and redirect it to another file.  Then use the newly
created file to restore (without the unwanted messages).

I had to do this after we installed an anti-virus program, and the server
sent a few hundred messages to the rt e-mail account.

Otherwise check out the MySql documentation to do a backup and restore.

/*------------------------------------------
Scott McClelland, CNE, MCP
Network Administrator
Vortex Data Systems 
http://www.vortexdata.com
--------------------------------------------*/

>