Skip to content

Instantly share code, notes, and snippets.

@patrickmaciel

patrickmaciel/reduced.sh

Created November 22, 2019 21:31
Show Gist options
  • Save patrickmaciel/dab9778d61156983d4ccab5066d024a7 to your computer and use it in GitHub Desktop.
Save patrickmaciel/dab9778d61156983d4ccab5066d024a7 to your computer and use it in GitHub Desktop.
Download ZIP
Reduce a large sql file ignoring insert's of specific tables
Raw
reduced.sh
```sh
#!/bin/bash
sed '/INSERT INTO `rev_reviews`/d' dump.sql |
sed '/INSERT INTO `rev_log`/d' |
sed '/INSERT INTO `p_logconsulta`/d' |
sed '/INSERT INTO `p_logconsulta_20190726`/d' |
sed '/INSERT INTO `rev_log_products`/d' |
sed '/INSERT INTO `rev_log_tasks`/d' |
sed '/INSERT INTO `rev_log_products_client`/d' |
sed '/INSERT INTO `rev_log_reviews`/d' > reduced.sql
```
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment