↓
 

Computer Aid

Ph: 0402 133 866

  • Home
  • Blog
  • Contact
  • Web Services
    • Websites
    • SEO
    • Hosting
    • Domain Names
    • Portfolio
Home→Tags phpmyadmin

Tag Archives: phpmyadmin

Repair wordpress MySQL tables using phpmyadmin

Computer Aid Posted on 3 November, 2011 by Luigi Martin3 November, 2011

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.

Posted in Technical | Tagged phpmyadmin, repair mysql, wordpress

Archives

Categories

Recent Comments

  • Sue Jones on outlook error 0X800ccc0e while sending emails
  • Blair Newmann on AdSmartMedia advertising
  • Private Investigator in GTA on Divorce, consent orders, and superannuation splits: getting the wording correct

Tags

802.11g ADSL amd android bigpond broadband bsod defender dell email exitjunction firefox firewall gmail Google google contacts ie7 infection internet connection ISP laptop Linux m1188a ntldr is missing office 2007 outlook outlook express password power supply problems ram registry repair install sata scam slow telstra thunderbird usb vista wifi windows 7 wireless wordpress xp
Copyright © 2005-2015 Computer Aid
↑