Btw, you can also use --skip-extended-insert in mysqldump to insert statement always insert a single row at a time.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of andrew fay Sent: July 30, 2008 11:02 To: Drew Barnes Cc: rt-users@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: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > CC: [EMAIL PROTECTED]; [EMAIL PROTECTED]; rt-users@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: [EMAIL PROTECTED] > > To: [EMAIL PROTECTED] > > CC: [EMAIL PROTECTED]; rt-users@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 <[EMAIL PROTECTED]> > > An: Ham MI-ID, Torsten Brumm > > Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>; > > rt-users@lists.bestpractical.com <rt-users@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*: [EMAIL PROTECTED] > > > *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: [EMAIL PROTECTED] > > > > > > > > > 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/>
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com