MySQL 4.0.13-nt-log --Help
Hi, I am running MySQL 4.0.13-nt-log on Windowns XP and I need help on the following: 1) I have written a program in vc++ 6 which writes data to a mysql table; it runs and even make some entries into the table (about 10 per half-day), but after some time (18 hours or less) mysql disconnects; any attempts to reconnect are unsuccessful; when I restart the computer, mysql starts fine. What could the problem? Is it to do with my program or mysql itself? 2) How do I find out when mysql stopped and the cause? where can I find the log file if there is? Thanks. Emmanuel __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.0.13-nt-log --Help
Emmanuel Mwesigwa [EMAIL PROTECTED] wrote on 08/16/2005 04:57:53 AM: Hi, I am running MySQL 4.0.13-nt-log on Windowns XP and I need help on the following: 1) I have written a program in vc++ 6 which writes data to a mysql table; it runs and even make some entries into the table (about 10 per half-day), but after some time (18 hours or less) mysql disconnects; any attempts to reconnect are unsuccessful; when I restart the computer, mysql starts fine. What could the problem? Is it to do with my program or mysql itself? 2) How do I find out when mysql stopped and the cause? where can I find the log file if there is? Thanks. Emmanuel Are you making and breaking connections to the database only as often as you need them or are you trying to maintain one long continuous connection? Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Log HELP!
Mybe this is not a mysql question but a unix command line question: would you please tell me how can I log execution of a DDL? I have a test.sql which is a DDL file, I wanna log its output but when I try the following it create log file but its empty. mysql -u root databasename test.sql log it Just send errors and logs to STDERR. Thanks you for your helps in advance. Regards -- Mohammadreza Shojatalab European Bioinformatics InstituteTel: +44 (0)1223 494 669 EMBL Outstation Fax: +44 (0)1223 494 468 Wellcome Trust Genome Campus E-Mail: [EMAIL PROTECTED] Hinxton, Cambridge URL: http://www.ebi.ac.uk/~shoja CB10 1SD, UK - 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
Re: Log HELP!
Mohammad Shoja wrote: Mybe this is not a mysql question but a unix command line question: would you please tell me how can I log execution of a DDL? I have a test.sql which is a DDL file, I wanna log its output but when I try the following it create log file but its empty. mysql -u root databasename test.sql log mysql -u root databasename test.sql 21 log it Just send errors and logs to STDERR. Thanks you for your helps in advance. -- Gerald L. Clark [EMAIL PROTECTED] - 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
RE: Log HELP!
hi. if you're not on a windows box, try something like: mysql -uroot -p test.sql 21 | tee output.log the mysql client also has a --tee option, as well as a tee(\T) command that could be of use. -ravi. -Original Message- From: Mohammad Shoja [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 11:22 AM To: [EMAIL PROTECTED] Subject: Log HELP! Mybe this is not a mysql question but a unix command line question: would you please tell me how can I log execution of a DDL? I have a test.sql which is a DDL file, I wanna log its output but when I try the following it create log file but its empty. mysql -u root databasename test.sql log it Just send errors and logs to STDERR. Thanks you for your helps in advance. Regards -- Mohammadreza Shojatalab European Bioinformatics InstituteTel: +44 (0)1223 494 669 EMBL Outstation Fax: +44 (0)1223 494 468 Wellcome Trust Genome Campus E-Mail: [EMAIL PROTECTED] Hinxton, Cambridge URL: http://www.ebi.ac.uk/~shoja CB10 1SD, UK - 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 - 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