[Koha] Importing Koha Database to a new install

[Phillip Ponchot]

I think I've figured out what's up.  I managed to determine that the Koha database is from Koha version 3.00.00.107 and the version that I've installed by default is 3.14.00.000.  This means that the database is extremely out of date and can not be "imported" without transforming some of the data. 

When the data has been imported by me, Koha doesn't recognize it.  I can't login as staff and when I log in as koha_library, koha has me setup the database just like I'm just finishing the install and overwrites the database. 

I've also figured out that the the No Library Set always appears when logged in as koha_library even if there is a valid database. 

Thanks,

Phillip

I know that there are procedures to upgrade databases from one version to the next.  

If anyone has "monkey.txt" (meaning step by step procedures) to upgrade this database, I would sincerely appreciate it and so would my library since we are down hard. 

> From: pponchot at live.com
> To: koha at lists.katipo.co.nz
> Date: Sun, 22 Dec 2013 00:24:56 -0800
> Subject: [Koha] Importing Koha Database to a new install
> 
> Does anyone have some "monkey text" instructructions on how to dump the old koha database from the old server and import it into the new one.  From instructions and other readings on the web, I have tried to export the database and import it without acceptable results.
> 
> When I log into Staff Koha, I still have to login with the username and password that comes with the installation.  Also when I do log in, I see as a choice of libraries - My Library and several other libraries so I am assuming there's an issue with the import or maybe something else. 
> 
> I did the following using the instructions below:
> 
> 1. Using mysqldump, dumped the old koha database which is named Koha.
> 2.  Copied the dump to the new server. 
> 3.  Deleted the new koha_library database on the new server.
> 4.  Created a new koha_library database.
> 5.  Using mysql imported the koha_library database from the dump .  
> 
> I also do not have a Library Set so something is not right on the import. 
> 
> Thanks to everyone who's helped me so far.  I'm making progress.
> 
> Phillip
> 
> 
> 
> Instructions:
> 
> Koha Database Restoration process.
> 
> 
> Open a terminal and apply following commands.
> 
>  
> 
> Remove existing database in new installation
> 
>  
> 
> sudo su
> 
> mysql -uroot -p 
> 
> [Enter the MySQL Root password]
> 
>  
> 
> drop database koha_library;
> 
> create database koha_library;
> 
> quit;
> 
>  
> 
> Copy your database backup from your pen drive to home folder.
> 
>  
> 
> Then restore the old backup to new installation.
> 
> Database Restoration command,
> 
> mysql -uroot -p koha_library < koha.sql
> 
>  
> 
> koha_library - name of database in new installation
> 
> koha.sql - name of database in old installation
> 
>  
> 
> Enter the MySQL root password.
> 
> Then rebuild the Zebra Index.
> 
> Apply following command in a terminal,
> 
> sudo koha-rebuild-zebra -v -f library
> End of Instructions
>  		 	   		  
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha