NAME
MySQL Database Dump Splitter v0.0.1
AUTHOR
Pavel Tsakalidis [ http://pavel.gr | [email protected] ]
DESCRIPTION
This script breaks down a mysqldump file into one-file-per-table.
USAGE
--in [sql dump] --out [output folder] --force --postfix-time "d-m-Y" --postfix-name [some text] --ignore [ignore-table1,ignore-table2,...] --only [export-table1,export-table2,...] --list
--in MySQL dump file.
--out Output folder to store individual sql files.
--force If --out directory does not exist, create it.
--postfix-time PHP date() format string to be appended to table filename.
--postfix-name Any text you want to be appended to table filename.
--ignore Any tables you want to ignore, comma separated.
--only Specific tables you want to export. Overrides --ignore option.
--list Only list tables. Will ignore every option except --in.
EXAMPLES
php dbsplit.php --in /tmp/data.sql --out /tmp/tables --force --only table1,table2
php dbsplit.php --in /tmp/data.sql --list
php dbsplit.php --in /tmp/data.sql --out /tmp/tables --postfix-time "d-m-Y_H-i" --postfix-text myexporttext