Splitting up SQL server dump

Question

Is there a way how to split up dump of whole database server (with such tables as 'mysql' or 'information_schema') to single databases?

Looking for better way than insert this whole dump and export needed databases...

Need to recover only part of this dump (only single databases)

score 3 · Accepted Answer · answered Oct 09 '11 at 13:48

3

try this:

awk '/USE `/{i++}{print > "file."i".sql"}' yourFullMysqlDump.sql

it'll create file.X.sql for each of the databases

answered Oct 09 '11 at 13:48

pQd

nice, thanks. But I think this will skip the step `CREATE DATABASE ...`, isn't it? – Marek Sebera Oct 09 '11 at 13:50
@MarekSebera - yes, but you can add it easily. – pQd Oct 09 '11 at 16:35

score 2 · Answer 2 · answered Oct 09 '11 at 13:30

2

Dump is a text file, so just open in in text editor and extract the part you need.

answered Oct 09 '11 at 13:30

Kruno

my dump is unfortunately >100 MB in uncompressed version, and in gzipped version I can't obviously edit it. – Marek Sebera Oct 09 '11 at 13:36
'text file' isn't quite correct, as it can also contain binary data – pauska Oct 10 '11 at 11:05

2 Answers2