Re: [Gnumed-devel] Restoring a database under Debian

[Busser, Jim]

On 2015-01-24, at 10:58 AM, Karsten Hilbert <address@hidden> wrote:

> This would assume you've that the *.sql files sitting in a
> directory named
> 
>       "backup-gnumed_v20-GNUmed_Team-MacBook-2.local-2015-01-21-21-05-31"
> 
> branching off from your current dirctory. Also your command
> will create a tar containing the SQL files INSIDE that
> subdirectory.

Thanks for resolving that.

I had guessed wrong that, wishing to tar all the files inside the backup 
directory, one would choose to tar the directory and all within.

What delayed my 'eureka' moment was the fact that even in the case where files 
have been tarred without an enclosing directory, expansion of such an archive 
via the GUI (under Mac OS automatically without user prompts, and under Debian 
Gnome by default unless the user chooses differently at a prompt), into a 
subfolder having the same name as the archive filename.

Which has the same appearance as an expanded tar which had prepared from above 
the enclosing directory.

My eureka moment came after you pointed out what I was wondering, and I then 
compared the result of

        tar tf …

against tar the archives created from two different positions within the path: 
one outside the enclosing directory, and one inside.

The first returned the problematic

        backup-gnumed_v20-GNUmed_Team-MacBook-2.local-2015-01-21-21-05-31/
        
backup-gnumed_v20-GNUmed_Team-MacBook-2.local-2015-01-21-21-05-31/backup-gnumed_v20-GNUmed_Team-MacBook-2.local-2015-01-21-21-05-31-database.sql
        
backup-gnumed_v20-GNUmed_Team-MacBook-2.local-2015-01-21-21-05-31/backup-gnumed_v20-GNUmed_Team-MacBook-2.local-2015-01-21-21-05-31-roles.sql
 

whereas the second returned

        
backup-gnumed_v20-GNUmed_Team-MacBook-2.local-2015-01-21-21-05-31-database.sql
        
backup-gnumed_v20-GNUmed_Team-MacBook-2.local-2015-01-21-21-05-31-roles.sql 

so this was good for me to note and I will add it to the wiki when I update its 
backup and restore pages.

-- Jim