[rt-users] Proper way to backup RT Database

[Jim Brandt]

On 5/23/13 11:05 AM, Cena, Stephen (ext. 300) wrote:
> I just lost my Service Desk database. I did a test creating a ticket,
> saw what I wanted, then restored the database previously. It didn't
> restore. So I dropped all tables, did a restore. RT broke. I checked the
> tables restored & it only did 45 out of 68.
> So now I get to rebuild the RT configuration again (not that bad).
> The command I'm using to backup my RT databases is:
> mysqldump -u root -p<PASSWORD> --result-file=G:\BACKUPS\RT-<DATE>.sql
> Is this how the database should get backed up? Why did it only back up
> some tables but not all? I've already got one RT system with a borked
> database I haven't been able to get help with yet. With the scale of the
> one I'm going to be launching I CANNOT afford for backups/restores to
> not work.

There are docs on backups here that might help:

http://bestpractical.com/rt/docs/latest/backups.html

Those dump just the RT database.

Also, maybe show the command you used to restore from the backup? Any 
errors during the dump or restore?