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
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
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
I would make a backup and put it on a dev URL and test it to latest version. What plugins are being used?
Post restoration
Could be that the database for the local version is still connected to the live version. Check you wp-config file as not all host use local host for databases some use fixed addresses..
I think the best way to do it is just go direct into your phpmyadmin and export your database
version control for wordpress? (wordpress folder and database at same time)
Please refer to the official codex page: Moving WordPress within your site Go to Admin Panel -> Settings -> General. Change WordPress address (URI): (www.thess.com/welcome to www.thess.com) Change Site Address address (URL): (www.thess.com/welcome to www.thess.com) Move your files from subdirectory to root. That’s it.
Auto Update fail time my external folder deleted