Goldmine

Dear All Has anyone successfully used Goldmine accessing MySQL databases via ODBC or any other connection method? Regards Michael Johnson - Before posting, please check: http://www.mysql.com/manual.php (the manual)

MySQL JDBC driver problem

Hi, How are you? I have a problem to jdbc driver. My paltform is win2000 professional and MySQL Server's version is 3.23.55. I use jdbc driver of mysql-connector-java-3.0.6-stable.jar and i find some problems to this jdbc driver version. When i use some method about setting or getting String suc

Re: Two mysql servers on the same database directory

>From: gerald_clark <[EMAIL PROTECTED]> >User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20020823 Netscape/7.0 >To: Vlad Shalnev <[EMAIL PROTECTED]> >Cc: [EMAIL PROTECTED] >Subject: Re: Two mysql servers on the same database directory > > > >Vlad Shalnev wrote: > >>Hi, All >>

Re: Upgrading from 3.22

At 22:33 -0500 3/16/03, [EMAIL PROTECTED] wrote: We are wanting to upgrade to MYSQL 3.23 on a Linux system. Is there an upgrade from 3.22 to 3.23 or do I simply install 3.23 in the same directory where 3.22 was? Any help would be appreciated. You can do that, though of course you should make a ba

Re: Foreign Key and default action/RESTRICT behaviour?

At 4:13 +0100 3/17/03, Andreas wrote: RESTRICT is, of course, the default 'action'. ON DELETE and ON UPDATE are later additions. Paul DuBois wrote: I see in the change notes that ON UPDATE was implemented in 4.0.8. But how can ON DELETE be a later addition than RESTRICT? I was under the impressi

Re: Upgrading from 3.22

We are wanting to upgrade to MYSQL 3.23 on a Linux system. Is there an upgrade from 3.22 to 3.23 or do I simply install 3.23 in the same directory where 3.22 was? Any help would be appreciated. - Before posting, please check

Re: Foreign Key and default action/RESTRICT behaviour?

RESTRICT is, of course, the default 'action'. ON DELETE and ON UPDATE are later additions. Paul DuBois wrote: I see in the change notes that ON UPDATE was implemented in 4.0.8. But how can ON DELETE be a later addition than RESTRICT? I was under the impression that RESTRICT wasn't even implement

Re: Foreign Key and default action/RESTRICT behaviour?

At 14:29 -0600 3/16/03, Paul DuBois wrote: At 19:21 +0100 3/16/03, Tor R. Skoglund (NextG) wrote: Hi List, regarding the foreign key definitions: [CONSTRAINT symbol] FOREIGN KEY (index_col_name, ...) REFERENCES table_name (index_col_name, ...) [ON DELETE {CASCAD

Re: Foreign Key and default action/RESTRICT behaviour?

At 23:12 +0200 3/16/03, Heikki Tuuri wrote: Tor, - Original Message - From: ""Tor R. Skoglund (NextG)"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Sunday, March 16, 2003 10:11 PM Subject: Foreign Key and default action/RESTRICT behaviour? > Hi List, regarding the foreign

Re: How to compile mysql-3.23.55 on Aix 4.3.3.11

Thats right. problem resolved. Thanks. set-variable=thread_stack=256k in the [mysqld] portion of you're my.cnf file. HTH -Bart -Original Message- From: Jose [mailto:[EMAIL PROTECTED] Sent: Sunday, March 16, 2003 10:22 AM To: [EMAIL PROTECTED] Subject: How to compile mysql-3.23.55 on

Re: Foreign Key and default action/RESTRICT behaviour?

Tor, - Original Message - From: ""Tor R. Skoglund (NextG)"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Sunday, March 16, 2003 10:11 PM Subject: Foreign Key and default action/RESTRICT behaviour? > Hi List, regarding the foreign key definitions: > > [CONSTRAINT symbol] F

RE: Newbie - How can I insert new data with the current date/time?

Great, this is more of what I was looking fora way to have the DB auto populate the date/time in a column, without having to use sql. Thanks again! "Uttam

Re: Newbie - How can I insert new data with the current date/time?

Thanks Paul, that works great. Yes, I meant to say the table animals, not bug_master. Paul DuBois

Re: INTO LOCAL OUTFILE?

On 16-Mar-2003 Tim Johnson wrote: > Hi Paul: > * Paul DuBois <[EMAIL PROTECTED]> [030316 09:59]: >> At 9:14 -0900 3/16/03, Tim Johnson wrote: >> >Hello All: >> >I am using Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386) >> > >> >I believe that INTO LOCAL OUTFILE is not implemented,

MySQL CC & Mandrake 8.2

I have Mandrake 8.2 installed and had MySQL loaded during the system installation.I have questions about the location of MySQL and where I should unpack the MySQL graphical interface(s) to install. I have the MySQLCC (version glibc-0.8.10) in a tarball, MySQL Client (version 3.23.7-5.3) in an RPM a

Re: Foreign Key and default action/RESTRICT behaviour?

At 19:21 +0100 3/16/03, Tor R. Skoglund (NextG) wrote: Hi List, regarding the foreign key definitions: [CONSTRAINT symbol] FOREIGN KEY (index_col_name, ...) REFERENCES table_name (index_col_name, ...) [ON DELETE {CASCADE | SET NULL | NO ACTION

Re: INTO LOCAL OUTFILE?

At 10:34 -0900 3/16/03, Tim Johnson wrote: Hi Paul: * Paul DuBois <[EMAIL PROTECTED]> [030316 09:59]: At 9:14 -0900 3/16/03, Tim Johnson wrote: >Hello All: >I am using Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386) > >I believe that INTO LOCAL OUTFILE is not implemented, but >

Foreign Key and default action/RESTRICT behaviour?

Hi List, regarding the foreign key definitions: [CONSTRAINT symbol] FOREIGN KEY (index_col_name, ...) REFERENCES table_name (index_col_name, ...) [ON DELETE {CASCADE | SET NULL | NO ACTION | RESTRICT}] [ON UPDATE {

Process Limit on Linux ?

Hi there, i wrote several times to the list asking for help with a problem regarding process limits on linux, but never got an answer. today i found this story: http://www.mysql.com/press/user_stories/handy.de.html here are the relevant sentences: "We had some process limit problems on our Lin

Re: How to compile mysql-3.23.55 on Aix 4.3.3.11

In the last episode (Mar 16), Jose said: > Now i'm trying to compile 3.23.55 version to probe if it works. I use > gcc-3.2.1. I have read installation instructions for aix but i get > this error for "make" process: > > gcc -pipe -mcpu=power -Wa,-many -O3 -DDBUG_OFF -felide-constructors -fno-except

Re: INTO LOCAL OUTFILE?

Hi Paul: * Paul DuBois <[EMAIL PROTECTED]> [030316 09:59]: > At 9:14 -0900 3/16/03, Tim Johnson wrote: > >Hello All: > >I am using Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386) > > > >I believe that INTO LOCAL OUTFILE is not implemented, but > >all the same, I would like to sav

VB6 ODBC Memory problems

Hello, I have been developing an application in VB60 (SP5) which seems to eat up my memory after running some time. The programm is just doing a SELECT in a loop. When the programm is stopped, the memory is freed. Developement environment: WinNT40 SP6a VB60 SP5 DAO 3.6 MySql 2.23.54-nt M

Re: INTO LOCAL OUTFILE?

At 9:14 -0900 3/16/03, Tim Johnson wrote: Hello All: I am using Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386) I believe that INTO LOCAL OUTFILE is not implemented, but all the same, I would like to save a selection set into a local output (text) file. Can someone suggest a

Re: broken database? or?

On Sun, 16 Mar 2003 12:04:37 -0500, joe <[EMAIL PROTECTED]> wrote: >I have recently moved onto a new server. For a brief period after the move >I could access the mySQL database using GUI clients such as mysqlf and >sqlyog. And the web site that it supported was accessible in various >browsers

INTO LOCAL OUTFILE?

Hello All: I am using Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386) I believe that INTO LOCAL OUTFILE is not implemented, but all the same, I would like to save a selection set into a local output (text) file. Can someone suggest a way to use mysqldump to do the same (

RE: How to compile mysql-3.23.55 on Aix 4.3.3.11

I don't know about the make problem you describe, but in order to use MySql with AIX 4.3.3.11 you'll have to include set-variable=thread_stack=256k in the [mysqld] portion of you’re my.cnf file. HTH -Bart -Original Message- From: Jose [mailto:[EMAIL PROTECTED] Sent: Sunday, March 16,

How to compile mysql-3.23.55 on Aix 4.3.3.11

Hi! First of all i had working mysql 3-23-35 on aix 4.3.3.10. After upgrade to 4.3.3.11 it doesn't works. I get: Warning: mysql_select_db() [function.mysql-select-db]: Can't connect to local MySQL server through socket '/tmp/mysql.sock Now i'm trying to compile 3.23.55 version to probe if it work

embedded server

hi ! I've wrote an application that run on Win32 and that embed the server. It works perfectly on XP but some friends of mine reported crash on win2000 when mysql_server_init(...) is called. When I debug it (winXP / MSVC++ 6.0 / MySQL 4.0.11) the debug process stops when mysql_server_init(...) i

broken database? or?

I'm a total newbie. If this issue does not belong here, please suggest a more appropriate mailing list or fourm. I have recently moved onto a new server. For a brief period after the move I could access the mySQL database using GUI clients such as mysqlf and sqlyog. And the web site that it sup

comment with "foreign key" text causes innodb CREATE TABLE failure

Hi! > "Brandon" == Brandon Bird <[EMAIL PROTECTED]> writes: Brandon> From: [EMAIL PROTECTED] Brandon> To: [EMAIL PROTECTED] Brandon> Subject: comment with "foreign key" text causes innodb CREATE TABLE Brandon> failure Brandon> Description: Brandon> If an innodb table is created with a

Re: Warning: mysql_select_db() [function.mysql-select-db]: Can't connect to local MySQL

The file exists: When i starts mysql i do ls -l /var/lib/mysql and shows: srwxrwxrwx 1 mysqlmysql 0 16 mar 12:51 /var/lib/mysql/mysql.sock If i look in mysql log i get: 030316 12:51:34 mysqld started /usr/local/bin/mysqld: ready for connections mysqld got signal 11; The manual sec

RE: Newbie Query Question

is a crosstab is what you want? pls. give the result (output of the query) that you expect from the example and what you are actually getting. regds, -Original Message- From: Charles Kline [mailto:[EMAIL PROTECTED] Sent: Saturday, March 15, 2003 20:53 To: [EMAIL PROTECTED] Subject: Newbi

RE: Newbie - How can I insert new data with the current date/time?

*if you create a column of the type TIMESTAMP instead of DATETIME then it automatically stores the time when the record was inserted/last updated. If you have more that one column of type TIMESTAMP in the same table then only the first TIMESTAMP column gets updated automatically. (Don't confuse My