[mythtv-users] problems setting up mysql w/FC1

[Peter Valdemar Morch]

mike johnson mythtv65-at-hotmail.com |Lists| wrote:
  > what i've done.  i've started mysql (and verified that it is indeed
> running),  set the password, but when i input the line to create the 
> mythconverge database, i get a message saying that it isn't there.?   
> i'm new to mysql, so input would be a great help.

If you can set the password, that is good news. Mysql is running and the 
worst should be over... What does this mean:?

 > i get a message saying that it isn't there

Does this file exist in your filesystem / setup: 
/usr/share/doc/mythtv-0.14/database/mc.sql

An *exact* cut'n'paste from the terminal is very, very helpful to us! :-D

Also, what do these two commands show? (Again, not your paraphrase but 
the exact output...)
$ mysql -u root -p -e 'show databases'
(enter password)
$ mysql -u root -p -e 'create database foo ; drop database foo'
(enter password)
$ mysql -u root -p -e 'show databases'
(enter password)

My output is something like this. (never mind that I don't need the -u 
and -p  and password entering stuff - it isn't important - but you 
probably need them in your setup):

myth at peter:~> mysql -e 'show databases'
+-------------+
| Database    |
+-------------+
| _temp       |
| mysql       |
| mythconverg |
| test        |
+-------------+

You should get 2 * indentical output, similar to mine. "foo" should 
*not* be mentioned in the second output and you should see no errors.

If all this looks fine, and you do have a mythconverg database, you may 
want to try with a fresh mythconverg database by simply dropping it (all 
your settings will be backed up in a file, but the database itself will 
be lost!!!!) and recreating it with:

# First create a backup of any existing mythconverg database.
$ mysqldump -u root -p mythconverg > mythbackup.sql
(enter password)

# Now drop and recreate the database from scratch...
$ mysql -u root -p -e 'drop database mythconverg'
(enter password)
$ mysql -u root -p < /usr/share/doc/mythtv-0.14/database/mc.sql
(enter password)

If you *don't* have a mythconverg database in the 'show databases' 
output, try this:
$ mysql -u root -p -e 'create database mythconverg'
(enter password)

If that works, this should have too:
$ mysql -u root -p < /usr/share/doc/mythtv-0.14/database/mc.sql
(enter password)


Peter

-- 
Peter Valdemar Mørch
http://www.XXXXXXXXX