View Single Post
Old 06-06-2016, 05:04 AM  
j3rkules
VIP
 
j3rkules's Avatar
 
Industry Role:
Join Date: Jul 2013
Posts: 22,112
The next time you can use an affiliate link cloaking plugin so you do not need to change the link in all posts manually.

Here what you can do:

1. Download your wordpress database and saved it as a backup.

2. Copy the backup to another location and opened it in a text editor (text wrangler in my case).

3. Search for the old link, then used the 'replace all' command to replace it with the new one. It found several thousand instances of the old link and replaced them all.

4. In PHPmyAdmin, drop all the tables then import the modified database file. All of the links will be fixed.
j3rkules is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote