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.
|