Remove dump data in mysql dump file
Posted:
August 04, 2015
|
Categories:
News
, Magento Tutorial
, Wordpress
, vTiger CRM
, vTiger CRM Customer Portal
, Premium Plugin
, Git
, Laravel
, Mysql
, Ionic Framework
Remove selected table insert content from dump file
grep -v "INSERT INTO \`big_table\`" dump.sql > dump_stripped.sql
Remove all insert content from dump file
grep -v "INSERT INTO" dump.sql > dump_stripped_insert.sql
Replace dump.sql with your dump file name