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

Is WordPress multisite is good to go?

When multisite is on you have to be careful with your hosting. For example if you want a subdomain installation be sure your webhosting is ready for that because wildcards are necessary (~ subdomain such as *.yourdomain.com). In your case, everything is focused on users. To me you’d better use buddypress because it’s a great … Read more

Redirect WordPress MS to no-www version, excepting some dirs and prefixes

<IfModule mod_rewrite.c> RewriteEngine on #If whe’re using www. RewriteCond %{HTTP_HOST} ^www\.(.+)$ [NC] #prefixes to !^ ignore RewriteCond %{REQUEST_URI} !^/host RewriteCond %{REQUEST_URI} !^/aprobar RewriteCond %{REQUEST_URI} !^/wp-admin RewriteCond %{REQUEST_URI} !^/wp-login.php #See at the end about index.php RewriteCond %{REQUEST_URI} !^/index.php RewriteRule ^(.*)$ http://%1/$1 [R=301,L] </IfModule> When you’re using permalinks, WordPress do something like this to get the content: … Read more