If you change domain with your blog, but decided to stick to the same database (1), probably you will have to update several URLs in your entries.
I’m a lazy person and everything which can be done automatically, will be be automated. Replacing links or words in your WordPress database table is a really simple act. Of course, you should first backup your database (2).
Open your CPanel or Plesk backend and move to the Database —> phpMyAdmin area. Select your database here and move to wp_posts
The syntax to replace strings/data/words/whatevah in your database is simple:
update tablename set field = replace(field,'search_for_this','replace_with_this');
In my case I had to change the URL from serialrecidivism.com; to ifranky.com/amifamousnow, the string looked as this:
update wp_posts set post_content = replace(post_content,'http://serialrecidivism.com','http://ifranky.com/amifamousnow');
Congratulations, after some Googling, you now have become a MYSQL authority! (3)
- You have imported your database at your new hoster, or just changed all while staying with the same hoster(↩)
- Lazy people obviously use this trick(↩)
- Yeah, right(↩)
