<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>
Hi,<br><br>I am having a problem backing up the mysql db for our RT installation,<br><br>I can back it up correctly into an SQL file.. move it to another machine with mysql running and get errors trying to restore it.<br><br>If I remove the attachments table from the restore then it restores fine,<br><br>the error i get is :<br><br>Error while executing this query:INSERT INTO `rtdb`.`Attachments` VALUES (179,455,178,'','',NULL,'text/plain','none'<br><br>etc and then a mess of illedgable text.<br><br>I am looking into upgrading to the latest version of RT but I don't want to do this until I can back everything up correctly.<br><br>Ideally I would like the attachments backed up though.<br><br>If
the attachment table can't be saved what will happen if I restore this
DB on top of a new installation ? will I just not be able to browse the
attachments or will this make it so we are unable to browse the old
tickets?<br><br>I say this because the new RT will be running on a different machine as this one is coming to the end of it's life unfortunatly.<br><br>Thanks in advance!<br><br>Andy<br /><hr />Get Messenger on your Mobile! <a href='http://clk.atdmt.com/UKM/go/101719964/direct/01/' target='_new'>Get it now!</a></body>
</html>