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@adminkuhn.ch · W www.adminkuhn.ch