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).
You can pipe the dumped SQL through
sedand 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
- Only print the lines matching between the
CREATE DATABASElines (including both
CREATE DATABASElines), and
- Delete the last
CREATE DATABASEline from the output since we don't want mysqld to create a second database.
If your dump does not contain the
CREATE DATABASElines, you can also match against the
Postar um comentário