Hi there,

We have a semi-large (200MB) mySQL database from an old
phpBB2 Cinema4d forum. Due to circumstances the old forum had
to move (2006) to a new host and a new domain. We also took that
moment to buy/ install a more current IPB forum.

We are now trying to get the old forum up again, as a static (read only)
forum.
But, most links in the database link to the old domain. We tried to do a
search and replace in Dreamweaver, but it either crashed or got not very
far in the DB. And replacing the links by hand.... So eventhough we have
the entire old site on a backup, internal the images link to the folder on the
old domain.

Has anyone here ever dealt with something simular or knows how to
replace those links in the DB?

Thank you very much,

--
Rick

UPDATE tablename SET column = REPLACE(column,'old_hostname','new_hostname') WHERE column LIKE '%old_hostname%';

Looks like it should work

Hi Chris!

Thank you for your speedy reply!
I forgot to mention that I'm a total n00b when it comes to phpMyAdmin.

Where would I fill in your given code?

Thanks.

--
Rick

Go into the database in phpMyAdmin, and hit the SQL link in the top nav bar.