[mythtv-users] Why mythconverg database never refreshes with "mysql -u root -p < mc.sql"

[Larry Jones]

Despite many attempts to start over with a new fresh virgin mythconverg 
database using the command
mysql -u root -p < /usr/share/doc/mythtv-0.20/database/mc.sql
the old database always remained.   Finally, I saw a post(ref 1) of the 
mc.sql script file which reads

CREATE DATABASE /*if not exists*/ mythconverg;
GRANT ALL ON mythconverg.* TO mythtv[at]localhost IDENTIFIED BY "mythtv";
FLUSH PRIVILEGES;
GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv[at]localhost
IDENTIFIED BY "mythtv";
FLUSH PRIVILEGES;
ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1;

So since mythconverg existed (the old database I hoped I was 
destroying), this script saw my old mythconverge database existed so 
then /*did not*/ create a new fresh untouched database after deleting 
the old one.

Solution:  Use something like  mysqlcc to "drop" (apparently sql speak 
for delete) the mythconverg database. Then invoke the mysql -u root -p < 
mc.sql or as appropriate for your distribution to create a new untouched 
virgin database.

And look carefully.  The MythTV database is mythconverg   not the common 
spelling mythconverge as in convergence of PC and TV.

This note applies to the Fedora-Jarod Wilson build of MythTV.  I'm not 
certain if it would apply to any of the others.

Larry

(1) http://www.gossamer-threads.com/lists/mythtv/users/250237