MySQL privileges

2002-03-25 Thread Felik Harmanto
hi, In MySQL, pls tell me which privileges should I grant to every user so they can change their password? thanks Felik __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -

Re: mysqlhotcopy

2002-03-25 Thread Hans Kind
Dear Martin, I tried that option, but it returns a errono 24: ../bin/mysqlhotcopy -u username -p password --flushlog --allowold --regexp='.*' /d1/terminal-a/mysql/ 'mail' is an empty database 'opt' is an empty database 'oveas' is an empty database DBD::mysql::db do failed: Can't find file: './

RE: Trapping for no user input in a query

2002-03-25 Thread Ron Jamison
Tailor your query to the request of your user(s). I.e. if only one parameter was passed from the form only match against one field. E.g.: $sql = "SELECT ID, publication,run_date,left(ad_copy,40) as Advertisement FROM classifieds WHERE MATCH "; if ($param1) $sql .= "(ad_copy) against ('

mysql.server

2002-03-25 Thread mlim
>Description: regarding mysql.server daemon >How-To-Repeat: I can't seem to find the mysql_daemon_user syntax, per your installation direction via the web >Fix: None >Submitter-Id: >Originator:Super-User >Organization: >MySQL support: [none | licence | email support | extended email supp

RE: Impact of Free ORACLE

2002-03-25 Thread Ron Jamison
To answer your question I don't think the fabled price slash of Oracle will have any impact on MySQL or its community. Surely you can understand that since this is a mailing list, any posts of such titillating rumors will get a large response. I'd also like to add that after having used MySQL fo

Trapping for no user input in a query

2002-03-25 Thread Kim Kohen
Hello all I am trying to query two columns in mysql which have fulltext indexes using the following: SELECT ID,publication,run_date,left(ad_copy,40) as Advertisement FROM classifieds WHERE MATCH (long_group) against ('\"$param2\"') AND MATCH (ad_copy) against ('\"$param1\"') As you can probably

how to use checker to debug mysql applications

2002-03-25 Thread Michael Widenius
Hi! > "mysql" == mysql-return-103913-monty mysql writes: mysql> Hi, mysql> is there any way to debug a c-programm that uses the mysql c-api? I want mysql> to use checker for memleak checking but it seems to be impossible to mysql> compile the mysql client libraries using checker. The rea

Re: mysqlimport

2002-03-25 Thread Paul DuBois
At 22:04 -0700 3/25/02, Keith Spiller wrote: >Hello, > >mysqlimport --replace --fields-terminated-by=\| --verbose >--user=user --password=mysql database tables.sql > >I'm trying to use the mysqlimport command. I have multiple tables >listed in my table.sql file. But the command requires that t

mysqlimport

2002-03-25 Thread Keith Spiller
Hello, mysqlimport --replace --fields-terminated-by=\| --verbose --user=user --password=mysql database tables.sql I'm trying to use the mysqlimport command. I have multiple tables listed in my table.sql file. But the command requires that the filesname be the same as the table you try to im

Re: Dropping tables

2002-03-25 Thread Paul DuBois
At 22:20 -0600 3/25/02, Steve Buehler wrote: >Thank you. I am still not an expert yet at MySQL and/or PHP. I >learn something new everyday. At least this list doesn't knock >people down for asking questions that could be found by either a 1 >minute or a 1 month search on the web. I will try

Re: Dropping tables

2002-03-25 Thread Steve Buehler
Thank you. I am still not an expert yet at MySQL and/or PHP. I learn something new everyday. At least this list doesn't knock people down for asking questions that could be found by either a 1 minute or a 1 month search on the web. I will try this out in the morning. I see no reason why y

RE: Impact of Free ORACLE

2002-03-25 Thread MadProfessor
Ok, Ok, KIDZ, I get it. I had just heard from a rather reliable pair of sources that the oracle system was free, so I thought I'd ask you cats if you had any thoughts Now I get endless buillshit sarcasm, instead of the simple 1 or 2 people pointing out that I'm wrong. The rest of you guys who

Re: Which Datatype

2002-03-25 Thread Paul DuBois
At 15:47 -0500 3/23/02, denonymous wrote: >From: "Othmar Stehlik" <[EMAIL PROTECTED]> > >> I´m writing a simple Guestbook in Java, but I´m not quite sure which SQL >> Datatype I should use for the user´s comments. >> VARCHAR is not big enough, > > >Try TEXT or TINYTEXT. TINYTEXT is no longer t

Re: 1 table many fields/several tables less fields?

2002-03-25 Thread Paul DuBois
At 21:34 + 3/25/02, Gath wrote: >Greetings. I would thank some feedback on this issue. The doubt is: >Should i create a table, with about 40-65 fields (ID, 3 or 4 of text, the >reamining of small/tiny int), or should i split it in about 4-6 tables, >dividing the fields between them? >Info: >Th

Re: myisamchk and table corrupt

2002-03-25 Thread Mr. Ozette Brown
Patrick, Try this from your shell: You want to flush the tables (I'm assuming you want to keep the database up and running), do a recover, safe recover, and check to make sure you don't get the error messages when everything is finished. $ mysqladmin flush-tables $ myisamchk -r -o /var/lib/mys

Re: GRANT create/drop for temp tables

2002-03-25 Thread Paul DuBois
At 18:28 -0500 3/25/02, Ray Rodriguez wrote: >This is either a mysql feature request (who would I send it to?) or a >question. I've looked at the documentation and could not find a way to do >this. > >Is there a way to grant create/drop access specifically for temporary >tables? I have a situati

Re: Table created on script Err

2002-03-25 Thread alan4100
Paul, I mean to say that it USED two different databases.. By the way, I could use mysql at the dos prompt. And I could use mysql -u root -p at the dos prompt, too. It looks like I could do almost anything at the c:\ prompt. Thanks again. - Original Message - From: "Paul DuBois" <[EMAIL

Re: Dropping tables

2002-03-25 Thread Paul DuBois
At 16:40 -0600 3/25/02, Steve Buehler wrote: >Is there anyway to drop a group of tables with a wildcard in MySql? >I have tried: >DROP TABLE IF EXISTS division1s* >and >DROP TABLE IF EXISTS division1s(*) >but neither one works. I am hoping that there is a good useable >answer to this. The synt

RE: Dumb Newbie Keyword Search Question

2002-03-25 Thread Paul DuBois
At 15:49 -0500 3/25/02, Tal-ee wrote: >Hi, I saw your discussion and i was wondering if any of you know if there is >a way to stop mySQL from ignoring 3-letter words in the AGAINST statement >when you use the MATCH operator? >Thanks, >-Tal-ee It's in the manual. http://www.mysql.com/doc/F/u/Full

Re: mysql and snort

2002-03-25 Thread ozette
Idan, Check out: http://www.incident.org/snortdb/ Thanks, Ozette Idan Dolev wrote: >Hi, > >I am pretty new guy dealing with mysql database, and I am sorry if this has >being asked before. >Are their any doc explaining how to integrate snort and mysql ? > >Best regards, > >Idan Dolev > > > >

Re: GetLastError in MYSQL

2002-03-25 Thread Paul DuBois
At 23:04 -0300 3/25/02, Edilson Vasconcelos de Melo Junior wrote: >Hi, > >How do i get the last error message while using mysql C API? It's in the manual. http://www.mysql.com/doc/m/y/mysql_error.html http://www.mysql.com/doc/m/y/mysql_errno.html > >Thank u very much, >Dirso > >Edilson Vasconce

GetLastError in MYSQL

2002-03-25 Thread Edilson Vasconcelos de Melo Junior
Hi, How do i get the last error message while using mysql C API? Thank u very much, Dirso Edilson Vasconcelos de Melo Junior www.jrsoftwares.com.br - Portal JR [EMAIL PROTECTED] Fone: (+55)(19)3256-3577 Cel : (+55)(19)9111-5873 -

Re: mysql.pm and the mysql root password

2002-03-25 Thread Brian Reichert
On Mon, Mar 25, 2002 at 06:12:26PM -0800, daniel wrote: > so how do you install mysql.pm once you've got a password on mysql? The DBI module will make use of the DBI_PASS environemnt variable; maybe that'll help: env DBI_PASS=mySQLpass perl -MCPAN -e shell Failing that; edit the 'make test' s

Multiple Search

2002-03-25 Thread delz
Hi All, How do i perform multiple search in mysql. For example I have a database running in a computer shop and I want to search for Monitors specifically purchased from 03/01/2002 to 03/31/2002. Can any one help me? Regards, Delz -

Re: Impact of Free ORACLE

2002-03-25 Thread Jerry Winegarden
On Mon, 25 Mar 2002, MadProfessor wrote: > Just curious what everyone thinks the impact on MySQL will be now that > Oracle is free? Getting the jump on April 1 jokes? Seriously, though. Open source and supportability by a community of users and developers are as important to some as $. > >

RE: Impact of Free ORACLE

2002-03-25 Thread jwubbel
Here is what the MadProfessor needs to do: 1. Contact you local Oracle Marketing Rep. He will set you straight on licensing and pricing. 2. Go read the Oracle9iAS Data Sheet. Notice that they use Apache and throw in couple of their own candy wrappers called "mods". Oracle9iAS does not inclu

Re: Impact of Free ORACLE

2002-03-25 Thread jay downs
I thought it was the starving kids in West Virginia? - Original Message - From: Rutledge, Aaron <[EMAIL PROTECTED]> To: Mysql List (E-mail) <[EMAIL PROTECTED]> Sent: Monday, March 25, 2002 5:59 PM Subject: RE: Impact of Free ORACLE ...uhm...yeah right. I also heard Larry Ellison was go

mysql.pm and the mysql root password

2002-03-25 Thread daniel
for all the perl fanatics out there, this questions for you: i installed mysql on a cobalt-linux box then set up the root password for mysql then ran: perl -MCPAN -e shell and at the cpan prompt: cpan> install Bundle::Mysql the whole thing ran great up to the end where it started failing test

RE: Impact of Free ORACLE

2002-03-25 Thread Charles McGrotty
Being a Oracle Database Admin myself, I have to say that MySQL is far better, it is just as fast when configured right, just as flexiable when the scripting is done right and the real icing on the cake is it is HONESTLY, TRUTHFULLY, TOTALLY FREE! If I could I would make the place where I work swi

Re: Impact of Free ORACLE

2002-03-25 Thread Michael Bacarella
Oh, that. Once you swear that you won't use Oracle to develop weapons of mass destruction, sell solutions to known terrorists, or are not yourself a terrorist, you get to download Oracle for free. Certainly not the source though. -M On Mon, Mar 25, 2002 at 05:29:32PM -0600, MadProfessor wrote:

RE: MySQL Myths Debunked Revision 5

2002-03-25 Thread Land, Christopher
Perhaps, you could add the "Free Oracle database" myth, as well? C:- -Original Message- From: Michael Bacarella [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 3:28 PM To: [EMAIL PROTECTED] Subject: MySQL Myths Debunked Revision 5 A new revision of MySQL Myths Debunked is now a

RE: Impact of Free ORACLE

2002-03-25 Thread Joe Hoffman
I tried to ignore this thread, but the temptation overwelmed me The assumption of 'Free' implies you give up nothing in return for what you receive. While one can certainly run Oracle products without putting out cash (whether you possess a legal license is another issue for Lawyers), what

RE: 3.23.50?

2002-03-25 Thread RBRoa
Im just curious How did u put the MySQL status in your signature? R.B.Roa PhilCom Corporation Tel. No. 858- Mobile No. (63) (919-xxx) -Original Message- From: Jeremy Zawodny [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 5:50 AM

RE: Impact of Free ORACLE

2002-03-25 Thread Francesca Shiekh
At 05:29 PM 3/25/2002 -0600, MadProfessor wrote: >Here's a couple I've dug up: > >http://biz.yahoo.com/prnews/020117/sfth035_1.html >http://www.devx.com/judgingjava/articles/javaone/report2.asp (Flat out >SAYS ORACLE IS FREE!) I took a quick look at this site and I don't see anything that says th

RE: Impact of Free ORACLE

2002-03-25 Thread MadProfessor
Here's a couple I've dug up: http://biz.yahoo.com/prnews/020117/sfth035_1.html http://www.devx.com/judgingjava/articles/javaone/report2.asp (Flat out SAYS ORACLE IS FREE!) And of course, let's not forget http://www.oracle.com (Just go to downloads, register your info and try downloading ANYTHING

Re: MySQL Myths Debunked Revision 5

2002-03-25 Thread Georg Richter
On Tuesday, 26. March 2002 00:28, Michael Bacarella wrote: > A new revision of MySQL Myths Debunked is now available. > > http://m.bacarella.com/projects/mysqlmyths/ > looks nice, and you had a lot of work :) Maybe it could be interesting to integrate a faq in the mysql-manual and implement

GRANT create/drop for temp tables

2002-03-25 Thread Ray Rodriguez
This is either a mysql feature request (who would I send it to?) or a question. I've looked at the documentation and could not find a way to do this. Is there a way to grant create/drop access specifically for temporary tables? I have a situation where I need to use a create temporary..select

RE: Impact of Free ORACLE

2002-03-25 Thread Tim Buchalka
I think you will find that Oracle offers free DEVELOPER copies of at least some of their products. You still need to pay for it to actually use it in a production environment. So nothing has changed! i.e. Oracle is not Free (for production environments). Cheers Tim -Original Message--

MySQL Myths Debunked Revision 5

2002-03-25 Thread Michael Bacarella
A new revision of MySQL Myths Debunked is now available. http://m.bacarella.com/projects/mysqlmyths/ MySQL Myths Debunked was originally my attempt to provide a solid document to help me silence naysayers who would harass my decision to use MySQL instead of the big and stupid alternatives.

Performance indexes with a lot of Null values on MyISAM big tables

2002-03-25 Thread Benoît Grangé
Hello, I work with a MySQL server version 3.23 and MyIsam tables where records are inserted real time, betweek 10 and 50 records per second until the table reaches 10 million records, where one other table is started. I already have a PRIMARY KEY on this table and the current index "size" is aro

hierarchical struture into mysql

2002-03-25 Thread David yahoo
Hi all, I m looking for a tree struture for which can be easilly queried with mysql features. I only know the tree with row having a parent id. Retieving children can only be done with recursive : mysql doesnt do that ? Thanks _ Do You

Re: Impact of Free ORACLE

2002-03-25 Thread Gabriel Ricard
Since when? Even if Oracle was free, it would still take a bit of convincing for me to want to switch from MySQL. Unless of course they decided to port to OSX and release that for free, oh and while they're at it, cut out all the Java garbage that has no business residing in a database. *sigh

RE: Impact of Free ORACLE

2002-03-25 Thread RBRoa
Hahahahah..a million dollar support goes freewhat a news. R.B.Roa PhilCom Corporation Tel. No. 858- Mobile No. (63) (919-xxx) -Original Message- From: MadProfessor [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 26, 2002 6:48 AM T

Re: Impact of Free ORACLE

2002-03-25 Thread Francesca Shiekh
Since when is Oracle free? F. At 04:48 PM 3/25/2002 -0600, MadProfessor wrote: >Just curious what everyone thinks the impact on MySQL will be now that >Oracle is free? > > >- >Before posting, please check: >http://www.mysql.

RE: Impact of Free ORACLE

2002-03-25 Thread Richard Forgo
Did Big Larry go open source? This is news to me. If you have more details, please provide the list a link to share that info. Rik Forgo JIST3 Army Test & Training Investment Conference (ATTIC) Diverse Technologies Corp. (c) 410.852.7420 (h) 410.859.8474 -Original Message- From: MadProf

RE: Impact of Free ORACLE

2002-03-25 Thread Rutledge, Aaron
...uhm...yeah right. I also heard Larry Ellison was going to give all his money away to help starving children in Afghanistan as well. -Original Message- From: MadProfessor [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 3:48 PM To: [EMAIL PROTECTED] Subject: Impact of Free ORA

Re: Impact of Free ORACLE

2002-03-25 Thread Dan Nelson
In the last episode (Mar 25), MadProfessor said: > Just curious what everyone thinks the impact on MySQL will be now > that Oracle is free? And where did you hear this? -- Dan Nelson [EMAIL PROTECTED] - Before

Impact of Free ORACLE

2002-03-25 Thread MadProfessor
Just curious what everyone thinks the impact on MySQL will be now that Oracle is free? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

RE: Thanks to whomever... for the tip on mySQLMan...

2002-03-25 Thread Ron Jamison
I agree; theres no reason to use anything but phpMyAdmin for database maintenance over the web. The guys at phpwizard.net keep adding more and more features which strengthen its position as THE package to use for this application. I wouldn't use anything else. $0.02 -Original Message-

Access break mode error

2002-03-25 Thread Rutledge, Aaron
Occasionally with MyODBC, MySQL and Access I am getting an error when trying to close a window stating 'This action will reset the current code in break mode. Do you want to stop the running code-Yes/No'. It becomes impossible to close the window because it wont allow me to select Yes. The only

Dropping tables

2002-03-25 Thread Steve Buehler
Is there anyway to drop a group of tables with a wildcard in MySql? I have tried: DROP TABLE IF EXISTS division1s* and DROP TABLE IF EXISTS division1s(*) but neither one works. I am hoping that there is a good useable answer to this. Thanks in advance Steve Buehler

Re: Update change values in wrong column

2002-03-25 Thread Jeff Kilbride
Actually, the column you're referring to is a TIMESTAMP. As the manual states, the first TIMESTAMP field in any table is automatically updated whenever a change occurs. If you don't want this value to change, you should use a DATETIME field instead. However, keep in mind that you'll have to change

Re: Update change values in wrong column

2002-03-25 Thread Shawn McCool
You need a where clause at the end to tell it which row to update. [EMAIL PROTECTED] wrote: >. mysqladmin version >mysqladmin Ver 8.21 Distrib 3.23.42, for apple-darwin1.4 on powerpc >Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB >This software comes with ABSOLUTELY NO WAR

Update change values in wrong column

2002-03-25 Thread sive
• mysqladmin version mysqladmin Ver 8.21 Distrib 3.23.42, for apple-darwin1.4 on powerpc Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL lice

RE: 1 table many fields/several tables less fields?

2002-03-25 Thread Land, Christopher
Here are the 5 Rules of Data Normalization -- http://www.datamodel.org/NormalizationRules.html Eliminate Repeating Groups - Make a separate table for each set of related attributes, and give each table a primary key. Eliminate Redundant Data - If an attribute depends on only p

Re: MySQL replication

2002-03-25 Thread Shawn McCool
Check in the slave's master.info file In the first line you'll see a filename for the master's binary log an in the second line you'll see the position. Look at the file on the master server and compare the byte -size to the position. I wrote a little perl script/netsaint plugin that takes care

Re: Auto_increment and TimeStamp Fields

2002-03-25 Thread Eric Baines
I failed mention that I am using the ODBC driver to access this database. Everything works great using the Unix client but not the ODBC driver. It seems to have something to do with using DAO. I tried RDO and the last_insert_id() is now working. Can anybody confirm this?

Re: 3.23.50?

2002-03-25 Thread Jeremy Zawodny
On Mon, Mar 25, 2002 at 02:56:58PM -0600, Michael Bacarella wrote: > 3.23.50 is referenced in the documentation but not available for > download. Should it be there? Not yet. :-) > Don't mean to nag, but I'm itching for that autoextend feature. Based on previous posts, it'll be there in a week

1 table many fields/several tables less fields?

2002-03-25 Thread Gath
Greetings. I would thank some feedback on this issue. The doubt is: Should i create a table, with about 40-65 fields (ID, 3 or 4 of text, the reamining of small/tiny int), or should i split it in about 4-6 tables, dividing the fields between them? Info: The database would be read/write by PHP, and

RE: Strange query issues

2002-03-25 Thread Salada, Duncan
Are the first three machines closing their connections correctly? Duncan -- Duncan Salada | Titan | www.titan.com/testeval Email: [EMAIL PROTECTED] | Voice: 301-925-3222x375 | Fax: 301-925-3216 > -Original Message- > From: Gabriel [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 25, 2002

3.23.50?

2002-03-25 Thread Michael Bacarella
3.23.50 is referenced in the documentation but not available for download. Should it be there? Don't mean to nag, but I'm itching for that autoextend feature. PS. mysql,query,table -- Michael Bacarella | Netgraft Corporation | 545 Eighth Ave #401 Systems Analysis | New Y

RE: Dumb Newbie Keyword Search Question

2002-03-25 Thread Tal-ee
Hi, I saw your discussion and i was wondering if any of you know if there is a way to stop mySQL from ignoring 3-letter words in the AGAINST statement when you use the MATCH operator? Thanks, -Tal-ee -Original Message- From: Dan Tappin [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25,

RE: Thanks to whomever... for the tip on mySQLMan...

2002-03-25 Thread Matthew Walker
I just went in looked at mySQLMan, and I must say, I'm not very impressed with it. If you like that package, you should really try out phpMyAdmin. You can download it at http://phpmyadmin.sourceforge.net. It's completely free, quite secure, and very easy to use. Matthew Walker Ecommerce Project M

RE: MySQL not using an index

2002-03-25 Thread Michael C. Neel
This seems to be something, running it with a where domain="somedomain.com" will use the domain index. Well, I'll bring out the gimp... Full query: SELECT *, access_log.domain as host_domain, access_log.server as server, DATE_FORMAT(MIN(date),'%M %e, %Y %r') as disp_date, access_log.username as

MySQL replication

2002-03-25 Thread Patrick Ouellet
Ok I have a MySQL server. And I have another MySQL server which is the replication of the other DB server. What I want to know is: Is there a way to know if the replication server has finished replicating the master server. I think my DB has been corupted. ( A process on another machine wrote

Re: MySQL not using an index

2002-03-25 Thread Christopher Thompson
What percentage of your database contains rows where status = 200? It looks to me like MySQL is estimating that perhaps 1/3 or more of the rows have that status and therefore, it is faster to simply do a table scan rather than using an index. On Monday 25 March 2002 1:08 pm, Michael C. Neel w

MySQL not using an index

2002-03-25 Thread Michael C. Neel
I'm nearing the end of my rope trying to figure this one out. I have some queries run against a table that is a log of hits from a web server. No matter how simple I've tried to make my query, MySQL sill does not choose an index. Even use index has no effect. My table: CREATE TABLE access_log

Strange query issues

2002-03-25 Thread Gabriel
Hello all. For my first post to the list, I have a very strange problem. (And yes, I have perused the archives. I haven't found anything similar.) Here's the situation: I've got 6 machines that that make requests to a 7th machine, which is running mysql-3.23.47. All the machines are FreeB

Re: Auto_increment and TimeStamp Fields

2002-03-25 Thread Paul DuBois
At 14:54 -0500 3/25/02, Eric Baines wrote: >I have created a table with a Primary Key that is an auto_incrementing >field. I was able to receive the auto_increment values by issuing a >last_insert_id(). When I added a timestamp to this table, the >last_insert_id() no longer returned any value ex

Auto_increment and TimeStamp Fields

2002-03-25 Thread Eric Baines
I have created a table with a Primary Key that is an auto_incrementing field. I was able to receive the auto_increment values by issuing a last_insert_id(). When I added a timestamp to this table, the last_insert_id() no longer returned any value except 0. Is there a MySQL rule that you can not

RE: Problem loading PC DB into Solaris

2002-03-25 Thread Paul DuBois
At 14:34 -0500 3/25/02, Alexander, Chris wrote: >Ack > >Case sensitivity of table names gets screwed up when doing stuff with >PHP/MySQL on Windows!! (Windows 95 in this case - yes, more >paleo-computing!). > >I am using this set of canned scripts: phpslice v 0.2.0. The scripts have >been inst

AIX - Dependent module libmysqlclient.a could not be loaded

2002-03-25 Thread Joe Hoffman
Due to problems with the Binary release for AIX (Dependent module libz.a count not be found), I decided to compile our own from source. The resulting mysql works fine for the AIX machine where it was compiled, but does not run on SOME other AIX machines. The error reported is: "Dependent module

RE: Problem loading PC DB into Solaris

2002-03-25 Thread Alexander, Chris
Ack Case sensitivity of table names gets screwed up when doing stuff with PHP/MySQL on Windows!! (Windows 95 in this case - yes, more paleo-computing!). I am using this set of canned scripts: phpslice v 0.2.0. The scripts have been installed successfully in multiple places on UNIX, been usi

Re: InnoDB books

2002-03-25 Thread Heikki Tuuri
Sean, since InnoDB development progresses rapidly, no book except the InnoDB online manual is fully up-to-date. The page http://www.innodb.com/books.html contains a link to Michael Kofler's MySQL book which treats InnoDB and BDB in appendixes. There is also a link to a recent Terra Lycos Webmonk

Re: problems deleting a user from "user" db

2002-03-25 Thread Lance Uyehara
> I got problems deleting a user which I've created before. > > mysql> delete from user where user=wus; > ERROR 1054: Unknown column 'wus' in 'where clause' > mysql> How about quoting a string type: delete from user where user='wus'; -Lance --

Re: problems deleting a user from "user" db

2002-03-25 Thread denonymous
From: "Manuel Hendel" <[EMAIL PROTECTED]> > I got problems deleting a user which I've created before. > > mysql> delete from user where user=wus; > ERROR 1054: Unknown column 'wus' in 'where clause' > mysql> > > Can anyone provide some help? Try this: delete from user where user='wus'; --

Re: problems deleting a user from "user" db

2002-03-25 Thread Paul DuBois
At 19:23 +0100 3/25/02, Manuel Hendel wrote: >I got problems deleting a user which I've created before. > >mysql> delete from user where user=wus; >ERROR 1054: Unknown column 'wus' in 'where clause' >mysql> > >Can anyone provide some help? wus is a string. Surround it in quotes. >Thanks, >

Re: MS Access MyODBC MySQL and #DELETED

2002-03-25 Thread Chris Hedemark
No help, just a "me too". If you respond with something helpful to this, please either post it to the list or copy me on it because I'm fed up with MS Access / myODBC / MySQL combo as well (not necessarily the individual components, just the combination). --

Repost: mysql 3.23.26 + freebsd 4.4 stable cpu pinned

2002-03-25 Thread Lance Uyehara
I didn't receive any response so thought I'd repost with some more questions. Is my problem so rare no one knew what to say? or Is there some obvious solution here and everyone thought *someone else* would straighten me out? Any pointers and help is appreciated. Thanks, Lance > Does anyone have

RE: problems deleting a user from "user" db

2002-03-25 Thread Rick Emery
delete from user where user="wus"; -Original Message- From: Manuel Hendel [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 12:24 PM To: MYSQL List Subject: problems deleting a user from "user" db I got problems deleting a user which I've created before. mysql> delete from user

RE: mysql/php on Win2000

2002-03-25 Thread Andrew Hazen
Hi, if you think that IIS and Apache are going to have problems co-habitating then, yes, please tell me which services to kill. On the other hand, I'm not using IIS for anything else, maybe I should try to uninstall it before installing Apache??? Thanks. Andrew Hazen Spam filter: mysql -Or

Re: Problem loading PC DB into Solaris

2002-03-25 Thread Scott Helms
Chris, That is very weird, and I don't have any real help :-( but there are a couple of things I will suggest: 1. Run mysiamchk (assuming these are MyISAM tables) from the Solaris box and retry, its "possible" that there is a character in your data that the Windows box is allowing, but Sola

RE: mysql/php on Win2000

2002-03-25 Thread Todd Williamsen
IIS Services to kill: IIS Admin FTP Publishing Service World Wide Wb Publishing Service If my memory serves me right, if you stop the IIS admin service the rest will stop as well. But remember to disable them by going into Start | Admin Tools | Services And right click on them chose Propertie

problems deleting a user from "user" db

2002-03-25 Thread Manuel Hendel
I got problems deleting a user which I've created before. mysql> delete from user where user=wus; ERROR 1054: Unknown column 'wus' in 'where clause' mysql> Can anyone provide some help? Thanks, Manuel -- 667: The neighbor of the beast. ---

MS Access MyODBC MySQL and #DELETED

2002-03-25 Thread Alexander Shaw
Hello everyone, This is starting to drive me mad now and I can't find a way round. I have installed the service pack and updates suggested in the manual, am running MyODBC 3.51 and MySQL 3.23.46 have added timestamp fields and enabled return matching rows. But still when I add a new record an try

Thanks to whomever... for the tip on mySQLMan...

2002-03-25 Thread Andrew Lietzow
Helo list, I don't recall if it was here that I heard of this mySQLMan package. I think so. http://www.gossamer-threads.com/scripts/mysqlman/index.htm has quickly saved me lots of hair, and will soon enable me to go live with mySQL... My use and interest in mySQL has just taken a quantum leap fo

RE: mysql/php on Win2000

2002-03-25 Thread Todd Williamsen
I have found Win2k completely stable with Apache/PHP/mySQL. Not one issue! If you are talking IIS combo, then yes issues will arise. I don't see any performance hit on this setup as a CGI. I think you are being a bit bias towards Windoze. Windows 2k is quite stable. The thing about win2k is

RE: mysql/php on Win2000

2002-03-25 Thread Todd Williamsen
IIS: Kill the services, and disable them If you need to know which ones let me know. Oracle8i: No, they use different ports. I run Oracle8, mySQL, SQL Server7 without any problems -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 10:24

Re: building latest mysql on mac os x

2002-03-25 Thread Paul DuBois
At 12:01 -0500 3/25/02, Gabriel Ricard wrote: >I've been watching the mysql.com downloads page for a while and it >doesn't seem like there's a build of 3.23.49 coming soon. The manual >on mysql.com talks about a 3.23.50, is that the latest source >distribution? What is 3.23.49a, which is listed

RE: mysql/php on Win2000

2002-03-25 Thread Alexander, Chris
As far as OS's are concerned, I'm an equal opportunity bigot, I hate them all. :) Using these tools on your home PC running some flavour of Windows will work fine. That's the way I work, devel on the WinXP box, ftp the files/changes to my Linux web server. Everything seems to work - excepting th

Re: Table created on script Err

2002-03-25 Thread Paul DuBois
At 12:35 -0500 3/25/02, alan4100 wrote: >Paul, > >You are right. :) > >USE alan03 works. >USE db_alan03 works. > >But it created two separate databases. They are not the same. But both >works just the same. That doesn't make any sense. USE doesn't create anything. > > > >- Original Messag

Re: Table created on script Err

2002-03-25 Thread alan4100
Paul, You are right. :) USE alan03 works. USE db_alan03 works. But it created two separate databases. They are not the same. But both works just the same. - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "alan4100" <[EMAIL PROTECTED]>; "Gerald Clark" <[EMAIL PROTECTE

fulltext server as replication client?

2002-03-25 Thread Brian Bray
Here is a though: I know that replication requires identical table definitions, but does that also include identical indexes? So, could I setup a master database without a fulltext index on a particularly large table I have and then setup a slave server with the fulltext index and then do all th

Re: mysql/php on Win2000

2002-03-25 Thread Curtis Maurand
The only problem with Win2K is that a lot of the components for PHP aren't there. Also PHP will run as an ISAPI module, but its not recommended. The preferred method is as a CGI (read 25% performance hit). Win2K doesn't multi-task/multi-thread as well as either of the *nix's mentioned and its

Re: mysql and snort

2002-03-25 Thread Curtis Maurand
what is snort? Curtis Idan Dolev said: > Hi, > > I am pretty new guy dealing with mysql database, and I am sorry if this > has being asked before. > Are their any doc explaining how to integrate snort and mysql ? > > Best regards, > > Idan Dolev > > > > -

RE: Problem loading PC DB into Solaris

2002-03-25 Thread Alexander, Chris
| | Can you access the Solaris DB from your Windows box? | | mysql -u -h -p | Yep. | Also, what is the error your getting exactly? Are you | running the web | server on the Solaris box as well? If so drop this into | the document root: | | | and call it so

Re: MySQL running on a MacOSX webserver - issues?

2002-03-25 Thread Gabriel Ricard
We've been using MySQL 3.23 in OSX on our production servers for about 6 months now. The system was in development for over a year prior to that. We have a legacy application in RealBASIC (it's not my fault!) that uses ODBC to issue numerous REPLACE queries to the database on an hourly basis t

building latest mysql on mac os x

2002-03-25 Thread Gabriel Ricard
I've been watching the mysql.com downloads page for a while and it doesn't seem like there's a build of 3.23.49 coming soon. The manual on mysql.com talks about a 3.23.50, is that the latest source distribution? What is 3.23.49a, which is listed for the downloads? I'd like to get a build of 3.

Re: Problem loading PC DB into Solaris

2002-03-25 Thread Scott Helms
Chris, Can you access the Solaris DB from your Windows box? mysql -u -h -p Also, what is the error your getting exactly? Are you running the web server on the Solaris box as well? If so drop this into the document root: and call it something original like info.php, and call it from a

Re: InnoDB books

2002-03-25 Thread Gabriel Ricard
Core MySQL ISBN: 0130661902 http://shop.barnesandnoble.com/booksearch/isbnInquiry.asp?isbn=0130661902 [EMAIL PROTECTED] wrote: > >-Original Message- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] >Sent: 25 March 2002 07:59 >To: Sean O'Donnell >Subject: Re: InnoDB books > > >Your me

  1   2   >