[rt-users] backing up db

[sam at eigroup.com]

Backing up the database is probably just a case of:

/path/to/mysql/bin/mysqldump rt | gzip > rt.sql.gz

(the gzip is not compulsory ;)

then when you've reinstalled or moved or whatever, you can squirt this file into your new mysql install (I can't remember how to do this but I know it's not too tricky, look here http://www.mysql.com/doc/ for clues)

YMMV

Sam ;)

According to Ashby Gochenour:

> Hey Guys,
> I am preparing to do the RT move from one machine to another.
> I'm getting mysql installed on the new machine and will next install
> RT on the new machine (and apache).
> 
> I understand now, that the transactions directory holds the text of the
> tickts. However, I still don't understand what the 'database' consists of. 
> 
> If I want to do a backup of the database (before the move), is that done
> via mysql commands or is it done by taring a directory or something
> similar?
> 
> Thanks for all the help!
> 
> Ashby Gochenour
> 
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users

-- 
Windows has detected that you have moved your mouse; you must restart 
your computer for changes to take effect...

--

********************************************************************************
*                                                                              *
* This email and any files transmitted with it are confidential and intended   *
* solely for the use of the individual or entity to whom they are addressed.   *
* Copying this email or in any way disseminating its content to any other      *
* person is strictly prohibited.  If you have received this email in error     *
* please notify postmaster at eigroup.com                                         *
*                                                                              *
********fnord*******************************************************************