Re: Microsoft Visual C++ 6.0 API

Hi First of all let me say that the API is consistent cross-platforms i.e. there is no difference between Windows and *NIX At 16:56 21/01/2001 -0500, Don Hargroves wrote: Where can I get an example(s) of Microsoft Visual C++ 6.0 API to MySQL running under Linux 6.2? I suppose you mean Red Hat

explain select question

Hi all, I've been working on optimizing my query but no success. Concerning the type of query shown by "explain select", about join type "ALL" in the manual is written: "This is normally not good if the table is the first table not marked const, and usually very bad in all other cases." So, I

Re: MySQL constantly crash on BLOB insertions...

hi, the fatal "MySQL gone away..." error remains outstanding even after i upgraded 3.22.25 to 3.23.31 just now. i also run mysql_convert_table_format with my database, which should have converted all tables to MyISAM format. does anybody have good idea of working around this? i cannot go on

Re: explain select question

Dimitar Boiadjiev wrote: Hi all, I've been working on optimizing my query but no success. Concerning the type of query shown by "explain select", about join type "ALL" in the manual is written: "This is normally not good if the table is the first table not marked const, and usually very

Installing Mysql on a cobalt raq4

If you want to install MySQL on a RaQ4 go to the Cobalt web site at http://pkg.nl.cobalt.com. You will find a special .pkg file the will install in just a few minutes. The big "BUT!" - you have to clear out ALL traces of any previous MySQL installation. We got our hosting operation to reload

Mysql and Lotus

Hi, I am using Mysql version 3.22.32 and MyODBC version 2.50.3300 to connect to a Lotus Approach 97 front-end. I have been having some problems with boolean values. Is there anybody out there that has used Mysql with Lotus Approach, you may be able to offer me some help. Regards --- Faizal

Help with Dates

I have a script that saves a date in to a mySQL database. The date I want to be saved is 14 days from the current date. So for example today's date is January 22, 2001, the date I want saved is February 5, 2001. However when I add 14 days onto the day part part of the day I get January 36,

Veeery slow.

Hi. I'm running a mysql database, to which queries seem to take way too much time. The database contains just two tables, each with approx 10.000 rows. Simple select() calls to these can take more than a minute. Can this be right? My platform is a RedHat 6.1, running MySQL-3.22.32-1. Should I

MySQL on Netware - Again!

Hello Folks! Again someone is asking for MySQL on Netware. Sorry if you guys are tired of this... but Netware is all over... I ve checked the list archives, found some threads about this topic. Developers seem to be disapointed with lack of support from Novell, dev tools, etc.

Re: order by ( bug or undocumented feature )

Mark Papadakis writes: Hi all, I was wondering what's wrong with a query like this: select itemlist , sum(field1), count(*) as cnt from table where where conditions group by id having cnt=2 order by field_x, field_y desc limit 10 I am expecting to get the requested rows

Re: Unexplained high-loads on FreeBSD

Does a downgrade to MySQL 3.22.x help ? (seems less work to me, but I'l investigate the other possibilities anyway). Sinisa Milivojevic wrote: Herald van der Breggen writes: Hello Noor, I am struggling with a similar problem on a linux based system. It's a Netfinity 4500R, dual

Re: A report generator MySQL

I am writing a database to store student academic records at my local high school. I wish to generate attractively published reports home to parents. Does anybody know of a method or product that will produce elegantly formatted reports from MySQL? StarOffice can create reports from MySQL

RE: Unexplained high-loads on FreeBSD

Hi Sinisa Is the FreeBSD problem previously submitted by me known to you? Noor -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: Monday, January 22, 2001 3:32 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Unexplained

Re: Help with Dates

Yes, mysql can do date arithmetic. Read up on date_add and date_sub functions in the manual. -- Richard Ellerbrock [EMAIL PROTECTED] Mike Podlesny [EMAIL PROTECTED] 2001/01/22 03:01:10 I have a script that saves a date in to a mySQL database. The date I want to be saved is 14 days from the

Re: Replication with three servers - How to do this ?

Amiph wrote: Hi ! Ok. I've made correctly replication with two servers in a two-way replication. Both servers are master/slave. But I would like to know if is it possible to make three servers to replicate and receive the updates from each others like this: a sends updates to b and c

Re: MySQL on Netware - Again!

I have replied to this before and you would have found it in the archives too. Novell lacks a thread library! If you can port a thread library or write your own, you maybe able to get it to work. The thread library is the key to making MySQL work. If you have that, you are 95% there! --

RE: Unexplained high-loads on FreeBSD

Noor Dawod writes: Hi Sinisa Is the FreeBSD problem previously submitted by me known to you? Noor Ken Manzel has submitted many valuable messages to this mailing list concerning many important patches for FreeBSD 4.* threads. He has even provided names of files and dates when they

Win NT/2000 mySQL question

Hello, Hope this list is right for a newbie question. I would like using mySQL as an ODBC-database on a Win NT Server with MIS, ... That means, I am having a Website developed with ASP/SQL-Server, and I just would like changing the databaseserver (SQL-server out, mySQL in ) The

Re: Unexplained high-loads on FreeBSD

Sinisa Milivojevic wrote: Hi! The above is an already reported problem that occurs only on SMP Linux on the high load. A solution is to try kernel 2.4, glibc 2.2 (when stable) and to build properly MySQL on that setup. Regards, Sinisa Do you know whether the problem is

Re: MySQL constantly crash on BLOB insertions...

hi Tim, thanks for the prompt response which is hard to be seen with Oracle and Microsoft. sorry, i should have had studied hard the manual a year ago. regarding the error, however, would the error message be better to tell users to adjust relevant configuration than only to say "MySQL gone

Re: Access denied ... /mysql.sock Problem

Laurie Savage wrote: I am unable to connect to MySQL either as root or user unless I issue a "mysqld --socket=/var/lib/mysql/mysql.sock - u root" command. This is good for all users as long as the machine is booted. I have checked Ksysv and mysql is enabled at startup. I have

How do I know if a record exsist?

Hi, I'm using Perl to maintain a database. I'd like to search for a record in a database and if it does not exist, add it. Otherwise, just update the fields. In my script, I have: $sqlCmd = $dbh-prepare("SELECT PortName FROM Ports where PortName = '$port' "); $sqlCmd-execute(); Where

RE: Win NT/2000 mySQL question

Hi Marc, All your questions could be answered at: http://www.scibit.com/MySQLX try the Sample Website Hello, Hope this list is right for a newbie question. I would like using mySQL as an ODBC-database on a Win NT Server with MIS, ... That means, I am having a Website developed with

Re: Unexplained high-loads on FreeBSD

Hi Sinisa and everyone, I have a question for Noor, after updating freeBSD-stable last week, I assume you did a "make world", but did did you recomiple MySQL under that update? The compiler itself was broken on the older FreeBSD and was not fixed till the 12th of Jan (except by patches on

announcement: mssql2mysql database converter

mssql2mysql converts Microsoft SQL Server databases to MySQL mssql2mysql is VB/VBA code (you need VB6 or a VBA6 capable program such as Excel 2000 or Word 2000 to run it) mssql2mysql is free (GPL) for more informations see: http://www.kofler.cc/mysql/ Michael Kofler

Re: How do I know if a record exsist?

Don wrote: Hi, I'm using Perl to maintain a database. I'd like to search for a record in a database and if it does not exist, add it. Otherwise, just update the fields. In my script, I have: $sqlCmd = $dbh-prepare("SELECT PortName FROM Ports where PortName = '$port' ");

Re: INSTALLATION QUESTION on Cobalt Raq3

"l" == lkeeton [EMAIL PROTECTED] writes: l First does anybody know the website address for that searchable l site that allows you to search on mysql archive emails. I would l appreciate if I could get that. I also am looking for opinions on Does anyone read the footers on the messages they

Full-Text Query

Good Day All, This will work... mysql SELECT storyID, title, summary, MATCH summary AGAINST (LCASE('news')) AS probability - FROM newsStories WHERE MATCH summary AGAINST (LCASE('news')) 0 LIMIT 0, 5; But this will not... mysql SELECT COUNT(*), MATCH summary AGAINST (LCASE('news')) AS

Mysql and Lotus

Hi, Thought I'd try sending the message again, maybe you all missed the first time. I am using Mysql version 3.22.32 and MyODBC version 2.50.3300 to connect to a Lotus Approach 97 front-end. I have been having some problems with boolean values. Is there anybody out there that has used Mysql

Re: Unexplained high-loads on FreeBSD

Hi Noor, Here is my my.cnf file, it has almost nothing in it. [mysqld] port=3306 set-variable = max_allowed_packet=1M log-update [mysql.server] user=mysqladm [mysqldump] And Here are some stats for you, it sounds like our servers are very close. I am using DELL 2400's with 2 processors.

Re: Error in UPDATE syntax?

Don wrote: Hi, I'm looking at the docs for the UPDATE syntax right now! Here is my code (in Perl): $sqlCmd = $dbh-prepare("UPDATE Ports SET Country = $country, TransPort = $transPort, Suspended =

C API -- using mysql_ping()

If a connection has been closed by the mySQL server, like in a timeout condition, does the API function mysql_ping() awake the connection again if the reconnect flag was set, or will it just return a lost server error? In other words, if I'm testing to see if a long-unused connection is dead

Re: mySQL vs Oracle

Ann Ricchiazzi wrote: Dear mySQL Users, I am trying to choose between mySQL and Oracle for a Linux server. My specific questions are: 1) Will mySQL handle 3000 hits/day well? 2) Does mySQL handle multi-media file formats? For example, if I want to store audio clips, or Flash movie

Re: mySQL vs Oracle

On Mon, 22 Jan 2001 10:49:28 -0800, Ann Ricchiazzi ([EMAIL PROTECTED]) wrote: Dear mySQL Users, I am trying to choose between mySQL and Oracle for a Linux server. My specific questions are: 1) Will mySQL handle 3000 hits/day well? I'm on a site that does 90,000 database-heavy pages a day and

RE: mySQL vs Oracle

Hello Ann, The answer to you question depends on how you plan to use the database (i.e. financial trancactions, serving data on the web etc.) as well as financial considerations. MySQL is free and Oracle is expensive. Here are some questions you should answer: 1.) Do you need full

select HELP from HERE where HELP_NEEDED = TRUE !

hi, i have a web serverrunning redhat linux 7 i installed mysql 3.23.30 two weeks ago and it has begun to cause problems i get a "lost connection during query" every half a minute, basicly my web site is dead i tried instaling the 3.23.32 ( stable you call it! ) and i get the same response i'm in

Re: Win NT/2000 mySQL question

Thanks Jacques Christopher, you are telling on your site (compliment, really nice work), that your MySQLX-component is quicker then ODBC. Any benchmarking about it ? Also - does your component support ADO-objects ? - specially Recordsets .. or do you have something similar ? How can you

Re: mySQL vs Oracle

"AR" == Ann Ricchiazzi [EMAIL PROTECTED] writes: AR I am trying to choose between mySQL and Oracle for a Linux server. My AR specific questions are: AR 1) Will mySQL handle 3000 hits/day well? You need to define what a "hit" is. Is it a simple select on the primary key of a single table or a

DbTools question/feature suggestion (EXCEL)

Hi folks I have downloaded DB tools and took a quick look at it and it seemed to me that exporting from excel table can only be done by creating some new table for that purpose in the db. But what do I want to do? I`d like to copy the contents of excel file to an existing table into fields that

Running mysql_install_db will not create grant tables

Description: httpd5%14664:./bin/my_print_defaults: /sbin/loader: Error: Unresolved symbol in ./bin/my_print_defaults: _F64_fstat 14664:./bin/my_print_defaults: /sbin/loader: Error: Unresolved symbol in ./bin/my_print_defaults: _F64_stat 14664:./bin/my_print_defaults: /sbin/loader: Error:

Sorry, I just a bug without attaching my email address.

Description: 23655:./bin/my_print_defaults: /sbin/loader: Error: Unresolved symbol in ./bin/my_print_defaults: _F64_fstat 23655:./bin/my_print_defaults: /sbin/loader: Error: Unresolved symbol in ./bin/my_print_defaults: _F64_stat 23655:./bin/my_print_defaults: /sbin/loader: Error: Unresolved

Re: Error in UPDATE syntax?

On Mon, 22 Jan 2001, Don wrote: Hi, I'm looking at the docs for the UPDATE syntax right now! Here is my code (in Perl): $sqlCmd = $dbh-prepare("UPDATE Ports SET Country = $country, TransPort = $transPort,

Re: MySQL constantly crash on BLOB insertions...

"Huang-Ming" == Huang-Ming [EMAIL PROTECTED] writes: Huang-Ming hi Tim, Huang-Ming thanks for the prompt response which is hard to be seen with Oracle and Microsoft. Huang-Ming sorry, i should have had studied hard the manual a year ago. regarding the error, however, would the error

Re: mySQL vs Oracle

er, what? did i miss something? heh. -tcl. On Mon, 22 Jan 2001, Nathan Cook wrote: Note: As of version 3.2.3gamma Mysql Supports Sub-Selects. .:: Nathan Cook [ [EMAIL PROTECTED] ] ::. Systems Network Administrator :: Programmer [ phone - 208.343.3110 ][ pager - 208.387.9983 ]

Re: MySQL constantly crash on BLOB insertions...

Hi. On Mon, Jan 22, 2001 at 11:37:23PM +0200, [EMAIL PROTECTED] wrote: "Huang-Ming" == Huang-Ming [EMAIL PROTECTED] writes: Huang-Ming hi Tim, Huang-Ming thanks for the prompt response which is hard to be seen with Oracle and Microsoft. Huang-Ming sorry, i should have had studied

Re: select performance

Hi. I am not sure what you compare against, because the description of the second test script is not clear to me in the given context. Anyhow, the difference probably comes from the fact, that MySQL has to use indexes to find the row which matches to the id and has to access about log(65000) =~

Re: ERROR 1040: Too many connections

Hi! "Filippo" == Filippo Carletti [EMAIL PROTECTED] writes: Sometimes something bad happens in a server and it is hard to figure out what is going on because we can not get in. I'd like to suggest a change Filippo for MySQL 4 protocol, such that a connection from localhost can still get

Mysql opening tables

Hi! "Peter" == Peter Zaitsev [EMAIL PROTECTED] writes: Peter Hello monty, Peter After I got mysql/system crash I often see the following after I Peter bring mysql up again: Peter ruby:~ # w Peter 9:37pm up 7:35, 1 user, load average: 0.01, 0.04, 0.06 Peter USER TTY FROM

Startup of mysqld in scripts/mysql_install_db causes SEGV

Description: I have compiled MySQL 3.23.32 on Slackware 7.1 with BerkeleyDB support. Configure, make and make install work fine without any errors, however as soon as I run scripts/mysql_install_db it fails: Preparing user table Preparing func table Preparing tables_priv table Preparing

RE: SELECT FROM TABLE WHERE ?

Select * from singlemalts order by rating limit 1; Now, you have to share your samples with the rest of us! :) Cal http://www.calevans.com -Original Message- From: Richard Reina [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 21, 2001 12:49 PM To: [EMAIL PROTECTED] Subject: SELECT

Re: SELECT FROM TABLE WHERE ?

select max(rating) from singlemalts will give you the highest value or select * from singlemalts order by rating desc will give all the rows ordered by rating and the first row will have the highest value Richard Reina wrote: I've tried the manual (and the Oreily MySQL book) and played

Re: AW: mySQL vs Oracle

Sorry, but our mailserver is down again (Exchange ;), so I had to read via web and search my list-archiv for your mailadress. We tested the system on a Dual-P3-800Mhz-1GB while developing. Now it's running on a E4500 with 6x400Mhz and 8 Slaves (P3-800). Our site generates currently 1,5-2 Million

bdb table stability / what to watch out for?

in the mysql manual, i noticed: "Even though Berkeley DB is in itself very tested and reliable, the MySQL interface is still considered beta quality. We are actively improving and optimizing it to get it stable very soon." a team i'm in is considering trying bdb tables for some things for a

aborted connections?

we're seeing a lot of errors like these in our error log files from mysql: 010122 17:38:52 Aborted connection 177373 to db: 'XXX' user: 'YYY' host: `ZZZ' (Got an error reading communication packets) i haven't investigated too too much about this yet, but i was wondering what common problems

INSERT/UPDATE and MyISAM table

Hi. In the MyISAM table without any deleted rows, I read in the documentation that INSERT and SELECT can occur concurrently. What about UPDATE? I presume update will issue exclusive lock to the table unlike insert, but I wanted to know for sure. Also, after deleting some rows in the

Re: INSERT/UPDATE and MyISAM table

At 12:00 PM +0900 1/23/01, Nat Sakimura wrote: ?Hi. In the MyISAM table without any deleted rows, I read in the documentation that INSERT and SELECT can occur concurrently. What about UPDATE? I presume update will issue exclusive lock to the table unlike insert, but I wanted to know for sure.

Re: HELP! Newbie can't get MySQL to start at boot time

* Paul DuBois [EMAIL PROTECTED] [010122 21:03]: Is there a newbie resource somewhere for Those-Too-Stupid-to-Live? Did you run mysql_install_db ? Yes. Several times. :-) The database files are created in /var/mysql. There may be some confusion in this port as to where the datbase etc.

Problem with make test on Msql-Mysql-modules-1.2215 with MySQL-3.23

To whom it may concern, I get this error when I run make test. Details Perl-5.003_03 MySQL-3.23.32 SCO UnixWare 7.1.1 Developement System that comes with UW 7.1.1 libz 1.1.3 What is this sysbol __llasgdivu that is referenced in libmysqlclient.so.10 used or does it come from? Does any one else

Re: Mysql opening tables

Hello Michael, Tuesday, January 23, 2001, 2:02:33 AM, you wrote: Peter I saw this many times on different machines and this sequince never Peter resolves itself ( the locks never disapears). Always the only way to Peter fix this is to kill one of the queries. I killed query #16 and Peter

Re: PHP and MySQL in red hat 7.0

I tried RedHat, but had the same problem getting apache and php and mysql to talk to each other. I decided to try Mandrake 7.2 and it did all the work for me. Murdmath - Original Message - From: "Luis" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED];

RE: aborted connections?

Read the archives. The detailed story can be found there. Use newest MySQL and newest PHP CVS. These errors will go away. Maciek -Original Message- From: tc lewis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 3:56 AM To: [EMAIL PROTECTED] Subject: aborted connections?

RE: Win NT/2000 mySQL question

Hi Marc, Thanks Jacques Christopher, you are telling on your site (compliment, really nice work), that your MySQLX-component is quicker then ODBC. Any benchmarking about it ? Yes, although not prominent, we've had this on your site for a while: