-
-
Save thedigitaloctopus/aed13a9cea6886c3a93462d3b523c6af to your computer and use it in GitHub Desktop.
push a local WP database to an existing staging site
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # push a local WP database to an existing staging site | |
| # uses current directory as theme path and ssh alias | |
| pushstage() { | |
| START=$(date +%s) | |
| # make a backup of the current local database | |
| # get current directory name, used for database and URL | |
| current=${PWD##*/} | |
| cd ~/Sites/$current || return | |
| # rsync the local database to staging site | |
| wp db export $current.sql | |
| rsync $current.sql $current-s:~/ | |
| # make a backup of the staging database | |
| wp @stage db export backup.sql | |
| # reset the staging database | |
| wp @stage db reset --yes | |
| # import our rsynced local database and update URLs | |
| wp @stage db import $current.sql | |
| wp @stage search-replace "$current.localhost" "$current.dmctest.com.au" --all-tables | |
| # deactivate plugins that aren't needed | |
| wp @stage plugin deactivate debug-bar query-monitor acf-theme-code-pro wordpress-seo | |
| # Discourage search engines from indexing this site | |
| wp @stage option update blog_public 0 | |
| cd ~/Sites/$current/wp-content/themes/$current | |
| END=$(date +%s) | |
| DIFF=$(( $END - $START )) | |
| echo -e "\n$current.localhost database now in use on $push_staging_url site.\nIt took $DIFF seconds, enjoy!\n" | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment