[Koha] Importing Koha Database to a new install

[Phillip Ponchot]

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