My mythtv box crashed because of a corrupted hard drive. I can see my data when connected it to another computer. I need to know how I can retrieve the database so I can load it on my new drive.
mysqldump utility :). This option allows you to export the database instead of merely copying the files.
Go inside the MySQL db directory of the hard drive, there will be some files there for each database. Retrieve them.
Here is the tricky part. You are going to need to get the same version of mySQL from the one that was in the dead box. Once you know what version it was, install it in a new rig and copy over the files.
After that you can use php myadmin or the mysql cli interface to make a proper export.
Use a data retrieval service if the information is very valuable to you, as any attempt at DIY data retrieval can lessen the chances of a later attempt.
That said, using GetDataBack is a good bet for NTFS or FAT drives (they have two different versions. Here is a guide to help you with Linux HD's (actually the advice will work with any type of HD, but for FAT and NTFS formatted drives you can use GetDataBack).
Hope this helps!