[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 Taylor

"Everyone knows the plural of virus is Windows" - Mike Muth on AFU

More information about the mythtv-users mailing list