[DominikHoffmann]

I am running a third-party freeware application that has assembled data in a MySQL database. When I had to rebuild the server from scratch I saved the database to a flat file using one of the methods using the mysqldump command, as described in Apple Support Article 107852, which jibes with my third-party application's documentation.

However, when I attempt to restore the database from the .sql file I am informed through an error message that

ERROR 1049: Unknown database '********'

Some investigation into what this error message might mean, raised the suggestion that I might have to initialize MySQL with the name of the database I would like to restore first. However, I don't know how to do that.

Any ideas?

[Wevah]

Yes, you have to create the database first:

create database foo;

in the MySQL console, where 'foo' is the name of your database.

Then you can go

mysql -p foo < foo.sql

[DominikHoffmann]

Thank you very much for saving me the trouble of digging through a MySQL text! -- Dominik

[Wevah]

No problem!