Urgent-UDF problem

2001-02-12 Thread Thomas Kaester(global)
Hello Sinisa and everybody else, sorry that I contact you directly! But I tried all suggestions and it still doesn't work! The UDF return string has always 256 characters! I've used my_malloc and my_free! Also I allocated the necessary memory in xxx_init()! But it doesn't work! What can I do? Who

mysql@lists.mysql.com

2001-02-12 Thread root2
>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator: >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release: my

Re: special characters messing me up

2001-02-12 Thread Rolf Hopkins
"^M"??? You sure it is that? Anyway, it is most likely to do with carriage returns. Windows uses CR and LF to indicate a new line, while Linux and Macs only use LF. Hopefully this will help. Don't know what you can do about it though. - Original Message - From: "John W Ford" <[EMAIL

Re: Shell Shocking

2001-02-12 Thread Colin Faber
Donald, Poor administration of the server or incorrect privileges assigned to your user account. Donald Korth wrote: > Hello > > The hosting company has given me a user name and passwd . When i log into my own >site thro' a telnet session i 'm able to view all the databases created in t

Shell Shocking

2001-02-12 Thread Donald Korth
Hello The hosting company has given me a user name and passwd . When i log into my own site thro' a telnet session i 'm able to view all the databases created in the server that includes DBs not created by me . I also did a "USE DB" command to connect to a DB that wasn't mine . Also "Sho

special characters messing me up

2001-02-12 Thread John W Ford
I can't figure out why my windows machine leaves "^M" character at the end of each line of code. This causes the file to be messed up when I put it on the Linux server. It makes my perl interpreter look for a file named ^M after the very first line. #!/usr/sbin/perl also... what else I can't fi

Insert BLOB

2001-02-12 Thread Eric Raymond G. Patdu
Hello there, I'm currently developing an app in VB with MySQL as the database and I'm having a hard time inserting a BLOB into MySQL. Can somebody share with me a code snippet on how to do this? Thanks, Eric

Re: external access to mysql

2001-02-12 Thread Teddy A Jasin
Hi, again phpmyadmin can do this :) Teddy - Original Message - From: "Mike Yuen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 13, 2001 1:45 PM Subject: external access to mysql > I and 2 others are working on a web site an occasionally. Each of us are > in d

Re: mysqlimport - LOAD DATA LOCAL INFILE

2001-02-12 Thread Irmund Thum
Rus schrieb: > > Maybe it's problem with end_of_line symbol. > You could use PHP to insert records directly into db. > > - Original Message - > From: Irmund Thum <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Monday, February 12, 2001 2:30 PM > Subject: mysqlimport - LOAD DATA LOC

external access to mysql

2001-02-12 Thread Mike Yuen
I and 2 others are working on a web site an occasionally. Each of us are in different locations and exchange info email. Some of them need to query the database to compare results with what is on the site with the MySQL database. My question is, is there a way to allow access to my database by

Issues compiling under Solaris

2001-02-12 Thread Alan W. Rateliff, II
Previously someone had mentioned that the issues covered by my FAQ (located at < http://users.talstar.com/forager/MySQL-HOWTO.html >) had been taken care of with releases past 3.23.28. However, just tonight I found that the problem with the broken Solaris term.h file still exists, and after runni

Re: replication in 3.23.32

2001-02-12 Thread Benjamin Pflugmann
Hi. On Mon, Feb 12, 2001 at 05:30:04PM -0700, [EMAIL PROTECTED] wrote: > Hello All, > > after upgrading our servers to 3.23.32 (the most recent release best I > can tell), Meanwhile an update is out (since yesterday night, I think). Didn't see an announcement yet - hopefully I don't get scolded

Password routine

2001-02-12 Thread Andrea
Hi all I am interesting on password routine in mysql Could some body help about this routine ? I download the source code of MySql, but i am not yet found about this routine Maybe some body have this routine in Delphi / pascal code Help me please Regards --

Re: Mysql 3.23-14 keeps dieing on me...

2001-02-12 Thread John Jensen
First off, check your cables. If one looks pinched or chewed, try a fresh one. If one is particularly long, try to replace with a shorter one. Cables are a weak link in the hardware. On 12 Feb 2001, at 17:16, Scott McDaniel wrote: > > Dear Everyone, > > I am presently running Mysql 3.23-14 s

Re: Re: Corruption

2001-02-12 Thread Sasha Pachev
On Monday 12 February 2001 16:57, Rodolfo Sikora wrote: >mysql> select VERSION(); >+-+ >| VERSION() | >+-+ >| 3.23.31-log | >+-+ >1 row in set (0.00 sec) > >I swer I'm running 3.23.31 (with pgcc) but let's forget about "Contratulation message", I think the er

Re: SET question

2001-02-12 Thread Cindy
"Thalis A. Kalfigopoulos" writes: >So in your case that you want to add "d" to a tuple that is "a,b,c" you do >UPDATE table SET set_val=15 WHERE my_cond; >since 15 is in binary (the leftmost '1' is the flag that tells mysql to >add the "d" in your set) > >does it make any sense? Yes,

Re: Is this possible

2001-02-12 Thread Rus
mysqldump creates a text file with such structure. - Original Message - From: Joel Holtzman <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 13, 2001 1:47 AM Subject: Is this possible > Hello, I am starting to get some success from Load data. Ok, now with that, > here

Re: SET question

2001-02-12 Thread Thalis A. Kalfigopoulos
This is a reply to the SET column UPDATE question (I deleted to e-mail, oups!). The question was that you have a column of type SET and value ("a,b,c") and you want to make this ("a,b,c,d") In the __MySQL MANUAL__ it says that the SET type is actually stored numerically and in particular "with

Re: Can anyone suggest a more efficient method

2001-02-12 Thread Rus
I am not shure about recalculating constants in mysql. Try . where activity.event_time_unix <= const .. where const is the result of 981990589 - (2* ( 24 * (60 * 60) ) ) - Original Message - From: Bryan Hunt <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, F

Re: mysqlimport - LOAD DATA LOCAL INFILE

2001-02-12 Thread Rus
Maybe it's problem with end_of_line symbol. You could use PHP to insert records directly into db. - Original Message - From: Irmund Thum <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, February 12, 2001 2:30 PM Subject: mysqlimport - LOAD DATA LOCAL INFILE > for my JavaScrip

Re: CREATE TABLE / Telnet (Linux / Unix server)

2001-02-12 Thread Rus
I mean, did you select into outfile from mysql or try to import file with some other format. You are trying to import file with some structure, where fields and lines are separated with some characters. You have to read manual on LOAD DATA INFILE. - Original Message - From: Joel Holtzma

Re: Mysql 3.23-14 keeps dieing on me...

2001-02-12 Thread Benjamin Pflugmann
Hi. Note that 3.23.14 (10. Apr 2000) was still considered alpha quality, so the general suggestion is to upgrade to current 3.23.33 (12. Feb 2001) release (declared stable). The chances are high that the problem you encounter has been fixed up meanwhile. Bye, Benjamin. PS: For more in

Re: Mysql 3.23-14 keeps dieing on me...

2001-02-12 Thread Jorge del Conde
Hi, Could this be some kind of TCP / IP error or hardware malfunctioning ? Try upgrading to the latest (stable) 3.23.33 release. Regards Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ M

Re: Error code 13

2001-02-12 Thread Jorge del Conde
Hi, This sounds like a permissions problem. Make sure your database directory is set to 770 and that the files inside (tables) are set to 660. example: # chmod 770 demo # chmod 660 demo/* Regards Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge d

RE: Data modeling tool [Long Rant and then some information]

2001-02-12 Thread Cal Evans
Greetings list: I'm going to reply to my own message here. I've received 2 comments on my use of the word cartoonish when describing the interface to DeZign. While their approach was different, both basically wanted to know what I found cartoonish about the interface. First let me say that I w

how to add to a set

2001-02-12 Thread Cindy
OK, is there an easy way to ADD a value to a set type without having to enumerate all that's there already? I've looked through http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SET but it doesn't say anything about adding values to the current set. It rather looks like a

Who is using BDB tables in critical environment?

2001-02-12 Thread Jeremy D. Zawodny
I feel like the BDB tables have been around long enough to be reasonably stable and mature enough to have some confidence in them. But it always helps to hear people say things like: I've been using BDB tables in a high-volume environment with no problems since . And the BDB page-level lockin

Re: how to 'live' withou transactions?

2001-02-12 Thread Rolf Hopkins
You could upgrade to the latest version which now supports transactions. - Original Message - From: "Christian Dechery" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 13, 2001 10:17 Subject: how to 'live' withou transactions? > How can I do 'transaction' withou begi

Re: Installing on Solaris machine

2001-02-12 Thread Rolf Hopkins
The manual is a very good place to start. There is even a section specifically dealing with Solaris. - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 12, 2001 22:43 Subject: Installing on Solaris machine > Hello, > Do you have a set o

Re: Want to Deny Access into MySql Database

2001-02-12 Thread Rolf Hopkins
I don't think that's possible. Mind you, they won't be able to do much anyway as they didn't supply any passwords. - Original Message - From: "lkeeton" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 12, 2001 23:30 Subject: Want to Deny Access into MySql Database >

how to 'live' withou transactions?

2001-02-12 Thread Christian Dechery
How can I do 'transaction' withou begin/commit/rollback? I don't understando how lock tables can replace it... if I have update thing set this=this; insert into stuff values(this, this and that); insert into thing_stuff values(from both thing and stuff); or whatever... and I want to be sure th

Localization

2001-02-12 Thread Lisle Robins
I am localizing (in French) a Delphi MySQL application which uses the Zeos components which in turn use libmysql.dll. Can anyone suggest how to translate the login dialog screen and other messages in libmysql.dll? Is there already a French version around? Thanks. Lisle Robins

replication in 3.23.32

2001-02-12 Thread John Cartwright
Hello All, after upgrading our servers to 3.23.32 (the most recent release best I can tell), we can't seem to get our one-way replication restarted. We added the server-id to the my.cnf file and did a "reset master" and "reset slave" and although the status shows OK, updates are not being transf

Re: Virus Alert

2001-02-12 Thread William R. Mussatto
McAfee claims to have had protection against it since Aug 2K. On Mon, 12 Feb 2001, Ashley M. Kirchner wrote: > Date: Mon, 12 Feb 2001 12:11:36 -0700 > From: Ashley M. Kirchner <[EMAIL PROTECTED]> > To: MySQL Mailing List <[EMAIL PROTECTED]> > Subject: Virus Alert > > > Two messages *just*

Reading from merge table while updating underlying table

2001-02-12 Thread Fred van Engen
Hi, Is it okay to write to a table that is part of a merge table? The documentation is not explicit on this as far as I understand it. Anyway, when I try this in a typical logging scenario that merge tables are supposed to be useful for, I sometimes get incorrect results. My tables have these f

BDB not working well

2001-02-12 Thread Christian Jaeger
Hello I've just compiled mysql-3.23.32 (tar.gz) with with the bdb tgz (from mysql.com) on my linuxppc machine (powermac 9600/300mhz, kernel 2.2.17 , glibc 2.1.3, gcc-2.95.3). configure --with-charset=german1 --with-extra-charsets=latin1 --with-berkeley-db I find the following problems: (1. I di

SV: CREATE TABLE / Telnet (Linux / Unix server)

2001-02-12 Thread Pål Wester
Hi Joel Actually yes!! It has to be of sql syntax, so if you have a .cvs you'll have to ro a find replace like this: s/\n/');\nINSERT INTO MY_TABLE( myvalue1, myvalue2, myvalue3, .., myvaluen ) values ( '/g; s/;/','/; SO THAT 34;4356;346;346346;34636 35;4;4;34;34 BECOMES: '); INSERT INTO MY_TA

Error code 13

2001-02-12 Thread Rashid Zolqarnain
Hello, I copy a database "demo" from one server to another. The file types are the same as other databases that exist in the destination server. I stopped and restarted mysql server. When I try to use that database using the command "use demo" it gives me the following error "Error code

Re: Exporting DB's

2001-02-12 Thread Atle Veka
mysqldump --help or, read up on it on www.mysql.com :) .. Atle On Mon, 12 Feb 2001, Jeremy Arntz wrote: > Ok this is a total newbie question, but if I develope a DB on my developement server >and want to export it to the live server what is process I use to do this? > > TIA, > Jeremy J. Ar

Re: SELECT DISTINCT question

2001-02-12 Thread Thalis A. Kalfigopoulos
> Say I have a bunch of records in a table with a bunch of fields. One of > those fields is cluster_id. It is not unique. However, I want to make a > unique set. I want one record for each cluster_id value. I don't care > which record that is. > > Right now, I do: > SELECT DISTINCT cluster_id FRO

Mysql 3.23-14 keeps dieing on me...

2001-02-12 Thread Scott McDaniel
Dear Everyone, I am presently running Mysql 3.23-14 server on a dual processor Linux box. It is the only service on the server while interactions are done via a web interface (Perl CGI) on a separate web server. About once an hour, I get the error: Aborted connection 52 to db: 'ihost' user: 'we

Re: Re: Corruption

2001-02-12 Thread Rodolfo Sikora
mysql> select VERSION(); +-+ | VERSION() | +-+ | 3.23.31-log | +-+ 1 row in set (0.00 sec) I swer I'm running 3.23.31 (with pgcc) but let's forget about "Contratulation message", I think the error is something related to master.info position. Thanks for you

Is this possible

2001-02-12 Thread Joel Holtzman
Hello, I am starting to get some success from Load data. Ok, now with that, here's my question, 'cause I can't find the answer in the manual. Can I create a table *solely* by pointing to a text file with the coloumns/records as part of the text file? What I mean is, instead of creating the colum

Re: !!! Mysql hangs after some days on FreeBSD 4.0I-Helll

2001-02-12 Thread Danny
-Hello - If you are running FreeBSD 4.0 why not install mysql using /usr/ports/database/mysql-server.3.xxx make install make clean On Tue, 13 Feb 2001, pdewaha wrote: > Hi, > I've mysql 3.23.32 running on FreeBSD 4.0. > It runs a site with heavy traffic and heavy > database

Re: Access 2000 and MySQL - this isn't _my_ choice

2001-02-12 Thread Irmund Thum
WJ McEachran schrieb: > > I've just been exposed to Access 2000 :-( > I'd be interested in any comments about using Access 2000 as a front-end > for MySQL (this isn't _my_ choice). > > How is it done? What are the pitfalls? > > Please c.c. me directly as I'm in the process of resubscribing to t

Re: CREATE TABLE / Telnet (Linux / Unix server)

2001-02-12 Thread Joel Holtzman
I turned my access db into excel, and into .csv So that's the structure of my text file. When I use "Load data infile..." I get the 10 warnings. 10 for the 2 columns, and 8 records. Does it have to be a special format? I have the file.txt on the server. I can point to it. I just can't get it to i

Re: Duplicate entry error??

2001-02-12 Thread Atle Veka
You have set EKey to be unique, so if you already have another row with EKey = 13, you cannot establish an additional row with the same key. (unique keys can be either set by primary key(), or unique()) .. Atle On Mon, 12 Feb 2001, Paul Wilkinson wrote: > Thanks in advance for your help! >

Exporting DB's

2001-02-12 Thread Jeremy Arntz
Ok this is a total newbie question, but if I develope a DB on my developement server and want to export it to the live server what is process I use to do this? TIA, Jeremy J. Arntz Digital Architect Simplified Development [EMAIL PROTECTED] http://www.simplifiednow.com/

RE: Duplicate entry error??

2001-02-12 Thread Quentin Bennett
Hi, You have a unique key defined which includes Ekey and another field (the key 2 mentioned in the error message), and the entry "other_field = '88' and Ekey='252'" has already been used. Regards Quentin -Original Message- From: Paul Wilkinson [mailto:[EMAIL PROTECTED]] Sent: Tuesday,

MySQL Windows GUI (admin tool)

2001-02-12 Thread Gregg Housh
Ok, its been awhile since i've mentioned my tool (MyDBAdmin) on this list. Since then Ive gotten alot of it done. Most of the simpler stuff. I have a little ways to go before I can start sharing it with people. Below is the list that I originally built from my idea's and from responses give

I can not alter the new index num.....

2001-02-12 Thread Kent Hoover
$ myisamchk --set-autoincrement-value=1 YourTable.MYI would reset the number to 1 for you. If you do not remove existing records from your table, your MySQL could generate errors as the new value collides with an existing record. Cheers, Kent -

Here you have, ;o)

2001-02-12 Thread Mike Schwartz
Hi: Check This! - 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-mai

Re: Re[2]: MySQL GUI for Windows

2001-02-12 Thread Gregg Housh
keywords, feature-limited. I am working on one, why I dont say that it is the best or anything. It will be out shortly (a week or 2 depending on how much time I can spend.) It will not be feature limited. And it will be based on the open-source objects being developed by Eric Grau, MyVBQL, whic

mysql hangs on client start (and mysql_install_db)

2001-02-12 Thread Drew Degentesh
>Description: mysql hangs. This is really frustrating. History: -had 3.23.27 running. Had to restart the machine. -on reboot, no clients would connect (command line , Perl or PHP) -tried to restart by rc.d/initd/mysql stop, that timed out -killed off processes with kill -9 -tried to restart, clien

Re: Update: Status of MySQL 4.0/Innobase/transactions & row level locks

2001-02-12 Thread Tim Bunce
On Mon, Feb 12, 2001 at 03:02:49PM +0200, Heikki Tuuri wrote: > [...]. Currently, in MySQL > you must call UNLOCK TABLES before issuing another LOCK TABLES, because > there is no deadlock detection in MySQL itself. I believe a LOCK TABLES does an automatic atomic UNLOCK TABLES of any that were l

Recompiling local_lim.h, internals.h into libpthread.a: How do I?

2001-02-12 Thread Andrew L. Matthews
Hello. I am referring to instructions to correct a problem involving 1000+ concurrent connections. The relevant section in the MySQL manual is Installing MySQL/System-specific Issues/Linux Notes (All Linux Versions). The relevant paragraphs, from the manual, are as follows: “If you plan to have

number of instances of gw

2001-02-12 Thread nuts
With mysql installed on linux, and called by a perl program, we see about 20 instances of mysql running at one time. Is this usual & normal? Mike Clark Coconut Island Software [EMAIL PROTECTED] 888 999 2181 - Before posting, p

Duplicate entry error??

2001-02-12 Thread Paul Wilkinson
Thanks in advance for your help! How does one replace a single field value when the value repeats? I tryed the following and get an error message "Duplicate entry '88-252' for key 2" UPDATE DKWords SET EKey='252' WHERE EKey='13' What is wrong? Paul -

Re[2]: MySQL GUI for Windows

2001-02-12 Thread James Treworgy
There is a free, feature-limited version. GBD> Mascon is sweet, but it's not free :) >> can anyone suggest a good GUI client to suggest to MySQL hosting >> customers? -- Best regards, Jamesmailto:[EMAIL PROTECTED] -

SELECT DISTINCT question

2001-02-12 Thread Rishi L Khan
Say I have a bunch of records in a table with a bunch of fields. One of those fields is cluster_id. It is not unique. However, I want to make a unique set. I want one record for each cluster_id value. I don't care which record that is. Right now, I do: SELECT DISTINCT cluster_id FROM my_table Th

replication errors

2001-02-12 Thread Virgil Palitang
I have a one-way replication setup where the master is out of state, and the slave is local. The connection between the machines is high-speed, but not 100% reliable. Every once in a while, my slave thread stops because of a duplicate key entry. I'm puzzled by this for several reasons: 1. Insertio

Access 2000 and MySQL

2001-02-12 Thread WJ McEachran
I've just been exposed to Access 2000 :-( I'd be interested in any comments about using Access 2000 as a front-end for MySQL (this isn't _my_ choice). How is it done? What are the pitfalls? Please c.c. me directly as I'm in the process of resubscribing to this list. -- Bill McEachran

Re: [VIRUSALERT] Don't open attachments in mails with the subject "Here you have ;)"

2001-02-12 Thread Pål Wester
this is a VBS virus which sends itself to all you're adresses in Outlook.. You should _NOT_ run the attachment.. I didn't find any information about this file on www.norman.com, but It is harmfull... If you're interested in the code here it is, not harmfull as text though :o) ---AnnaKournikov

limiting query time

2001-02-12 Thread Mark Maggelet
Hi, Is there a way to have mysql give up on a query after a certain length of time? thanks, - Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Virus Alert

2001-02-12 Thread Ashley M. Kirchner
Two messages *just* came through the list with almost no content in them. All they said was: Hi: Check this! Those are messages generated by the AnnaKournikova virus, which currently no AV will detect. This virus affects Outlook in general. "A warned man counts for two."

Re: MySQL GUI for Windows

2001-02-12 Thread Graeme B. Davis
Mascon is sweet, but it's not free :) > can anyone suggest a good GUI client to suggest to MySQL hosting > customers? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

nested sets vs. key path method

2001-02-12 Thread Christian Fellner
Hello, at the time I try to figure out what's the best way to get a kind of parent/child - hierarchy with unlimited subchild. My special attention is situated on really fast SELECT statements. Actually I'm using nested sets like: CREATE TABLE Personnel (emp CHAR(10) PRIMARY KEY, sala

Re: Here you have, ;o)

2001-02-12 Thread Nathan
If you hadn't read up on this yet, the attachment AnnaKournikova.jpg.vbs which is accompanying Mr. Arora's e-mail is a virus. McAfee doesn't know what the damage is, because it was created by a worm that changes the damage slightly for every lucky recipient. Just a heads up. Cheers, # Nathan

thread_cache_size on linux

2001-02-12 Thread Byron Albert
Hello, I am trying to tune mysql on linux for a web based application. Reading the docs I found thread_cache_size I checked what it was set to by default and found that it was 0. In the docs it says That it doesn't make much difference if you have a good thread implementation. So my ques

open source database benchmark

2001-02-12 Thread Thalis A. Kalfigopoulos
Hi all, this should be interesting http://osdb.sourceforge.net/ . It is an Open Source Database Benchmark. It is really early in its development, and little has been implemented (barely compiled, and didn't work in the end) but looks like an interesting effort. regards, thalis

Re: !!! Mysql hangs after some days on FreeBSD 4.0I

2001-02-12 Thread Ken Menzel
Hi Patric, I believe you will have many problems of this kind with older versions of FreeBSD. You should update, if you can, to FreeBSD-stable. See this URL for easy instructions on how to update if you don't know how. http://www.mostgraveconcern.com/freebsd/ and look at the CVSUP info. Th

MyVbQL.dll version 2.0.0 released

2001-02-12 Thread Eric Grau
MyVbQL.dll version 2.0.0 released. The new version can be download at http://www.icarz.com/mysql/index.html Version 2.0.0 contains the following changes: MYSQL_CONNECTION object changes: - fixed OpenConnection method returning incorrect state upon successful connection - added AutoUpdat

UDF - string problem

2001-02-12 Thread Thomas Kaester
Hello Sinisa and everybody who can help me! I try to develop a UDF which returns a string! But I get only 256 characters of the string! I tried to change my alloc function, so that I only use my_malloc and my_free! But the result is the same! The necessary memory is allocated in xxx_init() and

MS Access - This Recordset is not updateable

2001-02-12 Thread John Halladay
I've scanned past e-mails and haven't found this in the archives. This is probably something simple that I'm overlooking. If I'm connecting to a table in MySQL from MS Access 97 and getting the message "This Recordset is not updateable" whenever I try and change anything, where can I change the

Here you have, ;o)

2001-02-12 Thread John Runnels
Hi: Check This! - 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-m

Here you have, ;o)

2001-02-12 Thread ajay arora
Hi: Check This! - 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-mai

DECIMAL column type links to Access as TEXT

2001-02-12 Thread Apolinaras 'Apollo' Sinkevicius
I found a problem with MyODBC when linking tables to Access97. It considers DECIMAL type as TEXT (and you know you can't change that without going into code). I changed the column type into FLOAT and it fixed the problem, but at the same time it would be nice if MyODBC either gave you a choice

RE: Can anyone suggest a more efficient method

2001-02-12 Thread Johnson, Gregert
SELECT unit.* FROM unit LEFT JOIN activity ON unit.dialup_user = activity.dialup_user AND !(activity.event_time_unix ...) AND unit.status = 'Active' WHERE activity.dialup_user IS NULL; --Greg Johnson -Original Message- F

Use of mysql_use_result in ODBC driver ?

2001-02-12 Thread Patrick FICHE
Hi all, I would like to change the do_query function in execute.c module in the ODBC driver to use mysql_use_result function instead of mysql_store_result function. There is currently some comments with an eventual problem in case of SQLRowCount function. To my mind, the only thing would be tha

Re: indexing unique fields

2001-02-12 Thread btjones
You don't need the INDEX (email) at the end of this statement, it's creating a second index on the same data. UNIQUE specifies that an index should be created. TJ Hunter <[EMAIL PROTECTED]> wrote: I'm using the following table to store information about a merchant user. He uses his email add

Re: Persistant Connection

2001-02-12 Thread Sasha Pachev
On Saturday 10 February 2001 20:31, Benjamin Pflugmann wrote: >Hello. > >On Fri, Feb 09, 2001 at 09:53:45AM -0500, [EMAIL PROTECTED] wrote: >> Good Morning: >> >> We have a system of databases (in the plural) which number in the hundreds >> on individual servers. I want to open a persistant conn

!!! Mysql hangs after some days on FreeBSD 4.0I

2001-02-12 Thread pdewaha
Hi, I've mysql 3.23.32 running on FreeBSD 4.0. It runs a site with heavy traffic and heavy database interaction. After starting mysql it hangs after some days. Mysql server is still in the processlist, but it is not possible to connect to the sql

Configure with pgcc

2001-02-12 Thread Brian P. Austin
Has anyone had success compiling .32 mysql on linux using pgcc. I export the variables correctly, but it fails in configure when trying to run the test program. Right after test return of sprintf(). anybody have success with pgcc? ---

Re: Upgrading

2001-02-12 Thread Jon Rosenberg
you need to grab the .i386.rpm files...you have the source code RPM. - Original Message - From: "Ben Ocean" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 12, 2001 10:14 AM Subject: Upgrading > Hi; > I'm trying to upgrade to the latest distro. I thought I could simp

Re: Upgrading

2001-02-12 Thread Jan-Aage Bruvoll
On Mon, 12 Feb 2001, Ben Ocean wrote: > I'm trying to upgrade to the latest distro. I thought I could simply d'l > the distro, go in as root (Apache, RedHat) and enter the following command: > # rpm -U MySQL-3.23.32-1.src.rpm Being no rpm expert, the above suggests that you fetched the source di

RE: MySQL GUI for Windows

2001-02-12 Thread Crercio Osmaildo da Silva
Hi, DBTools (http://dbtools.vila.bol.com.br) is totally free and full functionality. It works only for Windows platform and it has a lot of features including Import Wizard to migrate data from other sources to mySQL. []'s Crercio O. Silva -Original Message- From: indrek siitan [mailto

Can anyone suggest a more efficient method

2001-02-12 Thread Bryan Hunt
I have two tables, one contains units one contains activity I run this query .. select unit.dialup_user, unit.address1, activity.dialup_user from unit LEFT JOIN activity ON (unit.dialup_user = activity.dialup_user) where !(activity.event_time_unix > (981990589 - (2* ( 24 * (60 * 60) )

Re: MySQL GUI for Windows

2001-02-12 Thread Teddy A Jasin
Use PhpMyadmin - Original Message - From: "indrek siitan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 12, 2001 11:00 PM Subject: MySQL GUI for Windows > Hi, > > can anyone suggest a good GUI client to suggest to MySQL hosting > customers? > > it should: > > * be

Re: MySQL GUI for Windows

2001-02-12 Thread jurban
urSQL -> http://www.urbanresearch.com/ursql On Mon, 12 Feb 2001, indrek siitan wrote: > Hi, > > can anyone suggest a good GUI client to suggest to MySQL hosting > customers? > > it should: > > * be able to display table structures, add and alter tables > (field, indexes) > > * show a

Re: Corruption

2001-02-12 Thread Sasha Pachev
>This table is getting corrupted all the time (twice a week). >We have only SELECTS and INSERTS with little updates. (we have 140.000 registers growing faster to 100 :)) >CREATE TABLE conta ( idConta int(8) unsigned NOT NULL auto_increment, idDominio int(6) unsigned DEFAULT '0' NOT NUL

Re: MySQL GUI for Windows

2001-02-12 Thread Adam Brake
For web-based GUI admin, I'd highly recommend phpMyAdmin (http://phpwizard.net/phpMyAdmin/) "indrek siitan" <[EMAIL PROTECTED]> on 02/12/2001 10:00:27 AM To: [EMAIL PROTECTED] cc:(bcc: Adam Brake/Raleigh/TEKELEC) Subject: MySQL GUI for Windows Hi, can anyone suggest a good GUI cl

tab in mysqlshell

2001-02-12 Thread Jesper Bunch
Hey I just upgraded to mysql 3.23.32 but now i can't use the tab in the mysqlshell (like in you do in various unix shells to get a list of valid names, etc.). How do I enable it in again ? // Jesper

Win2000 cluster and MySQL

2001-02-12 Thread Thierry Coopman
Hi, A collegue of me is asking if it is possible to use MySQL on a Windows 2000 cluser. It is in an Active/Standby configuration with shared disks. If the active server fails, the standby takes over the services, so it fires up the MySQL service. I have no idea if this is a good solution, in

Upgrading

2001-02-12 Thread Ben Ocean
Hi; I'm trying to upgrade to the latest distro. I thought I could simply d'l the distro, go in as root (Apache, RedHat) and enter the following command: # rpm -U MySQL-3.23.32-1.src.rpm When I do I get no error messages, but no upgrade seems to occur (i.e., I get the old version number at the my

Want to Deny Access into MySql Database

2001-02-12 Thread lkeeton
I have set up my passwords into the mysql database but I am having a problem when somebody just logs in as just (mysql) without mysql -u user -ppassword. By just putting in mysql they can get into mysql, but they can't get into any of the databases unless they log on and supply a user and a pas

connection faild

2001-02-12 Thread mysql
hi i using linux 6.2,mysql and coldfusion 4.5 the odbc connection in cold fusion is failed for setup can anyone help ? i don know how to start on checking. wong - Before posting, please check: http://www.mysql.com/manual.p

Re: replication problem

2001-02-12 Thread Gerald L. Clark
Stephen Wong wrote: > > I try to use the replication feature of the latest stable version 3.23.32. Everyting > works find when I follow the instructions until when I tried to stop the slave and > then start it. It generated the following messages in the error log: > > 010212 18:28:08 mysqld s

Re: got error 127 - again and again

2001-02-12 Thread Rodolfo Sikora
So, you're a lucky guy! I got the same "problem" but more strange and comic. I've been using perl / DBI to access mysql on my scripts, an week ago I got the same error as you. I runned out repair my tables (everyone says that this error is about corrupted tables), after repair and local/consol

MySQL GUI for Windows

2001-02-12 Thread indrek siitan
Hi, can anyone suggest a good GUI client to suggest to MySQL hosting customers? it should: * be able to display table structures, add and alter tables (field, indexes) * show and edit table data * be freeware (or it can be half-commercial, as long as the above functionality is a

Installing on Solaris machine

2001-02-12 Thread mmflynn1
Hello, Do you have a set of simple instructions to install mysql on Solaris machine? Your help is appreciated. Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.

  1   2   >