We just got a scary phone call. Don’t worry, everyone’s ok. We logged into one of our Wordpress sites and, while the backend was still there, all the posts and pages and comments were gone. G-O-N-E. Poof. Just like that. I went into the PHPmyadmin section of the control panel to look at the database and saw this error: “wp_posts” is marked as crashed and should be repaired.
After a mild heart spasm, I started searching the web furiously for a solution and thank goodness found this video, which calmly explained what to do and fixed the problem.
If you don’t feel like watching the video, here’s what I did:
1. Gather backups of everything. It is painstaking and takes a looong time, but better safe than sorry.
Find the most recent backup that was sent to your email via the WP-DB Backup plugin
Go into the PHPmyadmin in your hosting provider’s control panel, export the whole database as well as each table individually.
[Note: The table that crashed probably won't let you export it, and will give you this ugly message: Table 'wp_posts' is marked as crashed and should be repaired]
2. in PHPmyadmin, click the checkbox next to the corrupted table (ours was wp_posts). The table will probably say “in use”. Use the dropdown menu at the bottom to select “repair table”.
Lessons learned
1. Backup hourly or daily and send all backups to a separate email account so you don’t have to worry about it clogging up your inbox
2. Check your blog’s overhead column in PHPmyadmin at least once a month and repair any tables with a high overhead.
ThemeForest is a brand new online marketplace where you can buy and sell Wordpress, CSS, Joomla, Drupal and many other types of templates. I’m aware that I get overly excited about new theme/template sites, so I’ll try to tone down my excitement by putting my impressions into list format. Here are some reasons why you should check out ThemeForest.
The site stays true to the forest motif with a very nice color scheme, but thankfully a bear-free environment.
As I poked around, I found the navigation of the site brilliant – I love the tree chart that breaks down the site by template type (Joomla, Wordpress, CSS, etc.) and category. The breadcrumbs were also a nice touch and made it easy to find my way around.
I enjoyed the pretty thumbnails next to each template and had to hold back from opening up each template to take a closer look. I know how arduous the process is of making screenshots and then cropping it, resizing it, etc. so you can tell they’re putting a lot of work and detail into the site.
All templates start at $10 and most templates I liked were between $10-40, an amazing deal for unique and creative templates that I’ve never seen before.
Referral Program – If you refer a new person to ThemeForest and they buy a template, you get 50% of their purchase. Nice! Here’s an example of a badge you can put on your site
WPCandy’s Sweet Contest – WPCandy is giving away 5 sets of $25 to spend at ThemeForest. Check out WPCandy’s post here
To beef up their stock, ThemeForest is hosting a contest with prizes of $600 to template authors who submit the most templates by the end of September.
WP Scoop, which launched yesterday, is yet another digg-like site, that lists the most popular posts from around the web about Wordpress plugins, themes, hacks, or anything else that has Wordpress written all over it.
Playing on the scoop theme, the website claims that “New users should.. worry not, it is as easy as eating ice-cream.” Mmm.. Wordpress flavored ice cream… sounds delicious.
But here’s the real scoop – who’s behind it?
After a quick search, I couldn’t find any names, pictures, or hints as to who started it. Why are they hiding? C’mon, we don’t bite (unless it’s Ben&Jerry’s), we just want to give you credit and follow you on Twitter.
There's lots of great stuff out there for WordPress. I put this blog together so that I would have a place to organize the best information so that when I need it, I can easily find it. What better way to do it than with WordPress?
![[del.icio.us]](http://images.del.icio.us/static/img/delicious.small.gif){kind=small}
