I have a Wordpress installation that has a corrupt table, wp_posts. Unfortunately, I also had two hard drives fail recently and I do not have a backup of this database.
I want to make a local backup before I attempt to repair the table, but when I go to export the database as sql, I'm not able to get a complete backup. When I backup through wordpress, if gives me an error but gives me an sql file anyway, missing the data for this table. When I try to access the database directly and dump it, I get a 1kb file with no data in it.
I have seen online that a number of people have successfully repaired their Wordpress tables. There is even a script now that attempts to do this automatically. However, it would make me feel a lot better to get a local, broken copy of the db to operate on. Does anyone have any advice on how to do this?
Thank you. P.S. I use a GUI called Heidi SQL to access the db remotely.