<div class="gmail_quote">On Wed, Nov 11, 2009 at 3:16 PM, Michael T. Dean <span dir="ltr"><<a href="mailto:mtdean@thirdcontact.com">mtdean@thirdcontact.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div class="im">On 11/11/2009 11:38 AM, Steve Evans wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">I am using Mythtv 0.21 on Gentoo. Gentoo sets up mysql to use utf8,<br>but Mythtv prefers it to use latin1. This will cause problems when<br>
Mythtv is upgraded to 0.22. There are instructions on how to fix this at:<br><br><a href="http://wiki.mythtv.org/wiki/Fixing_Corrupt_Database_Encoding" target="_blank">http://wiki.mythtv.org/wiki/Fixing_Corrupt_Database_Encoding</a><br>
<br>I followed these instructions, but got this error when restoring the fixed backup:<br><br>ERROR 1062 (23000) at line 1712: Duplicate entry 'Kathleen ÃôDixieÃö Dixon*Jane Hazlegr' for key 2<br> <br></blockquote>
<br></div>That means you have partial corruption.
<div class="im"><br><br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Fortunately it was possible to restore the original, unfixed, backup,<br>so I have a working mythtv :-)<br>
<br>Does anyone have any idea how to fix the database /without/ getting this error?<br></blockquote><br></div>You need to follow the instructions at:<br><br><a href="http://www.gossamer-threads.com/lists/mythtv/users/406111#406111" target="_blank">http://www.gossamer-threads.com/lists/mythtv/users/406111#406111</a><br>
<br>Mike
<div>
<div></div>
<div class="h5"><br>_______________________________________________<br>mythtv-users mailing list<br><a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br><a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br>
</div></div></blockquote>
<div> </div>
<div>I followed the directions on the posted thread on my end... Started with a clean v0.21-fixes DB in latin1 charset, upgraded to v0.22, ran the setup...</div>
<div>Will the resulting v0.22 database be utf8?<br></div></div>