WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It only takes a minute to sign up.
Sign up to join this community
I am trying to change all images links from http to https, is it possible doing that on a batch query working on the whole database? How?
Moreover my provider made a mess adding an "s" to https getting useless and wrong "httpss" ! So I must revert them from httpss to https.
Please help, many thanks.
I should think that you can use phpAdmin Find and Replace where you find "http://www.example.com" and replace with "https://www.example.com". This should handle all internal linking (if blog, then internal linking as well as images, etc.). It would not cover relative addressing like "//www.example.com". In the case of Wordpress, this would be done on the wp_posts table, post_content column.
you could use https://github.com/interconnectit/Search-Replace-DB. This is a great tool to find and replace in db, you just need to copy the srdb folder to root of your site( where your wp-config.php is), then open it :
yourdomain.com/srdb
and then find and replace the strings in your db
for replacing use like this
httpss: ==> https: //for those which have ss
http: ==> https: // for new one
adding
:
to your replace statement prevent mistake
Do not change these URLs in database. The protocol part should be 'http'. When 'https' request is being made, then first four characters of the URL is replaced by 'https', automatically. If URL from database starts with 'https' then result will be 'httpss'!
You can use a very good search/replace plugin that I'm using last year - Better Search Replace
It's working very good. Be sure you'll create the DataBase backup before. I never had problems with this plugin, but you have to be sure, you have the DataBase copy in any case.
