From owner-freebsd-questions Thu Dec 27 10:28:56 2001 Delivered-To: freebsd-questions@freebsd.org Received: from [209.49.190.34] (fireout.mbakercorp.com [209.49.190.34]) by hub.freebsd.org (Postfix) with SMTP id AB40237B419 for ; Thu, 27 Dec 2001 10:28:53 -0800 (PST) Received: from no.name.available by [209.49.190.34] via smtpd (for hub.FreeBSD.org [216.136.204.18]) with SMTP; 27 Dec 2001 18:28:53 UT Received: from mbakercorp.com (unverified) by MI.mbakercorp.com (Content Technologies SMTPRS 4.2.5) with SMTP id for ; Thu, 27 Dec 2001 13:29:12 -0500 Received: from gatedom-Message_Server by mbakercorp.com with Novell_GroupWise; Thu, 27 Dec 2001 13:28:07 -0500 Message-Id: X-Mailer: Novell GroupWise Internet Agent 5.5.4.1 Date: Thu, 27 Dec 2001 13:27:59 -0500 From: "Joseph Wright" To: , Subject: Re: Moving MySQL Databases Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 You can move the databases with the MySQL mysqldump utility. mysqldump -u -p > .dmp it will then prmpt you for a password and then dump your database into a file with sql insert statements. to import first create the database then run: mysql -u -p < .dmp >>> Jason Halbert 12/27/01 11:42AM >>> Does anyone know how to move MySQL databases from one box to another?=20 I am upgrading my server and I would like to move my Qmail and=20 Apache databases over. It would be a nightmare to have to recreate=20 them from scratch. Thanks for any help. Jason jason@jason-n3xt.org=20 To Unsubscribe: send mail to majordomo@FreeBSD.org=20 with "unsubscribe freebsd-questions" in the body of the message To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message