Thanks, Mark. More general reply in separate email. On Fri, July 6, 2007 6:55 pm, Mark Schoonover wrote: > 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 >
-- Lan Barnes SCM Analyst Linux Guy Tcl/Tk Enthusiast Biodiesel Brewer -- [email protected] http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
