[mythtv-users] database recovery, no backup
Michael T. Dean
mtdean at thirdcontact.com
Sat Jul 21 14:12:16 UTC 2012
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
More information about the mythtv-users