It might be possible to get your stuff back, depending on what you have to work with.
My old WordPress site got corrupted when I tried to change the domain.
What does ‘corrupted’ mean? What was happening? How did you decide that the ‘site’ was corrupted? Was the database corrupted? Or do you not know?
Then I carefully chose the database entries that seemed safe to export and imported it into the new database. So in the end I exported everything but the options table.
How did you export? PhpMyAdmin or similar database tool? The WP backend?
The site went white when we changed the domain, and I did everything plus much more to recover it, and then I tried to go back to the old domain, and restoring, but that one got white aswell.
Now I see that the database from that site is corrupted somehow – the post content got replaced with these “links”. (wp_posts table, post_content cells) Instead for the actual texts.
O_O
Upon realizing that I used an old backup from 5 days ago and restored that one – posts appeared! But, well, old, and not entirely good either, some characters wrong, truncated on some places, etc. And the last 5 days of work, and fine polishing… – gone. 🙁
And some posts says it has got 12 comments, but it really has none, etc. 😉
What’s paining me most is the last days work. 🙁
Working with PhpMyAdmin.
Wow. I’m sorry. What you’ve got in those database files is all you’ve got I’m afraid. I don’t know how changing domains could have done this unless you were changing hosts too.
I think you are going to have to reconstruct with what you’ve got. I’d think that pasting your surviving text into new posts and then deleting the old ones is your best approach since you’ve obviously got some strange things going on with comments and such. Again, sorry. Without a good database backup I’m not sure what you can do.
I am finished now, it is working nicely now. The 3 days old backup was good, and I pasted from there. I only had to recreate 3 posts from memory and thankfully it was not so hard, small posts.
I purged all comments, went in database and did them nice zeroed.
Now the site is working nicely. I hope so at least. 🙂
And oh, the truncated posts of the old backup, it is not the backup, but the import. Somehow the import truncated the posts once it reached to a special character. AS it wasn’t so many posts, maybe 10-15 posts, I opened the SQL backup in text editor and pasted manually, and it is good now.