One option is setting the site’s URL in the wp-config.php file itself. This effectively overrides the siteurl option that’s otherwise stored in the database, but it also means you can reference the URL without doing a query. From the Codex: It is possible to set the site URL manually in the wp-config.php file. Add these … Read more
One thing you can do to help reduce the amount of bloat is add a plugin that controls the number of previous revisions kept for Pages, Posts, etc (preferably one that allows for separate values for each type, such as last 5 revisions for pages and last 20 revisions for posts, or whatever.) There are … Read more
So after @Nicolai found that blurb in the WP source confirming that I can’t use multiple parameters in the orderby if I am ordering by relevance I had to go a different route. However, this route only works if I don’t care for pagination. There probably is a way to put it back, but I’m … Read more
Have a look at this older question: How to: Easily Move a WordPress Install from Development to Production?. It covers migration and deployment of WP installations. For your more immediate issue, do backups of your database. Use a backup plugin (WP-DB-Backup is what I use, find it on the WP plugins repository) to handle this … Read more
Yes, but that is out of quick and easy realm. See HyperDB in Codex and repository for starters.
It is possible but you must manually create a new instance of the wpdb class with right settings for your other database. Quote from the wpdb Codex page: The $wpdb object can talk to any number of tables, but only one database: the WordPress database. In the rare case you need to connect to another … Read more
First of all, the prefix is only a configuration option and not a security feature. The reason is that once an attacker has access to your database, he can find out any exisiting table prefix within seconds. There’s no way this obscurity protects you from any attack. For the prefix itself, WordPress asks you to … Read more
You’re probably running into the joys of MySQL’s MyISAM engine… From within MySQL (or PhpMyAdmin), use REPAIR TABLE xyz statements again, repeatedly, on each of your tables (or rather, your terms related tables, since these are the ones that sound corrupt) to see if this solves anything. If those fail, there are a few documented … Read more
It’s not stored as attribute, but as list of all stickies. Snippet from core: $sticky_posts = get_option(‘sticky_posts’); So look for the option and then use IDs to retrieve posts.
this comes down to a simple one line and there is no need to get all of the children using: $featured image_id = get_post_meta( $post_id, ‘_thumbnail_id’, true );