Richard,

> Hmmmm. On the solaris machines (both), there is currently NO "my.cnf"
> file anywhere, yet MySQL has been working "just fine". I imagine default 
> values are being used for everything. I'll have to select one of the 
> .cnf files from "support-files". I'll let you know how it works.

>>set-variable = max_allowed_packet=16M

If this variable isn't set, the communication buffer (between client
and server) is just 1 MB big. This is a common source of problems,
especially when you are using extended inserts (i.e. INSERT ... VALUES
(...),(...),(...)) like mysqldump would produce with the --opt option.

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  iConnect GmbH <http://iConnect.de>
  Heesestr. 6, 12169 Berlin (Germany)
  Telefon: +49 30 7970948-0  Fax: +49 30 7970948-3

[filter fodder: sql, mysql, query]


---------------------------------------------------------------------
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

Reply via email to