[Koha] Problems restoring a backup to a new server

[Michael Kuhn]

Hi Jack

>  > I am attempting to setup a new server and trying to restore the file
>  > koha_library.sql.gz to the new server. I assume that the gz is a
>  > compressed file. Using the command in the terminal "mysql -uroot -p
>  > koha_library < koha_library.sql fails with the error file not found.
>  > I attempt to tar the file with tar -zxfv and get an error that it is
>  > not a valid tar file. Running Ubuntu precise1 and koha version
>  > 3.18.11.000. All help is appreciated.
>
> Assuming you copied the file "koha_library.sql.gz" into directory
> "/tmp"...
>
> Change to /tmp:
>
> $ cd /tmp
>
> Decompress the file (this will result in file "koha_library.sql"):
>
> $ tar xzf koha_library.sql.gz

Sorry, this is of course wrong! Instead decompress the file like (this 
will result in file "koha_library.sql"):

$ gzip -d koha_library.sql.gz

Then continue like I described:

> Now load the file:
>
> $ mysql -uroot -p koha_library < koha_library.sql
>
> Be sure you call this command while being in the directory where
> "koha_library.sql" resides. Of course also giving the absolute path is
> possible:
>
> $ mysql -uroot -p koha_library < /tmp/koha_library.sql

Good luck, Michael
-- 
Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
T 0041 (0)61 261 55 61 · E mik at adminkuhn.ch · W www.adminkuhn.ch