Melbourne Brisbane Computer Repairs, Website design & SEO

Posted: 02 Nov 2011 04:49 PM PDT

I had a heart-stopping moment a short while ago.

I was updating a blog post (just fixing some spelling errors), clicked save / update, and I got an error message that said something about there being do data and that maybe the article had been deleted.

So I refresh the page, but I get the same error.

I go back to my main blog page (which looks fine, since it is cached), but when I click on any blog post, I get a page not found error.

Next stop: the wordpress admin dashboard.

I quickly see that wordpress thinks I have zero posts, zero pages, 20 categories, and over 2000 tags

It looks like some things are ok, but all of my 850 posts have disappeared!

But I quickly remember that I setup the Computer Aid blog to perform a weekly database backup, so it shouldn’t be a total disaster.

But before I start restoring databases, I figure I’ll have a look at the database using myphpadmin:

log into my website cpanel
in the databases section, click on myphpadmin
in the phpmyadmin page, click on the wordpress database
in the list of database tables, click on the wp_posts table, and I get a message saying: wp_posts is marked as crashed and should be repaired

So it looks like I might be able to fix things without a database restore.

So I go back to the list of database tables, and at the bottom, I click on “check all”, and then to the right, I click on the “with selected” dropdown, and select “repair table” (be careful not to select “empty” or “drop” !).

After a few seconds, everything is fixed, and the Computer Aid blog is running once again.

Computers and Internet

Thursday, November 3, 2011

Melbourne Brisbane Computer Repairs, Website design & SEO

Melbourne Brisbane Computer Repairs, Website design & SEO

0 comments:

Archives

Credits