Title: Lost posts Last modified: August 19, 2016 --- # Lost posts * [davidrourke](https://wordpress.org/support/users/davidrourke/) * (@davidrourke) * [17 years, 4 months ago](https://wordpress.org/support/topic/lost-posts-3-2/) * Hi. * I’ve lost the posts on my WP 2.7 blog. * [http://www.rourkevisualart.com/wordpress](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](https://wordpress.org/support/users/samboll/) * (@samboll) * [17 years, 4 months ago](https://wordpress.org/support/topic/lost-posts-3-2/#post-932442) * before importing – did you reset your permalinks? * db backup [http://codex.wordpress.org/Restoring_Your_Database_From_Backup](http://codex.wordpress.org/Restoring_Your_Database_From_Backup) * [http://codex.wordpress.org/Backing_Up_Your_Database#Restoring_From_a_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](https://wordpress.org/support/users/davidrourke/) * (@davidrourke) * [17 years, 4 months ago](https://wordpress.org/support/topic/lost-posts-3-2/#post-932449) * 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](https://wordpress.org/support/users/samboll/) * (@samboll) * [17 years, 4 months ago](https://wordpress.org/support/topic/lost-posts-3-2/#post-932512) * strange – should be an import tab maybe ask your host about this * Thread Starter [davidrourke](https://wordpress.org/support/users/davidrourke/) * (@davidrourke) * [17 years, 4 months ago](https://wordpress.org/support/topic/lost-posts-3-2/#post-932554) * Samboll, * Thanks. I’ll do that. * Thread Starter [davidrourke](https://wordpress.org/support/users/davidrourke/) * (@davidrourke) * [17 years, 4 months ago](https://wordpress.org/support/topic/lost-posts-3-2/#post-932628) * 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. ## Tags * [database](https://wordpress.org/support/topic-tag/database/) * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/) * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 5 replies * 2 participants * Last reply from: [davidrourke](https://wordpress.org/support/users/davidrourke/) * Last activity: [17 years, 4 months ago](https://wordpress.org/support/topic/lost-posts-3-2/#post-932628) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics