2012-12-31, 05:47 PM
How to use MySQL to replace the URL in your posts?!
replace the URL in your posts
|
2012-12-31, 05:47 PM
How to use MySQL to replace the URL in your posts?!
2012-12-31, 06:00 PM
So you want a query that will replace all links in post with something else? Can you elaborate please.
2012-12-31, 06:05 PM
yes a something like this:
UPDATE wp_posts SET POST_CONTENT = replace(POST_CONTENT, 'myolddomain.com', 'localhost/sandbox'); its for wordpres but this not work on mybb
2012-12-31, 06:08 PM
I have never user a query like this.
Have you tried this?
2012-12-31, 06:16 PM
Thank you
worked
2012-12-31, 06:17 PM
(This post was last modified: 2012-12-31, 06:17 PM by JordanMussi.)
Your welcome, glad to be of help.
2012-12-31, 06:23 PM
This user has been denied support.
Make sure to have a backup before running any such queries on post messages. So you can undo in case anything goes wrong.
2012-12-31, 06:32 PM
Yeah I would do that. The OP had already said that they had tried it and I guessed that if they had tried it and it hadn't worked and nothing had gone wrong, that trying one that should work wouldn't do any damage.
2013-01-01, 12:24 AM
Slightly off topic, but perhaps it would be nice if MyBB could detect posted internal URLs and only store them as relative URLs. Would make domain movements a bit nicer.
|
« Next Oldest | Next Newest »
|