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:
- much of it is over my head, and
- no queries listed.