restoring mysql databases from mysqldump was Re: upgrading mysql

[Alan Batie]

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, 
> but now when I try to restore the backups using mysql "database name"  
> < 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.

-- 
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)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 305 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20030829/d707ea65/attachment.bin