[rt-users] backing up db

[Rich West]

This is always a good idea.  Just for the heck of it, IMHO it is good practice to do:
mysqldump -u<root user> -p<password> -A | gzip > database_backup.gz

I do this on a nightly basis just before my backups (to tape) go start up.

-Rich
--
Richard West                    mailto:rwest at wesmo.com
Wesmo Computer Services         http://www.wesmo.com
Register Your Domain For          Got TV?
As Little As $14.95/yr!           Get your .TV!


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