MyBB Community Forums

So I move my forum from alltechtalk.net to alltechtalk.net/forum

I know that there is a mysql script/command to update the links on old posts, but I forgot what it was.

May someone please help me?


PS. Yes, I did try looking for it, but couldn't find it.

Make a database backup before running this query. It's untested but should work as expected.

update mybb_posts set message = replace(message, 'alltechtalk.net', 'alltechtalk.net/forum')

(2012-04-16, 02:29 AM)Nathan Malcolm Wrote: [ -> ]Make a database backup before running this query. It's untested but should work as expected.

update mybb_posts set message = replace(message, 'alltechtalk.net', 'alltechtalk.net/[b]forum')[/b]

Thanks... to help people out, in the future, make sure that the ') follows right after the url and that there is no space or enter between the link and the ').

Ah, thanks, fixed. There was a newline after the URL I copied.