Mailing List Archive: CVS database question

I just grabbed the latest CVS for mythtv (8/4) and was wondering what is up
with the database files?

I dropped my old database with 'mysqladmin drop mythconverg'.

Then, I used 'mysql < database/mc.sql' to make the new DB. This runs fine
and loads all the tables. My question is when I do 'mysql <
database/cvs.sql' I get the following error:

ERROR 1060 at line 18: Duplicate column name 'recorddups'

Should I still be using the cvs.sql file? Do i need to use -f to force it?
What are the other .sql files for in the database directory? Do I need to
use those too? Is there a place to check for new CVS documentation every
time you check out?

Thanks!
Trey

_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

On Monday 04 August 2003 08:50 pm, Trey Stout wrote:
> I just grabbed the latest CVS for mythtv (8/4) and was wondering what is up
> with the database files?
>
> I dropped my old database with 'mysqladmin drop mythconverg'.
>
> Then, I used 'mysql < database/mc.sql' to make the new DB. This runs fine
> and loads all the tables. My question is when I do 'mysql <
> database/cvs.sql' I get the following error:
>
> ERROR 1060 at line 18: Duplicate column name 'recorddups'
>
> Should I still be using the cvs.sql file? Do i need to use -f to force it?
> What are the other .sql files for in the database directory? Do I need to
> use those too? Is there a place to check for new CVS documentation every
> time you check out?

mc.sql always contains the full database up to that point in time. cvs.sql is
for people following the CVS tree regularly. If you're using CVS, the best
(and generally only) place to know what's changed is on the cvs commits list
-- that's what it's there for.

Isaac
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users