RE: MySQL JDBC

2001-07-19 Thread Venu Anuganti
Here is the one...it looks lists.mysql.com is filtering the attachments. -- import java.sql.*; public class TestMySQL { public static void main(String[] Args) { try { // The newInstance() call is a work around for some // broken Java implementations Class.forName("or

MyODBC installation

2001-07-19 Thread shane
Hi, i've installed mysql on a win2000 os and downloaded myodbc zip file and went through the process of setting it up. it says sucessful installation but the environment tab of my mysqladmin says that myodbc is not found. what do i need to do? thks shane

Re: date_format doesn't work correct

2001-07-19 Thread Florian Schmidt
At 17:51 19.07.2001 +0200, you wrote: > >>okay, i see this output on my sco-machine: > >>'2001071614' '2001-07-19 14:00:00' > >> > >>if i try the same with mysql-front on my win2k machine: > >>'2001071914' '2001-07-19 14:00:00' > > >Somehow your sample data doesn't look right: shouldn't it be > >

Re: database server upgrade

2001-07-19 Thread Mike Wexler
Steve Brazill wrote: > > More RAM never hurts (as long as you're using it, which you might be able to > influence by your other option of optimizing the server variables). Ok. I'm at 2 GB now. My next server will probably start at 4GB and I want to have expansion room. What servers are current

Re: Storing survey(s) data?

2001-07-19 Thread Jeff S Wheeler
[This is an email copy of a Usenet post to "mailing.database.mysql"] In article <9j81uc$2bie$[EMAIL PROTECTED]>, "Steve Werby" <[EMAIL PROTECTED]> wrote: > "Nelson Goforth" <[EMAIL PROTECTED]> wrote: >> My client conducts a number of surveys or questionnaires for THEIR >> Seems like the simple

Re: mysql.org

2001-07-19 Thread Van
Michael Meltzer wrote: > > thought the list might want to know, this has been picked up by a trade > magazine, I got a copy of "interactive week" in sail mail today. (In my best > sarcastic voice)As they say in Hollywood "Any Publicity is good as long as > your spell the names right". Found a web

regarding mysql software

2001-07-19 Thread chetan merai
database ,sql,query,table Dear sir, I , chetan merai ,want to know about the installation problem that i am having with mysql. After downloading from net , and then using other commands when i use the command ./configure , I get the following error:

Re: database server upgrade

2001-07-19 Thread Steve Brazill
More RAM never hurts (as long as you're using it, which you might be able to influence by your other option of optimizing the server variables). I've always had the opinion, that the faster you service the queries, the more queries you can handle with existing resources. This might be best han

RE: MySQL JDBC

2001-07-19 Thread shane
think the attachment is wrong. the only thing i get is a text file containing Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail

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

2001-07-19 Thread Chip
The data entered into the web form is not posted to the database, as mentioned in the original post. I can insert new data at the command line and the database is updated as expected. There's something about the web form that isn't right, or the way it connects? I don't see anything wrong with t

Re: Multiple Tables

2001-07-19 Thread tj marlin
yes. the user table must reference the sysid. and the sysid must be unique in the computer system table. some how or another the input data must make the association. you could also have a unique name in the computer system table. then the input data could say john doe uses computer xyz. the

Re: mysql.org

2001-07-19 Thread Brooklyn Linux Solutions CEO
> > MYSQL.NET > XMYSQL.COM > MYSQLPHP.COM > PHPMYSQL.COM > MYSQL-PHP.COM > MYSQLHOST.COM > > -S > > Aside from being incorrect about the process of tradmarking in the US and the ability to defend a trademark while awaiting registry, all these above websites are not claiming to be the off

will new databases be reflected in database replication.

2001-07-19 Thread Russell Teo Wee Liang
Hi all, I am running mysql 3.23.33 on a Sun Ultra-250 and is running slave databases on 2 other machines. Everything was running fine until someone created a new database and it wasn't updated in the slave databases. Is there anyway to work around this? regards, Russell.

Re: Re: mysql.org

2001-07-19 Thread Brooklyn Linux Solutions CEO
> > I think you see evil people, conspiracies and other unwanted stuff when > in fact there are only misunderstandings and opposing viewpoints. > > I'm with Bob Hall on this one. Excellent statement Bob! > > -S > > Their is no conpsirisy, there is only one company trying to steel

Re: MySQL JDBC

2001-07-19 Thread Venu Anuganti
Hi Ricardo / Shane If you are using mmmysql JDBC Driver, please find the attaches simple JDBC sample that can be used with this driver to connect to MySQL server and do some basic operations. Before compiling the sample, make sure you set the CLASSPATH variable to mmmysql JDBC driver installed/ac

Re: mysql.org

2001-07-19 Thread Michael Meltzer
thought the list might want to know, this has been picked up by a trade magazine, I got a copy of "interactive week" in sail mail today. (In my best sarcastic voice)As they say in Hollywood "Any Publicity is good as long as your spell the names right". Found a web version if any one wants a look.

Multiple Tables

2001-07-19 Thread temu-jin
I have been looking through the documentation and searching through the list for answers to this question, but have not yet figured out how to do so. Basically, I want to have multiple tables linked together. I have seen a lot of talk about foreign keys and that MySQL does not support them. I

Re: mysql manager

2001-07-19 Thread Donald Dahlman
should be an easy task to open a database and edit or create a new one should not need a server running for that. I do it all the time with Delphi maybe im not being clear I trien all the win32 programs listed on the mysql site and they all try to connect to the unit server. "Gerald R. Jensen" wr

Re: shutdown Mysql

2001-07-19 Thread Steve Werby
"QUAN,SUU (Non-A-PaloAlto,ex2)" <[EMAIL PROTECTED]> wrote: > is there another to shut down mysql, other than ps, then kill? mysqladmin shutdown -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.com/ ---

Re: mysql manager

2001-07-19 Thread Gerald R. Jensen
Donald: It would be a tall order to create and manage a database without a server ... but the 'server' I refer to is software, running on a machine you have access to. Check out http://www.mysql.com/ or search the list archives at http://lists.mysql.com/... you'll find a load of good utilities a

Re: shutdown Mysql

2001-07-19 Thread Benjamin Pflugmann
Hi. On Thu, Jul 19, 2001 at 06:02:18PM -0600, [EMAIL PROTECTED] wrote: > On Unix > > is there another to shut down mysql, other than ps, then kill? mysqladmin shutdown Have a look at the following manual sections for more information: http://www.mysql.com/doc/P/o/Post-installation.html http:

Factory of Table and Bed Linens

2001-07-19 Thread ask
Dear Sir/Madam: We wonder if you might have the interest in importing embroidered and spray printed tablecloths and bedsheets from our owned factory in Xiamen, China. We as a manufacturer and an exporter has over 300 workers with 20 years experience of making table and bed linens using fabri

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

2001-07-19 Thread Allen Grace
- Original Message - From: "Chip" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July 20, 2001 10:04 AM Subject: Re: Please help - does changing the port the web server listens on affect mysql? > That's what I expected, but haven't figured out the problem with the one > databa

Re: stability of freebsd 4.3, gcc 2.95.3

2001-07-19 Thread Allen Grace
- Original Message - From: "Ken Menzel" <[EMAIL PROTECTED]> To: "Allen Grace" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, July 19, 2001 11:40 PM Subject: Re: stability of freebsd 4.3, gcc 2.95.3 > > Has anyone had unfavourable experiences with FreeBSD 4.3-STABLE, gcc > 2.95.3

Re: Upgrade MySQL

2001-07-19 Thread MikeBlezien
Jeremy, Appreciate the info. I think we'll install the Mysql-Max and see how it goes. THX's >>On Thu, 19 Jul 2001 17:53:12 -0700, Jeremy Zawodny <[EMAIL PROTECTED]> wrote: >>The binary is known to be good (or at least known). It is a static >>binary built with a specific compiler, specific

Re: Sysdate????Date????Please help

2001-07-19 Thread Werner Stuerenburg
I would call the program via cron job. The program would query the database, produce the mails and feed them to sendmail. I work with php, but don't know about java. I planned to add this feature to our card program, but didn't have the time yet. > to send the greeting at a later date,not today.

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 the

Re: Upgrade MySQL

2001-07-19 Thread Jeremy Zawodny
On Thu, Jul 19, 2001 at 05:57:15PM -0500, MikeBlezien 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. > >>> > >>> An

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 -u -p > >

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. W

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 http://www.wond

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 arc

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

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: 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

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: http:/

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. > -- > Je

Re: Upgrade MySQL

2001-07-19 Thread Steve Werby
"MikeBlezien" <[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 ha

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: 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 dri

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

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 a

Re: Upgrade MySQL

2001-07-19 Thread MikeBlezien
>>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 fro

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 s

Re: Upgrade MySQL

2001-07-19 Thread Jeremy Zawodny
On Thu, Jul 19, 2001 at 04:47:29PM -0500, MikeBlezien 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 curr

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

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 p

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) 5224-9

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 Fo

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 an

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 v

Upgrade MySQL

2001-07-19 Thread MikeBlezien
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 upgrading

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 millisecond

Upgrade MySQL

2001-07-19 Thread MikeBlezien
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 upgrading

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 & si

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 sc

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) ---

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 r

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 s

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 limit,

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

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

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

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

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 NUL

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 i

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 G

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 filesyste

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: 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 seperat

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 an

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 it

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: thi

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

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 unders

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

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 table

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) --

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 fro

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.

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 AttractionInf

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; > > m

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

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. Fiel

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 /usr/local/mysql-3.23.39-p

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 exaggeratio

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 NuSh

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 process,

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. Be

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) i

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 t

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 th

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 m

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 so

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: 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: 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 my

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' > >

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 cont

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.%' >

  1   2   >