![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
MythTV fix
Jul. 7th, 2008 07:09 pmWe had a power flicker this afternoon and the Myth box came up grumpy.
As a note to myself, this time the problem was that MySQL didn't want to come up. the solution was to make copies of the DB files over in /var/lib/mysql/mysql/*, run mysqld, note which files it was griping about being corrupt, deleting them, running /usr/bin/mysql_create_db, repeat until the DB comes up clean.
Then start mysqld as root and do "grant all on mythconverg.* to 'mythtv'@'localhost' identified by 'mythtv';
et voila.
Oh, this was just after the frog strangler of a rain that we had, in which another guy and I were getting completely soaked to the skin (well beyond that; jumping in a lake would have made no difference), putting tarps and plywood up to keep the rain out of the window wells at the church building (gutter still not installed). Too late, we had water on the floors. So after fixing Myth and getting a bite of dinner, I went back and ran the carpet cleaner to suck up water for an hour.
As a note to myself, this time the problem was that MySQL didn't want to come up. the solution was to make copies of the DB files over in /var/lib/mysql/mysql/*, run mysqld, note which files it was griping about being corrupt, deleting them, running /usr/bin/mysql_create_db, repeat until the DB comes up clean.
Then start mysqld as root and do "grant all on mythconverg.* to 'mythtv'@'localhost' identified by 'mythtv';
et voila.
Oh, this was just after the frog strangler of a rain that we had, in which another guy and I were getting completely soaked to the skin (well beyond that; jumping in a lake would have made no difference), putting tarps and plywood up to keep the rain out of the window wells at the church building (gutter still not installed). Too late, we had water on the floors. So after fixing Myth and getting a bite of dinner, I went back and ran the carpet cleaner to suck up water for an hour.
