Modify MySQL dump File The Fatest

When using the MySQL command to import mysqldump generated SQL files, in order to improve the import speed, often need to modify the dump file, but in the face of a dozens of GB file, this thing is too broken, the quickest way is to do this:

(    echo "SET autocommit=0;"    echo "SET unique_checks=0;"    echo "SET foreign_key_checks=0;"    Cat Cc_jiecao.sql    echo "SET Foreign_key_checks=1;"    echo "SET Unique_checks=1;"    echo "SET autocommit=1;"    echo "COMMIT;") | Mysql-u.-P ... target_database

Reference:smarter-faster-backups-restores-mysql-databases-with-mysqldump

Original link: http://onlyvc.us/modify-mysql-dump-file-the-fatest-way/

Modify MySQL dump File The Fatest