[mythtv-users] help needed: mythfilldatabase does not fill database (mysql error 130)

[Bruce Markey]

Bruce Markey wrote:
...
> Well, that's the point. The "-r" is for "repair". It should
> print error messages when it got to the damaged file when it
> was *repairing* it. Running it a second time should show no
> errors if it was fixed the first time. See www.mysql.ord for
> more info.

Scratch that. I see now in your earlier message that you did
try to repair it but you still get the errors.

First, get a backup as best you can now before things get any
further out of hand.

http://www.mythtv.org/docs/mythtv-HOWTO-21.html#ss21.5

Then try this:

mysql -r -u mythtv -pmythtv mythconverg
mysql> truncate table program;

then repair again. This will drop all the data while saving the
table column info. This might get rid of the bogus data files
in the process.

If that doesn't work make sure you have a backup file and look
for the line "CREATE TABLE program (" and about 30 lines ending
with ") TYPE=MyISAM;". Cut'n'paste these into a file, say,
"progtbl.sql". You could then "drop table program;" then recreate
it with:

mysql -u mythtv -pmythtv mythconverg < progtbl.sql

I would really expect that you should have no errors at this
point but if you have to drop the whole mythconverg database
or reinstall mysql server (doubt it ;-) or whatever, you can
still just do:

mysql -u mythtv -pmythtv mythconverg < mythtv_backup.sql

to get back to the last state then rerun mythfilldatabase to
fill the program table.

--  bjm