Ticket bodies?

RT Users
1

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.

Erik Parker

2

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 |

3

Yep, I found them there shortly after. Thank you Jon> 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 |
±-------------------------------------------------------------+

Erik Parker