Have developed a site on the production box using a temporary address (http://IP-adddress).

Now it’s time to go live. Once, ages ago, I successfully used phpMyAdmin and did a search/replace, but am wondering if it’s still “the best” way to go.

Will these work okay, still? The site is in WordPress 3.0.1.

update wp_options set option_value=replace(option_value,'OLD URL','NEW URL') where option_value like "%OLD URL%";    
update wp_posts SET guid=replace(guid, 'OLD URL','NEW URL');
update wp_posts SET post_excerpt=replace(post_excerpt, 'OLD URL','NEW URL');
update wp_posts SET post_content=replace(post_content, 'OLD URL','NEW URL');    
update wp_postmeta SET meta_value=replace(meta_value, 'OLD URL','NEW URL');

I’ve read a number of related posts here, but none with the actual queries.

I thought this search and replace plugin sounded promising, but the only documentation I found was in German, which I can’t read, so I’m too cautious to try it.

And this thread about moving from development to production has lots of information in it, but:

  1. much of it is over my head, and
  2. no queries listed.

TYIA,

Mike

3 Answers
3

Yes, these queries still work.

This is a complete how-to: http://web-kreation.com/tutorials/migrating-a-wordpress-site-ftp-phpmyadmin-and-sql-queries/

Tags:

Leave a Reply

Your email address will not be published. Required fields are marked *