need mysql version newer than 3.23.38 for dec osf4.0

2001-11-09 Thread Klaus Kunze
Hallo, I am new on this maillist. I need for my Dec-Server with OSF4.0 a newer version (binary) of mysql than 3.23.38 Where can I get such version. With source-code of Version 3.23.44 I have problems Mit frdl. Gruss Klaus Kunze === Dr. Klaus

Re: New fork of MySQL

2001-11-09 Thread Ben Gollmer
Hmm, this has certainly been an interesting discussion. I personally think that forking the code accomplishes nothing at all. What's so tough about making a patch to 3.23 and sending it to the MySQL developers? I also doubt that anyone working on the new fork will be able to convince

Re: need mysql version newer than 3.23.38 for dec osf4.0

2001-11-09 Thread Michael Wittmann
hi, found this on german mysql mirror ftp://ftp.kernelnotes.de/mysql.com/Downloads/MySQL-3.23/mysql-3.23.44-dec-osf5.1-alphaev6.tar.gz (6320kb). don't know if there might be problems with osf5.1 vs osf4. hope this helps, michael Klaus Kunze wrote: Hallo, I am new on this maillist. I need

Re: MySQL 4.0 updated?

2001-11-09 Thread Bernhard Doebler
Hi, I think MySQL 4.0.0 is in it's alpha state. Wouldn't it be more right to get a 4.0.0 beta and several release candidates than a 4.0.1 version? Best regards Bernhard - Original Message - From: Mike Wexler [EMAIL PROTECTED] To: Mark Maunder [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]

Re: 127.0.0.1 problem

2001-11-09 Thread Carl Troein
Alex writes: Are there any obvious reasons why mysql -h localhost works and mysql -h 127.0.0.1 does not. Maybe not obvious, but a good reason nonetheless: The string 'localhost' has a special meaning to mysql: Connect locally using some platform-dependent means of IPC, such as unix

Beginner question - getting last inserted ID

2001-11-09 Thread Anna Åhnberg
Hello! I am working on my first MySQL client. I have a number of tables, each containing a AUTO_INCREMENT PRIMARY KEY column. The client is built in Java and using a JDBC-bridge to connect to the database. When I do an insert in one of these tables the primary key column gets a new ID. How do I

Re: MySQL 4.0 updated?

2001-11-09 Thread alec . cawley
I think MySQL 4.0.0 is in it's alpha state. Wouldn't it be more right to get a 4.0.0 beta and several release candidates than a 4.0.1 version? 4.0 is in its alpha state. 4.0.0 is the first alpha release, and 4.0.1 the second and so on. It is, IMO, essential to give every release its own

Replicating from 3.23.42 to 4.0 - problem

2001-11-09 Thread Arne K. Haaje
Can I replicate a 3.23.42 database to a 4.0.0 server? I have not seen mentioned any place that you can not so I tried.. The error log on the slave say; 011108 15:54:17 Slave: connected to master 'user@master:32354', replication started in log 'FIRST' at position 4 011108 15:54:17 Could not

SqlBuilder (Constructor) now support MySql

2001-11-09 Thread [EMAIL PROTECTED]
Ver 0.7 News 07/11/2001 http://www.geocities.com/b_asi2000/index.htm In addtion to BDE, direct Oracle, FlashFiler connectivity, now also support Add ADO support Add DAO support Add ODBC support Add direct DBISAM ver 2.x access (Local) Add direct DBISAM ver 3.x access (Client Server) Add

Re: C API mysql_query() malfunctioning (long)

2001-11-09 Thread M. A. Alves
I know KR (section 4.9, 2nd ed.) says char s[] = ...; is equivalent to char s[] = { . . . , '\0'} but I always explicitely attach the \0 just to be sure i.e. char s[] = ...\0; /* mysql, database (cheating the filter, human reader ignore) */ -- , M A R I O data miner, LIACC,

Re: OT: Default forced on MySQL;

2001-11-09 Thread Gordan Bobic
On Friday 09 Nov 2001 03:36, DownloadFAST.com wrote: Mr. Bobic, [snip] The only thing that matters is that every time you respond on the list, you are only making a fool of yourself in the eyes of the many people who are lurking. They can see right thru your motives in sending this post

Re: New fork of MySQL

2001-11-09 Thread DownloadFAST.com
What's so tough about making a patch to 3.23 and sending it to the MySQL developers? 3.23 will not the most current cvs soon I assume. Or does MySQL actively support, debug, fix, and go back and maintain older releases? I also doubt that anyone working on the new fork will be able to

Re: Beginner question - getting last inserted ID

2001-11-09 Thread Carl Troein
Anna Åhnberg writes: When I do an insert in one of these tables the primary key column gets a new ID. How do I get this ID? I guess I cannot use SELECT MAX(id) FROM Table since old, deleted id's are reused for new rows. Please, help me! I shall help you help yourself, for from that

MySQL Transactions

2001-11-09 Thread Segun Olotu
Can anyone help? I'm trying to implement a transaction (using InnoDB tables ) in which everything done in it can be rolled back at any stage. There are several operations involved and I need to be able to undo all the work done so far at any point. In my code below, I've deliberately set the

Re: Beginner question - getting last inserted ID

2001-11-09 Thread Kodrik
The manual has all the necessary information: http://www.mysql.com/doc/C/R/CREATE_TABLE.html http://www.mysql.com/doc/e/x/example-AUTO_INCREMENT.html The unofficial FAQ has a chapter on AUTO_INCREMENT: http://www.bitbybit.dk/mysqlfaq/faq.html#ch6_0_0 What you're looking for is probably

Re: varchar in the foodchain

2001-11-09 Thread Tony
On Friday 09 November 2001 12:23 am, Steve Meyers wrote: Tables with variable length rows can get ugly if not optimized frequently. We had one which was taking 2.5 sec to do an indexed query, and when we optimized the table it dropped to .2 sec. But as long as you keep your tables

mysql corruption tables in production environment (Urgent)

2001-11-09 Thread Rui Barreiros
Hi, We have several mysql server in production evironment, and most of them when they have millions of rows, they all get MyIsam tables corrupted. One of the servers has ext2 filesystem with scsi harddrives, after the myisamchk -r it repairs the table, but after a few inserts it will corrupt

Re: New fork of MySQL

2001-11-09 Thread DownloadFAST.com
I will end my involvement in this thread, because I sense there is too much noise coming. If any one with good experience in the MySQL source code base would like to do some well paid, contracting work for me, please do not hesistate to email me privately. Thank you for your consideration of my

Still about MySQL Cluster

2001-11-09 Thread Ady Wicaksono
By using internal MySQL Replication, extra speed could be fetch by sending non-updates (INSERT, DELETE, UPDATE, ...) query to slave server BUT could MySQL engine do it transparently from user application ? If it can't, i suggest to insert this feature to TODO list -- ady -- email:

Re: OT: Default forced on MySQL;

2001-11-09 Thread Gordan Bobic
On Friday 09 Nov 2001 12:11, DownloadFAST.com wrote: Considering the features you want (IIRC you only mentioned the default values in tables) - why don't you try PostgreSQL instead? My understanding is it is much slower. That is what I am hoping for. Or rather, I am hoping that MySQL proves

Keeping SQL dbs separated

2001-11-09 Thread [EMAIL PROTECTED]
Hello, I have been asked by a guy to rewrite his web site presently written by somebody else using ASP/NT/IIS/MS Access (by some other webmaster who vanished). I said, yes, I could do it but with PHP/MySQL, because that's what I know, and even more important I only have Linux/Apache at home to

Re: Slooow InnoDB problem

2001-11-09 Thread Heikki Tuuri
Maciek, At 12:20 PM 11/9/01 +0100, you wrote: please show us the CREATE TABLE statements and what EXPLIN SELECT ... says about both table types. CREATE TABLE `stats_InnoDB` ( `id` int(10) unsigned NOT NULL auto_increment, `ident` char(100) NOT NULL default '', `class` int(2) unsigned

Re: Re: OT: Default forced on MySQL;

2001-11-09 Thread Gordan Bobic
On Friday 09 Nov 2001 12:08, you wrote: MySQL On Friday 09 Nov 2001 11:37, you wrote: Note on what is going on here... The paragraph below was from a private email I sent to Gordon. And now Gordon just responded to it on the public list. Gordon, I was strongly hinting to you in

??Sourcing in sections of a database create file

2001-11-09 Thread Tony
Years ago I worked on an RDBMS that had a feature to allow execution of 'sections' of a command file, avoiding others. I am still ign scanning the docs, but have not found anything similar in MySQL. For example, in a database creation table one could enter (in MySQL format) the following:

Faking MS Access on MySQL linux box

2001-11-09 Thread [EMAIL PROTECTED]
Hello, I have another question about the situation explained in my other message Keeping SQL DBs separated. If it's not possible reconfigure SQL on the ISP server, then I will have to test on Linux/Apache some PHP/MySQL pages that will have to access via ODBC a MS Access database on an

Getting alll Tables from all Databases/catalogs

2001-11-09 Thread Omkar
Hi, I am developing a application by using MySql database server. I have requierment in my application, that i need to know/show all the tables available in all the databases/catalogs of MySql. By using show tables from test i can get tables from test database. But I need to know all the tables

permissions for updating from one machine to another

2001-11-09 Thread Ari Davidow
I'm trying to set up a script for updating the tables on our production machine with work done on the test machine. The user that will be running the script, has SELECT privileges on the source database. What privileges does the user need for the target database? Can I get by with

Re: Keeping SQL dbs separated

2001-11-09 Thread Kodrik
The guy passed this request to the hosting company (which he doesn't want to change) and the answer is: if you *really* need to use PHP instead of ASP OK, but as far as MySQL is concerned we only have one customer using it now, and if we gave it to you too, then the two databases would be

Re: 127.0.0.1 problem

2001-11-09 Thread Eugene Mah
I would check the grant tables to see if host 127.0.0.1 has permission to access the DB. Even though they are the same thing, I don't know if mysqld treats them as the same thing. Eugene At 03:15 AM 11/09/2001 -0800, you wrote: Hello, Are there any obvious reasons why mysql -h localhost

Re: New fork of MySQL

2001-11-09 Thread Steve Meyers
In fact, I already emailed the developers yesterday, and asked if I could pay to have the particular feature I wanted prioritized at this time. Strange how open source developers don't always answer to the almighty dollar, eh? I asked kindly that you not turn this into a

How to Create Tables ... and Clients using winmysqladmin

2001-11-09 Thread ChandraShekarReddy Talakola
Hi, I am just install the mysql database and i start the system at dos prompt winmysqladmin i got the test tables with permissions and i have created my own database but iam unable to create table for that how can i create table and also i want create clients for my server and set the

Connection timeout and pooling

2001-11-09 Thread Sylvain Hamel
IDE : JBuilder 4 prof I am using pooling in order to optimize database access. When everybody leaves the office for the weekend all my connection timeout. This is expected except I would like my connection pool to be able to test connections before passing them back to the requester. Whats the

host.frm

2001-11-09 Thread Dominique Marant
Hello, I have to move a database from host with mysql 3.22.27 to a new host with mysql 3.23.36. After the install of mysql-3.23.36, I transfered the datadir that is running with the 3.23.36 on the new system and I restart mysqld. But the mysqld failed with error :

Re: Connection timeout and pooling

2001-11-09 Thread Christian Andersson
if you intend to use mysql you could send down for instance select 1 to the database.. but this is not database independent since not all databases might be albe to handle this type of query but it is application independent when using mysql. if you plan to use an other database some other form

Re: Beginner question - getting last inserted ID

2001-11-09 Thread Carl Troein
Anna Åhnberg writes: Thanks, I actually already found the chapters but now I also now how to use the function too! Let me quote from the manual: LAST_INSERT_ID([expr]) Returns the last automatically generated value that was inserted into an AUTO_INCREMENT column. mysql select

RE: run-all-tests always fails under reiserfs partition

2001-11-09 Thread George Eric R Contr AFSPC/CVYZ
Glad to here it. I hadn't tried it myself, but I heard that it helped under some circumstances. You'll take a small performance hit for the case where you're dealing with lots of small files I've heard. I haven't tried XFS. I Just installed RH7.2 on a box last weekend using the ext3

RE: Beginner question - getting last inserted ID

2001-11-09 Thread Johnson, Gregert
If you are using the Mark Matthews JDBC driver (MM.MySQL), there's another way to get the last insert id: instead of using a generic Statement object to execute the INSERT command, use an org.gjt.mm.mysql.Statement object. After executing an INSERT, the method getLastInsertID() will return

MYSQL/ASP empty recordset - why

2001-11-09 Thread John Harman
I have a strange problem, when I run the following SQL query: SELECT surname, Count(forename) FROM names GROUP BY surname; If I run this in a mysql DOS box I get a correct result showing the surnames and the appropriate number of people with that surname. If I run this same query through ASP,

Offtopic JDBC

2001-11-09 Thread Othmar Stehlik
Hi I run mySQl on a Win98 machine,and cant get a connection. My sql runs fine, but I can´t connect to the database. I use the path jdbc:mysql//localhost:3360/...and so on. On win2k everything worked fine. Please give an advice! Othmar -- GMX - Die Kommunikationsplattform im Internet.

ALTER Syntax Question

2001-11-09 Thread Brad Harriger
Is it legal to change a field name to the same name as in the following? ALTER TABLE t1 CHANGE a a INTEGER; Thanks, Brad This e-mail and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. This

Table corruption 4.0

2001-11-09 Thread moka
I am sending this mail in order to get things straight about table corruption which I am experiencing with 4.0(as well as previous versions). 1)System specs: PIII x1000MHz, 1GB RAM, HD 37GB SCSI, AHA29160N SCSI controller 2) Database MyISam tables, BUT 21000 tables in the database(this is

Re: Connection timeout and pooling

2001-11-09 Thread TAKAHASHI, Tomohiro
Hi, What is your Pooing Utility? Generally, JDBC Connection is TCP/IP's Socket. After the Socket has been disconnected, we can not detect it by JDBC interface. So, we have to detect it before we return a Connection to the client. Please see a source of my util class for Pooling,

Re: Offtopic JDBC

2001-11-09 Thread TAKAHASHI, Tomohiro
Hi, 3360? 3306? Please try "jdbc:mysql//localhost:3306/..." ^^ Thanks. Othmar Stehlik wrote: Hi I run mySQl on a Win98 machine,and cant get a connection. My sql runs fine, but I can$B%((Bt connect to the database. I use the path

Re: ALTER Syntax Question

2001-11-09 Thread John Barton
Sure is: http://www.mysql.com/doc/A/L/ALTER_TABLE.html John Barton [EMAIL PROTECTED] http://jbarton.technicalworks.net On Fri, 9 Nov 2001, Brad Harriger wrote: Is it legal to change a field name to the same name as in the following? ALTER TABLE t1 CHANGE a a INTEGER; Thanks, Brad

Re: Beginner question - getting last inserted ID

2001-11-09 Thread alec . cawley
Anna Åhnberg writes: Thanks, I actually already found the chapters but now I also now how to use the function too! Let me quote from the manual: LAST_INSERT_ID([expr]) Returns the last automatically generated value that was inserted into an AUTO_INCREMENT column. mysql

Re: Get real mysqld hostname

2001-11-09 Thread Dan Nelson
In the last episode (Nov 08), Mike Broxterman said: I'm looking for a programatic way to obtain the real FQDN of the myqld server, not the one used to connect to the server. Here's the scenario, several servers running mysqld are behind a virtual IP so when you connect to mysqld you do not

RE: MySQL Transaction Problem

2001-11-09 Thread David Woods
I'm sorry, but apparently I'm too green to be able to figure this out. You are right, when I do the SHOW CREATE TABLE, it tells me my table is MyISAM. If I use ALTER TABLE Episode TYPE=BDB;, it accepts the command but does not change the table type. I am using MySQLD-max-nt, which the manual

Large MySQL setup

2001-11-09 Thread Aaron Williams
Hello again list. I sent this message yesterday and wasn't able to get an answer. Just curious to see if any of the gurus out there care to share some insight on a mid-level MySQL setup, and can offer some starting points for learning how to troubleshoot the same. | Begin message: I have a

RE: Offtopic JDBC

2001-11-09 Thread Chris Newland
Hi Othmar, I'm sure its probably a typo in your message, but isn't the default port 3306 and not 3360? Also, isn't there a : after mysql? e.g. jdbc:mysql://localhost:3306/ If its not this then let me know and I'll try and suggest a solution. Best Regards, Chris -Original Message-

Re: Beginner question - getting last inserted ID

2001-11-09 Thread William R. Mussatto
On Fri, 9 Nov 2001, Carl Troein wrote: Date: Fri, 09 Nov 2001 15:41:21 GMT From: Carl Troein [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Beginner question - getting last inserted ID Anna Åhnberg writes: Thanks, I actually already found the chapters but now I also now how to

Re: Keeping SQL dbs separated

2001-11-09 Thread William R. Mussatto
Apache supports running cgi scripts as a designated user on a virtual host basis (only key is the files can be writable by ONLY the USER not his GROUP (toe badly stubbed making this mistake). However, why doesn't the isp create a separate mysql user for each client's database and restrict

Re: mysql corruption tables in production environment (Urgent)

2001-11-09 Thread Bill Adams
Rui Barreiros wrote: Hi, We have several mysql server in production evironment, and most of them when they have millions of rows, they all get MyIsam tables corrupted. One of the servers has ext2 filesystem with scsi harddrives, after the myisamchk -r it repairs the table, but after a few

Re: Large MySQL setup

2001-11-09 Thread joseph . bueno
Aaron Williams wrote: Hello again list. I sent this message yesterday and wasn't able to get an answer. Just curious to see if any of the gurus out there care to share some insight on a mid-level MySQL setup, and can offer some starting points for learning how to troubleshoot the same. |

Re: Large MySQL setup

2001-11-09 Thread Bill Adams
Aaron Williams wrote: The tables run upwards of around 13-15 gigs each. The nature of the data forces me to search the entire contents (looking for unique values) around 3000 times a day. The server is running Solaris 2.8, Do you have an index on the columns you are querying for unique

why index stops to work ?

2001-11-09 Thread wk
Hello mysql list, Could anybody explain why index stops to work in the query SELECT SUM(...) WHERE ... with encreasing the size of range, but continue to work in the analog query SELECT COUNT(*) WHERE ... ? See later: In the table ip_summary_d: PRIMARY KEY = (date,): mysql explain select

show processlist

2001-11-09 Thread Stuart Scamman
How do I show processlist from a specific computer, not everything ? Thanks.

Lots of Aborted Connections and Signal 11s

2001-11-09 Thread Jonathan Hilgeman
I run PHP 4.0.3 and MySQL 3.23.32. I get a fair amount of traffic and host about 1000 very small sites on a fairly fast server with plenty of RAM and space. However, it keeps shutting down frequently and every time it shuts down, the binary log files rotate, and someone will probably try to

RE: Mysql Innodb data files

2001-11-09 Thread Demirchyan Oganes-AOD098
Hello everyone, I have a question with regards to the InnoDB data files. I have the following in my.ini file. innodb_data_file_path = ibdata1:200M innodb_data_home_dir = c:/innodb_data I just want to know the following. Does it mean that I have 200Mb allocated space to store all the InnoDB

Re: show processlist

2001-11-09 Thread Bill Adams
Stuart Scamman wrote: How do I show processlist from a specific computer, not everything ? Thanks. mysqladmin processlist |grep 'the.host.you.care.about' -- Bill Adams TriQuint Semiconductor - Before posting, please

Re: why index stops to work ?

2001-11-09 Thread Carl Troein
wk writes: Could anybody explain why index stops to work in the query SELECT SUM(...) WHERE ... with encreasing the size of range, but continue to work in the analog query SELECT COUNT(*) WHERE ... ? Well, I can imagine that the optimizer chooses not to use the index for SUM() a lot

Mysql -server conflicts error

2001-11-09 Thread Ouyang, Sunny
Hi All, I tried to upgrade mysql database from mysql-server-3.23.36-1 to mysql-3.23.43-1. However, when I downloaded and used rpm -i MySQL-3.23.43-1.i386.rpm I received the following error: error: failed dependencies: MySQL conflicts with mysql-3.23.36-1 MySQL -server conflicts

Re: Large MySQL setup

2001-11-09 Thread Aaron Williams
Joseph Bueno wrote: Hi, If you run a single query, MySQL will use only one processor. MySQL multithreading allows you to run multiple queries in parallel, one query per thread. Right, that I understand. Even while running up to 30 queries it pegs the first CPU at max, and no other CPUs are

RE: How to Create Tables ... and Clients using winmysqladmin

2001-11-09 Thread Venu
Hi Shekar, -Original Message- From: ChandraShekarReddy Talakola [mailto:[EMAIL PROTECTED]] Sent: Friday, November 09, 2001 6:50 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: How to Create Tables ... and Clients using winmysqladmin Hi, I am

RE: MySQL Transaction Problem

2001-11-09 Thread David Woods
I got it figured out, sort of. My machine was not loading the version of MySQL I thought it was. Now it is, and I have BDB support. My rollbacks now work. Thanks for the help. David -Original Message- From: David Woods [mailto:[EMAIL PROTECTED]] Sent: Friday, November 09, 2001 10:25

RE: Mysql Innodb data files

2001-11-09 Thread Norman L. Smith
From: Demirchyan Oganes Hello everyone, I have a question with regards to the InnoDB data files. I have the following in my.ini file. innodb_data_file_path = ibdata1:200M innodb_data_home_dir = c:/innodb_data I just want to know the following. Does it mean that I have 200Mb

Duplicate column names

2001-11-09 Thread Brad Harriger
How does MySQL handle duplicate column names? This e-mail and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. This communication may contain material protected by legal privileges or statutory

How does authentication works with MYSQL??????

2001-11-09 Thread Siomara Pantarotto
Can someone PLEASE explains how MySQL does authentication remotely After installing MYSQL I created a user root with xyzxyz password. The database allowed that. When I connect Mysql, via java codes, from the same machine it works perfectly. When I connect Mysql, via java codes, from a

How does authentication works with MYSQL??????

2001-11-09 Thread Christopher Book
Look at the 'grant' commands in the mysql manual. You have to setup permissions if you want other hosts (other than localhost) to work, by assigning permissions to all domains or a list of ips or something. Its pretty complicated, but if you just want to give one user access from anywhere its

Solaris 8 Mysql-3.23.44

2001-11-09 Thread Keith W
Has anyone been able to get mysql-3.23.44 running on the Sparc platform Solaris 8? I've tried both binary and source distro's with no luck. I've made the recomended changes from the Readme's and Install files as well as searched google high and low. I still get the same failures. From the

question

2001-11-09 Thread Wells, Kenneth L
How can I fix this? Database: mysql_error:Host 'localhost.localdomain' is not allowed to connect to This mysql server Fatal Error, Quitting.. Snort: no process killed - Before posting, please check:

Re: New fork of MySQL

2001-11-09 Thread Shankar Unni
Steve Meyers wrote: The MySQL source is under the GPL. Any fork must also be under the GPL. You may sell your forked MySQL, but you must also provide the source code. Is it really, now? What are the rules about bundling now? If we distribute a (standalone) copy of MySQL with our

Re: Solaris 8 Mysql-3.23.44

2001-11-09 Thread Aaron Williams
Has anyone been able to get mysql-3.23.44 running on the Sparc platform Solaris 8? I've tried both binary and source distro's with no luck. I've made the recomended changes from the Readme's and Install files as well as searched google high and low. I still get the same failures. I went to

Re: OT: Default forced on MySQL;

2001-11-09 Thread Shankar Unni
DownloadFAST.com wrote: [...] why don't you try PostgreSQL instead? My understanding is it is much slower. No kidding? Why don't you fork the PostGreSQL codebase and apply your special assembly talents to speed it up by 50% or even 60%?

Re: question

2001-11-09 Thread Mikel King
Check your grants table in the mysql db...make sure you have given yourself permission to user said db from the specified host as that user... Wells, Kenneth L wrote: How can I fix this? Database: mysql_error:Host 'localhost.localdomain' is not allowed to connect to This mysql server Fatal

Duplicate column names

2001-11-09 Thread Christopher Book
How does MySQL handle duplicate column names? You can't create two columns with the same name in one table. If you have a query that combines multiple tables, you reference them with the table name: ie select a.id, b.id as otherid from a, b where Chris

How to improve FTI speed?

2001-11-09 Thread Gordan Bobic
Hi. I've just set up my prototype so I can benchmark comparatively tthe profmance between PostgreSQL and MySQL. There's good news, and there's bad news. The good news is - MySQL is faster by about 2 times. The bad news is - MySQL is ONLY faster by about 2 times. Now, I DO understand that

Re: New fork of MySQL

2001-11-09 Thread Carl Troein
Shankar Unni writes: What are the rules about bundling now? If we distribute a (standalone) copy of MySQL with our product, does that expose our product to the GPL? Or is it just like distributing a copy of Emacs with your OS? (I.e. as long as you make the source available, it doesn't

Re: Duplicate column names

2001-11-09 Thread Steve Werby
Brad Harriger [EMAIL PROTECTED] wrote: How does MySQL handle duplicate column names? Kind of open ended, but I'll give it a shot. MySQL doesn't allow duplicate column names within a table, but if you are referring to a query accessing multiple tables containing fields with the same name then

RE: New fork of MySQL

2001-11-09 Thread Ravi Raman
hi. regarding 'bundling' GPL products with commercial ones: http://www.gnu.org/licenses/gpl-faq.html#GPLInProprietarySystem to summarize, it's okay, if it's done properly. hth. -ravi. -Original Message- From: Shankar Unni [mailto:[EMAIL PROTECTED]] Sent: November 9, 2001 2:24 PM To:

RE: New fork of MySQL

2001-11-09 Thread Wells, Kenneth L
I get the error 'Host 'emdtest.ncr.com' is not allowd to connect to this MySQL database server' How do I correct this??? - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: New fork of MySQL

2001-11-09 Thread Carl Troein
Wells, Kenneth L writes: I get the error 'Host 'emdtest.ncr.com' is not allowd to connect to this MySQL database server' whine First of all, I must ask you why you've posted this under a thread about forking off MySQL. This makes little sense to me. Secondly, since you just posted the same

RE: New fork of MySQL

2001-11-09 Thread massey
http://www.mysql.com/doc/G/R/GRANT.html You need to GRANT 'emdtest.ncr.com' permission to connect or a user from any box to connect with a user name and password. mysql GRANT ALL PRIVILEGES ON *.* TO kenneth@% IDENTIFIED BY 'some_pass' WITH GRANT OPTION; means kenneth can connect

Re: OT: Default forced on MySQL;

2001-11-09 Thread Kodrik
No kidding? Why don't you fork the PostGreSQL codebase and apply your special assembly talents to speed it up by 50% or even 60%? If you're willing to pay for quality, Oracle is an obvious choice. It's fast, it has all the features, there are numerous advanced tools to manage and develop your

Re: Licensing question

2001-11-09 Thread Arjen G. Lentz
Hi Shankar, - Original Message - From: Shankar Unni [EMAIL PROTECTED] What are the rules about bundling now? If we distribute a (standalone) copy of MySQL with our product, does that expose our product to the GPL? Or is it just like distributing a copy of Emacs with your OS? (I.e.

Newbie MySQL Install Question

2001-11-09 Thread Dan Tappin
I have some experience with MySQL on MacOS X but that was with a pretty GUI installer. I am now trying to get MySQL installed on Redhat 7.0. I download the client and server versions and followed the install procedures. The problem I am having is with mysqladmin. The docs state that you need

Re: Newbie MySQL Install Question

2001-11-09 Thread Kelley Reynolds
Make sure that the mysql server has been started. - Original Message - From: Dan Tappin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 09, 2001 4:07 PM Subject: Newbie MySQL Install Question I have some experience with MySQL on MacOS X but that was with a pretty GUI

Re: Newbie MySQL Install Question

2001-11-09 Thread Bill Adams
Dan Tappin wrote: I have some experience with MySQL on MacOS X but that was with a pretty GUI installer. I am now trying to get MySQL installed on Redhat 7.0. I download the client and server versions and followed the install procedures. The problem I am having is with mysqladmin. The

Re: New fork of MySQL

2001-11-09 Thread Paul Smith
%% Shankar Unni [EMAIL PROTECTED] writes: su Who can answer these questions? Well, the obvious place to look is the MySQL web site, http://www.mysql.com Click Products, then click MySQL Licensing Policy. -- ---

RE: Newbie MySQL Install Question

2001-11-09 Thread Dan Tappin
I tried that but it came back with a 'mysqld is running already' error. Side Question: How can I allow a SSH connection from a remote machine? My linux box is in a locked server room and I would like to administer it from my office via a terminal. I tried via SSH from my MacOS X laptop but I

RE: Newbie MySQL Install Question

2001-11-09 Thread Dan Tappin
How do I double check? LSOF? I tried that but I can't get the option right? Side Question: How can I allow a SSH connection from a remote machine? My linux box is in a locked server room and I would like to administer it from my office via a terminal. I tried via SSH from my MacOS X laptop

Re: Solaris 8 Mysql-3.23.44

2001-11-09 Thread Michael Stassen
Keith, It's a little hard to help, since you didn't provide the details of your attempt to install from source. (Compiler? command line for configure? ...) Searching Google groups on 'mysql solaris cross compiling', I found numerous related threads. It appears that everyone who reported this

RE: Newbie MySQL Install Question

2001-11-09 Thread Dan Tappin
Port 3306 is open on the machine. Dan -Original Message- From: Kelley Reynolds [mailto:[EMAIL PROTECTED]] Sent: Friday, November 09, 2001 2:07 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Newbie MySQL Install Question Make sure that the mysql server has been

Re: Newbie MySQL Install Question

2001-11-09 Thread Bill Adams
Dan Tappin wrote: I tried that but it came back with a 'mysqld is running already' error. Actually your command is wrong. If you never set the password before it should be (without the -p): mysqladmin -u root password your?new.password note that 'password' IS the command. Side Question:

RE: Newbie MySQL Install Question

2001-11-09 Thread Wells, Kenneth L
I'm getting the sazme exact error, can anyone help us?? -Original Message- From: Kelley Reynolds [mailto:[EMAIL PROTECTED]] Sent: Friday, November 09, 2001 4:07 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Newbie MySQL Install Question Make sure that the mysql server has

RE: Newbie MySQL Install Question

2001-11-09 Thread Dan Tappin
DOH! :^) Thanks for the tips. Dan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bill Adams Sent: Friday, November 09, 2001 2:26 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Newbie MySQL Install Question Dan Tappin wrote:

Re: Active maintenance of 3.23 tree

2001-11-09 Thread Arjen G. Lentz
Hi, - Original Message - From: DownloadFAST.com [EMAIL PROTECTED] To: Ben Gollmer [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Or does MySQL actively support, debug, fix, and go back and maintain older releases? That is indeed the case. The 3.23 and 4.0 branches co-exist, and we still do

Re: Newbie MySQL Install Question

2001-11-09 Thread Carl Troein
Dan Tappin writes: I tried that but it came back with a 'mysqld is running already' error. /me silently curses the bad quoting habits that Lookout causes, but knows what the thread was about, and so _please disregard_ this sentence unless you know what I'm talking about. Now where was I? Oh,

RE: Newbie MySQL Install Question

2001-11-09 Thread Dan Tappin
Ok that worked... but now my SQL utility program returns a 'Host 192.168.0.74 (my local IP) is not allowed to connect to this MySQL server' I assume that I need to get into the grant tables. Is this just via mysqladmin -u root -p??? Thanks, Dan -Original Message- From: [EMAIL

Re: New fork of MySQL

2001-11-09 Thread Paul DuBois
At 7:45 PM + 11/9/01, Carl Troein wrote: Shankar Unni writes: What are the rules about bundling now? If we distribute a (standalone) copy of MySQL with our product, does that expose our product to the GPL? Or is it just like distributing a copy of Emacs with your OS? (I.e. as long as

Re: Solaris 8 Mysql-3.23.44

2001-11-09 Thread Keith W
Actualy I did provide the things you mention. By stating that I've done all that was suggested in the Readme and Install documentation. That includes the compiler type and version etc and flags. On Fri, 9 Nov 2001, Michael Stassen wrote: Keith, It's a little hard to help, since you didn't

  1   2   >