Re: Blob fields

Hi, I have the question related to this topic, hopefully you could help me on this. Is that possible that we insert an encrypted image into blob fields where the encryption is done by using mysql existing function (AES_Encrypt) from the client side? If yes, how is the procedure ? Thanks in advance

slow performance with large "or" list in where

If I do a query such as: SELECT * from foo where fooid = 10 or fooid = 20 or fooid = 03 ... with a total of around 1900 "or fooid =" parts on a given table with 500k rows, it takes about four times longer than doing 1900 separate queries in the form: SELECT * from foo where fooid = 10 fooid is

Re: mysql account

Paul, > I am assuming that the 'alan' account that you're planning to use has > all privileges. Otherwise, you will find after flushing the privileges > that you'll no longer be able to administer your server without starting > it with the --skip-grant-tables option... The *alan* account does h

Re: Convert Foxpro database to Mysql

On Saturday, October 4, 2003, at 11:05 AM, Dwi Suharto Panese wrote: i want to convert the existing foxpro database into mysql database. Any idea? Sure, I've done it a lot. What exactly do you need to know? ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.c

Re: mysql account

Hi, Shanta I do have a 'my.cnf' in 'c:\windows' dir, and it's called 'my.ini' in WinMySQLadmin. As I mentioned early, the ONLY user and password in 'my.cnf' is: user=alan, password=alan. Wait, this is amazing! (I just gave it another try) After about 6hrs, it works now!!! Now only 'alan' can log

Re: ip range lookup

Hi Willem: I have the same database and the only thing different is that I included the country iso name into the primary key: mysql> describe ip_country_database; +-+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +

Re: ip range lookup

Hi Willem, I don't *think* MySQL optimizes BETWEEN like that to use an index. Have you tried this?: SELECT * FROM ipcountry WHERE ip1 >= 123456789 AND ip2 <= 123456789; Matt - Original Message - From: "Willem Bison" Sent: Saturday, October 04, 2003 6:08 PM Subject: ip range lookup

ip range lookup

I have a table that maps ip-ranges to countries: each record consists of 2 ip numbers (unsigned int's) and the country in which all ip's between those two are located. How should I setup the table to have fast ip lookups ? Making a primary key of the 2 ip's and doing a 'select .. between ip1 and ip

Re: Multiple-Column Unique Index Redundancy

At 18:06 -0400 10/3/03, John Kornet wrote: I've been over a few books, the site, and the archives... Can someone please confirm that if I create a unique index over 2 columns, it will be redundant to create a regular index for the first? In other words, does the left-prefix rule apply to unique

Re: GROUP BY/ORDER BY Problem

At 5:52 -0700 10/3/03, Ed Smith wrote: Why doesn't the following work: mysql> CREATE TABLE dog(id integer, breed char(20), age integer, weight integer) ; mysql> SELECT breed, MIN(age) -> FROM dog -> GROUP BY breed -> ORDER BY MIN(age); ERROR : Invalid use of group function I don't

Re: mysql 4.0.15 and latest redhat enterprise AS Beta - segmention fault

At 12:01 +0200 10/3/03, Thomas Gusenleitner wrote: HI List! mysql 4.0.15 won't start on the latest beta of the redhat enterpise AS. (will be released this month) i used the std. rpms for linux x86. i get the following error: Starting mysqld daemon with databases from /var/lib/mysql /usr/bin/my

Re: Mutable mysql servers accessing the same data dir

At 2:45 -0400 10/4/03, Kenneth Lichtenberger wrote: I would like to know how feasible it would be to have more than one mysql server accessing the same data dir. Not recommended. e.g. having two different computers accessing the data dir over a nfs mount And *especially* not recommended over NFS.

Re: changing TMPDIR for tempory file location

At 13:20 -0500 10/3/03, dan orlic wrote: Hello all, My query is about changing the tmpdir on mysql. As stated in on the mysql.com site it states that if it is not set it uses the default, in my case, the default was /tmp. It also states that to change it you can do so in the mysqld_safe start

Re: remote connection 4

At 22:55 +0200 10/4/03, Ms Carlsson wrote: when i try to connect to my mysql database from another machine i get a error like this %mysql -h domain.com -u tellus ERROR 2003: Can't connect to MySQL server on 'domain.com' (61) The port don't listen Apparently the MySQL server on domain.com is not r

Re: mysql account

At 4:35 +1000 10/5/03, Wang Feng wrote: Hi, folks. I use WinXP + MySQL. I deleted all the rows from the 'user' table of the 'mysql' database except my own account (host: localhost, user: alan, password:alan). --- I was hoping only I have the access to the MySQL databases. The problem is that I st

remote connection 4

when i try to connect to my mysql database from another machine i get a error like this %mysql -h domain.com -u tellus ERROR 2003: Can't connect to MySQL server on 'domain.com' (61) The port don't listen and this is disabled in my.cfg # #skip-networking whats wrong and how do i allow remote con

RE: mysql account

do u have a .my.cnf in c:\ dir or c:\windows dir ? from DOS when u issue a mysql command it usually picks up the username and password from the .my.cnf file. - Shanta -Original Message- From: Wang Feng To: [EMAIL PROTECTED] Sent: 10/4/2003 2:35 PM Subject: mysql account Hi, folks. I

mysql account

Hi, folks. I use WinXP + MySQL. I deleted all the rows from the 'user' table of the 'mysql' database except my own account (host: localhost, user: alan, password:alan). --- I was hoping only I have the access to the MySQL databases. The problem is that I still can login to MySQL by the DOS comma

MySQL w/dual-master replication?

Hi there, I realize it's not supported, but nonetheless, I need to investigate how possible it is. The primary goal is high-availability, not performance scaling. It sounds like if I'm careful, it might work out ok. Careful means: - No auto_increment columns... handle unique key assignment i

MySQL Cookbook now available in German

MySQL Cookbook (O'Reilly & Associates) is now available in German (translated by Lars Schulten, Stefan Hinz & Peter Klicman). Information is available at: http://www.kitebird.com/mysql-cookbook/ http://www.oreilly.de/catalog/mysqlckbkger/ -- Paul DuBois, Senior Technical Writer Madison, Wisconsin,

MySQL, Second Edition, now available in French

MySQL, Second Edition, is now available in French. Information is available at: http://www.kitebird.com/mysql-book/ http://www.pearsoneducation.fr/espace/livre.asp?idEspace=73&idLivre=1771 -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certif

Re: Tomcat, Connection Pooling, and MySQL

you need to put mysql-connector-javax in tomcat/common/lib and then specify driverClassName com.mysql.jdbc.Driver in your server.xml Adam On 10/03/2003 04:35 PM Dan Greene wrote: I got it working... unfournately it's on my laptop at home, not here at work with

Convert Foxpro database to Mysql

Hello, i need some help, i want to convert the existing foxpro database into mysql database. Any idea? == Dwi Suharto [EMAIL PROTECTED] System and Network Administratorhttp://www.revlinux.dhs.o

RE: Installing

Make all gives me this libmysql.c: In function `mysql_real_connect': libmysql.c:2177: warning: passing arg 5 of `gethostbyname_r' from incompatible pointer type libmysql.c:2177: too few arguments to function `gethostbyname_r' libmysql.c:2177: warning: assignment makes pointer from integer without

Re: Newbye speed question - which setup to use for indexing

Hi, No, MySQL never uses multiple CPUs for the same query at the same time (the OS could switch the thread between CPUs over time, but that doesn't count :-)). Each connection gets one thread and one thread can only run on one CPU at a time. It would be pretty hard (if not impossible) to have mul