[Koha] Database problem and upgrade
Whenever I try to mysqldump Koha (3.0), the dump fails on line 35431 with an error 2013, lost connection to the MySQL server. To resolve this issue I've tried the following: 1. Changing the my.cnf setting to give a longer time out for the connection, reads and writes - Did not resolve the issue. 2. Ran mysqlcheck to fix the database and also the table. - Table comes back OK but the dump still fails. 3. Do a select on the item using limit to see which record is causing the problem - I get a 2013 error when trying this. If anyone has any suggestion on how to delete this row and dump the database, please let me know. I've exhausted days working on this issue. Thanks, Phillip ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Database problem and upgrade
Phillip Ponchot schreef op do 29-05-2014 om 15:50 [+]: > 3. Do a select on the item using limit to see which record is causing > the > problem - I get a 2013 error when trying this. > > If anyone has any suggestion on how to delete this row and dump the > database, please let me know. I've exhausted days working on this > issue. I haven't seen this myself, but have you tried writing a script that selects the rows one-by-one until it fails, so you find out what record it is that is causing the problem, and then just deleting that record? However, it sound more like this is a MySQL specific issue that you'd have a greater chance of success by taking to MySQL forums. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
