Yesterday, a friend of mine asked me urgent help. He fully developed a WP based website for a research project on localhost/his_website. As WP stores full links pretty much everywhere in the database, his website was obviously completely broken when he moved it to production on his_website.com.
I quickly put some PHP lines of codes together to fix the whole DB at once. Feel free to re-use it in your own projects.
- put the script on your server, for example /website/root/wordpress_production.php
- configure DB connection + old and new URL
- visit http://www.your_website.com/wordpress_production.php (you should see nothing)
- you’re done !
DISCLAIMER: this script comes with NO WARRANTY. USE IT AT YOUR OWN RISKS.