[mythtv-users] database recovery, no backup

[Michael T. Dean]

On 07/20/2012 11:46 AM, Ross Boylan wrote:
> During an upgrade from .24 to .25 (using Marillat's Debian repository)
> my database got borked and the system won't start.  The standard advice
> is to restore from backup, but I don't have one.
>
> I have all the recordings, and I assume that data is likely still in the
> database.  I tried a little debugging, but haven't located the schema
> migration code.
>
> Any advice about the best way to proceed?

Before MythTV upgrades the database, it will try its best to create a 
database backup (unless you explicitly tell it not to with a setting).  
It will place the backup in one of the directories in your DB Backups 
Storage Group.  If you haven't specified a directory list for DB 
Backups, it will place the backup in one of the directories in your 
Default Storage Group.  If it can't find any of the directories it 
should use, it will place the backup in your /tmp directory.

Look carefully through your MythTV Storage Group directories for a 
backup:  ls /path/to/directory/*.sql*

Assuming you find it, do a full restore, then attempt a DB upgrade using 
mythtv-setup. If it fails, please provide the log output from that 
mythtv-setup run (i.e. start the program using:  mythtv-setup --logpath 
/path/to/some/directory and it will create a log file in the specified 
director).

Mike