how can i replace link in database

[AmirAbbas]

hello

i have another question

i want replace some link in database with a SQL query

i want replace this text in database

-http://www.siscenter.com/forum/

with

-http://forum.siscenter.com/


we need to install forum in subdomain
i need a SQL query

whats that SQL query ?

[Peter77]

Hello, you will want to backup your entire phpbb root folder -- files and SQL ect. get rid of the "froum" directory and create a subdomain called "forum" ( I use Cpanel, not sure what you use ) and then install your phpbb and upload your backups to the new subomain called "forum"... another words, it's like moving your entire board.


I hope that is what you were asking.

[AmirAbbas]

hello

i don't have problem with changing address
our forum was installed on this address for 2 years

-http://www.siscenter.com/forum/

if we change the address we will have lots of internal broken link
we need a quey for replacing old form link with new one

[dcz]

It's not that simple, you need ot select every single post, make sure the link is in there and update if necessary.

Depending on how big the forum is, it can be a pain to avoid timeouts.

A simple trick would be to edit a db backup (only the post_text table), and use the replace command of your favorite text editor (a decent one is required here, no word-pad nor note pad here) on it before you put it back online.

Search for the entire string to make it safe : -www.siscenter.com/forum and replace with -forum.siscenter.com, should be shorted than writing down the sql script to do it for you

++

[AmirAbbas]

thanks

[falkra]

Sorry to bump here, but would this work (online, not on local table backup) ?

UPDATE phpbb_posts_text SET post_text = REPLACE(post_text, 'oldstring', 'newstring');