Re: [Koha] Koha Export Data Options
Dear All, I have been able to resolve the problem. Sharing here for anyone having the same problem. MySQL did an update to their mysqldump dump package for the better, but unfortunately, the change came in a minor patch release and has broken MySQL dump backups for some users. Ref: https://snapshooter.com/docs/fixing-mysqldump-couldn-t-execute-flush-tables-access-denied Best Regards. - Original Message - From: "Ms. Naveen Ali" To: koha@lists.katipo.co.nz Cc: "jonathan druart" Sent: Thursday, 9 March, 2023 9:47:24 AM Subject: Re: [Koha] Koha Export Data Options Dear All, I am still stuck here. Support will be most appreciated. With best regards, Naveen Ali ITM-JE (EAKL) Inst Representative for HEC Digital Library Resources. NEDUET, Karachi. - Original Message - From: "Ms. Naveen Ali" To: koha@lists.katipo.co.nz Sent: Thursday, 2 March, 2023 2:14:45 PM Subject: Re: [Koha] Koha Export Data Options Hi. Sorry for the incomplete information I am using Koha 22.05 Error log shows [Thu Mar 02 13:00:04.468545 2023] [cgi:error] [pid 40831] [client 192.168.14.235:63827] AH01215: Use of uninitialized value $record_type in string eq at /usr/share/koha/intranet/cgi-bin/tools/export.pl line 43.: /usr/share/koha/intranet/cgi-bin/tools/export.pl, referer: http://192.168.14.237:8001/cgi-bin/koha/tools/tools-home.pl Thanks. *With best regards,* *Naveen Ali* * * *ITM-JE (EAKL)* *Inst Representative for * *HEC Digital Library Resources.* *NEDUET, Karachi.* -- *From: *"Jonathan Druart" *To: *"Ms. Naveen Ali" *Cc: *"Koha" *Sent: *Thursday, 2 March, 2023 12:43:55 PM *Subject: *Re: [Koha] Koha Export Data Options Hi, Which version of Koha? Do you see an error in the Koha log files? Regards, Jonathan Le mer. 1 mars 2023 à 11:32, Ms. Naveen Ali a écrit : Dear All, I use Koha Tools-> Export Data->Export Database Option to download dump of Koha database. I have a large database with over 15 books and 8,000 patron records. The dump was a large file around 400MB. Suddenly the dump file now generated is just 1KB. Sharing contents of file -- MySQL dump 10.13 Distrib 8.0.32, for Linux (x86_64) -- -- Host: localhost Database: koha_library -- -- -- Server version 8.0.32-0ubuntu0.20.04.2 /*!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 */; /*!50503 SET NAMES utf8mb4 */; /*!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 */; - No data in the file. I can't understand the reason for this. Can you please help. With best regards, Naveen Ali ITM-JE (EAKL) Inst Representative for HEC Digital Library Resources. NEDUET, Karachi. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha Export Data Options
Dear All, I am still stuck here. Support will be most appreciated. With best regards, Naveen Ali ITM-JE (EAKL) Inst Representative for HEC Digital Library Resources. NEDUET, Karachi. - Original Message - From: "Ms. Naveen Ali" To: koha@lists.katipo.co.nz Sent: Thursday, 2 March, 2023 2:14:45 PM Subject: Re: [Koha] Koha Export Data Options Hi. Sorry for the incomplete information I am using Koha 22.05 Error log shows [Thu Mar 02 13:00:04.468545 2023] [cgi:error] [pid 40831] [client 192.168.14.235:63827] AH01215: Use of uninitialized value $record_type in string eq at /usr/share/koha/intranet/cgi-bin/tools/export.pl line 43.: /usr/share/koha/intranet/cgi-bin/tools/export.pl, referer: http://192.168.14.237:8001/cgi-bin/koha/tools/tools-home.pl Thanks. *With best regards,* *Naveen Ali* ** *ITM-JE (EAKL)* *Inst Representative for * *HEC Digital Library Resources.* *NEDUET, Karachi.* -- > *From: *"Jonathan Druart" > *To: *"Ms. Naveen Ali" > *Cc: *"Koha" > *Sent: *Thursday, 2 March, 2023 12:43:55 PM > *Subject: *Re: [Koha] Koha Export Data Options > > Hi, > > Which version of Koha? > > Do you see an error in the Koha log files? > > Regards, > Jonathan > > Le mer. 1 mars 2023 à 11:32, Ms. Naveen Ali a > écrit : > >> Dear All, >> >> I use Koha Tools-> Export Data->Export Database Option to download dump >> of Koha database. >> >> I have a large database with over 15 books and 8,000 patron records. >> The dump was a large file around 400MB. >> >> Suddenly the dump file now generated is just 1KB. >> >> Sharing contents of file >> >> >> -- MySQL dump 10.13 Distrib 8.0.32, for Linux (x86_64) >> -- >> -- Host: localhost Database: koha_library >> -- -- >> -- Server version 8.0.32-0ubuntu0.20.04.2 >> >> /*!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 */; >> /*!50503 SET NAMES utf8mb4 */; >> /*!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 */; >> >> - >> >> >> No data in the file. I can't understand the reason for this. Can you >> please help. >> >> With best regards, >> >> Naveen Ali >> >> ITM-JE (EAKL) >> Inst Representative for >> HEC Digital Library Resources. >> NEDUET, Karachi. >> >> >> ___ >> >> Koha mailing list http://koha-community.org >> Koha@lists.katipo.co.nz >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >> > > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha Export Data Options
Hi. Sorry for the incomplete information I am using Koha 22.05 Error log shows [Thu Mar 02 13:00:04.468545 2023] [cgi:error] [pid 40831] [client 192.168.14.235:63827] AH01215: Use of uninitialized value $record_type in string eq at /usr/share/koha/intranet/cgi-bin/tools/export.pl line 43.: /usr/share/koha/intranet/cgi-bin/tools/export.pl, referer: http://192.168.14.237:8001/cgi-bin/koha/tools/tools-home.pl Thanks. *With best regards,* *Naveen Ali* ** *ITM-JE (EAKL)* *Inst Representative for * *HEC Digital Library Resources.* *NEDUET, Karachi.* -- > *From: *"Jonathan Druart" > *To: *"Ms. Naveen Ali" > *Cc: *"Koha" > *Sent: *Thursday, 2 March, 2023 12:43:55 PM > *Subject: *Re: [Koha] Koha Export Data Options > > Hi, > > Which version of Koha? > > Do you see an error in the Koha log files? > > Regards, > Jonathan > > Le mer. 1 mars 2023 à 11:32, Ms. Naveen Ali a > écrit : > >> Dear All, >> >> I use Koha Tools-> Export Data->Export Database Option to download dump >> of Koha database. >> >> I have a large database with over 15 books and 8,000 patron records. >> The dump was a large file around 400MB. >> >> Suddenly the dump file now generated is just 1KB. >> >> Sharing contents of file >> >> >> -- MySQL dump 10.13 Distrib 8.0.32, for Linux (x86_64) >> -- >> -- Host: localhost Database: koha_library >> -- -- >> -- Server version 8.0.32-0ubuntu0.20.04.2 >> >> /*!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 */; >> /*!50503 SET NAMES utf8mb4 */; >> /*!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 */; >> >> - >> >> >> No data in the file. I can't understand the reason for this. Can you >> please help. >> >> With best regards, >> >> Naveen Ali >> >> ITM-JE (EAKL) >> Inst Representative for >> HEC Digital Library Resources. >> NEDUET, Karachi. >> >> >> ___ >> >> Koha mailing list http://koha-community.org >> Koha@lists.katipo.co.nz >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >> > > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha Export Data Options
Please reply to the list. Which exact version of Koha? 22.05.XX? It is missing the last part. Le jeu. 2 mars 2023 à 09:01, Ms. Naveen Ali a écrit : > Hi. > Sorry for the incomplete information I am using Koha 22.05 > > Error log shows > > [Thu Mar 02 13:00:04.468545 2023] [cgi:error] [pid 40831] [client > 192.168.14.235:63827] AH01215: Use of uninitialized value $record_type in > string eq at /usr/share/koha/intranet/cgi-bin/tools/export.pl line 43.: > /usr/share/koha/intranet/cgi-bin/tools/export.pl, referer: > http://192.168.14.237:8001/cgi-bin/koha/tools/tools-home.pl > > Thanks. > > *With best regards,* > > *Naveen Ali* > > ** > *ITM-JE (EAKL)* > *Inst Representative for * > *HEC Digital Library Resources.* > *NEDUET, Karachi.* > > > > -- > *From: *"Jonathan Druart" > *To: *"Ms. Naveen Ali" > *Cc: *"Koha" > *Sent: *Thursday, 2 March, 2023 12:43:55 PM > *Subject: *Re: [Koha] Koha Export Data Options > > Hi, > > Which version of Koha? > > Do you see an error in the Koha log files? > > Regards, > Jonathan > > Le mer. 1 mars 2023 à 11:32, Ms. Naveen Ali a > écrit : > >> Dear All, >> >> I use Koha Tools-> Export Data->Export Database Option to download dump >> of Koha database. >> >> I have a large database with over 15 books and 8,000 patron records. >> The dump was a large file around 400MB. >> >> Suddenly the dump file now generated is just 1KB. >> >> Sharing contents of file >> >> >> -- MySQL dump 10.13 Distrib 8.0.32, for Linux (x86_64) >> -- >> -- Host: localhost Database: koha_library >> -- -- >> -- Server version 8.0.32-0ubuntu0.20.04.2 >> >> /*!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 */; >> /*!50503 SET NAMES utf8mb4 */; >> /*!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 */; >> >> - >> >> >> No data in the file. I can't understand the reason for this. Can you >> please help. >> >> With best regards, >> >> Naveen Ali >> >> ITM-JE (EAKL) >> Inst Representative for >> HEC Digital Library Resources. >> NEDUET, Karachi. >> >> >> ___ >> >> Koha mailing list http://koha-community.org >> Koha@lists.katipo.co.nz >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha >> > > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha Export Data Options
Hi, Which version of Koha? Do you see an error in the Koha log files? Regards, Jonathan Le mer. 1 mars 2023 à 11:32, Ms. Naveen Ali a écrit : > Dear All, > > I use Koha Tools-> Export Data->Export Database Option to download dump of > Koha database. > > I have a large database with over 15 books and 8,000 patron records. > The dump was a large file around 400MB. > > Suddenly the dump file now generated is just 1KB. > > Sharing contents of file > > > -- MySQL dump 10.13 Distrib 8.0.32, for Linux (x86_64) > -- > -- Host: localhost Database: koha_library > -- -- > -- Server version 8.0.32-0ubuntu0.20.04.2 > > /*!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 */; > /*!50503 SET NAMES utf8mb4 */; > /*!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 */; > > - > > > No data in the file. I can't understand the reason for this. Can you > please help. > > With best regards, > > Naveen Ali > > ITM-JE (EAKL) > Inst Representative for > HEC Digital Library Resources. > NEDUET, Karachi. > > > ___ > > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
