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 [email protected] "Thank you for helping us help you help us all." --For email related issues, please contact [email protected]
-- RT Training in Seattle, June 19-20: http://bestpractical.com/training
