Lost posts

  • davidrourke

    (@davidrourke)


    17 years, 4 months ago

    Hi.

    I’ve lost the posts on my WP 2.7 blog.

    http://www.rourkevisualart.com/wordpress

    Here’s what I did:

    I tried installing the most recent stable version of bbpress, sharing the WordPress database. When I told bbpress to integrate users, I lost my keymaster account and couldn’t log into bbpress. So I used WP-DBManager to delete all tables with bb_ in the name, then tried re-installing bbpress. The installation didn’t complete and sent me right to bbpress front page. I could log into admin now but posting produced a series of php error messages.

    I’m not concerned about bbpress, but big the blog is now hosed. It loads, but there are no longer any posts. I had a couple of hundred. I can get to the administration part of the blog, but there are no posts. WP-DBManager tried and failed to restore from a backup. I have .sql backups of the database file, but I have not been able to restore manually.

    I am not a MySQL person. I tried using my hosting provider’s database manager control panel to restore. It claimed success, but no change in status. I am using Godaddy, on a Linux account. The database is MySQL 4. I would have no objection to upgrading to MySQL 5 if that would help, but I don’t know how to do that (I tried at one point with a different database and messed it up).

    I tried logging into PHPMyAdmin to restore from a backup, but can’t figure out how to do that, even after looking in the Codex and Googling “WordPress restore.” The tutorials I’ve seen do not correspond to the admin screens I see. I cannot find any way to import a backed up database file, for example. Sorry for my lack of a clue here.

    Any help would be appreciated. Thanks.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Samuel B

    (@samboll)

    17 years, 4 months ago

    before importing – did you reset your permalinks?

    db backup
    http://codex.wordpress.org/Restoring_Your_Database_From_Backup

    http://codex.wordpress.org/Backing_Up_Your_Database#Restoring_From_a_Backup

    also most good hosts will do this for you

    Thread Starter davidrourke

    (@davidrourke)

    17 years, 4 months ago

    Samboli,

    Thanks. I did not know about permalinks and have now reset them.

    I’ve read the instructions in the Codex (although not a techie, I am not one to post support questions without doing research first).

    Here’s my problem. From the Codex:

    1. Login to phpMyAdmin.
    2. Click databases, and select the database that you will be importing your data into.
    3. You will then see either a list of tables already inside that database or a screen that says no tables exist. This depends on your setup.
    4. Across the top of the screen will be a row of tabs. Click the Import tab.
    5. On the next screen will be a Location of Text File box, and next to that a button named Browse.
    6. Click Browse. Locate the backup file stored on your computer.
    7. Make sure the SQL radio button is checked.
    8. Click the Go button.

    There is no Import tab. There’s an Export tab, but no Import–not anywhere in the interface that I can find. This is PHPMyAdmin 2.7.0. Is there any reason why that might be the case?

    Thanks again.

    Samuel B

    (@samboll)

    17 years, 4 months ago

    strange – should be an import tab
    maybe ask your host about this

    Thread Starter davidrourke

    (@davidrourke)

    17 years, 4 months ago

    Samboll,

    Thanks. I’ll do that.

    Thread Starter davidrourke

    (@davidrourke)

    17 years, 4 months ago

    OK.

    Called support and figured out how to upload the backup file. Did that successfully. I can now browse through the tables and all the information seems to be there.

    However, the admin panel still says there are no posts and no pages, even though I can find them in the database table. I have no idea how this should all be structured, but obviously WP is finding the database, but no post data.

    Any suggestions? Thanks.

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

The topic ‘Lost posts’ is closed to new replies.