[mythtv-users] Questions on correcting database encoding under Gentoo while still on 0.21-fixes

[Michael T. Dean]

On 11/02/2009 03:15 PM, Tom Dexter wrote:
> Thanks!  Do you know offhand whether I may have run into problems if I
> didn't change the my.cnf on the frontend?  Like I explained above that
> appears to create a situation where connections from the frontend to
> the (newly corrected) backend would have this by default:
>
> Server characterset:	latin1
> Db     characterset:	latin1
> Client characterset:	utf8
> Conn.  characterset:	utf8
>
> With the frontend's my.cnf changed the above are all latin1.  Would
> missing that have caused an issue, or would data just get properly
> translated and stored?  Then again, I guess that would only be an
> issue for anything (if there is in fact any situation) where the
> frontend writes directly to the database.

If you run mythtv 0.21-fixes in that configuration, it will corrupt 
data.  And, since the backend is not corrupting data, you will end up 
with the dreaded "partial corruption."

If you fix mysql on the backend and the upgrade to 0.22-fixes using the 
backend host's mythtv-setup of mythbackend, then you'd be fine running 
your frontend host in any charset configuration (as 0.22 and above 
properly set characterset).

Because I wasn't completely sure what you had said you were doing in 
your original post, I modified the wiki page to suggest fixing the DB 
right before upgrading.  If you did change it and have run 0.21-fixes 
against the fixed DB, you may want to go back to the original backup and 
either the original "misconfiguration" of mysqld or just upgrade to 
0.22-fixes now.

Mike