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/
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com