restoring mysql databases from mysqldump was Re: upgrading mysql
alan at batie.org
Fri Aug 29 14:44:46 PDT 2003
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
Size: 305 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20030829/d707ea65/attachment.bin
More information about the freebsd-questions