Extracting a Database From a mysqldump File

Restoring a single database from a full dump is pretty easy, using the mysql command line client’s –one-database option: mysql> mysql -u root -p –one-database db_to_restore < fulldump.sql But what if you don’t want to restore the database, you just want to extract it out of the dump file? Well, that happens to be easy… Continue reading Extracting a Database From a mysqldump File