ssh connection between web server and mysql]

2001-04-11 Thread Leon Harris
Hi all. I have had a real nightmare with mysql and ssh, trying to get a tunnel going. I also have had similar probs with stunnel, but that is another post. I am running OpenSSH_2.5.2p2, SSH protocols 1.5/2.0, OpenSSL 0x0090581f as the ssh client on the web server and sshd version OpenSSH_2.5.1p

Need Coldfusion/MySQL developer

2001-04-11 Thread Maroa Gikuuri
We have an upcoming project that will require some Coldfusion/MySQL development. We are looking for an offsite developer. Initially we may need the developer to configure the server for Coldfusion (there is already some development that has been done). Then the developer will have to do an a

more on the install problem

2001-04-11 Thread Mike Millner
I've narrowed it down some. I'm not finding the answer in archives. From the manual I found these commands: shell> mysqladmin version shell> mysqladmin variables shell> mysqladmin -h `hostname` version variables shell> mysqladmin -h `hostname` --port=3306 version shell> mysqladmin -h 'ip for your

Client Install

2001-04-11 Thread Ken Cole
Hi, Further to my earlier e-mail about problems starting mysql, Rolf suggested installing the client software. Were as I had no problems with the server, I am having some dependancy problems with the client. It says I need: libc.so.6(GLIBC_2.0) libc.so.6(GLIBC_2.1) libpthread.so.0(GLIBC_2.0

Re: mysql uses 99% cpu under freebsd 4.3

2001-04-11 Thread Dan Nelson
In the last episode (Apr 11), Ken Menzel said: > The list reject my trace (it was too large), so here is a smaller > one! Stops after info from first top starts showing CPU usage of 99% > Ken > > Hi Tim, I just had it happen. Overall average 14 queries per second > on this machine. Single CP

Re: install problem

2001-04-11 Thread Rolf Hopkins
- Original Message - From: "Mike Millner" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 12, 2001 10:49 Subject: install problem > Hello, > I just installed mysql 3.23.36 on a Debian Potato system. I know your going > to tell me to read the manual. I have been and wil

just a question

2001-04-11 Thread pablo alonso
Using ver 8.18 dist 3.23.36 on win98se. It unzipped just fine, installed and starts mysqld-opt in the background at startup. The nice GUI is a green traffic light in the system tray, but it frequently disappears, and seems to hang if I attempt to restart it. I don't know how to restart it, a

install problem

2001-04-11 Thread Mike Millner
Hello, I just installed mysql 3.23.36 on a Debian Potato system. I know your going to tell me to read the manual. I have been and will continue. Any help would be greatly appreciated. Thanks, Mike I have (at least) two problems When I do a ps-ef | grep mysqld: root 19004 25880 0 20:04 pts

Re: Newbie Install Questions

2001-04-11 Thread Ken Cole
Rolf, > > Just downloaded and installed MySQL-3.23.36-1.i386.rpm > > from ftp.mysql.com. I am running a RH 5.2 server. > > > > 1. Is this the correct version from my OS? > > I don't see a great problem with that but have you thought > about upgrading to RH 7.0. > It is a matter of proving to

Re: Newbie Install Questions

2001-04-11 Thread Rolf Hopkins
- Original Message - From: "Ken Cole" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 12, 2001 9:50 Subject: Newbie Install Questions > Hi, > > Just downloaded and installed MySQL-3.23.36-1.i386.rpm from > ftp.mysql.com. I am running a RH 5.2 server. > > 1. Is this th

Re: MySQL and PHP issue

2001-04-11 Thread Rolf Hopkins
This doesn't look easy and I don't have time to sit down and think about it but I'll give a couple of suggestions. 1. An ORDER BY clause may help. When you go through the list, you will then need to detect a change in "menu level". 2. Why do the menu items need to be in a database anyway? Just

Re: I Need your help

2001-04-11 Thread Rolf Hopkins
And since when was INTERSECT/UNION able to be done in MySQL? As far as I am aware, it is yet to be implemented. - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 11, 2001 23:16 Subject: I Need your help > Good morning, > Please, > I use MySql

Re: getting ip of mysql server

2001-04-11 Thread Rolf Hopkins
May I ask as to what purpose you need to do this?Have you looked at nslookup? - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 12, 2001 5:03 Subject: getting ip of mysql server > Hi there, > > I'm wondering if there's a way to findout the

Re: Cannot launch Mysql

2001-04-11 Thread Rolf Hopkins
Check that socket exists, the path is correct, permissions are correct and read the archive list as mentioned at the bottom of this e-mail. This is an FAQ. - Original Message - From: "RIDLEY, JAMES A. (AIT)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 12, 2001 4:52

Newbie Install Questions

2001-04-11 Thread Ken Cole
Hi, Just downloaded and installed MySQL-3.23.36-1.i386.rpm from ftp.mysql.com. I am running a RH 5.2 server. 1. Is this the correct version from my OS? 2. The install, rpm -i MySQL-3.23.36-1.i386.rpm, seemed to go ok. Got two warnings: setrlimit couldn't increase number of open files to mo

Re: unusable mysqlshow and mysqldum under 3.23.36

2001-04-11 Thread Rolf Hopkins
Without seeing the actual command you are using, the best I can do is guess. Perhaps you're not using password, specifying a user or maybe your database is empty. However, this is probably not the case as you should have gotten other errors. Have you tried a sanity check on the database? -

Fix for all ODBC users wanting BOOL fields

2001-04-11 Thread Eric Fitzgerald
I sent this to the MyODBC list also, but I know that very few people watch that list. So I'm posting here as well: I have edited the MyODBC source to do a translation of TINYINT fields to BOOL fields. I have tested these thoroughly with Visual Fox Pro, and they work as logical fields, including

MySQL and PHP issue

2001-04-11 Thread David
I tried posting this in the PHP newsgroup but received no response so thought I would try here since issue involves MySQL I am trying to make a simple HTML menu system with data stored in a MySQL database.. I am having problems displaying menu links under the correct submenu from a loop. I have

Re: the quick and the dead...

2001-04-11 Thread Heath Boutwell
Thanks for the information below. Also, according to the article here: http://www.webtechniques.com/archives/2001/05/hong/ The wildly popular amihotornot.com has served over 17.5 million page views in one month using mySQL exclusively. I don't know how extensively Yahoo Finance uses mySQL in th

Re: Need: DB Link from Oracle to MySQL

2001-04-11 Thread Tim Bunce
On Wed, Apr 11, 2001 at 06:14:51PM -0500, pmetha wrote: > Hello all: > > I need to create a db link type structure within Oracle 817 EE > to connect to MySQL so that I can read mySQL tables. > > Can any kind person point me in the direction of how to do this > if it is possible at all. We're ex

Re: mysql uses 99% cpu under freebsd 4.3

2001-04-11 Thread Tim Bunce
On Wed, Apr 11, 2001 at 12:33:44PM -0400, Ken Menzel wrote: > The list reject my trace (it was too large), so here is a smaller > one! Stops after info from first top starts showing CPU usage of 99% > Ken > > Hi Tim, I just had it happen. Overall average 14 queries per second > on this machin

Re: mysql uses 99% cpu under freebsd 4.3

2001-04-11 Thread Tim Bunce
I suspect the point is that many more threads simply makes the problem appear more often and thus be reproducible and thus more easily fixed. Tim. On Wed, Apr 11, 2001 at 04:49:19PM +0200, Lars Andersson wrote: > My 4.2 STABLE dosent get so many queries, according to mysqladmin (Queries > per se

RE: Perl MySQL Interface

2001-04-11 Thread Chris Becker
go to perl.com - click CPAN and look for DBI and DBD, and look for docs on how to install a perl module. You need to install DBI first, then DBD... hope this helps. Chris Becker MCSE MCDBA === Idysys http://www.idysys.com [EMAIL PROTECTED] === -Orig

Need: DB Link from Oracle to MySQL

2001-04-11 Thread pmetha
Hello all: I need to create a db link type structure within Oracle 817 EE to connect to MySQL so that I can read mySQL tables. Can any kind person point me in the direction of how to do this if it is possible at all. PM.

Perl MySQL Interface

2001-04-11 Thread Brian Cassidy
I have installed MySQL 3.23 on RedHat 7 using the rpms. Installing the bench rpm gives "MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.36-1". I can't seem to locate any version of this dbi which will install. I see that mysql.com has a perl dbd module for MySQL but that is not an rpm. Is that wh

Re: Having a big problem in libmysqlclient.a with apache and php

2001-04-11 Thread Joe Canon
> From: Mohamed Ould <[EMAIL PROTECTED]> > To: Mohamed Ould <[EMAIL PROTECTED]>, > [EMAIL PROTECTED] > Date: Wed, 11 Apr 2001 14:25:01 +0200 > Subject: Re: Having a big problem in libmysqlclient.a with apache and php > > > No body which is able to tell me what to do with th

Re: JDBC driver

2001-04-11 Thread Chris Worth
read the docs that come with it. it is ALL explained in there. RTFM... is the best thing. On Wed, 11 Apr 2001 10:39:32 -0700 (PDT), Leon Zilber wrote: >I got very useful help. Thanks. > >But now, I am facing another Java -> JDBC problem. > >I have successfully downloaded mm.mysql-2.0.4-bin.

Perl DBD Errors???

2001-04-11 Thread Chris Becker
I installed DBI just fine, now I'm installing DBD and am getting the following error message from 'make test'. Can anyone translate??? [root@clx Msql-Mysql-modules-1.2210]# make test make[1]: Entering directory `/perlmods/Msql-Mysql-modules-1.2210/mysql' make[1]: Leaving directory `/perlmods/M

MyODBC, NT 4.0 WS, and Access 2000

2001-04-11 Thread Fenn Rider
I am trying to get myODBC working on an NT 4.0 ws, sp6a client, connecting to a MySQL db running on a linux box. When I try to connect, I get a dialoge that says: ODBC -- call failed. [TCX][MyODBC]Host '' is not allowed to connect to this MySQL server (#1130). I have set up the host and user in

help porting data to a mirror....

2001-04-11 Thread William Eisner
The issue is that the mirror must be Microsoft SQL and our DB is on mySQL. If you can recommend a way to do this efficiently or some one who dose this well I would greatly appreciate your efforts. Thank you for your time and efforts, William Eisner Jr. Consultant / Web Developer Psimatrix Inter

getting ip of mysql server

2001-04-11 Thread dempsejn
Hi there, I'm wondering if there's a way to findout the IP of the server that MySQL is running on, once logged into MySQL. I know this may seem simple, but I'm looking for something beyond ping somehost.com Is there someway to get the ip needed to connect to a mysql database remotely from MySQL

Cannot launch Mysql

2001-04-11 Thread RIDLEY, JAMES A. (AIT)
I am having trouble launching MySql on a IBM AIX Unix platform. I type the mysql command at the prompt and this is the error message I get back: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) What am I missing or what can I do to correct this problem. Plea

Re: Need it ASAP

2001-04-11 Thread phobo
for 'asap' things like this, go use a chatroom / IRC type scenario. Or look up What you're asking has NOTHING to do with databases. siggy - Original Message - From: "Mike Roberts" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 12, 2001 6:49 AM Subject: Need it ASAP

unusable mysqlshow and mysqldum under 3.23.36

2001-04-11 Thread Martin Bringe
Hi, we compile and install from tarball source mysql 3.23.36. mysql-server seems to work but if I try mysqldump or mysqlshow, I only get version banner from mysqld. mysqldump is important for dayly saving the database on tape, so we can't live withoit it. Strange behavour: If I use a wrong db-name

Replication Bug Across Databases

2001-04-11 Thread jlhaase
>Description: When setting replication to only replicate one database between servers via the binlog-do-db option in my.cnf, it is possible to miss updates on the master server, or to replicate updates on databases other than the one specified. All updates are logged to the binary log an

Re: [MySQL] Backwards Compatible?

2001-04-11 Thread Gerald Clark
Read the CHANGES section of the manual. Make sure you use only ISAM type files. 3.23 uses MYISAM by default. Tim Thorburn wrote: > > Hello, > > Is MySQL backwards compatible? On my main machine I'm running MySQL > 3.23.36 and our hosting company is using MySQL 3.22.32 - the database I've > c

Re: Need it ASAP

2001-04-11 Thread Gerald Clark
Mike Roberts wrote: > > Hey all! What does this have to do with MySQL? > What I am trying to do is get a form to recognize when the user hits > enter. > If > This > Was > My > Description > It would show up like this > "if this was my description" > I have tried different wraps (Virtual, Physica

Re: MySQL Newbie install question

2001-04-11 Thread Gerald Clark
TCPwrappers has nothing to do with mysql. Mysqld manages the port itself. You do not want tcpwrappers grabbing the port. Check the path to mysql.sock. It must be world searchable and readable for the client to write to the socket. Read the section of the manual on GRANT privileges. You are not r

Re: Need it ASAP

2001-04-11 Thread Christopher R. Jones
Way off topic! But just so you know, you can't use a TEXT input field, you must use a TEXTAREA field: Testing >Hey all! >What I am trying to do is get a form to recognize when the user hits >enter. >If >This >Was >My >Description >It would show up like this >"if this was my description" >I hav

[MySQL] Backwards Compatible?

2001-04-11 Thread Tim Thorburn
Hello, Is MySQL backwards compatible? On my main machine I'm running MySQL 3.23.36 and our hosting company is using MySQL 3.22.32 - the database I've created is a simple listing of local businesses with contact information, so I don't believe there would be any issues of my using features tha

Re: Millenium

2001-04-11 Thread René Tegel
although it somehow _is_ possible (even documented but i don't know where, registry settings should do) to run services on win 9x, like virus scan and other stuff... if someone knows details :) - Original Message - From: "Dan Harrington" <[EMAIL PROTECTED]> To: "Sylvain Besson" <[EMAIL PR

Re: the quick and the dead...

2001-04-11 Thread Tom Kleinpeter
This is not done with a RDBMS. I don't think any commercial, general purpose database is designed to search over a billion documents at that speed. Text search engines like Google and Altavista are designed with a lot of different goals. A good book on the subject is "Managing Gigabytes" by

Yahoo! Auto Response

2001-04-11 Thread jitenderjoshi
I recevied your mail thanx Jitender Joshi Original Message: X-Track: 4: 40 Received: from web.mysql.com (192.58.197.162) by mta427.mail.yahoo.com with SMTP; 11 Apr 2001 11:57:12 -0700 (PDT) Received: (qmail 30477 invoked by uid 7797); 11 Apr 2001 17:56:42 - Mailin

MySQL Newbie install question

2001-04-11 Thread Damian Moran
Hi I downloaded and installed the latest i386 RPM from MySql.com on a RH7 box. When I try to contact the mysql server i get the following error: [someone@somemachine ~]$ mysqladmin ping mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket

Can't install xbsql-o.1.tgz

2001-04-11 Thread Xosé
From: Xosé <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: 2001-04-11 20:36 Groups: [EMAIL PROTECTED] no references SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-P

Re: the quick and the dead...

2001-04-11 Thread Steve Werby
"Basil Hussain" <[EMAIL PROTECTED]> wrote: > Anyway, 405 queries per second is not so much if you have monster hardware. > I seem to remember one of the MySQL developers mentioning one time that they > had benchmarked a MySQL server at over 1,000 queries/sec. Though a MySQL benchmark may have ach

RE: Millenium

2001-04-11 Thread Dan Harrington
Windows Millenium editon is not made to be a server. Regardless of whether or not it will run, I wouldn't do it if I were you. Go to Win2K pro if you must be on a windows box, but Win ME will only cause you needless pain. my 2cents :-) > -Original Message- > From: Sylvain Besson [mail

Need it ASAP

2001-04-11 Thread Mike Roberts
Hey all! What I am trying to do is get a form to recognize when the user hits enter. If This Was My Description It would show up like this "if this was my description" I have tried different wraps (Virtual, Physical, Soft, Hard) for the text field, but it doesn't work! I want it in my database, k

Re: mysql uses 99% cpu under freebsd 4.3

2001-04-11 Thread Jeremy Zawodny
On Wed, Apr 11, 2001 at 04:58:49PM +0300, Sinisa Milivojevic wrote: > > This seems to be a problem with threads on FreeBSD, although on > which side, yet remains to be seen. > > It seems to appear that it is surfacing not just under heavy load, > but when there are many threads running. Many mea

MySQL Newbie install question

2001-04-11 Thread Damian Moran
Hi I downloaded and installed the latest i386 RPM from MySql.com on a RH7 box. When I try to contact the mysql server i get the following error: [someone@somemachine ~]$ mysqladmin ping mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket

Re: how to escape french characters

2001-04-11 Thread Ken Menzel
You should not need to escape french characters. Try this test script: Just use 'cut and paste' to paste eash line into the command line interface and you will see it works fine. use test; create table français ( id int unsigned auto_increment primary key, text char(60) ); insert français (text

ODP: Unix server/Windows client

2001-04-11 Thread Daniel £aœ
Hi Yes of course. If you use Delphi find zeos component, else use libmysql.dll or libmysql.lib and mysql.h included in Win32 binaries. > -Oryginalna wiadomoœæ- > Od: Gerald R. Jensen [mailto:[EMAIL PROTECTED]] > Wys³ano: 11 kwietnia 2001 03:24 > Do: [EMAIL PROTECTED]; [EMAIL PROTECTED] >

JDBC driver

2001-04-11 Thread Leon Zilber
I got very useful help. Thanks. But now, I am facing another Java -> JDBC problem. I have successfully downloaded mm.mysql-2.0.4-bin.jar driver, but I am not sure how to use this in my Java application. How should I register my application with the DB? Class.forName("???"); Thanks, Leon ___

ODP: MYSQL API for C

2001-04-11 Thread Daniel £aœ
Hi You don't have to do anything. Regards Daniel Las > -Oryginalna wiadomoœæ- > Od: VVM Ravikumar Sarma Chengalvala [mailto:[EMAIL PROTECTED]] > Wys³ano: 11 kwietnia 2001 17:09 > Do: [EMAIL PROTECTED] > Temat: MYSQL API for C > > > I am using MYSQLAPI for C in my C++ program.WHat are > a

Re: the quick and the dead...

2001-04-11 Thread Basil Hussain
Hi, > 35 Million keyword searches a day are done at the > Goolge site. > > My calculator tells me this is roughly 405 keyword > searches per SECOND. > > Not even considering any other database queries needed > to generate targeted ad placement on each page, etc > one is left with a haunting que

Re: the quick and the dead...

2001-04-11 Thread Steve Werby
"Heath Boutwell" <[EMAIL PROTECTED]> wrote: > According to a recent story: > http://news.cnet.com/news/0-1005-200-5561996.html?tag=tp_pr > > 35 Million keyword searches a day are done at the > Goolge site. > > My calculator tells me this is roughly 405 keyword > searches per SECOND. > > Not even c

Big performance drop with a _lot_ of tables

2001-04-11 Thread Antti Kaipila
I have a big performance problem with a database that has > 600 tables in it. I have read trough the manual and tried tuning different variables, like table_cache and so on, with no real solution to the problem. It's not really possible to split the data to different databases at this point so I

Job Opening in Brazil

2001-04-11 Thread Leonardo Dias
Hi, there. We're looking for advanced PHP programmers to Work in Brazil. Catho Online is the biggest job website in Brazil and possibly in Latin America. We're looking for someone who's already experienced and willing to learn even more with us. The salary is 3000 reais (aproximately 1500 dollar

RE: Mysql and Perl DBI

2001-04-11 Thread Scott Baker
I highly recommend a source installation for everyone anyway. The RPMs are problematic to say the least. The source install is easy anyway. At 09:21 AM 4/11/2001 -0700, Eric Fegraus wrote: >The redhat 7 mysql version doesn't work correctly...i.e. the mysql.h is >missing. The solution is to re

Re: how to escape french characters

2001-04-11 Thread Kip Turk
On Wed, 11 Apr 2001, christopher sagayam wrote: > First of all how to find out a special french character using perl and then how to >escape it ? While this is pretty much off topic for mysql, I'll respond and add the magic words to get my post through. $something1 =~ s/[list of french charact

RE - MYSQL recovery/reliability under powerfail conditions

2001-04-11 Thread Burkies, Norman
Hi We are evaluating various RDBMS for use on within an airborne server (Embedded NT4.0) environment. This environment does not have reliable power. Aircraft are powered cycled without regard for delicate OS environments etc. We like MySql because it is fairly lightweight (regards processor/mem

Re: how to escape french characters

2001-04-11 Thread Scott Baker
There is a function in the dbi called quote... $dbh->quote($somethign1); Look it up: http://ep33.tp4.ruhr-uni-bochum.de/mlists/MySQL/May.2000/3018.html At 09:45 PM 4/11/2001 +0530, christopher sagayam wrote: >im using a INSERT into tablename values ('$something1' , '$something2') > >now if $so

mysql uses 99% cpu under freebsd 4.3

2001-04-11 Thread Ken Menzel
The list reject my trace (it was too large), so here is a smaller one! Stops after info from first top starts showing CPU usage of 99% Ken Hi Tim, I just had it happen. Overall average 14 queries per second on this machine. Single CPU Kernel Dell 2400 600MHZ FreeBSD-stable from January. Al

the quick and the dead...

2001-04-11 Thread Heath Boutwell
Since mySQL is one the fastest RDBMS in the world for pure SELECTs, this seems like the proper forum to pose the following: According to a recent story: http://news.cnet.com/news/0-1005-200-5561996.html?tag=tp_pr 35 Million keyword searches a day are done at the Goolge site. My calculator tell

RE: Mysql and Perl DBI

2001-04-11 Thread Eric Fegraus
The redhat 7 mysql version doesn't work correctly...i.e. the mysql.h is missing. The solution is to re-install with the a tarball from the mysql site.. :( eric -Original Message- From: Gordon Stewart [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 11, 2001 5:29 AM To: [EMAIL PROTECT

PATCH2: REGEXP in select only works with short expressions on Alpha

2001-04-11 Thread Michael Widenius
> "Stephen" == Stephen Beynon <[EMAIL PROTECTED]> writes: Stephen> On Tue, 10 Apr 2001, Michael Widenius wrote: Stephen> Thankyou for the patch - it certainly improves the situation (and fixes Stephen> the test case I gave) but I seem to have found another problem with regexp Stephen> :(

Re: how to escape french characters

2001-04-11 Thread christopher sagayam
First of all how to find out a special french character using perl and then how to escape it ? chris - Original Message - From: christopher sagayam To: [EMAIL PROTECTED] Sent: Wednesday, April 11, 2001 9:45 PM Subject: how to escape french characters im using a INSERT into tablename

how to escape french characters

2001-04-11 Thread christopher sagayam
im using a INSERT into tablename values ('$something1' , '$something2') now if $something1 contains any french characters likeé mysql says there is an error in sql statement I am using a BLOB datatype How to escape french characters using perl or using mysql chris

Re: Millenium

2001-04-11 Thread Scott Baker
MySQL will run just fine on all Win32 platforms. Including Millenium. At 05:41 PM 4/11/2001 +0200, Sylvain Besson wrote: >Hi >Is mysql running on Windows Millenium ? >Thank you in advance > >Sylvain Besson - Scott Baker - Webs

Re: Having a big problem in libmysqlclient.a with apache and php

2001-04-11 Thread Mohamed Ould
I'm sorry, even with this do not works. Thanks anyway. Gerald Clark a écrit : > make distclean, reconfigure and re make and install mysql. > > Mohamed Ould wrote: > > > > I have I have already zlib RPM (zlib-1.1.3-12) installed on my machine. Is this >is wrong one? > > > > Gerald Clark a écri

Millenium

2001-04-11 Thread Sylvain Besson
Hi Is mysql running on Windows Millenium ? Thank you in advance Sylvain Besson

I Need your help

2001-04-11 Thread technical
Good morning, Please, I use MySql, I would use INTERSECT/UNION functions and they don't work, I need help, My query is : select E.*, ME.Emplacement, E.Url,E.EMail, C.Name From Entreprise E, Mot_Entreprise ME, Mot M, Categorie C where (E.ID=ME.ID) and (ME.CodeMot=M.CodeMot) and (M.Mot like 'wor

Re: "Memo" Fields

2001-04-11 Thread Marty Landman
At Wednesday 4/11/01 10:32 AM, Frank Schmuck, CFO wrote: >I have a database of e-mail messages, the body of which is currently a >"memo" field. I want to convert these to MySQL (or to create a new one in >MySQL). Frank, for potentially large variable length strings Mysql provides the 'blob' dat

MYSQL API for C

2001-04-11 Thread VVM Ravikumar Sarma Chengalvala
I am using MYSQLAPI for C in my C++ program.WHat are all the precautions while using this way and how should I proceed.Shall I need to provide an extern C for the mysql.h header file. Pl help if someone already worked. REgards, Ravi __ Do You Yaho

Re: ID numbers: auto-increment or sequences ?

2001-04-11 Thread Steve Werby
"Gunnar von Boehn" <[EMAIL PROTECTED]> wrote: > Can I somehow say that > in database (1) the autovalues should start with 1 > and in database (2) maybe with 1 ? Yes. See the previous post from Mike Blezien. What he didn't say is that yes, you can have two identically structured tables w

Re: Any tool to port from DB2UDB to MySQL

2001-04-11 Thread Marco Guidi
Hi, I'm at the end of a project in which I did exactly that (transfer data from db2 for Linux to MySQL). I used no tool. I wrote some C/C++ programs accessing and tranforming the db2 data in a suitable form for MySQL. The same programs also inserted data in MySQL. Wed, 11 Apr 2001, Venkatesh

RE: "Memo" Fields

2001-04-11 Thread Robert Barrington
Use a text field. Varchar cannot exceed 255 characters. Robert B. Barrington GetMart Commercial Ecom: Web Administrator http://weddinginlasvegas.com/ http://getmart.com/ [EMAIL PROTECTED] Vegas Vista Productions 3172 North Rainbow Boulevard Suite 326 Las Vegas, Nevada 89108-4534 -Original M

Re: mysql uses 99% cpu under freebsd 4.3

2001-04-11 Thread Lars Andersson
My 4.2 STABLE dosent get so many queries, according to mysqladmin (Queries per second avg: 0.700) the last time it acted up. By the way, it is a dual CPU machine. On another machine with only one CPU running exactly the same code and relese of FreeBSD I havent seen this problem. /Lars Andersson _

Re: mysqlimport and remote host

2001-04-11 Thread Lucy
Hi Gerald Thanks a lot for the suggestion, but I'm not sure it will solve my prob, 'cos I dont want to copy a whole DB, and it's not on the same server anyway. I think it's my --local syntax in the mysqlimport (given in earlier message posted) that's dodgy. I've also tried an equals sign, doub

Re: mysql uses 99% cpu under freebsd 4.3

2001-04-11 Thread Andrey Kotrekhov
On Wed, 11 Apr 2001, Sinisa Milivojevic wrote: Hi! > > Hi Ken, > > This seems to be a problem with threads on FreeBSD, although on which > side, yet remains to be seen. > > It seems to appear that it is surfacing not just under heavy load, but > when there are many threads running. Many means mor

"Memo" Fields

2001-04-11 Thread Frank Schmuck, CFO
I have a database of e-mail messages, the body of which is currently a "memo" field. I want to convert these to MySQL (or to create a new one in MySQL). Is the equivalent of a memo field in MySQL a varchar of x length? If so how long do you make the field so that it does not truncate the end o

Re: Having a big problem in libmysqlclient.a with apache and php

2001-04-11 Thread Gerald Clark
make distclean, reconfigure and re make and install mysql. Mohamed Ould wrote: > > I have I have already zlib RPM (zlib-1.1.3-12) installed on my machine. Is this is >wrong one? > > Gerald Clark a écrit : > > > You need to load the zlib RPM from your CD. > > > > Mohamed Ould wrote: > > > > >

Re: Problems - Connection to mysql server thru an Access .adp

2001-04-11 Thread Gerald Clark
Read the section in the manual on setting up MyODBC. Daniel Chase wrote: > > I am running windows 2000 pro with Access 2000. > > I installed mySQL 3.23.36 and myodbc. After installation, I reconfigured > the mysqlwinadmin to use the mysqld-opt, overwwrote the ini and it shows > a connection and

Re: mysql uses 99% cpu under freebsd 4.3

2001-04-11 Thread Sinisa Milivojevic
Ken Menzel writes: > Hi Sinisa! > Good to hear from you. Not having this problem yet, I am however > interested in the details of what you did find and what may be the > potential cure. I am asking as I would like a little more detail than > what would normally go in a log entry. IE how did

Re: Having a big problem in libmysqlclient.a with apache and php

2001-04-11 Thread Mohamed Ould
I have I have already zlib RPM (zlib-1.1.3-12) installed on my machine. Is this is wrong one? Gerald Clark a écrit : > You need to load the zlib RPM from your CD. > > Mohamed Ould wrote: > > > > No body which is able to tell me what to do with this error? > > I'm staying in it since three days

Re: mysql uses 99% cpu under freebsd 4.3

2001-04-11 Thread Ken Menzel
Hi Sinisa! Good to hear from you. Not having this problem yet, I am however interested in the details of what you did find and what may be the potential cure. I am asking as I would like a little more detail than what would normally go in a log entry. IE how did the problem get reproduced.

Re: Having a big problem in libmysqlclient.a with apache and php

2001-04-11 Thread Gerald Clark
You need to load the zlib RPM from your CD. Mohamed Ould wrote: > > No body which is able to tell me what to do with this error? > I'm staying in it since three days. Searching on all google.com but no result. > > Thanks > > Mohamed Ould a écrit : > > > Hi, > > > > I goot this error when I t

Re: How to get it in ONE query?

2001-04-11 Thread Gerald Clark
Why? The mysql monitor is not a programming language. You are going to write programs in perl, PHP, python, or some other program that will be able to tell you how many rows were returned. Besides, if you look your output, it tells you how many rows were returned. Parse it. michalm wrote: > > I

Problems - Connection to mysql server thru an Access .adp

2001-04-11 Thread Daniel Chase
I am running windows 2000 pro with Access 2000. I installed mySQL 3.23.36 and myodbc. After installation, I reconfigured the mysqlwinadmin to use the mysqld-opt, overwwrote the ini and it shows a connection and the use of tcp-ip, so I assume there is a server connected. I have tried every imagin

RE: IT Inventory database needed.

2001-04-11 Thread Sica, Bill
On the Dell end, have you looked at DELL openmanage? it basically needs a server with a toned down version of micro$oft SQL. Dell Openmanage gives you all the dell specs, memory, procesor, service tag #, BIOS revision, etc. I'm sure it wouldn't be to bad to connect that into MySQL. (I haven't look

Re: Newbie has problem starting mysql 3.23

2001-04-11 Thread Gerald Clark
Read the mysqld error logs in mysql's var directory. If you are using the RPMs on RH7.0 CD, don't. GO to mysql.com or redhat.com and get new ones. Marc Gear wrote: > > I've been having enormous problems starting the mysql daemon and conencting > to it. > if i start the it with safe_mysqld i get

Re: mysqlimport and remote host

2001-04-11 Thread Gerald Clark
If you can ssh to the host you should be able to use scp to copy the file over. Lucy wrote: > > Hi > I'd successfully loaded a text file to a previously created table on my > localhost/server. It all works fine. > I'm having trouble doing the same to a remote host. I've checked the manual >

ID numbers: auto-increment or sequences ?

2001-04-11 Thread Gunnar von Boehn
Hi, For identification of each record in our database we use an 'autovalue'-column. It seems that this was a rather bad idea. As we are now planning to run two individual databases. In both of them records shall be written. Later we plan to merge them together again. But how can we do this? Wi

Re: Any limits on the number of fields ?

2001-04-11 Thread Gerald Clark
When developing, I have the program log all sql statements to a file so that I can examine them for errors. Perhaps the creates that fail contain some SQL error that you should test for ( reserved words or embedded quotes etc. ) [EMAIL PROTECTED] wrote: > > Hello there can anybody tell me if the

Re: Mysql and Perl DBI

2001-04-11 Thread Ben Dimmock
Gordon, What kind of errors? A copy/paste of errors would be useful. Cheers Ben - Original Message - From: "Gordon Stewart" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 11, 2001 1:29 PM Subject: Mysql and Perl DBI > > > I am running Redhat 7 and mysql and I have

Re: ID numbers: auto-increment or sequences ?

2001-04-11 Thread MikeBlezien
On Wed, 11 Apr 2001 14:42:47 +0200, Gunnar von Boehn <[EMAIL PROTECTED]> wrote: with MySQL 3.23+ you can now assign the auto_increment start value, when creating the table: AUTO_INCREMENT = 1 >>For identification of each record in our database >>we use an 'autovalue'-column. >>It see

Re: Slave to host connection

2001-04-11 Thread Gerald Clark
On the slave: telnet 192.168.1.2 3306 DO you get a connected message and sone garbage? If not, your master is not open for connections on port 3306. You could have skip-networking in /etc/my.cnf , or perhaps you specified a different port. If you did get the connection, then it is something el

Re: Newbie has problem starting mysql 3.23

2001-04-11 Thread B. van Ouwerkerk
>if i start the it with safe_mysqld i get: ./safe_mysqld & ># safe_mysqld >Starting mysqld daemon with databases from /var/lib/mysql >mysqld daemon ended Any additional messages? Any messages in syslog?? Bye, B. - Before

Re: Please HELP ME!!!!!!!!!!!!!!!!!!!!!!!!!!!

2001-04-11 Thread [EMAIL PROTECTED]
> k, I followed the instuctions on the MySQL page, downloaded > mysql-3.23.36-pc-linux-gnu-i686.tar.gz for redhat linux and then > followed the install directions: > >shell> groupadd mysql >shell> useradd -g mysql mysql >shell> cd /usr/local >shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar

Re: SOS ! I want to unsubscribe -------------------(query)

2001-04-11 Thread [EMAIL PROTECTED]
> I would like to unsubscribe of this list!!! Help me please ! > > My address : [EMAIL PROTECTED] > > -- > Alain Siani > (query,mysql) > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >

  1   2   >