[mythtv-users] Trouble moving backend database to new hardware

[Ken Taylor]

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