I'm building a new mythtv system. The old system is a RedHat 9.0 box, running mythtv 0.20.2, and I'm upgrading to mythbuntu 12.04 running mythtv 0.25.2.<br><br>I'm using this guide (<a href="http://www.mythpvr.com/mythtv/tips/migrate-recordings.html">http://www.mythpvr.com/mythtv/tips/migrate-recordings.html</a>) to migrate my shows and recording history to the new system. However, I'm running into import issues (missing columns) due to the difference in age between the mythtv versions.<br>
<br>I'm wondering if there's a working solution to address the problem, other than manually adding the columns to the old database (prior to exporting and importing). Here are the databases that I'm trying to import, along with the columns that are missing:<br>
<br>oldrecorded - missing season, episode, inetref, future<br><br>recordedmarkup - missing offset, data<br><br>recordedprogram - missing audioprop, subtitletype, videoprop<br><br>recorded - missing season, episode, inetref, storagegroup, bookmarkupdate<br>
<br>record - missing season, episode, inetref, autometadata, storagegroup, avg_delay, filter. Also contains a column that no longer exists - tsdefault<br><br><br>Secondly, the old system mysql database is verions 3.23.54. Will any additional conversions need to be done to address the mysql change? ie: character encoding, auto_increment, how null is defined, etc.<br>
<br><br>Thank you<br><br>-Rob<br>