Successfully completing the steps described above will ensure that the DB tables are self consistent, but not that they contain all the necessary data for your recordings. The following thread contains directions for other things you may to do to complete the recovery after doing DB repairs. http://mysettopbox.tv/phpBB2/viewtopic.php?t=14002&highlight=mythcommflag

I had a problem last night with my program table that I was not able to correct with the normal methods but, came up with another solution and wanted to share it incase anyone has a similar problem.

Symptoms of the problem;
mythfrontend works fine but there is no guide data/ show listings/ channel info.
if you try to look at the mythconverg database through webmin it will tell you the program table is corrupt.

Results from an attempt to repair the table;
When trying all the different methods of repair the result with an error 5

If I shutdown the mysql and tried to copy the tables file program.MYI it would return an error because the file was corrupt..... This is when I new I was in trouble.

How I fixed the table

Code:

#su#mysqlmysql> TRUNCATE TABLE program;mysql>exit#mythfilldatabase

After mythfilldatabase completed all was good.

This method only works on a table that can be repopulated and where the data file is corrupt but the table schema is in tact.

The truncate table command deletes all the data in the table but leave the table structure in tact.

# Resatart the servers in the right order...start_mysqldstart_mythbackend

# Unlock the system again...unlock_myth

Does this script still work with 7.2? I tried the .py script for a table repair, and it didn't work for me, so I had to do the manual procedure outlined in this thread. But I would like to automate it with a cront script above.

Who is online

Users browsing this forum: No registered users and 6 guests

You cannot post new topics in this forumYou cannot reply to topics in this forumYou cannot edit your posts in this forumYou cannot delete your posts in this forumYou cannot post attachments in this forum