#!/bin/bash

#replace production site values with our local
sed -i -- 's/\/\/twincities.com/\/\/wordpress.local/g' *.sql
sed -i -- 's/\/\/www.twincities.com/\/\/wordpress.local/g' *.sql

#replace bad sql syntax VIP added
sed -i -- 's/SET NAMES ;//g' *.sql

#merge the sql files to one for import
cat wp_*.sql > combined_vaultpress_dump.sql