Posts disappearing; fixed with MySQL export/import??

  • Resolved chuckhendo

    (@chuckhendo)


    14 years, 7 months ago

    I’m having an issue with one of my WordPress sites. Basically, everything is working fine until the user adds a new post. Occasionally, this will cause all of the posts and pages on the site to “disappear”. They still show up on the total count at the top of the posts page (but no actual posts listed) – and they are still in the database. They just don’t show up on the site.

    The strange thing is – exporting the database from PHPMyAdmin and reimporting it fixes the problem every single time. And I don’t mean importing a backup, I mean importing the EXACT same database that had the problem.

    Any idea of a solution for this?

Viewing 4 replies - 1 through 4 (of 4 total)
  • kostas123

    (@kostas123)

    14 years, 7 months ago

    Switch over to the default theme and disable all plugins .
    What are the results ???

    Thread Starter chuckhendo

    (@chuckhendo)

    14 years, 7 months ago

    Well, that would be VERY difficult to do as its a production site. I moved the site to our own server and it seems to be working fine?

    kostas123

    (@kostas123)

    14 years, 7 months ago

    I’m not sure that your database is the root of your problem .
    WP-Optimize: This is a database cleanup and optimization tool. It allows you to remove post revisions, comments in the spam queue, un-approved comments within few clicks.
    A good practice would be to re-uplad the WordPress core-files , not the content in the wp-content folder .
    First Back-up .

    Thread Starter chuckhendo

    (@chuckhendo)

    14 years, 7 months ago

    It seems that it was an issue with the server and permalinks. IIS – always a good time. Thanks kostas123!

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

The topic ‘Posts disappearing; fixed with MySQL export/import??’ is closed to new replies.