[mythtv-users] Upgrade to 2.6.17-gentoo-r2/ivtv-0.7.0/mythtv-0.19_p9163-r1 and having problems

[Mark Knecht]

On 7/16/06, John Johnson <johnatl at mac.com> wrote:
> Mark Knecht wrote:
> ...
> > 060716 14:58:17 [Warning] './mysql/db' had no or invalid character
> > set, and default character set is multi-byte, so character column
> > sizes may have changed
> > 060716 14:58:17 [ERROR] Fatal error: mysql.user table is damaged or in
> > unsupported 3.20 format.
> > dragonfly mysql #
> >
> You might try:
> mysqld_safe –skip-grant-tables –user=root &
> mysql_fix_privilege_tables
> pkill mysqld
> /etc/init.d/mysqld restart
>
>  From http://www.john-hunt.com/ , near the top of a Google search.
>
> Regards,
> JJ
>

John,
   Thanks. No luck. The commands ran fine but when I try to start up
mysqld I still get the message about something being in an unusable
3.20 format, as I posted earlier.

   I'm gonna bag this and just try to bring up M{th from scratch.
Right now we only have about 10 saved programs. No big deal at all if
I lose those. I'll rename them and they are watchable in mplayer so
nothing is really lost.

   I appreaciate your ideas and help. Thanks a lot and thanks to
others who have answered.

Cheers,
Mark