I should have said that the previous post is meant to get ready for the upgrade of MythTV!!!
BTW the site is currently slashdotted.
Comics, Macs, RAID, Linux, Gentoo, some science and a dash of atheism. No longer a wet lab molecular biologist, I now work for MacVector, Inc.
I should have said that the previous post is meant to get ready for the upgrade of MythTV!!!
BTW the site is currently slashdotted.
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!
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!