Philipp,
From what I see, you are doing the right thing.
You shouldn't have to do any modification on your database, Koha should
take care of it when you access your staff interface when detecting a
mismatch between the version in the code and the one in your database.
Your database information (database, login and passwd) are located in
your etc/koha-conf.xml file (its location depends on your install
directory).
Make sure this information is what you expect it to be.
Hope that helps,
Eric Bégin
Solutions inLibro inc.
On 2013-12-22 10:01, Phillip Ponchot wrote:
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: pponc...@live.com
To: koha@lists.katipo.co.nz
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: pponc...@live.com
To: koha@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@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
