[mythtv-users] Mysql troubles

[Bobby Gill]

>
> Before you do anything else, read up on LVM2, get comfortable with it,
> and put it into practice when you add your second hard disk.
>
> The database itself is easy to move...
>
> * Partition and format a filesystem on your 40G drive
> * Mount the 40G drive at a temporary mount point
> * Stop the mythtv processes
> * Stop mysqld
> * rsync -avp /var/lib/mysql/ ${TMPMOUNTPOINT} # the database must be
> down for this to work
> * mv /var/lib/mysql /var/lib/mysql.old
> * mkdir /var/lib/mysql
> * chown mysql.mysql /var/lib/mysql
> * chmod 755 /var/lib/mysql
> * mount /dev/hda1 /var/lib/mysql # replace hda1 with your 40G drive
> * start mysqld
> * check the logs and make sure mysql started ok
> * start mythtv processes
>
> You're also going to want to add this mount point to /etc/fstab.  After
> you're sure everything is working ok, you can 'rm -rf /var/lib/mysql.old'.
>
> Doing it this way requires no changes in settings to mysql or to mythtv.
>
>
>
Okay, I finally got around to adding the second IDE drive. I have
partitioned it (40G total) to a 5GB labelled "mysql" and a 35GB for extra
space.

I followed your instructions but I can't get it to work. Here's from the
/var/lib/mysql/mythbox.err:

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20081030/085a389d/attachment.htm