<div dir="ltr">Thanks Mike. You wrote:<br>> To fix corruption, the only supported solution is to throw away<div>> all re-creatable data (settings/configuration/plugin data/...) <div>> and keep only the essential non-re-creatable data (recording </div>
<div>> information and history). You do so with a partial restore<br>><br>> <a href="http://www.mythtv.org/wiki/Database_Backup_and_Restore#Partial_restore_of_a_backup">http://www.mythtv.org/wiki/Database_Backup_and_Restore#Partial_restore_of_a_backup</a><br>
<br>OK. Here are the steps I've taken:<br> <a href="http://mythconverg_backup.pl">mythconverg_backup.pl</a> --verbose<br>That seemed to work fine.<br><br>The next step in the wiki is to delete the existing database:<br>
mysql -uroot -p -e 'DROP DATABASE IF EXISTS mythconverg;'<br>That also seemed to work (no error messages anyway)<br><br>Then the wiki says "then create a new database (and note that doing so may change MySQL passwords/permissions, so may cause authentication problems).", pointing to <a href="http://www.mythtv.org/wiki/MythTV-HOWTO#Setting_up_the_initial_database">http://www.mythtv.org/wiki/MythTV-HOWTO#Setting_up_the_initial_database</a> which seems to say to:<br>
$ cd database<br> $ mysql < mc.sql<br><br>So I got stuck with these three questions:<br>1. Where is this database directory I'm supposed to cd to?<div>2. where can I find mc.sql? Is it the 320 byte file already on my system at /usr/share/mythtv/sql/mc.sql </div>
<div>3. This step has the ominous but not particularly helpful warning that "doing so may change MySQL passwords/permissions, so may cause authentication problems". Can I prevent that by using my old MySQL password or something?</div>
<div><br></div><div style>Thanks for any help.</div><div style><br></div><div style>-Fred</div><div><br><div class="gmail_extra"><div class="gmail_quote"><div style><div style><br></div></div></div></div></div></div></div>
</div>