SMF Support > SMF 2.0.x Support

SOLVED new domain and need to change all links in forum posts to the new domain

(1/2) > >>

Frozt:
I change the domain of my site and forum

so I have a lot of links of articles and forum with the old urls


is possible change all of that urls to the new domain?

I can change each url manually in phpmyadmin but take a lot of time, is there other method to do it?

X3mE:
Do a find & replace query in phpMyAdmin


--- Code: ---UPDATE tablename SET tablefield = replace(tablefield,"findstring","replacestring");
--- End code ---

Frozt:
oh thanks

I go to try

SlammedDime:
Back up your database FIRST, please.

Frozt:

--- Quote from: X3mE on October 22, 2008, 08:40:45 AM ---Do a find & replace query in phpMyAdmin


--- Code: ---UPDATE tablename SET tablefield = replace(tablefield,"findstring","replacestring");
--- End code ---

--- End quote ---


that in the case of find the old url in the post messages could be like this:



--- Code: ---UPDATE smf_messages SET body = replace(body,"olddomain","newdomain");
--- End code ---


I dont know if tablefield is body in this case

Navigation

[0] Message Index

[#] Next page