How to Retrieve Your Most Recent Posts if Your WordPress Database Crashes
This is about the worst thing that can happen to your WordPress world. Hopefully you have a backup. If you make daily backups then you’re doing just fine. However, if you make weekly backups, then you may be missing about a week’s worth of posts. Oh noes! You worked hard to write those. How can you get them back? Chances are that Google probably has cached versions of your most recent work. Google your site or the specific posts you want back and start the copy and paste process.