Skip to content

Instantly share code, notes, and snippets.

@BKeanu1989

BKeanu1989/live-to-local-wp.sql

Last active November 29, 2018 13:17
Show Gist options
  • Save BKeanu1989/6920d815206089b674cf4f07036358e6 to your computer and use it in GitHub Desktop.
Save BKeanu1989/6920d815206089b674cf4f07036358e6 to your computer and use it in GitHub Desktop.
Download ZIP
From live to local Wordpress
Raw
live-to-local-wp.sql
-- variables: PREFIX; URL; HTDOCS_DIR
-- TODO/TRY UPDATE PREFIXposts SET guid = replace(guid, 'URL', 'http://localhost:8888/HTDOCS_DIR');
UPDATE PREFIXoptions SET option_value = replace(option_value, 'URL', 'http://localhost:8888/HTDOCS_DIR') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE PREFIXposts SET post_content = replace(post_content, 'URL', 'http://localhost:8888/HTDOCS_DIR');
UPDATE PREFIXpostmeta SET meta_value = replace(meta_value, 'URL','http://localhost:8888/HTDOCS_DIR');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment