[rt-users] backing up db

[Ashby Gochenour]

Rich and All,
Thank you for the advice.
I'm not experienced with mySQL: would the -u -p be for the root sql user
or for the actual root login on the machine? Also, does anyone know where
to find the sql u/p? I set up mysql with a debian package and picked the
passwords and I have no idea what I set them :( (I've never connected to
the rt database)

Thanks again for all the help guys!

Ashby Gochenour

On Thu, 5 Apr 2001, Rich West wrote:

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