dliana.mythtv at gmail
Nov 11, 2009, 9:07 AM
Post #2 of 6
(723 views)
Permalink
|
|
Re: Error when changing Mythtv's mysql database from utf8 to latin1 on Gentoo
[In reply to]
|
|
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.
1. 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.
2. I would dump the full database using the mysqldump command[1]
3. 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
4. Drop mythconverg.
5. 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.
6. Re-create mythconverg with a charset of latin1.
7. Run mythtv-setup from 0.21, but do not set anything up and exit.
8. Restore you're backup from step 2 or 3, depending on your
preferences. I restored from step 2.
9. Upgrade mythtv, mythtv-themes and your plugins to v0.22.
10. Run mythtv-setup and tweak your settings. It looks like this
upgrades your db to utf8. (I'm assuming this is okay)
[1] http://www.mythtv.org/wiki/Backup_your_database#The_mysqldump_command
On Wed, Nov 11, 2009 at 11:38 AM, Steve Evans <mythtv-users [at] gorbag>wrote:
> Hello,
>
> I am using Mythtv 0.21 on Gentoo. Gentoo sets up mysql to use utf8,
> but Mythtv prefers it to use latin1. This will cause problems when
> Mythtv is upgraded to 0.22. There are instructions on how to fix this at:
>
> http://wiki.mythtv.org/wiki/Fixing_Corrupt_Database_Encoding
>
> I followed these instructions, but got this error when restoring the fixed
> backup:
>
> ERROR 1062 (23000) at line 1712: Duplicate entry 'Kathleen ÃôDixieÃö
> Dixon*Jane Hazlegr' for key 2
>
> Fortunately it was possible to restore the original, unfixed, backup,
> so I have a working mythtv :-)
>
> Does anyone have any idea how to fix the database /without/ getting this
> error?
>
> Steve
> --
> ____________________________________________________________________
> Steve Evans E-mail: mailto:stevee [at] gorbag
> WEB: http://www.gorbag.com
> Registered Linux user #217906: http://counter.li.org
> Public Encryption Key: http://www.gorbag.com/public-key.html
> ____________________________________________________________________
>
> Now playing: 'Everything's Gone Green' by 'New Order' from the album
> 'Factory
> Records - Communications 1978-92 - CD2 1981 to 1984'
>
> 2.6.30-gentoo-r7 Intel(R) Pentium(R) 4 CPU 3.00GHz GNU/Linux
>
> 11:56:33 up 16 days, 20:51, 7 users, load average: 1.92, 0.92, 0.37
>
> From the cradle to the coffin underwear comes first.
> -- Bertolt Brecht
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users [at] mythtv
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
|
