[mythtv-users] moving database from FC4 to gentoo (mysql 4 to 5)

Brad Fuller bradallenfuller at yahoo.com
Sun Feb 11 21:04:12 UTC 2007


I'm looking thru the online MySql docs but can't find the answer. The 
mythtv gossamer threads server seems to be down (Unable to connect to 
search server: Connection refused)

I'm trying to move a mythtv database from FC4 to Gentoo

On the FC4 machine running mysql version 4 I dumped the mythconverg 
database using:
mysql dump -tc -u mythtv -p mythconverg > mythdb.sql

On the gentoo machine (it's actually the same machine) I ran the
mysql -u root -p < /usr/share/mythtv/database/mc.sql

because I figured I needed to add the user first.

I DROP'd the database and I tried to restore the database using from the 
FC4 database:

mythsql -u mythtv -p mythconverg < mythdb.sql

but I receive the following error:

ERROR 1146 (42S02) at line 21: Table 'mythconverg.callsignnetworkmap' 
doesn't exist.

Note that gentoo is running MySql 5. But, I don't know if this is the 
problem, or not.
callsignnetworkmap is the first table in the mythdb.sql file. So, I 
don't think that it doesn't exist.

Any hints?

thanks,
brad




More information about the mythtv-users mailing list