when i want to restore koha sql file using this command mysql -uroot -ppasswd databaseName <koha.sql give me this error ERROR 2013 (HY000) at line 267: Lost connection to MySQL server during query i doing this command to much time before but it appear since two weeks if any solve can tell me. Ahmad Nasser koha system admin. future university in Egypt mobil: +201110136090 -- View this message in context: http://koha.1045719.n5.nabble.com/Mysql-problem-tp5848326.html Sent from the Koha-general mailing list archive at Nabble.com.
Hi, You have not mentioned anything about the versions of software involved here - OS, Koha, MySQL server. Without these information, it is difficult to attempt any help. cheers -indranil On Mon, Jul 27, 2015 at 3:21 PM, ahmnas <ahmad.nasser19@gmail.com> wrote:
when i want to restore koha sql file using this command mysql -uroot -ppasswd databaseName <koha.sql give me this error ERROR 2013 (HY000) at line 267: Lost connection to MySQL server during query i doing this command to much time before but it appear since two weeks if any solve can tell me.
Ahmad Nasser koha system admin. future university in Egypt mobil: +201110136090
-- View this message in context: http://koha.1045719.n5.nabble.com/Mysql-problem-tp5848326.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
-- Indranil Das Gupta 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 Ahmad
when i want to restore koha sql file using this command mysql -uroot -ppasswd databaseName <koha.sql give me this error ERROR 2013 (HY000) at line 267: Lost connection to MySQL server during query i doing this command to much time before but it appear since two weeks if any solve can tell me.
Maybe you've got some SQL insert statements that are bigger than the allowed maximum size (maybe you are loading picture data?). You will find the parameter "max_allowed_packet" in section "mysqld" of file "/etc/mysql/my.cnf" - whatever size it is, increase it. For example max_allowed_packet = 32M In case your problem is depending on the network, increasing the timeout may help. The parameter here is "net_write_timeout", for more information see https://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_... I hope this will help you. Kind regards, Michael
participants (3)
-
ahmnas -
Indranil Das Gupta -
Michael Kuhn