<html>
<body>
<font size=3>I just replaced my MBE this past weekend and had a similar
problem. While I was working with Fedora 9, the solution I found might
help you. <br><br>
I brought the new software load up, including mythtv and mysql. Loaded
mythtv, and then ran <br><br>
$ mysql -u mythtv -pmythtv mythconverg < mythtv_backup.sql<br><br>
I seemed to have similar problems to the ones you have been seeing.
Nothing worked. It drove me crazy for a day until...<br><br>
I erased mysql and deleted /var/lib/mysql. <br><br>
# yum erase mysql<br>
# rm -f -R /var/lib/mysql<br><br>
Note** yum also erased 6 other dependent programs. <br><br>
Then I slowly reloaded the mysql environment. <br><br>
# yum install mysql <as well as other dependent programs that were
erased><br><br>
# mysql -u root mysql<br>
mysql> UPDATE user SET Password=PASSWORD('<root password>')
WHERE user='root';<br>
mysql> FLUSH PRIVILEGES;<br>
mysql> quit <br><br>
I then installed the empty mythconverg. Because this was a restore of an
existing environment, I did think I needed not do this before. <br><br>
$ mysql -u root -p < /usr/share/doc/mythtv-0.20/database/mc.sql<br>
(your path may be a little different depending on distribution also enter
the password you just set above when prompted) <br><br>
Then I erased and re-created mythconverge in accordance with the database
restore documentation
(<a href="http://www.mythtv.org/docs/mythtv-HOWTO-23.html#ss23.5" eudora="autourl">
http://www.mythtv.org/docs/mythtv-HOWTO-23.html#ss23.5</a>)<br><br>
$ mysql -u root -p<br>
mysql> drop database mythconverg;<br>
mysql> create database mythconverg;<br>
mysql> flush privileges;<br>
mysql> exit<br><br>
Finally I reloaded the backup of mythconverg<br><br>
$ mysql -u mythtv -pmythtv mythconverg < mythtv_backup.sql<br><br>
Everything worked after that. <br><br>
-- Mache<br><br>
</font></body>
</html>