From owner-freebsd-questions Thu Dec 27 10:17:38 2001 Delivered-To: freebsd-questions@freebsd.org Received: from mta07-svc.ntlworld.com (mta07-svc.ntlworld.com [62.253.162.47]) by hub.freebsd.org (Postfix) with ESMTP id E338137B41B for ; Thu, 27 Dec 2001 10:17:31 -0800 (PST) Received: from lungfish.ntlworld.com ([62.253.145.15]) by mta07-svc.ntlworld.com (InterMail vM.4.01.03.23 201-229-121-123-20010418) with ESMTP id <20011227181730.YJNR327.mta07-svc.ntlworld.com@lungfish.ntlworld.com>; Thu, 27 Dec 2001 18:17:30 +0000 Received: from tuatara.goatsucker.org (tuatara.goatsucker.org [192.168.1.6]) by lungfish.ntlworld.com (8.11.3/8.11.3) with ESMTP id fBRIHTn31209; Thu, 27 Dec 2001 18:17:29 GMT (envelope-from scott@tuatara.goatsucker.org) Received: (from scott@localhost) by tuatara.goatsucker.org (8.11.6/8.11.6) id fBRIG5501859; Thu, 27 Dec 2001 18:16:05 GMT (envelope-from scott) Date: Thu, 27 Dec 2001 18:16:04 +0000 From: Scott Mitchell To: Jason Halbert Cc: questions@FreeBSD.ORG Subject: Re: Moving MySQL Databases Message-ID: <20011227181604.K1003@localhost> References: <20011227174410.D399637B41C@hub.freebsd.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <20011227174410.D399637B41C@hub.freebsd.org>; from jason@jason-n3xt.org on Thu, Dec 27, 2001 at 05:42:29PM +0000 X-Operating-System: FreeBSD 4.4-RELEASE i386 Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG On Thu, Dec 27, 2001 at 05:42:29PM +0000, Jason Halbert wrote: > Does anyone know how to move MySQL databases from one box to another? > I am upgrading my server and I would like to move my Qmail and > Apache databases over. It would be a nightmare to have to recreate > them from scratch. > > Thanks for any help. > > Jason > jason@jason-n3xt.org If it's the same version of MySQL on both boxes you can simply copy the database files to wherever the new setup wants them to be... obviously shut both MySQL instances before trying this :-) I've done this myself, moving to a slightly later version, with no problems whatsoever. If the versions are sufficiently different that the new install can't read the old database files (I've no idea how back-compatible MySQL's files are) there are some tools in the MyQSL distribution for exporting and importing databases, that will probably do what you want. They're documented in the online manuals as mysql.com, although I've never tried them myself. HTH, Scott -- =========================================================================== Scott Mitchell | PGP Key ID | "Eagles may soar, but weasels Cambridge, England | 0x54B171B9 | don't get sucked into jet engines" scott.mitchell@mail.com | 0xAA775B8B | -- Anon To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message