How can I connect and run PHP program through crond service.

2002-02-13 Thread sreedhar
Hi all, I am doing a small testing project on Library. I wrote a PHP program to list out the people and their mailid's who took book and had not returned from MySQL database. Using the mail command i could able to send remainder's to them. But now i would like to make this as auto mail. so my P

....from ms access to mysql

2002-02-13 Thread Fabio Amura
Hi, i have to migrate from ms access to my sql, and i dont know how can i do... do your know at easy metod for this migration, and can you give me indication or link i'm not an espert... thanks fabio -Messaggio originale- Da: Jochen Kaechelin [mailto:[EMAIL PROTECTED]] Inviato: giove

RE: Empty mysql.user entries???

2002-02-13 Thread Takacs Istvan
Reznichenko, Wed, 13 Feb 2002 15:02:01 PM, you wrote: > TI> After the default mysql-3.23-47 installation, > TI> there are two entries in the mysql.user table > TI> where the User and Password fields are empty. > TI> I'd like to know what is the purpose of these > TI> records? > TI> The first has

Updating SuSE 7.3

2002-02-13 Thread Jochen Kaechelin
Can I use the RedHat-rpms on mysql.com to update a SuSE 7.3 prof or do I need to compile it from source with some parameters? I run 3.23.44 max and I want to update to 3.23.48 max -- Jochen - Before posting, please check:

Upgrading from 3.23.36 to 3.23.39 or Greater

2002-02-13 Thread Kevin Cashman
Is their any special instructionsfor upgrading within versions. A software vendor says I need to be at 3.23.39 or greater for their product to function. I am at 3.23.36. When I try to upgrade with rpm -Uvh her is my results: [root@chilly admin]# rpm -Uvh MySQL-3.23.48-1.i386.rpm error: failed

Mysql Row Lock Problem

2002-02-13 Thread Amit Dilip Lonkar
Hi I have set lock on a row in Mysql by the command "SELECT " + selCols + " FROM ATTRIBUTE LOCK IN SHARE MODE"; Now when the user who has set the lock updates the record the the lock is still not released. Hence no other user is able to update. How do i release this lock ? Also If i hav

RE: W2K Network

2002-02-13 Thread Martin Jeremic
You need to set access privileges for SQL server. try with this : GRANT ALL PRIVILEGES ON database.tables TO [EMAIL PROTECTED] \g flush privileges \g mySQL prompt. Try also to delete password from DNS on client machine. (I'm maybe make a syntax error, look in mySQL manual for details). -

MySQL Update based on SELECT CRITERIA

2002-02-13 Thread USER
Is there any way to do an Update...Select like an InsertSelect? For instance can I fill one table with data from another table. The columns do not match exactly so a table copy won't do much good. But the data retrieved in the select command is compatible with the new table fields. sql,que

HELP..!!!

2002-02-13 Thread Herry Rajasa
mee too.. I have tried either send the email or go to their unsubscribe page.. with no result.. can we just have the option to go to the database/sites and click the messages we like to see? anyone or admin can help us.. PS: I'm getting tired now to erase my full mailbox everyday from this mailin

RE: Query Speed

2002-02-13 Thread RBRoa
Yeah, My tables structure +---+---+--+-+-+ + | id| int(11) | | PRI | NULL| auto_increment | | edate | date | YES | MUL | NULL| | | etime | int(5) unsigned zerofill | YES |

RE: MySQL installed but no MySQLAdmin???

2002-02-13 Thread Neil Silvester
You also need to download and install the MySQL client programs rpm from the mysql.com website too. This will install mysql and mysqladmin client progs. Neil -Original Message- From: Vernon A Webb [mailto:[EMAIL PROTECTED]] Sent: Thursday, 14 February 2002 1:01 PM To: MySQL Subject: MySQ

MySQL installed but no MySQLAdmin???

2002-02-13 Thread Vernon A Webb
Why, if I have MySQL is the MySQLAdmin not on the box? Is there something else I must install? I've downloaded the rpm from the web site and installed. When it boots, MySQL does come up and it says that it has started without errors. What am I missing?

mysqldump does not seem to work as in documentation

2002-02-13 Thread jack . alban
>Description: on red hat linux 7.2 on an intel box mysqldump --opt -u geo -pmy_pass --where="some condition" AIRDB UniversalCdrEast | mysql --compress -h some_ip -u geo -pmy_pass AIRDB yielded an error 1035: empty query >How-To-Repeat: >Fix: had to spel

Re: Distributed Fulltext?

2002-02-13 Thread Steven Roussey
Mike Wexler wrote: That may be what you want. But I want a search engine. For my database. I want to be able to do search of the million records of inventory in our database and find the items with certain keywords, that are currently available for sale, in the venue the user is shopping

please update the RPM packages

2002-02-13 Thread Florin Andrei
(please ignore my previous message, it was sent by mistake) A while ago i asked you to modify the MySQL RPM package so that it will also provide "mysql", not only "MySQL", so that some RPM dependencies on some distributions will be happy. You did changed the "provides" option, it works fine, than

please update the RPM packages

2002-02-13 Thread Florin Andrei
Guys, A while ago i asked you to modify the MySQL RPM package so that it will also provide "mysql -- Florin Andrei "U is for Universe, everything there is. Possibly a large computer simulation." - Alphabetica Cyberia - Befor

Re: Does delete from .. where (condition) use an index?

2002-02-13 Thread Heikki Tuuri
Eric, print what EXPLAIN SELECT * FROM Syslog USE INDEX(ds_index) WHERE ... says. Please also show what the InnoDB monitor prints. Regards, Heikki -Original Message- From: Eric Mayers <[EMAIL PROTECTED]> To: Heikki Tuuri <[EMAIL PROTECTED]>; [EMAIL PROTECTED] <[EMAIL PROTECTED]> Da

RE: Does delete from .. where (condition) use an index?

2002-02-13 Thread Eric Mayers
Heikki, mysql> EXPLAIN SELECT * FROM Syslog WHERE datestamp <= 2002021310712; ++--+---+--+-+--+-+- ---+ | table | type | possible_keys | key | key_len | ref | rows| Extra | ++--+---+--+-+--

Re: Web hosting for InnoDB

2002-02-13 Thread Jeremy Zawodny
On Wed, Feb 13, 2002 at 08:19:50AM -0500, Kevin McBrearty wrote: > > We are working on a Java web application and are thinking about > using InnoDB. Does anybody know any hosting companies in the > US/Canada that support InnoDB table types in MySQL. Most that I have > checked with don't. I'm work

Query Speed

2002-02-13 Thread RBRoa
Hi, I got stuck on queryabout a million rows in one table...it slows up my server... How can I improve my server on managing a request like this? I manually loop the monthly data query...I got a database that is full of data daily...so all I need to get the maximum of every month is to quer

RE: select count distinct

2002-02-13 Thread Land, Christopher
The following may assist: (three-fifths down) http://www.mysql.com/doc/G/r/Group_by_functions.html Note that if you are using MySQL Version 3.22 (or earlier) or if you are trying to follow ANSI SQL, you can't use expressions in GROUP BY or ORDER BY clauses. You can work around this limitation by

Re: Does delete from .. where (condition) use an index?

2002-02-13 Thread Heikki Tuuri
Eric, MySQL is very pessimistic about key accesses: it assumes many of them cause a random disk read. Please print EXPLAIN SELECT * FROM Syslog WHERE datestamp < ... to see how it accesses the table. I have tuned the optimization in 3.23.48 so that it would favor index searches more often. Pl

RE: Problems with a join...

2002-02-13 Thread Keith A. Calaman
Try SELECT pd.ANSWER_TEXT, pr.*, COUNT(*) as NUM FROM pollresponse left join polldata on pd.QUESTION_ID = pr.QUESTION_ID WHERE pd.VOTE_ID = pr.RESPONSE GROUP BY pr.RESPONSE Something like that will work better...probably you have to massage it a little. Note that you were not getting any

PLEASE HELP WITH STATEMENT.

2002-02-13 Thread Lance Prais
I am using the following statement in Oracle 8.0.6 and getting an error I and I do not understand why it is giving it to me. CODE: CREATE OR REPLACE procedure primus_temp_dump_test(in_tab_name in varchar2) as cursor_id integer; execute_return_value integer; last_function_code integer; Begin cu

RE: Help doesn't work in mysqlgui

2002-02-13 Thread Peter Pierre
mysql Is there a manual for it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, 14 February 2002 10:46 AM To: Peter Pierre Subject: Re: Help doesn't work in mysqlgui Your message cannot be posted because it appears to be either spam or simply off

select count distinct

2002-02-13 Thread Brian Warn
I'm stuck right now with using v. 3.22.32. Yes, I know I need to upgrade, but I can't for various reasons. Anyway, I need to do a select count(distinct column) from table query, but can't since this version doesn't support it. How can I do this? Thanks, Brian

Does delete from .. where (condition) use an index?

2002-02-13 Thread Eric Mayers
I haven't been able to find details about how/if MySQL (InnoDB) optimizes deletes. Does it use indexes? Can I force it to use an index? My table is defined as: CREATE TABLE Syslog( id int(11) not null, datestamp timestamp(14), message char(255), KEY ds_index(datestamp), KEY id_index(

Re: Distributed Fulltext?

2002-02-13 Thread hooker
> While any speed up with a full table fulltext search would be helpful > and useful, there are instances where the search is intersected with > another column and the problem of search is therefore more complex but > also leads to potential optimizations. > > In our case we rarely do searches th

Logging visits using a database

2002-02-13 Thread Peter Lovatt
Hi Excuse the cross post I am thinking about building a logging tool to do visit analysis using SQL, rather than doing log file analysis. The aim is to analyse requests for dynamic pages called via php as well as static pages. Static pages will use an include for logging. Php calls may have two

Re: Distributed Fulltext?

2002-02-13 Thread hooker
> Steve Rapaport wrote: > > Someone correctly pointed out today that it's not Mysql's job > > to be Google, and I agree. But it seems to me that it would be > > fair for mysql to be able to handle searches in under 1 second > > for databases 1 millionth the size of Google. All I want here > > is

Re: Charset Question - Spanish?

2002-02-13 Thread Reid Wilson
Hi, I would love to be forwarded any messages that people send you about this issue, as I'm in a very similar situation to you. On Mac OSX, we have a database into which we "feed" texts files of sql with the Spanish characters intact, but then in the database the accent marks and such don't sho

Problem compiling mysql on HPUX

2002-02-13 Thread Hector Jose Montalvo Herrera
Hello, I have problems to compiling Mysql-3.23.47 on HPUX 11.0, When I run the "make" , the get the next error: Making all in readline gcc -DUNDEF_THREADS_HACK -DHAVE_CONFIG_H -I./../include -I./.. -I.. -D__STD C_EXT__ -O3 -DDBUG_OFF -DHAVE_BROKEN_PREAD -DDONT_USE_FINITE -DHAVE_BROKE N_GE

MySQL on Linux, Athlon MP stability?

2002-02-13 Thread Femme Taken - Tweakers.net
We have been using a dual Athlon MP 1600+ (1,4GHz) MySQL box since december. Stability is rock solid and the performance is consirably higher than our previous dual PIII-1000 server (>40% clock speed difference). Configuration: Tyan Thunder K7 motherboard, 2GB RAM, Adaptec 3200S SCSI-RAID, 3

INSERT base on SELECT criteria

2002-02-13 Thread Scott Andreas
Hello list, I have a table that I want to insert records based on a criteria select. The database colums are... | | || code + contactno + note + source + date _|___|__||__ my SQL statement is INSE

new to mysql

2002-02-13 Thread [EMAIL PROTECTED]
Hi mailing group, i'm sorry to disturb you, i'm new to mysql, i like to use it under winnt5. I like to pose some questions first to use it: 1) does someone know how to do a silent install of mysql service ? You have any script already ? 2) can mysql win32 is suitable for "mission critical" pur

Re: Distributed Fulltext?

2002-02-13 Thread Mike Wexler
Brian DeFeyter wrote: > On Wed, 2002-02-13 at 16:39, Mike Wexler wrote: > >> >>Brian DeFeyter wrote: >> >>>I sorta like that idea. I don't know exactly what you can and can't do >>>as far as indexing inside of HEAP tables.. but the index size would >>>likely differ from the written index. Then

Re: W2K Network

2002-02-13 Thread Cary
I'm running on almost the same setup as you, only using VFP as my frontend app. Try setting up a User DSN on the client machines instead of a system DSN. This might not be causing the problem, but setting it up this way works great for me. Cary At 02:31 PM 2/13/02, Otto Saayman wrote: >Hi there

InnoDB, MySQL 3.23 inserts and deletes

2002-02-13 Thread Eric Mayers
I'm using MySQL-Max-3.23 and have an InnoDB table that's getting hit with lots of inserts .. I'm pushing them as fast as I can to strain the box and getting 200-300/sec. The table consists of a timestamp (timestamp(14)) and a message (char(255)). I need to keep the table from exceding a certain

Re: sql

2002-02-13 Thread Gerald Clark
perhaps because you are root@eros, and not [EMAIL PROTECTED] root wrote: > Hi > > How do I get off the list ? > > I have tried several times with sending a mail to > mysql-unsubscribe-srabol=mysql-unsubscribe-ing.aguirre=internetica.com.mx@lis >ts.mysql.com, and tried the > http://lists.mysql.co

Re: Distributed Fulltext?

2002-02-13 Thread Brian DeFeyter
On Wed, 2002-02-13 at 16:39, Mike Wexler wrote: > > > Brian DeFeyter wrote: > > I sorta like that idea. I don't know exactly what you can and can't do > > as far as indexing inside of HEAP tables.. but the index size would > > likely differ from the written index. Then you can expand the idea an

Re: Distributed Fulltext?

2002-02-13 Thread Mike Wexler
Brian DeFeyter wrote: > I sorta like that idea. I don't know exactly what you can and can't do > as far as indexing inside of HEAP tables.. but the index size would > likely differ from the written index. Then you can expand the idea and > use the X/(num slices) on (num slices) boxes technique..

RE: ORDER BY an ABSolute value

2002-02-13 Thread Chris Thomas
The sql statement select id from table_name order by abs(id); works with version 3.23(i use 3.23.44) but not 3.22 or below -Original Message- From: Keith A. Calaman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 12 February 2002 11:24 AM To: David Mackay Cc: [EMAIL PROTECTED] Subject: RE: ORD

Mysql on NT/2000

2002-02-13 Thread Johnny Withers
A friend of mine plans to host a site on NT/2000. After looking over the pricing for an enterprise version of MSSQL Server 2000, he's considering other DB backends for his project. I suggested MySQL (of course). However, I have never run MySQL on any Windows platform before. I was wondering if t

Re: problems with default-character-set=cp1251

2002-02-13 Thread Miguel Angel Solorzano
At 09:48 13/02/2002 +0300, =?koi8-r?B?6czY0SDl18fFztjF18neIOvP0s/Cz9c=?= wrote: Hi! I did the test with default-character-set=cp1251 and was not be able to repeat your problem: Microsoft Windows 2000 [Versão 5.00.2195] (C) Copyright 1985-2000 Microsoft Corp. C:\>cd\server\usr\mysql\bin C:\ser

Re: MySQL on Linux, Athlon MP stability?

2002-02-13 Thread Christopher Thompson
On Wednesday 13 February 2002 12:10 pm, Trond Eivind Glomsrød wrote: > > Our kernel people love them - Athlon goodness, no VIA chipset. Good > performance, good stability. Note that the Via kt266a (_not_ SMP chipset) is quite good these days. If I was building a dual-processor machine, there's n

RE: [SQL] How to delete multiple instances

2002-02-13 Thread Rick Emery
If you're using mysql 4.0, you might try: DELETE addrbkb FROM addrbkA,addrbkB WHERE addrbkA.phone=addrbkB.phone; This functionality was added with 4.x. I haven't tested this, so BEWARE The following is from the 4.0 manual: DELETE t1,t2 FROM t1,t2,t3 WHERE t1.id=t2.id AND t2.id=t3.id In the abov

RE: MySQL on Linux, Athlon MP stability?

2002-02-13 Thread Matthew Walker
Well, I don't have anything yet, but I've got a server in the mail coming to me that is a dual Athlon MP 1900+. I'll be getting it either today, or tomorrow with any luck, and I'll let you know how things go. Gonna be running SuSE 7.3, PHP, MySQL, Apache, BIND9 and various other packages on it. O

Problems with a join...

2002-02-13 Thread Chad Day
I'm trying to write a polling application and display the results on an admin screen.. my goal is to show all the answers for the poll questions and display the # of votes for each. The query I have to do this is: select pd.ANSWER_TEXT, pr.*, COUNT(*) as NUM from ft_pollresponses as pr right joi

Re: Distributed Fulltext?

2002-02-13 Thread Brian DeFeyter
I sorta like that idea. I don't know exactly what you can and can't do as far as indexing inside of HEAP tables.. but the index size would likely differ from the written index. Then you can expand the idea and use the X/(num slices) on (num slices) boxes technique.. sending the query to each, and

W2K Network

2002-02-13 Thread Otto Saayman
Hi there I have an Internal Network running MySQL with all machines running W2K. One of them has a VB Application which uses MyODBC to connect to another server running MySQL. The VB produces this error: Access Denied for username@vbappmachinename ... Using Password YES ... ODBC is set up with

Re: mysql minimum memory requirement

2002-02-13 Thread Christopher Thompson
On Wednesday 13 February 2002 10:51 am, Shih-Hao Li wrote: > > Does anybody know what's the minimum memory requirement > for mysql running on Redhat Linux and Sun Solaris? > Please reply or cc to my email address. I have run MySQL with 32 megs of RAM quite happily. Note that this was NOT partic

MySQL && OpenBSD equals high load ?

2002-02-13 Thread shoeke
>Description: After upgrading from OpenBSD 2.8 to 3.0 and upgrading MySQL from 3.23.27 to 3.23.42 from the OpenBSD ports tree the load mysql generates seems to have roughly doubled, while the number of update/insert/select queries have remained the same. >How-To-Repeat:

ADO to MySQL interface?

2002-02-13 Thread Guy Davis
Hi all, The company I work for is a Linux shop using MySQL almost exclusively, however we're partnering with Windows-only shop to tie their application into our overall product offering. Their app uses ADO as it's database interface and they say it will work with Oracle, MS SQL Server, and MS

Re: MySQL on Linux, Athlon MP stability?

2002-02-13 Thread Trond Eivind Glomsrød
"Tobias Lind - Telia Internet" <[EMAIL PROTECTED]> writes: > Hello! I'm in the process of upgrading my Linux-server (currently a > dual P2-400MHz), and have been thinking about getting a system with > dual Athlons (maybe 2x Athlon MP 1800+). Does anyone have any > experience (good or bad) with

Re: AW: Bug in MySQL API ?!?

2002-02-13 Thread Michael Widenius
Hi! > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: >> mysql_fix_pointers(mysql, &tmp_mysql); /* adjust connection pointers */ >> ... >> this method contains (unlike version known to me) function call >mysql_fix_pointers(), which probably handles pointers of MYSQL struct.

Re: MySQL and Web Objects5 (OS X)

2002-02-13 Thread David Steinbrunner
>Does anyone know how to cause WO to recognize and offer MySQL as an adaptor? >i.e., how to get WO5 to use MySQL?) > >Thanks in advance. You might want to try the Web Objects mailing lists at OmniGroup: http://www.omnigroup.com/developer/mailinglists/ -- David Steinbrunner mailto:[EMAIL PROTEC

Reappearing postings: the reason

2002-02-13 Thread Sergei Golubchik
Hi! On Feb 13, Mike(mickalo)Blezien wrote: > On Tue, 12 Feb 2002 17:15:24 -0800, Jeremy Zawodny <[EMAIL PROTECTED]> > wrote: > > >>I'm getting duplicate messages separated by several hours. Am I alone > >>in this, or are others seeing it too? > >> > >>Jeremy > > Yep... it seems the list mailin

RE: Request for help in testing new replication code in 4.0.2

2002-02-13 Thread Steven Roussey
That would be great. Thanks! Sincerely, Steven Roussey http://Network54.com/?pp=e > -Original Message- > From: Brian P. Austin [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 12, 2002 10:45 pm > Subject: RE: Request for help in testing new replication code in 4.0.2 > > I have finis

Re: Using password: _No_

2002-02-13 Thread Cliff
Thanks. This works when I use any other user besides root without a password. Guess the problem is that there is a password for root and I don't know what it is. Thanks again for getting me over the first mindless hurtle. Regards, Cliff Austin "Brian P. Austin" wrote: > > what command are

configure does not propagate threads info properly to innodb and others

2002-02-13 Thread jnp
>Description: When configuring on a netbsd 1.5.2 system which does not have a threads package readily available, the include "-I../mit-pthreads/include" is not passed to innodb. vio misses it (resubmitted because of wrong sender address) >How-To-Repeat:

RE: Is The MySQL Mailing List On Crack?

2002-02-13 Thread SpyProductions Support Team
> Jeremy Zawodny wrote : > > > > I'm getting duplicate messages separated by several hours. Am I alone > > in this, or are others seeing it too? > > > > Jeremy > > -- > > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > > Technical Yahoo - Yahoo Finance > > Desk: (408) 349-7878 Fax: (408) 349-5454

mysql minimum memory requirement

2002-02-13 Thread Shih-Hao Li
Hi, Does anybody know what's the minimum memory requirement for mysql running on Redhat Linux and Sun Solaris? Please reply or cc to my email address. Thank you very much! Shih-Hao ___ GO.com Mail Get Your Free,

Re: Distributed Fulltext?

2002-02-13 Thread Mike Wexler
Steve Rapaport wrote: > > Someone correctly pointed out today that it's not Mysql's job > to be Google, and I agree. But it seems to me that it would be > fair for mysql to be able to handle searches in under 1 second > for databases 1 millionth the size of Google. All I want here > is a dec

RE: Is The MySQL Mailing List On Crack?

2002-02-13 Thread Rick Emery
I posted a message at 7:22 AM (US Central). It just appeared at 11:15 AM (US Central) -- > -Original Message- > From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] > Sent: 13 February 2002 01:15 > To: [EMAIL PROTECTED] > Subject: Is The MyS

Unique indexes and case sensitivity bug(?)

2002-02-13 Thread Andrea Forghieri
>Description: >How-To-Repeat: >Fix: THANX >Submitter-Id: <[EMAIL PROTECTED]> >Originator: root >Organization: >MySQL support: [none ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release: mysql-4.0.1-alpha (Official MySQL RPM) >Server: /usr/bin/mysqladmin Ver 8.18 Di

Re: Distributed Fulltext?

2002-02-13 Thread Mike Wexler
My understanding is that part of how google and Altavista get such high speeds is to keep everything in memory. Is it possible to create a HEAP table with a full text index? If so, does the full text index take advantage of being in memory? For example, I would imagine that if you were keeping

Re: errno: 138

2002-02-13 Thread Kevin Smith
I think it's because it's the old structure, try this... BUT, back-up your database files first! Check that the owner of the database files are MySQL and that they have the correct permissions, then run the following statement : alter table customers type=MyISAM; K - Original Message -

sql

2002-02-13 Thread root
Hi How do I get off the list ? I have tried several times with sending a mail to mysql-unsubscribe-srabol=mysql-unsubscribe-ing.aguirre=internetica.com.mx@lis ts.mysql.com, and tried the http://lists.mysql.com/php/unsubscribe.php link - after submitting my mail address, i don't get a confi

Re: Is The MySQL Mailing List On Crack?

2002-02-13 Thread Dan Nelson
In the last episode (Feb 12), Jeremy Zawodny said: > I'm getting duplicate messages separated by several hours. Am I > alone in this, or are others seeing it too? Bestweb is re-injecting old messages. They did the same thing to the freebsd-questions list a couple days ago. The list admin just

Overwritten mysql tables

2002-02-13 Thread Demirchyan Oganes-AOD098
Hello everyone, I have posted this message 2 days ago, but surprisingly no one responded. I have these scripts that I load when I want to create new tables in the database. I had DB1 full of data. Then I created DB2 and forgot to change the database that I was working in, to DB2. I loaded al

RE: BSD and MySQL : Major Problems

2002-02-13 Thread Jonathan Hilgeman
1) It may seem OS dependent, but unless you've tried the other 2 OSes on the same box with the exact same setup (unlikely), I wouldn't blame the OS right away. (Can you tell I'm biased towards FreeBSD?) 2) This seems to still point to the file system, so again, check your errors/error logs/messag

RE: BSD and MySQL : Major Problems

2002-02-13 Thread Brad Phinney
The problem with this error is (1). It seems OS dependent (cannot recreate it on Linux, Solaris). (2). It happens randomly, no rhyme nor reason. I am simply making a DBI call to do ALTER TABLE or tables-> command. One second it could fail to open the DB directory (hence the error). Three se

Cannot UPDATE mysql record in ASP

2002-02-13 Thread Danis Stéphane (NHQ-AC)
I get this error when trying to update a record using ASP recordsets. Microsoft OLE DB Provider for ODBC Drivers error '80040e21' Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. /Web_local/admin/xt_save.asp, line 39 What is rea

RE: BSD and MySQL : Major Problems

2002-02-13 Thread Jonathan Hilgeman
I would first check your /var/log/messages file, or whatever file is receiving your system warnings/errors. This could be a filesystem problem. If you're not logged in as root, just keep trying your program until you get that error, and quickly go to the shell and type: ls -lt /var/log That shou

MySQL on Linux, Athlon MP stability?

2002-02-13 Thread Tobias Lind - Telia Internet
Hello! I'm in the process of upgrading my Linux-server (currently a dual P2-400MHz), and have been thinking about getting a system with dual Athlons (maybe 2x Athlon MP 1800+). Does anyone have any experience (good or bad) with a dual Athlon system with Linux running MySQL 3.23.x, and maybe Apac

Re: errno: 138

2002-02-13 Thread Georg Richter
> <---snip---> > mysql> select * from customers; > ERROR 1016: Can't open file: 'customers.ISD'. (errno: 138) > <---snip---> http://www.mysql.com/doc/p/e/perror.html Regards Georg - Before posting, please check: http://www

RE: Is The MySQL Mailing List On Crack?

2002-02-13 Thread Jonathan Hilgeman
I'm getting this, too. I first noticed it when Monty appeared to start spamming us with release announcements. :) - Jonathan -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 5:15 PM To: [EMAIL PROTECTED] Subject: Is The MySQL Mailing Lis

RE: ignoring in ORDER

2002-02-13 Thread David McInnis
You may be able to sort using a regex expression. David -Original Message- From: DL Neil [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 1:39 AM To: 'abdul - ÚÈÏ ÇáÑÍãä' <[EMAIL PROTECTED]; [EMAIL PROTECTED]> Subject: Re: ignoring in ORDER Hi Abdul, Can Mysql ignore alp

RE: Probably OT - SQL join help needed

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

RE: Slow Database

2002-02-13 Thread Tim Stephenson
Neil, You can limit the number of records returned by any query by appending " LIMIT x, y " or "LIMIT y" where x is the offset of the first row you want, and y is the maximum number of records to return. For example, "select * from testtable LIMIT 2 " would return the first 2 rows from the table

problems with default-character-set=cp1251

2002-02-13 Thread Victoria Reznichenko
éÌØÑ, Wednesday, February 13, 2002, 8:48:52 AM, you wrote: éåë> Hi. éåë> I use mysql 3.26.47, established on Windows 2000 Server Russian. éåë> After I set property - default-character-set = cp1251, web-server on a éåë> beginning to give out a massage - File ' c:\mysql \\ share\charsets éåë> \?.c

Re: Is The MySQL Mailing List On Crack?

2002-02-13 Thread Dibo Chen
Having gotten TONS of such, I've unsbuscribed twice in vain so far. Jeremy Zawodny wrote: > > I'm getting duplicate messages separated by several hours. Am I alone > in this, or are others seeing it too? > > Jeremy > -- > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > Technical Yahoo - Yahoo Finance

RE: Is The MySQL Mailing List On Crack?

2002-02-13 Thread J. Ceferino Ortega
Yes, I'm getting duplicate messages too. -Mensaje original- De: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Enviado el: miércoles, 13 de febrero de 2002 2:15 Para: [EMAIL PROTECTED] Asunto: Is The MySQL Mailing List On Crack? I'm getting duplicate messages separated by several hours. Am

Do MySQL are going to support NULL value for foreign key fields (in case parent are not null)

2002-02-13 Thread IvanLatysh
Hi All. Do MySQL are going to support NULL value for foreign key fields (in case parent are not null) I didn't found any mentions about this problem in news or somewhere else. If you have any kind of info please answer. Because so hard to use foreign keys without this option. Sincerely yours,

RE: Slow Database

2002-02-13 Thread Roger Baklund
* Neil Tompkins > > Are there any settings I can set to limit the number of records returned ? Yes, the LIMIT clause of the SELECT statement: http://www.mysql.com/doc/S/E/SELECT.html > -- Roger query - Before posting, please

RE: forms?

2002-02-13 Thread Todd Williamsen
Jim, I am still pretty wet behind my ears and I have always had problems with picking up the logic behind programming languages, but PHP is awesome! I had problems with the wacky structure of Visual Basic, and I hard a hard time just reading the code of C++ and Java. What helped me was a book

RE: Is The MySQL Mailing List On Crack?

2002-02-13 Thread Roger Baklund
* Jeremy Zawodny > I'm getting duplicate messages separated by several hours. Am I alone > in this, or are others seeing it too? You are not alone. :o) All the duplicates seems to contain one of the following substrings: cyon=bestweb.net cyon=3Dbestweb.net I have received 492 messages wit

Re: BSD and MySQL : Major Problems

2002-02-13 Thread phinney
/var/SAMT is the directory the program is running from. Do you use an SMP kernel? Ken Menzel wrote: >Hi Brad, > I use many FreeBSD (4.3 to 4.5 ) systems, but I do not have a >/var/SAMT directory. >using: >bash-2.03$ perror 2 >Error code 2: No such file or directory >bash-2.03$ > >Could this

Using password: _No_

2002-02-13 Thread Victoria Reznichenko
Cliff, Wednesday, February 13, 2002, 5:18:27 AM, you wrote: C> Hello, C> Can anyone help? C> When trying to run mysql I get an ERROR 1045: Access denied for user: C> 'root@localhost' (Using password: No). C> In the documentation it mentions 'Using password: YES'. Have tried C> starting mysql wi

Re: BSD and MySQL : Major Problems

2002-02-13 Thread Ken Menzel
Hi Brad, I use many FreeBSD (4.3 to 4.5 ) systems, but I do not have a /var/SAMT directory. using: bash-2.03$ perror 2 Error code 2: No such file or directory bash-2.03$ Could this have something to do with SAMBA or NFS? Ken - Original Message - From: "phinney" <[EMAIL PROTECTED]> To

Re: safe_show_database problem

2002-02-13 Thread Ken Menzel
Hi Steve, Try: safe-show-database Use dashes not underlines. Good Luck, Ken - Original Message - From: "Steve Wright" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 12, 2002 6:01 AM Subject: safe_show_database problem > Hi > > I want to limit the databases users ca

Re: Is The MySQL Mailing List On Crack?

2002-02-13 Thread Joseph Bueno
Jeremy Zawodny wrote : > > I'm getting duplicate messages separated by several hours. Am I alone > in this, or are others seeing it too? > > Jeremy > -- > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > Technical Yahoo - Yahoo Finance > Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936

RE: Using password: _No_

2002-02-13 Thread Brian P. Austin
what command are you issuing. is it mysql? If so, what arguments are you sending it? It should look like this mysql -u user -p prompt: password -Original Message- From: Cliff [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 9:18 PM To: [EMAIL PROTECTED] Subject: Using pas

RE: Is The MySQL Mailing List On Crack?

2002-02-13 Thread Rick Emery
I'm not certain about the list. I mailed several message on Tuesday about 3 PM central time. They did not appear until 4:30 AM Wednesday. Many of my messages were duplicated because I did not see them in the list when I mailed them so I was uncertain whether I had even mailed them. Today, I se

Re: Windows Version of MySQL licensing question?

2002-02-13 Thread Miguel Angel Solorzano
At 20:31 12/02/2002 +, David Ayliffe wrote: Hi! You can assume that the Windows License Terms is the same than Unix version. The shareware is a License option that was abandoned. Regards, Miguel >I read in Paul's book that to use MySQL on a Windows platform you need >to pay for it. > >I

Re: upgrading mysql-3.23.48 and rpm package.

2002-02-13 Thread Egor Egorov
Ireneusz, Tuesday, February 12, 2002, 11:46:40 AM, you wrote: IP> HI. IP> No i get twice the .rpm of mysql-3.23.48. It is'nt corrupted. IP> I could'nt install it. IP> I have rpm 3.0.4. on my RH 6.2 (Zoot) box. IP> Is there on the NET, rpm package of mysql-3.23.48, which can i install with IP> r

RE: Is The MySQL Mailing List On Crack?

2002-02-13 Thread Peter Lovatt
no! about 150 messages today Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- >

RE: Re: Indexes on UPDATE/DELETE

2002-02-13 Thread Rick Emery
>Also, how do I reset an auto-increment value back to 1 (with all >rows being already deleted of course). The following deletes all records and re-starts renumbering from 1; DELETE FROM mytable; The following deletes all records and continues counting from where the table last left off: DELETE F

Web hosting for InnoDB

2002-02-13 Thread Kevin McBrearty
We are working on a Java web application and are thinking about using InnoDB. Does anybody know any hosting companies in the US/Canada that support InnoDB table types in MySQL. Most that I have checked with don't. -- Kevin McBrearty ATG Automation Technologies Group Ltd. ---

RE: Is The MySQL Mailing List On Crack?

2002-02-13 Thread G r e g L a w r i e
I'm getting it and several others have as well !!! > -Original Message- > From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 13 February 2002 11:45 > To: [EMAIL PROTECTED] > Subject: Is The MySQL Mailing List On Crack? > > > I'm getting duplicate messages separated by sev

  1   2   3   >