I’ve recently had to backup a mysql database (wordpress) as we are moving to a new server.
I opened it out of interest and found all sorts of spurious rubbish which has nothing to do with our site or subject matter…and definitely no content we ever entered! Here’s a sample of typical stuff which accounts for a significant proportion of the sql file:
This post is about the @WordPress Twitter account, so if you don’t use Twitter, or don’t care about Twitter, then feel free to take the time you might have spent reading this post to go play outside (or an equivalent) instead.
n
Okay, so, Twitter! When all those apps started popping up using the Twitter API, things like automatically following anyone who followed you and sending an automatic Direct Message seemed like good ideas. We’re all friends, right? Wrong. That auto-follow bit us hard, and the huge amount of spam the account gets means that it’s been nearly impossible to monitor legitimate messages from WordPress users and developers who need to be pointed to a help resource. We’re sorry! Just as we needed to get …” etc etc. and there’s acres of this stuff!
It sounds like some kind of RSS chatter to me, but why the hell is it clogging up my database!
Anyone with any knowledge of wordpress or mysql, your comments most welcome!
I’ve recently had to backup a mysql database (wordpress) as we are
moving to a new server.
I opened it out of interest and found all sorts of spurious rubbish
which has nothing to do with our site or subject matter…and
definitely no content we ever entered! Here’s a sample of typical
stuff which accounts for a significant proportion of the sql file:
“0:{}s:8:“xml_base”;s:0:”“;s:17:“xml_base_explicit”;b:0;s:
8:“xml_lang”;s:0:”“;}}}s:32:“DCMI: DCMI Metadata Terms”;a:1:
{s:7:“creator”;a:1:{i:0;a:5:{s:4:“data”;s:11:“Ryan Markel”;s:
7:“attribs”;a:0:{}s:8:“xml_base”;s:0:”“;s:17:“xml_base_explicit”;b:
0;s:8:“xml_lang”;s:0:”“;}}}}}i:29;a:6:{s:4:“data”;s:13:“n n n n
n n n”;s:7:“attribs”;a:0:{}s:8:“xml_base”;s:0:”“;s:
17:“xml_base_explicit”;b:0;s:8:“xml_lang”;s:0:”“;s:5:“child”;a:2:{s:
0:”“;a:5:{s:5:“title”;a:1:{i:0;a:5:{s:4:“data”;s:23:“Dev Blog:
Tweet, Tweet!”;s:7:“attribs”;a:0:{}s:8:“xml_base”;s:0:”“;s:
17:“xml_base_explicit”;b:0;s:8:“xml_lang”;s:0:”“;}}s:4:“guid”;a:1:
{i:0;a:5:{s:4:“data”;s:40:“WordPress News – The latest news about WordPress and the WordPress community?
p=1297”;s:7:“attribs”;a:0:{}s:8:“xml_base”;s:0:”“;s:
17:“xml_base_explicit”;b:0;s:8:“xml_lang”;s:0:”“;}}s:4:“link”;a:1:
{i:0;a:5:{s:4:“data”;s:53:“April 2010 – WordPress News
tweet-tweet/”;s:7:“attribs”;a:0:{}s:8:“xml_base”;s:0:”“;s:
17:“xml_base_explicit”;b:0;s:8:“xml_lang”;s:0:”“;}}s:
11:“description”;a:1:{i:0;a:5:{s:4:“data”;s:3977:”
This post is
about the @WordPress
Twitter account, so if you don’t use Twitter, or don’t care about Twitter, then
feel free to take the time you might have spent reading this post
to go play outside (or an equivalent) instead.
n
Okay, so,
Twitter! When all those apps started popping up using the Twitter
API, things like automatically following anyone who followed you
and sending an automatic Direct Message seemed like good ideas.
We’re all friends, right? Wrong. That auto-follow bit us
hard, and the huge amount of spam the account gets means that
it’s been nearly impossible to monitor legitimate messages
from WordPress users and developers who need to be pointed to a
help resource. We’re sorry! Just as we needed to get …" etc
etc. and there’s acres of this stuff!
It sounds like some kind of RSS chatter to me, but why the hell is
it clogging up my database!
Anyone with any knowledge of wordpress or mysql, your comments most
welcome!
It looks like a cache of somebody’s RSS feed. You may have some
feature in WP or a third-party module for WP that is gathering other
people’s feeds. If so, the smart thing to do is cache them so you
don’t have to wait on their server with every page view, and only
check the last-saved date once in a while. I don’t use WP here, but
the basic pattern seems to indicate that’s what’s happening for you.
Walter
On Apr 17, 2010, at 7:45 AM, hugh wrote:
Hi David
How did you match all that text in Google?..anyway, well found.
But what does it mean? And why is it getting into my database?