MythTV 0.22 Migrating Recordings

Using the following SQL statements allows us to backup the mythtv recordings database

mysqldump -c -u mythtv -p -t mythconverg record recorded oldrecorded recordedprogram recordedrating recordedmarkup recordedseek > recordings.sql

It will ask for a password, which is the SQL database password not the system password.
After a few seconds it's done.  All that is left to do is copy the backup file accros to the new machine an import it.

The following SQL will import to the database

mysql -f -u mythtv -p mythconverg < recordings.sql