Changing database links has no effect

I can’t tell exactly what you are asking but this comment… What I did recently is that I created a wordpress dir on FTP server and move stuff there, but now people would have to input mydomain.com/wordpress to access my webpage… … makes me wonder it you don’t have a subdirectory install. If that is … Read more

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

Working local with one database

Set up a staging database on an online host and connect remotely from your various local dev environments. Might get a little confusing sharing 1 DB between many installs though.

Share WordPress Database

Does the WordPress installation has to use an exclusive database? If there are no table name conflicts, WordPress can share a database. Preventing conflicts is just a matter of setting a database prefix on install. By default, that prefix is wp_ but you can change it to anything you want within reasonable character limits. It … Read more