Thanks to a server dying I’ve been moving my MythTV installation to a new system. I wanted to install from scratch to clean out a load of old settings and other data that have been hanging around for years (I’ve been using MythTV since somewhere around v0.7), but to keep all my recordings and the tuner settings for my DVB-T cards.
I discovered that having copied the recordings across from the old server, running the following against the old database and importing into the new will extract all the recording data and recording schedules and can be imported into the new copy:
$ mysqldump -u mythtv -p mythconverg record recorded oldrecorded recordedprogram recordedrating recordedmarkup recordedseek > recordings.sql
And for the channel tuning data:
$ mysqldump -u mythtv -p mythconverg dtv_multiplex channel > channels.sql