I am trying to upgrade my mythtv setup. I am moving from a debian install to a ubuntu install.<br><br>I tried following these instructions:<a href="http://www.mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://www.mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7
</a> which explain how to back up the database and move it to a fresh myth-backend install. I performed the database backup no problem. I verified that every grep command produced output in the restore.sql file. My new backend is up and running.
<br><br>Now I am trying to restore the database backup using the following command:<br>$ mysql -u mythtv -pmythtv mythconverg < restore.sql<br><br>But I get the following error message:<br>ERROR 1054 (42S22) at line 1: Unknown column 'storage group' in 'field list'
<br>(there might not have been a space in 'storagegroup'. I'm not at home so I can't check.)<br><br>Does anybody know how I can fix this error? Must be the mythtv version I had on debian is different from the one I have on ubuntu? I really don't want to lose the list of previously recorded programs. I could care less about the recording profiles and current recordings though.
<br><br>-- <br>_____________<br>Ryan Patterson