[mythtv-users] DB restore

[Daryl McDonald]

On Mon, Feb 2, 2015 at 6:15 PM, Bill Meek <keemllib at gmail.com> wrote:

> On 02/02/2015 03:34 PM, Daryl McDonald wrote:
>
>> curiously enough, after a restart the mythbox/ubuntu desktop is responding
>> and if I open the FE the language/country screen appears if I hit esc I
>> get
>> a message: This version of Mythtv requires an updated database. (schema is
>> 5000 versions behind) Please run mythtv setup or mythbackend to update
>> your
>> database.
>>
>
> Just curious, what do the following print:
>
>     sudo ls -ld /var/lib/mysql/mythconverg/settings.MYD
>     sudo ls -ld /var/lib/mysql/mysql/user.MYD
>
> If the either or both of the above exist, continue on, otherwise
> go no further in this email.
>
> Also, there's a maintenance password [THAT YOU SHOULD NEVER
> CHANGE!] that should allow you to login like this:
>
>     sudo mysql --defaults-extra-file=/etc/mysql/debian.cnf
>
> sudo is required in this case because the file above isn't readable
> by anyone other than root:root.
>
> *If* that works, then type these 2 commands:
>
>     SELECT * FROM mythconverg.settings WHERE value = 'DBSchemaver';
>     quit
>
> Please put the output from the SELECT here.
>
> --
> Bill
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
>

Hi,and thanks Bill:
 mysql> SELECT * FROM mythconverg.settings WHERE value = 'DBSchemaver';
ERROR 130 (HY000): Incorrect file format 'settings'
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20150202/2d6b25bc/attachment.html>