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

[ryan patterson]

On 1/11/07, Ken Taylor <ken at onramp.com.au> wrote:
>
> 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


Okay if I drop the current database should I restore the entire database
from my old backend or just the parts the instructions said to grep out of
the mysqldump?

-- 
_____________
Ryan Patterson
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20070111/df6f16e0/attachment.htm