I am trying to change my setting so I can upload my db into my local server so I can keep backup's and test them out.
MySQL version 4.1.11
I get this error
ERROR 1153 (08S01) at line 366: Got a packet bigger than 'max_allowed_packet' bytes
so I want to change the max_allowed_packet
I have edited my other server with this but this is what I get from my fresh install of Fedora Core 4
Re: databases/mysql51-server and beginner's InnoDB questions ::
Sep 16, 2008 MySQl's reputation for speed is based on simple, generally single No, the sample my.cnf files in /usr/local/share/mysql/ are copied
http://markmail.org/message/jczphmktma5oeuqgHOME |
[mysqld]
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
big-tables
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Whisler, David - Profile - Grokbase::
3 posts - Last post: Sep 1, 2006That's a great question. Especially since this file does not exist be using the "my.cnf" file that I've setup in the MYSQL base
http://grokbase.com/profile/id:RPRIvSGnatxEJB973ckydFoRYdG5vcg89Z21Hi9TZVkHOME |
~
~
~
~
~
~
~
~
"my.cnf" 15L, 361C
What file do I need to edit or what do I need to add to this file to get it working correctly?
-Joshua
Thanks Steve! this worked!
It should work. That's the line in my my.cnf file. Try this instead:
max_allowed_packet = 16M
It should work. That's the line in my my.cnf file. Try this instead:
max_allowed_packet = 16M
Under the [mysqld] line, add this:
set-variable = max_allowed_packet = 16M
Assuming you want 16M of course. Restart MySQL after making this change.
if I keep it like that it won't allow my mysqld server to restart.
I am trying to import a 400 mb sql file.
 Where was the last debate on wednesday with Mccain and Obama?
 INSTANCE / WAITING FOR SPRING
|
Simple my.cnf file question