<div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Before you do anything else, read up on LVM2, get comfortable with it,<br>
and put it into practice when you add your second hard disk.<br>
<br>
The database itself is easy to move...<br>
<br>
* Partition and format a filesystem on your 40G drive<br>
* Mount the 40G drive at a temporary mount point<br>
* Stop the mythtv processes<br>
* Stop mysqld<br>
* rsync -avp /var/lib/mysql/ ${TMPMOUNTPOINT} # the database must be<br>
down for this to work<br>
* mv /var/lib/mysql /var/lib/mysql.old<br>
* mkdir /var/lib/mysql<br>
* chown mysql.mysql /var/lib/mysql<br>
* chmod 755 /var/lib/mysql<br>
* mount /dev/hda1 /var/lib/mysql # replace hda1 with your 40G drive<br>
* start mysqld<br>
* check the logs and make sure mysql started ok<br>
* start mythtv processes<br>
<br>
You're also going to want to add this mount point to /etc/fstab. After<br>
you're sure everything is working ok, you can 'rm -rf /var/lib/mysql.old'.<br>
<br>
Doing it this way requires no changes in settings to mysql or to mythtv.<br>
<br>
<br></blockquote></div><br>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.<br><br>I followed your instructions but I can't get it to work. Here's from the /var/lib/mysql/mythbox.err:<br>
<br><span style="font-family: courier new,monospace;">081030 15:59:30 mysqld started</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">081030 15:59:31 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">081030 15:59:31 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">081030 15:59:31 InnoDB: Started; log sequence number 0 61321</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">081030 15:59:31 [Note] /usr/sbin/mysqld: ready for connections.</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">Version: '5.0.68' socket: '/tmp/mysql.sock' port: 3306 Source distribution</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">081030 16:25:14 [Note] /usr/sbin/mysqld: Normal shutdown</span><br style="font-family: courier new,monospace;">
<br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">081030 16:25:14 InnoDB: Starting shutdown...</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">081030 16:25:14 InnoDB: Shutdown completed; log sequence number 0 61321</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">081030 16:25:14 [Note] /usr/sbin/mysqld: Shutdown complete</span><br style="font-family: courier new,monospace;"><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">081030 16:25:14 mysqld ended</span><br style="font-family: courier new,monospace;">
<br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">081030 16:49:28 mysqld started</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">081030 16:49:28 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">081030 16:49:28 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">081030 16:49:28 InnoDB: Started; log sequence number 0 61321</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">081030 16:49:28 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13)</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">081030 16:49:28 [ERROR] /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13)</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">081030 16:49:28 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">081030 16:49:28 mysqld ended</span><br style="font-family: courier new,monospace;"><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">(END) </span><br>
<br><br>Here's the current permissions in /var/lib/mysql:<br><br><span style="font-family: courier new,monospace;">~ # ls -laF /var/lib/mysql</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">total 20592</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">drwxr-xr-x 7 mysql mysql 4096 2008-10-30 16:49 ./</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">drwxr-xr-x 21 root root 4096 2008-10-30 16:34 ../</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">drwx------ 2 mysql mysql 4096 2008-10-30 16:47 ampache/</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">-rw-r----- 1 mysql mysql 5242880 2008-10-30 16:49 ib_logfile0</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">-rw-r----- 1 mysql mysql 5242880 2008-10-30 16:47 ib_logfile1</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">-rw-r----- 1 mysql mysql 10485760 2008-10-30 16:47 ibdata1</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">drwx------ 2 mysql mysql 4096 2008-10-30 16:47 mysql/</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">-rw-r----- 1 mysql mysql 35045 2008-10-30 16:49 mythbox.err</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">drwx------ 2 mysql mysql 12288 2008-10-30 16:48 mythconverg/</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">drwx------ 2 mysql mysql 4096 2008-10-30 16:48 torrentflux/</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">drwx------ 2 mysql mysql 4096 2008-10-30 16:48 torrentfluxb4rt/</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">~ # </span><br>
<br><br>I tried finding the file host.frm it's looking for, and found it:<br><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">/var/lib/mysql # sudo find -iname "*host*"</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">./mysql/host.MYI</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">./mysql/host.frm</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">./mysql/host.MYD</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;"></span><span style="font-family: courier new,monospace;">/var/lib/mysql # </span><br>
<br>Dunno what to do here??<br><br>Bob<br>