On 7/6/07, Lan Barnes <[EMAIL PROTECTED]> wrote:
OK, I screwed the pooch. I did a reinstall, extracted the mysql data on my recordings, and proceded to save it on a partition that got reformatted. Now I have the recordings in their pristine format, but the new Myth install (very clean, thank you for asking) knows nothing about them. What are my options? Is there a way to get them into Myth some way? If not, can I transcode them and burn them somehow? I can't be the first person to mess up this way. This implies that someone has figured out a recovery path. TIA, -- Lan Barnes SCM Analyst Linux Guy Tcl/Tk Enthusiast Biodiesel Brewer
Very challenging indeed! So, you formatted over the database? You could use grep in binary mode to search for the directory name that held the data. That could give you a starting point. What storage engine was used? If it's MyISAM tables, then you'll have seperate files to deal with. If it's Innodb, by default, all the tables are stored in a single file. Inside MyISAM tables, you'll find text strings of your data, but I'm not sure it's guaranteed to be all contiguous.... Innodb would give you a fighting chance since everything is contained in a single table. Another approach would be looking for the binary logs. I'd have to do some research, but I think there's a way to reply the binlogs into a different instance of mysqld... -- Mark Schoonover, CMDBA [EMAIL PROTECTED] http://marksitblog.blogspot.com Cell: 619-368-0099 Database Administration * System Engineering * Software Development * -- [email protected] http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
