Dear Friends, I am trying to import koha 3.14 database in to koha 3.18.06. When i run mysql dump command I got the following message. < /home/library/koha_koha.sql Enter password: -- MySQL dump 10.13 Distrib 5.5.43, for debian-linux-gnu (x86_64) -- Host: localhost Database: koha_koha -- Server version 5.5.43-0ubuntu0.14.04.1 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2015-05-20 0:59:43 But when I run the zebra index command it shows that it has exported 0 records. sudo koha-rebuild-zebra -v -f koha Zebra configuration information ================================ Zebra biblio directory = /var/lib/koha/koha/biblios Zebra authorities directory = /var/lib/koha/koha/authorities Koha directory = /usr/share/koha/intranet/cgi-bin Lockfile = /var/lock/koha/koha/rebuild/rebuild..LCK BIBLIONUMBER in : 999$c BIBLIOITEMNUMBER in : 999$d ================================ skipping authorities ==================== exporting biblio ==================== Records exported: 0 ==================== REINDEXING zebra ==================== ==================== CLEANING ==================== Zebra configuration information ================================ Zebra biblio directory = /var/lib/koha/koha/biblios Zebra authorities directory = /var/lib/koha/koha/authorities Koha directory = /usr/share/koha/intranet/cgi-bin Lockfile = /var/lock/koha/koha/rebuild/rebuild..LCK BIBLIONUMBER in : 999$c BIBLIOITEMNUMBER in : 999$d ================================ ==================== exporting authority ==================== Records exported: 0 ==================== REINDEXING zebra ==================== skipping biblios ==================== CLEANING Can somebody plz suggest me that how can I solve this problem..? Regards Obaiah B. Ashoka Trust for Research in Ecology and the Environment, Royal Enclave, Srirampura, Jakkur Post, Bangalore-560064 -- View this message in context: http://koha.1045719.n5.nabble.com/Records-Exported-0-tp5840766.html Sent from the Koha-general mailing list archive at Nabble.com.
Hi, On Wed, May 20, 2015 at 11:44 AM, obaiah <obaiah@atree.org> wrote:
Dear Friends,
I am trying to import koha 3.14 database in to koha 3.18.06. When i run mysql dump command I got the following message.
< /home/library/koha_koha.sql Enter password: -- MySQL dump 10.13 Distrib 5.5.43, for debian-linux-gnu (x86_64) -- Host: localhost Database: koha_koha
<snipped>
But when I run the zebra index command it shows that it has exported 0 records.
sudo koha-rebuild-zebra -v -f koha
<snipped>
Can somebody plz suggest me that how can I solve this problem..?
Possibly dumb question: But after the db import and before the zebra reindex, did you run the Koha web-installer from the staff client URL? cheers -- Indranil Das Gupta L2C2 Technologies Phone : +91-98300-20971 Blog : http://indradg.randomink.org/blog IRC : indradg on irc://irc.freenode.net Twitter : indradg -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards. For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org
Hi, Yes I did run the koha web-installer after db import and before the zebra index. Regards Obaiah ATREE -- View this message in context: http://koha.1045719.n5.nabble.com/Records-Exported-0-tp5840766p5840938.html Sent from the Koha-general mailing list archive at Nabble.com.
Greetings, Is koha really your instance name? Perhaps you created another in your confusion? GPML, Mark Tompsett -----Original Message----- From: obaiah Sent: Wednesday, May 20, 2015 2:14 AM To: koha@lists.katipo.co.nz Subject: [Koha] Records Exported 0 Dear Friends, I am trying to import koha 3.14 database in to koha 3.18.06. When i run mysql dump command I got the following message. < /home/library/koha_koha.sql Enter password: -- MySQL dump 10.13 Distrib 5.5.43, for debian-linux-gnu (x86_64) -- Host: localhost Database: koha_koha -- Server version 5.5.43-0ubuntu0.14.04.1 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2015-05-20 0:59:43 But when I run the zebra index command it shows that it has exported 0 records. sudo koha-rebuild-zebra -v -f koha Zebra configuration information ================================ Zebra biblio directory = /var/lib/koha/koha/biblios Zebra authorities directory = /var/lib/koha/koha/authorities Koha directory = /usr/share/koha/intranet/cgi-bin Lockfile = /var/lock/koha/koha/rebuild/rebuild..LCK BIBLIONUMBER in : 999$c BIBLIOITEMNUMBER in : 999$d ================================ skipping authorities ==================== exporting biblio ==================== Records exported: 0 ==================== REINDEXING zebra ==================== ==================== CLEANING ==================== Zebra configuration information ================================ Zebra biblio directory = /var/lib/koha/koha/biblios Zebra authorities directory = /var/lib/koha/koha/authorities Koha directory = /usr/share/koha/intranet/cgi-bin Lockfile = /var/lock/koha/koha/rebuild/rebuild..LCK BIBLIONUMBER in : 999$c BIBLIOITEMNUMBER in : 999$d ================================ ==================== exporting authority ==================== Records exported: 0 ==================== REINDEXING zebra ==================== skipping biblios ==================== CLEANING Can somebody plz suggest me that how can I solve this problem..? Regards Obaiah B. Ashoka Trust for Research in Ecology and the Environment, Royal Enclave, Srirampura, Jakkur Post, Bangalore-560064 -- View this message in context: http://koha.1045719.n5.nabble.com/Records-Exported-0-tp5840766.html Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Hi, Yes 'koha' is my instance name. Regards Obaiah ATREE -- View this message in context: http://koha.1045719.n5.nabble.com/Records-Exported-0-tp5840766p5840939.html Sent from the Koha-general mailing list archive at Nabble.com.
obaiah schreef op di 19-05-2015 om 23:14 [-0700]:
I am trying to import koha 3.14 database in to koha 3.18.06. When i run mysql dump command I got the following message.
You need to show us the command you're using to do the database dump and restore, and what's with the SQL being output, where's that coming from? If that's the whole of the database dump though, the problem is that you have a totally empty database dump and so zero records would be expected. This said, I'd expect more errors to come from koha-rebuild-zebra in that case. Basically, you need to do some digging: how many records are in your original database (look inside the database), how many are in your restored copy. Do they match? Does the SQL file have the sort of things that you'd expect in it, like your data? But most usefully for us to help is to show exactly what it is that you're doing, otherwise we are just guessing and can't give good solutions. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF
Dear Robin Sheat, Thank you very much for the reply. I have been using koha from past 6-7 years, so far I have not faced any problem and everything was working fine. Two weeks back there was lot of power fluctuation in the institute due to that during the weekend my koha server got crashed. On top of that for my bad luck the external device which I was using also got corrupted. Luckily I have 2 months old data stored in my other device which as about 55MB, now I am trying to import that in to newly installed koha. The commands which I used for dbdump is as follow. mysqldump -u root -p 'koha_koha' < /home/obaiah/koha_koha.sql Enter password: -- MySQL dump 10.13 Distrib 5.5.43, for debian-linux-gnu (x86_64) -- Host: localhost Database: koha_koha I am not very good at SQL. I would be grateful if you could help me to solve this problem. Regards Obaiah B. ATREE -- View this message in context: http://koha.1045719.n5.nabble.com/Records-Exported-0-tp5840766p5840943.html Sent from the Koha-general mailing list archive at Nabble.com.
Hi mysqldump is the command you use to dump a database ie export it, you would never use it with < because that doesn't make sense. Are you trying to export your database or import an old copy? If import you want just mysql. Chris On 21 May 2015 6:43:17 pm NZST, obaiah <obaiah@atree.org> wrote:
Dear Robin Sheat,
Thank you very much for the reply.
I have been using koha from past 6-7 years, so far I have not faced any problem and everything was working fine. Two weeks back there was lot of power fluctuation in the institute due to that during the weekend my koha server got crashed. On top of that for my bad luck the external device which I was using also got corrupted. Luckily I have 2 months old data stored in my other device which as about 55MB, now I am trying to import that in to newly installed koha. The commands which I used for dbdump is as follow.
mysqldump -u root -p 'koha_koha' < /home/obaiah/koha_koha.sql Enter password: -- MySQL dump 10.13 Distrib 5.5.43, for debian-linux-gnu (x86_64) -- Host: localhost Database: koha_koha
I am not very good at SQL. I would be grateful if you could help me to solve this problem.
Regards Obaiah B. ATREE
-- View this message in context: http://koha.1045719.n5.nabble.com/Records-Exported-0-tp5840766p5840943.html Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Sent from my Android device with K-9 Mail. Please excuse my brevity.
Hi, Yes your right, thank you so much for pointing out the mistake. Now its working fine. Thanks a lot for every one for the help. Obaiah B ATREE -- View this message in context: http://koha.1045719.n5.nabble.com/Records-Exported-0-tp5840766p5840947.html Sent from the Koha-general mailing list archive at Nabble.com.
participants (5)
-
Chris Cormack -
Indranil Das Gupta -
Mark Tompsett -
obaiah -
Robin Sheat