My table structure is very simple and does not use big column like text nor blub at all. But when I load several million rows into master server using mysqlimport, on slave I got the error like
021129 13:24:40 Error reading packet from server: log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master (server_errno=1236) 021129 13:24:40 Got fatal error 1236: 'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master' from master when reading data from binary log I have two questions. First, mysqlimport does not commit until the entire data are imported? Second, If the answer to the first question is Yes, it can cause the above error? :query -- Chung Ha-nyung <alita@[neowiz.com|kldp.org]> Sayclub <http://www.sayclub.com> NeoWiz <http://www.neowiz.com> --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php