<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'><p><font size=2 color=navy face=Arial>
Under xampp the is also a my.ini i think.</font></p>
<p><hr size=2 width="100%" align=center tabindex=-1>
<font face=Tahoma size=2>
<b>Von</b>: andrew fay <andrew.fay@hotmail.co.uk>
<br><b>An</b>: Ham MI-ID, Torsten Brumm; barnesaw@ucrwcu.rwc.uc.edu <barnesaw@ucrwcu.rwc.uc.edu>; robert@ml.erje.net <robert@ml.erje.net>
<br><b>Cc</b>: rt-users@lists.bestpractical.com <rt-users@lists.bestpractical.com>
<br><b>Gesendet</b>: Wed Jul 30 16:46:44 2008<br><b>Betreff</b>: RE: AW: Re: [rt-users] RT 3.6.4 MYSQL Backup
<br></font></p>
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 catalog using the Mysql Administrator. When I am restoring it I am restoring on to a windows xp pro machine running a mysql server. I have tried restoring attachments after and before just by itself with no luck.<br><br>How would I set the <font size="2">max_allowed_packet option under windows? I have access to the console and am using WAMP to run my mysql server.<br><br>Thanks!<br><br>Andy<br></font><br><hr>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>
<meta http-equiv="Content-Type" content="text/html; charset=unicode">
<meta name="Generator" content="Microsoft SafeHTML">
<title>AW: Re: [rt-users] RT 3.6.4 MYSQL Backup</title>
<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/" target="_blank">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" target="_blank">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br>
><br>
> Community help: <a href="http://wiki.bestpractical.com" target="_blank">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" target="_blank">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>
<BR>
<br /><hr />Find out how to make Messenger your very own TV! <a href='http://clk.atdmt.com/UKM/go/101719648/direct/01/' target='_new'>Try it Now!</a></body>
</html>