<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>
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>> <br><br /><hr />Get Messenger on your Mobile! <a href='http://clk.atdmt.com/UKM/go/101719964/direct/01/' target='_new'>Get it now!</a></body>
</html>