[mythtv-users] Backend DB migration--replace or just restore?

John Pilkington johnpilk222 at gmail.com
Sun Sep 6 09:47:46 UTC 2020


On 06/09/2020 05:12, lists at arewethere.net wrote:

> I'm struggling a bit here.
> 
> In (v31) mythconverg_restore.pl the create procedure includes this
> 
>     verbose($verbose_level_debug, 'Setting database character set.');
>     $query = qq{ALTER DATABASE $mysql_conf{'db_name'}
>                 DEFAULT CHARACTER SET latin1
>                 COLLATE latin1_swedish_ci;};
> 
> but mc.sql does that step like this
> 
>     ALTER DATABASE mythconverg
>     DEFAULT CHARACTER SET utf8
>     COLLATE utf8_general_ci;
> 
> so the different approaches seem inconsistent with each other.
> 
I haven't run mythconverg_restore.pl in years, but that 'swedish' 
setting is in my recent build from master.  It does look an unlikely 
default.

John P



More information about the mythtv-users mailing list