Title: Retrieve Posts from Raw WordPress Files Last modified: August 19, 2016 --- # Retrieve Posts from Raw WordPress Files * [jdang307](https://wordpress.org/support/users/jdang307/) * (@jdang307) * [16 years, 3 months ago](https://wordpress.org/support/topic/retrieve-posts-from-raw-wordpress-files/) * Ok, I had a wordpress installation, and while I never did a proper backup, I copied all the files and folders via FTP to my computer. So I have those. * I went to upgrade WP and it screwed up my install. Kept returning an SQL error over and over again. The one button upgrade was no good. So now, I have to delete everything and reinstall WP. But I want my posts to go back in. Losing themes, etc. I dont’ care about. I just want the raw posts in there. * How do I retrieve those from the raw files, and insert them back into the new install? I tried looking for a folder or file with it but couldn’t. Viewing 8 replies - 1 through 8 (of 8 total) * [esmi](https://wordpress.org/support/users/esmi/) * (@esmi) * [16 years, 3 months ago](https://wordpress.org/support/topic/retrieve-posts-from-raw-wordpress-files/#post-1368670) * Your posts weren’t stored in files. They were (are?) stored in your database. * [MichaelH](https://wordpress.org/support/users/michaelh/) * (@michaelh) * [16 years, 3 months ago](https://wordpress.org/support/topic/retrieve-posts-from-raw-wordpress-files/#post-1368673) * Might try rebuilding your database tables: [How do you repair a MySQL database table?](http://codex.wordpress.org/FAQ_Troubleshooting#How_do_you_repair_a_MySQL_database_table.3F). * Might also ask your host if they have backups they might restore for you. * For the future review [WordPress Backups](http://codex.wordpress.org/WordPress_Backups). * Thread Starter [jdang307](https://wordpress.org/support/users/jdang307/) * (@jdang307) * [16 years, 3 months ago](https://wordpress.org/support/topic/retrieve-posts-from-raw-wordpress-files/#post-1368924) * Thanks guys (girls?), learn something new everyday. Luckily I learned this mistake at the beginning of my WP ventures. * Thread Starter [jdang307](https://wordpress.org/support/users/jdang307/) * (@jdang307) * [16 years, 3 months ago](https://wordpress.org/support/topic/retrieve-posts-from-raw-wordpress-files/#post-1368925) * Hmm, I remember now, I did do a wordpress backup properly (right after my SQL table got messed up). I have a file called “valueinv_wrdp1” SQL File, valueinvestingcenter is my domain. * Yes, so I went to reinstall wordpress, then attempted to import this file into the new wordpress, but it would break in the exact same manner. Should I reimport, then repair the tables as said here? * Thread Starter [jdang307](https://wordpress.org/support/users/jdang307/) * (@jdang307) * [16 years, 3 months ago](https://wordpress.org/support/topic/retrieve-posts-from-raw-wordpress-files/#post-1368927) * Ok, I reinstalled WP, because it wouldn’t even load anymore (blank home page). After I made sure I can even see the wordpress install (I can, with one Hello World post) I went to myphpadmin and imported the SQL file. Again, site is broken. Just a blank white page. I then went to myphpadmin and analyzed all tables, they are all ok. Repaired all tables, they say they are ok. But nothing shows up, again. * So I go into the wp-admin area, it says database must be updated. So I do that, and it lets me into the admin area (but nothing shows up still on the regular site) and when I go in, there is absolutely nothing imported. NO posts, nothing. * Is my stuff lost? If so, I can accept that. But would love to figure out how to get just the posts in. Or maybe my backup has no posts in it at all anyway. * EDIT: Sorry for the triple post, I didn’t even realize it until now. * [esmi](https://wordpress.org/support/users/esmi/) * (@esmi) * [16 years, 3 months ago](https://wordpress.org/support/topic/retrieve-posts-from-raw-wordpress-files/#post-1368939) * > I did do a wordpress backup properly (right after my SQL table got messed up). * Chances are that there’s something in that backup that is causing the problem. Do you have a slightly earlier backup? * [Jonas Grumby](https://wordpress.org/support/users/ss_minnow/) * (@ss_minnow) * [16 years, 3 months ago](https://wordpress.org/support/topic/retrieve-posts-from-raw-wordpress-files/#post-1368942) * Yes, by your own description you made the backup after the data was messed up. Try to repair the database as Michael suggested. For the future, think about using a plugin like WP-DBManager and have it back up your database regularly. You can also use it to make a one-time backup before you make any major changes, and you can use it to easily revert to an earlier backup. * [Jonas Grumby](https://wordpress.org/support/users/ss_minnow/) * (@ss_minnow) * [16 years, 3 months ago](https://wordpress.org/support/topic/retrieve-posts-from-raw-wordpress-files/#post-1369006) * BTW [WP-DBManager](http://wordpress.org/extend/plugins/wp-dbmanager/) also has a database repair function built into it. Viewing 8 replies - 1 through 8 (of 8 total) The topic ‘Retrieve Posts from Raw WordPress Files’ is closed to new replies. * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) * 8 replies * 4 participants * Last reply from: [Jonas Grumby](https://wordpress.org/support/users/ss_minnow/) * Last activity: [16 years, 3 months ago](https://wordpress.org/support/topic/retrieve-posts-from-raw-wordpress-files/#post-1369006) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics