Tag Info

Hot answers tagged

2

If you just want to get rid of the \ characters in the string that's returned, you can use PHP's stripslashes(): $content = stripslashes( $content ); I'd recommend doing this on output rather than on input; WordPress adds the slashes as it sanitizes your data on insert, per update_option()'s Codex page, The $option (option name) value is escaped with ...


2

I'm running 3 WP blogs on a Debian Squeeze large instance and was investigating why mysql was stuck on that host at 200% CPU usage and system load between 3 and 6. Looking at a 'show process list' inside mysql, we understood the wp_option table was involved in this issue so we executed: alter table wp_options add index autoload_idx(`autoload`); After ...


2

The wp_rand function mixes up the randomization of random numbers with various means, and in between runs it stores the random seed so as to keep the shuffling going every run. The random_seed transient is where it stores that.


2

The only really interesting (and very important) part of the 3rd query is this: 'project_location_children', 'a:7:{i:22;a:1:{i:0;i:23;}...etc...}}' The a:n:{i:n; etc } stuff is a serialized PHP array. WordPress - for some historical reason - keeps track of term children in one option entry per taxonomy term. The painful thing is, that a lot of people ...


1

It is pretty hard to tell since you didnt give a lot of information, but First, make sure both sites connect to the same database. Then add those lines in the wp-config.php of each sites to make sure your sites are going to get the right value of wp_home and wp_siteurl depending on which server your are connected to : define('WP_HOME','http://' . ...


1

I used: DELETE FROM `wp_options` WHERE `option_name` LIKE ('%\_transient\_%'); to cleanup with great results :) (from here http://stackoverflow.com/questions/10422574/can-i-remove-transients-in-the-wp-options-table-of-my-wordpress-install)


1

WP uses the GUID column of posts for links. You need to replace that, I use a script http://interconnectit.com/products/search-and-replace-for-wordpress-databases/ Just drop it in your root dir then follow the instructions. Hope this helps!


1

Definitely a really bad idea. Just send what you need, exposing all this data publicly opens a lot (and some more) attack vectors.



Only top voted, non community-wiki answers of a minimum length are eligible