[rt-users] RT 3.6.4 MYSQL Backup

[Drew Barnes]

I have never used Mysql under windows, but from MySQL's documentation:
When the MySQL server starts on Windows, it looks for options in two 
files: the my.ini file in the Windows directory, and the C:\my.cnf file.


andrew fay wrote:
> Hi,
>
> Sorry I should of been more clear,
>
> 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.
>
> How would I set the max_allowed_packet option under windows? I have 
> access to the console and am using WAMP to run my mysql server.
>
> Thanks!
>
> Andy
>
> ------------------------------------------------------------------------
> Subject: AW: Re: [rt-users] RT 3.6.4 MYSQL Backup
> Date: Wed, 30 Jul 2008 16:39:02 +0200
> From: torsten.brumm at Kuehne-Nagel.com
> To: barnesaw at ucrwcu.rwc.uc.edu
> CC: andrew.fay at hotmail.co.uk; rt-users at lists.bestpractical.com
>
> Yes, like drew said, this can also be the problem, i remeber from our 
> last move.
> 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.
>
> ----- Originalnachricht -----
> Von: Drew Barnes <barnesaw at ucrwcu.rwc.uc.edu>
> An: Ham MI-ID, Torsten Brumm
> Cc: andrew.fay at hotmail.co.uk <andrew.fay at hotmail.co.uk>; 
> rt-users at lists.bestpractical.com <rt-users at lists.bestpractical.com>
> Gesendet: Wed Jul 30 16:35:44 2008
> Betreff: Re: [rt-users] RT 3.6.4 MYSQL Backup
>
> I was thinking that it might be the max_allowed_packet option my.cnf. 
> Recent versions of MySQL seem to export the tables in what my office has
> begun to refer to as "massive dumps," that is, One insert statement for
> each table.
>
> One other option would be not exporting the data in binary format, IIRC.
>
>
> Ham MI-ID, Torsten Brumm wrote:
> >
> > Hi fay,
> > I'm not sure about the error, but if you can't restore the attachments
> > table correctly, then your rt install will be broken, rt stores not
> > only the things we know as attachment like .doc or .xls, he also
> > stores each mail text etc there. A broken table is not good in this
> > way ;-)
> >
> > Can you try as workaround to stop your mysqld copy over the plain
> > files (innodb etc) to the new server an try to start there.
> >
> > Tob
> >
> > ------------------------------------------------------------------------
> > *Von*: rt-users-bounces at lists.bestpractical.com
> > *An*: rt mailing list
> > *Gesendet*: Wed Jul 30 16:11:20 2008
> > *Betreff*: [rt-users] RT 3.6.4 MYSQL Backup
> > 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
> >
> > ------------------------------------------------------------------------
> > Get Hotmail on your Mobile! Try it Now!
> > <http://clk.atdmt.com/UKM/go/101719965/direct/01/>
> > ------------------------------------------------------------------------
> >
> > _______________________________________________
> > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> >
> > Community help: http://wiki.bestpractical.com
> > Commercial support: sales at bestpractical.com
> >
> >
> > Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> > Buy a copy at http://rtbook.bestpractical.com
>
> --
> Drew Barnes
> Applications Analyst
> Network Resources Department
> Raymond Walters College
> University of Cincinnati
>
>
>
> ------------------------------------------------------------------------
> Find out how to make Messenger your very own TV! Try it Now! 
> <http://clk.atdmt.com/UKM/go/101719648/direct/01/>

-- 
Drew Barnes
Applications Analyst
Network Resources Department
Raymond Walters College
University of Cincinnati