Re: need help to uninstall mysql

2001-09-18 Thread Dana Powers
that hard to fix ). The log is probably /var/lib/mysql/hostname.err , but Im not familiar with redhat so that is just a guess. dpk - Original Message - From: GUYOT Carole [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 18, 2001 6:21 AM Subject: need help to uninstall mysql I've

Re: need help with select statements

2001-08-30 Thread Ian Barwick
On Thursday 30 August 2001 15:28, Andre Konopka wrote: Hi, I have, three tables (one,two, three) with the rows id/value. id is the key for all the tables. with select value from one where id=xx; select value from two where id=xx; select value from three where id=xx; I can select

mysql BLOB field -- need help

2001-08-29 Thread Zhenjiang Guo
I'm exhausted by the BLOB field in MySQL. I cann't get the content of the BLOB field. Is there anyone who will kindly point out the correct direction for me? A piece of code will be especially appreciated. I'm using VC and ADO. Thanks.

Re: mysql BLOB field -- need help

2001-08-29 Thread Carl Troein
On 29-Aug-01, Zhenjiang Guo wrote: I'm exhausted by the BLOB field in MySQL. I cann't get the content of the BLOB field. Is there anyone who will kindly point out the correct direction for me? A piece of code will be especially appreciated. I'm using VC and ADO. Thanks. As far as I know

Re: mysql BLOB field -- need help

2001-08-29 Thread Zhenjiang Guo
Yes, I tried a TEXT field. Error occurs when calling Recordset-Fields-GetItem(0L)-AppendChunk(lSize). But the same code runs well when I changed to an Access table. Thanks On Wed, 29 Aug 2001 10:18:54 +0200 Carl Troein [EMAIL PROTECTED] wrote: As far as I know a BLOB is just a TEXT with

Re: Need Help Setting Up MySQL on Win98

2001-08-28 Thread Grigory Bakunov
Date |Mon, 27 Aug 2001 12:54:25 -0700 (PDT) From |S K Bryan [EMAIL PROTECTED] Hello! SKB Hello - SKB I'm very new at this, so please pardon the very beginner questions... SKB I'm attemtping to install MySQL to my local machine running Win98. The SKB install seems to go alright, but when I try

Need Help Setting Up MySQL on Win98

2001-08-27 Thread S K Bryan
Hello - I'm very new at this, so please pardon the very beginner questions... I'm attemtping to install MySQL to my local machine running Win98. The install seems to go alright, but when I try mysqld--standalone it gives me an error. Then I tried mysqld -standalone, which seemed to work. Then

Re: Need Help Setting Up MySQL on Win98

2001-08-27 Thread John Meyer
At 12:54 PM 8/27/01 -0700, you wrote: Hello - I'm very new at this, so please pardon the very beginner questions... I'm attemtping to install MySQL to my local machine running Win98. The install seems to go alright, but when I try mysqld--standalone it gives me an error. Then I tried mysqld

Re: Need Help Setting Up MySQL on Win98

2001-08-27 Thread Gerald R. Jensen
Try putting a space between mysqld and --standalone (mysqld --standalone) - Original Message - From: S K Bryan [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Monday, August 27, 2001 2:54 PM Subject: Need Help Setting Up MySQL on Win98 Hello - I'm very new at this, so please

MySQL dump 8.9 and telephone field - need help

2001-08-20 Thread Jean Lambert
MySQL dump 8.9 is doing weird things on me, I wonder what's going on. I have the following SQL column type : com_tel_fax_cr char(3), com_tel_fax_no varchar(8), the com_tel_fax_no is for storing an seven-digit phone number and the '-', ie: 727-1163 When the data is dumped, all char and varchar

need help

2001-08-19 Thread qball cow
I have made a mysql server on my linux box. and via Myobdc I access it from a C++ programm I made.. I can see the records.. but If I change one.. I get the error: No Cursor name availible I dont know if it is in my program or some premission I set wrong in mysql.. If anybody can help me

RE: need help

2001-08-19 Thread Venu
Hi !! )-Original Message- )From: qball cow [mailto:[EMAIL PROTECTED]] )Sent: Sunday, August 19, 2001 10:50 AM )To: [EMAIL PROTECTED] )Subject: Fw: need help ) ) )I have made a mysql server on my linux box. and via Myobdc I )access it from a C++ programm I made.. I can see the records

Need help: workaround for sub-selects?

2001-08-06 Thread Erlend Stromsvik
(sorry for the double-post, but I had wrong subcect on the previous one) Hi I having a little trouble with mysql, with the lack of sub-selects. Yes, I have read about joins, both the manual and from the MySQL book by Paul Dubois, but none of those provide any 'real' info about what to do.

Re: Newbie need help on MySQL on RH 7.1

2001-08-02 Thread Mario Witte
On Wed, Aug 01, 2001 at 08:19:45PM -0400, Stonix wrote: Hi, I installed a RH 7.1, and I installed all the packages for apache, php and mysql. I don't know how to check if mysql server is running. On my machine cannot connect to mysql server. Hi, try executing the following command: ps

Re: Newbie need help on MySQL on RH 7.1

2001-08-02 Thread Grigory Bakunov
Date |Wed, 1 Aug 2001 20:19:45 -0400 From |Stonix [EMAIL PROTECTED] Hello! S Hi, S I installed a RH 7.1, and I installed all the packages for S apache, php and mysql. I don't know how to check if mysql S server is running. On my machine cannot connect to mysql S server. S Thanks in advance

Newbie need help on MySQL on RH 7.1

2001-08-01 Thread Stonix
Hi, I installed a RH 7.1, and I installed all the packages for apache, php and mysql. I don't know how to check if mysql server is running. On my machine cannot connect to mysql server. Thanks in advance for all advices if can help me out! Regards, Alex shi

I need help constructing a regexp

2001-07-27 Thread Mark Worsdall
In message [EMAIL PROTECTED], Mark Worsdall [EMAIL PROTECTED] writes Hi all, I have a problem, I have some VARCHAR data in a column called Sequence looking like this:- 5;6 12;6 120;6 5;6;1 12;6;12 120;6;105 So there could be anything from 2 to n numbers seperated by ; Each number could be 1

Re: I need help constructing a search thingy using % _ in LIKE

2001-07-27 Thread tj marlin
yes, but then you wouldn't learn. if you don't want to buy Dubois' book, try appendix J of the mySql reference manual, available for free from the mysql site. At 06:06 PM 7/26/01 +0100, you wrote: In message [EMAIL PROTECTED], tj marlin [EMAIL PROTECTED] writes I think it is time for you to

I need help constructing a search thingy using % _ in LIKE

2001-07-25 Thread Mark Worsdall
Hi all, I have a problem, I have some VARCHAR data in a column called Sequence looking like this:- 5;6 12;6 120;6 5;6;1 12;6;12 120;6;105 So there could be anything from 2 to n numbers seperated by ; Each number could be 1 to 3 digits long (eg 5 12 or 121). I have tried various searches like

Can someone explain this? I need help!

2001-07-17 Thread Bryan Coon
Hi, I am experiencing some really bizzare behaviour in MySQL v3.23.36... I have a perl script that takes some html form based user input, parses it into an array and then loops throught the array inserting each element into a table. This table is then left outer joined with others for a quick

Re: Can someone explain this? I need help!

2001-07-17 Thread Paul DuBois
At 4:58 PM -0700 7/17/01, Bryan Coon wrote: Hi, I am experiencing some really bizzare behaviour in MySQL v3.23.36... I have a perl script that takes some html form based user input, parses it into an array and then loops throught the array inserting each element into a table. This table is then

Need help with mysql

2001-06-16 Thread Malkhaz Mangoshvili
Hello. I installed on my computer Red Hat Linux 7.0. After that I started configuring mysql. I upgraded mysql, added all necessary packages and I wanted to run mysql server. Whenever I type mysql it gives me such an error message: ERROR 2002: Can't connect to MYSQL server through socket

Re: Need help with mysql

2001-06-16 Thread Trond Eivind Glomsrød
Malkhaz Mangoshvili [EMAIL PROTECTED] writes: Hello. I installed on my computer Red Hat Linux 7.0. After that I started configuring mysql. I upgraded mysql, added all necessary packages and I wanted to run mysql server. Whenever I type mysql it gives me such an error message: ERROR

Re: Need help with mysql

2001-06-16 Thread Paul DuBois
At 6:23 PM -0400 6/16/01, Malkhaz Mangoshvili wrote: Hello. I installed on my computer Red Hat Linux 7.0. After that I started configuring mysql. I upgraded mysql, added all necessary packages and I wanted to run mysql server. Are you using RedHat's MySQL RPMs? If so, you should uninstall

i need help completing install of newest version

2001-06-13 Thread Andrew Hook
so i'm trying to install mysql 3.23.38 on slackware linux, kernel 2.0.27 i'm installing from a tar.gz and have no previous mysql on this server. so i'm ok to scripts/mysql_install_db.sh then i get the following 3 lines scripts/mysql_install_db.sh: my_print_defaults: command not found didn't

RE: Need help on mysql/php

2001-06-07 Thread Adrian D'Costa
it can display. -Original Message- From: Neil Zanella [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 12:09 PM To: Don Read Cc: Ed Peddycoart; Mysql@Lists. Mysql. Com; Jorge Oliveira Subject: RE: Need help on mysql/php On Tue, 5 Jun 2001, Don Read wrote

RE: Need help on mysql/php

2001-06-07 Thread Paul DuBois
At 2:13 PM +0530 6/7/01, Adrian D'Costa wrote: On Wed, 6 Jun 2001, Ian Ford wrote: Name your config file config.inc and if any of the below situations happen your password and username will not show up in plain text for the casual browser. (EXAMPLE: CONFIG.INC ?

RE: Need help on mysql/php

2001-06-06 Thread Sommai Fongnamthip
://www.webfroggie.com wap: http://www.webfroggie.com -Mensagem original- De: Ed Peddycoart [mailto:[EMAIL PROTECTED]] Enviada: Quarta-feira, 6 de Junho de 2001 0:29 Para: Jorge Oliveira; Mysql@Lists. Mysql. Com Assunto: RE: Need help on mysql/php Thanks...this helped...Just had success

need help with cross table update

2001-06-06 Thread Jaime Teng
Hi, I have two tables on mysql: Table1: class char(10) usernamechar(50) etc. etc.. Table2: class char(10) usernamechar(50) timeint unsigned etc.. Table2's class column is a new column addition and therefore does not have any values on it. I

need help for a simple request

2001-06-06 Thread alexandre Roussel
Hi, I have some problems with the following SQL request that I process with phpMyAdmin : select * from TABLE2 where FIELD not in (select FIELD from TABLE1); This request identify all records in TABLE2 which are not in TABLE1 (depending on value of FIELD). TABLE1 and TABLE2 have exactly the

Re: need help for a simple request

2001-06-06 Thread Rafal Jank
alexandre Roussel wrote: Hi, I have some problems with the following SQL request that I process with phpMyAdmin : select * from TABLE2 where FIELD not in (select FIELD from TABLE1); This request identify all records in TABLE2 which are not in TABLE1 (depending on value of FIELD).

Re: need help for a simple request

2001-06-06 Thread MikemickaloBlezien
On Wed, 6 Jun 2001 11:52:14 +0200, alexandre Roussel [EMAIL PROTECTED] wrote: subselects are not currently supported with MySQL. Hi, I have some problems with the following SQL request that I process with phpMyAdmin : select * from TABLE2 where FIELD not in (select FIELD from TABLE1); This

RE: Need help on mysql/php

2001-06-06 Thread Paul DuBois
@Lists. Mysql. Com Subject: RE: Need help on mysql/php At 10:37 PM +0100 6/5/01, Jorge Oliveira wrote: Hi again, You are right, your username and password will have to be on every PHP script that needs to use database. However, you don't have to be afraid because nobody can access the source

RE: Need help on mysql/php

2001-06-06 Thread Kenneth Kopelson
Actually you are only exposed if you have not set up Apache to run with virtual hosts. It is not difficult to configure Apache so that a person can only see the scripts that are in his/her directory, and is prevented from seeing or modifying the scripts in other peoples directories. Also,

RE: Need help on mysql/php

2001-06-06 Thread Neil Zanella
On Tue, 5 Jun 2001, Don Read wrote: Better yet, put the file outside the $DOCUMENT_ROOT, in case your server is poorly configured. include($DOCUMENT_ROOT/../config.php); This is a very good idea. One day if the system administrator decides to back up all the user data and upgrade the web

RE: Need help on mysql/php

2001-06-06 Thread Paul DuBois
At 10:35 AM -0700 6/6/01, Kenneth Kopelson wrote: Actually you are only exposed if you have not set up Apache to run with virtual hosts. It is not difficult to configure Apache so that a person can only see the scripts that are in his/her directory, and is prevented from seeing or modifying the

RE: Need help on mysql/php

2001-06-06 Thread Ian Ford
: RE: Need help on mysql/php On Tue, 5 Jun 2001, Don Read wrote: Better yet, put the file outside the $DOCUMENT_ROOT, in case your server is poorly configured. include($DOCUMENT_ROOT/../config.php); This is a very good idea. One day if the system administrator decides to back up all

RE: Need help on mysql/php

2001-06-06 Thread Neil Zanella
On Wed, 6 Jun 2001, Ian Ford wrote: Name your config file config.inc and if any of the below situations happen your password and username will not show up in plain text for the casual browser. (EXAMPLE: CONFIG.INC ? $DBname = 'test'; $DBuser =

Need help on mysql/php

2001-06-05 Thread Ed Peddycoart
I recently move my website to FastWebServers.com. MySQL and PHP is provided. I have a control panel which allows me to initialize MySQL for my use. The initialization creates a db, named celticblues_com (my domain is celticblues.com). So far, I have added a table to my database, and added the

RE: Need help on mysql/php

2001-06-05 Thread Jorge Oliveira
original- De: Ed Peddycoart [mailto:[EMAIL PROTECTED]] Enviada: Terça-feira, 5 de Junho de 2001 21:31 Para: [EMAIL PROTECTED] Assunto: Need help on mysql/php I recently move my website to FastWebServers.com. MySQL and PHP is provided. I have a control panel which allows me to initialize

Re: Need help on mysql/php

2001-06-05 Thread B. van Ouwerkerk
Great support.. Right.. take a look at www.devshed.com they've got a few nice tutorials.. if you plan to work a lot with MySQL you might want to buy the book called MySQL written by Paul DuBois or fill out the survey and hope you'll get one for free ;-).. Other interesting websites:

Re: Need help on mysql/php

2001-06-05 Thread Olexandr Vynnychenko
Hello Ed, Tuesday, June 05, 2001, 11:30:36 PM, you wrote: EP I recently move my website to FastWebServers.com. MySQL and PHP is EP provided. I have a control panel which allows me to initialize MySQL for my EP use. The initialization creates a db, named celticblues_com (my domain is EP

RE: Need help on mysql/php

2001-06-05 Thread Ed Peddycoart
To: Mysql@Lists. Mysql. Com Subject: RE: Need help on mysql/php Hi, Please refer to http://www.php.net/manual/en/ref.mysql.php Jorge Oliveira [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] © webfroggie.com - Recursos Online! web: http

RE: Need help on mysql/php

2001-06-05 Thread Jorge Oliveira
-Mensagem original- De: Ed Peddycoart [mailto:[EMAIL PROTECTED]] Enviada: Quarta-feira, 6 de Junho de 2001 0:29 Para: Jorge Oliveira; Mysql@Lists. Mysql. Com Assunto: RE: Need help on mysql/php Thanks...this helped...Just had success in connecting to the MySQL server and dumping the db contents

RE: Need help on mysql/php

2001-06-05 Thread Jorge Oliveira
- De: Ed Peddycoart [mailto:[EMAIL PROTECTED]] Enviada: Quarta-feira, 6 de Junho de 2001 0:49 Para: Jorge Oliveira Assunto: RE: Need help on mysql/php I assume that you mean that they cannot access the scripts if the extension of the file is .php3, but if I mix PHP within an HTML file, then all

RE: Need help on mysql/php

2001-06-05 Thread Don Read
On 05-Jun-01 Ed Peddycoart wrote: Thanks...this helped...Just had success in connecting to the MySQL server and dumping the db contents to the screenOne worrisome bit though...My username and password for connecting to the db on my host is my username and password for the web account.

RE: Need help on mysql/php

2001-06-05 Thread Paul DuBois
At 10:37 PM +0100 6/5/01, Jorge Oliveira wrote: Hi again, You are right, your username and password will have to be on every PHP script that needs to use database. However, you don't have to be afraid because nobody can access the source of your PHP scripts - unless they are a good hacker!

RE: Need help on mysql/php

2001-06-05 Thread Paul DuBois
At 7:42 PM -0500 6/5/01, Don Read wrote: On 05-Jun-01 Ed Peddycoart wrote: Thanks...this helped...Just had success in connecting to the MySQL server and dumping the db contents to the screenOne worrisome bit though...My username and password for connecting to the db on my host is my

Mysql difficult query. Need help!

2001-05-24 Thread Weevil
Hi. I'm having some problems with formulating a SELECT statement to do the following: I have a database with one column of names with certain tags bounded by square brackets, and a price column as well. The database looks something like this: ITEMPRICE Shirt

Re: Mysql difficult query. Need help!

2001-05-24 Thread Dennis Salguero
PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, May 24, 2001 4:19 PM Subject: Mysql difficult query. Need help! Hi. I'm having some problems with formulating a SELECT statement to do the following: I have a database with one column of names with certain tags bounded by square brackets

Need help with outer join...

2001-05-18 Thread David Jordan
Hello, all. Having a small problem with MySQL and need some expert help. Trying to do a left outer join on one table out of seven. As shown below the only table which may have no row would be the pnotes table. Also shown below is the results I am getting (*use a fixed font for proper

Re: need help

2001-05-17 Thread Peter L. Berghold
On Thu, May 17, 2001 at 06:36:23AM -0700, mansoor spake thusly: *] i m new to mysql, how i can convert a string 28-MAR-2001 to date *] In what language? -- -+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+ Peter L. Berghold[EMAIL PROTECTED]

RE: need help on replication

2001-05-10 Thread David Shields
Joe: AFAIR, as an ex NT4 sysadmin, system error 5 is access denied - you have a permissions problem somewhere. On NT4 these can be a swine to solve. Check out your NT system error logs as a starting point. HTH. David By the way, I once first tried to set up the slave on a NT machine. But

need help on replication

2001-05-09 Thread Joseph Chow
Hi, there, This is my first try on this mailing list. I am a new user of mysql and need some help about replication on mysql 3.23.36. I had followed the manual to set up master/slave server. At the beginning, they are connected perfectly. All the modifications (i.e. create databases, insert

Re: need help on replication

2001-05-09 Thread Jeremy Zawodny
On Wed, May 09, 2001 at 10:29:42AM -0600, Joseph Chow wrote: Hi, there, This is my first try on this mailing list. I am a new user of mysql and need some help about replication on mysql 3.23.36. I had followed the manual to set up master/slave server. At the beginning, they are

RE: need help on replication

2001-05-09 Thread Joseph Chow
Zawodny [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 10:33 AM To: Joseph Chow Cc: [EMAIL PROTECTED] Subject: Re: need help on replication On Wed, May 09, 2001 at 10:29:42AM -0600, Joseph Chow wrote: Hi, there, This is my first try on this mailing list. I am a new user of mysql

Re: need help on replication

2001-05-09 Thread Jeremy Zawodny
On Wed, May 09, 2001 at 11:18:14AM -0600, Joseph Chow wrote: Hi, Jeremy, It is very nice to talk to you. Thanks for your information. It's working now, but I did nothing but going over the procedure again. I may make some mistakes during my operations. But it is really a good idea to

need help

2001-05-07 Thread BENZ LEE
Hi,all How can I get rid of the lock on database? for I want to operate one database but two tables at same time, Thanks and best regards ~{B7B~B~FdP^T6Yb~} ~{Na=+IOOB6xGsKw~} - Before posting, please check:

Re: Need help with 23.36

2001-04-24 Thread New Style MySQL Personnel
mysql use lum Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in table 'users' Database changed mysql select * from users; ERROR 1017: Can't find file: './lum/users.frm' (errno: 13)

Re: Need help with 23.36

2001-04-24 Thread B. van Ouwerkerk
COuld try a mysqldump to backup and restore the tables on the new/other machine. This should get you past the problems you found earlier. Remember to add the propriate users to the new machine.. Bye, B. mysql use lum Reading table information for completion of table and column names You

Need help with 23.36

2001-04-23 Thread New Style MySQL Personnel
I copied my database files made with 23.29 to 23.26 and now I get this. I chowned mysql.mysql and chmoded 660. What's wrong? mysql use lumina; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any

Need help with 23.36

2001-04-23 Thread New Style MySQL Personnel
I copied my database files made with 23.29 to 23.26 and now I get this. I chowned mysql.mysql and chmoded 660. What's wrong? mysql use lumina; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any

Re: Need help with 23.36

2001-04-23 Thread B. van Ouwerkerk
I copied my database files made with 23.29 to 23.26 and now I get this. I chowned mysql.mysql and chmoded 660. What's wrong? Perhaps or.. the location of your database is different.. or.. you didn't copy everything.. including subdirectories. Solution: check the location and if you copied

I need help to instal mysql

2001-04-23 Thread Lana Conan
First of all sorry for my English, I hope it would be good enougth to be understood. I am trying to instal mysql on a digital unix os. First I had problem with the ./configure it prompted this message checking for cc++... no checking for cl... no checking whether the C++ compiler (gcc )

Re: Need help with 23.36

2001-04-23 Thread New Style MySQL Personnel
The location is good because I have some other databases created with 36 and they work fine. I copied ALL the database's files to /var/lib/mysql where the others are and I get this error. Any idea? On Mon, 23 Apr 2001, B. van Ouwerkerk wrote: I copied my database files made with 23.29 to

Need help with 23.36

2001-04-23 Thread New Style MySQL Personnel
Please anyone. I really need some ideas. I copied my database files made with 23.29 to 23.26 and now I get this. I chowned mysql.mysql and chmoded 660. The location of the databases is good because I have some other databases created with 36 and they work fine. I copied ALL the database's files

Re: Need help with 23.36

2001-04-23 Thread Gerald Clark
chown -R mysql /var/lib/mysql New Style MySQL Personnel wrote: The location is good because I have some other databases created with 36 and they work fine. I copied ALL the database's files to /var/lib/mysql where the others are and I get this error. Any idea? On Mon, 23 Apr 2001, B.

RE: Need help with 23.36

2001-04-23 Thread indrek siitan
Hi, mysql use lumina; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Didn't find any fields in table 'absences' Didn't find any fields in table 'admins' Didn't find any fields in table 'classes'

Re: I need help to instal mysql

2001-04-23 Thread Gerald Clark
Install gmake. Lana Conan wrote: First of all sorry for my English, I hope it would be good enougth to be understood. I am trying to instal mysql on a digital unix os. First I had problem with the ./configure it prompted this message checking for cc++... no checking for cl... no

RE: Need help with a Freebsd install..

2001-04-20 Thread Patrick Calkins
/(whatever.foo.bar.err) I hope this helps you out! Patrick # -Original Message- # From: Larry Caragay [mailto:[EMAIL PROTECTED]] # Sent: Wednesday, April 18, 2001 3:45 PM # To: [EMAIL PROTECTED] # Subject: Need help with a Freebsd install.. # # # Can any one help me install Mysql on my

Need help with a Freebsd install..

2001-04-18 Thread Larry Caragay
Can any one help me install Mysql on my Freebsd 4.2 box.. the first thing I did was: got a copy of Mysql for mysql.com placed in in the /usr/local then: gzip -dc mysql-3_23_36-unknown-freebsdelf4_2-i386_tar.gz | tar -vxf - created a mysql directory. /usr/local/mysql then ./configure

I need help with the mysql logs.

2001-04-10 Thread eran yahav
I need help with the mysql logs. I want the mysql to enter the time it takes each query to run as well in the log. also i want to know from which file / program each query was run. Is that possible ? if so how can i do it or where can i find more information. thanks eran

Need Help with RH 7.0 RPM install

2001-04-08 Thread Harry C. Marotto Jr.
I have not been able to figure this out, yet. I found the file /usr/share/mysql/make_binary_distribution and tried a make on it; no luck. I scoured the documentation on the web and in my own distribution and have not been able to find out what to do next. See Below. I would appreciate getting

Re: Need Help with RH 7.0 RPM install

2001-04-08 Thread Jens Vonderheide
I have not been able to figure this out, yet. I found the file /usr/share/mysql/make_binary_distribution and tried a make on it; no luck. I scoured the documentation on the web and in my own distribution and have not been able to find out what to do next. See Below. I would appreciate

BADLY NEED HELP

2001-03-24 Thread Nuno Ferreira
-rw-rw 1 mysqlmysql 100916 Mar 16 17:09 imp_addr.ISD -rw-rw 1 mysqlmysql1024 Mar 16 17:09 imp_addr.ISM -rw-rw 1 mysqlmysql8648 Mar 9 11:06 imp_addr.frm I've been reading all the archieve files about a error i get when trying to do

Re: Need help optimizing this (simple) query

2001-03-13 Thread Jordan Russell
Hi, Ok, I'm out of ideas. The additional index should have sped things up, not slowed them down. I've got some tables with 26,000 rows in it and I do 4 joins (using a WHERE clause) with smaller tables without a hitch. Sorry I can't help. But thanks a lot for trying. :) And thanks also to

Need help with mysql startup problem

2001-03-12 Thread Russ Heaton
I just installed RH 7.0 selecting the 'install everything' option. Now when I use safe_mysqld, it starts then ends immediately with the following message in the log. 010310 12:43:30 mysqld started 010310 12:43:30 Can't start server : Bind on unix socket: Permission denied 010310 12:43:30 Do

Need help optimizing this (simple) query

2001-03-12 Thread Jordan Russell
Hi everyone, I'm stuck on one issue which is preventing me from using MySQL in production on one particular database. (This is similar to my last post but this time I'll explain better what I'm attempting to do.) I'm trying to create a database of filenames and directories using MySQL. I have

Re: Need help optimizing this (simple) query

2001-03-12 Thread Gerald L. Clark
A .03 sec left join PREVENTS you from using MySQL. This must be a troll. You have no where clause, so no index is used. Jordan Russell wrote: Hi everyone, I'm stuck on one issue which is preventing me from using MySQL in production on one particular database. (This is similar to my last

Re: Need help optimizing this (simple) query

2001-03-12 Thread Jordan Russell
A .03 sec left join PREVENTS you from using MySQL. This must be a troll. Sigh... I guess I failed to mention this was a deliberately simplified example in order to pose my question in a easy-to-understand manner. In reality, there are much more records, and a more complex query, where the

Re: Need help optimizing this (simple) query

2001-03-12 Thread Jordan Russell
You have no where clause, so no index is used. Oops, missed this part. Where exactly do I need a WHERE clause, and for what? The first query doesn't have a WHERE clause and yet it appears to be using the "date" index. Jordan Russell

Re: Need help optimizing this (simple) query

2001-03-12 Thread Jordan Russell
Hi, Thanks for the reply. Hve you read http://www.mysql.com/documentation/mysql/bychapter/manual_Performance.html#L EFT_JOIN_optimization ? Yes, many times, as well as just about everything else in the Performance chapter. Am I missing something totally obvious? Should I even be using a LEFT

RE: Need help optimizing this (simple) query

2001-03-12 Thread Cal Evans
were your results? Cal http://www.calevans.com -Original Message- From: Jordan Russell [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 2:27 PM To: Cal Evans Cc: [EMAIL PROTECTED] Subject: Re: Need help optimizing this (simple) query Hi, Thanks for the reply. Hve you read http

Re: Need help optimizing this (simple) query

2001-03-12 Thread Jordan Russell
Everything I've seen on this list indicates that using LEFT JOIN negates using an index. (WARNING: This is 3rd hand info and as such should be viewed skeptically!) Have you tried: SELECT files.id, dirs.name FROM files where files.dir_id=dirs.id ORDER BY files.date DESC LIMIT 1; If so,

RE: Need help optimizing this (simple) query

2001-03-12 Thread Cal Evans
(dir_id), to the above. Cal http://www.calevans.com -Original Message- From: Jordan Russell [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 2:48 PM To: Cal Evans Cc: [EMAIL PROTECTED] Subject: Re: Need help optimizing this (simple) query Everything I've seen on this list indicates

Re: Need help optimizing this (simple) query

2001-03-12 Thread Steve Ruby
Jordan Russell wrote: Everything I've seen on this list indicates that using LEFT JOIN negates using an index. (WARNING: This is 3rd hand info and as such should be viewed skeptically!) Have you tried: SELECT files.id, dirs.name FROM files where files.dir_id=dirs.id ORDER BY

Re: Need help optimizing this (simple) query

2001-03-12 Thread Jordan Russell
/* This table has 5000 rows */ CREATE TABLE files ( id int(11) NOT NULL auto_increment, dir_id int(11) NOT NULL default '0', name varchar(100) NOT NULL default '', date datetime default NULL, PRIMARY KEY (id), KEY date (date) ) TYPE=MyISAM; for grins and giggles, add: key

RE: Need help optimizing this (simple) query

2001-03-12 Thread Cal Evans
Message- From: Jordan Russell [mailto:[EMAIL PROTECTED]] Sent: Monday, March 12, 2001 3:07 PM To: Steve Ruby Cc: Cal Evans; [EMAIL PROTECTED] Subject: Re: Need help optimizing this (simple) query Do you have an index on files that starts with dir_id and an index on dirs that stats with id

need help!

2001-03-10 Thread Kwame Gyang
I am a computer science student who has a project to in a few weeks. I have been trying to get my Java program make connections to mysql server running on my windows PC. I got the right drivers but I keep getting bad handshake error.. This is what I used String address =

Re: trying to install on RedHat 7.0 and need help

2001-03-07 Thread Gerald L. Clark
Go back to redhat.com and get the RPM that works, Or search the mysql list archives. This has been answered a hundred times ( No exageration. ) Charles L Hagen wrote: OK, here is the story. I have a PII Linux RedHat 7.0 server. I installed the Mysql package that comes with it and

Re: trying to install on RedHat 7.0 and need help

2001-03-06 Thread Irmund Thum
Charles L Hagen schrieb: mysqld dead but subsys locked it's successfully installed and running, but not really killed killall mysqld and start again you shouldn't post those long nonsense listings -- http://it97.dyn.dhs.org -- IrmundThum

trying to install on RedHat 7.0 and need help

2001-03-05 Thread Charles L. Hagen
I cannot seem to get this database program to work correctly. I am asking for any help I can get. I need to start this asap. Charles Hagen [EMAIL PROTECTED]

RE: trying to install on RedHat 7.0 and need help

2001-03-05 Thread Jon Haworth
is happening? Cheers Jon -Original Message- From: Charles L. Hagen [mailto:[EMAIL PROTECTED]] Sent: 04 March 2001 04:12 To: [EMAIL PROTECTED] Subject: trying to install on RedHat 7.0 and need help Importance: High I cannot seem to get this database program to work correctly. I am

Re: trying to install on RedHat 7.0 and need help

2001-03-05 Thread Hardy Merrill
Charles, you need to be more descriptive about exactly what problem you're having. Spell out your hardware, OS, MySQL version, etc., and describe what isn't working. Charles L. Hagen [[EMAIL PROTECTED]] wrote: I cannot seem to get this database program to work correctly. I am asking for any

Re: trying to install on RedHat 7.0 and need help

2001-03-05 Thread Charles L Hagen
OK, here is the story. I have a PII Linux RedHat 7.0 server. I installed the Mysql package that comes with it and also the dependent applications as specified. I try to start the mysqld and it gives me an OK and then I status it and it says mysqld dead but subsys locked I am asking

need help to set mysql up(error 105)

2001-02-27 Thread Nice Nick
Dear our mailing list friends, i am very new and i tried to install mysql to my computer(windows based ,i downloaded the software for windows ) but i failed. the error is: setup is unable to find installation languages in C:\PROGRA~1\ALZIP_HZTMP_\SETUP.LID file Error 105 i am looking for your

Need help with select statement.

2001-02-26 Thread David Jacobowitz
Dear Sir, I have looked in the manual but could not find any clue so I am seeking your assistance. I have a table with 25 fields and I use most of these fields but not all in different DBI scripts. Currently I use: SELECT field_1, field_4, ...getting tired typing field names... FROM myTest;

Re: Need help with select statement.

2001-02-26 Thread David Jacobowitz
Thanks Rolf From: "Rolf Hopkins" [EMAIL PROTECTED] To: "David Jacobowitz" [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Need help with select statement. Date: Tue, 27 Feb 2001 09:21:57 +0800 No it's not possible but you can just read in all tables anyway and ignore t

Two query issues -- need help

2001-02-20 Thread Matteo Dell'Orto
Hi all, I have two little problems: 1.In a query, I get errors when a record's field contains the ' character. In fact the query starts like ! sql query "insert into dbase values ('@qfield1', '@qfield2'...). 2.I need to split query results in multiple pages (e.g. with a next button) so that my

RE: Two query issues -- need help

2001-02-20 Thread Alan Halls
-- From: Matteo Dell'Orto [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 20, 2001 10:32 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Two query issues -- need help Hi all, I have two little problems: 1.In a query, I get errors when a record's field contains the ' character. In fact th

<    4   5   6   7   8   9   10   >