P.S. I still need a step by step procedure (monkey.txt) to upgrade the koha 3.0 database to the 3.14 database and import it so it can be used.
> From: [email protected] > To: [email protected] > Date: Sun, 22 Dec 2013 06:51:02 -0800 > Subject: Re: [Koha] Importing Koha Database to a new install > > 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: [email protected] > > To: [email protected] > > 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 > > [email protected] > > http://lists.katipo.co.nz/mailman/listinfo/koha > > _______________________________________________ > Koha mailing list http://koha-community.org > [email protected] > http://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
