<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7652.24">
<TITLE>AW: Re: [rt-users] RT 3.6.4 MYSQL Backup</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>Yes, like drew said, this can also be the problem, i remeber from our last move.<BR>
We increased the max_allowed_packet option massivly, but also without success. We did the trick by dumping only the attachments table and restored them later. Was working fine.<BR>
<BR>
----- Originalnachricht -----<BR>
Von: Drew Barnes <barnesaw@ucrwcu.rwc.uc.edu><BR>
An: Ham MI-ID, Torsten Brumm<BR>
Cc: andrew.fay@hotmail.co.uk <andrew.fay@hotmail.co.uk>; rt-users@lists.bestpractical.com <rt-users@lists.bestpractical.com><BR>
Gesendet: Wed Jul 30 16:35:44 2008<BR>
Betreff: Re: [rt-users] RT 3.6.4 MYSQL Backup<BR>
<BR>
I was thinking that it might be the max_allowed_packet option my.cnf. <BR>
Recent versions of MySQL seem to export the tables in what my office has<BR>
begun to refer to as "massive dumps," that is, One insert statement for<BR>
each table.<BR>
<BR>
One other option would be not exporting the data in binary format, IIRC.<BR>
<BR>
<BR>
Ham MI-ID, Torsten Brumm wrote:<BR>
><BR>
> Hi fay,<BR>
> I'm not sure about the error, but if you can't restore the attachments<BR>
> table correctly, then your rt install will be broken, rt stores not<BR>
> only the things we know as attachment like .doc or .xls, he also<BR>
> stores each mail text etc there. A broken table is not good in this<BR>
> way ;-)<BR>
><BR>
> Can you try as workaround to stop your mysqld copy over the plain<BR>
> files (innodb etc) to the new server an try to start there.<BR>
><BR>
> Tob<BR>
><BR>
> ------------------------------------------------------------------------<BR>
> *Von*: rt-users-bounces@lists.bestpractical.com<BR>
> *An*: rt mailing list<BR>
> *Gesendet*: Wed Jul 30 16:11:20 2008<BR>
> *Betreff*: [rt-users] RT 3.6.4 MYSQL Backup<BR>
> 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<BR>
> 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`<BR>
> 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<BR>
> 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<BR>
> this DB on top of a new installation ? will I just not be able to<BR>
> browse the attachments or will this make it so we are unable to browse<BR>
> the old tickets?<BR>
><BR>
> I say this because the new RT will be running on a different machine<BR>
> as this one is coming to the end of it's life unfortunatly.<BR>
><BR>
> Thanks in advance!<BR>
><BR>
> Andy<BR>
><BR>
> ------------------------------------------------------------------------<BR>
> Get Hotmail on your Mobile! Try it Now!<BR>
> <<A HREF="http://clk.atdmt.com/UKM/go/101719965/direct/01/">http://clk.atdmt.com/UKM/go/101719965/direct/01/</A>><BR>
> ------------------------------------------------------------------------<BR>
><BR>
> _______________________________________________<BR>
> <A HREF="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</A><BR>
><BR>
> Community help: <A HREF="http://wiki.bestpractical.com">http://wiki.bestpractical.com</A><BR>
> Commercial support: sales@bestpractical.com<BR>
><BR>
><BR>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<BR>
> Buy a copy at <A HREF="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</A><BR>
<BR>
--<BR>
Drew Barnes<BR>
Applications Analyst<BR>
Network Resources Department<BR>
Raymond Walters College<BR>
University of Cincinnati<BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>