[rt-users] Proper way to backup RT Database

[Cena, Stephen (ext. 300)]

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.
 
Stephen Cena
QVII
MIS/IT Dept
850 Hudson Ave.
Rochester, NY. 14620
585-544-0450 x300
sjc at qvii.com
"Thank you for helping us help you help us all."
--For email related issues, please contact postmaster at qvii.com
 
 
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130523/2fda2277/attachment.htm>