Weird issue with database migration and SSL links

Found a problem. Basically there were 2 options that forced my permalinks to https:

  1. Settings > General: change the site url from https to http.
  2. SEO by Yoast plugin, under section permalinks needed to change Canonical Settings to force HTTP.

Related Posts:

  1. Multiple developers / editors working on a site in progress
  2. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  3. Fastest way (least amount of steps) to locally import a remote database using WP-CLI
  4. Solution for database version control and deployment?
  5. How to migrate a HTTPS WordPress installation to localhost?
  6. How can I migrate from another platform to WordPress (using the same domain) and launch when ready?
  7. Migrating data between local and development server
  8. Best way to import users, post and categories from an external database
  9. Syncing local content with development / staging sites
  10. Organizing WP Pages based on old website database
  11. Presentation vs Content in WP DB-Tables
  12. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
  13. Migrate a Non WordPress database to wordpress [closed]
  14. How to fix unchanged URLs in Database after running serialized search and replace script?
  15. WordPress DATABASE Update Manually?
  16. Migrating database / content of non-CMS site to WordPress
  17. How do I reset a self-hosted WordPress URL?
  18. I don’t see site_url and home_url fields in wp_options table (phpMyAdmin)?
  19. Export all content from wordpress
  20. Migrating WordPress from DreamHost to Azure WordPress Resource via UpdraftPlus “wp_options table does not exist…” error
  21. Moving minor updates between local and live sites – just database?
  22. How to move the WordPress site Layout from test site to Production site?
  23. Merging two databases without borking it
  24. Why does importing copies of the database dump and the document root make WordPress data inconsistent?
  25. Able to use all admin pages but in the frontend there is a “Error establishing a database connection”-Error
  26. Trouble Migrating all data blog from WordPress.com to WordPress.org
  27. Copying database tables to new database
  28. Migrating from PDO using SQLite to clean new install using MySQL
  29. Migration: Copying database content to a different server
  30. Change WordPress URL in sql file via Terminal
  31. Strange characters added to the database
  32. After database migration, theme mods don’t show [closed]
  33. Problem migrating to localhost
  34. WordPress url transformation script
  35. How to transfer from localHost to live but use the already existing database on the server?
  36. Image link issues after importing a database backup to my local web server
  37. Database migration issues – Error #1046 No database selected
  38. echo site_url() returns a different value than what is in the database siteurl field
  39. Migrate Users From laravel to wordpress
  40. /wp-admin not accessible after migrating to local host (no plugin issue)
  41. How to fix Uploaded to this post option to see group of images uploaded to a post?
  42. How do you enable scripts on a WordPress installation in Softaculous?
  43. WordPress site migration – locked out of admin area
  44. Malware in old website – how to migrate?
  45. WP website showing blank page after moving from subdomain to main domain
  46. WordPress Migration – Issue with admin panel changes
  47. Do I need to be selective about where I search and replace when pointing a domain to a subfolder used for development?
  48. How to edit posts/pages without making the change live?
  49. Migrate not successful, DB is broken. How to fix, or at least output static HTML without plugins?
  50. After Migration From dev, Only my Links to the Homepage Still Redirect to dev
  51. I cannot change anything in my wordpress database from within wordpress?
  52. Media library images “missing” after migrating them using SQL
  53. Restoring .sql backup results in “Error establishing a database connection”
  54. import (migration) user database to wp-users
  55. Database question while Migrating from one domain to another on same WebHost [Bluehost]
  56. Moving database from WP 2.6 to 3.5 problem
  57. Importing Concrete5 content to WordPress
  58. Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
  59. How to properly configure SSL connection to remote azure database for running queries within a WordPress environment
  60. MySQL SELECT increment counter
  61. Exclude Statement in SQL
  62. Can a post ID be 0?
  63. what is the wp_5_posts table in the database?
  64. WordPress Database Charset/Collate
  65. What is the database table for pages?
  66. Using Dynamic Data Pulled from a MySQL Table in a WordPress Page
  67. Is database safe after merging a branch of a more recent version over an older one?
  68. Hook to be used when creating a database table
  69. Delete all post meta except featured image
  70. Merging WordPress posts from different databases
  71. Is it possible to split database tables using HyperDB?
  72. How do I get WordPress login to ignore the password input if a particular username is used?
  73. “Error establishing a database” connection on some sites
  74. Is MariaDB’s Aria storage engine suitable for WordPress?
  75. Slow queries constantly getting stuck on WordPress database of ~100,000 posts
  76. How do I query wp_options for expired transient pairs with MySQL commands?
  77. WordPress running SQL query to update database from form
  78. How to fix database error duplicate entry
  79. WPDB SQL query with prepare() returning variable, not db value
  80. Get value form wordpress database
  81. Why this query is not showing any result on wordpresss home page?
  82. How to display content from external db with relevant urls
  83. how to count click tab menu and insert to database
  84. Adding prefix to WordPress database tables breaks admin capabilities?
  85. What is the best way to resurrect and update my old WordPress site?
  86. content disappearing minutes after it’s published
  87. Add pdf to a website
  88. Optimizing function that automatically creates internal links based on post title string
  89. Can two domains use the same database?
  90. _wp_attachment_metadata is not being added to database when PDF files uploaded
  91. adding user_id and name to a separate table whenever a user register based on role
  92. How do I loop/iterate through posts to edit all img tags?
  93. How to optimise this database query?
  94. How to retrieve user data based on role using SQL?
  95. Adding featured for post using database
  96. Store id from database query in cookie
  97. Split database on large site?
  98. Store the wordpress “featured image” under »wp_posts« Database table
  99. Return image urls with specific base string?
  100. What WordPress file is saving new users to database