failure to connect to mysql-server at localhost

2008-07-22 Thread kenneth rotich
am using ubutu 6.06 operating system. Thanks kenneth

Re: InnoDB dropping records / MyISAM working as it should

2007-05-16 Thread Kenneth Loafman
Folks, Thanks for all the help. Not only is the code working, but my understanding of the issue has improved, thanks to this list. ...Ken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: InnoDB dropping records / MyISAM working as it should

2007-05-15 Thread Kenneth Loafman
Jon Ribbens wrote: On Tue, May 15, 2007 at 04:13:33PM -0500, Kenneth Loafman wrote: Can't tell. The docs are somewhat lacking in detail, however, if I do a db.autocommit(True) it works as it should. Will have to dig into the API code and see if that is where the semantic discontinuity

Re: InnoDB dropping records / MyISAM working as it should

2007-05-15 Thread Kenneth Loafman
Ofer Inbar wrote: Kenneth Loafman <[EMAIL PROTECTED]> wrote: Sounds like InnoDB is still borked though. You should not have to use a commit unless you have started a transaction, as I understand it. The semantics for non-transaction access should be identical. Are you explicitly t

Re: InnoDB dropping records / MyISAM working as it should

2007-05-15 Thread Kenneth Loafman
Thanks for the tip, that worked. Sounds like InnoDB is still borked though. You should not have to use a commit unless you have started a transaction, as I understand it. The semantics for non-transaction access should be identical. ...Ken Dan Buettner wrote: Hi Kenneth - it appears

InnoDB dropping records / MyISAM working as it should

2007-05-15 Thread Kenneth Loafman
Folks, Here's an interesting problem for you. I found a problem that did not make any sense, and in diagnosing the problem I found an issue with InnoDB vs MyISAM, so I wrote a short script to test it. The test case is a simple Open, Insert, Close series repeated 5 times with both engines.

Re: Are primary keys essential?

2005-12-21 Thread Kenneth Wagner
Hi James, If the tables you use have primary keys that _YOU_ don't need or use then, for you, they are not essential. I do have a question, though. You are working with SQL tables, aren't you? And from wherever they came from or exist, I presume from your reply that you don't need the PKs.

Re: Are primary keys essential?

2005-12-21 Thread Kenneth Wagner
esses show "WAGNEKO64054A". If another Wagner, Kenneth O. arrives in zip code 64054, presumably, he becomes "WAGNEKO64054B." No middle initial? The it's "WAGNEK_64054.") How could I know which customers to restore without going thru a lot of queries? What i

Re: Reason for Auto-increment primary keys?

2005-12-21 Thread Kenneth Wagner
about how to use the ID? Or what's it for? Ken - Original Message - From: "Rhino" <[EMAIL PROTECTED]> To: "Kenneth Wagner" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Cc: "mysql" Sent: Wednesday, December 21, 2005 4:57 PM Subject:

Re: Reason for Auto-increment primary keys?

2005-12-21 Thread Kenneth Wagner
Hi Rhino, Excellent question. Felt as you do, initially. Here's what changed my mind. Integer keys are fast. And small. Hence, they take very little RAM space. They are contiguous. A missing PK is easy to find. There's a gap in the number sequence. Can't do this with the part description. No

RE: The table '' is full

2005-08-23 Thread Lindh Kenneth
Thanks a ton Shawn, very illuminating. Will try this tomorrow with good hope. :) BR /Kenneth -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: den 23 augusti 2005 16:50 To: Lindh Kenneth Cc: mysql@lists.mysql.com Subject: Re: The table '' is full

The table '' is full

2005-08-23 Thread Lindh Kenneth
When I run a query I get this error-message. It doesn't say which table, but I checked all my tables and none is near max_table_size. We have MyISAM-tables and we're using version: 5.0.4 Any ideas? BR /Kenneth This query work

FULLTEXT INDEX support for ucs2

2005-06-27 Thread Lindh Kenneth
Hi, I would like to know if the support for fulltext index on ucs2-columns will be added and if so when. BR /Kenneth Lindh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Is this picayune??

2005-04-29 Thread Kenneth Wagner
Hi, Normalizing some tables. Does it make much difference to MySQL whether I separate minor, related data into tables for a main account (MemberAccount) such as: MemberAccount then emails, religion, hobbies, education, etc. I'll explain. On the other hand, I could put all the information in

database migration puzzle.

2005-04-25 Thread Kenneth Wagner
Hi all, I have removed mysql 4_0_20d and installed 4.1. My puzzle is this: 1. I have prior databases in 4.0 (intact data directory with InnoDB files *.idb, etc.) data directory with sub directories. 2. I want to bring in some of the databases to the new 4.1 version. The 4.0 databases

Re: Test post to test new client

2004-11-14 Thread Kenneth Wagner
Here's is your test reply. Wishing you complete success... Ken Sugar Creek - Original Message - From: "Robb Kerr" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, November 14, 2004 11:34 AM Subject: Test post to test new client I'm posting to test a new newsgroup client. Pleas

MySQL implementation of Oracle sequences

2004-10-15 Thread Kenneth Lim
ately. This approach seems to create a bottleneck also. But I would imagine this approach is more costly than solution #1. 3- Redo our semantics by replacing our insert statements and allowing AUTO_INCREMENTed columns to keep the IDs unique. Thanks for you feedback. -ken Kennet

Replication and LOAD DATA LOCAL INFILE

2004-10-12 Thread Kenneth Lim
ssages above. The data seems to be the same on master and slave. Are there special considerations for using LOAD DATA LOCAL INFILE statements with a replication setup? Thanks. -ken Kenneth Lim Software Engineer Senvid, Inc. 2445 Faber Place, Suite #200 Palo Alto, CA 94303 phone: 650-354-3

installing mySQL on Windows 2000

2004-01-13 Thread West, Kenneth D.
I'm attempting to install version 4.0.16 When I try to install the software I get an error that reads: "An error occurred during the data move process: 103" Can anyone give me any guidance on how to resolve this. Thanks, Ken This e-mail and any files transmitted with it may contain inf

Subtracting date fields

2003-12-31 Thread Kenneth Letendre
se-10 integers rather than dates. E.g.: 2004-01-07 (20,040,107) - 2003-12-31 (20,031,231) = 8876 How do I get MySQL to treat these date fields as date fields in this case? Thanks, Kenneth -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Subtracting date fields

2003-12-31 Thread Kenneth Letendre
se-10 integers rather than dates. E.g.: 2004-01-07 (20,040,107) - 2003-12-31 (20,031,231) = 8876 How do I get MySQL to treat these date fields as date fields in this case? Thanks, Kenneth -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

End Action [ failure 0x1602]

2003-10-10 Thread Kenneth Illingsworth
I have been using ODBC v3.51 to select from MySQL DB's hosted by a RH v7.2 Linux VM from within an application script. The DB's are normally imported in the early morning. I now have a need to Insert into a table from an application script. The insert works when submitted through phpMyAdmin. How

I have been using ODBC v3.51 to access MySQL DB's hosted by a RH v7.2 Linux VM for select purposes f

2003-10-08 Thread Kenneth Illingsworth
I have been using ODBC v3.51 to access MySQL DB's hosted by a RH v7.2 Linux VM for select purposes from within an application script. They are normally imported in the early morning. I now have a need to Insert into a table from an application script. The insert works when submitted through php

Mutable mysql servers accessing the same data dir

2003-10-03 Thread Kenneth Lichtenberger
anyone know for sure if this will work Thanks a bunch Kenneth W Lichtenberger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Finding out the password a client is using

2003-09-08 Thread kenneth . lundstrom
I have a clientprogram tring to connect to a MySQL database via ODBC, but the client is receiving '(access is denied to XX with password yes). ' How do I find out what password the client is sending? ----- Kenneth Lundström [EMAIL PROTECTED] -- MySQL Gener

myodbc error

2003-08-14 Thread Kenneth Foli Jørgensen
i get this msg: Microsoft.Data.Odbc.OdbcException: NO_DATA - no error information available at Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode) at Microsoft.Data.Odbc.OdbcDataReader.GetData(Int32 i, SQL_C sqlctype, Int32 cb) at Microsoft.Data.Odbc.O

Re: Import databse ?

2003-07-30 Thread Kenneth Illingsworth
Isn't the default field separator in Linux a Tab character? I suspect it is. And, I also suspect that the default field separator in Solaris is not a Tab character. Check these out. If these are in fact true, then it might go a long way in explaining why your import failed. >>> Vidhya CS <[EMAI

Re: Error code 1064 in another application...

2003-07-29 Thread Kenneth Illingsworth
If your query has worked in one account, but not in another, then your 1064 error is probably related to privileges granted to the second account. HTH >>> "Ola Ogunneye" <[EMAIL PROTECTED]> 07/29/03 09:08AM >>> I am running mysql 4.0.13 and using a weblog(Geeklog) to do my web. Using geeklog as

Fwd: MySQL error code 1064:K@N@!:

2003-07-28 Thread Kenneth Illingsworth
I suspect that this is some kind of issue with privileges. However, the account I am using has been given 'ALL' privileges to the database I am trying to insert to. Am I save to assume that ALL includes insert privileges? --- Begin Message --- I cannot seem to find this in the MYSQL Reference. A

Re: MySQL error code 1064:K@N@!:

2003-07-28 Thread Kenneth Illingsworth
any selects I want ok. This is my first attempt to insert. >>> David Precious <[EMAIL PROTECTED]> 07/25/03 11:54 AM >>> On Friday 25 July 2003 1:05 pm, Kenneth Illingsworth wrote: > I cannot seem to find this in the MYSQL Reference. Are there other places I > should

Altering table and field names

2003-07-25 Thread Kenneth Illingsworth
I would like to copy the values from each record in the Program table to another table (tblPrograms). This is the syntax I came up with: select * from Program insert tblPrograms set ProgramCode=Location, ProgramName=Description; However, it fails without telling me why. Perhaps someone could c

Re: MySQL error code 1064

2003-07-25 Thread Kenneth Illingsworth
any selects I want ok. This is my first attempt to insert. >>> David Precious <[EMAIL PROTECTED]> 07/25/03 11:54 AM >>> On Friday 25 July 2003 1:05 pm, Kenneth Illingsworth wrote: > I cannot seem to find this in the MYSQL Reference. Are there other places I > should

Fwd: MySQL error code 1064

2003-07-25 Thread Kenneth Illingsworth
I suspect that this is some kind of issue with privileges. However, the account I am using has been given 'ALL' privileges to the database I am trying to insert to. Am I save to assume that ALL includes insert privileges? --- Begin Message --- I cannot seem to find this in the MYSQL Reference. A

Fwd: Re: MySQL error code 1064

2003-07-25 Thread Kenneth Illingsworth
target the offending object more precisely for testing purposes. And, now the error is 1602 with no text. I am currently still looking for any error references. Once again, thanks in advance for your time. >>> "Kenneth Illingsworth" <[EMAIL PROTECTED]> 07/25/03 08:05AM >>

Re: MySQL error code 1064

2003-07-25 Thread Kenneth Illingsworth
/v1n1tpserrorcodes.html >>> "Kenneth Illingsworth" <[EMAIL PROTECTED]> 07/25/03 08:07 AM >>> I cannot seem to find this in the MYSQL Reference. Are there other places I should check? The message text in my log started out with 'You have...'. But, it was truncated

Re: MySQL error code 1064

2003-07-25 Thread Kenneth Illingsworth
I streamlined the application so as to target the offending object more precisely for testing purposes. And, now the error is 1602 with no text. I am currently still looking for any error references. Once again, thanks in advance for your time. >>> "Kenneth Illingsworth" <

MySQL error code 1064

2003-07-25 Thread Kenneth Illingsworth
I cannot seem to find this in the MYSQL Reference. Are there other places I should check? The message text in my log started out with 'You have...'. But, it was truncated and I could not see the rest. It occurred on a submitted insert statement originating in an application. The insert statemen

RE: linux and mysql socket

2003-06-19 Thread Kenneth Hylton
If it truly ran fine for a few days and then you couldn't run the client, you may have another problem. If you rebooted the box, mysqld may not have automatically started. So, all of the sudden, the client can't connect to the socket since it is not there as the server is not running. You can ch

Strange Temporary Table Problem.

2003-02-28 Thread Kenneth Stifle
Hello everyone, I am running MySQL version 3.23.52 on Mandrake 9.0 and access it from a web application running on IIS on Win 4.0 Service pack 6a with MyODBC version 2.50.39. The problem I am having is when I create a temporary table and then query the temporary table I get a Table doesn’t exist

RE: help with query

2003-01-13 Thread Kenneth Hylton
>From you example, not quite sure what you are trying to do (I could if, for example generic tree was 0199, and 01 was tree and last two characters were color or something like that) At any rate, you can use string functions to pull data from portions of fields to build whatever you want to search

RE: Question or Wish feature

2003-01-07 Thread Kenneth Hylton
Refer to http://www.mysql.com/doc/en/LOAD_DATA.html for doc on LOAD DATA INFILE command and syntax. -Original Message- From: Gman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 07, 2003 10:45 AM To: [EMAIL PROTECTED] Subject: Question or Wish feature How easy is it to import a CSV fil

Re: Mysql.Sock problem

2002-12-31 Thread Kenneth Illingsworth
It appears that we both are climbing the same mountain. The best approach is to hire a consultant to come in and get you started in the right direction. If, as is our case, this is unlikely, I will attempt to relay to you some of what I have encountered so far. Typically we prefer downloading R

re: Help struggling newbie, please!!

2002-12-17 Thread Kenneth Illingsworth
You might also wish to consider downloading and installing Webmin. It's one of the easiest installs I have encountered. Simply tar the tarball and proceed into the new subdirectory (IE webmin-1.030) and perform a /setup.sh . Webmin will allow you easy access to your server via a web browser. Sim

Re: Can't find hosts.frm -- permissions now okay?

2002-12-12 Thread Kenneth Illingsworth
I had a similar experience right down to the error message you are getting. Based on that experience, I am inclined to recommend the following: 1) Abandon your current installation which I perceive that your are attempting from a MySQL tarball. 2) Download the webmin-1.030 tarball and execute ./

Install PHP with MySQL

2002-12-05 Thread Kenneth Illingsworth
I recently installed the following RPM's: MySQL-3.23.41-1a.s390.rpm MySQL-devel-3.23.41-1a.s390.rpm MySQLclient9-3.23-22-6a.s390.rpm MySQL-server-3.23.41-1a.s390.rpm Afterwards, I was able to start the mysqld daemon ok and install an application I downloaded for a demonstration of the viability

Re: REPLACE fails to find newlines

2002-12-04 Thread Kenneth Porter
--On Tuesday, December 03, 2002 12:14 PM -0500 "Keith C. Ivey" <[EMAIL PROTECTED]> wrote: > My first guess is that you have CRLF where you think you've got just > LF. Have you tried the query with '\r\n' in place of '\n'? That was it. I guess the data must have been imported from source that wa

REPLACE fails to find newlines

2002-12-03 Thread Kenneth Porter
Using Red Hat 8.0, mysql-3.23.52-3, and phpMyAdmin-2.3.3. I'm importing a bunch of old posts from one bboard system (Ezboards) into a new one (Burning Board), and the process left a bunch of HTML "" on the end of each line that is now unwanted. (I'm getting double-spacing.) I figured this SQL sho

Bind on unix socket: Permission denied

2002-11-22 Thread Kenneth Illingsworth
Mysqld.log shows this error: 021122 11:29:05 mysqld started 021122 11:29:06 Can't start server : Bind on unix socket: Permission denied 021122 11:29:06 Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?

Fatal error: Please read "Security" section of the manual tofind out how to run mysqld as root!

2002-11-22 Thread Kenneth Illingsworth
This happens when I try to start the mysql daemon. I have checked the manual, but cannot fathom what else I am supposed to do. Here is what has been done so far: ./scripts//mysql_install_db seemed to initialize the MySQL db's ok. I also executed the following statements without issue: chown -

Error starting the Mysql Daemon

2002-11-22 Thread Kenneth Illingsworth
After taring mysql-3.23.53-unknown-linux-gnu-s390.tar.gz successfully on our Linux VM and linking the new directory to simply mysql, I ran into the following error trying to start the mysql daemon: [root@cofr3 mysql]# ./bin/mysqld -L /mysql/share/mysql/english Fatal error: Please read "Security"

epayroll

2002-11-14 Thread Kenneth Illingsworth
Anyone have experience with Hotscripts Enterprise Timesheet and Payroll application? It's my first attempt at running a MySQL aplication. Here is the link: http://www.hotscripts.com/Detailed/14498.html The installation seemed to go flawlessly. Apache webserver was running as well as MySQL v3.2

MySQL Performance

2002-11-01 Thread Kenneth Hylton
Howdy - I have a question concerning MySQL performance. From the list, it seems to be the topic as of late! Database Server: Dual Pentium III 1.2GHz COMPAQ server with 2GB of RAM running Red Hat LInux, 7.2 (Enigma). MySQL version is 3.23.52-Max-log. All tables are InnoDB. Storage: All MySQL

RE: Performance over a network

2002-10-25 Thread Kenneth Hylton
I just got done playing with this same scenario. If the task finishes locally OK, but totally dogs on the network, then you may have a network issue, NOT a MySQL issue. 1) Make sure that the switch and boxes are set to full duplex operation. This will eliminate collisions. Make sure that everyt

RE: Mysql arbitrarily rounds large floats

2002-10-22 Thread Kenneth Hylton
I didn't see anyone else reply, so I will give you my thoughts. I thought one of the "list gurus" would give you a much better answer than I could so I waited. Assuming that with two decimal places, you are doing something monetary. But this applies whenever you want fixed decimal places, too. I

Website with next SQL standard 200X (final draft)

2002-09-26 Thread Kenneth Andresen
reading - there are about 3500 pages... -- Best regards, Kenneth mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Website with next SQL standard 200X (final draft)

2002-09-21 Thread Kenneth Andresen
the new standard yet, but it should certainly be of interest to look at the new standard might aim for. You should enjoy reading - there are more than 3000 pages for you on the standard... -- Best regards, Kenneth mailto:[EMAIL PROTECTED

RE: mediumint(6) problem

2002-09-11 Thread Kenneth Hylton
Mediumint refers to the fact that it is three bytes long rather than a regular 4 byte, 32 bit integer. It's range is like +/- 8,000,000 or so (look it up for sure) The 6 just has to do with how many digits will be displayed when you invoke the MySQL client for the row - spacing will be a minimum

RE: JAMES KADEH mysql !

2002-08-28 Thread Kenneth Hylton
Unfortunately, you may be. Now he has your e-mail address. As my father always sez, "smooth move Ex-Lax" -Original Message- From: Mary Stickney [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 10:12 AM To: John Wards; [EMAIL PROTECTED] Subject: RE: JAMES KADEH mysql ! I

RE: MySQL vs. Oracle (not speed)

2002-08-16 Thread Kenneth Hylton
Our experience has been totally the opposite. We recently ported a Delphi application from MS-SQL to MySQL. The MySQL server was a less powerful box than MS-SQL was running on. I will not go into great detail because some of the software is proprietary and we make $$$ providing the service.

RE: Definition of structure MYSQL

2002-08-13 Thread Kenneth Hylton
It should be in mysql.h Check your installation and make sure it was installed. Our sysadmin originally installed MySQL without it - after all, he didn't need it so it must not have been important ;) Also, you will need to be sure and install the libmysqlclient and link with it. Regards, Ken

Basic MySQL setup question

2002-08-01 Thread Kenneth Gomez
Dear All, My web host provider says that he cannot allow me to have a MySQL account on the server. However, he asks me to set up my tables offline and ftp them across and asses them using Php. Can this be done? Thank you. Kindest regards, Kenneth Gomez, Engineering Analyst, Compumod Sdn

RE: stupid question

2002-06-11 Thread Kenneth Hylton
I am assuming this is not a MySQL question since MySQL interacts with SQL commands that are all in characters. try using strstream. You can poke just about anything into it and get a string out. If you must have a char*, then use the c_str() function of the string class. The best implementatio

RE: Length Limit

2002-05-10 Thread Kenneth Hylton
The real answer, yes. It has a limit of several GB, depending on your OS. It can take a huge string containing MBytes of BLOB data. Just for grins, I loaded several MB of image data this way just to prove to myself that you could do it. The practical answer is then pretty much no. (Probably wo

RE: Any ideas how to speed this up?

2002-05-03 Thread Kenneth Hylton
What version of the ODBC Drivers are you using? I had a VB app using the 3.5x versions of the ODBC driver manipulating very small tables and it was absolutley painful to run. I stepped back to the version 2.x drivers (2.9, I think - anyhow, the driver information is available on the web site)

RE: One field or numerous datatype-specific tables?

2002-04-17 Thread Kenneth Hylton
Howdy - Am I missing something? Why would you have to create all of your columns as BIGINT? Whether the "has pool" column is a TINYINT, BIGINT, or whatever, the SELECT statement would be the same, wouldn't it? Won't "SELECT FROM HOMES WHERE HasPool = 1;" return houses with pools regardless o

RE: MySQL on Cobalt Raq2

2002-04-10 Thread Kenneth Hylton
Well, I haven't kept up on the Cobalt product line, but, I wasn't aware that they had intel based offerings. I thought they were all RISC chip based. That probably explains why I86 binaries won;t install.. If they don't have a binary for Cobalt Cube/RaQ systems, it's compile time...

RE: Deleting Duplicated Records

2002-04-10 Thread Kenneth Hylton
You are 100% correct. Since MySQL does not support "cursors", I always put an auto_increment column in my tables for just this purpose. (This is what other DBMS' do, they just do it behind your back) Unfortunately, the way MySQL really handles result sets doesn't lend itself to simply adding

Using DECIMAL Types for Huge Numbers

2002-04-03 Thread Kenneth Hylton
Howdy All - I am using MySQL 3.23.46-Max under Red Hat 7.2 I am trying to use DECIMAL type columns to work with huge numeric (monetary) values. I figured out how to get large numbers into DECIMAL types by passing them as strings: mysql> insert into khtest set k1=1,t1="123456789012345678.10";

RE: Password function

2002-04-02 Thread Kenneth Hylton
Okay, here's a hint... 4.2.9 in the manual (;o) Basically, if you encrypt the password, then you have to look it up using the password function, too. Ken Hylton Programmer Analyst IV LEC Systems & Programming Billing Concepts, Inc. 7411 John Smith Drive San Antonio, Texas 78229-4898 (210) 949

mysqld: Can't find file: 'host.frm' even though file exits

2002-03-30 Thread Kenneth . Lerman
>Description: Subject says it all >How-To-Repeat: ./bin/safe_mysqld >Fix: unknown >Submitter-Id: >Originator:Kenneth Lerman >Organization: Systems Essentials Limited >MySQL support: none >Synopsis: Can't find file: 'host.fr

RE: C API Question

2002-03-20 Thread Kenneth Hylton
Not as far as I know, you need to open your file, read the commands and process them one at a time. The C API is not magic and has no more capability than you do setting down and typing in the commands yourself. What you can do is build one HUGE insert command from lots of individual row insert

RE: queries and functions

2002-03-18 Thread Kenneth Hylton
I don't think MySQL has a mechanism for doing any sort of stored procedure, but, I just saw this earlier today and went adn looked at it. It may help you, but I know nothing about it and con offer no further advice. Ken Hylton Programmer Analyst IV LEC Systems & Programming Billing Concepts, In

Server Databases Clash

2002-03-15 Thread Kenneth Hylton
I read your article and found it to be interesting and overall, quite accurate. I do have one bone to pick with you however. I know the MySQL staffer who worked the MySQL portion of the test. I had occasion to meet him and talk briefly about the PC Magazine test in Houston the week following th

RE: problem in telent to mysql server

2002-03-14 Thread Kenneth Hylton
Howdy - You are trying to telnet to the MySQL server. 3306 is the MySQL Server default port, not the telnet port. If you are trying to run the MySQL client, then: 1) telnet mysqlserverhostname 2) run the Mysql client within your telnet session (mysql -uroot -proot, for example) If you are tr

C API BLOB type field lengths returned

2002-03-07 Thread Kenneth Hylton
Howdy - I've posted this twice before - third time might be the charmer... Can anybody help me? I am using the C API and am returning a result set from a table with a BLOB type item in it. When I populate the BLOB fields initially (with all the same data) the length is returned properly when I is

C API BLOB type field lengths returned

2002-03-05 Thread Kenneth Hylton
Howdy - I am using the C API and am returning a result set from a table with a BLOB type item in it. When I populate the BLOB fields initially (with all the same data) the length is returned properly when I issue SELECT * FROM and decode the result set column metadata. Meaning, that if I put ,

RE: how can I use 'C' programs accessing a MySql

2002-03-05 Thread Kenneth Hylton
The best book for c programming I found is the O'Reilly book, "MySQL & mSQL" . It has a good example of using the C API and even builds some simple C++ classes. The book, "MySQL" by Paul DuBois is the best overall MySQL book I found. Plus, Paul is a regular responder to this list, so I would bu

FW: C API BLOB type field lengths returned

2002-03-04 Thread Kenneth Hylton
> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -Original Message- From: Kenneth Hylton [mailto:[EMAIL PROTECTED]] <mailto:[mailto:[EMAIL PROTECTED]]> Sent: Sunday, March 03, 2002 1:19 PM To: '[

RE: [NEWBIE] Problems with the RESULT Class. Please Help :(

2002-03-03 Thread Kenneth Hylton
Hi Justin - I have run into the same issues and have given up on using MySQL++ interface for that reason, plus it doesn't have the ability to update tables dynamically. That is, if you need to update anything, you have to define the table to a macro at compile time! Change a table, recompile e

RE: INSERT blob data in C

2002-02-28 Thread Kenneth Hylton
L PROTECTED]> -Original Message- From: paradoxix [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 3:04 PM To: Kenneth Hylton Cc: [EMAIL PROTECTED] Subject:Re: IN

INSERT blob data in C

2002-02-28 Thread Kenneth Hylton
Howdy - I looked in the doc @ mysql.com and the New Riders and O'Reilly MySQL books. Plus, I consulted the archives as best I could and did not see an answer for this: How do you insert binary data using the C API? I know you need to use mysql_real_query method and pass length, but how do you

column level grants

2002-02-28 Thread Kenneth Hylton
Howdy - I have looked online and also in MySQL by Paul DuBois, plus the O'Reilly book and can't find an example of how to do column level security. We are running 3.23.46-Max on Red Hat 7.2 Here is what I am trying: mysql> GRANT ALL (BatchControlUri, IndustryId, UpdateId) ON dbEngine.BatchCo

RE: get instance variable

2002-02-19 Thread Kenneth Hylton
Hi Robert - The only way I have found to get this sort of stuff (as well as security info) out is to use mysql_query (or mysql_real_query) and issue the query just like you would at the mysql client. Then you can interpret the results that are returned. I am having to do that with column level

RE: Probably OT - SQL join help needed

2002-02-13 Thread Kenneth Hylton
Hi Robert - Not an MySQL expert, but, I think what you are describing is a perfect use of MERGE tables. They take up basically no space (except to contain the names of the tables that are merged) and allow for you to merge these two tables logically and then just do whatever queries you want ag

Mysqladmin help please help

2001-11-12 Thread Wells, Kenneth L
Please help I'm at the end of my rope... I just ran a script to create databases in my SQl server, it runs fine When it completes it says remember to set a password for the mysql root user! I entered this? /usr/local/mysql/bin/mysqladmin -u root -p password password (I want password to

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 be

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) http://lists.mysql.c

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: http://www.mysql.com/manua

RE: REMOVE NOW THIS IS THE SECOND TIME

2001-09-09 Thread Kenneth Wells
Nev and emel, Stop being an asshole and take your name out of the mailing list. It does work you know -Original Message- From: Nev and Emel Gokcen [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 09, 2001 2:05 PM To: [EMAIL PROTECTED] Subject: REMOVE NOW THIS IS THE SECOND TIME

Help?

2001-09-08 Thread Kenneth Wells
Can anyone help me? I'm trying to install Snort on a windows2000 box and in the final step I get this error: Here is my error in my web viewer: Parse error: parse error in c:\inetpub\wwwroot\acid\acid_conf.php on line 7 Analysis Console for Intrusion Databases Invalid Database Type Spec

RE: Database read only

2001-09-08 Thread Kenneth Wells
I don't know why it is read-only, that is my problem. -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 08, 2001 5:05 PM To: Kenneth Wells Cc: 'MySQL-mailinglist' Subject: Re: Database read only On Sat, Sep 08, 2001 at 0

Database read only

2001-09-08 Thread Kenneth Wells
Does any one know how to turn off read only for a database? KEnny - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread

RE: problem with using mysqladmin

2001-09-08 Thread Kenneth Wells
Can anyone help me? I'm trying to set up Snort and I have downloaded MySQl shareware 3.23.40 I have a few questions. First, after I install I don't get the icon automatically on my taskbar, but I can start it myself and it is there, is that normal? Second, When I try to add a database via

HTML Checkbox -> php -> MySQL SET

2001-09-03 Thread Kenneth E. Lemons
T('a','b','c'), form_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ); === Kenneth E. Lemons Information Technology Office Computer Systems Engineer School of Engineering [EMAIL PR

compile problem

2001-08-14 Thread Kenneth
piler using the update rpm from the redhat site ? 2. If I want to use 2.95.3, which files should I have to install ? Thanks in advance for any help/comment given. Best Regards. Kenneth === compile status == # ./configure --prefix=/usr/local/mysql loading cache ./config.cache checking h

help, cant unsibscribe

2001-07-19 Thread Kenneth Johansen
AIL PROTECTED] ,but im still recieving emails. anyone got any ideas ? kenneth johansen [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the l

Re: segmentation fault

2001-07-11 Thread Kenneth Kopelson
What is mysql-VERSION-OS.tar.gz? Breughel, did you really type that exact thing on the command line, because if you did, I believe the instructions you followed intended for you to replace the VERSION-OS with your actual VERSION and OS. For example: gunzip mysql-3.23.39-pc-solaris.tar.gz | t

Re: Problem with count() - URGENT

2001-07-03 Thread Kenneth Kopelson
Just to point out, you did not describe t2 in this email, but you have redescribed t1 again, and not table t2. Also, from looking at your query, I can see the following things: If you did not have the where condition checking for the timestamp, then you would get the entry for "four" since th

Re: Problem with count() - URGENT

2001-07-03 Thread Kenneth Kopelson
Just to point out, you did not describe t2 in this email, but you have redescribed t1 again, and not table t2. Also, from looking at your query, I can see the following things: If you did not have the where condition checking for the timestamp, then you would get the entry for "four" since th

Re: MySQL JDBC

2001-06-28 Thread Kenneth Fleck
gt; Regards > Thomas > > -Original Message- > From: flag [mailto:flag]On Behalf Of Kenneth Fleck > Sent: 28. juni 2001 12:19 > To: mysql list > Subject: MySQL JDBC > > Hi ! > I have a problem accessing a MySQL DB from a java-app. On commandline I > can get in wit

  1   2   >