Visualizza wikitesto di Spezzare un dump di multi DB

 
 Extracting a Single Database From a mysqldump File containing –all-databases Dump.
 Imagine to have a full MySQL DB Dump (containing a lot of Single Database Dumps) and imagine also to need the extraction or restoration of a single one. This is a quite common task that can be accomplished using some shell commands.
 
 1. Using the mysql command line client’s –one-database option:
 
 mysql -u root -p --one-database B_To_Be_Restored < FullDump_File.sql
 
 2. Using ‘sed’ to extract the Dump from the dump file:
 
 sed -n '/^-- Current Database: `DB_To_Be_Restored`/,/^-- Current Database: `/p' FullDump_File.sql > DB_To_Be_Restored.sql
  Tags: --all-databases, DataBase, DB, DB Dump, Dump, MySQL, mysqldump, Restore
 
  This entry was posted on Thursday, December 11th, 2014 at 11:50 AMand is filed under . You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.
 
 Source: https://blog.bravi.org/?p=1205