[rt-users] ticket bodies?
Jon Stearley
jrstear at sandia.gov
Mon Sep 10 13:37:02 EDT 2001
On Mon, Sep 10, 2001 at 10:18:53AM -0700, Erik wrote:
>
> Where are the ticket bodies stored in mysql?
>
> I've looked through every table and can't find them.. I can find the
> subjects, but not the body.
>
> I need to dump the body/info of every ticket to a flat file, but i swear
> it's hiding them.
>
> ANy help would be great.
i'm an rt2 newbie, but it looks like they're in table Attachments to
me (2.0.6). try `mysqldump -pyourpasswdhere rt2 >/tmp/dumped`
--
+--------------------------------------------------------------+
| Jon Stearley (505) 845-7571 (FAX 844-2067) |
| Compaq Federal LLC High Performance Solutions |
| Sandia National Laboratories Scalable Systems Integration |
+--------------------------------------------------------------+
More information about the rt-users
mailing list