[mythtv-users] DB restore

[Phil Bridges]

On Mon, Feb 2, 2015 at 4:36 PM, Daryl McDonald <darylangela at gmail.com>
wrote:

>
>
> On Mon, Feb 2, 2015 at 4:32 PM, Phil Bridges <gravityhammer at gmail.com>
> wrote:
>
>> Try:
>>
>> sudo mysql -u mythtv -p mythconverg   (assuming your database has a
>> "mythtv" user")
>>
>> On Mon, Feb 2, 2015 at 4:25 PM, Daryl McDonald <darylangela at gmail.com>
>> wrote:
>>
>>>
>>>
>>> On Mon, Feb 2, 2015 at 3:59 PM, Daryl McDonald <darylangela at gmail.com>
>>> wrote:
>>>
>>>> On Feb 2, 2015 2:45 PM, "Michael T. Dean" <mtdean at thirdcontact.com>
>>>> wrote:
>>>> >
>>>> > On 02/02/2015 11:41 AM, Daryl McDonald wrote:
>>>> >
>>>> >> On Mon, Feb 2, 2015 at 9:30 AM, Michael T. Dean wrote:
>>>> >>
>>>> >>> On 02/02/2015 09:22 AM, Daryl McDonald wrote:
>>>> >>>
>>>> >>>> Greetings Mythizens, I woke up this morning to that Green Terra
>>>> setup
>>>> >>>> screen, evidently I need to restore my database.
>>>> >>>>
>>>> >>> Are you sure?  There should never be a case where you wake up to
>>>> find your
>>>> >>> database gone.  Why do you think you need to restore the database?
>>>> >>
>>>> >>
>>>> >> I use Steppes, and when I woke the box was still on, so I opened
>>>> Myth FE to
>>>> >> see what it was recording, and was shocked to find the Terra theme
>>>> "select
>>>> >> country and Language screen" as I navigated through screens in a
>>>> panic I
>>>> >> saw one offering to update my database as it was 5000 versions
>>>> outdated,
>>>> >> hence my assumption. Is there any info I can post or paste to help
>>>> diagnose
>>>> >> what is going on here?
>>>> >
>>>> >
>>>> > This will happen if MythTV can't find your database.  It won't find
>>>> your database if there's a problem with your config.xml or, for example, if
>>>> you change around host names and/or IP addresses.  You haven't described
>>>> your configuration at all (number of hosts, host names, which are dedicated
>>>> backends or frontends and which are combined backend/frontend systems,
>>>> location of mythconverg database, ...), so there are many reasons this
>>>> could occur, but from the logs you posted, I see:
>>>> >
>>>> > Feb  2 11:23:17 daryl-A780L3C mythbackend: mythbackend[2483]: N
>>>> thread_unknown mythdirs.cpp:68 (InitializeMythDirs) Using configuration
>>>> directory = /home/mythtv/.mythtv
>>>> > ...
>>>> > Feb  2 11:23:17 daryl-A780L3C mythbackend: mythbackend[2483]: N
>>>> CoreContext mythcontext.cpp:504 (LoadDatabaseSettings) Empty LocalHostName.
>>>> > Feb  2 11:23:17 daryl-A780L3C mythbackend: mythbackend[2483]: I
>>>> CoreContext mythcontext.cpp:512 (LoadDatabaseSettings) Using localhost
>>>> value of daryl-A780L3C
>>>> >
>>>> > and then a bunch of messages that show that mythbackend is connecting
>>>> to an empty database on the local host.  Is the host name "daryl-A780L3C"
>>>> really the one you want to use and the one you have been using for MythTV?
>>>> Are you sure your ~mythtv/.mythtv/config.xml specifies the proper location
>>>> and connection information for your MySQL database?
>>>> >
>>>> > Mike
>>>> >
>>>> > _______________________________________________
>>>> > 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
>>>>
>>>> I use a combined fe be only, yes "daryl-A780L3C" is the host name I
>>>> have been using, I thought about using a different one a while back but
>>>> staying with this one was simpler. I just checked the myth box,which is a
>>>> Ubuntu desktop also and the chromium browser I had left open with gmail had
>>>> closed and I was unable to relaunch it, just a few pulses then nothing. I'
>>>> m going to look into the config files now.
>>>>
>>>
>>> Thanks Eric, but I'm still confused:
>>>
>>> daryl at daryl-A780L3C:~$ mysql -u user mythconverg
>>> ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using
>>> password: NO)
>>> daryl at daryl-A780L3C:~$ sudo mysql -u user mythconverg
>>> [sudo] password for daryl:
>>> ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using
>>> password: NO)
>>> daryl at daryl-A780L3C:~$ sudo mysql mythconverg
>>> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
>>> password: NO)
>>> daryl at daryl-A780L3C:~$
>>>
>>>
>>> _______________________________________________
>>> 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
>>>
>>>
>>
>> _______________________________________________
>> 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
>>
>> Thanks Phill, this looks familiar, as to how I've accessed this before,
> but not this time:
>
>   daryl at daryl-A780L3C:~$ sudo mysql -u mythtv -p mythconverg
> Enter password:
> ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using
> password: YES)
> daryl at daryl-A780L3C:~$
>
>
>
>
Did you enter in the mythtv mysql password (maybe mythtv)?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20150202/efc5203d/attachment.html>