[Koha] Koha Export Data Options

[Ms. Naveen Ali]

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" <naveen at neduet.edu.pk> 
To: koha at lists.katipo.co.nz 
Cc: "jonathan druart" <jonathan.druart at bugs.koha-community.org> 
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" <naveen at neduet.edu.pk> 
To: koha at 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" <jonathan.druart at bugs.koha-community.org> 
*To: *"Ms. Naveen Ali" <naveen at neduet.edu.pk> 
*Cc: *"Koha" <koha at lists.katipo.co.nz> 
*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 <naveen at neduet.edu.pk> a 
écrit : 


<blockquote>
Dear All, 

I use Koha Tools-> Export Data->Export Database Option to download dump 
of Koha database. 

I have a large database with over 150000 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 at lists.katipo.co.nz 
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha 





_______________________________________________ 
</blockquote>



Koha mailing list http://koha-community.org 
Koha at lists.katipo.co.nz 
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha