marktruman

So I have a ton of wordpress blogs, With a shitload of posts. Is there anyway to edit the url in them blog posts? I will be changing it to the same url. I think I heard of a way in phpmyadmin

WarChild

You want to change all occurrences of a single URL to a single new URL or you want to change multiple different URLS to be one new one?

__________________
.

TheDoc

UPDATE wp_posts SET post_content = replace(post_content, "/replace-this/", "/with-this/");

__________________

marktruman

Single URL to a different Single URL

marktruman

is that a command, where is that entered?

WarChild

That's an SQL statement to update your database that drives yoru blog at the database level. You must have access to your MySQLServer, correct?

__________________
.

alias

Nice.

__________________
https://porncorporation.com

TheDoc

If you're unsure what that is, it's best to ask your host to run it for you.... just tell them exactly what you want found and replaced and most hosts will gladly do it for you.

Otherwise, enter php my admin, access the wp db, hit the post table, click the SQL tab at the top, and enter that line.... after you change out what to replace. Your wp_posts table may be named differently.

UPDATE wp_posts SET post_content = replace(post_content, "www.oldurl.com", "newurl.com");

Screwing this up though can really screw some shit up... the last tab at the top, whatever it is, will let you duplicate the post table & structure to a new table name - highly recommended doing this if you've never ran a command like this before.

__________________

TheDA

There's a way to do it from WP with a plug-in as well.

http://lesterchan.net/portfolio/programming/php/ The DB manager there lets you edit SQL at that level.

It also lets you backup your database before you do it in case you fuck it up

TheDoc

Thanks... I just moved a ton of sites to multisite, so the line is fresh on the brain.

If you move to multisite from a standalone wp, you've gota run that to replace the content paths.

__________________

Paul&John

__________________
Use coupon 'pauljohn' for a $1 discount at already super cheap NameSilo!
Anal Webcams | Kinky Trans Cams Live | Hotwife XXX Tube | Get your Proxies here