Re: Cannot start mysqld
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 Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: DateTime Select optimised
Select * from TABLE 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 TABLE where date = _2005-01-07_ you may also go for ... WHERE year(foo)=a AND month(foo)=b AND dayofmonth(foo)=c; t -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
just testing, sorry.
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
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 - GC Before posting, please check: GChttp://www.mysql.com/manual.php (the manual) GChttp://lists.mysql.com/ (the list archive) GC GC To request this thread, e-mail [EMAIL PROTECTED] GC To unsubscribe, e-mail [EMAIL PROTECTED] GC Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php GC GC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 3.23.54 compile error
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 - GC Before posting, please check: GChttp://www.mysql.com/manual.php (the manual) GChttp://lists.mysql.com/ (the list archive) GC GC To request this thread, e-mail [EMAIL PROTECTED] GC To unsubscribe, e-mail [EMAIL PROTECTED] GC Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php GC GC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Compiling 3.23.54-1
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 with error: GP GP ... GP + mv Docs/manual.ps.save Docs/manual.ps GP + automake GP aclocal.m4: 1272: `AM_PROG_INSTALL' is obsolete; use `AC_PROG_INSTALL' GP aclocal.m4: 1273: `AM_PROG_INSTALL' is obsolete; use `AC_PROG_INSTALL' GP aclocal.m4: 1379: `AM_PROG_INSTALL' is obsolete; use `AC_PROG_INSTALL' GP libmysql_r/Makefile.am:26: library used but `LIBTOOL' not defined in `configure.in' GP Error: Bad exit status from /var/tmp/rpm-tmp.61894 (%build) GP GP GP RPM build errors: GP Bad exit status from /var/tmp/rpm-tmp.61894 (%build) GP GP My conf is: GP rh 7.0 GP 2.2.23 GP glibc-2.2.4-18.7.0.8 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Compiling 3.23.54-1
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 MTB MTB Did the mysql team change tools versions? automake/autoconf? that's what im trying to figure it out.. im just writing a mail to [EMAIL PROTECTED] (rpm packages maintainer) regards, tibyke - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Compiling 3.23.54-1 - new tools installed !
On Thu, 12 Dec 2002 21:29:40 - Jocelyn Fournier [EMAIL PROTECTED] wrote: JF Hi, JF JF You should downgrade automake to 1.5 and if it still doesn't work, try with JF autoconf 2.52. JF JF Regards, JF Jocelyn hi, MySQL folks! :) 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.2 is updated regularly :) regards, tibyke - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Compiling 3.23.54-1
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 MTB MTB Did the mysql team change tools versions? automake/autoconf? MTB MTB -- MTB Michael T. Babcock MTB C.T.O., FibreSpeed Ltd. MTB http://www.fibrespeed.net/~mbabcock Hi! As I wrote in another thread: 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.2 is updated regularly :) __however___! dont forget to modify /usr/bin/safe_mysqld: As Nick writes it in MySQL 3.23.54 safe_mysqld fix thread: snip The following code is incorrect in safe_mysqld on 3.23.54 at least (that is all I have checked) Line 162: if $NOHUP_NICENESS -gt 0 then $NOHUP_NICENESS=nice --$NOHUP_NICENESS nohup This needs to be: if test $NOHUP_NICENESS -gt 0 then NOHUP_NICENESS=nice --$NOHUP_NICENESS nohup Thanks! Nickg /snip after all, now 3.23.54 just works fine for me :) Regards, tibyke - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 3.23.54 safe_mysqld fix
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 $NOHUP_NICENESS -gt 0 N then N $NOHUP_NICENESS=nice --$NOHUP_NICENESS nohup N N N This needs to be: N N if test $NOHUP_NICENESS -gt 0 N then N NOHUP_NICENESS=nice --$NOHUP_NICENESS nohup N N N N Thanks! N N Nickg N N N - N Before posting, please check: Nhttp://www.mysql.com/manual.php (the manual) Nhttp://lists.mysql.com/ (the list archive) N N To request this thread, e-mail [EMAIL PROTECTED] N To unsubscribe, e-mail [EMAIL PROTECTED] N Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php N N - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Exact word search
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 %; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php