mysql@lists.mysql.com

2002-06-15 Thread root
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:root >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release:

Re: Problem with load data infile and user's privileges

2002-06-15 Thread Jason Englehardt
On Sat, 15 Jun 2002, Sergey Bondar wrote: > OS Linux Red Hat 7.2 > MySql 3.23.41 > > Hi All! > That is my steps. > > With root privileges > I doing: > GRANT ALL ON mydb.* TO client@localhost identified by "pwd"; > I got: > OK The user needs the file privilege. Granting all on mydb.* does not giv

Re: How can I install MySQL client only!

2002-06-15 Thread Jason Englehardt
On Sat, 15 Jun 2002, JamesWang Home wrote: > Hi, > > I have a question. I can install MySQL server on machine A. I am trying to > install client on machine B only by select "customer" install and click > "next" button. But I cannot deselect MySQL server. It is always checked and > disabled. > > D

Re: MySQL 4.0.1 & SSL config - a shot in the dark

2002-06-15 Thread Tonu Samuel
On Sat, 15 Jun 2002, Clay Loveless wrote: > I've been trying to figure out how to set up SSL support in mysql-4.0.1 ... > The online documentation is pretty sparse on the subject. > > Here's what I've got so far -- and so far this is *NOT* working. I'm putting > it out here so that someone else

pooled access for speedup queries

2002-06-15 Thread [EMAIL PROTECTED]
Hello to all, I'm new to mysql programming, I had recently switched from interbase6 to mysql to test speed differences. I have builded a simple test loading (under win2k server) the mysql library (to achieve direct access). Into this bench I have run many times 100 sequential queries to test th

Re: How can I install MySQL client only!

2002-06-15 Thread MikeParton
Get a different client to load on the other machine. Some options: MyCC (www.mysql.com) (this is currently version 0.8.4 and is an alpha dbTools 1.1.13 (www.dbtools.com.br) this is pretty slick - Original Message - From: "JamesWang Home" <[EMAIL PROTECTED]> To:

Re: innodb keeps crashing due to out-of-memory errors.

2002-06-15 Thread Per Andreas Buer
Hi Heikki, thanks for replying so swiftly. "Heikki Tuuri" <[EMAIL PROTECTED]> writes: > this is probably a real bug. It is trying to allocate 1.5 GB of memory in > one shot, which does not make sense. More probably the argument to the > allocator is garbage. > > What MySQL version you are runn

Re: Working libmysqld.a for Tru64 5.1?

2002-06-15 Thread Dan Nelson
In the last episode (Jun 15), Randall Severy said: > To anyone who can help, > Does anyone have a working libmysqld.a library (with the > net_clear define patch in net_serv.cc) compiled on a Compaq Tru64 5.1 > (or compatible) system? I've been trying to build one for a week on > one of Compa

How can I install MySQL client only!

2002-06-15 Thread JamesWang Home
Hi, I have a question. I can install MySQL server on machine A. I am trying to install client on machine B only by select "customer" install and click "next" button. But I cannot deselect MySQL server. It is always checked and disabled. Does that mean I have to install MySQL server on machine B

Working libmysqld.a for Tru64 5.1?

2002-06-15 Thread Randall Severy
To anyone who can help, Does anyone have a working libmysqld.a library (with the net_clear define patch in net_serv.cc) compiled on a Compaq Tru64 5.1 (or compatible) system? I've been trying to build one for a week on one of Compaq's TestDrive servers and I just can't get a working lib

Problem with load data infile and user's privileges

2002-06-15 Thread Sergey Bondar
OS Linux Red Hat 7.2 MySql 3.23.41 Hi All! That is my steps. With root privileges I doing: GRANT ALL ON mydb.* TO client@localhost identified by "pwd"; I got: OK With client privileges !!! I doing: mysql -u client -p passwd CREATE DATABASE mydb; I got: OK CREATE TABLE mytable ( col01 CHAR(

Demande d'inscription à mysql-france

2002-06-15 Thread Notification de Yahoo! Groupes
Bonjour, Vous avez récemment demandé à vous inscrire au groupe mysql-france. Comme vous êtes déjà membre de ce groupe, votre demande ne sera pas prise en compte. Pour toute question sur l'envoi de messages à ce groupe, veuillez envoyer un e-mail à [EMAIL PROTECTED] Cordialement, L'équipe

Re: innodb keeps crashing due to out-of-memory errors.

2002-06-15 Thread Heikki Tuuri
Per, - Original Message - From: "Per Andreas Buer" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Saturday, June 15, 2002 11:40 PM Subject: Re: innodb keeps crashing due to out-of-memory errors. > > Hi Heikki, thanks for replying so swiftly. > > "Heikki Tuuri" <[EMAIL PROT

fishcart on win98

2002-06-15 Thread savaidis
Hello! Does anyone know how to install the "fishcart" - using My-SQL- on win98 or help me anyway on this? It's really important! Thanks Makis Savaidis - Before posting, please check: http://www.mysql.com/manual.php (th

Re: The report

2002-06-15 Thread Sinisa Milivojevic
Egor Egorov writes: > > Zdravo! > > Hi, > > I'm trying to make use of the new(ish) merge table > type, and am running into two problems. The first is > unexpected behaviour, the second is a straight MySQL > server crash. I have tested 3.23.47, 3.23.49 and > 3.23.51 with similar results. Details

increase mysql max connections over 1024

2002-06-15 Thread Patrick Hsieh
Hello list, I'd like to increase the number of max connections above 1024 in Linux. I think I have to increase PTHREAD_THREADS_MAX in /usr/include/bits/local_lim.h /* The number of threads per process. */ #define _POSIX_THREAD_THREADS_MAX 64 /* This is the value this implementation s

MySQL 4.0.1 & SSL config - a shot in the dark

2002-06-15 Thread Clay Loveless
I've been trying to figure out how to set up SSL support in mysql-4.0.1 ... The online documentation is pretty sparse on the subject. Here's what I've got so far -- and so far this is *NOT* working. I'm putting it out here so that someone else may be able to fiddle around on their end and help fi

MS Access forms and auto numbers

2002-06-15 Thread Alexander Shaw
Hi, I'm trying to upsize an application to MS Access front-end and a MySQL backend. The problem I'm encountering is that some of the data written from a bound form depends on an auto-number field, which in the case of MySQL isn't updated from Null until the record is written by moving onto the ne