Repairing MythTV tables

MySQL 5.0 Reference Manual :: 5.10.4.3 How to Repair Tables

I’ve just been trying to backup my MythTV tables. Previously I’ve used PHPMyAdmin. However, I thought I would try command line and automate it.

mysqldump -u root -p mythconverg > mythconverg-`date +%F`.sql
However, I constantly got a error message
Can't open file: (errno: 145) when using LOCK TABLES mythtv

So i discovered I needed to repair the tables. The above docuimentation is pretty easy but basically.

cd /var/lib/mysql.mythconverg
myisamchk -e *.MYI

Then run the following command on each table that shows errors:
myisamchk -r -q program.MYI

Easy peaasy lemon squeezy!

Raid 5 to 6 conversion possible?

A recent post on Raj’s blog made me think about giving RAID6 a play. This then makes me wonder whether a RAID 5 to 6 conversion is possible? I guess this is completely impossible without a complete reformatting. But there again growing a RAID 5 array is also a similar experience, and this is now possible. I would suggest that both require adjustment of stripes. or am I really talking out of my behind?

I recently used mdadm’s new grow function to increase my 3 drive RAID5 array to 4 drives. This worked perfectly. I trust my backups, so am quite happy to risk its integrity to convert to RAID6. Hmmmm!