Skip to content

Instantly share code, notes, and snippets.

@ellegaarddk

ellegaarddk/URL_change.sql

Last active April 22, 2018 12:58
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ellegaarddk/25e57b592b80467da0f9deb3ba82bb00 to your computer and use it in GitHub Desktop.
Save ellegaarddk/25e57b592b80467da0f9deb3ba82bb00 to your computer and use it in GitHub Desktop.
Download ZIP
Skift af URL til https
Raw
URL_change.sql
##Ret prefix og domæner!!!!
UPDATE wp_posts SET post_content = replace(post_content, 'http://domain.dk', 'https://domain.dk');
UPDATE wp_posts SET guid = REPLACE (guid, 'http://domain.dk', 'https://domain.dk') WHERE post_type = 'attachment';
UPDATE wp_comments SET comment_author_url = replace(comment_author_url, 'http://domain.dk', 'https://domain.dk');
UPDATE wp_comments SET comment_content = replace(comment_content, 'http://domain.dk', 'https://domain.dk');
@ellegaarddk
Copy link
Author

Test med:
https://www.ssllabs.com/ssltest

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