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?
--
RT Training in Seattle, June 19-20: http://bestpractical.com/training
