[mythtv-users] Default character set

[Michael T. Dean]

On 11/14/2008 01:32 PM, Jan Ceuleers wrote:
> Michael T. Dean wrote:
>   
>> It sounds like your schema is fine, so you're probably in a good place 
>> for the upgrade to 0.22, but even if that's not the 
>> case--realistically--what's the benefit of finding out that your data is 
>> broken /now/ over finding it out when you upgrade 0.22?
>>     
> Knowing up-front that the upgrade will fail is useful information, I 
> think. This provides the option of not upgrading.
>   

Also, backup, upgrade, fail, restore, revert works.  Though that takes 
more of your time, it takes significantly less time than creating a 
sure-fire test of whether an upgrade will fail***.  Besides, there are 
always ways to fix a failed upgrade--it's just a matter of how much time 
you're willing to spend fixing broken data.

Mike

***And, really, the best test of whether it will fail on your particular 
configuration with your particular data is to execute all the database 
upgrade steps exactly as they will be performed by Myth--after which 
you've either upgraded your database or corrupted it (meaning you'd 
either run the upgraded version of Myth or restore your old database, 
anyway).