Hi, If you guys don't mind i would like to ask how to change all the links in my wordpress blog. I know how to use Search and Replace but there is no guide how to also change the different sub of the links. For example, i want to change http://www.example.com/blabla/* (different links) to http://www.newlinks.com, you see there is a lot of different links need to be change. I hope you guys could help me. Thanks!
Try this plugin: http://wordpress.org/extend/plugins/search-and-replace/ Make sure you have a backup before using it. That plugin can change almost everything so a mistake could wreak your site.
Thanks, but actually i already stated in the first post that i already tried search and replace, the problem is i want to change the sub of the links. Let me quote my first post Any help would be really appreciated.
Ah sorry, I zoomed in on the links and overlooked that part No matter, you actually can change them with that plugin. Put http://www.example.com/blabla/ in the first box and put http://www.newlinks.com/ in the second box. It will substitute that part of each link but leave the rest untouched. I tested it with one link and it worked fine.
Again, thanks for your reply but actually i would like the rest of /blabla/ such as /blabla/etcetc to be substitute also with the http://www.newlinks.com I hope you can help me how to use it with the plugin. I am very appreciate your help. Anyway, i repped u,
Ok, that is a problem. The MySQL replace function only takes fixed strings, not wildcards. Search and Replace won't work because it uses that function. I think you can change the links using phpMyAdmin but I don't know what SQL command to use. Maybe someone in the MySQL forum can help you. Thanks for the rep but I probably don't deserve it
You would need to use phpmyadmin and some sql queries to do this. See here and if you want to see more examples, this google search. The best way to do it is to copy your Wordpress database then upload it again using phpmyadmin -- that's the database you should work on -- the copy. That way you have as many chances as you need in case you make a mistake or three. If you do, drop the database and upload it again. You are also going to have to do it in stages so that you get through all of the versions of the links you want to replace: /blabla/ , /blabla/etcetc , /blablablablabla ,.., <<-- your search strings -- i.e. http://whateverthedomain.com/blabla
I think he is looking for some plugins? If i'm not wrong. I developed one for my blog but don't know currently it is working or not. have a look http://etechdna.com/wp-frame-it-plugins-18416/
This is how I do it. I dont use phpmyadmin though I use Navicat for Mysql. Totally rockin remote mysql management tool.
there is another plugin that is good for changing urls when you move a site... http://wordpress.org/extend/plugins/velvet-blues-update-urls/