[mythtv-users] Mysql troubles

Friedrich Clausen fred at derf.nl
Fri Oct 31 09:13:17 UTC 2008


Hello,

> Bob wrote:
<snip>
> 081030 15:59:30  mysqld started
> 081030 15:59:31 [Warning] option 'max_join_size': unsigned value
> 18446744073709551615 adjusted to 4294967295
> 081030 15:59:31 [Warning] option 'max_join_size': unsigned value
> 18446744073709551615 adjusted to 4294967295
> 081030 15:59:31  InnoDB: Started; log sequence number 0 61321
> 081030 15:59:31 [Note] /usr/sbin/mysqld: ready for connections.
> Version: '5.0.68'  socket: '/tmp/mysql.sock'  port: 3306  Source
> distribution
> 081030 16:25:14 [Note] /usr/sbin/mysqld: Normal shutdown
>
> 081030 16:25:14  InnoDB: Starting shutdown...
> 081030 16:25:14  InnoDB: Shutdown completed; log sequence number 0 61321
> 081030 16:25:14 [Note] /usr/sbin/mysqld: Shutdown complete
>
> 081030 16:25:14  mysqld ended
>
> 081030 16:49:28  mysqld started
> 081030 16:49:28 [Warning] option 'max_join_size': unsigned value
> 18446744073709551615 adjusted to 4294967295
> 081030 16:49:28 [Warning] option 'max_join_size': unsigned value
> 18446744073709551615 adjusted to 4294967295
> 081030 16:49:28  InnoDB: Started; log sequence number 0 61321
> 081030 16:49:28 [ERROR] /usr/sbin/mysqld: Can't find file:
> './mysql/host.frm' (errno: 13)
> 081030 16:49:28 [ERROR] /usr/sbin/mysqld: Can't find file:
> './mysql/host.frm' (errno: 13)
> 081030 16:49:28 [ERROR] Fatal error: Can't open and lock privilege tables:
> Can't find file: './mysql/host.frm' (errno: 13)
> 081030 16:49:28  mysqld ended
>
> (END)
>
>
> Here's the current permissions in /var/lib/mysql:
>
> ~ # ls -laF /var/lib/mysql
> total 20592
> drwxr-xr-x  7 mysql mysql     4096 2008-10-30 16:49 ./
> drwxr-xr-x 21 root  root      4096 2008-10-30 16:34 ../
> drwx------  2 mysql mysql     4096 2008-10-30 16:47 ampache/
> -rw-r-----  1 mysql mysql  5242880 2008-10-30 16:49 ib_logfile0
> -rw-r-----  1 mysql mysql  5242880 2008-10-30 16:47 ib_logfile1
> -rw-r-----  1 mysql mysql 10485760 2008-10-30 16:47 ibdata1
> drwx------  2 mysql mysql     4096 2008-10-30 16:47 mysql/
> -rw-r-----  1 mysql mysql    35045 2008-10-30 16:49 mythbox.err
> drwx------  2 mysql mysql    12288 2008-10-30 16:48 mythconverg/
> drwx------  2 mysql mysql     4096 2008-10-30 16:48 torrentflux/
> drwx------  2 mysql mysql     4096 2008-10-30 16:48 torrentfluxb4rt/
> ~ #
>
>
> I tried finding the file host.frm it's looking for, and found it:
>
> /var/lib/mysql # sudo find -iname "*host*"
> ./mysql/host.MYI
> ./mysql/host.frm
> ./mysql/host.MYD
> /var/lib/mysql #
>
> Dunno what to do here??
>
> Bob

It seems that your MySQL is looking for its data in the wrong place,
what is the contents of your /etc/my.cnf? (if present). Did your
previous installation use /var/lib/mysql?

Cheers,

Fred.


More information about the mythtv-users mailing list