[mythtv-users] Trouble moving backend database to new hardware
ryan.goat at gmail.com
Thu Jan 11 16:34:26 UTC 2007
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 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
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the mythtv-users