[mythtv-users] Retrieving old Myth database for new install

David Brieck Jr. dbrieck at gmail.com
Fri Jul 16 18:34:50 UTC 2010


On Fri, Jul 16, 2010 at 2:23 PM, John Coman <jc at protypegraphics.com> wrote:
>
>
> David Brieck Jr. wrote:
>
> On Fri, Jul 16, 2010 at 10:04 AM, John Coman <jc at protypegraphics.com> wrote:
>
>
> I had a MythTV setup using Ubuntu 9.04.  I was having problems and decided
> to upgrade to 10.04.
> Upon restart after installing 10.04 my system crashed and would never boot
> again.
> I then installed 10.04 on a new partition along with Myth.  That all seems
> to be working but I don't have access to any of my old recordings.  Also the
> database that tracks which shows have been recorded is not available.
> To summarize:
> Original Myth 9.04 on partition A.
> New Myth using 10.04 on partition B
> All myth recording on a different Drive X.
> How do I tell Myth to look on Drive X?
>
> I still have the original although corrupt files on Partition A.
> Any help would be greatly appreciated.
> jcoman
>
>
> If the partition is still readable, you should be able to click Places
> and it will list your un-mounted partition. Click on it, then browse
> to the mysql folder ( var/lib/mysql )  and copy the myth database into
> your current mysql location. You'll probably need to fix permissions,
> but this should get you started.
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>
> Partition is readable.  I will try the ideas and report back.
>
> John
>

You might need to do some of the copying via a command line via sudo.

$ sudo service stop mysql
$ sudo cp -r /media/somethinggoeshere/var/lib/mysql/mythconverg /var/lib/mysql/
$ sudo service start mysql

After you have the tables loaded you probably want to check/repair the
database in case MySQL wasn't shutdown cleanly.


More information about the mythtv-users mailing list