[mythtv-users] Mythbuntu backup and restore screwed me

[Thomas Mashos]

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