Skip to content

Instantly share code, notes, and snippets.

@mjones129

mjones129/wordpress.sql

Last active December 21, 2024 02:39
Show Gist options
  • Save mjones129/f16ee274a276a5bc21a11fd3cc321ca9 to your computer and use it in GitHub Desktop.
Save mjones129/f16ee274a276a5bc21a11fd3cc321ca9 to your computer and use it in GitHub Desktop.
Download ZIP
Set Wordpress URL with WPCLI
Raw
wordpress.sql
#show siteurl
wp db query "SELECT * FROM wp_options WHERE option_name = 'siteurl';"
#show home
wp db query "SELECT * FROM wp_options WHERE option_name = 'home';"
#update siteurl
wp db query "UPDATE wp_options SET option_value = 'https://newsiteurl.com' WHERE option_name = 'siteurl';"
#update home
wp db query "UPDATE wp_options SET option_value = 'https://newsiteurl.com' WHERE option_name = 'home';"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment