Re: addition for manual section 24.5.1

2001-08-14 Thread Jeremy Zawodny
On Mon, Jul 30, 2001 at 10:51:22AM +0200, Werner Stuerenburg wrote: I don't know where to send this to, so someone who knows please forward it to the appropriate address. I've submitted a doc patch to include that information. Thanks, Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED]

Re: Permissions Problems

2001-08-14 Thread indrek siitan
Hi, Can anyone explain why this is happening? root@www:/# mysql -u dgadmin -h www.4cdg.com -p cdgcatalog Enter password: ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) remove the space between -p and the password. Rgds, Indrek -- For technical

How do I find out more about a bug in an earlier version of MySQL?

2001-08-14 Thread James Robertson - Composite Design
Hello How can I find out more information about a MySQL bug fixed in release 3.23.9 and described in the change notes as 'Fixed problem with 8-bit characters as separators in LOAD DATA INFILE.'? [I wish to LOAD DATA INFILE using 0xBF as the FIELD TERMINATOR and 0xC6 as the LINE TERMINATOR but

MySQL daemon and inetd

2001-08-14 Thread VDA
Hi, Friday, August 10, 2001, 8:05:41 PM, David Harrison [EMAIL PROTECTED] wrote: DH You can't use inetd, but if you have a machine with System V type run DH levels, the file support-files/mysql.server can be placed in DH /etc/rc.d/init.d or whatever your flavor of UNIX uses, with appropriate DH

Re: MySQL daemon and inetd

2001-08-14 Thread joseph . bueno
VDA wrote: Hi, Friday, August 10, 2001, 8:05:41 PM, David Harrison [EMAIL PROTECTED] wrote: DH You can't use inetd, but if you have a machine with System V type run DH levels, the file support-files/mysql.server can be placed in DH /etc/rc.d/init.d or whatever your flavor of UNIX uses,

php/mysql user auth question

2001-08-14 Thread Kit Kerbel
ok...here's the deal. I have successfully developed a script to verify user authenticity. however, i need to verify what the User Type is for purposes of redirection to a certian page. ++-+---+--+ | ID | BearID | SSN | UserType |

Lost bin-log(s) following logrotate affecting recovery, replication

2001-08-14 Thread Joel Fowler
Environment: Red Hat 7.1 mysqld 3.23.36-log /etc/my.cnf as follows: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock log-bin=/bu/mysql/online-log/iServ2 log-bin-index=/bu/mysql/online-log/iServ2.index [mysql.server] user=mysql

Re: php/mysql user auth question

2001-08-14 Thread Ståle Undheim
On Tue, 14 Aug 2001, Kit Kerbel wrote: This is a sample of my table. how would i go about checking the user type after I have verified that the user exists in the table? I tried this query: // Determine User Type For Redirection $redirect = SELECT UserType FROM User WHERE

Problems with MYSQL-D-MAx for win 98 DROP TABLE

2001-08-14 Thread Luciano Pulvirenti
If you create a Berkeley-DB table (es. CREATE TABLE TEST TYPE BDB) is not possible delete it after. The command DELETE TABLE TEST responds Table unknown. Thank You Luciano - Before posting, please check:

INSERT problem

2001-08-14 Thread Mariusz Muszalski
Look at this MS SQL: Declare @BF char(10) Declare @BL char(10) SET ROWCOUNT 1 Select @BF=Date From Results Where GameID=1 Order by Date ASC Select @BL=Date From Results Where GameID=1 Order by Date DESC Select @BF As BF, @BL As BL -- Now wonna to implement above to

Insert Delayed

2001-08-14 Thread Ben Smith
Subject : Database Hello all, We have various routines which Insert in to tables. And in some cases there are alot of rows involved, which understandably can take some time. I just want to check that my understanding of the INSERT DELAYED option is correct. When using DELAYED, are all rows

MySQL++ 1.7.9 static lib for Mac OS X

2001-08-14 Thread Sinisa Milivojevic
Hi1 I have built MySQL++ lib on OS X and have uploaded static version of the library for Mac OS X on MySQL++ page. OS X users just have to install manually that library and include files and can start using it. Library is built with GNU 2.95.2 and is therefore useable only with that compiler

auto_increment vs. heap tables

2001-08-14 Thread Leos Bitto
Hello, I am currently changing a simple PHP4-based application from PostgreSQL 7.1 to MySQL 3.23. I have some tables in the database which I would like to create as TYPE=HEAP in MySQL. Because I have read the MySQL manual (applause here, please!) I know that auto_increment cannot be used there.

RE: INSERT problem

2001-08-14 Thread Yosi Oren
Hi, You are trying to use nested select for that update wich MySQL do not support insted use : update table set field = value from table inner join table where bla = bla Sincerely, Yosi Oren VP,RD manager Tel : +972 4 908 2180 ext 217 Fax :

Info about Table and Indizes

2001-08-14 Thread Benjamin Boksa
Hi List! I got some questions about tables: - How do I get the creation date of a certain table? - Is there a SQL-statemanet to delete tables that have a certain age? - If I delete a table do all the indizes created on that table get dropped automatically? Thanks in advance for your answers,

re: deleing exactly the same rows from a table?

2001-08-14 Thread Jon Cheng
Hi, I am curious if there is a way to delete exactly the same rows from a table with one query? Or must I do select and delete one query at a time? I accidentally parse an html file twice, and I want to keep the rows that are distinct. Thanks for your help, -Jon

adding types

2001-08-14 Thread Sylvain BARTHELEMY
Hi, How can I add a new type to MySQL ? Thanks. --- Sylvain BARTHELEMY http://www.tac-financial.com | http://barth.netliberte.org - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Problems with MYSQL-D-MAx for win 98 DROP TABLE

2001-08-14 Thread Sinisa Milivojevic
Luciano Pulvirenti writes: If you create a Berkeley-DB table (es. CREATE TABLE TEST TYPE BDB) is not possible delete it after. The command DELETE TABLE TEST responds Table unknown. Thank You Luciano Your CREATE statement is a bit dubious, so check that there is such a table at all. --

SAK kills daemons. It shouldn't.

2001-08-14 Thread VDA
Hello mysql mailing list readers, Secure Attention Key is supposed to kill all processes on current console. Usually init respawns new getty. This way I can be sure that login prompt I see is not mimicked by password collecting program. I like this idea a lot. I noticed that when I press

SAK kills daemons. It shouldn't. #2

2001-08-14 Thread VDA
Hello mysql mailing list readers, Daemons surviving SAK: klogd gpm dhcpcd inetd: Me too! And I don't let you SIGKILL my children! automount: I'm at least as tough as inetd!! Also I see '?' in TTY column in 'ps -AH e' output for all these daemons (both dying and surviving), so ps does not

MYSQL bug with if and datetime fields

2001-08-14 Thread Arturs Aboltins
From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: MYSQL bug with if and datetime fields Description: In queries where datetime field is in "WHERE" condition, the same field in "IF" statement causes incorrect query result. How-To-Repeat:

Re: MYSQL bug with if and datetime fields

2001-08-14 Thread Sinisa Milivojevic
Arturs Aboltins writes: From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: MYSQL bug with if and datetime fields Description: In queries where datetime field is in WHERE condition, the same field in IF statement causes incorrect query result. How-To-Repeat:

Incorrect index selection when potential index is compound

2001-08-14 Thread Michael Widenius
Hi! Eric == Eric DeCosta [EMAIL PROTECTED] writes: Description: Eric Index analysis and optimization is choosing wrong index when a Eric table involved in a JOIN is compound. MySQL should still be using Eric the first part of the GECK_STATE PRIMARY key (geck_id) since it is the column

Re: mysqld forgets location of datadir

2001-08-14 Thread Michael Widenius
Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Rene Churchill writes: I'm having a problem with mysql forgetting the location of it's datadir. After the server has been running for some time, it looses track and starts throwing errors when I attempt to select a

Performance with large numbers of connections

2001-08-14 Thread Chris Allen
I am running a mysql server on a stand-alone host that is queried by a web server. I am currently seeing an average of 33 queries per second, although this is often a lot higher. The problem is, when large numbers of connections start to arrive, the machine load gets very high - but MySQL

[planejamentonet] Promoções Planejamento Net

2001-08-14 Thread Alfredo Luiz dos Santos Junior

Re: MySQL daemon and inetd

2001-08-14 Thread Michael T. Babcock
I nave no problem in running mysqld. But my Linux machine have only 32 Mb of RAM. I just like to make mysqld load *on demand*. Just for reference, most modern *nix variants will handle this situation properly. If MySQL isn't doing anything, its memory space will get swapped out to disk and

Re: Copy of databse on my PC....

2001-08-14 Thread Sinisa Milivojevic
Michael T. Babcock writes: Thank you for your technical question to the MySQL team. Unfortunately, our developers are not able to answer this type of inquiry if you have not purchased a technical support contract. I'd like to know if this is now official MySQL policy (filling the list

problem with mysqld

2001-08-14 Thread Henry
Hello, I am new to mysql. I install windows version MySQL. I want to initial mysql with command mysqld, I get an error message as can't initialize innoDB as 'innodb_data_file_path' is not set. Could you please help me how to solve this problem? Thanks Henry

Re: SELECT MIN(field) takes minutes on a large table!

2001-08-14 Thread Dan Makovec
Hi Heitzso, Thanks for your suggestion, and in the absence of feedback from anybody else I suspect you're probably right. The system this thing is running on is a vastly outdated P150 with 128MB. I was hoping that I could do a little trick with the tables to optimize the queries a little more

Re: Permissions Problems

2001-08-14 Thread Gerald Clark
You are connecting TO host www.4cdg.com, but the permission table entry list the hosts you connect FROM. You need to grant privileges to the user and machine you connect FROM. Butch Evans wrote: Can anyone explain why this is happening? root@www:/# mysql -u dgadmin -h www.4cdg.com -p

Re: Lost bin-log(s) following logrotate affecting recovery, replication

2001-08-14 Thread Gerald Clark
This really is not a MySQL issue, but a Red Hat issue. Don't logrotate the MySQL bin logs. Joel Fowler wrote: Environment: Red Hat 7.1 mysqld 3.23.36-log /etc/my.cnf as follows: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock

Re: locking tables.

2001-08-14 Thread Gerald Clark
To avoid the Fatal Embrace where two users each lock a table, and then attempt to read the table the other locked, you must lock all table you intend to use for the duration of the lock. The manual clearly states that a subsequent lock or unlock command will first unlock all the tables you

Re: INSERT problem

2001-08-14 Thread Gerald Clark
MySQL does not support multi table updates yet either. Yosi Oren wrote: Hi, You are trying to use nested select for that update wich MySQL do not support insted use : update table set field = value from table inner join table where bla = bla . Sincerely,

SORRY: I was wrong

2001-08-14 Thread Tonu Samuel
Now again I want to tell sorry to everyone who was shoked by my letter which told that we do not give answers without money. The truth is that MySQL developers have about 20 different mailing lists to read in priority order. We have mailing list for people who pay for support and their mails get

configure - missing termcap and curses libraries - solution

2001-08-14 Thread John Prentice
I noticed from the archives that some people had problems configuring the MySQL source. They were getting the same error message as I was getting, about termcap and curses libraries being missing, but nobody seemed to work out exactly what was wrong or what needed installing. On Linux Mandrake

IF clause

2001-08-14 Thread Mariusz Muszalski
How to translate this to mySQL: -- IF NOT EXISTS ( Select Number From Results Where GameID=1 ) begin INSERT INTO Results ( GameID, Date, Number ) VALUES

Replication housekeeping

2001-08-14 Thread Robert Cross
I've got a fairly simple MySQL system here using replication, one master and one slave. Looking at the system the other day and the database logs are sure building up. Is there any standard way (best practice) - preferably automated - to keep these under control? If not, I've have a go at

BIT data type?

2001-08-14 Thread Philip Mak
I have an application that requires the storage of various flags (by flag, I mean a variable that is either 1 or 0). What's a good way of doing this? I've thought about two ways: Method 1: Make a TINYINT column for each flag I can use TINYINT NOT NULL datatype for storing each flag. The

compile problem

2001-08-14 Thread Kenneth
Hello mysql, I'm trying to install mysql from source in a redhat 7.1 machine but got the following errors(under section 'compile status'). I tried the same in my redhat 7.0 without any problem. Please give me some ideas on the following matters: 1. Should I update the gcc compiler using the

mysql+mm.mysql

2001-08-14 Thread Sibel Toprakkiran
Hi, I'm trying to connect to a mysql database from linux using the driver mm.mysql-2.0.2-bin.jar. The connect is successfull, but when I want to retrieve some records from the database, I get the message error reading communication packets. Do someone has an idea, what it can be? Thanks and

Re: problem with mysqld

2001-08-14 Thread Heikki Tuuri
Henry, if you do not want to use transactional InnoDB tables, add skip-innodb to your my.cnf or my.ini file. If you want to use InnoDB tables, follow the instructions: To use InnoDB tables you must specify configuration parameters in the MySQL configuration file in the [mysqld] section of

Re: Mysql causing severe load problems on Dual-Athlon server?

2001-08-14 Thread Ryan Shrout
Update -- The problem I described happened again, and this time I was able to get the mysqladmin processlist done. Here are the results from that. Can you help me find my problem based on this information? Thank you!! Here is the top header: 11:09am up 4 days, 20:15, 1 user, load average:

Best Practice for mysqlhotcopy?

2001-08-14 Thread Philip Mak
I have a user on my system with a normal shell account, and a normal MySQL account that owns a database. How can this unpriviledged user back up his database using mysqlhotcopy? I've run into two problems: 1. He has to login as the MySQL root user in order to be able to execute FLUSH TABLES.

WinMySQLAdmin 1.0

2001-08-14 Thread Dan Haynes
Having trouble with e-mail servers this morning and not sure if my subscription request made it. If this has been reported already or is the incorrect mailing list for this issue, please excuse and point me in the right direction. Had a internet connection failure last night and due to what

Re: Mysql causing severe load problems on Dual-Athlon server?

2001-08-14 Thread Johan Wahlström
- Original Message - From: Ryan Shrout [EMAIL PROTECTED] To: Tonu Samuel [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, August 14, 2001 5:21 PM Subject: Re: Mysql causing severe load problems on Dual-Athlon server? Update -- The problem I described happened again, and this

Re: Mysql causing severe load problems on Dual-Athlon server?

2001-08-14 Thread Johan Wahlström
This is happening to me also! I have a Dual P-III, 550, 896MB RAM. Suddenly mysql says it has insert max_connections here connections busy most of them LOCKED, and then suddenly they start working on all of them at the same time. This creates a load average similar to max_connections. Is this a

Re: Mysql causing severe load problems on Dual-Athlon server?

2001-08-14 Thread Ryan Shrout
This just happened a second time today... that is the most frequent yet. Please, you have got to help me on this! Ryan Shrout Owner - Amdmb.com http://www.amdmb.com/ [EMAIL PROTECTED] - Original Message - From: Ryan Shrout [EMAIL PROTECTED] To: Tonu Samuel [EMAIL PROTECTED] Cc: [EMAIL

mysql 3.23.41 errors during compile

2001-08-14 Thread Faine, Mark
Anybody seen this before: gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_CURSES_H -I/export/home6/temp/mysql-3.23.41/include -DHAVE_RWLOCK_T -o mysqlbinlog mysqlbinlog.o mini_client.o net_serv.o mini_client_errors.o

Re: MYSQL bug with if and datetime fields

2001-08-14 Thread Michael Widenius
Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Arturs Aboltins writes: From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: MYSQL bug with if and datetime fields Description: In queries where datetime field is in WHERE condition, the same field in IF statement

SELECT .. OR from multiple tables

2001-08-14 Thread Eric Anderson
I've got two tables, Current and Temporary, Current has a row with login='keric', Temporary doesn't. The following query: mysql select * from Current, Temporary where Current.login='username' or Temporary.login='username' - \g Empty set (0.01 sec) obviously doesn't work. I want to know

Float Issue

2001-08-14 Thread Dave Jolly
Hi, There seems to be a round-off problem with FLOAT. Here's a scenario to replicate it... -- $ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1149 to server version: 3.23.41 Type 'help;' or '\h' for help. Type '\c' to clear the

I blew it big time... locked myself out of mysql

2001-08-14 Thread chip . wiegand
I used mysqladmin to create a database and set the grant properties to root@localhost with the password, but now am unable to use mysql at all. How can I rectify this problem? When I try to access mysql I get 'Access denied for user root@localhost'. I have tried, from the command line, with

Re: Mysql causing severe load problems on Dual-Athlon server?

2001-08-14 Thread Ryan Shrout
Sorry, but this system has quad 15K RPM SCSI hard drives running RAID 0+1. I don't think hdparm applies to that. Ryan Shrout Owner - Amdmb.com http://www.amdmb.com/ [EMAIL PROTECTED] - Original Message - From: Werner Stuerenburg [EMAIL PROTECTED] To: Ryan Shrout [EMAIL PROTECTED] Sent:

RE: SELECT .. OR from multiple tables

2001-08-14 Thread Bruce Stewart
How about a UNION query...? -Original Message- From: Eric Anderson [mailto:[EMAIL PROTECTED]] Sent: Tue, 14 August 2001 18:56 To: [EMAIL PROTECTED] Subject: SELECT .. OR from multiple tables I've got two tables, Current and Temporary, Current has a row with login='keric', Temporary

Re: Mysql causing severe load problems on Dual-Athlon server?

2001-08-14 Thread Ryan Shrout
Actually, I ran this test: [root@dagger /root]# hdparm -Tt /dev/sda /dev/sda: Timing buffer-cache reads: 128 MB in 0.93 seconds =137.63 MB/sec Timing buffered disk reads: 64 MB in 13.92 seconds = 4.60 MB/sec And that does seem pretty bad, doesn't it? Is there optimization for SDA like

Re: SELECT .. OR from multiple tables

2001-08-14 Thread Philip Mak
Your query will work in every case, EXCEPT when either Current or Temporary has 0 rows, because then there's nothing to join. I'm not sure if doing a join is a clean way of doing this though. If you know that Current will never be empty (but temporary might be), then this query would work:

Re: Float Issue

2001-08-14 Thread joseph . bueno
Dave Jolly wrote: Hi, There seems to be a round-off problem with FLOAT. Here's a scenario to replicate it... -- $ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1149 to server version: 3.23.41 Type 'help;' or '\h' for

Re: SELECT .. OR from multiple tables

2001-08-14 Thread Eric Anderson
Your query will work in every case, EXCEPT when either Current or Temporary has 0 rows, because then there's nothing to join. I'm not sure if doing a join is a clean way of doing this though. If you know that Current will never be empty (but temporary might be), then this query would work:

Re: I blew it big time... locked myself out of mysql

2001-08-14 Thread Jeremy Zawodny
On Tue, Aug 14, 2001 at 10:14:58AM -0700, [EMAIL PROTECTED] wrote: I used mysqladmin to create a database and set the grant properties to root@localhost with the password, but now am unable to use mysql at all. How can I rectify this problem? When I try to access mysql I get 'Access denied

MySQL 3.23.41 has invalid asm constrainst

2001-08-14 Thread Trond Eivind Glomsrod
Description: mysql 3.23.41 doesn't build properly on IA32 with assembly and innobase enabled. 3.23.40 didn't have this problem Configure statement in spec file (%configure is a standard rpm macro, specifying CFLAGS and CXXFLAGS and various prefixes) %configure --without-debug \

Re: Lost bin-log(s) following logrotate affecting recovery, replication

2001-08-14 Thread Gerald Clark
I don't recall ever losing a log. Are you sure logrotate isn't renaming it? Joel Fowler wrote: I agree that Red Hat has an issue with safe_mysqld and logrotate. However, in my opinion MySQL has a much more serious problem. In a logging system there shouldn't be any subtle ways to drop

Re: Local Sockets vs TCP

2001-08-14 Thread Gerald Clark
These scripts should not be creating their own sockets. The should be connecting to the one socket that the mysql server creates. Hans Zaunere wrote: We have had a MySQL/Apache/Perl combo running fairly smoothly. However the other day MySQL seemingly went crazy, and brought the rest of the

Re: Local Sockets vs TCP

2001-08-14 Thread Hans Zaunere
Ok. I didn't write these scripts, as they were in place when I arrived at this position, however from looking through them, it appears the actual connection to MySQL happens with something like: my $dbh = connect(DBI:mysql:database:localhost, user, password); The above is a perl line. So

encrypt/decrypt question

2001-08-14 Thread Michael Tam
Hi all, I am very new to the encrypt and decrypt data process and would like to know how do I able to encrypt a string and store to MySQL and retrieve the data and decrypt it at the later time. I understood it sorts of contradict the point of security but I just want to use it to

Re: Lost bin-log(s) following logrotate affecting recovery, replication

2001-08-14 Thread Joel Fowler
I've also reported this problem to Red Hat' Bugzilla as I understand they're responsible for the /etc/logrotate.d/mysql script. It's Bugzilla [Bug 51711] Changed - MySQL looses bin-logs during logrotate. Joel Fowler === At 01:16 PM 8/14/01 -0500,

REAL MONEY

2001-08-14 Thread Dan Mitchell
REAL MONEY Subject: Fw: .AS SEEN ON NATIONAL TV Subject:REAL MONEY Dear Friend Future Millionaire: AS SEEN ON NATIONAL TV: Make over a half million dollars every 4 to 5 months from your home for an investment of only $25 U.S. Dollars one time expense.

Re: encrypt/decrypt question

2001-08-14 Thread mickalo
Michael, I just did something like this, and used the ENCODE/DECODE. Works well. Basically you want to assign a special key for the encoding/decoding of the data you want to encode/decode. The column type should be either a BLOB or TINYBOLD, as it's stored in a binary format, depend on the size

Re: I blew it big time... locked myself out of mysql

2001-08-14 Thread chip . wiegand
Thanks for all the replies, I have followed the instructions in the manual and am still getting an error, here is the message: --- simrad_4# safe_mysqld --skip-grant-tables [1] 57953 simrad_4# Starting mysqld daemon with databases from /var/db/mysql

Re: encrypt/decrypt question

2001-08-14 Thread Rene Churchill
If all you're looking for is a trivial hiding of the data, then I'd suggest doing a rot13 on the string. I highly doubt there is a native SQL function that does this, so you'll need to write your own function in whatever interface you're using. Perl/PHP/whatever. Rot13 is a simple rotation of

Re: Lost bin-log(s) following logrotate affecting recovery, replication

2001-08-14 Thread Trond Eivind Glomsrød
Joel Fowler [EMAIL PROTECTED] writes: I've also reported this problem to Red Hat' Bugzilla as I understand they're responsible for the /etc/logrotate.d/mysql script. It's Bugzilla [Bug 51711] Changed - MySQL looses bin-logs during logrotate. 3.23.41-1 uses a new method for flushing logs

Re: program using mysql_real_open gets error when rexec'd on 3.23.39

2001-08-14 Thread Steve Rickard
I have resolved this problem. The program doing the mysql_real_open had been compiled with the thread library by a cc -Kthread ... compile. When the -Kthread option was removed the problem went away. - Original Message - From: Steve Rickard [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED]

Re: Local Sockets vs TCP

2001-08-14 Thread Gerald Clark
Connect() does that for you. The mysql library handles the communication to the server. You just use the supplied functions. Are you sure it was sockets you were running out of? Hans Zaunere wrote: Ok. I didn't write these scripts, as they were in place when I arrived at this position,

!!!

2001-08-14 Thread

Re: I blew it big time... locked myself out of mysql

2001-08-14 Thread mickalo
On Tue, 14 Aug 2001 12:16:59 -0700, [EMAIL PROTECTED] wrote: Thanks for all the replies, I have followed the instructions in the manual and am still getting an error, here is the message: --- simrad_4# safe_mysqld --skip-grant-tables [1] 57953 simrad_4#

Re: Urgent:MySql problem

2001-08-14 Thread Shu Xiao
What is your /etc/my.cnf? Do you see mysql daemon running? (use ps -ef) Maybe it is under /tmp/mysql.sock. You need to change the configuration and restart server. Shu At 01:28 PM 6/1/2006 +0530, sachin wrote: Hello, I am working on RH Linux 7.0 MySql is not working at all. My MySql files

Re: problem rpm installation of MySQL

2001-08-14 Thread Shu Xiao
At 12:33 AM 8/14/2001 -0400, Trond Eivind Glomsrød wrote: Shu Xiao [EMAIL PROTECTED] writes: Hi, I have problem starting MySQL on Redhat7.1. After installed Redhat7.1 which include MySQL rpm installation, I saw the file named mysqld under /etc/init.d . I set up symlink to it under

Re: problem rpm installation of MySQL

2001-08-14 Thread Trond Eivind Glomsrød
Shu Xiao [EMAIL PROTECTED] writes: BTW, if I want to upgrade to new rpm version, what should I do. The RPM program will take care of upgrading itself? If you get the new version of mysql in rpm format (eg. from Rawhide), 'rpm -Uvh mysql*rpm' should take care of it. -- Trond Eivind Glomsrød

nested if statements allowed?

2001-08-14 Thread Eric Schultz
I am trying to do a nested if, but it appears to break my query... Here is a sample of what I am trying to, basically validating email addresses out of a db: select IF( (LENGTH( emailaddr ) = 1 || NOT LOCATE( \@,emailaddr ) || LOCATE( ,emailaddr ), (IF address.ts = 2001081300,

Re: Local Sockets vs TCP

2001-08-14 Thread Hans Zaunere
Connect() does that for you. The mysql library handles the communication to the server. You just use the supplied functions. Are you sure it was sockets you were running out of? Well the supplied functions have been used. How could I confirm that the system was in fact running out of

mysql only stores one word?

2001-08-14 Thread Nate Sanden
Hey im pretty new to mysql, but I made a basic html form and used php to post it to my mysql database. It goes in fine, but it only carries the first word in each input box. So say for description I put in My little white dog it only stores My in the database. Would appreciate any insight you

Re: I blew it big time... locked myself out of mysql

2001-08-14 Thread chip . wiegand
[EMAIL PROTECTED]@bellsouth.net on 08/14/2001 10:03:13 PM Internet mail from: Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: I blew it big time... locked myself out of mysql On Tue, 14 Aug 2001 12:16:59 -0700, [EMAIL

Problems compiling mysql on linux 7.0

2001-08-14 Thread Vien Huynhle
Title: Blank I am getting this error when trying to install mysql # ./configure --with-low-memory --prefix=/usr/local/mysql loading cache ./config.cachechecking host system type... i586-pc-linux-gnuchecking target system type... i586-pc-linux-gnuchecking build system type...

RE: SELECT .. OR from multiple tables

2001-08-14 Thread Dave Rolsky
On Tue, 14 Aug 2001, Bruce Stewart wrote: How about a UNION query...? Too bad MySQL doesn't support them yet ;) -dave /*== www.urth.org We await the New Sun ==*/ - Before posting, please

Re: encrypt/decrypt question

2001-08-14 Thread Michael T. Babcock
I am very new to the encrypt and decrypt data process and would like to know how do I able to encrypt a string and store to MySQL and retrieve the data and decrypt it at the later time. Grab a copy of mcrypt (search http://freshmeat.net/ for it) and read the docs for it -- its a good idea to

Problems compiling mysql on linux 7.0

2001-08-14 Thread Vien Huynhle
Title: Blank I am getting this error when trying to install mysql # ./configure --with-low-memory --prefix=/usr/local/mysql loading cache ./config.cachechecking host system type... i586-pc-linux-gnuchecking target system type... i586-pc-linux-gnuchecking build system type...

Replication

2001-08-14 Thread Neil Tompkins
Hello, My ISP provides me with a MySQL database. I have installed MyODBC and MySQL on my Windows2000 machine. Can you tell me if its possible to replicate the database to my own computer, make changes and these be replicated back to the database hosted by my ISP ? Thanks for any help Neil

Re: mysql only stores one word?

2001-08-14 Thread Tyler Longren
post some code. Make sure you're using quotes in the right places. Tyler Longren Captain Jack Communications [EMAIL PROTECTED] www.captainjack.com On Tue, 14 Aug 2001 13:39:48 -0700 Nate Sanden [EMAIL PROTECTED] wrote: Hey im pretty new to mysql, but I made a basic html form and used php

Re: mysql only stores one word?

2001-08-14 Thread mickalo
On Tue, 14 Aug 2001 13:39:48 -0700, Nate Sanden [EMAIL PROTECTED] wrote: Hey im pretty new to mysql, but I made a basic html form and used php to post it to my mysql database. It goes in fine, but it only carries the first word in each input box. So say for description I put in My little white

Design/Permissions Question

2001-08-14 Thread o o
I'm relatively new to MySQL and am drawing up some ideas for writing a support/trouble tracking database for my company. I envisioned a single database with seperate tables for various data I would be storing (IP/Connection info table, Machine Inventory Table, etc). Each table would have data for

Re: Problems compiling mysql on linux 7.0

2001-08-14 Thread Tyler Longren
Which Linux 7.0 are you using? I'll assume you're talking about Redhat. So why don't you just download the mysql rpm and install it instead of doing it from source? Good luck, Tyler Longren Captain Jack Communications [EMAIL PROTECTED] www.captainjack.com

Re: Local Sockets vs TCP

2001-08-14 Thread Christian Jaeger
At 16:41 Uhr -0400 14.8.2001, Hans Zaunere wrote: sort of thing. Would it be better to just switch to TCP/IP sockets? my $dbh = connect(DBI:mysql:database:localhost, user, password); Well it seems like you ARE using INET TCP/IP sockets, since there is 'localhost' there (which goes over

Re: I blew it big time... locked myself out of mysql

2001-08-14 Thread chip . wiegand
Werner Stuerenburg [EMAIL PROTECTED] on 08/14/2001 11:55:37 PM Internet mail from: Please respond to Werner Stuerenburg [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: Re: I blew it big time... locked myself out of mysql I think it is grant all on *.* to 'root'@'localhost'

RE: Lots of spawning Mysql processes and one that won't die?

2001-08-14 Thread Dan Haynes
Dunno if this will help or not, I'll just throw it out for consideration. I'm just learning PHP, Javascript etc. and tend to make a lot of mistakes in my scripts at this point. When I write a script that executes a binary on the Apache server (NT 4.0 SP6a) and it goes off into na-na land, I

Re: Permissions Problems

2001-08-14 Thread Butch Evans
On Tue, 14 Aug 2001, Gerald Clark wrote: You are connecting TO host www.4cdg.com, but the permission table entry list the hosts you connect FROM. Actually, it is just one host...I am running on FreeBSD and I have to specify the hostname on the command line. You need to grant privileges to

Re: Float Issue

2001-08-14 Thread tj marlin
.1 can not be represented exactly on a binary machine. there must be an approximation stored in the fractional bits of the floating point representation. there are more fractional bits in a double than in a float. so the approximation is better. see the user manual for exact sizes. At 12:51

Re: I blew it big time... locked myself out of mysql

2001-08-14 Thread Butch Evans
On Tue, 14 Aug 2001 [EMAIL PROTECTED] wrote: I used mysqladmin to create a database and set the grant properties to root@localhost with the password, but now am unable to use mysql at all. How can I rectify this problem? When I try to access mysql I get 'Access denied for user root@localhost'. I

Re: Replication

2001-08-14 Thread Jeremy Zawodny
On Tue, Aug 14, 2001 at 10:11:30PM +0100, Neil Tompkins wrote: Hello, My ISP provides me with a MySQL database. I have installed MyODBC and MySQL on my Windows2000 machine. Can you tell me if its possible to replicate the database to my own computer, make changes and these be replicated

development tools

2001-08-14 Thread Christian Hermanus
SORRY FOR ANY CROSS POSTING Dear All, I have a plan to build a database application using mysql as it database engine What is the best development tools if I using a Microsoft NT environment. I'll be happy if you share your experience Regards Christian

Re: development tools

2001-08-14 Thread Dennis Salguero
Naturally, the answer is: it depends. What is your application supposed to do? What languages are you versed in? Does your data need to be accessible via the web? At the very least, you will be needing the ODBC driver for MySQL, MyODBC. It's available from the MySQL web site. Other than that,

  1   2   >