Can't start mysql
Does anybody know what is the problem. MySql ran out of memory and I have not been able to start it again. Here's an error from log file: 070827 15:09:17 mysqld started ^G/usr/sbin/mysqld: Character set 'utf8 |' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file 070827 15:09:17 [ERROR] Aborting 070827 15:09:17 [Note] /usr/sbin/mysqld: Shutdown complete 070827 15:09:17 mysqld ended Any help appreciated. -Original Message- From: Weston, Craig (OFT) [mailto:[EMAIL PROTECTED] Sent: Monday, August 27, 2007 1:02 PM To: mysql@lists.mysql.com Subject: [MYSQL]Time formatting for cycle time. Hello all, I am working on Martin Minka's date diff function as found at http://forge.mysql.com/snippets/view.php?id=56. It is a beautiful thing. However, I am trying to alter it or identify a similar function that instead of giving me the number of days between two dates it returns the number of workday hours:minutes between two datetimes, or some other date differential (such as an exact number of days between two dates with remainder) I hate asking open ended questions, but can anyone give me any hints as to how to make this conversion? I may be able to figure it out... In a few weeks. My long term goal is to identify the business hours(minutes, seconds, whatever) between two dates, taking into account weekends, holidays, and business hours. Thanks, Craig This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
java.util.Date versus java.sql.Date
Hello Besides some obvious differences in implementations between util.Date and sql.Date are there any other issues/advantages or disadvantages using one versus the other? Thanks
Question
Does anybody know how can I see what queries are currently being executed? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Question
Thanks, worked fine for me. Felix -Original Message- From: Chris Comparini [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 03, 2006 11:10 AM To: mysql@lists.mysql.com Subject: Re: Question On Tuesday 03 October 2006 10:57, Feliks Shvartsburd wrote: Does anybody know how can I see what queries are currently being executed? From the mysql commandline, use show processlist; There is also a program called mytop which shows what's executing. -Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Question
Hi I have several problems. I'm using MySql 5 and it is running on Linux. When I'm trying to execute mysql -u root -p I get the following: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) I'm also not able to stop the server. When I run mysql.server stop it gives me some garbage. Please help. Thanks -Original Message- From: George Law [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 03, 2006 11:25 AM To: Feliks Shvartsburd; mysql@lists.mysql.com; [EMAIL PROTECTED] Subject: RE: Question show processlist gives you an abbreviated list of queries. show full processlist gives you the full queries. -Original Message- From: Feliks Shvartsburd [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 03, 2006 1:57 PM To: mysql@lists.mysql.com; [EMAIL PROTECTED] Subject: Question Does anybody know how can I see what queries are currently being executed? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Help needed
Hi I'm having a problem compiling store procedure getting errors that don't make much sense. The problem is that I need to filter any value that is either NULL or an empty string an set to '0' character. SP is below CREATE PROCEDURE test () BEGIN DECLARE code VARCHAR(10) DEFAULT '0'; update table_name set filed_name = CASE when ISNULL(filed_name) = 1 OR CHAR_LENGTH(filed_name) = 0 then code END CASE; END; Thanks for any help.