<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=FR-CA link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span lang=EN-CA style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Btw, you can also use --skip-extended-insert in mysqldump to insert
statement always insert a single row at a time.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal style='margin-left:35.4pt'><b><span lang=EN-US
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] <b>On Behalf Of </b>andrew
fay<br>
<b>Sent:</b> July 30, 2008 11:02<br>
<b>To:</b> Drew Barnes<br>
<b>Cc:</b> rt-users@lists.bestpractical.com<br>
<b>Subject:</b> Re: [rt-users] RT 3.6.4 MYSQL Backup*RESOLVED*<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal style='margin-left:35.4pt'><o:p> </o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:0cm;margin-right:0cm;margin-bottom:
12.0pt;margin-left:35.4pt'><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>added
max_allowed_packet = 16M<br>
<br>
to my.ini<br>
<br>
The restore operation finished successfully!<br>
<br>
Thanks guys,<br>
<br>
Andy<br>
<br>
> Date: Wed, 30 Jul 2008 10:50:16 -0400<br>
> From: barnesaw@ucrwcu.rwc.uc.edu<br>
> To: andrew.fay@hotmail.co.uk<br>
> CC: torsten.brumm@kuehne-nagel.com; robert@ml.erje.net;
rt-users@lists.bestpractical.com<br>
> Subject: Re: AW: Re: [rt-users] RT 3.6.4 MYSQL Backup<br>
> <br>
> I have never used Mysql under windows, but from MySQL's documentation:<br>
> When the MySQL server starts on Windows, it looks for options in two <br>
> files: the my.ini file in the Windows directory, and the C:\my.cnf file.<br>
> <br>
> <br>
> andrew fay wrote:<br>
> > Hi,<br>
> ><br>
> > Sorry I should of been more clear,<br>
> ><br>
> > I have RT 3.6.4 running on an ubuntu machine and backing up the <br>
> > catalog using the Mysql Administrator. When I am restoring it I am <br>
> > restoring on to a windows xp pro machine running a mysql server. I <br>
> > have tried restoring attachments after and before just by itself with
<br>
> > no luck.<br>
> ><br>
> > How would I set the max_allowed_packet option under windows? I have <br>
> > access to the console and am using WAMP to run my mysql server.<br>
> ><br>
> > Thanks!<br>
> ><br>
> > Andy<br>
> ><br>
> >
------------------------------------------------------------------------<br>
> > Subject: AW: Re: [rt-users] RT 3.6.4 MYSQL Backup<br>
> > Date: Wed, 30 Jul 2008 16:39:02 +0200<br>
> > From: torsten.brumm@Kuehne-Nagel.com<br>
> > To: barnesaw@ucrwcu.rwc.uc.edu<br>
> > CC: andrew.fay@hotmail.co.uk; rt-users@lists.bestpractical.com<br>
> ><br>
> > Yes, like drew said, this can also be the problem, i remeber from our
<br>
> > last move.<br>
> > We increased the max_allowed_packet option massivly, but also without
<br>
> > success. We did the trick by dumping only the attachments table and <br>
> > 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>; <br>
> > 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 <br>
> > 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>
> > > <http://clk.atdmt.com/UKM/go/101719965/direct/01/><br>
> > > ------------------------------------------------------------------------<br>
> > ><br>
> > > _______________________________________________<br>
> > > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users<br>
> > ><br>
> > > Community help: http://wiki.bestpractical.com<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 http://rtbook.bestpractical.com<br>
> ><br>
> > --<br>
> > Drew Barnes<br>
> > Applications Analyst<br>
> > Network Resources Department<br>
> > Raymond Walters College<br>
> > University of Cincinnati<br>
> ><br>
> ><br>
> ><br>
> >
------------------------------------------------------------------------<br>
> > Find out how to make Messenger your very own TV! Try it Now! <br>
> > <http://clk.atdmt.com/UKM/go/101719648/direct/01/><br>
> <br>
> -- <br>
> Drew Barnes<br>
> Applications Analyst<br>
> Network Resources Department<br>
> Raymond Walters College<br>
> University of Cincinnati<br>
> <o:p></o:p></span></p>
<div class=MsoNormal align=center style='margin-left:35.4pt;text-align:center'><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
<hr size=2 width="100%" align=center>
</span></div>
<p class=MsoNormal style='margin-left:35.4pt'><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'>Get Messenger on your Mobile! <a
href="http://clk.atdmt.com/UKM/go/101719964/direct/01/" target="_new">Get it
now!</a><o:p></o:p></span></p>
</div>
</body>
</html>