[mythtv-users] moving database from FC4 to gentoo (mysql 4 to 5)
Brad Fuller
bradallenfuller at yahoo.com
Sun Feb 11 21:32:39 UTC 2007
Steve Hodge wrote:
> On 2/12/07, *Brad Fuller* <bradallenfuller at yahoo.com
> <mailto:bradallenfuller at yahoo.com>> wrote:
>
> On the FC4 machine running mysql version 4 I dumped the mythconverg
> database using:
> mysql dump -tc -u mythtv -p mythconverg > mythdb.sql
>
>
> This is the problem - the "-t" switch tells mysqldump not to put table
> creation statements in the dump file. That's what you want if you will
> be reimporting the dump into an existing mythconverg db. But you want
> to recreate the db from scratch so you needed those create table
> statements.
crap, I mistakenly thought it meant ADD the table statements. Although,
I'm really stupid about database stuff.
Thanks!
>
> I assume you can't do another dump?
>
> You might be able to get it working by doing a fresh Myth install (to
> recreate the database) and then importing the dump file into that. You
> may have to truncate all the tables first.
>
> Cheers,
> Steve
> ------------------------------------------------------------------------
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
More information about the mythtv-users
mailing list