[mythtv-users] Database migration
Michael T. Dean
mtdean at thirdcontact.com
Wed Jul 8 13:43:03 UTC 2009
On 07/08/2009 09:05 AM, Martin Ravell wrote:
> I’ve just recently built a new MythDora box to replace my old one
> which finally carc’d it (after five years and various different
> distros and versions).
> The new system is setup nicely and has been running well for the last
> week and a half.
> Fortunately I managed to grab a database dump and the recordings
> directory from the old machine. (It was the motherboard that blew not
> the disks)
> Looking at the SQL it says (near the top) :
> -- Server version 5.0.45
> The new machine has :
> -- Server version 5.0.67
> My questions to the list are:
> 1. Is there a known way for me to bring my recorded shows over to the
> new database?
> 2. Can I also get my history info so that Myth knows which episodes of
> my favourite shows I have already watched (and do not wish to
> re-record) etc?
> 3. Can the previous two things be done without stuffing up the current
> (new) database.
> I’ve spent some time googling but with little results. Anyone able to
> point me in the right direction?
The preferred method is to do a database backup (
http://www.mythtv.org/wiki/Database_Backup_and_Restore ), then restore
the database on the new host, which will handle both 1 and 2. The best
way to accomplish 3 is to ensure you use the same hostname for the new
host as you used for the old host.
More information about the mythtv-users