Filesystem Backup: user error: Got a packet bigger than 'max_allowed_packet' [#33314]

Cent OS 3.X, Mysql 4.x, PHP 4.x

Here is my my.cnf file

BEGIN FILE
[mysqld]
set-variable = max_connections=500
safe-show-database
END FILE

When trying to run the backup I get this. I'm sure I've not configured something correctly. I have tmp on the default position or the root of the server.

user error: Got a packet bigger than 'max_allowed_packet'
query: INSERT INTO variable (name, value) VALUES ('fbu_stored_tasks', 's:997471:\"a:71:{i:0;a:50:{s:46:\"/home/johnbran/public_html/modules/help.module\";O:8:\"stdClass\":3:{s:8:\"filename\";s:46:\"/home/johnbran/public_html/modules/help.module\";s:8:\"basename\";s:11:\"help.module\";s:4:\"name\";s:4:\"help\";}s:52:\"/home/johnbran/public_html/modules/folksonomy.module\";O:8:\"stdClass\":3:{s:8:\"filename\";s:52:\"/home/johnbran/public_html/modules/folksonomy.module\";s:8:\"basename\";s:17:\"folksonomy.module\";s:4:\"name\";s:10:\"folksonomy\";}s:45:\"/home/johnbran/public_html/modules/dba.module\";O:8:\"stdClass\":3:{s:8:\"filename\";s:45:\"/home/johnbran/public_html/modules/dba.module\";s:8:\"basename\";s:10:\"dba.module\";s:4:\"name\& in /home/johnbran/public_html/includes/database.mysql.inc on line 66.

Comments

Comment #1

jsbthree commented 7 October 2005 at 07:02

Forgot to mention i was trying to create 10 mb files if that makes a difference.

I kicked it down to 5 mb and set it to tar rather than gz and this

warning: fopen(/home/johnbran/public_html/_vti_pvt/service.pwd): failed to open stream: Permission denied in /usr/local/lib/php/File/Archive/Writer.php on line 99.