mysqldump issue with koha database
I'm running Koha on two different servers for testing reasons. One has 3.6.2 and is my current active server. I just upgraded the other from 3.2.2 to 3.6.2 with no problems. I copied the koha database using mysqldump from the current server and copied it onto the newly upgraded server. I've run the rebuild_zebra.pl script, but none of the data shows. Searching in the OPAC and Staff Client shows nothing in the catalog. So I checked the koha database using the mysql shell and all the books are listed there, but nothing shows when searching. What am I doing wrong? C.J. Walke, Librarian Maine Organic Farmers and Gardeners Association Unity, Maine - USA -- View this message in context: http://koha.1045719.n5.nabble.com/mysqldump-issue-with-koha-database-tp54291... Sent from the Koha-general mailing list archive at Nabble.com.
On 25 January 2012 13:37, cjwalke <cjwalke@mofga.org> wrote:
I'm running Koha on two different servers for testing reasons. One has 3.6.2 and is my current active server. I just upgraded the other from 3.2.2 to 3.6.2 with no problems. I copied the koha database using mysqldump from the current server and copied it onto the newly upgraded server. I've run the rebuild_zebra.pl script, but none of the data shows. Searching in the OPAC and Staff Client shows nothing in the catalog.
So I checked the koha database using the mysql shell and all the books are listed there, but nothing shows when searching.
Hi CJ Ahh, the structure of the items table changed between 3.2.x and 3.4.x,
From the Upgrade section in the INSTALL file
"Koha 3.4.x or later no longer stores items in biblio records. If you are upgrading from an older version you will need to do the following two steps, they can take a long time (several hours) to complete for large databases misc/maintenance/remove_items_from_biblioitems.pl --run misc/migration_tools/rebuild_zebra.pl -b -r " This might be what you missed. Hope this helps Chris PS MOFGA looks like a great place to work/be involved with
Hi Chris, I have run the commands you mention: misc/maintenance/remove_items_from_biblioitems.pl --run misc/migration_tools/rebuild_zebra.pl -b -r And Zebra is running. I think the issue is that the two servers are different types of machines. One is an old P3 Dell and the other is a G5 Mac. This morning I copied an older version of the koha database from the Dell on to the Dell, which cleared out the initial copy that was from the Mac. Everything is working fine, it's just not my latest copy. Does that make sense? --C.J. -- View this message in context: http://koha.1045719.n5.nabble.com/mysqldump-issue-with-koha-database-tp54291... Sent from the Koha-general mailing list archive at Nabble.com.
On 2012-01-25 13:37, cjwalke wrote:
So I checked the koha database using the mysql shell and all the books are listed there, but nothing shows when searching.
What am I doing wrong?
In addition to what Chris said, make sure your Koha server is actually running. That is one of the more common causes of that symptom. Robin.
On 26 January 2012 08:58, <robin@catalyst.net.nz> wrote:
On 2012-01-25 13:37, cjwalke wrote:
So I checked the koha database using the mysql shell and all the books are listed there, but nothing shows when searching.
What am I doing wrong?
In addition to what Chris said, make sure your Koha server is actually running. That is one of the more common causes of that symptom.
And by Koha Robin means Zebra :) Chris
Robin probably meant your Zebra server, not Koha ;) You can do this using the following command : ps aux|grep zebra Regards, Eric On 2012-01-25 14:58, robin@catalyst.net.nz wrote:
On 2012-01-25 13:37, cjwalke wrote:
So I checked the koha database using the mysql shell and all the books are listed there, but nothing shows when searching.
What am I doing wrong?
In addition to what Chris said, make sure your Koha server is actually running. That is one of the more common causes of that symptom.
Robin. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
participants (4)
-
Chris Cormack -
cjwalke -
Eric Bégin -
robin＠catalyst.net.nz