[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

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

Hope this helps

Kind regards, 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