need location and how to configure logs for 4.0.15-nt-log

Hey I've been looking for the log files on a mysql version 4.0.15 install on a windows 2000 box. I've looked in the config file and there is somethign for called log-bin. How do i turn on and configure logging? Thanks. -- Chris Edwards Web Application Developer Outer Banks Internet

sql question

opic. Gives me: ++-+---+---+---+ +---+ | id | name| createdby| order | created | topics| posts | ++-+---+---+---+ +---+ | 29 | Test Category One | Chris Edwards | 0 |

Re: strange date problem SOLVED

all zero. > > Whats going on? I guess I should have looked at this alittle longer before posting. no such thing as 24th hour 23.59 then 0. -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com -- MySQ

strange date problem

;Rachel' ) I get no errors from mysql. (MySQL 3.23.54) on a freebsd system. But I do get: 03 01 Test 2 Event is not displaying correct date. -00-00 00:00:00 -00-00 00:00:00 0 Rachel in mysql. The dates are all zero. Whats going on? -- Chris Edwards Web Application Develop

preserving indexes

show their correct cardinality. I don't think phpMyAdmin is at fault because searching on the table before I fix it is sluggish until afterwards. Is the a command I could run that would re-index everything after I dump the data into the table? Or what is going on? thanks. -- Chris E

text search question

looking for a quick way to search. Does anyone have any suggestions? Thanks. -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql T

multiple ORs

provide optimization for this? Thanks. -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com - Original Message - From: "James" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday,

Re: fastest way to get last row

Hi Thanks! Looks like everyone knew the exact answer. I guess I posted too soon, as I figured it out also. -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com - Original Message - From: "Ryan Yag

fastest way to get last row

one? Not using mysql 4... Thanks. -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com - Original Message - From: "Peter Brawley" <[EMAIL PROTECTED]> To: "Bruce Feist" <[E