How to mass replace old dead links with new links in a Wordpress blog?

[akibaba]

Most of the links (20k+, wupload, filesonic, uploadstation and fileserve) in my Wordpress blog is dead.

And I get a list of live links for them in a text file. How do I mass replace those dead links in my post with those live links (In one go)?

akibaba Reviewed by akibaba on 7th Jun 2011. How to mass replace old dead links with new links in a Wordpress blog? Most of the links (20k+, wupload, filesonic, uploadstation and fileserve) in my Wordpress blog is dead. And I get a list of live links for them in a text file. How do I mass replace those dead links in my post with those live links (In one go)? Rating: 5

[algon]

sorryyyyy

[factor]

http://www.besthostingforums.com/showthread.php?t=84995
Rank 45: akibaba (18197 credits)
Is this you?

Edit: AAAAAAAAAAAAAAAwesome.

[akibaba]

factor: off topic, yes.

[qloolp]

http://wordpress.org/extend/plugins/find-replace/

It's work to 3.0.5 and It should work on 3.1.3 too. Anyway back up your database first.


not in one go, but more comfortable than do it one by one by hand.

[akibaba]

http://wordpress.org/extend/plugins/find-replace/

I think this will not work for such as:

replace
http://www.filesonic.com/file/1246786931/file.part1.rar

with
http://www.filesonic.com/file/1143784991/file.part1.rar


Where the filename file.part1.rar in both link is same.

[qloolp]

I think this will not work for such as:

replace
http://www.filesonic.com/file/1246786931/file.part1.rar

with
http://www.filesonic.com/file/1143784991/file.part1.rar


Where the filename file.part1.rar in both link is same.

If I were you, I'll try

search : 1246786931/file.part1.rar
replace : 1143784991/file.part1.rar


It should work.

but 20k+ link replace is pain in the ass

You need some custom php that do it automatic. Unfortunately I think that there are no free code to make this job done.

[akibaba]

but 20k+ link replace is pain in the ass

You need some custom php that do it automatic. Unfortunately I think that there are no free code to make this job done.

Yes a simple custom php code that can connect to mysql server and issue some MYSQL commands to search and replace is what I need now.

[xTreme]

it will work , but u have to manually replace all links

[akibaba]

it will work , but u have to manually replace all links

Impossible, there is 20k+ links that is dead, so I seek for some code that can search for unique file name and replace the old links with new links automatically.

I am willing to pay for it if someone can provide me with such a code.