RE: Partial and inexact matches

On Saturday, March 05, 2005 15:21, Robert S wrote: > Probably a real n00b question. > > I am writing a simple contact management database with MySQL (version > 3.23.49-8.9, Debian Woody). I'd like users to be able to enter the > first few characters of a contact's name to do a search, and I'd l

Re: "Load Data Infile ... Repair with KeyCache" --WAY SLOW!

Hi, On Mar 6, 2005, at 12:51 PM, mos wrote: At 10:07 PM 3/2/2005, you wrote: Hello. You may use ALTER TABLE .. DISABLE KEYS to speed up the loading process on the MyISAM table. I gave that a try but I had to cancel "Alter Table ... Enable Keys" after 49 hours. I find it amazing that it takes only

Re: select date_format('2004-10-03 15:06:14','%m/%d/%y %T');

Scott Hamm wrote: How do I create a table using: date_format('2004-10-03 15:06:14','%m/%d/%y %T'); That way I can import Access Data? Can't do that. You can import Access data via ODBC - that way the driver figures out how to send the data to MySQL. I assume you are trying to export to a text f

Sum() unequal number of rows

SELECT sum(col1) AS total1 FROM t1 GROUP by col1 SELECT col1, sum(col2) AS total2 FROM t2 GROUP by col2 Table t1 contains 4 rows to sum for each value in col1 Table t2 contains 8 rows to sum for each value in col2 If one select statement is used, the result has 8 rows and total2 is corre

Access Denied

I have installed in a single user called "metal-host" more than 10 databases all with different names and in different php scripts (phpbb phpnuke mambo etc). the problem is that they only work as I install them,after some hour later all the scripts show me that error : Access denied for user: '[E

Re: permission denied error

Usually, datadir is a subdirectory of basedir. Something like mysqld_safe --basedir=/data/mysql --datadir=/data/mysql/data --user=mysql & Are you certain you want your databases in your basedir, rather than in a subdirectory? The errors you are getting seem to indicate that user mysql cannot wr

Re: "Load Data Infile ... Repair with KeyCache" --WAY SLOW!

At 10:07 PM 3/2/2005, you wrote: Hello. You may use ALTER TABLE .. DISABLE KEYS to speed up the loading process on the MyISAM table. I gave that a try but I had to cancel "Alter Table ... Enable Keys" after 49 hours. I find it amazing that it takes only 6.25 hours to load 450 million rows into th

Re: CygWin and MySQL???

Hey, Those RPMS are compiled for a linux architecture. Cygwin is the GNU tools (plus a few others) compiled under windows to similate a linux environment. It can't actually execute those binaries. You have three options: 1) Install the Windows binary. You won't be able to compile things like DBD

RE: Unicode characters are giving me question marks

one has to encode "extend string or any unicode" to utf-8 first and then insert it to MySQL database 4.1 Most likely you did not encode them to utf-8. zhi peng "Steve Quezadas" <[EMAIL PROTECTED]> wrote: >Hey guys, > >I just upgraded to mysql 4.1 and I'm trying to get damn unicode to work i

CygWin and MySQL???

Whenever I try to install the RPM for Linux i386 on CygWin it fails with an error saying:   Error: MySql-??-4.1.10-0.i386.rpm: V3 DSA signature: BAD, key ID 5072e1f5 Error: MySql-??-4.1.10-0.i386.rpm cannot be installed   Where ?? is: devel, chared-compat or client   What

permission denied error

Hi, I have moved my base and data directories at /data/mysql on my system and /data/mysql is owned by user mysql. Earlier these were located at /var/lib/mysql my /etc/my.cnf has following entries: # The following options will be passed to all MySQL clients [client] #password = your_passwor