<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 10.00.9200.16576"></HEAD>
<BODY>
<DIV><SPAN class=128250115-23052013><FONT size=2 face=Arial>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.</FONT></SPAN></DIV>
<DIV><SPAN class=128250115-23052013><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=128250115-23052013><FONT size=2 face=Arial>So now I get to
rebuild the RT configuration again (not that bad).</FONT></SPAN></DIV>
<DIV><SPAN class=128250115-23052013><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=128250115-23052013><FONT size=2 face=Arial>The command I'm
using to backup my RT databases is:</FONT></SPAN></DIV>
<DIV><SPAN class=128250115-23052013><FONT size=2 face=Arial>mysqldump -u root
-p<PASSWORD>
--result-file=G:\BACKUPS\RT-<DATE>.sql</FONT></SPAN></DIV>
<DIV><SPAN class=128250115-23052013><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=128250115-23052013><FONT size=2 face=Arial>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.</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV align=left><FONT size=2 face=Arial>Stephen Cena</FONT></DIV>
<DIV align=left><FONT size=2 face=Arial>QVII</FONT></DIV>
<DIV align=left><FONT size=2 face=Arial>MIS/IT Dept</FONT></DIV>
<DIV align=left><FONT size=2 face=Arial>850 Hudson Ave.</FONT></DIV>
<DIV align=left><FONT size=2 face=Arial>Rochester, NY. 14620</FONT></DIV>
<DIV align=left><FONT size=2 face=Arial>585-544-0450 x300</FONT></DIV>
<DIV align=left><FONT size=2 face=Arial><A
href="mailto:sjc@qvii.com">sjc@qvii.com</A></FONT></DIV>
<DIV align=left><FONT size=2 face=Arial>"Thank you for helping us help you help
us all."</FONT></DIV>
<DIV align=left><FONT size=2 face=Arial>--For email related issues, please
contact <A
href="mailto:postmaster@qvii.com">postmaster@qvii.com</A></FONT></DIV>
<DIV align=left><FONT size=2 face=Arial></FONT> </DIV>
<DIV align=left><FONT size=2 face=Arial></FONT> </DIV>
<DIV> </DIV></BODY></HTML>