[mythtv-users] Error creating mythconverg database afterfresh.16install...

[Graham W. Mitchell]

I am trying this on a fresh FC2 install too, and I am getting the same
error.... I've had a dig about, but can't seem to find a solution.


Graham

-----Original Message-----
From: mythtv-users-bounces at mythtv.org
[mailto:mythtv-users-bounces at mythtv.org] On Behalf Of Nate Thompson
Sent: Sunday, September 12, 2004 11:08 AM
To: 'Discussion about mythtv'
Subject: RE: [mythtv-users] Error creating mythconverg database
afterfresh.16install...

Sorry, I thought I had Outlook configured for plain text... Just did a
fresh
install of Outlook this weekend as I built a new PC for myself as well.
I
will let you know if I figure anything out.

Nate 

-----Original Message-----
From: mythtv-users-bounces at mythtv.org
[mailto:mythtv-users-bounces at mythtv.org] On Behalf Of William
Sent: Sunday, September 12, 2004 10:09 AM
To: 'Discussion about mythtv'
Subject: RE: [mythtv-users] Error creating mythconverg database after
fresh.16install...

<gripe>Please use text mode when posting to the list.</gripe>

<snip>
I decided to format and install FC2 and .16 following Jarod's guide. I
got
through most of it without any serious issues (after upgrading the
kernel
and enabling the at.testing repo), but am having a problem when I go to
create the database. Entering the line 'mysql -u root -p <
/usr/share/doc/mythtv-0.16/database/mc.sql'  results in the following
error
message:
ERROR 1064 at line 4: You have an error in your SQL syntax near
'TEMPORARY
TABLES ON mythconverg.* TO mythtv at localhost IDENTIFIED BY "mythtv"' at
line
1
Anyone have any thoughts as to what could be causing this error? I'm
usually
pretty good at working through these kind of issues, but it's getting
late
and I'm tired. :) Thanks, Nate Thompson </snip>

I ran into the same problem. I just finished switching back to FC1 and
was
going to try again but the darn apt repository is down. Will try again
once
I can download some needed updates. Let me know if you fix it, I would
rather use FC2.

Bill