[mythtv] Upgrade database from command line

[Craig Treleaven]

At 6:49 PM +1000 9/8/14, Grant Gardner wrote:
>On 7 September 2014 20:55, Michael T. Dean <mtdean at thirdcontact.com> wrote:
>>  On 09/07/2014 02:19 AM, Joseph Fry wrote:
>>
>>  FWIW, I don't think it's too much to ask users to install the version of
>>  MythTV they need to upgrade their databases--especially since the "remove
>>  ability to upgrade from ancient versions of MythTV" is something we seldom
>>  do.  We have only ever done so when some particular database upgrades are so
>>  ancient that they tend to fail with modern Qt/Qt-MySQL/MySQL--at which point
>>  users who are using those ancient versions should probably upgrade to the
>>  stable version (that's supported) as soon as they hear the development
>>  (next) version removes support for upgrading from their version if they care
>>  to keep their data.
>>
>
>If I've read the code correctly current trunk can go back as far as
>0.24, and 0.24-fixes can go back as far as 0.14
>See - https://code.mythtv.org/trac/ticket/504
>
>With any luck I'll have a fully scripted process for this sometime
>later tonight.  Can anyone suggest somewhere to get some old version
>backups to test with?

One issue I don't think I've seen mentioned in this thread is MySQL 
time zone support:

http://www.mythtv.org/wiki/MySQL_Time_Zone_Tables

AIUI, the time zone tables MUST be loaded before doing a database 
conversion for 0.26 or higher.  I believe having them loaded causes 
no harm for other MythTV versions.  Therefore an early step should be 
to check for/load these tables.

Also, loading the time zone tables (at least on OS X) results in some 
messages that look like error messages but are harmless.  I might 
have an example squirreled away somewhere but I'm not sure where 
right now.  I've never checked what result code is returned by 
mysql_tzinfo_to_sql in such cases.  Anyway, something to look into 
when building a script.

Craig

-- 
--
Craig Treleaven, CA -- Clearview Consulting
(905) 829-2054  ctreleaven at cogeco.ca