mysql恢复多个数据库,如何从包含多个数据库的mysqldump恢复一个数据库？

I have a mysql dump with 5 databases and would like to know if there is a way to import just one of those (using mysqldump or other).

Suggestions appreciated.

解决方案

You can pipe the dumped SQL through sed and have it extract the database for you. Something like:

cat mysqldumped.sql | \

sed -n -e '/^CREATE DATABASE.*`the_database_you_want`/,/^CREATE DATABASE/ p' | \

sed -e '$d' | \

mysql

The two sed commands:

Only print the lines matching between the CREATE DATABASE lines (including both CREATE DATABASE lines), and

Delete the last CREATE DATABASE line from the output since we don't want mysqld to create a second database.

If your dump does not contain the CREATE DATABASE lines, you can also match against the USE lines.