iceaxeHi forums,
Summary
Posts can be made to the blog and are visible online, but are not being saved to the database.
Background
Hope you can help. I currently run a website which uses WordPress version 3.0.1 (I'll be upgrading soon). It runs on my Mac Os X server, with this config: Apache/2.2.20 (Unix) mod_ssl/2.2.20 OpenSSL/0.9.8r DAV/2 PHP/5.3.6. Its been running a long time on this server.
I had a server fail last week when a hard drive burned out. I've restored using some off the shelf backup software and realised that randomly the last 3 weeks or so of my blog data is missing. The backup is every hour so it should have been there as part of the mysql database.
This led me to investigate more.
Actions taken
I've restored the server and my blog, and used Google page cache to recover my lost posts. I've 're-posted' these to the blog. Next I did a database dump using 'mysqldump' and checked the database source SQL to ensure the lost posts had been written to the database - they had not.
So somehow I've got some data and posts on my blog, but they are not being saved to the database - yet still they are present on the blog.
The only change I've made recently to the blog was to enable Custom Structure permalinks (/%year%/%postname%/) about 3 weeks ago and its around this time that the problem seems to have began.
Example
This is an example post effected: http://www.fightgravity.co.uk/2011/broad-peak-2011/
And if I search a database dump for any contents of this post, such as the first sentence, it is not present.
s8consulting:backup Scott$ grep "Many thanks to our sponsor for Broad Peak 2011" all.sql
<no result>
Any ideas / tips?
I presume the data is being cached in mysql somehow? I'm really confused!
