From: Feliks Shvartsburd Date: August 28 2007 12:38am Subject: Can't start mysql List-Archive: http://lists.mysql.com/mysql/208751 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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:Craig.Weston@stripped]=20 Sent: Monday, August 27, 2007 1:02 PM To: mysql@stripped Subject: [MYSQL]Time formatting for cycle time. Hello all,=20 I am working on Martin Minka's date diff function as found at http://forge.mysql.com/snippets/view.php?id=3D56. 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) =20 =20 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.=20 =20 My long term goal is to identify the business hours(minutes, seconds, whatever) between two dates, taking into account weekends, holidays, and business hours. =20 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.