Fw: java.sql.SQLException: [TCX][MyODBC] Access denied for user...(Using password: No) message

2001-07-19 Thread Venu Anuganti
-- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Venu Anuganti [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Redwood city, California USA ___/

Re: Can't initialize InnoDB as 'innodb_data_file_path' Problem

2001-07-19 Thread Sunento Wu
Thanks Ken ! - Original Message - From: Ken Sommers [EMAIL PROTECTED] To: Sunento Wu [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, July 19, 2001 1:45 PM Subject: Re: Can't initialize InnoDB as 'innodb_data_file_path' Problem Better read the manual:

RE: mysql.org

2001-07-19 Thread Martin Jeremic
First, I support mySQL and Open Source community. Maybe you can fight them with their own weapon. They have made some extra applications based on mySQL, and they sell it. You can create same applications as Open Source. -

Re: Transaction for MySQL

2001-07-19 Thread Michael Tam
Hi everyone, Would someone help me out with these questions? I know these may be something obvious/ in the manual .. etc but I would like to have someone showing me if I am on the right track and maybe share some of these in greater detail. Greatly appreciated. Regards, Michael

Re: MySQL or MS SQL?

2001-07-19 Thread Bernhard Doebler
Hi, the question is what operating system you are going to use. If your DB gets to large you will have problems not with tha database but with the filesystem. Best Regards Bernhard - Original Message - From: Alexander Chernienko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent:

RE: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message

2001-07-19 Thread shane
Hi, the driver which i am using is type IV. do i still need to install myodbc? thks -Original Message- From: Venu Anuganti [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 19, 2001 2:04 PM To: shane Cc: [EMAIL PROTECTED] Subject: Re: java.sql.SQLException: [TCX][MyODBC] Access denied for

Bug in Mysql access rights ?

2001-07-19 Thread BAUMEISTER Alexandre
Bonjour, I have a problem with Mysql-3.23.39 and users access rights. It's the second time I notice this problem since I installed .39 on two of my servers. But yesterday, the bug was even more flagrant. I had a user which had all rights on a database when connecting from

Re: innodb and raw disks

2001-07-19 Thread Peter Duffy
Christian Jaeger wrote: Just to the record: I've written a small program too, and it reports correct sizes for normal disk devices under both linux 2.2 and 2.4, as long as the partition sizes don't exceed the 2GB limit (I don't have large file support, since I use debian potato with just

Re: Transaction for MySQL

2001-07-19 Thread alec . cawley
Would someone help me out with these questions? I know these may be something obvious/ in the manual .. etc but I would like to have someone showing me if I am on the right track and maybe share some of these in greater detail. Greatly appreciated. Since the experts are too busy,

RE: mysql error

2001-07-19 Thread Adrian D'Costa
Hi, Thanks. After sending my mail I found out that the mysqld was not running. Now it is fine. Thanks once again Adrian On Tue, 17 Jul 2001 [EMAIL PROTECTED] wrote: as opposed to using safe_mysqld try starting mysql using /etc/init.d/rc.d/mysql start and stopping using

re-compile mysql to use multiple character sets (again)

2001-07-19 Thread Pjotr Nyikolajevics Szekszardi
Hi, I have configured mysql using the parameter --with-charset=latin2, made some databases and tables full of latin2 text. Now I have to add another database, which will store text in latin1. As I red the articles related to these problems, if I understand well, I have to do the followings: -

Re: Running multiple MySQL servers on one machine

2001-07-19 Thread Jeremy Zawodny
On Mon, Jul 16, 2001 at 12:40:24PM +1000, William Chi wrote: Hi, I was wondering if anyone has any opinions on the advantages and disadvantages of running multiple servers on one machine. Each server would be used to access different databases. Off the top of my head, since I haven't seen

select

2001-07-19 Thread Nicolas W
Hello, I'd like to do a query with the following form: select * from (select ...) ... But it doesn't work. Is it possible to do something like that with mysql and maybe with another syntax? Thanx Nico. - Before posting,

Win32 - replication - Error 1133

2001-07-19 Thread BALU Frédéric
Hi everybody, I use Replication on a windows NT4 Server. There are 1 master and 2 slaves, all on the same machine. One slave is started with the option skip-name-resolve, not the other. For the 2 slaves : master-host=localhost When adding a user (MYSQL.User), the replication is OK but,

Re: Bug in Mysql access rights ?

2001-07-19 Thread Sinisa Milivojevic
BAUMEISTER Alexandre writes: Bonjour, cut What's happening ? Regards, Alex. Your story is quite strange. Can you run SHOW GRANTS on both user@localhost and user@remoteIP and see what they are showing ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr.

Re: Running multiple MySQL servers on one machine

2001-07-19 Thread ryc
I think the main disadvantage would be the memory... Running two servers means it would use twice the amount of memory... So say you are using 256mb for the key cache... running two servers would use 512mb (not the exact moment the servers start but after a prolonged period of time of course).

Re: Info needed! -- urgent!!

2001-07-19 Thread Asha Ramaiah
The following doesn;t make sense... I need the resultset comprising the list of all the tables in the db...and i wat that as a java.sql resultset...can somebody help me here!???urgent!! java code : String sqlQuery = show tables; try { con = ConnectionPoolManager.getConnection();

unique and null values

2001-07-19 Thread Aek
back to my unique constraint again :) i asked on irc but couldnt get anything out of them so i came here. got a unique constraint with serveral columsn like so.. UNIQUE (col1,col2,col3) id like to have col2 and col3 to use null values but it doesnt seem to like this. Is there a way i can use

configure problem

2001-07-19 Thread TomC
I get the following error: checking return type of sprintf... configure: error: can not run test program while cross compiling when I type ./configure in the source directory of mysql-3.23.39 so I can't install mysql. Why? Thanks

Re: query.preview() stored in an edit box

2001-07-19 Thread Sinisa Milivojevic
Örjan Björk writes: Hi, I recently downloaded mysql++ and the tutorial that came with it. Unfortunately they used cout in the examples... they used the following code coutquery.preview(); and that worked great but... How do I get the result back as a string which I can store in a CString

Re: Transaction for MySQL

2001-07-19 Thread Ilya Martynov
MT 1) which one should I use InnoDB or BDB? what kind of advantages MT given by each type? I'm not expert but AFAIK BDB databases doesn't work well (i.e. fast) if they don't fit fully in RAM. Another important thing: InnoDB provides row-level locking while BDB only page-level locking. Thus it

Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fields

2001-07-19 Thread Sergei Golubchik
Hi! On Jul 19, Carsten Gehling wrote: Finally I was able to produce a complete step-by-step to corrupt the index ;-) mysql insert into visitkort (kategori_id) values (108); mysql select last_insert_id(); mysql update visitkort set navn = 'test5' where id = 1; mysql update visitkort set

Re: Re[2]: Bug in Mysql access rights ?

2001-07-19 Thread Sinisa Milivojevic
BAUMEISTER Alexandre writes: Sinisa, xut mysql show grants for news@'192.168.1.%'; ++ | Grants for [EMAIL PROTECTED]% |

date_format doesn't work correct

2001-07-19 Thread Florian Schmidt
Hi! i've mysql-3.23.39-nt on winnt with a client running under SCO 3.2 i've a simple querry with date_format in it, but date_format isn't doing what i expect... sql_string: select date_format(c.hour, '%Y%m%d%H'), c.hour from count c c.hour is DATETIME okay, i see this output on my

Re[4]: Bug in Mysql access rights ?

2001-07-19 Thread BAUMEISTER Alexandre
Sinisa, mysql show grants for news@'192.168.1.%'; ++ | Grants for [EMAIL PROTECTED]% |

inheritance of privileges?

2001-07-19 Thread Johan Nilsson
Privileges question: I have a user in mysql.user and he has among each other DROP privileges, but if he creates a database and some tables in it, he can query a DROP table but can't run a DROP script... then he gets Permission denied, but if I add him to the mysql.db table for this database with

help, cant unsibscribe

2001-07-19 Thread Kenneth Johansen
sql - ignore. yesterday i sent an email to: [EMAIL PROTECTED] to get unsibscribed, but today i discovered that it didnt work. So i tried http://lists.mysql.com/php/unsubscribe.php After a while i got an auth code and a link. when i checked the link it said that i wasnt subscribing to [EMAIL

Re[6]: Bug in Mysql access rights ?

2001-07-19 Thread BAUMEISTER Alexandre
Sinisa, | GRANT USAGE ON *.* TO 'news'@'192.168.1.%' IDENTIFIED BY PASSWORD '' | | GRANT SELECT ON cotations.* TO 'news'@'192.168.1.%' | | GRANT SELECT, INSERT, UPDATE, DELETE ON contenu.* TO 'news'@'192.168.1.%' | |

Re: Re[6]: Bug in Mysql access rights ?

2001-07-19 Thread Sinisa Milivojevic
BAUMEISTER Alexandre writes: Sinisa, | GRANT USAGE ON *.* TO 'news'@'192.168.1.%' IDENTIFIED BY PASSWORD '' | | GRANT SELECT ON cotations.* TO 'news'@'192.168.1.%' | | GRANT SELECT, INSERT, UPDATE, DELETE ON contenu.* TO

RE: date_format doesn't work correct

2001-07-19 Thread Florian Schmidt
At 09:25 19.07.2001 -0400, you wrote: Probably due to timezone setting differences between the two client machines. i also thought about that, but there are 2 DAYs difference... can this be a timezone issue ? okay, i see this output on my sco-machine: '2001071614' '2001-07-19 14:00:00' if i

Re: inheritance of privileges?

2001-07-19 Thread Sinisa Milivojevic
Johan Nilsson writes: Privileges question: I have a user in mysql.user and he has among each other DROP privileges, but if he creates a database and some tables in it, he can query a DROP table but can't run a DROP script... then he gets Permission denied, but if I add him to the mysql.db

Re: stability of freebsd 4.3, gcc 2.95.3

2001-07-19 Thread Ken Menzel
Hi Allen, Has anyone had unfavourable experiences with FreeBSD 4.3-STABLE, gcc 2.95.3, and libmysqlclient_r.so.10 (from MySQL 3.23.39), and POSIX threads? When you say POSIX threads, I am alittle confused, Do you mean native threads? What are you configuration options. My systems are very

Re: Re[4]: Bug in Mysql access rights ?

2001-07-19 Thread Sinisa Milivojevic
BAUMEISTER Alexandre writes: Sinisa, | GRANT USAGE ON *.* TO 'news'@'192.168.1.%' IDENTIFIED BY PASSWORD '' | | GRANT SELECT ON cotations.* TO 'news'@'192.168.1.%' | | GRANT SELECT, INSERT, UPDATE, DELETE ON contenu.* TO

Re: FreeBSD issues - suggested fixes

2001-07-19 Thread Ken Menzel
Hi Michael, I would be very happy to help. I will however be away for the next 5 days, but there are other FreeBSD users on the list. I think the biggest help would be for one of us FreeBSD users to update the manual with all the latest information (I will try to do that late next week if

RE: date_format doesn't work correct

2001-07-19 Thread Florian Schmidt
At 09:40 19.07.2001 -0400, you wrote: You're correct, likely not a timezone problem. Have you confirmed that the clocks on these machines are synchronized? That they aren't really three days off? yep, again and agein :) the clocks are in sync +/- 5 secs okay, i see this output on my

Re: mysql.org

2001-07-19 Thread Bob Hall
On Wed, Jul 18, 2001 at 11:10:20AM -0700, Michael Collins wrote: It seems to me that the bottom line is that any outcome that results in there being a fork in the development of MySQL (with the result being two completely different types of MySQL), or in NuSphere retaining control of the

Re: Inno DB question

2001-07-19 Thread Heikki Tuuri
Stanislav, how big is the insert and update load to your table? One user of InnoDB says that it copes with his average load of 800 inserts/updates per second. The computer has 4 processors. Since InnoDB has the non-locking consistent read, SELECT queries do not stop inserts or updates to your

remote connection with phpMyAdmin

2001-07-19 Thread [EMAIL PROTECTED]
Hi everybody, I've installed MySQL 3.23.38 on a RedHat 6.0 system with php 3.0.18. When I want to connect to the server with phpMyAdmin, it returns the following message : Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

problems with a command table

2001-07-19 Thread Volker Streppelmann
Hello, my problem as follows: I have installed MySQL and MyODBC. Under a Database I have created a table called SQLLIB and a Table called SQLERR. SQLLIB contains a Field SQLNAME and SQLCOMMAND. For example it contains NumEntry for SQLNAME and SELECT COUNT(*) FROM SQLERR for SQLCOMMAND.

Re: innodb and raw disks

2001-07-19 Thread Peter Duffy
database table sql query OK, here's where I've got to. 1) After fiddling about with fdisk, disk geometry and kernel boot parms, I've managed to define a partition which appears to lseek as exactly 1000M (this was fairly horrible: if anyone wants to replicate this step, I'll go over the

Re: mysql.org

2001-07-19 Thread Brooklyn Linux Solutions CEO
the same time, a NuSphere-controlled mysql.org doesn't strike me as a disaster, provided they can do it with out shooting themselves in the foot, as they are doing now. Nah There using it as a marketing ploy to dup the public. The should have released their GPLed extentions on

List problems?

2001-07-19 Thread Bryan Coon
Is there a mysql newsgroup somewhere? Or some other forum? I am the kind of user that has one question every couple weeks or so, and rather than fill up my mailbox, I prefer to subscribe, ask my question and then unsubscribe. This works well with other services, but it takes me (no

MySQLBug - Script mysql_install_db Empty

2001-07-19 Thread Wu, Steve
I am evaluating MySQL on a Solaris8 Intel machine, and followed your instruction for the installation. I used GNU tar to unzip the files into /usr/local/mysql-3.23.39-pc-solaris2.8-i386. There was no error in the tar process of the downloaded file. However, in the

gemini tables in mysql

2001-07-19 Thread Pete Kuczynski
Hi, since Nusphere release the source code for gemini yesterday I believe it was, I was wondering if Mysql AB was going to incorporate it into a future release if it's database. I realise in light of recent .org events Pete -- ___ Pete Kuczynski Sr.

Re[2]: Inno DB question

2001-07-19 Thread BAUMEISTER Alexandre
Stanislav, HT I have a question about using InnoDB format of tables with MySQL. HT We have a following problem: HT our application collects data into MySQL database during some period of time HT (say 1 hour) and then we need to analyze these data then move insert results HT of analysis into

SV: Bug report: FULLTEXT index corrupts the index with too many TEXT fields

2001-07-19 Thread Martin Larsen
Hi! On Jul 19, Carsten Gehling wrote: Finally I was able to produce a complete step-by-step to corrupt the index ;-) mysql insert into visitkort (kategori_id) values (108); mysql select last_insert_id(); mysql update visitkort set navn = 'test5' where id = 1; mysql update

INNER JOIN Problem

2001-07-19 Thread Bob Horton
Hi, I'm trying to do an INNER JOIN in MySQL (3.23.39 - Linux i686) that works perfectly when I test it in Access but MySQL is complaining and the web docs seem to suggest I'm doing it right. Can anyone see the error? I've got indexes on both tables on the joined field (Primary for

Re: List problems?

2001-07-19 Thread Jeremy Zawodny
On Thu, Jul 19, 2001 at 09:06:19AM -0700, Bryan Coon wrote: Is there a mysql newsgroup somewhere? Or some other forum? I am the kind of user that has one question every couple weeks or so, and rather than fill up my mailbox, I prefer to subscribe, ask my question and then unsubscribe.

MySQL GUI Client

2001-07-19 Thread Adam Douglas
Hi, I just downloaded the MySQL GUI Client and was trying to set it up. The client keeps saying Access denied for user: 'adouglas@' (Using password: YES). I've typed in the Host Name (IP Address) and have the proper user name. Also I have the proper grant tables set for adouglas to access it from

Re: mysql.org

2001-07-19 Thread Marten Mickos
Dear folks at NuSphere, Thank you for your response to our open invitation. We disagree with a number of your statements, but we look forward to having a phone contact with you on Friday. Marten Mickos (database,sql,query,table)

blob question

2001-07-19 Thread Pete Kuczynski
Hi, I'm new to blobs. I want to create a seperate table that will hold blob's or pictures. Each picture will be a .gif and will not exceed 100k in size. each image will be called, ord.gif, bar.gif, cmi,gif, lax.gif, jfk.gif, ord.gif, etc. The questions I had were 1. what would the create

Re: MySQLBug - Script mysql_install_db Empty

2001-07-19 Thread Steve Brazill
What about the version of the file which should be in /usr/local/mysql-3.23.39-pc-solaris2.8-i386/bin ?? (which is the one you should be running from the 'mysql' directory as ./bin/mysql_install_db ) - Original Message - From: Wu, Steve [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Sfikas,

UPDATEing values in SET columns

2001-07-19 Thread Nick Brandon
Hi I have been searching through the manual and the list archives for the last few days regarding a problem I have with the SET column type. I'm creating an app that uses a SET column as 'flags'. Different parts within the application will check to see if certain 'flags' are enabled. As I

Backup of databases.

2001-07-19 Thread Tomas Norre
Hello there. I have a problem.. i cannot start my mysqld server on my Unix OpenBSD 2.9 Server, because i have a problem after i have restarted my server. So how do i take backups without connecting to the mysqld server, i have access to the files that is placed in /var/mysql but i cannot you

Re: blob question

2001-07-19 Thread Werner Stuerenburg
Generally, it is not advised to add pictures to tables. See http://www.bitbybit.dk/mysqlfaq/faq.html#storing_images We had this question here some days ago, so it may ge a good idea to discuss at length possible problems why people won't like this approach of storing pics as files. WARNING:

Re: MySQL question

2001-07-19 Thread MIKE TURNER
I thought about that after I sent it. First I will start with what my OS is. I am running Redhat 7.1. Kernel version 2.2.16-22(I believe). I used the i386 release. I did a rebuild of the src.rpm. then installed the rpm. I tried to set the root password as it told me but it said something like

Re: UPDATEing values in SET columns

2001-07-19 Thread Werner Stuerenburg
I would take another approach. table 1 has only user_id table 2 has flag values and key user_id So you just insert rows or delete them in table 2. That's it. Did I understand your problem? Sie schrieben am Donnerstag, 19. Juli 2001, 20:24:17: Hi I have been searching through the manual and

Re: blob question

2001-07-19 Thread Pete Kuczynski
Thanks, regarding the PHP info. What I need to know is: 1. what would the create table statment look like in Mysql. 2. Should I use a longblob based on my 100k .gif size? 3. Is one column with the gifs enough. Or should I add a autoincremented primary key? 4. Is it better to have a

Re: MySQL GUI Client

2001-07-19 Thread Stefan Hinz
Hi Adam, client keeps saying Access denied for user: 'adouglas@' (Using password: YES). Suggestion: Try: GRANT ALL ON *.* TO adouglas@localhost IDENTIFIED BY your_password This will grant you access from localhost, i. e. the client tool (e. g. MySQL Monitor, mysql.exe, or PHP script, or

Re: innodb and raw disks

2001-07-19 Thread Christian Jaeger
At 15:08 Uhr +0100 19.7.2001, Peter Duffy wrote: database table sql query I guess that it's thinking the tablespace is already initialised. Yes, probably: it's the same if you have an ibdata file and no log files and start mysql-innodb. I've noticed this while setting up innodb with filesystem

RE: mysql.org

2001-07-19 Thread Sander Pilon
the same time, a NuSphere-controlled mysql.org doesn't strike me as a disaster, provided they can do it with out shooting themselves in the foot, as they are doing now. Nah There using it as a marketing ploy to dup the public. The should have released their GPLed extentions

Re: UPDATEing values in SET columns

2001-07-19 Thread Stefan Hinz
Dear Nick, I dislike SET and ENUM as they are not SQL standard (tell me if I am wrong). They may be fast because of the bitwise storage of data. But both column types mangle DDL with DML, and that's where problems arise, like yours. Suggestion: Better go the straight way, i. e. put those flags

Re: blob question

2001-07-19 Thread Werner Stuerenburg
What I need to know is: 1. what would the create table statment look like in Mysql. DROP TABLE IF EXISTS pictures; CREATE TABLE pictures ( id mediumint(4) NOT NULL auto_increment, comment text NOT NULL, width smallint(6) DEFAULT '0' NOT NULL, height smallint(6) DEFAULT '0' NOT

Re: Backup of databases.

2001-07-19 Thread Werner Stuerenburg
i cannot start my mysqld server on my Unix OpenBSD 2.9 Server, because i have a problem after i have restarted my server. So how do i take backups without connecting to the mysqld server, i have access to the files that is placed in /var/mysql but i cannot you mysqldump because of the

Please help - does changing the port the web server listens on affect mysql?

2001-07-19 Thread chip . wiegand
I am having a problem with inserting data into a table via a web form, which was working just fine prior to changing the port the web server is listening on from 80 to 8080. I can insert data via the mysql command line just fine, just not from the web form. Below are the forms and table def for

RE: UPDATEing values in SET columns

2001-07-19 Thread Don Read
On 19-Jul-2001 Nick Brandon wrote: Hi I have been searching through the manual and the list archives for the last few days regarding a problem I have with the SET column type. I'm creating an app that uses a SET column as 'flags'. Different parts within the application will check to see

RE: UPDATEing values in SET columns

2001-07-19 Thread Don Read
On 19-Jul-2001 Nick Brandon wrote: Hi I have been searching through the manual and the list archives for the last few days regarding a problem I have with the SET column type. I'm creating an app that uses a SET column as 'flags'. Different parts within the application will check to see

Questions about extremely large database support

2001-07-19 Thread Tom Wheeler
We are beginning a project and need to choose a database. We have been using MS Visual FoxPro, which is like mySQL in that it is very fast and ISAM-based, but is used more often as a file database rather than client/server. Unfortunately, we are quickly approaching FoxPro's 2GB table size

Binlog has bad magic number [SOLVED]

2001-07-19 Thread Jim Ziegler
For me, this problem was due to: This problem occurs when the my.cnf file on the master contains log-bin=/var/log/replication.log but just log-bin seems to work. On Mon, Apr 02, 2001 at 05:11:21PM -0400, Jim Ziegler wrote: What causes: 010402 17:08:56 Error reading packet from server:

replication-magic number-fire your magician

2001-07-19 Thread Jim Ziegler
Description: I am unable to get replication running. I have set up both master and slave systems with version 3.23.33-log of musql. I can do a load table from master but when I start the slave, all I get in the slave log is: 010410 16:37:24 Slave: Failed reading log event, reconnecting to

Re: Please help - does changing the port the web server listens on affect mysql?

2001-07-19 Thread Jeremy Zawodny
MySQL knows nothing of the ports that your Web server may listen to. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 -- NEW MySQL 3.23.29: up 33 days, processed 260,996,108 queries (90/sec. avg)

Re: mysql.org

2001-07-19 Thread Brooklyn Linux Solutions CEO
Fact MYSQL owns their trademark Fact, what NuShpere brought form MYSQL is irrelevant as loing as they are infrringing on the MYSQL Trademark...and they were going to do WORSE until the public heat. Until they apologies fo the GPL violation, and then the Trademark infringment, they are pound

Re: Questions about extremely large database support

2001-07-19 Thread Werner Stuerenburg
Is mySQL up to such a task? I have been using mySQL for four years now, but have never used it in a project of this magnitude. We'll be handling financial data in the database, so integrity is important. I think so. You find impressive statements on the mysql site about speed size

Re: Questions about extremely large database support

2001-07-19 Thread Michael Meltzer
Do not put tick by tick data in a database, The stuff is not relational, it is time series, FAME was one on the few that could deal it but I think it died. A database does not help research or organizing the data, it gets in the way. you would be better off timestamping the data to the

Upgrade MySQL

2001-07-19 Thread MikemickaloBlezien
Hi All, I need to upgrade a server running MySQL v.3.23.38 to .39 Specs: RedHat/Linux 6.2 i386 512RAM The only databases currently are the default 'test' and the 'mysql' db's no other db's created. The current variables show: basedir/ datadir /var/lib/mysql My question is, when

unsure of performance vs. replication of data...

2001-07-19 Thread Jim Matzdorff
I have a general DB question, but since I'm using MySQL, I figure one of our friendly listreaders might be able to help me out. I have 4 tables, say table1-table4, and I need to get some data from table4 which relies on some values from table1. However, the only way I can get those table1

Storing survey(s) data?

2001-07-19 Thread Nelson Goforth
My client conducts a number of surveys or questionnaires for THEIR clients. There are several standard surveys, each with a different number of questions (from 20 up to 90). Question is, how store the data. Seems like the simple way would be to create a table with 100 fields and store the

Re: Questions about extremely large database support

2001-07-19 Thread Jeremy Zawodny
On Thu, Jul 19, 2001 at 11:30:31PM +0200, Werner Stuerenburg wrote: Is there a really efficient way to implement a function like indexseek() in FoxPro? This function will simply check an index to tell you if a record with that key exists. Sort of like select count(id) from Foo where

Re: Please help - does changing the port the web server listens on affect mysql?

2001-07-19 Thread Werner Stuerenburg
Congratulations to the Webby Award! MySQL knows nothing of the ports that your Web server may listen to. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049)

RE: mysql.org

2001-07-19 Thread G. Lovén
At 21:28 01-07-19, you wrote: the same time, a NuSphere-controlled mysql.org doesn't strike me as a disaster, provided they can do it with out shooting themselves in the foot, as they are doing now. Nah There using it as a marketing ploy to dup the public. The should

Re: Upgrade MySQL

2001-07-19 Thread Donald Dahlman
does someone have a windows based program to manage, create and edit a database abd table off line MikeBlezien wrote: Hi All, I need to upgrade a server running MySQL v.3.23.38 to .39 Specs: RedHat/Linux 6.2 i386 512RAM The only databases currently are the default 'test' and the 'mysql'

Re: Upgrade MySQL

2001-07-19 Thread Jeremy Zawodny
On Thu, Jul 19, 2001 at 04:47:29PM -0500, MikemickaloBlezien wrote: The only databases currently are the default 'test' and the 'mysql' db's no other db's created. The current variables show: basedir/ datadir /var/lib/mysql My question is, when upgrading and to replace the

Left Join very sloooowwww..

2001-07-19 Thread David Bouw
Hi there, I am wondering if the Left Join syntax is a very inefficient query for MySQL (and other databases generally speaking..)??? I have a table which consits of a few tables from which the bigest table contains about 4500 records... Heres the scenario: I have 5 tables fom an ecommerce

Re: Upgrade MySQL

2001-07-19 Thread MikemickaloBlezien
On Thu, 19 Jul 2001 15:50:13 -0700, Jeremy Zawodny [EMAIL PROTECTED] wrote: Also it's been recommended to install with the Source instead of the Binary. We want to enable BDB tables handlers also. Any suggestion would be much appreciated :) Use the MySQL-MAX binary from mysql.com rather

database server upgrade

2001-07-19 Thread Mike Wexler
We currently have a dedicate server for MySQL. The server is a dual pentium III (1Ghz) with 2GB of RAM in it. It also has 2 18GB 10,000 RPM drives in it arranged in a Raid 1 configuration (mirror). Sometime in the next 3-6 months we will be maxing out its capacity. (We were maxed out a few days

Sysdate????Date????Please help

2001-07-19 Thread Ryan Ahmed
Hiya Everyone, I have a small problem,I am a java programmer working for a small company, We have just been given project to build a greetings program for a website,thats no problem but one of the parameters is an option to send the greeting at a later date,not today. I have kinda worked out

Re: java.sql.SQLException: [TCX][MyODBC] Access denied for user...(Using password: No) message

2001-07-19 Thread Venu Anuganti
If it is a TYPE IV driver means, ODBC won't come into picture. But the error string whatever you got shows that, you are trying to connect it through JDBC:ODBC bridge driver. Please refer to your driver manual for more information for making the connection with MySQL. If you are using mmmysql

Re: mysql.org

2001-07-19 Thread John Jacques
Thomas J Keller wrote: The more I think about this, the more convinced I am that someone needs to offer the following observations: It is unfortunate that so many people within this community are so eager to assume the worst about a company, simply because they ARE a company. Not all

Re: Upgrade MySQL

2001-07-19 Thread Steve Werby
MikemickaloBlezien [EMAIL PROTECTED] wrote: I need to upgrade a server running MySQL v.3.23.38 to .39 Specs: RedHat/Linux 6.2 i386 512RAM The only databases currently are the default 'test' and the 'mysql' db's no other db's created. It seems you have nothing worth keeping, unless you have

Re: Please help - does changing the port the web server listens on affect mysql?

2001-07-19 Thread Chip
That's what I expected, but haven't figured out the problem with the one database. I created another very simple database and form and can insert data from the web form with no problem. -- Chip Jeremy Zawodny wrote: MySQL knows nothing of the ports that your Web server may listen to. --

shutdown Mysql

2001-07-19 Thread QUAN,SUU (Non-A-PaloAlto,ex2)
On Unix is there another to shut down mysql, other than ps, then kill? tia (Obviously very new to mysql) Suu Quan Agilent Technologies Bldg 54, Post P4 (408)553-7155 [EMAIL PROTECTED] - Before posting, please check:

Re: Storing survey(s) data?

2001-07-19 Thread Steve Werby
Nelson Goforth [EMAIL PROTECTED] wrote: My client conducts a number of surveys or questionnaires for THEIR clients. There are several standard surveys, each with a different number of questions (from 20 up to 90). Question is, how store the data. Seems like the simple way would be to

prob install 3.23.39 (config.log attached)

2001-07-19 Thread Frederick Leung
This file contains any messages produced by compilers while running configure, to aid debugging if configure makes a mistake. configure:812: checking host system type configure:833: checking target system type configure:851: checking build system type configure:886: checking for a BSD compatible

Re: Upgrade MySQL

2001-07-19 Thread Werner Stuerenburg
You may want to have a look at http://www.mysqlfront.de/ Sie schrieben am Freitag, 20. Juli 2001, 20:29:32: does someone have a windows based program to manage, create and edit a database abd table off line -- Herzlich Werner Stuerenburg

mysql manager

2001-07-19 Thread Donald Dahlman
does anyone have a program to create and manage a database with out being connected to a server - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

ADV Buy 3 get 4th FREE! Shop online at Wonderful Gift Solutions

2001-07-19 Thread Wonderful Gift Solutions
To be removed from this list just hit reply or send an e-mail to the link below with REMOVE in the subject line. Wonderful Gift Solutions P.O. Box 496 Glenwood, N.J. 07418 1-888-777-5692 Remove e-mail address: [EMAIL PROTECTED] Shop on or offline at Wonderful Gift Solutions

mysql.org

2001-07-19 Thread Brooklyn Linux Solutions CEO
You are, of course, welcome to your opinion, and to the expression of said opinion. You are also liable to be judged on the basis of that expression, and frankly, your expression leaves me wondering about your wisdom and your analytical capabilities, not to mention your social skills. What

MySQL JDBC

2001-07-19 Thread Ricardo Striquer Soares
i am facing the same problem Kenneth explane above, can anyone tell me what to do ? PS: i tried to use the mysql port number as well Kenneth Fleck wrote: Hi ! I have a problem accessing a MySQL DB from a java-app. On commandline I can get in without problems with mysql db -uuser -ppass

Re: Upgrade MySQL

2001-07-19 Thread Jeremy Zawodny
On Thu, Jul 19, 2001 at 05:57:15PM -0500, MikemickaloBlezien wrote: On Thu, 19 Jul 2001 15:50:13 -0700, Jeremy Zawodny [EMAIL PROTECTED] wrote: Also it's been recommended to install with the Source instead of the Binary. We want to enable BDB tables handlers also. Any suggestion

Re: Left Join very sloooowwww..

2001-07-19 Thread Werner Stuerenburg
I'm by no means an expert, but I made left joins with 2 tables with about 4500 and 2800 records each. They were basically structured quite the same. I had response time at about .7 seconds on the larger and and 15 seconds on the other - which kept me wondering why that should be. I found that

  1   2   >