Converts non-extended INSERT INTO queries into the equivalent extended-insert format.
The extended-insert format is much more performant when restoring data.
With leiningen:
git clone https://github.com/it0a/mysqldump-extend && \
cd mysqldump-extend && \
lein bin
Will output a binary at target/mysqldump-extend (Add this to your PATH)
mysqldump-extend data-non-extended-insert.sql > data-extended-insert.sql
mysqldump-extend data1.sql data2.sql data3.sql > data-extended-insert.sql
mysqldump-extend *.sql > data-extended-insert.sql
mysqldump-extend *.sql | mysql -u user -p database_name
Copyright © 2015 it0a
MIT License