From owner-freebsd-isp@FreeBSD.ORG Thu Apr 24 11:18:25 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 5672D37B401 for ; Thu, 24 Apr 2003 11:18:25 -0700 (PDT) Received: from strangelove.glynjones.com (63-212-172-50.glynjones.com [63.212.172.50]) by mx1.FreeBSD.org (Postfix) with ESMTP id D618843F75 for ; Thu, 24 Apr 2003 11:18:24 -0700 (PDT) (envelope-from dave-lists@glynjones.com) Received: from (unknown.Level3.net) [63.208.110.135] by strangelove.glynjones.com with esmtp (Exim 3.34 ) id 198lIe-0001gL-00; Thu, 24 Apr 2003 11:18:24 -0700 From: Dave Byrne To: freebsd-isp@freebsd.org In-Reply-To: References: Content-Type: text/plain Organization: Message-Id: <1051208959.1314.21.camel@dave.glynjones.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.3- Date: 24 Apr 2003 11:29:19 -0700 Content-Transfer-Encoding: 7bit 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 18:18:25 -0000 MyISAM table types are machine independent. ISAM table types are machine dependent. Either way if you are moving from x86 to x86 then it doesn't matter what type of tables you are using in mysql. Just copy the database files over. Just make sure that mysql is not running when you try and copy them, it'll corrupt them. Dave On Thu, 2003-04-24 at 09:50, Jim Sander wrote: > > mysql daemon will not start > > Piece o' cake man... > > I've copied many a binary .ISM file between systems and never had a > problem- I just recently copied quite a lot of data from a redhat box to > FreeBSD without any glitches simply by scp'ing the whole mysql datadir. I > doubt Debian does anything too terribly different. > > MySQL has its own data file format(s) so there's not a lot to worry > about except in HUGE version jumps. MySQL is *very* good about remaining > backward compatible, and allowing for easy "upconvert" of data. > > The only trouble I've had has been moving database files from FreeBSD > to a Mac OS-X, and I suspect that's more an Endian-ness issue. > > -=Jim=- > > _______________________________________________ > 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" >