.bashrc 1.47 KB
function put_svi_database() {
    
    ssh tenzing_www@db-1 mysqldump -u root sv-intranet | cat > /Users/jeremy/Desktop/sv-intranet.bak.sql \
    && mysqldump -u root sv-intranet > /Users/jeremy/Desktop/sv-intranet-local-bak.sql \
     && wp --path=/Users/jeremy/Webserver/sv-intranet/ search-replace 'http://svi.test' 'https://svi-staging.gotenzing.com' --skip-columns=guid \
     && mysqldump -u root sv-intranet > /Users/jeremy/Desktop/sv-intranet-new.sql \
     && ssh tenzing_www@db-1 "mysql -u root -e 'drop database IF EXISTS sv-intranet; create database sv-intranet;'" \
     && cat /Users/jeremy/Desktop/sv-intranet-new.sql | ssh tenzing_www@db-1 'mysql -u root sv-intranet' \
     && wp --path=/Users/jeremy/Webserver/sv-intranet/ search-replace 'https://svi-staging.gotenzing.com' 'http://svi.test' --skip-columns=guid \

}

# function pull_database() {
    
#     ssh tenzing_www@db-1 mysqldump -u root docterswithoutborders_staging | cat > /Users/jeremy/Desktop/docterswithoutborders_staging.sql \
#         && mysqldump -u root docterswithoutborders > /Users/jeremy/Desktop/docterswithoutborders.sql.local-bak \
#         && mysql -u root -e "drop database IF EXISTS docterswithoutborders; create database docterswithoutborders;" \
#         && mysql -u root docterswithoutborders < /Users/jeremy/Desktop/docterswithoutborders_staging.sql \
#         && wp --path=/Users/jeremy/Webserver/msf-ca-new/ search-replace 'https://msf-staging.gotenzing.com' 'http://msf.test' --skip-columns=guid \

# }