[mythtv-users] CVS database question

Isaac Richards ijr at po.cwru.edu
Mon Aug 4 22:10:45 EDT 2003


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


More information about the mythtv-users mailing list