backup

Merging versions of wp_posts based on post_title

Found it with help from a Twitter follower! Might be handy for others. Get your backup table and import in to your live DB with a new name, e.g. wp_posts_updated. Then run this query: UPDATE wp_X_posts LEFT JOIN wp_posts_updated ON wp_posts_updated.post_name = wp_X_posts.post_name SET wp_X_posts.post_content = wp_posts_updated.post_content WHERE wp_posts_updated.post_name = wp_X_posts.post_name DON’T import your backup … Read more

Clone wordpress blog on localbox manually

you can use this tool http://interconnectit.com/products/search-and-replace-for-wordpress-databases/ to replaces the urls. The advantage over SQL replace is that the tool know how to handle serialized info in the DB. Being easy to sync is problematic requirement with the way you are trying to do things. If you need that, then you should simply change your localhosts … Read more

Backup wordpress installation on shared hosting

DNS establishes which IP address domain is pointing to. Load balancers are used precisely because it work like that and there needs to be single point of entry before load can be spread or redirected to multiple servers. Simply put shared hosting is not engineered or marketed for high reliability, that is whole other level … Read more

+ More