Re: Cannot start mysqld

2005-08-10 Thread Pinter Tibor (tibyke)
check if rpm creates mysql user and group. then mysql_install_db, chown mysql:mysql /var/lib/mysql -R and finally try starting mysqld again t >050810 20:26:52 [ERROR] Fatal error: Can't open privilege tables: Table >'mysql.host' doesn't exist >050810 20:26:52 mysqld ended -- MySQL General Maili

Re: DateTime Select optimised

2005-03-21 Thread tibyke
> Select * from where date > _2005-01-07_ and date < > DATE_ADD(_2005-01-07_, INTERVAL 24 HOUR) > > However is there a simpler way of doing it by just passing one date like > > Select * from where date = _2005-01-07_ you may also go for "... WHERE year(foo)=a AND month(foo)=b AND dayofmonth(f

just testing, sorry.

2004-10-18 Thread tibyke
pls delete it regards, tibyke -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 3.23.54 compile error

2002-12-14 Thread tibyke
i mean... "MySQL 3.23.54 safe_mysqld fix" thread, sorry! t GC> GC> When I start mysql with GC> GC> service mysql start GC> GC> I get this error: GC> GC> /usr/bin/safe_mysqld: 5: command not found GC> What's that? GC> GC> By the way mysql seems up and running... GC> GC> GC> GC> ---

Re: 3.23.54 compile error

2002-12-14 Thread tibyke
check "Compiling 3.23.54-1 - new tools installed!" thread... t GC> GC> When I start mysql with GC> GC> service mysql start GC> GC> I get this error: GC> GC> /usr/bin/safe_mysqld: 5: command not found GC> What's that? GC> GC> By the way mysql seems up and running... GC> GC> GC> GC> ---

Re: MySQL 3.23.54 safe_mysqld fix

2002-12-12 Thread tibyke
what an important piece of information, thanks, Nick! tibyke On Thu, 12 Dec 2002 12:46:10 -0600 "Nick" <[EMAIL PROTECTED]> wrote: N> The following code is incorrect in safe_mysqld on 3.23.54 at least (that N> is all I have checked) N> N> Line 162: N> if $NOH

Re: Compiling 3.23.54-1

2002-12-12 Thread tibyke
On Thu, 12 Dec 2002 13:15:05 -0500 "Michael T. Babcock" <[EMAIL PROTECTED]> wrote: MTB> tibyke wrote: MTB> MTB> >the funny this is that 3.23.53 just worked (and compiled) fine, and '53 and '54 have exactly the same spec file. MTB> > MTB> > M

Re: Compiling 3.23.54-1 - new tools installed !

2002-12-12 Thread tibyke
olks! :) it works for me with (redhat 6.2):: - automake14-1.4p5-1 - libtool-1.4.2-4 - autoconf-2.52-6 it also works for me with (redhat 7.3): - automake 1-4p5-4 - libtool-1.4.2-7 - autoconf-2.13-17 7.3 has the out-of-the-box versions, while 6.

Re: Compiling 3.23.54-1

2002-12-12 Thread tibyke
On Thu, 12 Dec 2002 13:15:05 -0500 "Michael T. Babcock" <[EMAIL PROTECTED]> wrote: MTB> tibyke wrote: MTB> MTB> >the funny this is that 3.23.53 just worked (and compiled) fine, and '53 and '54 have exactly the same spec file. MTB> > MTB> > M

Re: Compiling 3.23.54-1

2002-12-12 Thread tibyke
hi, i get the very same problem with: rh 6.2 2.4.17 glibc-2.1.3-28 the funny this is that 3.23.53 just worked (and compiled) fine, and '53 and '54 have exactly the same spec file. what could be the problem then? regards, tibyke GP> I`m trying to compile 3.23.54-1 from src.rpm w

Re: Exact word search

2002-08-21 Thread tibyke
> Hello y'all, > > I guess this is easy, but it is defeating me. > I am having a problem with this query: > > $keyword = "search"; > SELECT * FROM table WHERE field LIKE '%$keyword%' > > The problem is I don't want "sear" or earch but exactly "search". like "% $keyword %"; ---