On Sun, 26 Mar 2006 13:41:18 +0900, Gerald Vogt wrote: > xulplanet.com is expired. Whois says:
I use the offline version of devboi <http://devboi.mozdev.org/> which puts several references (XUL, CSS, HTML) into a sidebar. I also have a ZIP/RAR archive of XULPlanet someone posted to a ruskie website. I use Foxdoc <http://percro.sssup.it/~pit/mozilla/foxdoc/> to browse html files inside ZIP archives. >> SQL Error : 1153 Got a packet bigger than 'max_allowed_packet' bytes A.2.9. Packet too large A communication packet is a single SQL statement sent to the MySQL server or a single row that is sent to the client. The largest possible packet that can be transmitted to or from a MySQL 5.0 server or client is 1GB. When a MySQL client or the mysqld server receives a packet bigger than max_allowed_packet bytes, it issues a Packet too large error and closes the connection. With some clients, you may also get a Lost connection to MySQL server during query error if the communication packet is too large. Both the client and the server have their own max_allowed_packet variable, so if you want to handle big packets, you must increase this variable both in the client and in the server. If you are using the mysql client program, its default max_allowed_packet variable is 16MB. To set a larger value, start mysql like this: shell> mysql --max_allowed_packet=32M That sets the packet size to 32MB. The server's default max_allowed_packet value is 1MB. You can increase this if the server needs to handle big queries (for example, if you are working with big BLOB columns). For example, to set the variable to 16MB, start the server like this: shell> mysqld --max_allowed_packet=16M You can also use an option file to set max_allowed_packet. For example, to set the size for the server to 16MB, add the following lines in an option file: [mysqld] max_allowed_packet=16M ....etc.... Phil -- Philip Chee <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> http://flashblock.mozdev.org/ http://xsidebar.mozdev.org Guard us from the she-wolf and the wolf, and guard us from the thief, oh Night, and so be good for us to pass. [ ]Hell hath no fury like the lawyer of a woman scorned. * TagZilla 0.059 _______________________________________________ Project_owners mailing list [email protected] http://mozdev.org/mailman/listinfo/project_owners
