vip_replace.sh

#!/bin/bash                                                                                                                                                                                                                                                                                   
                                                                                                                                                                                                                                                                                              
echo "*********VIP REPLACE SCRIPT STARTING**********"                                                                                                                                                                                                                                         
                                                                                                                                                                                                                                                                                              
##merge the sql files to one for easy import                                                                                                                                                                                                                                                  
echo ""                                                                                                                                                                                                                                                                                       
echo "Combining sql files in to one"                                                                                                                                                                                                                                                          
echo ""                                                                                                                                                                                                                                                                                       
{ echo "SET SQL_MODE='ALLOW_INVALID_DATES';" ; cat wp_*.sql ; } > combined_vaultpress_dump.sql                                                                                                                                                                                                
                                                                                                                                                                                                                                                                                              
#remove the old sql files                                                                                                                                                                                                                                                                     
echo ""                                                                                                                                                                                                                                                                                       
echo "Removing old sql files"                                                                                                                                                                                                                                                                 
echo ""                                                                                                                                                                                                                                                                                       
rm wp_*.sql                                                                                                                                                                                                                                                                                   
                                                                                                                                                                                                                                                                                              
#replace bad sql syntax                                                                                                                                                                                                                                                                       
echo ""                                                                                                                                                                                                                                                                                       
echo "Replacing bad SQL, this can take a few minutes... :D"                                                                                                                                                                                                                                   
echo ""                                                                                                                                                                                                                                                                                       
sed -i '' -e 's/SET NAMES ;//g' combined_vaultpress_dump.sql                                                                                                                                                                                                                                  
                                                                                                                                                                                                                                                                                              
echo "*****************ALL DONE*********************"