I've created a dump file using mysqldump that is about 4MB. When I try to load it on another server using "mysql database < dump.sql" I get errors. If I create a smaller dump file (below 1MB) it loads without a problem. I noticed that the default max_allowed_packet size is 1MB, but I've not had much success changing it. Everytime I try to create a my.cnf file to reset the default, mysqld starts and then ends abruptly. I'm pretty sure I don't have any syntax errors in my my.cnf file. Any ideas?
Tracy Tracy Kitts Director of Web Services National Business Incubation Association 20 East Circle Drive, Suite 190, Athens, Ohio 45701 (740) 593-4331 phone; (740) 593-1996 fax Visit us virtually at http://www.nbia.org. The National Business Incubation Association advances the business incubation process to increase entrepreneurial success and individual opportunity, strengthening communities worldwide. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002 --------------------------------------------------------------------- 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
