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]; [email protected] > > 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]>; > [email protected] <[email protected]> > 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 _______________________________________________ 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
