How do I restore one database from a mysqldump containing multiple databases?

mysql database import mysqldump restore
The Pixel Developer picture The Pixel Developer · Aug 29, 2010 · Viewed 24.1k times · Source

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.

Answer

Tim picture Tim · Aug 29, 2010

You can use the mysql command line --one-database option.

mysql> mysql -u root -p --one-database YOURDBNAME < YOURFILE.SQL

Of course be careful when you do this.

You can also use a mysql dumpsplitter.

Related questions

Import single database from --all-databases dump

Is it possible to import a single database from an --all-databases mysqldump? I guess I can modify the file manually but wondering if there are any command line options to do this. I am moving servers and have a lot …

Read More
Import SQL file into mysql

I have a database called nitm. I haven't created any tables there. But I have a SQL file which contains all the necessary data for the database. The file is nitm.sql which is in C:\ drive. This file has …

Read More
MySQL: ignore errors when importing?

I am importing a fairly large database. The .sql file has almost 1,000,000 lines in it. Problem is that I am getting a syntax error when trying to import the database. It says: ERROR 1064 (42000) at line 8428420: You have an error in …

Read More