[Koha] Problem with migration from KOHA 3.20 to 16.11.11

[Michael Kuhn]

Hi Przemek

> I have some problems with migration to new server and migrate to new 
> version koha.
> 
> On the old  server with KOHA 3.20 I made the command "koha-dump 
> biblio-main" (it's an instance name) - everything is fine - backup done.
> 
> and
> 
> On new test server with KOHA 16.11 execute command koha-restore 
> biblio-main-2017-09-13.sql.gz biblio-main-2017-09-13.tar.gz
> 
> Serwer parameters:
> Server: Ubuntu 14.04 LST
> Mysql: mysql Ver 14.14 Distrib 5.5.57, for debian-linux-gnu (x86_64) 
> using readline 6.3
> Apache: Server version: Apache/2.4.7 (Ubuntu)
> 
> 
> Restored? Not!  It didn't work.  After the above command - I received 
> such output at the terminal:


Did you really use the following command?

koha-restore biblio-main-2017-09-13.sql.gz biblio-main-2017-09-13.tar.gz

I guess "koha-restore" is not able to deal with compressed files, so you 
should first uncompress them. After that you will also need to execute 
"koha-upgrade-schema".


However, in July I successfully changed from an old host with Ubuntu 
14.04.5 LTS and Koha 3.20.4 to a new host with Debian GNU/Linux and Koha 
17.05.1.

After building the new host (not using the .tar.gz file) and creating 
the new Koha instance I used the following command (instead of using 
"koha-restore"):

$ mysql -u root -pPASSWORD DATABASE_NAME < dumpfile-3.20-20170724.sql

After that I upgraded the database schema susing this command:

$ sudo koha-upgrade-schema INSTANCENAME


Hope that helps.

Best wishes: 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