[rt-users] RT 3.6.4 MYSQL Backup

[andrew fay]

Hi,

I am having a problem backing up the mysql db for our RT installation,

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.

If I remove the attachments table from the restore then it restores fine,

the error i get is :

Error while executing this query:INSERT INTO `rtdb`.`Attachments` VALUES  (179,455,178,'','',NULL,'text/plain','none'

etc and then a mess of illedgable text.

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.

Ideally I would like the attachments backed up though.

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?

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.

Thanks in advance!

Andy

_________________________________________________________________
100’s of Nikon cameras to be won with Live Search
http://clk.atdmt.com/UKM/go/101719808/direct/01/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080730/c18055bb/attachment.htm>