[mythtv-users] URGENT HELP!!! Where does mythtv-setup put the backup after a schema update?

[Michael Jones]

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
>>>> it
>>>> just a full copy of the mysql/mythconverg folders?  a dump file?
>>>> etc.
>>>>
>>> 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
>> your
>> Default storage group, the backup could be in any of them.
>>
>> Note, though, that since mythtv-setup was run on your friend's  
>> system,
>> 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
>> have
>> written the backup to /tmp .  So, make sure you talk to your friend
>> soon
>> (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 .   
>> Those
>> instruction apply for restoring the backup.  The only difference is
>> you
>> may have to uncompress the backup first (i.e. gunzip
>> /path/to/backup_file.gz ).
>>
>> Mike
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>
> 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
> empty..
>
> 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
> work?
>
> 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...
>
> Michael
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users



By the way.. it turns out that he's running 0.22.20080422-1 ARGH!!!!!