All my blog posts are gone. When I repaired the post tables, it said:
blog.wp_post2cat Message: Number of rows changed from 133 to 0
blog.wp_postmeta Message: Number of rows changed from 6403 to 0
blog.wp_posts Message: Number of rows changed from 10760 to 0
I've contacted Yahoo (where my blog is hosted) and they said that it's a WordPress issue and they don't provide any WordPress help besides the installation process they have.
I've got a backup from December 8th.
Any idea where those posts have gone and how I could retrieve them? Or would I have to go back to my Dec 8th backup?
Thanks for any help with this.
Sadly when data in these tables are wiped, there is no way to get it back unless a backup exists before it was wiped.
Best bet is to restore the tables from whatever backup you have.
Thanks so much for getting back to me on this issue. I was afraid I would have to do this. Any idea why the data could have gotten wiped?
The last action I did was a post entry with three images. When uploading the images I started seeing some irregularities. It would upload the image but it would give me a 0 pixel by 0 pixel size.
Oh well! I'll attempt to restore from backup.
Thanks again!
While trying to import the backup, I get this error:
Error
SQL query:
# WordPress MySQL database backup
#
# Generated: Wednesday 8. December 2010 23:15 UTC
# Hostname: mysql
# Database: blog
# --------------------------------------------------------
# --------------------------------------------------------
# Table: wp_categories
# --------------------------------------------------------
#
# Delete any existing table wp_categories
#
DROP TABLE IF EXISTS wp_categories ;
MySQL said:
#1046 - No database selected
Any idea how to get passed this?
cipote
greiz