[rt-users] RT 3.6.4 MYSQL Backup

[Ham MI-ID, Torsten Brumm]

Hi fay,
I'm not sure about the error, but if you can't restore the attachments table correctly, then your rt install will be broken, rt stores not only the things we know as attachment like .doc or .xls, he also stores each mail text etc there. A broken table is not good in this way ;-)

Can you try as workaround to stop your mysqld copy over the plain files (innodb etc) to the new server an try to start there.

Tob

________________________________

Von: rt-users-bounces at lists.bestpractical.com 
An: rt mailing list 
Gesendet: Wed Jul 30 16:11:20 2008
Betreff: [rt-users] RT 3.6.4 MYSQL Backup 


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


________________________________

Get Hotmail on your Mobile! Try it Now! <http://clk.atdmt.com/UKM/go/101719965/direct/01/> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080730/a28cc26f/attachment.htm>