[rt-users] ticket bodies?

[Jon Stearley]

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   |
+--------------------------------------------------------------+