[mythtv-users] Mythbuntu backup and restore screwed me

[Gerald Brandt]

On 2014-07-09, 10:17 AM, Hika van den Hoven wrote:
> Hoi Thomas,
>
> Wednesday, July 9, 2014, 5:06:53 PM, you wrote:
>
>> On Wed, Jul 9, 2014 at 8:01 AM, Gerald Brandt <gbr at majentis.com> wrote:
>>> On 2014-07-09, 9:57 AM, Gerald Brandt wrote:
>>>> Hi,
>>>>
>>>> This mormimg I reported an error with mysql and table instances. I fixed
>>>> it, but it was recommended that I restore from a backup.
>>>>
>>>> So, I went into mythbuntu-control-center and used it's backup-restore
>>>> tool.  I've been doing daily backups for years.  No problem.
>>>>
>>>> I do a backup, just in case, and then I do a restore of yesterdays backup.
>>>>
>>>> I have now lost YEARS of mythbuntu data.  The mythbuntu backups didn't
>>>> backup my databases, even though I told it to.  Yeah, yeah, I should have
>>>> verified the backups, but I didn't.  This is great.
>>>>
>>>> I am not a happy man.  /var/lib/mysql/mythconverg is empty.  My 'backups'
>>>> have this in them:
>>>>
>>>> # tar -tf mythbuntu-system-backup_mythserver_20140708-1700_MBE_YESDB.tar
>>>>
>>>> etc/mythtv/config.xml
>>>>
>>>> etc/mythtv/mysql.txt
>>>>
>>>> etc/lirc/lircd.conf
>>>>
>>>> etc/lirc/hardware.conf
>>>>
>>>> etc/hostname
>>>>
>>>> etc/hosts
>>>>
>>>> tmp/mythbuntu-bare/
>>>>
>>>> tmp/mythbuntu-bare/mythconverg-1317-20140708170003.sql.gz
>>>>
>>>>
>>>>
>>>> Is there a way I can at least save all my recordings?
>>>>
>>> Apparently I was hasty.  The mythbuntu-bare sql files DOES contain my DB.
>>> It's just not restoring.
>>>
>>> How do I restore it?
>>>
>>> Gerald
>>>
>>>
>>>
>>> --
>>> Gerald Brandt
>>> Majentis Technologies
>>> 204-229-6595
>>> gbr at majentis.com
>>>
>>> _______________________________________________
>>> mythtv-users mailing list
>>> mythtv-users at mythtv.org
>>> http://www.mythtv.org/mailman/listinfo/mythtv-users
>>> http://wiki.mythtv.org/Mailing_List_etiquette
>>> MythTV Forums: https://forum.mythtv.org
>> Is it throwing any errors when trying to restore? The restore utility
>> just calls the mythtv database scripts, so you should be able to
>> restore the DB backup file using
>> http://www.mythtv.org/wiki/Database_Backup_and_Restore
>> And yes, you should always check your backups. And once you've checked
>> them, check them again.
>> Thanks,
>> Thomas Mashos
>> _______________________________________________
>
> Do you try to restore as the user you use to backup? Ik not you are
> probably missing ~/.mythtv/backuprc for the user you use to do the
> restore. Either run the restore as the same user you use to backup or
> copy the above file to the other home-directory, setting appropriate
> rights.
>
>
> Tot mails,
>    Hika                            mailto:hikavdh at gmail.com
>
I restored using mysql, and it's all back.

Gerald