From owner-freebsd-isp@FreeBSD.ORG Thu Apr 24 04:58:48 2003 Return-Path: Delivered-To: freebsd-isp@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id BCD9A37B401 for ; Thu, 24 Apr 2003 04:58:48 -0700 (PDT) Received: from psknet.com (grant.psknet.com [63.171.251.10]) by mx1.FreeBSD.org (Postfix) with SMTP id AFA4E43FE9 for ; Thu, 24 Apr 2003 04:58:47 -0700 (PDT) (envelope-from troy@psknet.com) Received: (qmail 42812 invoked by uid 85); 24 Apr 2003 11:58:46 -0000 Received: from troy@psknet.com by grant.psknet.com by uid 25 with qmail-scanner-1.16 (no such scanner Clear:. Processed in 0.393686 secs); 24 Apr 2003 11:58:46 -0000 Received: from pool-141-152-70-166.roa.east.verizon.net (HELO abyss) (141.152.70.166) by tc.psknet.com with SMTP; 24 Apr 2003 11:58:46 -0000 From: "Troy Settle" To: Date: Thu, 24 Apr 2003 07:59:07 -0400 Message-ID: <003701c30a58$e98408d0$aa8ffea9@abyss> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2616 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 In-Reply-To: <00b601c309f8$4ca7a360$a977ca41@vsis169> Importance: Normal Subject: RE: disaster recovery after rootkit -> MySQL and user accounts X-BeenThere: freebsd-isp@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Internet Services Providers List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 24 Apr 2003 11:58:49 -0000 If the old MySQL server is still running, who cares what version it is? Just do a dump and import. Sure, it'll take a bit longer, but it's version independent and your data is in a safe format for the transition. -- Troy Settle Pulaski Networks http://www.psknet.com 540.994.4254 ~ 866.477.5638 Pulaski Chamber 2002 Small Business Of The Year > -----Original Message----- > From: owner-freebsd-isp@freebsd.org > [mailto:owner-freebsd-isp@freebsd.org] On Behalf Of Lewis Watson > Sent: Wednesday, April 23, 2003 8:28 PM > To: freebsd-isp@FreeBSD.ORG > Subject: Re: disaster recovery after rootkit -> MySQL and > user accounts > > > > > >Hi Dave, > > >I moved from RH Linux to FreeBSD and it seems that I just shut down > MySQL > > >tar'd the MySQL database directory and untarred on the new FreeBSD > server. > > >Had no problem with the user table or anything of the > sort. While this > > >doesn't cover everything it perhaps will help on the MySQL > aspect of > > >things. > > > > I believe this will work if the versions of MySQL are the same or > perhaps > > close, but may not work with different versions of MySQL the further > > the versions are apart the less likely it is to work. MySQL > of course > > recommends a MySQLdump followed by a restore but that is probably > > not feasible in this case. > > > > Lyle Evans > > lyle@rackears.com > > http://www.rackears.com > > > I really wished I would have mentioned this :-). I think > there might have > been a few releases between the two but not many... I stayed on the > 3.xx.xx track during this move. Since then I upgraded to 4.xx and have > been very happy but I would keep the versions as close as possible for > this move... > Good point!! > Lewis > > _______________________________________________ > freebsd-isp@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-isp > To unsubscribe, send any mail to "freebsd-isp-unsubscribe@freebsd.org" >