When your MySQL database table gets corrupted–a good reason to switch from MyISAM to INNODB database type, apparently and you have to do it for the latest version of Moodle anyways–PHPMyAdmin won’t necessarily be good enough to fix it. I wrote about one approach to fix the problem here using no-cost software, but you can also use others as well, as I pointed out below….

Whatever the reason, it’s nice to know how to repair the database using a GUI interface. Note that there are other MySQL GUI tools–aside from Navicat Lite for MySQL–you can use, such as SQLYog for Windows and/or Sequel Pro for Mac…both of those are free, open source and no-cost as well.

SQLYog, which runs on Windows and GNU/Linux using WINE, can also come in handy. Here’s what the repair screen looks like once you go to TOOLS and choose TABLE DIAGNOSTICS:

Of course, I guess you could just do the optimization in PHPMyAdmin using SQL queries as described below (adapted from this source):

  1. Enter REPAIR TABLE tablename, for example, REPAIR TABLE StudentList.
  2. Click on GO button in PHPMyAdmin
  3. MySQL should now repair the table. 
So, you can repair your corrupt MySQL tables a variety of ways…as for me, I’d rather use a GUI tool like Navicat Lite or SQLYog but it’s nice to know other ways to accomplish the job.

Get Blog Updates via Email!
Enter your email address:

Delivered by FeedBurner
PingIt! pingthis();
Delicious Bookmark this on Delicious
Subscribe to Around the Corner-MGuhlin.org

Everything posted on Miguel Guhlin’s blogs/wikis are his personal opinion and do not necessarily represent the views of his employer(s) or its clients. Read Full Disclosure