Here's what the error log says: mysqld started .../bin/mysqld: Undefined symbol "strtoll" mysqld ended
Thanks, Tracy -----Original Message----- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 2:07 PM To: [EMAIL PROTECTED] Subject: RE: error when trying to load large dump files Hi Tracy, Just add err-log=/path/to/logfile/mysqld.err under safe_mysqld entry in your my.cnf file and see what the error file says after you restart it.. We can track down the problem from the error.. Gurhan -----Original Message----- From: Tracy Kitts [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 28, 2002 1:50 PM To: mySQL List Subject: error when trying to load large dump files 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 --- Incoming 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 --- 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
