[mythtv-users] Trouble moving backend database to new hardware
Ken Taylor
ken at onramp.com.au
Thu Jan 11 14:15:06 UTC 2007
On 11/01/2007, at 5:58 AM, ryan patterson wrote:
> 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.)
Sounds like you're trying to restore over an existing database.
You should drop the existing mythconverg database fisrt, and then
mythtv will update the data to the new format.
Ken
--
Ken Taylor
"Everyone knows the plural of virus is Windows" - Mike Muth on AFU
More information about the mythtv-users
mailing list