WordPress global search and replace
I moved this site from blog.jamesjpn.com to jamesjpn.net. A problem I faced was there were 678 lines of code that pointed to photos on the blog.jamesjpn.com server and I needed to edit the posts to point the links to the new server on jamesjpn.net. Thanks to http://www.barrywise.com/2009/02/global-find-and-replace-in-wordpress-using-mysql/ I learned how to do a global search and replace in the Sql section of phpMyAdmin!
UPDATE wp_posts SET post_content = REPLACE(post_content, ‘blog.jamesjpn.com’, ‘jamesjpn.net’)
It would have taken me a long time to do the job by editing each post, whereas Sql did a global search and replace of 678 lines of code in only 0.8187 of a second!
Related posts:
Restoring a large WordPress Database
WordPress Security: Checking for backdoors
Using mencoder to convert a .VOB file to a .flv file
The CFR - Illuminati - Federal Reserve - Rothschild - Vatican Connection
Creating mutilingual WordPress sites
Speeding up WordPress Blogs
Removing the WWW sub-domain for search engine optimization
Blocking comment spam in WordPress
WordPress tricks: Creating a menu on a page using images from a category
Opus Dei’s Influence Over Governments
California Fires - What We Know - By Ralph Epperson
WordPress Webmaster Woes
How To Get Text from an Image Only PDF File Using Linux
James Japan Moved to New Web Hosting Service
WordPress Power
WordPress - How to assign categories and tags to pages
WordPress power
The Navy's Negative Reaction To Bill Cooper Reporting a UAP
Please follow and like us:
(Visited 71 times, 1 visits today)