Thursday, November 11, 2010

Repairing MySQL table to ensure proper functioning of MythTV

MythTV is a home entertainment application, which is freely available as a open source solution for live streaming programs, and converts into a computer with the necessary supporting hardware components. This application is able to run on different operating systems such as Linux, Macintosh, FreeBSD, etc and primarily uses MySQL database as the backend to store the recordings. Having started in 2002, this application has undergone several developments and now is a competent combination of a TV and a computer. Having said that, at times you may face some issues while operating on the MythTV. Sometimes these issues may be because of corrupt database that can appear because of several reasons including virus infections, abrupt or unplanned system shutdowns, etc. You should try to fix such issues by using in-built MySQL methods failing which the use of a third-party MySQL repair software to repair MySQL database is a must.

Let us consider a situation in which you are watching MythTV but are unable to fast forward the programs. You tried to check the 'mythconverg.recordedseek' table to see if the data is alright by retrieving the records but you get the following error message repeatedly:

"MySQL error code 145 = Table was marked as crashed and should be repaired"

Cause:

The most prominent cause of this issue is that the database for the MythTV programs has damaged. Due to this, you are unable to properly operate MythTV.

Resolution:

To resolve this problem by recovering MySQL database, you should perform the following steps:

First of all, you should check the table for errors using the following command: CHECK TABLE recordedseek; You should run the 'REPAIR TABLE' command on the damaged table using the following syntax: REPAIR TABLE recordedseek; Then, rebuild the 'mythcommflag' using the following command: mythcommflag --rebuild -f

After running the aforementioned commands, try to reproduce the steps that resulted in the error. It should run perfectly now. However, if the problem is still persisting, then you should repair MySQL database using a third-party MySQL database recovery software. These tools are absolutely safe to use that do not damage the existing database while performing the database recovery.

The most recommended software the repairs different MySQL database (InnoDB and MyISAM) engines is Stellar Phoenix Database Recovery for MySQL. With the ability to repair different types of MySQL files such as .myd, .frm, .myi, .ibdata, and .ibd, this software repairs several objects including tables, view, database keys, etc. Supporting MySQL 3.x, 4.x, 5.x, and 6.x versions, this MySQL repair tool is compatible with Windows 7, Vista, Server 2003, XP, and 2000.


Resource: http://goarticles.com/cgi-bin/showa.cgi?C=3571219