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

How dis you create the backup? Did you use mysqldump or did you use the koha commands? For the .gz file try using gzip -d {path_to_backup_file}/koha_library.sql.gz then you'll get a koha_library.sql file which you can use to restore the database -- View this message in context: http://koha.1045719.n5.nabble.com/Problems-restoring-a-backup-to-a-new-serve... Sent from the Koha-general mailing list archive at Nabble.com.