Your posts weren’t stored in files. They were (are?) stored in your database.
Might try rebuilding your database tables: How do you repair a MySQL database table?.
Might also ask your host if they have backups they might restore for you.
For the future review WordPress Backups.
Thanks guys (girls?), learn something new everyday. Luckily I learned this mistake at the beginning of my WP ventures.
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?
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.
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?
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.
BTW WP-DBManager also has a database repair function built into it.
