[rt-users] RT 3.6.4 MYSQL BackupRESOLVED

Wed Jul 30 13:03:38 EDT 2008

Btw, you can also use --skip-extended-insert in mysqldump to insert
statement always insert a single row at a time.

From: rt-users-bounces at lists.bestpractical.com
[mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of andrew
fay
Sent: July 30, 2008 11:02
To: Drew Barnes
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] RT 3.6.4 MYSQL Backup*RESOLVED*

added max_allowed_packet = 16M

to my.ini

The restore operation finished successfully!

Thanks guys,

Andy

> Date: Wed, 30 Jul 2008 10:50:16 -0400
> From: barnesaw at ucrwcu.rwc.uc.edu
> To: andrew.fay at hotmail.co.uk
> CC: torsten.brumm at kuehne-nagel.com; robert at ml.erje.net;
rt-users at lists.bestpractical.com
> Subject: Re: AW: Re: [rt-users] RT 3.6.4 MYSQL Backup
> 
> 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
> 

________________________________

Get Messenger on your Mobile! Get it now!
<http://clk.atdmt.com/UKM/go/101719964/direct/01/> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080730/1c75ede7/attachment.htm>