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

[Michael T. Dean]

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