From owner-freebsd-questions@FreeBSD.ORG Sat Aug 30 08:49:05 2003 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id F318316A4BF for ; Sat, 30 Aug 2003 08:49:04 -0700 (PDT) Received: from smtp018.mail.yahoo.com (smtp018.mail.yahoo.com [216.136.174.115]) by mx1.FreeBSD.org (Postfix) with SMTP id 82DD643FD7 for ; Sat, 30 Aug 2003 08:49:03 -0700 (PDT) (envelope-from kaeru@pd.jaring.my) Received: from unknown (HELO ?219.95.63.107?) (khairil?yusof@219.95.63.107 with plain) by smtp.mail.vip.sc5.yahoo.com with SMTP; 30 Aug 2003 15:49:02 -0000 From: Khairil Yusof To: Michelle In-Reply-To: <613AB8E4-DA68-11D7-BE93-000393843210@mindspring.com> References: <613AB8E4-DA68-11D7-BE93-000393843210@mindspring.com> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-Tq7bEQogzwD2uQTaJmat" Message-Id: <1062258529.98655.90.camel@daemon.home.net> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.4 Date: Sat, 30 Aug 2003 23:48:50 +0800 cc: freebsd-questions@freebsd.org Subject: Re: restoring mysql databases from mysqldump was Re: upgrading mysql X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 30 Aug 2003 15:49:05 -0000 --=-Tq7bEQogzwD2uQTaJmat Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Sat, 2003-08-30 at 05:33, Michelle wrote: Not really FreeBSD specific..but.. :) > I ran mysqldump -A > backup-file.sql and then upgraded the mysql port,=20 > but now when I try to restore the backups using mysql "database name" =20 > < backup-file.sql, It states unknown database. I also have a=20 > mysqlhotcopy backup of all my databases. Am I doing something wrong=20 > when trying to recover multiple databases? How can I recover them from=20 > the mysqlhotcopy rather then the dump if something went wrong with the=20 > dump? mysqldump -A will save all databases, so when restoring you only need: mysql < backup-file.sql not: mysql "database name" < backup-file.sql This will try to restore only one database (which you need to create first). This ways is only needed if you do a mysqldump "databasename" > backup.sql. -- "Optimized, readable, on time; Pick any two."=20 FreeBSD 5.1-CURRENT i386=20 11:45PM up 1 day, 1:43, 4 users, load averages: 1.33, 1.47, 1.41 --=-Tq7bEQogzwD2uQTaJmat Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (FreeBSD) iD8DBQA/UMdhDAqnLW/+/X8RAv7PAKC310uojLzQ7ZHVL3J3EqIfS1snJQCgzln0 b5TIhEtaU6ALvUQ9bFcXk9o= =flUq -----END PGP SIGNATURE----- --=-Tq7bEQogzwD2uQTaJmat--