Skip to content

Instantly share code, notes, and snippets.

@jonathanstegall

jonathanstegall/migrate.sql

Created April 3, 2019 21:11
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save jonathanstegall/fdb85076664f2c0de9c76e7bd759ac83 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save jonathanstegall/fdb85076664f2c0de9c76e7bd759ac83 to your computer and use it in GitHub Desktop.
Download ZIP
migrate from VIP to local environment
Raw
migrate.sql
// first, run cat ~/Desktop/sql/*.sql | mysql -u root -p minnpost.wordpress in terminal
DELETE FROM wp_options WHERE option_name = 'jetpack_options';
UPDATE wp_options SET option_value = 'https://minnpost-wordpress.test' WHERE option_name = 'siteurl';
UPDATE wp_options SET option_value = 'https://minnpost-wordpress.test' WHERE option_name = 'home';
@jonathanstegall
Copy link
Copy Markdown
Author

jonathanstegall commented Feb 8, 2020 •
edited
Loading

Also can run cat ~/Desktop/sql/*.sql > ~/Desktop/sql/all_files.sql

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment