[mythtv-users] [mythtv-commits] Ticket #9742: Mythtv-setup fails to create the initial database

[Michael T. Dean]

On 04/19/2011 02:58 PM, MythTV wrote:
> #9742: Mythtv-setup fails to create the initial database
> ------------------------------------------+-------------------------
>       Reporter:  cedric.dewijs@…           |      Owner:  danielk
>           Type:  Bug Report - General      |     Status:  new
>       Priority:  minor                     |  Milestone:  unknown
>      Component:  MythTV - Mythtv-setup     |    Version:  Unspecified
>       Severity:  medium                    |   Keywords:
> Ticket locked:  0                         |
> ------------------------------------------+-------------------------
>   I have installed mythtv, and mysql. After creating the initial database,
>   mythtv-setup can not find the tables it needs.
>

Cedric,

We /think/ this is an issue with MySQL 5.5 (but don't know what's 
causing it, yet).  I'll try to install MySQL 5.5 and do some testing soon.

In the meantime, as a workaround, please install a blank schema, then 
verify that the upgrade works.  There's a 0.21-fixes blank schema (that 
I created and I will vouch for) available at

http://www.gossamer-threads.com/lists/engine?do=post_attachment;postatt_id=12787;list=mythtv

Please download that file ( mythconverg-1214-blank.sql.gz ) to your home 
directory, then run:

mythconverg_restore.pl --dir=$HOME --file=mythconverg-1214-blank.sql \
                        --drop_database --create_database --verbose

Then start up mythtv-setup to upgrade the database to current 0.24-fixes 
schema.  Please let me know whether the database upgrade works after 
creating the schema.  If so, that should let you get started while I 
work on figuring out what MySQL 5.5 changed.

Thanks,
Mike