<div>I am a Gentoo user... Here is my understanding of what needs to be done (or better yet, what I did). I could completely be out in left field, so if anyone wants to correct me, I can at least restore from a backup.</div>
<div> </div>
<ol>
<li>I had the latin1 use flag set for as long as I remember, so it is my understanding that I would not be, or at worst minimally affected. I think. </li>
<li>I would dump the full database using the mysqldump command[1]</li>
<li>Using the mysqldump comand, pullout the important tables (like recorded, recordeddata, etc.). I think the syntax for this is on the wiki. I like to set up my hardware and other settings from scratch when I</li>
<li>Drop mythconverg.</li>
<li>Make a backup of /etc/mysql/my.conf, and replace utf8 with latin1 in my.cnf. I did not have to do this since everything was latin1.</li>
<li>Re-create mythconverg with a charset of latin1.</li>
<li>Run mythtv-setup from 0.21, but do not set anything up and exit.</li>
<li>Restore you're backup from step 2 or 3, depending on your preferences. I restored from step 2.</li>
<li>Upgrade mythtv, mythtv-themes and your plugins to v0.22.</li>
<li>Run mythtv-setup and tweak your settings. It looks like this upgrades your db to utf8. (I'm assuming this is okay)</li></ol>
<div> </div>
<div>[1] <a href="http://www.mythtv.org/wiki/Backup_your_database#The_mysqldump_command">http://www.mythtv.org/wiki/Backup_your_database#The_mysqldump_command</a></div>
<div> </div>
<div class="gmail_quote">On Wed, Nov 11, 2009 at 11:38 AM, Steve Evans <span dir="ltr"><<a href="mailto:mythtv-users@gorbag.com">mythtv-users@gorbag.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hello,<br><br>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<br>backup:<br><br>ERROR 1062 (23000) at line 1712: Duplicate entry 'Kathleen ÃôDixieÃö<br>Dixon*Jane Hazlegr' for key 2<br><br>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<br>error?<br><br>Steve<br>--<br>____________________________________________________________________<br>Steve Evans E-mail: mailto:<a href="mailto:stevee@gorbag.com">stevee@gorbag.com</a><br>
WEB: <a href="http://www.gorbag.com/" target="_blank">http://www.gorbag.com</a><br>Registered Linux user #217906: <a href="http://counter.li.org/" target="_blank">http://counter.li.org</a><br>Public Encryption Key: <a href="http://www.gorbag.com/public-key.html" target="_blank">http://www.gorbag.com/public-key.html</a><br>
____________________________________________________________________<br><br>Now playing: 'Everything's Gone Green' by 'New Order' from the album 'Factory<br>Records - Communications 1978-92 - CD2 1981 to 1984'<br>
<br>2.6.30-gentoo-r7 Intel(R) Pentium(R) 4 CPU 3.00GHz GNU/Linux<br><br> 11:56:33 up 16 days, 20:51, 7 users, load average: 1.92, 0.92, 0.37<br><br>From the cradle to the coffin underwear comes first.<br> -- Bertolt Brecht<br>
<br>_______________________________________________<br>mythtv-users mailing list<br><a href="mailto:mythtv-users@mythtv.org">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>
</blockquote></div><br>