[mythtv-users] Mythbuntu backup and restore screwed me

[Hika van den Hoven]

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

"Zonder hoop kun je niet leven
Zonder leven is er geen hoop
Het eeuwige dilemma
Zeker als je hoop moet vernietigen om te kunnen overleven!"

De lerende Mens