On 28 Apr 2009, at 7:01 pm, Asif Iqbal wrote: > On Tue, Apr 28, 2009 at 1:53 PM, Tom Lahti <t...@bitstatement.net> > wrote: > >>> Ok now that upgrade completed on the test system, I now see 5000 >>> more >>> tickets already >>> created on the production systems. Do I have to redo this whole >>> thing? I >>> have binlog enabled >>> since the beginning of the original instance. How do I append >>> those new >> 500 >>> tickets? >>> I guess I am now on a catchup game :-) >> >> You're gonna have to shut down the production instance during the >> conversion. No way around it. Stay late and bring pizza and beer ;) > > > > I am looking for a way to use the binlogs to add the new tickets to > the test > server > > That way I don't have to dump the whole database again and the > import and > all that > from the beginning.
There's no simple way to do that because the schema has changed, so your binary logs can't be applied to the new server. When I updated our RT I did what the last person suggested; shut down the production RT, dump, load, upgrade, bring up new production RT. Tim -- The Wellcome Trust Sanger Institute is operated by Genome Research Limited, a charity registered in England with number 1021457 and a company registered in England with number 2742969, whose registered office is 215 Euston Road, London, NW1 2BE. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com