[mythtv-users] Trouble moving backend database to new hardware
ryan patterson
ryan.goat at gmail.com
Thu Jan 11 13:58:56 UTC 2007
I am trying to upgrade my mythtv setup. I am moving from a debian install
to a ubuntu install.
I tried following these
instructions:http://www.mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7
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.sqlfile. My new backend is up and running.
Now I am trying to restore the database backup using the following command:
$ mysql -u mythtv -pmythtv mythconverg < restore.sql
But I get the following error message:
ERROR 1054 (42S22) at line 1: Unknown column 'storage group' in 'field list'
(there might not have been a space in 'storagegroup'. I'm not at home so I
can't check.)
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.
--
_____________
Ryan Patterson
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20070111/d74c9315/attachment.htm
More information about the mythtv-users
mailing list