DE

↑ ↓ select, Enter open, Esc close

Switch the WordPress database from http to https

destructiveWP-CLIalle
Adjust the values, the command updates live
user@server
wp db export /var/www/vhosts/example.com/before-https.sql --path=/var/www/vhosts/example.com/httpdocs && wp search-replace 'http://example.com' 'https://example.com' --skip-columns=guid --path=/var/www/vhosts/example.com/httpdocs

First exports the database as a backup, then replaces http://example.com with https://example.com in all WordPress tables, including serialized data. This fixes mixed content warnings and stops internal links from going through a redirect, which also matters for SEO. The guid column is deliberately left unchanged.

Note: Test with --dry-run first. Also set up a 301 redirect from http to https at the web server level, and replace subdomains such as www. separately if needed.

Also searched as

  • switch wordpress to https
  • fix mixed content wordpress
  • replace http links in wordpress
  • still http after ssl certificate

Related one-liners

All in WP-CLI

Change domain: replace the old domain in the database

$wp db export /var/www/vhosts/example.com/before-domain-change.sql --path=/var/www/vhosts/example.com/httpdocs && wp search-replace '//old.example.com' '//example.com' --all-tables --skip-columns=guid --path=/var/www/vhosts/example.com/httpdocs
destructiveWP-CLI

Change the siteurl and home addresses

$wp option update siteurl 'https://example.com' --path=/var/www/vhosts/example.com/httpdocs && wp option update home 'https://example.com' --path=/var/www/vhosts/example.com/httpdocs
cautionWP-CLI

Check whether WordPress blocks search engines

$wp option get blog_public --path=/var/www/vhosts/example.com/httpdocs
harmlessWP-CLI

Read the siteurl and home addresses

$wp option get siteurl --path=/var/www/vhosts/example.com/httpdocs && wp option get home --path=/var/www/vhosts/example.com/httpdocs
harmlessWP-CLI

Regenerate permalinks and rewrite rules

$wp rewrite flush --path=/var/www/vhosts/example.com/httpdocs
cautionWP-CLI

Remove the search engine block in WordPress

$wp option update blog_public 1 --path=/var/www/vhosts/example.com/httpdocs
cautionWP-CLI

Read first, then run.

The commands on myline.de act directly on servers, files and databases. A wrong path or placeholder can delete data irreversibly or make a server unreachable.

  • All commands are provided without warranty and are not tested on every system.
  • Understand what a command does before running it, and check every placeholder.
  • Make a backup first and, if possible, try it on a test system.
  • You run commands at your own risk. Liability for damages is excluded to the extent permitted by law.