.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 \
# }