Make production Magento database into development-ready database

cleanup.sh

# USAGE: cleanup.sh input-file.sql output-file.sql "www.production-site.com" "dev.production-site.com"

awk '!/INSERT INTO `customer_(entity|address)/' $1 \
  | awk '!/INSERT INTO `log_/' \
  | awk '!/INSERT INTO `m2epro_/' \
  | awk '!/INSERT INTO `sales_/' \
  | awk '!/INSERT INTO `report_viewed_/' \
  | awk '!/INSERT INTO `load_/' \
  | sed "s/$3/$4/; s/http:\/\/$3/http:\/\/$4/; s/https:\/\/$3/http:\/\/$4/" \
  >  $2