MySQL import certain database in a large sql file.

[xenophobia]

Okay, I've done this:

mysqldump --all-databases -u root > mysql.sql

 

So this sql file had all the databases. So now I wanted to import to another machine.

 

My question now is, how do I import certain database only from this sql file?

I tried this:

mysqlimport -u root mydb mysql.sql

I got:

mysqlimport: Error: Unknown database 'mydb'

[fenway]

If the file is a reasonable size, you can extract the field in a text editor -- otherwise, sed and grep are your friends.