Date: Fri, 29 Aug 2003 14:44:43 -0700 From: Alan Batie <alan@batie.org> To: Michelle <tristan11@mindspring.com> Cc: freebsd-questions@freebsd.org Subject: Re: restoring mysql databases from mysqldump was Re: upgrading mysql Message-ID: <20030829214443.GA18572@agora.rdrop.com> In-Reply-To: <613AB8E4-DA68-11D7-BE93-000393843210@mindspring.com> References: <A4196EF4-DA5B-11D7-B233-0030656DD690@foolishgames.com> <613AB8E4-DA68-11D7-BE93-000393843210@mindspring.com>
next in thread | previous in thread | raw e-mail | index | archive | help
--VbJkn9YxBvnuCH5J Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, Aug 29, 2003 at 02:33:07PM -0700, Michelle wrote: > 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've never had a mysql upgrade trash my databases, but it sounds like the simple solution is to 'mysqladmin create "database name"' first. Though the -A does seem to put create database commands in the dump file. You might look at the sql and find out what's broken... I tried dumping all mine, and got a "client out of memory" error. Weird. --=20 Alan Batie ______ alan.batie.org Me alan at batie.org \ / www.qrd.org The Triangle PGPFP DE 3C 29 17 C0 49 7A \ / www.pgpi.com The Weird Numbers 27 40 A5 3C 37 4A DA 52 B9 \/ spamassassin.taint.org NO SPAM! To announce that there must be no criticism of the President, or that we are to stand by the President, right or wrong, is not only unpatriotic and servile, but is morally treasonable to the American public. -Theodore Roosevelt, 26th US President (1858-1919) --VbJkn9YxBvnuCH5J Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (FreeBSD) iQCVAwUBP0/JS4v4wNua7QglAQG/SgQAh107WbafozQCcEnUEdJTs5uyKTWCFr5J 94pEZ2KbdfXpnOfVF1tCUsyGi5BvSopp12eX3qBNv8SwDbROhp/2iU9x8MWCAOzf DqC4IcUenISLtl7vjop75SYP4AHp64wroZtVUEmYg8RGKzquf8+LJ+oeXeIpsYMV Wnrr6Hs30/E= =vEkk -----END PGP SIGNATURE----- --VbJkn9YxBvnuCH5J--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20030829214443.GA18572>