The error: /usr/local/bin/mysqldump: Error 5: Out of memory (Needed 14154840 bytes) when dumping table `Attachments` at row: 24285
Platform details: Client: mysqldump Ver 10.9 Distrib 4.1.12, for portbld-freebsd5.3 (i386) # /usr/local/bin/mysqldump -u dba -h seisei -p rt3 --set-variable=max_allowed_packet=256M Attachments > Attachments.sql Server: FreeBSD seisei.mydomain.net 5.3-RELEASE-p9 FreeBSD 5.3-RELEASE-p9 mysql-server-4.0.24_1 (from ports) I have kern.maxdsiz="751619277" #750 MB kern.dfldsiz="751619277" kern.maxssiz="134217728" # 128MB in /boot/loader.conf and mysql_enable=YES mysql_limits="YES" in /etc/rc.conf and max_allowed_packet = 256M in /etc/my.cnf Currently: 90035 mysql 20 0 503M 239M kserel 41:04 0.00% 0.00% mysqld So, I can see it hitting the 512M limit, but I had thought that the commands in /boot/loader.conf were supposed to fix that (as per http://dev.mysql.com/doc/refman/4.1/en/freebsd.html) Any suggestions as to where I've missed something would be great. Thanks, Graham -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
