Connecting to MySQL

2001-04-21 Thread Doddy Sebastianus
hi, I was trying to connect to MySQL server but after typing in the password, I got "can't connect to local MySQL server through socket '' (111) " I can connect to MySQL server thought regular terminal but for some reason It does not work when I am using MySQL GUI What's wrong with it? Thanks

Upgrading from 3.23.34 to 3.23.37

2001-04-21 Thread Paco Martinez
Estimated gurus. I'd like to know if is it essential to upgrade from 3.23.34 to 3.23.37 or changes are not very important. In case of necessary, how can I do this upgrading?? Downloading binary file or RPM file?? Is there any process to upgrade MySQL automaticaly?? Thank you very much

Re: hang problem with mysql

2001-04-21 Thread Sinisa Milivojevic
Vladimir Kukuruzovic writes: On Friday 20 April 2001 16:25, you wrote: Hi, I am using several mysql servers as a support for a high traffic site. The problem is that from time to time, and during last few days daily :, mysql hangs. It hangs so bad that even kill -9 can't kill it, the

Re: why doesn't this work? (C code)

2001-04-21 Thread Sinisa Milivojevic
Hi! As our manual clearly describes one connection can be used for one query at a time, unless you use threads and mutexes. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*|

Re: bug report

2001-04-21 Thread Sinisa Milivojevic
Andrew Schmidt writes: Description: tough one to describe. the step by step example shows all basicly once a table gets more than 1 row and doing a select with no result will yield a blank date... gah please see the example =) How-To-Repeat: create database tmpdb; use tmpdb;

how to avoid newline character?

2001-04-21 Thread Andreas Antes
When I load data into a mysql table from a simple tab delimeted textfile I prepared in a regular texteditor (notepad) using the "load data infile" command there is a newline character at the end of the text in every last column. How do I get rid of this newline character or are there alternative

Upgrading from 3.23.30

2001-04-21 Thread Gary Huntress
In the MySQL documentation section that covers upgrades, it discusses the process of upgrading between major releases. If I am upgrading MySQL within a major version, say from 3.23.30 to 3.23.36, is it as simple as just replacing mysqld? Regards, Gary "SuperID" Huntress

how do i?

2001-04-21 Thread Neil Patel
if have a static ip address, apache web server, mysql, myodbc and JDBC all working fine on Windows 98 platform. My basic question is how do i integrate these to have a form on a web page say on my Apache web server, dump the information a user submits into a sql database? I basically need help on

Installing MySQL on Linux Mandrake

2001-04-21 Thread Lee Jenkins
I've loaded Linux for the first time on a PC and wondered if I could get some advise on setting up MySQL on it. I would like to start off with the easiest/simplest method. Is that installing from an RPM? Is there an RPM for the latest stable version? Thanks In Advance, Lee Jenkins

Re: Mysql commands from Linux shell

2001-04-21 Thread Peter van Dijk
On Fri, Apr 20, 2001 at 12:03:22PM -0300, Fabio Galarraga wrote: Hi to all: I have a linux script and I need it can execute some mysql commands. Is it possible? If possible, how? http://www.dataloss.nl/dteq/ (you probably want to disable DEBUGging in the Makefile). Greetz, Peter.

wrong dependency to db.h

2001-04-21 Thread ch
Description: sql/Makefile.in has a dependency to ../bdb/build_unix/db.h at line 621. This file is not presence in mysql-3.23.37. How-To-Repeat: N/A Fix: delete the reference? Submitter-Id: submitter ID Originator:Christian Hammers Organization:

Re: why doesn't this work? (C code)

2001-04-21 Thread Peter Faulks
On Sat, 21 Apr 2001 14:12:20 +0300 (EEST), Sinisa Milivojevic wrote: As our manual clearly describes one connection can be used for one query at a time, unless you use threads and mutexes. G'day As I said, it worked fine b4 and I got it to work again. I _assumed_ the reason it fell over was

Slow replies (DNS problem?)

2001-04-21 Thread pablo alonso
I read your manual, but the details aren't always covered. I want to add -skip-name-resolution the the my.ini file. That file doesn't seem to be anywhere, although the WinMySqlAdmin tool says yes there is one present. I know I can edit it from the tool, but what would I add to it? I'm using

Re: Tables relationships

2001-04-21 Thread Mani Murugesan
- Original Message - No, MySQL does not help in enforcing referential integrity. You need to do that with your application. In some people's opinion (not mine), it is one of the major drawbacks to using MySQL. I agree. MySQL needs to have RI as its first priority on its TODO list. ps

Re: how to avoid newline character?

2001-04-21 Thread Paul DuBois
At 5:53 AM -0700 4/21/01, Andreas Antes wrote: When I load data into a mysql table from a simple tab delimeted textfile I prepared in a regular texteditor (notepad) using the "load data infile" command there is a newline character at the end of the text in every last column. How do I get rid of

Re: SQL Syntax question

2001-04-21 Thread Bob Hall
Hi there, I'm using mysql 3.22.27 and get error when trying to run this select statement: SELECT custmls.mlsnumber,custmls.streetnumber,custmls.streetdirect, FORMAT(custmls.currentprice,0),custmls.streetnam,custmls.streetaddtl, custmls.municname,custmls.state,custmls.zipcd,custmls.salesassoc,

Error codes

2001-04-21 Thread Steve Leibel
Can someone point me to the documentation of the error codes returned by Mysql? I mean the ones you get back from DBI via "err". I couldn't find them in the online docs. - Before posting, please check:

MySQL XSQL (Solaris/Apache/Jserv)

2001-04-21 Thread Dionysios G. Synodinos
I'm trying to get the Oracle XSQL servlet to work with MySQL (through the mm.mysql.jdbc-1.2c driver) under Solaris but I keep getting the following error message (using the xsql command-line tool): --- % sh $XSQL/bin/xsql test.xsql

compress problem when using MySQL++

2001-04-21 Thread Wm Terry
I seem to have a problem similar to others, but none of the suggested solutions seem to solve it. It's the standard "undefined reference to `compress'" while using MySQL++. What am I missing. Many solutions appear to address libmysqlclient. So I'm not sure if the problem is MySQL or MySQL++

WinMySqlAdmin

2001-04-21 Thread pablo alonso
Using version 3.23.36 on Win98 I see a problem with the new tool. On the databases tab I can view the databases and their tables in a tree view. If, in the right hand pane, I select my table, and wish to view its fields, I expect to see the field names, their datatypes, and other field-related

Information Technique

2001-04-21 Thread Samir Baghdadi
Salut Mr/Mme, J'ai une question prcise : Comment coder les caractres spciaux (de type , ,..) dans une BDD MySql Le problme c'est que j'ai developp avec JSP un site en utilisant le Systme d'exploitation Windows (les essais taient positifs). Lors de l'hbergement, (Sur adgraphix) les caractres

Mysql weird problem

2001-04-21 Thread Haris
Hello, i am developing a shopping cart with perl and mysql. The project almost finished is running fine on WinME with Mysql and Perl and Apache. Its running fine with Opera IE and Netscape. When i transfer the project on my protable running Win98,Opera and IE work but netscape just tries

RE: Mysql weird problem

2001-04-21 Thread Braxton Robbason
I think your problem is at the netscapeapache level, not the mysql level. Can you view static html pages served by your local apache with netscape? since netscape, opera, and IE all connect to apache, and then apache calls perl to connect to mysql, I doubt your problem has anything to do with