Re: Problems with text fields

what's you table definition, what;s your query - Original Message - From: "Thomas Kaester(global)" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 12, 2001 11:10 AM Subject: Problems with text fields Hello everybody, ich have a few problems with text fields. I want

Re: World's Money Monitoring on the Net!

Dear Mr. Stephen K. Horn, (WHITE HOUSE - USA) As being as Global Products Information Consultant, I have Invented a totally new Concept, using which the World's Money systems can be Monitored by using a single software on the Internet. Please help me to implement my Invention! I have Lost

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

This command should be invoked from the shell as the command: mysql --user mysqlusername -pmysqlpasswd database test.sql is actually running the mysql frontend with a username, password choosing database named "database" and executing all commands from test.sql before exiting. If you want to

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

Check that your sql script has the syntax use your_db_name create table tablename ... then try to exec it mysqlmysql your_script_name But first of all read the manual. It's help in most cases. - Original Message - From: C.o.m.b.u.s.t. [EMAIL PROTECTED] To: Nielsen [EMAIL PROTECTED];

Re: Building php4.0.4pl1 with mysql 3.23.32

Scott Brown schrieb: Does anyone have any suggestions??? As near as I can tell mysql_fetch_array is failing - but there is a return result otherwise I'd be getting an error message out of this routine... I'm really confused here. sounds strange! I've no problems using php4.04pl1 with

connection

how to i change the default connection from unix socket to tcpip 3306 ? currently is connection = localhost via unix socket thanks Wong - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: indexing unique fields

I think that KEY is the same as INDEX, but why UNIQUE? - Original Message - From: TJ Hunter [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 12, 2001 3:49 AM Subject: indexing unique fields I'm using the following table to store information about a merchant user. He

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

Check the structure of txt file. Does it created with SELECT ... INTO OUTFILE? Check command syntax. - Original Message - From: Joel Holtzman [EMAIL PROTECTED] To: Nielsen [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, February 12, 2001 8:51 AM Subject: Re: CREATE TABLE / Telnet

Re: MySQL version

paul herigs wrote: I want to know something about MySQL versions we have a database working with version 4.0. can you tell me were I can download this version. On the internet I only can find version 5.0 and my database don't response on this version. Something is totally wrong. MySQL-4.0

Technical Clarification

Hi, We have uploaded our site that uses Chilisoft ASP with MySQL backend database.We are now in testing stage.It works fine with just 10 records in each table. We have our original data in Excel. Now how do we convert that excel data to mysql data (which is in bulk.) and upload . The main

Total = the total of the SUM function

Hi, I was wondering if there is a way I can do this in MySQL as a one line command: SELECT COUNT(*) as Qty, Name, 100 * Qty/(SELECT COUNT(*) from Table1) as Percent from Table1 GROUP BY Name; Currently I have to do this in two lines: SELECT COUNT(*) from Table1; SELECT COUNT(*) as Qty,

Re: Performance Q

Rus wrote: Hi! Does MySQL open all tables in database when I select data from one table? No. But he will keep last x ones for faster access. My my.cnf file: [tonu@no tonu]$ cat /etc/my.cnf [mysqld] log-slow-queries=/var/log/mysql-slow-query.log set-variable = long_query_time=1 set-variable

Re: Error code list

vaibhavi writes: hello, I am working on project where my database is mysql. I need whole list of error codes eg code when there is primary key violation, or other such database related problems.I have tried perror but that all are system related problems.I want code for database

Re: Sub-Selects

Gunnar Ingvi writes: Hi there ! I?m wondering if there is planned support for Sub-Selects (e.g. HAVING and so on) in upcoming versions? I think this is very important to implement. Best regards, Gunnar Ingvi [EMAIL PROTECTED] Hi! It will come in version 4.1.

Re: Data modeling tool

On Sat, 10 Feb 2001, Cal Evans [EMAIL PROTECTED] wrote: As much as I love creating models by hand, my databases are growing to the point where I need a tool to help me "see" them. Does anyone know of a tool like ERWin or ER/Studio that supports MySQL? I do my diagrams in UML with dia. And

hi there

im trying to find out the corrent download urs's to get the shopping chart going.. i know i got to get the MySQL database, Msql-Mysql, and DBI , i found them but not shure which one to click im on windows 98 pc can you give me any direct links. i read the files but not shure still...

Re: Help - Corruption

Rodolfo Sikora writes: 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

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

Hi! The timeout in Innobase deadlock resolution is configurable in my.cnf file: you will be able to set it in units of one second (or would someone need an even greater precision?). In the future we might modify the MySQL code so that Innobase gets the information of MySQL LOCK TABLES commands

Queries editor better than standard mysql

Hi, I wonder: is there some queries editor better than standard mysql? Maybe something like dbaccess in Informix. I use mysqlgui in X, but I'd preffer something in terminal-mode... -- Mariusz Brzezinski WBK SA tel. +48 61 856 53 57 mobile +48 501 623 123

Re: UDF Problem

Thomas Kaester(global) writes: Hello everybody, I have a big UDF problem and I hope that anybody can help me! In details: I have developed an UDF which returns a string which is longer than 256 characters! But the function only returns the first 256 characters and not the

RE: BDB

Hi! "Mehalick," == Mehalick, Richard RE SSI-GRAX [EMAIL PROTECTED] writes: Mehalick, When using the BDB tables and RedHat 6.2 or 7.0, should --skip-locking be Mehalick, used or not? I know it was recommended for earlier versions of RedHat, like Mehalick, version 5.x. Now when CHECK TABLE

got error 127 - again and again

hi. i have been using mysql w/o problems for almost 1.5 years now; however, since some days ago, one of my tables keep crashing. i keep receveing 'get error 127 from table handler' errors. after doing a 'repair table' on tha particular table, everything seems to work ok - however, the same error

replication problem

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 started

Re: cronjobs crash with libmysqlclient in PAM-modules

On Mon, 6 Nov 2000, Michael Widenius wrote: Hi! "Jan" == Jan Lukoschus [EMAIL PROTECTED] writes: Description: Jan Operating system: SUN Solaris 7 or 8 Jan MySQL: 3.22.32 or 3.23.27-beta Jan When cron starts a job and tries to authenticate the associated user Jan with a PAM-module

Changing DB type

Hi all, I have a couple of MyISAM tables, but I want them changed to BDB tables. Can I let mysql do so automatically? Or should I do a dump, recreate the table as BDB and insert all the data again? TIA, Marc - Before

Re: got error 127 - again and again

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

Re: replication problem

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

connection faild

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:

Upgrading

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

Win2000 cluster and MySQL

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,

tab in mysqlshell

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

Re: MySQL GUI for Windows

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

Re: Corruption

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

Re: MySQL GUI for Windows

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 and edit

Re: MySQL GUI for Windows

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 able to

Can anyone suggest a more efficient method

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

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

Re: Upgrading

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 simply

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

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

Re: indexing unique fields

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

Use of mysql_use_result in ODBC driver ?

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

DECIMAL column type links to Access as TEXT

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

Here you have, ;o)

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

Here you have, ;o)

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,

MS Access - This Recordset is not updateable

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

MyVbQL.dll version 2.0.0 released

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

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

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.

Re: Here you have, ;o)

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

Access 2000 and MySQL

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

replication errors

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.

SELECT DISTINCT question

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

Here you have, ;o)

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

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

$ 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

RE: Duplicate entry error??

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:

Exporting DB's

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: CREATE TABLE / Telnet (Linux / Unix server)

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

Re: Re: Corruption

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

Mysql 3.23-14 keeps dieing on me...

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:

Re: Exporting DB's

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

Error code 13

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

BDB not working well

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

Reading from merge table while updating underlying table

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

Localization

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

how to 'live' withou transactions?

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

Re: Want to Deny Access into MySql Database

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 I

Re: Installing on Solaris machine

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 of

Re: how to 'live' withou transactions?

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

Who is using BDB tables in critical environment?

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 date. And the BDB page-level

how to add to a set

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

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

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

Re: Error code 13

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

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

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

Re: SET question

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

"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, but

Password routine

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

Issues compiling under Solaris

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

external access to mysql

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

Re: mysqlimport - LOAD DATA LOCAL INFILE

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 LOCAL INFILE

Re: external access to mysql

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

Insert BLOB

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

special characters messing me up

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

Shell Shocking

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

Re: Shell Shocking

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 the

Urgent-UDF problem

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?