How to bulk change links in posts after moving a forum

[Raziel-CZ]

I greet everyone and especially the support.

How do you change links in bulk posts after moving a forum from one domain to another (eg from forum.sebesdileni.cz to forum.etiq.cz)? Through some plugin or in phpMyAdmin?

[Mick]

Welcome to phpBB

Please do not multi post the same topic, you're just making work for the moderators, thanks.

[warmweer]

How do you change links in bulk posts after moving a forum from one domain to another (eg from forum.sebesdileni.cz to forum.etiq.cz)? Through some plugin or in phpMyAdmin?

Do a search and replace with phpMyAdmin (or similar) directly in the database (probably posts_table)
or (safer)
Do a search and replace (with Notepad+ or similar) on a database backup (freshly made) and when you're satisfied restore that altered database (you probably only need the posts_table) and disable your board while you working on it.

Whichever you choose, make sure you have a database backup in case something goes wrong.

BTW using the search function in this forum will point you to various topics with examples.

[Steve]

You could use : https://www.php.net/manual/en/function.preg-replace.php

Matching the old domain and sub domain, using a regex …

Using an event phpBB provides in viewtopic etc, you could write an extension …

Regards.

//edit
If you have access to the old server, you could use the apache mod rewrite rule.

[Raziel-CZ]

Additionally, thanks for the answers.

Mick for an off-topic answer without relevant advice such as a link and warmweer for a relevant answer that helped me. And Steeve, I'm just a bit of an advanced user, not a coder, so this advice didn't help me.

Have a nice day everyone.

[Steve]

I'm sure you will get help.
As for the textarea bug placing my smilies at the 1st position / position will have been reported to the team
Bug bug bug
Half hour later. Text box hello. What a crap box.

[HB]

...I'm just a bit of an advanced user, not a coder, so this advice didn't help me.

Assuming you have MySQL/mariadb access, here's the SQL:

Code: Select all

UPDATE phpbb3_posts set post_text = REPLACE(post_text, 'forum.sebesdileni.cz', 'forum.etiq.cz') WHERE post_text LIKE '%forum.sebesdileni.cz%';

This is a global replacement, but it's low risk IF the replacement is very unique, as is the case for "forum.sebesdileni.cz". Either way, I would test on a local installation and backup your database before making global changes like this.