[rt-users] RT 3.6.4 MYSQL Backup

Wed Jul 30 11:03:24 EDT 2008

Is it really a prod system? Do you think its a good idea to use it under xampp or mamp? And windows? ;-)

________________________________

Von: rt-users-bounces at lists.bestpractical.com 
An: andrew.fay at hotmail.co.uk ; barnesaw at ucrwcu.rwc.uc.edu ; robert at ml.erje.net 
Cc: rt-users at lists.bestpractical.com 
Gesendet: Wed Jul 30 16:48:01 2008
Betreff: Re: [rt-users] RT 3.6.4 MYSQL Backup 

Under xampp the is also a my.ini i think.

________________________________

Von: andrew fay 
An: Ham MI-ID, Torsten Brumm; barnesaw at ucrwcu.rwc.uc.edu ; robert at ml.erje.net 
Cc: rt-users at lists.bestpractical.com 
Gesendet: Wed Jul 30 16:46:44 2008
Betreff: RE: AW: Re: [rt-users] RT 3.6.4 MYSQL Backup 

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/> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080730/bc4c02d3/attachment.htm>