All posts are gone

  • cipote

    (@cipote)


    15 years, 4 months ago

    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.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Paul

    (@pcgrejaldo)

    15 years, 4 months ago

    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.

    Thread Starter cipote

    (@cipote)

    15 years, 4 months ago

    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!

    Thread Starter cipote

    (@cipote)

    15 years, 4 months ago

    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?

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘All posts are gone’ is closed to new replies.