[mythtv-users] URGENT HELP!!! Where does mythtv-setup put the backup after a schema update?
michael at michaelandholly.com
Sun May 11 03:56:36 UTC 2008
On May 10, 2008, at 8:51 PM, Michael Jones wrote:
> On May 10, 2008, at 8:29 PM, Michael T. Dean wrote:
>> On 05/10/2008 10:48 PM, Nick Morrott wrote:
>>> On 11/05/2008, Michael Jones <michael at michaelandholly.com> wrote:
>>>> The question is WHERE Is it stored? and HOW do I get it back? Is
>>>> just a full copy of the mysql/mythconverg folders? a dump file?
>>> If you haven't configured a storage directory for the DB
>> (specifically, a directory in a "DB Backups" storage group)
>>> , check your
>>> recordings directory.
>> If you have were running 0.21-fixes and had multiple directories in
>> Default storage group, the backup could be in any of them.
>> Note, though, that since mythtv-setup was run on your friend's
>> it would have been the one that tried to write the backup to the
>> directory specified in the (Default or DB Backups) storage group. If
>> that directory(ies) doesn't exist on his system, mythtv-setup would
>> written the backup to /tmp . So, make sure you talk to your friend
>> (i.e. before he shuts down his system if he has a "cleanup /tmp
>> directory" init script like many systems do)
>>> The compressed file contains a dump of the
>>> database from MySQL.
>>> Something like
>>> # mysql mythconverg < dumpfile.sql
>>> should repopulate the file contents back into the database.
>> See, also, http://mythtv.org/docs/mythtv-HOWTO-23.html#ss23.5 .
>> instruction apply for restoring the backup. The only difference is
>> may have to uncompress the backup first (i.e. gunzip
>> /path/to/backup_file.gz ).
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
> Ok.. So it seems that he has shut his system down since he left here,
> the /tmp, /mythtv and any other recordings locations are completely
> It seems that either.. his system never did make a backup.. or the
> backup has been lost (or we just can't find it)..
> He's on the 1220 version of the schema. Is there ANY way to adjust
> the database schema on my system manualy (I'm pretty mysql adept.. so
> structural changes aren't too difficult) so the existing database will
> Isn't there a "database_schema_version" field or something in the
> settings table that the backend looks at?
> Thanks guys,
> Waiting with baited breath...
> mythtv-users mailing list
> mythtv-users at mythtv.org
By the way.. it turns out that he's running 0.22.20080422-1 ARGH!!!!!
More information about the mythtv-users