Re: Extraneous warning 1292 (Incorrect datetime value)

2011-08-12 Thread Hal�sz S�ndor
2011/08/07 18:20 +0300, Marius Feraru Would someone please shed some light on what's wrong with calls like IF( DATE(d) = some-date, TIME(d), d ) on DATETIME columns? Thank you. I run some tests on mysql 5.0, 5.1 and 5.5: got the same wierd results everywhere, so I guess I'm missing

Re: Import from Quicken 2004 Mac?

2011-08-12 Thread Hal�sz S�ndor
2011/08/11 14:14 -0700, Jan Steinman QB 2010 Mac appears to only export .IIF format, which appears to be a variant of the older .QIF format, and Google didn't turn up really anything for getting IIF/QIF files into MySQL. The best I could find would be importing them into Excel first, then CSV

Re: error log rotation problem

2011-08-12 Thread Paul DuBois
On Aug 11, 2011, at 2:30 PM, Keith Murphy wrote: Hey everyone, I have run across something that has me stumped. I have some systems that have very large error logs because we haven't moved from statement-based to mixed-based replication yet so they get a lot of warnings logged. I need to

Re: error log rotation problem

2011-08-12 Thread Prabhat Kumar
this will help you http://adminlinux.blogspot.com/2009/09/mysql-log-file-rotation.html On Fri, Aug 12, 2011 at 9:43 AM, Paul DuBois paul.dub...@oracle.com wrote: On Aug 11, 2011, at 2:30 PM, Keith Murphy wrote: Hey everyone, I have run across something that has me stumped. I have some

Re: error log rotation problem

2011-08-12 Thread Keith Murphy
Hey everyone, the problem was that I have the error log in /var/log/mysqld/mysql.error and SELinux was not configured to allow it to rotate. I have compiled a custom module to allow it so the problem is resolved. It was not an issue with MySQL Server itself. thanks again. Keith On Fri, Aug 12,

Re: Import from Quicken 2004 Mac?

2011-08-12 Thread Chris Elhardt
might want to look at QIF Master. Generally designed to convert lists of data into QIF formats but Mr. Wooward may have some other tools to go the other way also. c On Aug 11, 2011, at 5:02 PM, David Brian Chait wrote: I don't think I have ever heard of anyone directly importing a QIF