New to mysql .. how to start it

2002-03-07 Thread amol sonaikar
Hi All I am very much new to mysql. We have installed it in machine but I don't know how to start it and what's it's default user to connect. I am still stuck at $ prompt..entering command Amol - http://mail.indiainfo.com India's first ISO certified

Re: MySQL Server uptime.

2002-03-07 Thread Jonas Björklund
Hi, > Up 212 days, > Processed 199,654 queries (average = 0.01/sec) > Processed 2 slow queries (woops ;-) don't you hate leaving out the where > statement on joins) I have also noticed that uptime is not calculated the same way as the Linux kernel. I have more uptime on the MySQL server then hos

Urgently required

2002-03-07 Thread Pramod_Chakravarthy
Dear Sir/Madam, I am looking out some information on the features My SQL freeware version and the Enterprise version. So I would be very happy if you could put on a table with the comparison of Mysql freeware version vs Mysql enterprise version. Please reply to this mail id as soon as possible b

max function

2002-03-07 Thread Manish Mehta
Hi I got a problem with max function select a.cemp_firstname,sum(nsalary_value),max(nsalary_status),max(dstatus_date) from employeemaster as a,empsal as s where a.nemp_id = s.nemp_id group by dstatus_date This query shows me two records . But my requriment is according to the max -> salary stat

MySQL Server uptime.

2002-03-07 Thread Neil Silvester
I know this isn't really on topic but I thought some people may find this interesting. The below stats were taken from a non-production server which I dump to from my production server as a kind of backup method using MysqlFront. I might add that today I did several multi-table joins on the world

Re: MySQL 4.0.x Replication Just Dumped Core...

2002-03-07 Thread Jeremy Zawodny
On Thu, Mar 07, 2002 at 09:48:41PM -0800, Jeremy Zawodny wrote: > Hey Sasha, [snip] > I'll keep it off-line until I hear from you on what data you need. Oops. Here's the info form the error log: ---snip--- 020307 21:39:03 Slave I/O thread initialized 020307 21:39:03 Slave SQL thread initia

Dropdown lists

2002-03-07 Thread Josiah Wallingford
I need to create a dropdown list in my script I am writing but don't know how to set it up in mysql. I have Mysql> create table tablename -> (now here is what I don¹t know what to put) state varchar(100); Do I use varchar for drop down lists? -

Client won't run queries with WHERE or IDENTIFIED BY or VALUES

2002-03-07 Thread Mark Painter
>Description: Installation has never worked properly - I have re-installed 5 or 6 times, different versions. Initially Mandrake 7.0 version, then tried to install a 386 rpm - wouldn't install, said it was for the wrong architecture, so tried the i686 binaries (initially 3.23.33-pc-linux-g

MySQL 4.0.x Replication Just Dumped Core...

2002-03-07 Thread Jeremy Zawodny
Hey Sasha, The 4.0.x slave I had just rebuilt the other day died about 40 minutes ago and produced a core file each time. It got caught in the cycle of "core dump, restart, core dump, restart..." In any case, here's a backtrace: #0 0x2839d330 in kill () from /usr/lib/libc_r.so.4 #1 0x283e9ab

STD()

2002-03-07 Thread RBRoa
Everyone, Is this correct?...how MySQL calculate this?... mysql> select * from temp; +--+ | cal | +--+ | 00029.98 | | 00029.95 | | 00029.89 | | 00029.84 | | 00029.78 | | 00029.81 | | 00029.84 |

Re: delete after undo

2002-03-07 Thread John Hunter
> "Joel" == Joel Rees <[EMAIL PROTECTED]> writes: Joel> This begins to sound like a job for Perl. Of course, it Joel> would be nice if you could get someone familiar with the Joel> internal formats mysql uses to give you some hints Yes, I am having trouble deciphering the primary

Re: delete after undo

2002-03-07 Thread Joel Rees
John Hunter asked: > Before I give up hope entirely, I notice that the file > mysql/var/seizure/surgery.MYD is not empty, and has the values from > the table before the delete in it. Although it is a binary file, > because it has large text fields I can read enough of it with 'less' > to see tha

Re: problem in mysqi

2002-03-07 Thread Intrex
mysqladmin was installed in /usr/bin on my system. or do a locate mysqladmin that will tel ya where it is Mark - Original Message - From: "Jianping Zhu" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, March 07, 2002 11:37 PM Subject: problem in mysqi > > > I downloaded the

Re: Anyone get MySQL and RH7.2 to work?

2002-03-07 Thread Michael Brunson
On Thu, 7 Mar 2002 22:20:46 -0500, Paul Warren used a few recycled electrons to form: | I've been frustrated with this for the past I-donno-how-many days. Has | anyone been able to get MySQL to work on Red Hat 7.2? | | I've been getting multiple errors. The First was the resolveIP() right from |

problem in mysqi

2002-03-07 Thread Jianping Zhu
I downloaded the the qpl MySQL-VERSION.i386.rpm and installed in redhat 7.2 sucessfully. but I find i can not use command like BINDIR/mysqladmin version to test the server because the file mysqladmin is not there. And I can not find bidir/mysqlshow bindir/mysql Do I have to install MySQL-cli

Reg Foreign Key

2002-03-07 Thread Sanjay Chigurupati
Hi, Should I or shouldn't I explicitly specify the foreign key in Mysql? If I am not mistaken, Mysql handles foreign keys automatically at query time and we need not explicitly specify the foreign key. But, will the database detect error when I enter non-existent value for a foreign key? Do I n

problems with SELECT and related tables

2002-03-07 Thread David Youngblood
I am running Apache/PHP 4/MySQL 3.23 on a Win98. The following statement will not execute in PHP MyAdmin or through the browser. However it does run under my SQL tool SQLion: SELECT contacts.contactId,contacts.firstName,orders.orderId FROM contacts INNER JOIN orders ON contacts.contactId = order

Re: making " : " an allowable character in tables & colums

2002-03-07 Thread Dan Nelson
In the last episode (Mar 08), [EMAIL PROTECTED] said: > Dan Wrote: > > In the last episode (Mar 08), [EMAIL PROTECTED] said: > > > Access can do it, & I have queries in access that need to be able > > > to read the data I imported into Mysql from access. Can it be > > > done, if so how > > > > Quo

Re: delete after undo

2002-03-07 Thread John Hunter
> "Paul" == Paul DuBois <[EMAIL PROTECTED]> writes: Paul> You can undo them using your backup. Otherwise, no. Well, since my backup is a couple of weeks old, this bites. Before I give up hope entirely, I notice that the file mysql/var/seizure/surgery.MYD is not empty, and has the value

Re: Why v3.23.49 does not build on RedHat 6.2 ?????

2002-03-07 Thread Sommai Fongnamthip
If I'd like to upgrade LH 6.2 to LH 7.0+. Would my old data (LH setting, MySQL db) lost? Sommai At 10:59 6/3/2002 -0500, Trond Eivind Glomsrød wrote: >"Ireneusz Piasecki" <[EMAIL PROTECTED]> writes: > > > Do you mean: You can forget upgrading on RH6.2 the glibc 2.1 to 2.2. > > Maybe one did it

Anyone get MySQL and RH7.2 to work?

2002-03-07 Thread Paul Warren
I've been frustrated with this for the past I-donno-how-many days. Has anyone been able to get MySQL to work on Red Hat 7.2? I've been getting multiple errors. The First was the resolveIP() right from the beginning. I follwed what the mysql website said and got glibc version 2.95 and that error d

Re: standard deviation

2002-03-07 Thread Paul DuBois
At 10:26 +0800 3/8/02, [EMAIL PROTECTED] wrote: >Everyone > >Does MySQL support standard deviation function? STD() or STDEV(). http://www.mysql.com/doc/G/r/Group_by_functions.html > >Sample.. > >10.03 >10.12 >9.28 >10.04 > >Standard deviation = 0.39 > > > > >R.B.Roa >Traffic Management Engineer

URGENT - problem in inserting single quote

2002-03-07 Thread Manisha
I am inserting into the table values with single Quote (MySql table). If I give the command through text file - Insert into test values ('manisha\' test') - then this is ok, but when i try to insert the manisha ' test value through http:///sqladmin using GUI then MySql is giving error. Any h

Re: delete after undo

2002-03-07 Thread Paul DuBois
At 21:05 -0600 3/7/02, John Hunter wrote: >I just did > >delete from some_table where 1>0; > >when I wanted to do > >delete from some_table where pid=1234; > >Oops! > >Nothing else has been done to the database since then. Can I undo or >not commit these changes? You can undo them using your bac

Blue World ... I think we all agree

2002-03-07 Thread Paul Warren
Well I wrote a big message and tried to send it to the mysql list but it got returned saying it was spam. Then I got to think that maybe it is. I see that the whole Blue World discussion is not quite as big as it was before but here's my suggestion. Either we email Blue World with our complaints

RE: Re: [ANN] Blue World Announces Lasso vs. PHP White Paper

2002-03-07 Thread Paul DuBois
Perhaps all you folks who have a problem with Blue World's posting can send your comments directly to them. It's unlikely that the rest of us care to read them. The "discussion" has now come to exhibit what all "that is SPAM!" threads metamorphose into sooner or later: the offense of the origin

delete after undo

2002-03-07 Thread John Hunter
I just did delete from some_table where 1>0; when I wanted to do delete from some_table where pid=1234; Oops! Nothing else has been done to the database since then. Can I undo or not commit these changes? I am sure this is a FAQ, but I am in a panic so I would be much obliged if someone can

RE: Re: [ANN] Blue World Announces Lasso vs. PHP White Paper

2002-03-07 Thread James Cox
Ah, this is correct, apologies, i was given the wrong information - apologies for giving the wrong impression. James > -Original Message- > From: Lee McNeil [mailto:[EMAIL PROTECTED]] > Sent: Friday, March 08, 2002 2:22 AM > To: Mysql > Subject: Re: Re: [ANN] Blue World Announces Lasso

Re: [ANN] Blue World Announces Lasso vs. PHP White Paper

2002-03-07 Thread John Steele
I found that quite interesting also. I develop locally on windows, but deploy to Linux, Cobalt Raqs, FreeBSD, Solaris etc. without any 'difficulties'. Todd Williamsen wrote: >Here is a blurb from the report of the white paper > >Lasso operates identically across platforms whereas with PHP, >

RE: DBI installation

2002-03-07 Thread Dan Vande More
You should befriend a little program called webmin, available at www.webmin.com/webmin Once installed go to "Other" and perl modules, it does it all for you... Dan -Original Message- From: Andy Cheng [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 6:19 PM To: [EMAIL PROTECTED]

standard deviation

2002-03-07 Thread RBRoa
Everyone Does MySQL support standard deviation function? Sample.. 10.03 10.12 9.28 10.04 Standard deviation = 0.39 R.B.Roa Traffic Management Engineer PhilCom Corporation Tel.No. (088) 858-1028 Mobile No. (0919) 30856267 -

Re: Re: [ANN] Blue World Announces Lasso vs. PHP White Paper

2002-03-07 Thread Lee McNeil
James, I believe there is something amiss here. Here is the header output from www.blueworld.com (192.147.161.21) using curl: [lee@whitestar lee]$ curl -i www.blueworld.com HTTP/1.1 302 Moved Temporarily Date: Fri, 08 Mar 2002 02:13:20 GMT Content-Type: text/html Connection: close URI: http://w

Re: NULL timestamps not possible?

2002-03-07 Thread Michael Stassen
Guess you still missed this line: - If you have multiple TIMESTAMP columns, only the first one is updated - automatically. Your example explicitly sets the first one to an empty string and doesn't set the second, so both get 000... Michael On Thu, 7 Mar 2002, Shankar Unni wrote: > Paul DuBoi

RE: Re: [ANN] Blue World Announces Lasso vs. PHP White Paper

2002-03-07 Thread Todd Williamsen
Here is a blurb from the report of the white paper Lasso operates identically across platforms whereas with PHP, significant functionality is lost migrating from one platform to another. This makes it very difficult to develop on one platform and deploy on another when using PHP. Lasso's platform

RE: Re: [ANN] Blue World Announces Lasso vs. PHP White Paper

2002-03-07 Thread Todd Williamsen
Quite hilarious... Interesting.. Trying to compete versus PHP and they use php... Wild Whats next PHP website using ASP? -Original Message- From: Jeff Kilbride [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 7:25 PM To: MySQL Subject: Re: Re: [ANN] Blue World Announces Lasso

RE: NULL timestamps not possible?

2002-03-07 Thread Al Caponi
> Of course, the page lies somewhat: it says that if you omit the column in > an insert, it should get set to now(), but the following example shows it > doesn't - notice that "u" is omitted in the insert, but gets set to 0 > instead of now(). > > >>create table foo (t timestamp, u timestamp);

Re: Re: [ANN] Blue World Announces Lasso vs. PHP White Paper

2002-03-07 Thread Jeff Kilbride
Ok, now *that's* funny!! :o) Guess Blue World's dev team haven't read the White Paper... --jeff - Original Message - From: "James Cox" <[EMAIL PROTECTED]> To: "Mysql" <[EMAIL PROTECTED]> Sent: Thursday, March 07, 2002 3:45 PM Subject: FW: Re: [ANN] Blue World Announces Lasso vs. PHP W

DBI installation

2002-03-07 Thread Andy Cheng
Hello all, I am new to linux. I need to connect to Mysql using perl. I downloaded DBI-1.18.tar.gz, Msql-Mysql-modules-1.2216.tar.gz from http://www.mysql.com/downloads/api-dbi.html. I don't see any installation instruction. Could some one show me how to install it? Thanks for the help.

Re: NULL timestamps not possible?

2002-03-07 Thread Shankar Unni
Paul DuBois wrote: > Feature you missed. Have a look here: > > http://www.mysql.com/doc/D/A/DATETIME.html Thanks. I wonder how I missed that. Of course, the page lies somewhat: it says that if you omit the column in an insert, it should get set to now(), but the following example shows it

Re: Can not connect (again)

2002-03-07 Thread Doug Thompson
Egor: Yesterday, I wrote and described that my fix for a single cpu, non-RAID environment was installing a new version. What I didn't say at the time is that the mysql.sock file was present exactly where it was supposed to be and at exactly the location the error message said it couldn't fin

Re: making " : " an allowable character in tables & colums

2002-03-07 Thread Arjen Lentz
Hi Joseph, On Fri, 2002-03-08 at 08:33, [EMAIL PROTECTED] wrote: > Access can do it, & I have queries in access that need to be able to read > the data I imported into Mysql from access. > Can it be done, if so how (hello fellow Australian ;-) Well, you can stuff pretty much anything into a col

Upgrading from mysql to mysql-max

2002-03-07 Thread Chris Book
Hello, Currently I have a server running an older version of mysql 3.23. This was installed using RedHat's provided RPMs (ie there's mysql, mysql-shared and mysql-devel RPMs installed). I want to upgrade to mysql-max (latest 3.23 version) however I'm pretty sure that the redhat RPMs place the m

Re: NULL timestamps not possible?

2002-03-07 Thread Paul DuBois
At 16:31 -0800 3/7/02, Shankar Unni wrote: >Shankar Unni wrote: > >>I tried setting a TIMESTAMP column (nullable, not first timestamp >>in that table) in mysql 3.23.38) to NULL, but it seems to get the >>value 00. Is it not possible to set a timestamp column >>to NULL? > > >It's ev

Re: Connect two SQL database with one connection

2002-03-07 Thread Paul DuBois
At 15:36 -0800 3/7/02, Zengfa Gao wrote: >Hi, > >I am trying to connection two SQL database with one >connection, such as: > >select name from db1.table1; > >select name from db2.table2; > >Is this working for JDBD driver? Both databases are on the same server? Should work. > > >Zengfa --

Re: C API BLOB type field lengths returned

2002-03-07 Thread Arjen Lentz
Hi, Kenneth, On Fri, 2002-03-08 at 08:48, Kenneth Hylton wrote: > I've posted this twice before - third time might be the charmer... > Can anybody help me? > I am using the C API and am returning a result set from a table with a BLOB > type item in it. > When I populate the BLOB fields initially

Re: Bug or Misunderstanding

2002-03-07 Thread Paul DuBois
At 17:42 -0500 3/7/02, [EMAIL PROTECTED] wrote: >Perhaps I misunderstand how the UNION statement is to be used, but the >following query doesn't work as I'd expect: > >SELECT column_id, SUM(column_a) AS positive_a FROM table_a WHERE column_b = >'positive' >UNION >SELECT column_id, SUM(column_a) AS

Re: DBD::mysql for non-mysql box

2002-03-07 Thread Paul DuBois
At 15:40 -0800 3/7/02, Brian Warn wrote: >If I want to load DBD::mysql on a box where mysql is not installed, do I >need to install some mysql components? I'm doing this because I'll be DBD::mysql uses the MySQL C client library. You can't install without it. >connecting to a remote box from m

Re: NULL timestamps not possible?

2002-03-07 Thread Shankar Unni
Shankar Unni wrote: > I tried setting a TIMESTAMP column (nullable, not first timestamp in > that table) in mysql 3.23.38) to NULL, but it seems to get the value > 00. Is it not possible to set a timestamp column to NULL? It's even worse: if you explicitly insert the value NULL (

Re: NULL timestamps not possible?

2002-03-07 Thread Paul DuBois
At 16:10 -0800 3/7/02, Shankar Unni wrote: >I tried setting a TIMESTAMP column (nullable, not first timestamp in >that table) in mysql 3.23.38) to NULL, but it seems to get the value >00. Is it not possible to set a timestamp column to >NULL? It is not possible. Setting a TIMESTA

RE: hosting

2002-03-07 Thread Gina
Marnix, You can install MySQL and PHP on your own computer easily. Read this: http://hotwired.lycos.com/webmonkey/99/21/index2a.html Check the side menu for installing each. Or, you might be able to find some free hosting here: http://www.free-php-hosting.com/ http://free-php.cjb.net/ Goodluck!

Re: C API BLOB type field lengths returned

2002-03-07 Thread Paul DuBois
At 16:48 -0600 3/7/02, Kenneth Hylton wrote: >Howdy - >I've posted this twice before - third time might be the charmer... >Can anybody help me? >I am using the C API and am returning a result set from a table with a BLOB >type item in it. >When I populate the BLOB fields initially (with all the sa

Re: hosting

2002-03-07 Thread Charles Quesenberry
At 12:53 AM 3/8/2002 +0100, you wrote: >Hello, >I am starting to work with mysql and php. >Does anyone know where to get a hosting that is free and that supports MySql >and PHP. >I would like to try out first before purchase a parking space on the >internet. One of the fantastic qualities of MyS

Re: hosting

2002-03-07 Thread Duncan Hill
On Thu, 7 Mar 2002, Ken Anderson wrote: > Got an old PII sitting around? > Install RedHat 7.2 w/mysql, apache, php, etc... PII? Yeesh, I run that stuff on an old PPro.. and I've run that stuff on a classic pentium with no problem.. mysql, php etc aren't all that CPU intensive, unless doing l

NULL timestamps not possible?

2002-03-07 Thread Shankar Unni
I tried setting a TIMESTAMP column (nullable, not first timestamp in that table) in mysql 3.23.38) to NULL, but it seems to get the value 00. Is it not possible to set a timestamp column to NULL? -- Shankar. - Bef

Re: hosting

2002-03-07 Thread Ken Anderson
Got an old PII sitting around? Install RedHat 7.2 w/mysql, apache, php, etc... You'll learn much more than just php and mysql, but no free service is going to really give you the access you need to learn mysql and php very well. Ken Marnix Vandegehuchte wrote: > > Hello, > I am starting to wo

RE: :mysql for non-mysql box

2002-03-07 Thread Brian Warn
Please disregard. I finally found the answer -- I need mysql client software on the local box -- in the online documentation. Brian -Original Message- From: Brian Warn [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 3:40 PM To: 'MySQL List' Subject: DBD::mysql for non-mysql b

Re: error starting mysql

2002-03-07 Thread Ken Anderson
If you are on RedHat, you might need to do mysql> grant all on books.* to [EMAIL PROTECTED] identified by 'bookorama123'; Ken Norman Zhang wrote: > > Hi, > > I assigned rights to a user in mysql, > > mysql> grant all on books.* to bookorama@localhost identified by > 'bookorama123'; > > Then

hosting

2002-03-07 Thread Marnix Vandegehuchte
Hello, I am starting to work with mysql and php. Does anyone know where to get a hosting that is free and that supports MySql and PHP. I would like to try out first before purchase a parking space on the internet. Thanks in advance Marnix -

Re: error starting mysql

2002-03-07 Thread Charles Quesenberry
My last email was technically correct, but not the root of your problem. Please accept my humble apologies. The answer to your problem is in the "MySQL" book by Paul DuBois, on page 429. If you do not have the book (and I highly recommend it), I will summarize. This situation happens if you

FW: Re: [ANN] Blue World Announces Lasso vs. PHP White Paper

2002-03-07 Thread James Cox
mysql,sql,query ~> telnet www.blueworld.com 80 Trying 192.147.161.21... Connected to www.blueworld.com. Escape character is '^]'. HEAD / HTTP/1.0 HTTP/1.0 200 OK Date: Thu, 07 Mar 2002 23:38:36 GMT Content-Type: text/html Server: Apache/1.3.20 (Unix) PHP/4.1.3-dev X-Powered-By: PHP/4.1.3-dev Conn

DBD::mysql for non-mysql box

2002-03-07 Thread Brian Warn
If I want to load DBD::mysql on a box where mysql is not installed, do I need to install some mysql components? I'm doing this because I'll be connecting to a remote box from my perl script to query, etc. mysql on the remote box. While using cpan to install the DBD::mysql module, I received the

Connect two SQL database with one connection

2002-03-07 Thread Zengfa Gao
Hi, I am trying to connection two SQL database with one connection, such as: select name from db1.table1; select name from db2.table2; Is this working for JDBD driver? Zengfa __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free

Re: making " : " an allowable character in tables & colums

2002-03-07 Thread Dan Nelson
In the last episode (Mar 08), [EMAIL PROTECTED] said: > Access can do it, & I have queries in access that need to be able to read > the data I imported into Mysql from access. > Can it be done, if so how Quote the name with `backtics` http://www.mysql.com/doc/L/e/Legal_names.html -- Da

Re: A sure "way" to start/connect mysql under Linux

2002-03-07 Thread Shankar Unni
Gelu wrote: > 3.Go to in /etc/init.d and make 2(two) symbolic link from mysqld script to > ... > - "K12mysqld" - OS kill the daemon when shutdown. > - "S12mysqld" - OS start the daemon on boot. > ...in rc3.d directory (if your OS boot on text mode) or rc5.d directory (if > your OS boot wi

Bug or Misunderstanding

2002-03-07 Thread mike . miller
Perhaps I misunderstand how the UNION statement is to be used, but the following query doesn't work as I'd expect: SELECT column_id, SUM(column_a) AS positive_a FROM table_a WHERE column_b = 'positive' UNION SELECT column_id, SUM(column_a) AS negative_a FROM table_a WHERE columb_b = 'negative' I

C API BLOB type field lengths returned

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

RE: [ANN] Blue World Announces Lasso vs PHP White Paper

2002-03-07 Thread Jonathan Hilgeman
> The lesson here is don't preach to those who might not want to be converted. W.W.J.D. - after Jesus cast the demon Legion out of that one guy, the people in that area asked him to leave and he left without any arguments. Take a hint from the Savior, Blue World. - Pastor Jonathan "Reverend of

RPM installation fails on RH7.2

2002-03-07 Thread Olav Drageset
Hi I have installed RedHat 7.2 . with Apache and DNS as default. When trying to install MySQL with kpaackage manager I get rpmdepCheck() fialed. I cannot see any required modules missing. Can anyone tel me what is wrong? Olav ---

Re: [ANN] Blue World Announces Lasso vs PHP White Paper

2002-03-07 Thread Kim Kohen
G'day Cathy > we feel it only > fair to be given the opportunity to correct said misinformation. You're forgetting that your original mail was forced upon us by you - in my eyes, your right of reply is dissolved with this action. If you don't like the negative response, don't make the origi

making " : " an allowable character in tables & colums

2002-03-07 Thread joseph . chillari
Access can do it, & I have queries in access that need to be able to read the data I imported into Mysql from access. Can it be done, if so how TIA Joseph ### Any views in this message are those of the individual sender, except wher

RE: MS-DOS Window

2002-03-07 Thread Robbie Martinez
Yes ... just went to mysql.com and I think the tee functionality was introduced in 3.23.XX -Robbie On Thu, 7 Mar 2002, Todd Williamsen wrote: > I don't have a problem and I am using 3.23.47 > > > -Original Message- > From: Robbie Martinez [mailto:[EMAIL PROTECTED]] > Sent: Thursday

RE: MS-DOS Window

2002-03-07 Thread Todd Williamsen
I don't have a problem and I am using 3.23.47 -Original Message- From: Robbie Martinez [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 3:51 PM To: Gurhan Ozen Cc: [EMAIL PROTECTED] Subject: RE: MS-DOS Window I tried using 'tee' in MySql but it's not working. mysql> tee f

error starting mysql

2002-03-07 Thread Norman Zhang
Hi, I assigned rights to a user in mysql, mysql> grant all on books.* to bookorama@localhost identified by 'bookorama123'; Then I tried to access mysql in as a regular user, [bookorama@a177 bookorama]$ mysql -u bookorama books -p; Enter password: bookorama123 And I get the following error mes

RE: MS-DOS Window

2002-03-07 Thread Robbie Martinez
I tried using 'tee' in MySql but it's not working. mysql> tee file.txt; ERROR 1064; You have an error in your SQL syntax near 'tee file' at line 1 I'm running version 3.22.34-shareware-debug on Win98. Is this a problem? Do I need to pick up a more recent version? Thanks, Robbie On Mon,

A sure "way" to start/connect mysql under Linux

2002-03-07 Thread Gelu
Hi Suppose we have the binary distribution already installed. 1. run mysq_install_db "script" 2. run mysql_setpermission 3.Go to in /etc/init.d and make 2(two) symbolic link from mysqld script to ... - "K12mysqld" - OS kill the daemon when shutdown. - "S12mysqld" - OS start the daemon on

RE: [ANN] Blue World Announces Lasso vs PHP White Paper

2002-03-07 Thread Todd Williamsen
Hmm Isn't price one of the the factors in doing a comparision? No matter what project size it is, cost plays a major role. If I can save a client $3000 by using PHP versus using Lasso, I would. It doesn't seem Lasso has a $3000(or more) advantage over PHP/mySQL combo. The thing is that peop

RE: [ANN] Blue World Announces Lasso vs PHP White Paper

2002-03-07 Thread Jonathan Hilgeman
> All we're doing here is providing information on a report that was just released and answering questions and clarifying mis-perceptions. Don't you mean "All we're doing here is marketing our product to an e-mail list" ... ? > Sharing information for the betterment of the community is good for

RE: [ANN] Blue World Announces Lasso vs. PHP White Paper

2002-03-07 Thread Luc Foisy
I don't know what you people are talking about. I have not one clue about anything PHP. But, if the software performs better. Is it not better? If at this time I wanted to think about that course of action, if both were going to cost me the same in time and money to learn, and I took that cost t

RE: Running MySQL as Service on 2000 Server

2002-03-07 Thread Todd Williamsen
I have no problem running mySQL as a service on Win2k Server. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 2:35 PM To: [EMAIL PROTECTED] Subject: Running MySQL as Service on 2000 Server Hi, Anybody running MySQL on Win 2000 ser

Re: [ANN] Blue World Announces Lasso vs PHP White Paper

2002-03-07 Thread Cathy Cunningham (Blue World Lasso Evangelist)
At 1:47 PM -0700 3/7/02, Van wrote: >> If you do a true comparison in features, you'll see that a PHP-based >> solution (with commercial add-ons) costs over three times the cost of >> Lasso. > >I try to stay out of such discussions, but your marketing-oriented spiel >inspired me to point out th

Re: insert problems

2002-03-07 Thread BD
At 01:40 PM 3/7/2002, you wrote: >Are there any documented reasons why mysql would only enter certain fields >and "skip" others? >I am having some strange problems where it seems that data are randomly >"dropped" from inserts via web forms. > >Have posted before stating a possible cache or proxy

Re: [ANN] Blue World Announces Lasso vs PHP White Paper

2002-03-07 Thread Van
From: Cathy Cunningham (Blue World Lasso Evangelist) > If you do a true comparison in features, you'll see that a PHP-based > solution (with commercial add-ons) costs over three times the cost of > Lasso. I try to stay out of such discussions, but your marketing-oriented spiel inspired me to poin

Re: [ANN] Blue World Announces Lasso vs PHP White Paper

2002-03-07 Thread John Cichy
Another thread pointed out that this runs on doze and Mac, I would venture to say a lot if not most, on this list are *nix people, so the have gotton bad press and have not targeted the correct userbase. Myself, if you spam me, I will not look at you products. spam kills! John On Thursday 07

RE: [ANN] Blue World Announces Lasso vs PHP White Paper

2002-03-07 Thread Adam
What they need is a PHP->Lasso converter, or offer a dev person to convert your application. Similar to ASP2PHP MYSQL CONTENT: And does Lasso offer MySQL connection pooling? -Original Message- From: John Dean [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 2:59 PM To: [EMAI

Running MySQL as Service on 2000 Server

2002-03-07 Thread martin . tunggorono
Hi, Anybody running MySQL on Win 2000 server here? I just installed MySQL 3.23.49-MAX (w/ InnoDB) on a 2000 Server (Dual 1.1 GHz - 1GB RAM - 15GB HD space) and I can run it without any problem from the command line as a standalone. However I couldn't run it as a service even though I already did

Re: [Mysql] Sorry for the reply.

2002-03-07 Thread Jeff Kilbride
The list has an automatic filter that blocks any message that doesn't contain either "sql" or "query" in it. Pain in the butt sometimes -- that's why you'll see "sql query" at the bottom of a lot of people's emails, or in their signature. --jeff - Original Message - From: "Chuck "PUP" Pa

Re: InnoDB and hosts.allow/deny

2002-03-07 Thread Jeremy Zawodny
On Wed, Mar 06, 2002 at 06:19:53AM +0100, Eberhard Lisse wrote: > Hi, > > I run SuSe 7.2 and have upgraded to the current suse versions of > mysql. > > Server version 3.23.41-Max-log > Protocol version10 > Connection linux.lisse.na via TCP/IP > TCP port

RE: [ANN] Blue World Announces Lasso vs PHP White Paper

2002-03-07 Thread Todd Williamsen
You think Blue World getting the point yet? Maybe they are thinking twice about spamming mailing lists with their products? Maybe a better target is Microsoft's .NET boards since both products are about the same price -Original Message- From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]]

Re: How to turn on Slow Query Log?

2002-03-07 Thread martin . tunggorono
Never mind with that.. I don't know why it was there, it was created automatically the 1st time you run the windows gui admin. And I had to modify it to log-slow-queries=filename and it turned out ok. Thanks anyway. Regards, Martin |-+> | |

RE: [ANN] Blue World Announces Lasso vs PHP White Paper

2002-03-07 Thread John Dean
At 12:30 07/03/2002 -0700, [EMAIL PROTECTED] wrote: >I think this is should be > > Learning Lasso$2500 PHP $2500 This may be true if you have no knowledge of either system, but most people on this list have a great deal of experience using PHP and for them that would be money down t

Re: Blue World

2002-03-07 Thread John Dean
Hi It a Mac and Windows thing At 11:35 07/03/2002 -0800, Dreamtime.net Inc. wrote: >Does it run on Unix? > >S > > > -Original Message- > > From: Cathy Cunningham (Blue World Lasso Evangelist) > > [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, March 07, 2002 10:37 AM > > To: Chuck "PUP" Pa

RE: [ANN] Blue World Announces Lasso vs PHP White Paper

2002-03-07 Thread Jonathan Hilgeman
Ah, the keywords "with commercial add-ons." Notice the plurality, as well. I wonder which add-ons and how many total add-ons were considered in making this cost estimate. I also wonder if most of us would even need more than one commercial add-on at most. - Jonathan -Original Message- Fr

Re: How to turn on Slow Query Log?

2002-03-07 Thread Jeremy Zawodny
On Thu, Mar 07, 2002 at 09:53:51AM -0800, [EMAIL PROTECTED] wrote: > Hi, > > I need help in turning on the slow query log option on the my.ini file. > > I've tried uncommenting it and when I tried to run the nt-max it > says it couldn't recognize the option. Here's what I have for my.ini > file,

[Mysql] Sorry for the reply.

2002-03-07 Thread Chuck \"PUP\" Payne
You know I had wrote but my message was kick by mysql mail list server for spamming, I didn't mean too and I am sorry to everyone on the list. I was trying to express my thought on an e-mail. Again sorry for spamming, all I did was hit reply to all to the Blue World Announces Lasso vs PHP White Pa

insert problems

2002-03-07 Thread Petre Agenbag
Are there any documented reasons why mysql would only enter certain fields and "skip" others? I am having some strange problems where it seems that data are randomly "dropped" from inserts via web forms. Have posted before stating a possible cache or proxy problem, but I am still at a loss...

Re: Can not connect (again)

2002-03-07 Thread Ggelu
Hi, You are "closer".This error is generated only if you wish to connect from the localhost or 127.0.0.1 (i believe).To avoid this inconvenient, in arguments of mysql client,you must "put" -S "path_of_the_mysql.socket".Usualy mysql create the socket file in tmp directory.You can also, made some m

Blue World

2002-03-07 Thread Dreamtime.net Inc.
Does it run on Unix? S > -Original Message- > From: Cathy Cunningham (Blue World Lasso Evangelist) > [mailto:[EMAIL PROTECTED]] > Sent: Thursday, March 07, 2002 10:37 AM > To: Chuck "PUP" Payne; [EMAIL PROTECTED] > Subject: Re: [ANN] Blue World Announces Lasso vs PHP White Paper > > >

RE: [ANN] Blue World Announces Lasso vs PHP White Paper

2002-03-07 Thread Adam
There is a point that if you buy APC-Cache and the encoder you are spending a lot of cache. However there is APC, PHPCache and others that do the job.. but not as well. PHP is mildly flawed in the sense that it is somewhat intentionally crippled so Zend can make a profit from sites that adopt it

RE: [ANN] Blue World Announces Lasso vs PHP White Paper

2002-03-07 Thread massey
I think this is should be Learning Lasso$2500 PHP $2500 Dosent matter if the product is free it still costs you time. > Can you provide a NON-BIAS so-called "TRUE comparison"? I would be > curious on what Blueworld has to say. Also, why do you think the TCO > is lower with lasso t

RE: [ANN] Blue World Announces Lasso vs PHP White Paper

2002-03-07 Thread Todd Williamsen
Can you provide a NON-BIAS so-called "TRUE comparison"? I would be curious on what Blueworld has to say. Also, why do you think the TCO is lower with lasso than PHP? I don't get it, there is no cost to own it, just to develop it. And if you develop with PHP correctly, then the TCO is low. H

  1   2   >