anniversary selects

2009-12-26 Thread Noel Butler
Hi, Hope we all had a great Christmas! I am trying to run a query that selects a member every 365 days so we can send them a domain reminder. For my test (because i'm too lazy to count out someone with hundreds of days :) ) I am using a known member at around 27/28 days Now if I use this if finds

RE: anniversary selects

2009-12-28 Thread Noel Butler
Thanks, that's exactly what I was after. On Mon, 2009-12-28 at 14:53 -0800, Daevid Vincent wrote: > Perhaps the examples here would help you: > http://dev.mysql.com/doc/refman/5.0/en/date-calculations.html > > > -Original Message- > > From: Noel Butler [mai

Re: Birthday Calendar

2010-03-23 Thread Noel Butler
does this list not have a dickhead filter? On Tue, 2010-03-23 at 15:17 +, Ganeswar Mishra wrote: > Hi > > Please click on the link below and enter your birthday for me. I am creating > a birthday calendar for myself. Don't worry, it'll take less than a minute > (and you don't have to ent

Re: Database Quotas

2010-05-20 Thread Noel Butler
On Thu, 2010-05-20 at 16:27 -0700, Tim Gustafson wrote: > Hi, > > I'm not sure if this is already an open issue or not - a Google search > resulted in various discussions but I didn't find any open support/feature > request. > > It would be really handy if during the "create database" statemen

Re: phpMyAdmin and other management tools

2010-07-01 Thread Noel Butler
On Thu, 2010-07-01 at 07:38 -0400, David Stoltz wrote: > Hi Folks, > > > > I'm currently using phpMyAdmin to manage the mySQL databases. I'm > wondering what most people like to use? I know there is "mySQL > Workbench", which I haven't really fooled with yet > command line (mysql prompt

Re: [NEWS]

2010-12-15 Thread Noel Butler
On Wed, 2010-12-15 at 14:06 +0200, Sergey Lazurenko wrote: > Hello! Hello! I'd like to place basic information about our products. I'll > be appreciate you. > > Best Regards, > Sergey Lazurenko > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe

Re: Autostart not working for me in 5.5.8 version

2010-12-20 Thread Noel Butler
Hi Joerg, On Mon, 2010-12-20 at 18:59 +0100, Joerg Bruehe wrote: > Hi Noel, all! > > > Noel Butler wrote: > > On Thu, 2010-12-16 at 10:08 -0300, Alejandro Bednarik wrote: > >> You are right. In previous version init script have a default value, now is > >

mysqlcheck 5.5 -a -o

2011-01-16 Thread Noel Butler
In all previous versions we were able to run -Aao --auto-repair Anyone know WHY, in 5.5, -a and -o , must be run separately, this is kind of silly I think, requiring two passes now. signature.asc Description: This is a digitally signed message part

re: mysqlcheck 5.5 -a -o

2011-01-17 Thread Noel Butler
On Mon, 2011-01-17 at 14:50 +0200, Michael Widenius wrote: > Hi! > > >>>>> "Noel" == Noel Butler writes: > > Noel> In all previous versions we were able to run -Aao --auto-repair > > Noel> Anyone know WHY, in 5.5, -a and -o , mus

libmysqlclient.so.16 no version information available

2011-01-31 Thread Noel Butler
Arg! This abomination 5.5 is causing more headaches, postfix will not run, I've heard dovecot may not either, amongst others postconf: /usr/lib/libmysqlclient.so.16: no version information available (required by postcon /etc/init.d/postfix start * Starting Postfix Mail Transport Agent postfi

Re: libmysqlclient.so.16 no version information available

2011-01-31 Thread Noel Butler
ain daemons, i don't trust distro butchers , err, i mean maintainers, for these critical apps. thanks anyway. > > Am 31.01.2011 09:24, schrieb Noel Butler: > > > > Arg! This abomination 5.5 is causing more headaches, > > > > postfix will not run, I

Re: libmysqlclient.so.16 no version information available

2011-01-31 Thread Noel Butler
out open source, each to their own. when there is only one version of the lib installed it should not be an issue, I've been building tarballs for 20 years, so do understand how the OS works and how to best use configure :) > Am 31.01.2011 11:38, schrieb Noel Butler: > > On M

Re: mysql apache md5

2011-03-07 Thread Noel Butler
On Mon, 2011-03-07 at 13:51 +0100, Johan De Meersman wrote: > Umm... I'm no crypto guru, but I've never heard of MD5 having variants, let > alone a salt. MD5 is MD5 is MD5. APR, incidentally, is the Apache Runtime, > afaik - part of the build kit for apache modules. > > I strongly suspect your

Re: Remote mysql too slow

2012-04-09 Thread Noel Butler
On Mon, 2012-04-09 at 06:14 -0500, Johnny Withers wrote: > right speed and duplex. It seems that every new server I get now has > to have the speed and duplex explicitly set instead of auto negotiate. > Many of the cisco switches are notorious for this. signature.asc Description: This is a

Out of office replies

2012-04-09 Thread Noel Butler
People, most of you are/should be professionals. It is about time your mail servers were configured to never send "out of office" bullshit replies in response to mailing list messages. I realise this is difficult here and is oracles fault for running an abandonware mail server (qmail) and antiquat

ATT: List OWNER/MODERATOR

2012-05-17 Thread Noel Butler
List is broken, in many ways. Amongst many of its failures, the two current biggest is: 1/ This lists bounce messages are clueless they do not include the reject reason 2/ mysql-owner address STILL points to a sun address which of course is rejected as they no longer host this list. *sigh*

Re: ATT: List OWNER/MODERATOR

2012-05-17 Thread Noel Butler
On Fri, 2012-05-18 at 03:40 +0200, Reindl Harald wrote: > Am 18.05.2012 02:51, schrieb Noel Butler: > > List is broken, in many ways. > > > > Amongst many of its failures, the two current biggest is: > > > > 1/ This lists bounce messages are clueless they do

Re: GA download reverted back to 5.5.24?

2012-06-29 Thread Noel Butler
That was nice of oracle to announce this wasn't it ...(/sarcasm) On Fri, 2012-06-29 at 16:35 -0400, Shawn Green wrote: > On 6/28/2012 9:41 PM, Hank wrote: > > I am in the process of reporting a new MySQL bug in 5.5.25 (doesn't > > exist in 5.5.24) - see: http://bugs.mysql.com/bug.php?id=6574

Re: GA download reverted back to 5.5.24?

2012-06-29 Thread Noel Butler
On Sat, 2012-06-30 at 11:34 +1000, Noel Butler wrote: > That was nice of oracle to announce this wasn't it ...(/sarcasm) > not to mention source of 25a can not be found anywhere on any mirror I looked at, or the download page fucking hopeless > > On Fri, 2012-06-

Re: GA download reverted back to 5.5.24?

2012-06-29 Thread Noel Butler
I wonder if you would have the same opinion to say your Operating System environment, Apache, php, any mainstream server daemon, how about they pull the current version for a serious bug, but dont tell anyone... Oracle have been quick to announce new releases of mysql, but failed to issue a notic

Re: GA download reverted back to 5.5.24?

2012-07-05 Thread Noel Butler
shows incompetenceon the part of the software developer, not the users. On Sat, 2012-06-30 at 14:15 +1000, Noel Butler wrote: > I wonder if you would have the same opinion to say your Operating > System environment, Apache, php, any mainstream server daemon, how > about they pull the c

ignore-db-dir

2012-09-05 Thread Noel Butler
Shaun, Is this option planned for backport into 5.5.x ? Cheers signature.asc Description: This is a digitally signed message part

Re: MySQL Client (libmysqlclient) compatibility policy

2013-02-18 Thread Noel Butler
On Mon, 2013-02-18 at 10:57 +0100, Sebastien FLAESCH wrote: > I have several versions of MySQL installed on my Linux, and it appears > that the libmysqlclient versions have changed in the 5.x version line: > > /opt3/dbs/mys/4.1.24/lib/libmysqlclient.so.14 > /opt3/dbs/mys/5.0.90/lib/libmysqlclien

Re: How to change max simultaneous connection parameter in mysql.

2013-03-18 Thread Noel Butler
On Mon, 2013-03-18 at 21:35 +0100, Reindl Harald wrote: > > Am 18.03.2013 21:01, schrieb Rick James: > > 20 is plenty if your pages run fast enough > > if your server can not serve more than 20 simultaionous > requests you are not doing any serious things > or he's using a 286 signatu

Re: remove me from the mailing

2013-04-06 Thread Noel Butler
On Sat, 2013-04-06 at 16:18 +, attee...@gmail.com wrote: > You don't have to be a jackass to him/her. > He's always a jackass, but, I must say, it is a rare occasion that I agree, and, hte *idiot* who posted all those lines was certainly more of a jackass. > The CAN SPAM act requires that

Re: MySQL Community Server 5.6.13 has been released

2013-08-05 Thread Noel Butler
On Thu, 2013-08-01 at 10:41 +0200, Sebastien FLAESCH wrote: > Hello, > > On 07/31/2013 01:03 PM, Sunanda Menon wrote: > > * The C API libmysqlclient shared-library .so files now have > > version 18.1.0 (up from version 18.0.0 used in MySQL 5.5). > > (Bug #16809055) > > W

Re: MariaDB

2013-08-11 Thread Noel Butler
I thought someone, even Monty, would have chimed in here, but... On Fri, 2013-08-09 at 16:28 +1000, Nick Edwards wrote: > Question, is building the source exactly the same as mysql? yes > Meaning, if I build it with set CMAKE options building mysql, can I > use those exact same options buildi