RE: Should We purchase mysql license Under Windows 2000??----Please Help!!!

If you are using MySQL for commercial gain then you need a developer's license. Michael Johnson Director BPEnet Humphrey Consulting Limited 13 Austin Friars London EC2N 2JX Tel +44(0)1323 438975 Fax +44(0)1323 738355 email [EMAIL PROTECTED] URL www.bpenet.net Also in Dublin Luxembourg

Re: fieltypes

Did you see http://www.mysql.com/doc/C/o/Column_types.html and http://www.mysql.com/doc/C/h/Choosing_types.html ? If there's something there that is confusing, let us know - - steve At 11:22 PM +0200 9/10/01, Mike Schwarz wrote: hi i'm a newbie with mysql, just

Re: Let's approach stored procedures

I have just started to look into the stored procedure issue. We will come up with a definite plan within a short period of time. It is true that there are solutions that would make transitions from another DBMS to MySQL easier however, I am leaning towards the ANSI standard rather than PL/SQL

european date to mysql date

Hi, I need to transform a europe date like 10/09/2001 (dd/mm/) in this format: 2001/09/10 (/mm/dd) ... how can I do using the mysql functions? many thanks in advance max - Before posting, please check:

Re: Let's approach stored procedures

On Mon, Sep 10, 2001 at 10:23:10AM +0200, Endre Stølsvik wrote: The proprietary issues might of course be a huge problem. Anyone knows anything about this? Well, the PostreSQL folks managed to implement a stored procedure language that looks, feels, and acts remarkably like Oracle's. So

a bug for bigint

Hi, I found a bug about bigint and max(), here is error result caused by bigint max(): -- mysql create table dick ( big bigint ); Query OK, 0 rows affected (0.00 sec) mysql insert into dick values (

Re: Let's approach stored procedures

At 09:40 AM 9/11/01 +0200, Arnulf Kristiansen wrote: I have just started to look into the stored procedure issue. We will come up with a definite plan within a short period of time. It is true that there are solutions that would make transitions from another DBMS to MySQL easier however, I am

Re: MyODBC, DBUG and multi-threaded clients

Hi Monty, Michael Widenius wrote: Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Peter Duffy writes: Hi Sinisa, My problems are within the mysqlclient and MyODBC libraries, both used directly by the application (and therefore all on the client side of the

Re: Stored procedures (2)

Claudio Cicali wrote: I've got a tour on the web, searching for info and ideas, regarding the subject to implement some sort of stored procedure in mysql (remember Lets approach stored procedure thread ?) This was what I discovered - The Perl stored procedures (myperl project) in not a

RE: Should We purchase mysql license Under Windows 2000??----Please Help!!!

MySql being under the GPL (as I just checked on the web site), I don't see why anything should be paid tu use it except if the owner asks for money which isn't the case. MySql proposes paying licenses but for people who don't want to be restricted by the GPL terms. So yes MySql can be used by

a bug for bigint

Hi, I found a bug about bigint and max(), here is error result caused by bigint max(): -- mysql create table dick ( big bigint ); Query OK, 0 rows affected (0.00 sec) mysql insert into dick values (

Re: when i try connect since a client windows9x to mysql ...

On Tue, 11 Sep 2001 00:25:20 GMT Miguel Enriquez Alvarado[EMAIL PROTECTED] wrote: hi all this is my first question: when i try connect since a client windows9x to mysql (in a server linux rh 7.0), say me the next error: General Sql Error: [TCX][MyODBC]Access deneied for user [EMAIL

Re: GEMINI Table Type

Hi, does MYSQL.COM has a table type same as GEMINI ( GEMINI does not complies with GPL according to what I read) that support the ACID PROPERTIES ( TRANSACTIONS ) (MyIsam, Inodb ?) ... yes. MySQL contains support for BDB and InnoDB tables, that are transaction-safe. if you are downloading

Re: Should We purchase mysql license Under Windows 2000??----Please Help!!!

On 11-Sep-01, michael johnson wrote: If you are using MySQL for commercial gain then you need a developer's license. No, MySQL is released under the GPL / LGPL. You only need the license if you're going to do something that would violate the license, such as linking the server part into

Database connection errors

Hi, Mysql is giving me connection to database errors. My database is created. Mysql server is getting started. The problem is with the connection to Mysql server. On command line, it shows connection with localhost. When I try to connect with server host name, it return backs with error -

join 2 db

Hi, I'd like to retrieve data which contain in 2 db. How could I do? db1-table-in-db1-field-in-table-in-db1 db2-table-in-db2-field-in-table-in-db2 I'd not extract data to new table because I'd like to retrieve data only. thanks SF

MySQL vs. AS/400

Hello, I need some facts on how MySQL compares to an AS/400 with their integrated data base engine. I'm talking to an AS/400 user who claims that there is no software in the market that can hold up against the AS/4000 in terms of speed and reliability. One claim is that it didn't fail him once

Re: mysql with jetspeed !

hi all ! i have recently installed mysql3.23.41 on my NT 4.0 worksation and running it as stand-alone. i wish to use mysql as a backend for a web application jetspeed. i did all the necessary setting changes and restarted both. now , from jetspeed i am able to access mysql( meaning that i

How do i see system tables ???

Hi Can anyone tell me how do i see all the system tables (default tables) used by mysql. To see the databases i know that there is a showdatabases command. How do i see the system tables ? thanx in advance regards Nilesh

MySQL Blasting CPU

I had a strange problem with MySQL 3.23.41 eating up my cpu, too I had just done a query to the database and it ate all of the cpu and slowed down all other processes on the machine for 20 minutes. I had to reboot the server. It did this 3 times. Database only had 15,000 records in it at the

Re: conversion.........

| he saves it as (.frm,.MYD,.MYI)anybody knows how in windows can i use the | database from my LINUX? simple, see mysql manual: mysqldump in linux shell type: mysqldump -uUSER -pPASSWORD --add-drop-table MYDATABASE dumpOfMyDatabase.sql copy the file dumpOfMyDatabase.sql to your win computer,

Re: How do i see system tables ???

Hi Can anyone tell me how do i see all the system tables (default tables) used by mysql. To see the databases i know that there is a showdatabases command. How do i see the system tables ? thanx in advance regards Nilesh What system tables are you talking about? The permissions

RE: MySQL Blasting CPU

Hi Have you done a optomis on the query? Is there any problmes with the tables? Did MySQL create lost of temp tables? Have you got lots of memmory in the sever? Has MySQL reported Long questones? Just a few things that I can think of I hope this helps? Simon -Original Message-

RE: mysqldump question (very basic)

Hi. I'm trying to run a mysqldump. I enter mysqldump -databases in order to backup all the databases. For some reason all I'm getting back is a help on the mysqldump. What am I doing wrong? thanks = It returns help whenever it doesn't understand what you're asking it to do (or

MySQL and Perl

Hi I just wanted to know how well MySQL gels with Perl, when compared to MySQL and PHP. any ideas ?? regards Nilesh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Database connection error

Hi, Can someone help out there? I have installed MySql 3.23.41 on Solaris. Created a database and executed the test script - run-all-tests which tested my installation/configuration. No error was reported. When I connect to the database from the installation server through command line -

Re: MySQL and Perl

Quite nicely. Take a look at the Perl DBI functions. Curtis On Tue, 11 Sep 2001, Nilesh Parmar wrote: Hi I just wanted to know how well MySQL gels with Perl, when compared to MySQL and PHP. any ideas ?? regards Nilesh

Re: GEMINI Table Type

At 11:03 11.09.01, you wrote: does MYSQL.COM has a table type same as GEMINI ( GEMINI yes. MySQL contains support for BDB and InnoDB tables, that are transaction-safe. I don´t want to provoke any anger here, maybe i´m still too new on the list. But actually, i´m a bit sick of the current

MySQL Error

Hi All After upgrading to 42 I get the Error 2002 cannot connect though socket /tmp/mysql.sock (111) But using my Win client I can connect and run commands and my Web site connects and is running fine. Using RH 7.0 latest MySQL build .42 M;) MySQL Database Enlightenment

Missing binaries in 3.23.42 release binary dist.

Hi, I've found there are missing binaries at least in mysql-3.23.42-pc-linux-gnu-i686.tar.gz Those are: isamlog, myisamlog, mysql_install_db, mysqlbinlog I've checked that in the tar archive again, but not luck. Am I totally blind? ;-) -- Martin Mokrejs - PGP5.0i key is at

Mysql Performance Problem with updates, bug?

Hello, it´s me again. For the new readers: mysql 3.23.41, ~50q/s, load jumps to 200. If have been experimenting with the slow log to find out about these slow queries that are apparently locking too long. Much to my horror, I have lots of queries of this type popping up: # Time: 21

Got error -30996 when reading table

Hi there, sorry if I am ask a dumb question. I searched the web for answer, but did not found any. No I am joining the list and hope that anybody can help! I am running mysql in version -3.23.40 on a Linux box and working with BDB Tables. I get the following errors: errors on client side:

Re: Database Design

Hi All, Not really a MySQL-oriented question. But this board's so active I decided to post my question here in hope I'll get some lights on my database design. Using Amazon as an example, say if I have a table that stores user information and each user is assigned an unique id (field might

Re: Database Design

==Would someone suggest a book that's more related to database design and preferably have some real-world scenarios as examples. Database Design for Mere Mortals A Hands on Guide to Relational Database Design Michael J. Hernandez Colm Colm Brazel (MA) CB Publications www.cbweb.net [EMAIL

error in sec index entry update

Hello, I'm using mysql 3.23.40 with InnoDB tables. Recently I've been seeing several of the following messages in my logs related to indexes. InnoDB: error in sec index entry update in InnoDB: index user_ table webassign/roster InnoDB: tuple 0: len 50; hex

RE: Database connection error

Hi, Looks like your problem is related to Access Privileges setup. Take a look at http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Privilege_system That should get you started. I'll just summarize a bit what the manual says here. MySQL's security

LAST_INSERT_ID() does not return anything

I have a problem using the LAST_INSERT_ID() in a particular installation. I am running IIS on windows NT and accessing the MySQL database from an asp page using ADO. Here is the code I am using SET objConn = Server.CreateObject(ADODB.Connection) objConn.open connectionstring objConn.execute

FOREIGN KEY ... ON DELETE CASCADE

Is FOREIGN KEY ... ON DELETE CASCADE operational in mysql? If so, I am not observing such. Here is how I am using it: CREATE TABLE scheduled_task_list ( schedule_id CHAR(28) NOT NULL, /* keys */ PRIMARY KEY (schedule_id) ); CREATE TABLE

Re: FOREIGN KEY ... ON DELETE CASCADE

Take a look at: http://www.mysql.com/doc/M/i/Missing_Foreign_Keys.html Basically, MySQL does not support foreign keys. Therefore, referrential data integrity (RDI) is also not available. Good Luck, Dennis ** Beridney Computer Services

Re: MySQL Error

i had the same problem chown -R mysql.mysql /var/lib/mysql and i created a symlink from /tmp to the /var/lib/mysql/mysql.sock and restarted mysql and wammo it worked.. I used this on one computer on the advice for Error 2002: ... ... mysql.sock(2) error. On Tue, 2001-09-11 at 08:53,

Re: Database Design

i got a really good book on MySQL, it does not have much in the way of troubleshooting, but a lot on use. Title: MySQL Author: Paul DuBois ISBN: 0-7357-0921-1 Publisher: New Riders - Before posting, please check:

linux load level possibly solved

Today our servers got the highest consistant level of activity I've ever seen, almost all of it because our users were reloading a mysql-database driven message board like crazy. Fortunately, I was awakened at 7.30am by my mysql 3.23.41 machine dying again, and in utter frustration I backed

Re: help with mysql.sock error

I had the same problem with suse 7.2. I see that the path to mysql.sock is /var/lib/mysql/mysql.sock. this location of mysql.sock was a leftover from the mysql that i installed from the distribution. the downloaded version though stores the mysql.sock in /tmp/mysql.sock - i had to tell a few of

Re: MySQL and Perl

PHP, Perl, Python, etc are all good ways to generate web pages, and they all get on with MySQL perfectly well (OK, I've only used Perl, but I've heard a lot about PHP and a little about Python). My personal input re Perl v. PHP is that PHP is great for people starting CGI stuff if they know HTML

Re: How do i see system tables ???

Hi Can anyone tell me how do i see all the system tables (default tables) used by mysql. To see the databases i know that there is a showdatabases command. How do i see the system tables ? thanx in advance regards Nilesh What system tables? There aren't any. -- Paul DuBois, [EMAIL

Re: join 2 db

Hi, I'd like to retrieve data which contain in 2 db. How could I do? db1-table-in-db1-field-in-table-in-db1 db2-table-in-db2-field-in-table-in-db2 I'd not extract data to new table because I'd like to retrieve data only. Refer to the tables by qualifying them with

Re: MySQL and Perl

PHP, Perl, Python, etc are all good ways to generate web pages, and they all get on with MySQL perfectly well (OK, I've only used Perl, but I've heard a lot about PHP and a little about Python). My personal input re Perl v. PHP is that PHP is great for people starting CGI stuff if they know HTML

Re: MySQL Error

chown -R mysql.mysql /var/lib/mysql That's because there's user=root defined in safe_mysqld. I just put there mysql and it works fine. I don't know how you, but I don't like the .pid and .err file mixed with databases in the datadir. MYSQL_UNIX_PORT=${MYSQL_UNIX_PORT:-/tmp/mysql.sock}

Re: MySQL and Perl

In web development PHP is very easy to use and best of all very well documented. I have to aggress with Lezz Giles on using PHP over perl for MySQL backed webpages.. The learning curve on PHP is far easier than perl.. I use both for various reasons..I tend to use perl of CGI apps that php cant do

Re:Re: when i try connect since a client windows9x to mysql ...

this is my first question: when i try connect since a client windows9x to mysql (in a server linux rh 7.0), say me the next error: General Sql Error: [TCX][MyODBC]Access deneied for user [EMAIL PROTECTED] (using password YES) alias Test You must grant user rights to mysql

Sending data from Excel to MySQL

I was wondering if someone could direct me to some resources where I could teach myself how to export data from Excel to a MySQL database. I have a number of spreadsheets I use for data collection, and have recently set up a MySQL database to stash the data in. I've managed to figure out how to

Re: Sending data from Excel to MySQL

At 3:31 PM -0400 9/11/01, Eugene Mah wrote: I was wondering if someone could direct me to some resources where I could teach myself how to export data from Excel to a MySQL database. I have a number of spreadsheets I use for data collection, and have recently set up a MySQL database to stash the

Re: my.cnf optimization question ..

They average around 500 connections/second at any given time, two have a master/slave setup. Connections/sec or Queries/sec? That's a lot of connections per second? Can you use persistent connections? It would save a lot of overhead. Half and half, at the moment .. We had a problem

RE: load level on linux mysql server out of control

I'ld suggest you guys round back to the version of MySQL that didn't have this problem, and try to figure out, possibly by giving MySQL AB access to the server(s), or installing a debuggable executable, what the problem is... Obviously, if two people are hit, the problem must be other than their

VDD error for newbie user

Hlello there.. I am a newbie to all of this.. I download the laterst version of mySQL (v 323) for win 98/NT/200. Everytime I try to install it, I get a message ..VDD. Virtual Device Driver format in regestry is invalid. Choose 'Close' to terminate this application.. I even tried to install

keyword in mysql

how can i store long keywords to a database in mysql. --- ¿Te desesperan las chapuzas caseras? No lo dudes y entra en Bricoespacio.com http://www.bricoespacio.com - Before posting, please check:

What have i done? adding new db

I am very much a part mysql db administrator, this is an appology for my ignorance. we are using mysql for 2 databases that are functioning normally. people add and access information without problem. i wish to add a third. i don't recall the exact process that i went through before to add

Mysql and Delphi dude

hi all i use delphi 3 and mysql, i can connect to mysql since a component Tquery (i see the data), but my question is: how remove the box where ask me the username and password, when run my app, anybody recommned me the component Tdatabase but i not know how use, anyone can help me? thanks

Re: What have i done? adding new db

At 2:18 PM -0700 9/11/01, Kevin Tomasek wrote: I am very much a part mysql db administrator, this is an appology for my ignorance. we are using mysql for 2 databases that are functioning normally. people add and access information without problem. i wish to add a third. i don't recall the

Replication again.....

It has been a interesting experience... but it is not reliable enough, unless I am doing something wrong... I have MySql() on Mandrake. Installed 1 master 2 slaves. One slave do a full backup and the other partial (some tables only). All work fine, except when I get an error and it tries to

VDD error

Hlello there.. I am a newbie to all of this.. I download the laterst version of mySQL (v 323) for win 98/NT/200. Everytime I try to install it, I get a message ..VDD. Virtual Device Driver format in regestry is invalid. Choose 'Close' to terminate this application.. I even tried to install

Re:Mysql and Delphi dude

hi all i use delphi 3 and mysql, i can connect to mysql since a component Tquery (i see the data), but my question is: how remove the box where ask me the username and password, when run my app, anybody recommned me the component Tdatabase but i not know how use, anyone can help me?

Re:Re:Mysql and Delphi dude

hi all i use delphi 3 and mysql, i can connect to mysql since a component Tquery (i see the data), but my question is: how remove the box where ask me the username and password, when run my app, anybody recommned me the component Tdatabase but i not know how use, anyone can help me?

VDD error message for newbie

Hlello there.. I am a newbie to all of this.. I download the laterst version of mySQL (v 323) for win 98/NT/200. Everytime I try to install in, I get a message ..VDD. Virtual Device Driver format in regestry is invalid. Choose 'Close' to terminate this application.. I even tried to install

Installation Problems - HP-UX 10.20

When I run ./scripts/mysql_install_db I get the following error message, any help resolving this issue would be greatly appreciated. /usr/local/mysql # ./scripts/mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table

Problem with 3.23.42

I just installed MySQL 3.23.42 onto my FreeBSD 4.4-RC3 Box and It installed just fine but now when I run the database it bombs And does the following: su-2.04# /usr/local/bin/safe_mysqld [1] 68926 su-2.04# Starting mysqld daemon with databases from /usr/local/var 010911 18:01:07 mysqld ended

Re: VDD error message for newbie

That may be it (dual boot). The virtual drivers for win98 that mySQL uses probably are only compatible with win98 not 2000. Im probably wrong but that's the only solution I've got. - Deryck H - http://www.comp-u-exchange.com - Original Message - From: Kevin [EMAIL PROTECTED] To: [EMAIL

RE: Mysql and Delphi dude

Use Zeos componets. You can use either login or no login. M;) -Original Message- From: Miguel Enriquez Alvarado [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 11, 2001 3:29 PM To: [EMAIL PROTECTED] Subject: Mysql and Delphi dude hi all i use delphi 3 and mysql, i can connect to

Re: Mysql and Delphi dude

The TDatabase component should have a property named LoginPrompt. You need to set that property to FALSE. 1) Drop a TDatabase on your form or datamodule 2) Set the TDatabase.DatabaseName property 3) Set the TDatabase.AliasName property 4) Set the TDatabase.LoginPrompt property to False 5) Drop

Re: Looking for a Data entry program for mysql...

Try mysqlfront (www.mysqlfront.de) I use it daily in development tasks for a hybrid Win2k - Linux setup. Works great. 10 Sep 01 10:28:21 PM, Francois Meehan [EMAIL PROTECTED] wrote: Hi all, I am looking for a freeware-shareware pgm for data entry, on win32 for a mysql database on Linux(not

RE: Mysql and Delphi dude

The Zeos components are fine, but there's no need to change the underlying libraries to get functionality that exists within the current component. Borland's TDatabase object (native VCL) also supports both options -- LoginPrompt or no LoginPrompt. On Tue, 11 Sep 2001, Mike wrote: Use Zeos

Any Affect?

After the planes crashes to the WTC building, any effect to the mySQL support and web site download section? And I want to express my deepest condolences to the people die in this WTC event. Regards, Calvin Chin [EMAIL PROTECTED] Ipmuda Berhad - Building materials for tomorrow's world !

Re: Any Effect?

Actually, I dont think so but I agree with the last statement. I think Bush needs to send out EVERY FBI, CIA, etc agent to find out whoever did this, if they werent on those planes already. Dang, the entire WTC tower. Wait, BOTH of them. Anyway, this has zippo to do with mySQL bu it still is

Re: MySQL and Perl

PHP has built in functions that will dump an entire row into an array (this works with CSV and SQL databases).well there is my 2 cents worth on PHP+MySQL Um, not to start a language war, perl also can dump a row into an array, as well as into a hash so that one can refer to fields by name,

Re: MySQL vs. AS/400

I realize my opinion may be unpopular in this forum, however, I have to say that if it's mission critical, I would want an IBM AS/400. As a consultant, I work with numerous hospital and health care companies that each manage tens of gigs of data on their machines. There is very little

Re: MySQL and Perl

PHP's mysql_fetch_array() fetches an associative as well as indexed array...or you can specify which. (I'm a huge fan of perl, btw, and have used it to talk to mysql when PHP was just a baby language so no flames...just setting the record straight...) Cheers jenn Rich Duzenbury wrote: PHP

Re: MySQL vs. AS/400

OK mine are more respected :) j/k another point of view. 1st You are assuming this only runs on Intel machines. I have MySQL running on a Sun E-4500 (8 x400mhz procs / 8GB RAM) running Solaris 8 on a financial institution on a very mission critical application. 2nd IBM support is piss poor

Re: MySQL and Perl (STOP)

STOP PLEASE. Not again. See mailing list archives. [EMAIL PROTECTED] wrote: PHP's mysql_fetch_array() fetches an associative as well as indexed array...or you can specify which. (I'm a huge fan of perl, btw, and have used it to talk to mysql when PHP was just a baby language so no

@variableName What Version?

I currently use MySQL 3.22.32-log I compiled the source code to use with Caldera 2.3.. Does my version support the use of the @variable syntax.. When I attempt to use this I get error Error 1064 .. I find that this also would not work set @min_price=min(shop.price); P.S What is the log

Re: @variableName What Version?

At 8:02 PM -0400 9/11/01, R Talbot wrote: I currently use MySQL 3.22.32-log I compiled the source code to use with Caldera 2.3.. Does my version support the use of the @variable syntax.. When I attempt to use this I get error Error 1064 .. I find that this also would not work set

Query using SSL very slow and hang

Hi, Maybe my question here is not directly related to this topic. However, I wish somebody out there will had enough information to help me solve this probelm. I am developing marketing portal using Java language, deploying with Apache 1.3.12 + Tomcat 3.2.2 + Mysql-3.23.40 as my database server

RE: manual

I have tryed to download the mysql manual.pdf but for some reason I cant. Would anyone be able to email me the pdf version? [EMAIL PROTECTED] Thanks Sharon - Before posting, please check:

Re: MySQL vs. AS/400

You forgot to metion the great new feature becoming available. Secure telnet, it never existed before very recently for AS/400. Secure huh? Yeah. There are companies making web apps for the AS/400 that are advertising that you can use the web and it is more secure than the traditional 5240

Re: MySQL vs. AS/400

At 10:30 PM 9/11/01, you wrote: OK mine are more respected :) j/k another point of view. Sorry, I didn't understand your comment. 1st You are assuming this only runs on Intel machines. I have MySQL running on a Sun E-4500 (8 x400mhz procs / 8GB RAM) running Solaris 8 on a financial

Re: MySQL vs. AS/400

At 12:33 AM 9/12/01, Eric Frazier wrote: You forgot to metion the great new feature becoming available. Secure telnet, it never existed before very recently for AS/400. Secure huh? Yeah. There are companies making web apps for the AS/400 that are advertising that you can use the web and it is

Addnew problem

Hi, When i create a webpage in frontpage in ASP code, de Addnew function to add a record in my mysql database does not function properly. The record is inserted , but the other first existing record will be deleted. What is going wrong here ? ALso when i create a new database with a column