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

[Michael Jones]

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