MySQL privileges
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/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqlhotcopy
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: './alternat/nuke_bannerfinish.frm' (errno: 24) at ../bin/mysqlhotcopy line 434. It creates the directories, but doesn't backup any of the tables. In the archives I found similar reports, but it was mentioned the problem was fixed!. Not sure how this errono 24 (Error code 24: Too many open files) relates to this problem. rgds Hans At 09:19 25-3-2002 +, you wrote: >On Sat, 2002-03-23 at 15:19, Hans Kind wrote: > > Hi, > > > > What is the correct syntax to use to backup all databases in the > > /usr/local/mysql/var directory. > > > > We tried a number of different options, but at best we get only 1 > database, > > backup completely. Using a wildcard, *, only creates the directory, but > > doesn't copy the tables. > > >[snip] > >Hi, > >mysqlhotcopy has a regexp argument which makes it backup all databases >matching the regexp. The regexp uses perl regexp syntax, not shell >wildcards: > >So: > > mysqlhotcopy --regexp='.*' > >backs up all databases, whereas: > > mysqlhotcopy --regexp='*' > >isn't a correct regexp. > >regards, >Martin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Trapping for no user input in a query
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 ('$param1')"; if ($param1 && $param2) $sql .= " AND MATCH "; if ($param2) $sql .= "(long_group) against ('$param2')"; /* query */ -Original Message- From: Kim Kohen [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 10:47 PM To: <[EMAIL PROTECTED]> Subject: Trapping for no user input in a query 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 guess, the $params are coming from a form via php. The above query works fine when the user submits both parameters but I can't work out how to trap for the user only entering a single parameter (which causes the query to always return an empty set)? Cheers and thanks kim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql.server
>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 support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class: >Release: mysql-3.23.49 (Source distribution) >Server: ./mysqladmin Ver 8.23 Distrib 3.23.49, for sun-solaris2.8 on sparc 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 license Server version 3.23.49 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 12 min 35 sec Threads: 1 Questions: 4 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.005 >Environment: System: SunOS vega.blastos.com 5.8 Generic_108528-11 sun4u sparc SUNW,UltraAX-i2 Architecture: sun4 Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/ucb/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='-R/usr/local/lib' LIBC: -rw-r--r-- 1 root bin 1760276 Jul 27 2001 /lib/libc.a lrwxrwxrwx 1 root root 11 Mar 21 17:41 /lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 root bin 1136744 Jul 27 2001 /lib/libc.so.1 -rw-r--r-- 1 root bin 1760276 Jul 27 2001 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Mar 21 17:41 /usr/lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 root bin 1136744 Jul 27 2001 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Impact of Free ORACLE
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 for two years and corresponding with the very helpful people behind MySQL AB, I'd be hard pressed to find a better, more stable database with the wonderful support that comes from the whole community. Oracle will continue to be slowly abandoned as the decision makers choose open source and low (no) cost over proprietary and stupendous costs. Larry has enough cash to hold him over for the rest of his life, but even so I'm sure he could get his hands in the mix with the soon to be developing third world corporations who will need ways to manage their livestock. I for one will be glad to see those inflated price tags go. THBBTHT! -Original Message- From: MadProfessor [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 8:11 PM To: [EMAIL PROTECTED]; 'Charles McGrotty' Cc: [EMAIL PROTECTED] Subject: RE: Impact of Free ORACLE 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 thought you were being original by giving me shit as if we were on slashdot need to realize there's no call for all that. I was trying to find out more about how everyone felt. I still run MySQL on my servers, and while I was interested in how Oracle works, I wasn't about to switch, so don't feel like you need to be questioning my geekiness, nor my interest in free software or open source. End fucking rant, have a nice day. VJ MadProfessor - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Trapping for no user input in a query
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 guess, the $params are coming from a form via php. The above query works fine when the user submits both parameters but I can't work out how to trap for the user only entering a single parameter (which causes the query to always return an empty set)? Cheers and thanks kim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to use checker to debug mysql applications
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 reason seems to be mysql> some assembly language parts. All other libraries I need compile. mysql> Did anybody hack up some stubs to use checker for mysql applications? mysql> Best regards, mysql> Carsten Hammer If you compile a debug version of the MySQL client library, you get the following features: - An internal memleak checker for MySQL client allocations - The DBUG package, which enables you to check most function calls and arguments to the MySQL library + more. You can find more information about the above in the manual section 'Debugging a MySQL client' In theory MySQL should work perfectly with any memleak package. (It works at least with purify). If you have problems, please write a full bug report about your compile problems to [EMAIL PROTECTED] and we will try to help you with this. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqlimport
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 the >filesname be the same as the table you try to import. Is there >anyway to import all of the tables at once? How would it know which data line goes in which table? > > >Keith - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlimport
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 import. Is there anyway to import all of the tables at once? Keith - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Dropping tables
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 this out in the >morning. I see no reason why your suggestion would not work. So I >will thank you before I even try it. :) If you're using PHP, you should be able to use a function like this: function delete_tables_with_pattern ($conn_id, $pat) { $query = "SHOW TABLES LIKE '$pat'"; $result_id = mysql_query ($query, $conn_id); if ($result_id) { $table = array (); while (list ($name) = mysql_fetch_row ($result_id)) $table[] = $name; mysql_free_result ($result_id); if (count ($table) > 0) # some tables were named { $query = "DROP TABLES " . join (",", $table); mysql_query ($query, $conn_id); } } } Call it like this: delete_tables_with_pattern ($conn_id, "division1s%"); However, before actually using it as shown above, you probably want to replace the second mysql_query() with a print statement. :-) > >Thanks >Steve > >At 09:58 PM 3/25/2002, you wrote: >>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 syntax described in the manual shows what what you want to do is not >>supported. You can't do it directly in SQL. >> >>But depending on the context in which you're issuing the statement, >>you can achieve the objective by other means. For example, if you're >>using some kind of API, you can use SHOW TABLES LIKE 'division1s%', >>then use the resulting list of tables to construct a DROP TABLES >>statement that drops the tables. >> >>> >>>Thanks in advance >>>Steve Buehler - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Dropping tables
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 your suggestion would not work. So I will thank you before I even try it. :) Thanks Steve At 09:58 PM 3/25/2002, you wrote: >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 syntax described in the manual shows what what you want to do is not >supported. You can't do it directly in SQL. > >But depending on the context in which you're issuing the statement, >you can achieve the objective by other means. For example, if you're >using some kind of API, you can use SHOW TABLES LIKE 'division1s%', >then use the resulting list of tables to construct a DROP TABLES >statement that drops the tables. > >> >>Thanks in advance >>Steve Buehler - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Impact of Free ORACLE
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 thought you were being original by giving me shit as if we were on slashdot need to realize there's no call for all that. I was trying to find out more about how everyone felt. I still run MySQL on my servers, and while I was interested in how Oracle works, I wasn't about to switch, so don't feel like you need to be questioning my geekiness, nor my interest in free software or open source. End fucking rant, have a nice day. VJ MadProfessor - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Which Datatype
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 than VARCHAR(255). One of the larger TEXT types would be better. > >However, you may want to have a check in place before it goes into the >database to trim it down to a reasonable size in the event some joker >decides to paste a few thousand lines of text into the comments. Or pasting in a core dump image, to see if your script is capable of handling input with unusual characters. Yes, it happens. > > > >-- >denonymous >www.coldcircuit.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 1 table many fields/several tables less fields?
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: >The database would be read/write by PHP, and it would have around 1500-2500 >users (distributed by the day), with about 150 queries each user. In each >query, around 10-20 fields values would be needed. The queries would mainly >be SELECT and UPDATE... > >I did read the optimisation part in the manual, particularly: > >"It's not normally useful to split a table into different tables just >because the rows gets 'big'." >>From http://www.mysql.com/doc/T/i/Tips.html , "Other Optimisation Tips". > >http://www.mysql.com/doc/C/r/Creating_many_tables.html, "Drawbacks to >Creating Large Numbers of Tables in the Same Database" > >but still didnt got an straight answer for my precise case. What was wrong with the information in those sections? That is, what's special about your case that makes them inapplicable? > Unfortunally i'm >new at this (both MySQL and PHP), so i apolozige for any mistake/stupidity >presented in the question... :) > >I will, in lack of contrary info, use 1 table with many fields... > > >Thank you for any comments. > >Gath - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: myisamchk and table corrupt
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/mysql/*/*.MYI $ myisamchk --fast --silent /var/lib/mysql/*/*.MYI If that still doesn't work, then shutdown your database, just try: $ mysqladmin shutdown $ myisamchk -r -o /var/lib/mysql/*/*.MYI $ myisamchk --fast --silent /var/lib/mysql/*/*.MYI Then start the database again. This should work. If this does actually work, then you should consider doing a database dump then rebuilding your database from the dump. Thanks, ozette Patrick Hsieh wrote: >Hello list, > >There's an corruption in my mysql table. >I tried to use myisamchk -o to recovery, but still exists when I use >myisamchk -s. > >What is the possible reason of the problem? > >linux95:/var/lib/mysql# myisamchk -s stocks/TimelyDeals.MYI >myisamchk: ISAM file stocks/TimelyDeals.MYI >myisamchk: error: Size of datafile is: 5947722 Should be: 6016194 >myisamchk: error: Keyblock size at page 284672 is not correct. Block length: 1022 >key length: 2 >MyISAM-table 'stocks/TimelyDeals.MYI' is corrupted >Fix it using switch "-r" or "-o" >linux95:/var/lib/mysql# > -- ___ Email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: GRANT create/drop for temp tables
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 situation where I need to use a create temporary..select >statement and later use a select statement to get some data, and later >drop the temporary table. I would like to do this without giving create >and especially drop access to the regular non-temporary tables in the >database. You could set up another database that's used only for temporary tables and create the tables there. > >Thanks, >Ray Rodriguez - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Table created on script Err
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 PROTECTED]> To: "alan4100" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, March 25, 2002 12:56 PM Subject: Re: Table created on script Err > 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 Message - > >From: "Paul DuBois" <[EMAIL PROTECTED]> > >To: "alan4100" <[EMAIL PROTECTED]>; "Gerald Clark" > ><[EMAIL PROTECTED]> > >Cc: <[EMAIL PROTECTED]> > >Sent: Monday, March 25, 2002 10:56 AM > >Subject: Re: Table created on script Err > > > > > >> At 10:40 -0500 3/25/02, alan4100 wrote: > >> >mysql > >> > > >> >Gerald, > >> > > >> >I will try that; Paul had suggested USE db_name. ..I will try both > >ways..USE > >> >db2 and USE db_xxx .. Will keep you both posted. > >> > >> Gerald's suggestion and mine are the *same*: The "USE" keyword followed by > >> the name of the database you want to use. > >> > >> > > >> >- Original Message - > >> >From: "Gerald Clark" <[EMAIL PROTECTED]> > >> >To: "alan4100" <[EMAIL PROTECTED]> > >> >Cc: <[EMAIL PROTECTED]> > >> >Sent: Monday, March 25, 2002 9:37 AM > >> >Subject: Re: Table created on script Err > >> > > >> > > >> >> USE db2; > >> >> > >> >> alan4100 wrote: > >> >> > >> >> >mysql > >> >> > > >> >> >Paul, > >> >> > > >> >> >I was afraid to hear that. It had said about line 2 in the error > >message. > >> >> >This line #2 looks normal. > >> >> > > >> >> >May I ask you to check this script below, but I am afraid it may be > >> >> >annoying. I will eventually put this on posting. Remember I use > >Windows > >> >XP. > >> >> > > >> >> >I would like to know if there is such an mysql "reader" to check > >syntax > >> >> >before I run the script. I am using MySQL by Sams in 21 days. > >> >> > > >> >> >Alan > >> >> > > >> >> > > >> >> > > >> >> >== > >> >> > > >> >> >CREATE db db2; > >> >> >USE db db2; > >> >> >CREATE TABLE Customers (Customer_ID INT NOT NULL > >> >> >PRIMARY KEY AUTO_INCREMENT, First_Name VARCHAR(20) > >> >> >NOT NULL,Last_Name VARCHAR(30) NOT NULL, > >> >> >Address VARCHAR(50), City VARCHAR(20), > >> >> >State VARCHAR(2), Zip VARCHAR(20), > >> >> >E_Mail VARCHAR(20), Age INT, Race VARCHAR(20), > >> >> >Gender ENUM('M','F') DEFAULT 'F', > >> >> >Eye_Color VARCHAR(10), Hair_Color VARCHAR(10), > >> >> >Favorite_Activity ENUM('Programming', 'Eating', > >> >> >'Biking', 'Running', 'None') DEFAULT 'None', > >> >> >Favorite_Movie VARCHAR(50), Occupation VARCHAR(30), > >> >> >Smoker Char(0)); > > > > > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Dropping tables
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 syntax described in the manual shows what what you want to do is not supported. You can't do it directly in SQL. But depending on the context in which you're issuing the statement, you can achieve the objective by other means. For example, if you're using some kind of API, you can use SHOW TABLES LIKE 'division1s%', then use the resulting list of tables to construct a DROP TABLES statement that drops the tables. > >Thanks in advance >Steve Buehler - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Dumb Newbie Keyword Search Question
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/Fulltext_Fine-tuning.html > > > > >-Original Message- >From: Dan Tappin [mailto:[EMAIL PROTECTED]] >Sent: Monday, March 25, 2002 10:03 AM >To: [EMAIL PROTECTED] >Cc: [EMAIL PROTECTED] >Subject: Re: Dumb Newbie Keyword Search Question > > >Thanks Alec, > >That is exactly what I was looking for. > >Dan > >> I think what you want is a FULLTEXT index with the MATCH operator - see > > http://www.mysql.com/doc/F/u/Fulltext_Search.html . >> >> Particularl.y, see the new developments in fulltext in V4.0.1 half way >doen >> the page >> > >Alec Cawley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql and snort
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 > > > >- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: GetLastError in MYSQL
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 Vasconcelos de Melo Junior >www.jrsoftwares.com.br - Portal JR >[EMAIL PROTECTED] >Fone: (+55)(19)3256-3577 >Cel : (+55)(19)9111-5873 > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
GetLastError in MYSQL
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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql.pm and the mysql root password
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' script. Good luck... > _ > daniel a. g. quinn > starving programmer > > war does not determine who is right -- only who is left. > - bertrand russell -- Brian 'you Bastard' Reichert<[EMAIL PROTECTED]> 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Multiple Search
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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Impact of Free ORACLE
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 $. > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > -- *** Jerry WinegardenOIT/Technical Support Duke University [EMAIL PROTECTED]http://www-jerry.oit.duke.edu *** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Impact of Free ORACLE
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 include the Oracle Database. And oh yes, Wireless & Personalization enablement is not included. That is extra! I think the CD ROM is free! Tongue in cheek. John Wubbel John Wubbel Consulting > 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 switch over, I am a great > lover of Open Source, forget ASP, IIS, and all the other Micro$oft > gimmics that are opperable on one platform, these are just cheap stunt > marketing tools. Granted Oracle is available on multiple platforms. But > take it from me, once you have had a serious look at Oracle and you find > you have to set memory allocation after memory allocation for every > little piece of the DB, you soon lose the desire to set up additional > databases. > > As I said, I do this for a living, and if the MySQL market was as big > (moneywise) I would leave the Oracle realm in a heart beat. > > Besides, I recently read an article on a benchmark test of several of > the top leading databases conducted by Zif Davis, you know that large > computer magazine corp, those guys do not bow down to M$, Oracle or any > of the other big names, they report the facts as they find them, > regardless of the name. > > Read more about this here: > http://www.eweek.com/article/0,3658,s=708&a=23115,00.asp > > So to be honest, I (again let me point out that I KNOW what I am talking > about) see little or NO danger for MySQL v's Oracle, and as I just read > in a email sent to this list, Oracle chances is pricing repeatedly one > moment it was per seat, then it was per processing power of the system > and the story goes on. > > Oracle is NOT, nor will it be FREE any time soon, and I am talking > YEARS! > > Regards, > > > - > > Charles McGrotty > Intelliweb Technologies, > > You know you want IT? > Visit Intelliweb Technologies for > all your hosting requirements. > > http://www.intelliwebtech.com > > > > > -Original Message- > From: Francesca Shiekh [mailto:[EMAIL PROTECTED]] > Sent: 25 March 2002 18:56 > To: MadProfessor; 'Richard Forgo'; [EMAIL PROTECTED] > Subject: RE: Impact of Free ORACLE > > > 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 the > database is free... > I can find Oracle 9iAS downloadable for free... that's the Application > Server, you then need the Database to go with it... > > Moreover, I wouldn't trust using it for production... Oracle has a > history > of changing the pricing on people and claiming that you have to pay more > > money if you want to continue using their product because the licensing > changed... > > They may give it to you free this year, next year you'll find yourself > with > a large bill! > > Just read these: > http://www.idg.net.nz/pressroom.nsf/UNID/8DCAE02D7BD89FD6CC256B8100822FB > 0!opendocument > http://www.newsbytes.com/news/02/175426.html > http://www.crmdaily.com/perl/story/16852.html > http://news.com.com/2100-1001-864135.html > > There are many more... > > I think MySql is here to stay even if Larry should decide to give it all > > away for free... database, applications etc. There are always the > consulting and support fees, and anyone who worked with Oracle Apps > knows > you can't do a damn thing without support! ..And if you want to take > less > than 5 years to implement the system you better have consultants on > board > and a staff of 2 people per module in house! > > $0.02 as someone else put it... > > Francesca > > > >And of course, let's not forget > >http://www.oracle.com (Just go to downloads, register your info and try > > >downloading ANYTHING) > > > > > >I PROMISE YOU, oh non believers, that you'll believe me after you read > >those articles, and then try downloading 9i from Oracle. You don't even > > >have to download it, just start it and watch it go! Cheers, > >VJ MPZ > >-Original Message- > >From: Richard Forgo [mailto:[EMAIL PROTECTED]] > >Sent: Monday, March 25, 2002 5:02 PM > >To: 'MadProfessor'; [EMAIL PROTECTED] > >Subject: RE: Impact of Free ORACLE > > > > > >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 > >
Re: Impact of Free ORACLE
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 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 ORACLE 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 request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql.pm and the mysql root password
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 tests due to the fact that the tests were trying to run mysql as root ...withOUT a password. so how do you install mysql.pm once you've got a password on mysql? do i have to remove the password? (how do i do that?) or do i have to install from source? (doable, but i'd rather go the cpan shell route if i can) are there any other choices? thanks for the help list :) _ daniel a. g. quinn starving programmer war does not determine who is right -- only who is left. - bertrand russell - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Impact of Free ORACLE
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 switch over, I am a great lover of Open Source, forget ASP, IIS, and all the other Micro$oft gimmics that are opperable on one platform, these are just cheap stunt marketing tools. Granted Oracle is available on multiple platforms. But take it from me, once you have had a serious look at Oracle and you find you have to set memory allocation after memory allocation for every little piece of the DB, you soon lose the desire to set up additional databases. As I said, I do this for a living, and if the MySQL market was as big (moneywise) I would leave the Oracle realm in a heart beat. Besides, I recently read an article on a benchmark test of several of the top leading databases conducted by Zif Davis, you know that large computer magazine corp, those guys do not bow down to M$, Oracle or any of the other big names, they report the facts as they find them, regardless of the name. Read more about this here: http://www.eweek.com/article/0,3658,s=708&a=23115,00.asp So to be honest, I (again let me point out that I KNOW what I am talking about) see little or NO danger for MySQL v's Oracle, and as I just read in a email sent to this list, Oracle chances is pricing repeatedly one moment it was per seat, then it was per processing power of the system and the story goes on. Oracle is NOT, nor will it be FREE any time soon, and I am talking YEARS! Regards, - Charles McGrotty Intelliweb Technologies, You know you want IT? Visit Intelliweb Technologies for all your hosting requirements. http://www.intelliwebtech.com -Original Message- From: Francesca Shiekh [mailto:[EMAIL PROTECTED]] Sent: 25 March 2002 18:56 To: MadProfessor; 'Richard Forgo'; [EMAIL PROTECTED] Subject: RE: Impact of Free ORACLE 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 the database is free... I can find Oracle 9iAS downloadable for free... that's the Application Server, you then need the Database to go with it... Moreover, I wouldn't trust using it for production... Oracle has a history of changing the pricing on people and claiming that you have to pay more money if you want to continue using their product because the licensing changed... They may give it to you free this year, next year you'll find yourself with a large bill! Just read these: http://www.idg.net.nz/pressroom.nsf/UNID/8DCAE02D7BD89FD6CC256B8100822FB 0!opendocument http://www.newsbytes.com/news/02/175426.html http://www.crmdaily.com/perl/story/16852.html http://news.com.com/2100-1001-864135.html There are many more... I think MySql is here to stay even if Larry should decide to give it all away for free... database, applications etc. There are always the consulting and support fees, and anyone who worked with Oracle Apps knows you can't do a damn thing without support! ..And if you want to take less than 5 years to implement the system you better have consultants on board and a staff of 2 people per module in house! $0.02 as someone else put it... Francesca >And of course, let's not forget >http://www.oracle.com (Just go to downloads, register your info and try >downloading ANYTHING) > > >I PROMISE YOU, oh non believers, that you'll believe me after you read >those articles, and then try downloading 9i from Oracle. You don't even >have to download it, just start it and watch it go! Cheers, >VJ MPZ >-Original Message- >From: Richard Forgo [mailto:[EMAIL PROTECTED]] >Sent: Monday, March 25, 2002 5:02 PM >To: 'MadProfessor'; [EMAIL PROTECTED] >Subject: RE: Impact of Free ORACLE > > >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: MadProfessor [mailto:[EMAIL PROTECTED]] >Sent: Monday, March 25, 2002 5:48 PM >To: [EMAIL PROTECTED] >Subject: Impact of Free ORACLE > >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 request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/
Re: Impact of Free ORACLE
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: > 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) > > > I PROMISE YOU, oh non believers, that you'll believe me after you read > those articles, and then try downloading 9i from Oracle. You don't even > have to download it, just start it and watch it go! > Cheers, > VJ MPZ > -Original Message- > From: Richard Forgo [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 25, 2002 5:02 PM > To: 'MadProfessor'; [EMAIL PROTECTED] > Subject: RE: Impact of Free ORACLE > > > 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: MadProfessor [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 25, 2002 5:48 PM > To: [EMAIL PROTECTED] > Subject: Impact of Free ORACLE > > 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 request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > -- Michael Bacarella | Netgraft Corporation | 545 Eighth Ave #401 Systems Analysis | New York, NY 10018 Technical Support | 212 946-1038 | 917 670-6982 Managed Services | [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL Myths Debunked Revision 5
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 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. Seems like I wasn't the only one who needed it. The response to this article has been overall very positive. More MySQL success stories would be much appreciated. -- Michael Bacarella | Netgraft Corporation | 545 Eighth Ave #401 Systems Analysis | New York, NY 10018 Technical Support | 212 946-1038 | 917 670-6982 Managed Services | [EMAIL PROTECTED] query,table,sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Impact of Free ORACLE
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 you give up causes the 'free' aspect to become questionable. First try measuring the amount of 'free' disk space you have left. Then try checking the amount of 'free' memory you have left.There's other non-free aspects of Oracle, but I will not go on. I think I'll go back to 'free' (as in disk space) for now joe > -Original Message- > From: Tim Buchalka [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 25, 2002 4:44 PM > To: 'MadProfessor' > Cc: [EMAIL PROTECTED] > Subject: RE: Impact of Free ORACLE > > > 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- > From: MadProfessor [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 26 March 2002 10:00 AM > To: 'Richard Forgo'; [EMAIL PROTECTED] > Subject: RE: Impact of Free ORACLE > > > 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) > > > I PROMISE YOU, oh non believers, that you'll believe me after you read > those articles, and then try downloading 9i from Oracle. You > don't even > have to download it, just start it and watch it go! Cheers, VJ MPZ > -Original Message- > From: Richard Forgo [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 25, 2002 5:02 PM > To: 'MadProfessor'; [EMAIL PROTECTED] > Subject: RE: Impact of Free ORACLE > > > 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: MadProfessor [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 25, 2002 5:48 PM > To: [EMAIL PROTECTED] > Subject: Impact of Free ORACLE > > 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 request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: 3.23.50?
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 To: Michael Bacarella Cc: [EMAIL PROTECTED] Subject:Re: 3.23.50? 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 or so. (Maybe sooner?) -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 46 days, processed 1,317,906,824 queries (329/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Impact of Free ORACLE
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 the database is free... I can find Oracle 9iAS downloadable for free... that's the Application Server, you then need the Database to go with it... Moreover, I wouldn't trust using it for production... Oracle has a history of changing the pricing on people and claiming that you have to pay more money if you want to continue using their product because the licensing changed... They may give it to you free this year, next year you'll find yourself with a large bill! Just read these: http://www.idg.net.nz/pressroom.nsf/UNID/8DCAE02D7BD89FD6CC256B8100822FB0!opendocument http://www.newsbytes.com/news/02/175426.html http://www.crmdaily.com/perl/story/16852.html http://news.com.com/2100-1001-864135.html There are many more... I think MySql is here to stay even if Larry should decide to give it all away for free... database, applications etc. There are always the consulting and support fees, and anyone who worked with Oracle Apps knows you can't do a damn thing without support! ..And if you want to take less than 5 years to implement the system you better have consultants on board and a staff of 2 people per module in house! $0.02 as someone else put it... Francesca >And of course, let's not forget >http://www.oracle.com (Just go to downloads, register your info and try >downloading ANYTHING) > > >I PROMISE YOU, oh non believers, that you'll believe me after you read >those articles, and then try downloading 9i from Oracle. You don't even >have to download it, just start it and watch it go! >Cheers, >VJ MPZ >-Original Message- >From: Richard Forgo [mailto:[EMAIL PROTECTED]] >Sent: Monday, March 25, 2002 5:02 PM >To: 'MadProfessor'; [EMAIL PROTECTED] >Subject: RE: Impact of Free ORACLE > > >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: MadProfessor [mailto:[EMAIL PROTECTED]] >Sent: Monday, March 25, 2002 5:48 PM >To: [EMAIL PROTECTED] >Subject: Impact of Free ORACLE > >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 request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > >- >Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Impact of Free ORACLE
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) I PROMISE YOU, oh non believers, that you'll believe me after you read those articles, and then try downloading 9i from Oracle. You don't even have to download it, just start it and watch it go! Cheers, VJ MPZ -Original Message- From: Richard Forgo [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 5:02 PM To: 'MadProfessor'; [EMAIL PROTECTED] Subject: RE: Impact of Free ORACLE 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: MadProfessor [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 5:48 PM To: [EMAIL PROTECTED] Subject: Impact of Free ORACLE 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 request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Myths Debunked Revision 5
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 this?! Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
GRANT create/drop for temp tables
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 statement and later use a select statement to get some data, and later drop the temporary table. I would like to do this without giving create and especially drop access to the regular non-temporary tables in the database. Thanks, Ray Rodriguez - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Impact of Free ORACLE
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- From: MadProfessor [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 26 March 2002 10:00 AM To: 'Richard Forgo'; [EMAIL PROTECTED] Subject: RE: Impact of Free ORACLE 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) I PROMISE YOU, oh non believers, that you'll believe me after you read those articles, and then try downloading 9i from Oracle. You don't even have to download it, just start it and watch it go! Cheers, VJ MPZ -Original Message- From: Richard Forgo [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 5:02 PM To: 'MadProfessor'; [EMAIL PROTECTED] Subject: RE: Impact of Free ORACLE 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: MadProfessor [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 5:48 PM To: [EMAIL PROTECTED] Subject: Impact of Free ORACLE 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 request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Myths Debunked Revision 5
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. Seems like I wasn't the only one who needed it. The response to this article has been overall very positive. More MySQL success stories would be much appreciated. -- Michael Bacarella | Netgraft Corporation | 545 Eighth Ave #401 Systems Analysis | New York, NY 10018 Technical Support | 212 946-1038 | 917 670-6982 Managed Services | [EMAIL PROTECTED] query,table,sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Performance indexes with a lot of Null values on MyISAM big tables
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 around 300 Megs on disk for 10 millions records. I am willing to add 3 other indexes, but they won't be unique indexes, and for one of them the field will be NULL for 25% of the records, meaning that the index may be weird and that insertion may need some time to find where to insert this NULL key in the index. The new index file size is 500 Megs when built from scratch. I had huge problems on a Microsoft SQL server some years ago doing this because it was "overflowing index pages", does someone has some experience on MyISAM ? Any idea about performance impact of this change ? The server is a dual P3, 1 gig RAM, with hardware raid, only doing this. Regards, -- Benoît Grangé Directeur réseau, Tiscali Télécom 37 rue Greneta, 75002 Paris (plan) tel: +33 1 45 08 24 68 fax: +33 1 45 08 20 01 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
hierarchical struture into mysql
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 Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Impact of Free ORACLE
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* - Gabriel 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.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Impact of Free ORACLE
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 To: [EMAIL PROTECTED] Subject:Impact of Free ORACLE 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 request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Impact of Free ORACLE
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.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail ><[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Impact of Free ORACLE
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: MadProfessor [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 5:48 PM To: [EMAIL PROTECTED] Subject: Impact of Free ORACLE 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 request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Impact of Free ORACLE
...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 ORACLE 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 request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Impact of Free ORACLE
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 posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Impact of Free ORACLE
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 request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Thanks to whomever... for the tip on mySQLMan...
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- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 12:52 PM To: Andrew Lietzow; [EMAIL PROTECTED] Subject: RE: Thanks to whomever... for the tip on mySQLMan... 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 Manager Mountain Top Herbs -Original Message- From: Andrew Lietzow [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 11:28 AM To: [EMAIL PROTECTED] Subject: Thanks to whomever... for the tip on mySQLMan... 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 forward. I have known for a long time that I would eventually want to run mySQL but the inability to use a web browser to access and manipulate data was a show-stopper for me. I just could not see myself getting all that excited by a character-based interface. It works for some things but not for serious database development, IMO. Last time I checked, Oracle wanted about 1,000,000 US dollars for their front-end gizmo (Oracle Forms?). I'm sure it has come down some since I checked. And maybe there is an X-Windows GUI interface available, but I am not aware of it. I have worked with 3-GL's in character based mode for over a decade; I like being spoiled by a browser and a GUI. So, I waited and waited, and voila, someone finally invented the wheel. The only thing I KNEW for sure during this time was that I was not going to give in and begin to use a MS product like Access; one that runs only on Windoze based O/S's. There are lots of great products for Windoze and I have to hand it to MS for marketing, but I'm not interested in having to reboot and reboot just to regain resources with a production system. While there are lots of users of MS-Access, it doesn't come in a Linux flavor so I could not devote much of my mindshare to it. It is an unfortunate reality because I really need a good database but it had to run on Linux to get my attention. So, now that I have found mySQLMan, I owe someone a huge "Thank you!". I got it up and running in a day, or so, and I'm excited to be moving on with my little project. I do get the impression that mySQL is compatible with RH Interchange as the install asks this question during setup. Hope that proves to be true. If there is a better way to go for an ecommerce server than Interchange, I have not seen it--but I'm all ears! Any caveats or alternative recommendations would be considered but only for a short time...I'm about to attain lift off! Personally, I do think the security issues on mySQL take up an inordinate amount of time (from what I can see on this list, it's a major issue that needs revisited from a development point of view). Thankfully, by seeing that there is more than one table involved with the mySQL database, I poked at it long enough that I finally got the remote login to work. Geepers, what a nightmare... Wouldn't it just be easier to hang all of the illegally intruding b*$#(@+s until we eradicated them from the planet? Andrew Lietzow The ACL Group, Inc. alias Number 1 Plantsman at http://hostahaven.com - Original Message - From: "Brian Bray" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 25, 2002 11:35 AM Subject: fulltext server as replication client? > 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 the fulltext queries on the slave server? > > > Thanks, > Brian Bray > > > > [for the filter: sql,query] > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/
Access break mode error
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 way to get out of it is to force Access to close--something that obviously makes me nervous. I have a timestamp column and a primary key--everything should be a current version. Has anyone else experienced this or know what the problem is? --Aaron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Dropping tables
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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Update change values in wrong column
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 both your start and stop columns to DATETIME -- otherwise, the stop column will become the first TIMESTAMP and will begin updating automatically. http://www.mysql.com/doc/D/A/DATETIME.html --jeff - Original Message - From: "Shawn McCool" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 25, 2002 2:13 PM Subject: Re: Update change values in wrong column > 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 WARRANTY. This is free software, > >and you are welcome to modify and redistribute it under the GPL license > > > >Server version 3.23.42-log > >Protocol version10 > >Connection Localhost via UNIX socket > >UNIX socket /tmp/mysql.sock > >Uptime: 1 day 7 hours 15 min 46 sec > > > >Threads: 1 Questions: 436 Slow queries: 0 Opens: 93 Flush tables: 2 > >Open tables: 0 Queries per second avg: 0.004 > > > >. Vendor Apple Blue&White G3 > >. MacOS X 10.1.3 > >. The included compiler in MacOSX Developer Tools gcc? > > > > > >THE ERROR > >See what happens in the start column, it change ?? when updating > >price column > > > >mysql> SELECT * FROM bookings; > >++++++ > >+---++ > >| id | start | stop | registrated| > >booking_object | booker | price | part_payed | > >++++++ > >+---++ > >| 1 | 20020324184014 | 20020321045959 | 20020323022729 | > >1 | 1 | NULL | NULL | > >| 2 | 20020324184014 | 20020330055959 | 20020324171150 | > >1 | 1 | NULL | NULL | > >++++++ > >+---++ > >2 rows in set (0.00 sec) > > > >mysql> UPDATE bookings SET price='0'; > >Query OK, 2 rows affected (0.01 sec) > >Rows matched: 2 Changed: 2 Warnings: 0 > > > >mysql> SELECT * FROM bookings; > >++++++ > >+---++ > >| id | start | stop | registrated| > >booking_object | booker | price | part_payed | > >++++++ > >+---++ > >| 1 | 20020324184136 | 20020321045959 | 20020323022729 | > >1 | 1 | 0 | NULL | > >| 2 | 20020324184136 | 20020330055959 | 20020324171150 | > >1 | 1 | 0 | NULL | > >++++++ > >+---++ > >2 rows in set (0.00 sec) > > > >mysql> desc bookings; > >++---+--+-+-++ > >| Field | Type | Null | Key | Default | > >Extra | > >++---+--+-+-++ > >| id | int(11) | | PRI | NULL| > >auto_increment | > >| start | timestamp(14) | YES | | > >NULL|| > >| stop | timestamp(14) | YES | | > >NULL|| > >| registrated| timestamp(14) | YES | | > >NULL|| > >| booking_object | int(11) | YES | MUL | > >NULL|| > >| booker | int(11) | YES | | > >NULL|| > >| price | text | YES | | > >NULL|| > >| part_payed | text | YES | | > >NULL|| > >++---+--+-+-++ > >8 rows in set (0.00 sec) > > > >Best Greetings > > > >Sive > > > > > > > >- > >Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > >To request this thread, e-mail <[EMAIL PROTECTED]> > >To unsubscribe, e-mail <[EMAIL PROTECTED]> > >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTE
Re: Update change values in wrong column
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 WARRANTY. This is free software, >and you are welcome to modify and redistribute it under the GPL license > >Server version 3.23.42-log >Protocol version10 >Connection Localhost via UNIX socket >UNIX socket /tmp/mysql.sock >Uptime: 1 day 7 hours 15 min 46 sec > >Threads: 1 Questions: 436 Slow queries: 0 Opens: 93 Flush tables: 2 >Open tables: 0 Queries per second avg: 0.004 > >. Vendor Apple Blue&White G3 >. MacOS X 10.1.3 >. The included compiler in MacOSX Developer Tools gcc? > > >THE ERROR >See what happens in the start column, it change ?? when updating >price column > >mysql> SELECT * FROM bookings; >++++++ >+---++ >| id | start | stop | registrated| >booking_object | booker | price | part_payed | >++++++ >+---++ >| 1 | 20020324184014 | 20020321045959 | 20020323022729 | >1 | 1 | NULL | NULL | >| 2 | 20020324184014 | 20020330055959 | 20020324171150 | >1 | 1 | NULL | NULL | >++++++ >+---++ >2 rows in set (0.00 sec) > >mysql> UPDATE bookings SET price='0'; >Query OK, 2 rows affected (0.01 sec) >Rows matched: 2 Changed: 2 Warnings: 0 > >mysql> SELECT * FROM bookings; >++++++ >+---++ >| id | start | stop | registrated| >booking_object | booker | price | part_payed | >++++++ >+---++ >| 1 | 20020324184136 | 20020321045959 | 20020323022729 | >1 | 1 | 0 | NULL | >| 2 | 20020324184136 | 20020330055959 | 20020324171150 | >1 | 1 | 0 | NULL | >++++++ >+---++ >2 rows in set (0.00 sec) > >mysql> desc bookings; >++---+--+-+-++ >| Field | Type | Null | Key | Default | >Extra | >++---+--+-+-++ >| id | int(11) | | PRI | NULL| >auto_increment | >| start | timestamp(14) | YES | | >NULL|| >| stop | timestamp(14) | YES | | >NULL|| >| registrated| timestamp(14) | YES | | >NULL|| >| booking_object | int(11) | YES | MUL | >NULL|| >| booker | int(11) | YES | | >NULL|| >| price | text | YES | | >NULL|| >| part_payed | text | YES | | >NULL|| >++---+--+-+-++ >8 rows in set (0.00 sec) > >Best Greetings > >Sive > > > >- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Update change values in wrong column
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 license Server version 3.23.42-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 1 day 7 hours 15 min 46 sec Threads: 1 Questions: 436 Slow queries: 0 Opens: 93 Flush tables: 2 Open tables: 0 Queries per second avg: 0.004 Vendor Apple Blue&White G3 MacOS X 10.1.3 The included compiler in MacOSX Developer Tools gcc? THE ERROR See what happens in the start column, it change ?? when updating price column mysql> SELECT * FROM bookings; ++++++ +---++ | id | start | stop | registrated| booking_object | booker | price | part_payed | ++++++ +---++ | 1 | 20020324184014 | 20020321045959 | 20020323022729 | 1 | 1 | NULL | NULL | | 2 | 20020324184014 | 20020330055959 | 20020324171150 | 1 | 1 | NULL | NULL | ++++++ +---++ 2 rows in set (0.00 sec) mysql> UPDATE bookings SET price='0'; Query OK, 2 rows affected (0.01 sec) Rows matched: 2 Changed: 2 Warnings: 0 mysql> SELECT * FROM bookings; ++++++ +---++ | id | start | stop | registrated| booking_object | booker | price | part_payed | ++++++ +---++ | 1 | 20020324184136 | 20020321045959 | 20020323022729 | 1 | 1 | 0 | NULL | | 2 | 20020324184136 | 20020330055959 | 20020324171150 | 1 | 1 | 0 | NULL | ++++++ +---++ 2 rows in set (0.00 sec) mysql> desc bookings; ++---+--+-+-++ | Field | Type | Null | Key | Default | Extra | ++---+--+-+-++ | id | int(11) | | PRI | NULL| auto_increment | | start | timestamp(14) | YES | | NULL|| | stop | timestamp(14) | YES | | NULL|| | registrated| timestamp(14) | YES | | NULL|| | booking_object | int(11) | YES | MUL | NULL|| | booker | int(11) | YES | | NULL|| | price | text | YES | | NULL|| | part_payed | text | YES | | NULL|| ++---+--+-+-++ 8 rows in set (0.00 sec) Best Greetings Sive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: 1 table many fields/several tables less fields?
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 part of a multi-valued key, remove it to a separate table. Eliminate Columns Not Dependent On Key - If attributes do not contribute to a description of the key, remove them to a separate table. Isolate Independent Multiple Relationships - No table may contain two or more 1:n or n:m relationships that are not directly related. Isolate Semantically Related Multiple Relationships - There may be practical constrains on information that justify separating logically related many-to-many relationships. C:- -Original Message- From: Gath [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 1:35 PM To: [EMAIL PROTECTED] Subject: 1 table many fields/several tables less fields? 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 it would have around 1500-2500 users (distributed by the day), with about 150 queries each user. In each query, around 10-20 fields values would be needed. The queries would mainly be SELECT and UPDATE... I did read the optimisation part in the manual, particularly: "It's not normally useful to split a table into different tables just because the rows gets 'big'." >From http://www.mysql.com/doc/T/i/Tips.html , "Other Optimisation Tips". http://www.mysql.com/doc/C/r/Creating_many_tables.html, "Drawbacks to Creating Large Numbers of Tables in the Same Database" but still didnt got an straight answer for my precise case. Unfortunally i'm new at this (both MySQL and PHP), so i apolozige for any mistake/stupidity presented in the question... :) I will, in lack of contrary info, use 1 table with many fields... Thank you for any comments. Gath - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL replication
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 of this. Let me know if you need it. Patrick Ouellet wrote: >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 to the replication server when the master >server was down. ) Well the replicated DB is larger than >the Master's DB > >So I want to wait until the replication server has finished >its replication, then use the slave's DB to overwrite >the master DB and resume normal operation. > >Is that a good idea? > >Thanx everyone. > >-A newbie MySQL admin. > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Auto_increment and TimeStamp Fields
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? Paul DuBois <[EMAIL PROTECTED]> To: "Eric Baines" <[EMAIL PROTECTED]>, [EMAIL PROTECTED] cc: 03/25/02 03:02 PMSubject: Re: Auto_increment and TimeStamp Fields 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 except 0. > >Is there a MySQL rule that you can not have an auto_increment field and a >timestamp field in the same table? No, you can have both. mysql> CREATE TABLE t -> (i INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, -> ts TIMESTAMP); Query OK, 0 rows affected (0.00 sec) mysql> INSERT INTO t SET ts = NULL; Query OK, 1 row affected (0.01 sec) mysql> SELECT LAST_INSERT_ID(); +--+ | last_insert_id() | +--+ |1 | +--+ 1 row in set (0.01 sec) mysql> INSERT INTO t SET ts = NULL; Query OK, 1 row affected (0.00 sec) mysql> SELECT LAST_INSERT_ID(); +--+ | last_insert_id() | +--+ |2 | +--+ 1 row in set (0.00 sec) mysql> SELECT * FROM t; +---++ | i | ts | +---++ | 1 | 20020325140102 | | 2 | 20020325140102 | +---++ 2 rows in set (0.00 sec) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 3.23.50?
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 or so. (Maybe sooner?) -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 46 days, processed 1,317,906,824 queries (329/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
1 table many fields/several tables less fields?
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 it would have around 1500-2500 users (distributed by the day), with about 150 queries each user. In each query, around 10-20 fields values would be needed. The queries would mainly be SELECT and UPDATE... I did read the optimisation part in the manual, particularly: "It's not normally useful to split a table into different tables just because the rows gets 'big'." >From http://www.mysql.com/doc/T/i/Tips.html , "Other Optimisation Tips". http://www.mysql.com/doc/C/r/Creating_many_tables.html, "Drawbacks to Creating Large Numbers of Tables in the Same Database" but still didnt got an straight answer for my precise case. Unfortunally i'm new at this (both MySQL and PHP), so i apolozige for any mistake/stupidity presented in the question... :) I will, in lack of contrary info, use 1 table with many fields... Thank you for any comments. Gath - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Strange query issues
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:07 PM > To: [EMAIL PROTECTED] > Subject: Strange query issues > > > > 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 FreeBSD 4.3-RELEASE. > > Our example query is "SELECT id, username, domain FROM usermanagement > LIMIT 1000", id is a primary key, and both username and domain are > indexed. > > The first three servers make the query in about 0.13 seconds. > The last > three take about 6.01 seconds to perform the query. > > This has been consistant and repeatable. > > All the machines are running the same client software. They are all > connected to the server over a switch, with no routers > inbetween. They > all are in the same subnet. They are also all configured in the same > way - they are mail servers. The load is balanced, and no server is > doing any significantly larger amount of processing than the others. > > Can anyone suggest anything for me to try to fix this problem? > > Many many thanks in advance, > Gabriel. > > > > -- > Gabriel Cain > Unix Systems Administrator [EMAIL PROTECTED] > Dialup USA, Inc. 888-460-2286 ext 208 > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
3.23.50?
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 York, NY 10018 Technical Support | 212 946-1038 | 917 670-6982 Managed Services | [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Dumb Newbie Keyword Search Question
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, 2002 10:03 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Dumb Newbie Keyword Search Question Thanks Alec, That is exactly what I was looking for. Dan > I think what you want is a FULLTEXT index with the MATCH operator - see > http://www.mysql.com/doc/F/u/Fulltext_Search.html . > > Particularl.y, see the new developments in fulltext in V4.0.1 half way doen > the page > >Alec Cawley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Thanks to whomever... for the tip on mySQLMan...
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 Manager Mountain Top Herbs -Original Message- From: Andrew Lietzow [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 11:28 AM To: [EMAIL PROTECTED] Subject: Thanks to whomever... for the tip on mySQLMan... 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 forward. I have known for a long time that I would eventually want to run mySQL but the inability to use a web browser to access and manipulate data was a show-stopper for me. I just could not see myself getting all that excited by a character-based interface. It works for some things but not for serious database development, IMO. Last time I checked, Oracle wanted about 1,000,000 US dollars for their front-end gizmo (Oracle Forms?). I'm sure it has come down some since I checked. And maybe there is an X-Windows GUI interface available, but I am not aware of it. I have worked with 3-GL's in character based mode for over a decade; I like being spoiled by a browser and a GUI. So, I waited and waited, and voila, someone finally invented the wheel. The only thing I KNEW for sure during this time was that I was not going to give in and begin to use a MS product like Access; one that runs only on Windoze based O/S's. There are lots of great products for Windoze and I have to hand it to MS for marketing, but I'm not interested in having to reboot and reboot just to regain resources with a production system. While there are lots of users of MS-Access, it doesn't come in a Linux flavor so I could not devote much of my mindshare to it. It is an unfortunate reality because I really need a good database but it had to run on Linux to get my attention. So, now that I have found mySQLMan, I owe someone a huge "Thank you!". I got it up and running in a day, or so, and I'm excited to be moving on with my little project. I do get the impression that mySQL is compatible with RH Interchange as the install asks this question during setup. Hope that proves to be true. If there is a better way to go for an ecommerce server than Interchange, I have not seen it--but I'm all ears! Any caveats or alternative recommendations would be considered but only for a short time...I'm about to attain lift off! Personally, I do think the security issues on mySQL take up an inordinate amount of time (from what I can see on this list, it's a major issue that needs revisited from a development point of view). Thankfully, by seeing that there is more than one table involved with the mySQL database, I poked at it long enough that I finally got the remote login to work. Geepers, what a nightmare... Wouldn't it just be easier to hang all of the illegally intruding b*$#(@+s until we eradicated them from the planet? Andrew Lietzow The ACL Group, Inc. alias Number 1 Plantsman at http://hostahaven.com - Original Message - From: "Brian Bray" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 25, 2002 11:35 AM Subject: fulltext server as replication client? > 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 the fulltext queries on the slave server? > > > Thanks, > Brian Bray > > > > [for the filter: sql,query] > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.332 / Virus Database: 186 - Release Date: 3/6/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.332 / Vir
RE: MySQL not using an index
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 user, IF (LENGTH(referer) > 45, CONCAT(LEFT(referer, 42),"..."),referer) as short_referer, TIME_FORMAT(SEC_TO_TIME(TIME_TO_SEC(MAX(date)) - TIME_TO_SEC(MIN(date)) + 30), "%i:%s") as time, COUNT(access_log.url) as cnt, pIDlog_alerts.url as alert FROM access_log LEFT JOIN pIDlog_alerts ON access_log.url LIKE pIDlog_alerts.url AND access_log.server = pIDlog_alerts.server AND access_log.domain LIKE pIDlog_alerts.domain, pID_report_opt WHERE host != ip AND pID_report_opt.server = access_log.server AND LOCATE("Mozilla",browser) > 0 AND LOCATE([*G_logtable*].domain,omit_domains) = 0 AND access_log.server = 'www.server.com' AND (access_log.status = '304' || access_log.status = '200') AND (filetype = "html" || filetype="pl" || filetype="mpls" || filetype="pdf" || filetype="shtml") GROUP BY session_id HAVING cnt > 1 ORDER BY date DESC LIMIT 20 Explain output: *** 1. row *** table: pID_report_opt type: ref possible_keys: server key: server key_len: 51 ref: const rows: 1 Extra: where used; Using temporary; Using filesort *** 2. row *** table: access_log type: ALL possible_keys: filetype,status,server key: NULL key_len: NULL ref: NULL rows: 592172 Extra: where used *** 3. row *** table: pIDlog_alerts type: ref possible_keys: server key: server key_len: 53 ref: access_log.server rows: 17 Extra: 3 rows in set (0.00 sec) Now to me, the access_log table would be best with the file_type index. Of the types selected, there are 155,983 records of the 592,341 total - or 26%. The order by with a goup by gets me a temp table, but if I could kill the filesort that would be a lot better. Also, maybe a multi field indexd would be great here, but I've neer had much luck with those, and a few times I've had results returned that were wrong with a multi column index on the table. Thanks for looking at this, Mike -Original Message- From: Christopher Thompson [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 3:13 PM To: Michael C. Neel; [EMAIL PROTECTED] Subject: Re: MySQL not using an index 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 wrote: > 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 ( > id bigint(20) unsigned NOT NULL auto_increment, > date datetime default NULL, > host varchar(255) default NULL, > domain varchar(255) default NULL, > ip varchar(255) default NULL, > method varchar(255) default NULL, > port smallint(6) default NULL, > url varchar(255) default NULL, > urlpath varchar(255) default NULL, > filepath varchar(255) default NULL, > filename varchar(255) default NULL, > filetype varchar(255) default NULL, > referer varchar(255) default NULL, > referer_domain varchar(255) default NULL, > referer_query varchar(255) default NULL, > browser varchar(255) default NULL, > status int(11) default NULL, > bytes int(11) default NULL, > server varchar(255) default NULL, > session_id varchar(255) default NULL, > user_id varchar(255) default NULL, > username varchar(255) default NULL, > query varchar(255) default NULL, > path_info varchar(255) default NULL, > request varchar(255) default NULL, > PRIMARY KEY (id), > KEY domain (domain(10)), > KEY url (url(10)), > KEY filetype (filetype(5)), > KEY status (status), > KEY session_id (session_id(10)), > KEY user_id (user_id(10)), > KEY ip (ip(5)), > KEY host (host(5)), > KEY server (server(10)) > ) TYPE=MyISAM; > > The query: > > SELECT * FROM access_log WHERE status=200 > > Gives this result in explain: > > *** 1. row *** > table: MEP_access_log > type: ALL > possible_keys: status > key: NULL > key_len: NULL > ref: NULL > rows: 592042 > Extra: where used > 1 row in set (0.00 sec) > > I'm really running a much more complex query, but this simple one > doesn't use an in
MySQL replication
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 to the replication server when the master server was down. ) Well the replicated DB is larger than the Master's DB So I want to wait until the replication server has finished its replication, then use the slave's DB to overwrite the master DB and resume normal operation. Is that a good idea? Thanx everyone. -A newbie MySQL admin. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Patrick Ouellet - Techniciens Specialiste [EMAIL PROTECTED] Recherche & Developpement Les Entreprises Microtec inc. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= "First they ignore you. Then they laugh at you. Then they fight you. Then you win." -Mohandas Gandhi =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= All source code included (if any ) is copyright Microtec Technologies Inc. 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL not using an index
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 wrote: > 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 ( > id bigint(20) unsigned NOT NULL auto_increment, > date datetime default NULL, > host varchar(255) default NULL, > domain varchar(255) default NULL, > ip varchar(255) default NULL, > method varchar(255) default NULL, > port smallint(6) default NULL, > url varchar(255) default NULL, > urlpath varchar(255) default NULL, > filepath varchar(255) default NULL, > filename varchar(255) default NULL, > filetype varchar(255) default NULL, > referer varchar(255) default NULL, > referer_domain varchar(255) default NULL, > referer_query varchar(255) default NULL, > browser varchar(255) default NULL, > status int(11) default NULL, > bytes int(11) default NULL, > server varchar(255) default NULL, > session_id varchar(255) default NULL, > user_id varchar(255) default NULL, > username varchar(255) default NULL, > query varchar(255) default NULL, > path_info varchar(255) default NULL, > request varchar(255) default NULL, > PRIMARY KEY (id), > KEY domain (domain(10)), > KEY url (url(10)), > KEY filetype (filetype(5)), > KEY status (status), > KEY session_id (session_id(10)), > KEY user_id (user_id(10)), > KEY ip (ip(5)), > KEY host (host(5)), > KEY server (server(10)) > ) TYPE=MyISAM; > > The query: > > SELECT * FROM access_log WHERE status=200 > > Gives this result in explain: > > *** 1. row *** > table: MEP_access_log > type: ALL > possible_keys: status > key: NULL > key_len: NULL > ref: NULL > rows: 592042 > Extra: where used > 1 row in set (0.00 sec) > > I'm really running a much more complex query, but this simple one > doesn't use an index so I don't think my query is affecting the index > (again, I don't *think*). I've run analyze table a few times, and > installed mysql 4.0.1-alpha (currently running 3.23.36), but with no > change. Any idea or routes to look down would greatly help. > > Thanks, > Mike > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL not using an index
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 ( id bigint(20) unsigned NOT NULL auto_increment, date datetime default NULL, host varchar(255) default NULL, domain varchar(255) default NULL, ip varchar(255) default NULL, method varchar(255) default NULL, port smallint(6) default NULL, url varchar(255) default NULL, urlpath varchar(255) default NULL, filepath varchar(255) default NULL, filename varchar(255) default NULL, filetype varchar(255) default NULL, referer varchar(255) default NULL, referer_domain varchar(255) default NULL, referer_query varchar(255) default NULL, browser varchar(255) default NULL, status int(11) default NULL, bytes int(11) default NULL, server varchar(255) default NULL, session_id varchar(255) default NULL, user_id varchar(255) default NULL, username varchar(255) default NULL, query varchar(255) default NULL, path_info varchar(255) default NULL, request varchar(255) default NULL, PRIMARY KEY (id), KEY domain (domain(10)), KEY url (url(10)), KEY filetype (filetype(5)), KEY status (status), KEY session_id (session_id(10)), KEY user_id (user_id(10)), KEY ip (ip(5)), KEY host (host(5)), KEY server (server(10)) ) TYPE=MyISAM; The query: SELECT * FROM access_log WHERE status=200 Gives this result in explain: *** 1. row *** table: MEP_access_log type: ALL possible_keys: status key: NULL key_len: NULL ref: NULL rows: 592042 Extra: where used 1 row in set (0.00 sec) I'm really running a much more complex query, but this simple one doesn't use an index so I don't think my query is affecting the index (again, I don't *think*). I've run analyze table a few times, and installed mysql 4.0.1-alpha (currently running 3.23.36), but with no change. Any idea or routes to look down would greatly help. Thanks, Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Strange query issues
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 FreeBSD 4.3-RELEASE. Our example query is "SELECT id, username, domain FROM usermanagement LIMIT 1000", id is a primary key, and both username and domain are indexed. The first three servers make the query in about 0.13 seconds. The last three take about 6.01 seconds to perform the query. This has been consistant and repeatable. All the machines are running the same client software. They are all connected to the server over a switch, with no routers inbetween. They all are in the same subnet. They are also all configured in the same way - they are mail servers. The load is balanced, and no server is doing any significantly larger amount of processing than the others. Can anyone suggest anything for me to try to fix this problem? Many many thanks in advance, Gabriel. -- Gabriel Cain Unix Systems Administrator [EMAIL PROTECTED] Dialup USA, Inc. 888-460-2286 ext 208 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Auto_increment and TimeStamp Fields
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 except 0. > >Is there a MySQL rule that you can not have an auto_increment field and a >timestamp field in the same table? No, you can have both. mysql> CREATE TABLE t -> (i INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, -> ts TIMESTAMP); Query OK, 0 rows affected (0.00 sec) mysql> INSERT INTO t SET ts = NULL; Query OK, 1 row affected (0.01 sec) mysql> SELECT LAST_INSERT_ID(); +--+ | last_insert_id() | +--+ |1 | +--+ 1 row in set (0.01 sec) mysql> INSERT INTO t SET ts = NULL; Query OK, 1 row affected (0.00 sec) mysql> SELECT LAST_INSERT_ID(); +--+ | last_insert_id() | +--+ |2 | +--+ 1 row in set (0.00 sec) mysql> SELECT * FROM t; +---++ | i | ts | +---++ | 1 | 20020325140102 | | 2 | 20020325140102 | +---++ 2 rows in set (0.00 sec) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Auto_increment and TimeStamp Fields
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 have an auto_increment field and a timestamp field in the same table? Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Problem loading PC DB into Solaris
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 installed successfully in multiple places on UNIX, been using it with >success. The code in phpslice refers to tables with mixed case and the >database creation scripts use mixed case names to create the tables. Works >fine. > >The tables ended up being created in all low case when input through >mysql.exe < createtables.sql. The weird part is that the scripts worked even >though they were referencing mixed case table names that did not exist. >Sounds like a windows thing for sure. > >Doing an export of the data to move to Solaris, wrote the tables all out in >low case as the tables all existed with low case names at that point. So >phpMyAdmin doesn't know any better at that point. > >I guess word to the wise, when moving back and forth between Windows and >*NIX pay attention to the case of tables and what not in addition to the >normal CF/LF issues. That's one reason I always use lowercase for database and table names. This issue also comes up when using Mac OS X, which is UNIX, but is built on top of the non-case-sensitive Mac OS file system. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AIX - Dependent module libmysqlclient.a could not be loaded
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 libmysqlclient.a could not be loaded." We used the IBM C compiler on AIX v4.3.3 to perform the build. Our resulting mysql does NOT work on another machine which also has AIX v4.3.3 and does NOT work on a machine which runs AIX 5.x. Using the ldd tool, I have identified two libraries that libmysqlclient.a is dependent upon, libc.a and libcrypt.a. Both of these libraries exist on all machines. I can't recompile MySQL for every machine. Any ideas on how to compile a version that WILL work on any AIX 4.3.3 machine? thanks joe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Problem loading PC DB into Solaris
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 using it with success. The code in phpslice refers to tables with mixed case and the database creation scripts use mixed case names to create the tables. Works fine. The tables ended up being created in all low case when input through mysql.exe < createtables.sql. The weird part is that the scripts worked even though they were referencing mixed case table names that did not exist. Sounds like a windows thing for sure. Doing an export of the data to move to Solaris, wrote the tables all out in low case as the tables all existed with low case names at that point. So phpMyAdmin doesn't know any better at that point. I guess word to the wise, when moving back and forth between Windows and *NIX pay attention to the case of tables and what not in addition to the normal CF/LF issues. This is so dumb I could just scream. Didn't we solve low case and upper case issues between platforms in the 1980s? Ugh. Time for a coffee break. Anyway, thanks all that tried to help. I appreciate it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB books
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 Webmonkey online article by Jay Greenspan about transactions in MySQL. I have not seen a copy of 'Core Mysql' by Leon Atkinson. Therefore I do not know how comprehensive the InnoDB coverage is in that book. From the contents I see there is a chapter on transactions in MySQL. Since the most important aspect in InnoDB is transactions and multiversion concurrency control, and those are close to Oracle, some general SQL books which are aware of Oracle might also help. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB -Original Message- From: Gabriel Ricard <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Date: Monday, March 25, 2002 7:12 PM Subject: Re: InnoDB books >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 message cannot be posted because it appears to be either spam or >>simply off topic to our filter. To bypass the filter you must include >>one of the following words in your message: >> >>sql,query >> >>If you just reply to this message, and include the entire text of it in the >>reply, your reply will go through. However, you should >>first review the text of the message to make sure it has something to do >>with MySQL. Just typing the word MySQL once will be sufficient, for example. >> >>You have written the following: >> >> >>does anyone know of any books that give innodb good coverage? >> >> >>- >>Before posting, please check: >> http://www.mysql.com/manual.php (the manual) >> http://lists.mysql.com/ (the list archive) >> >>To request this thread, e-mail <[EMAIL PROTECTED]> >>To unsubscribe, e-mail <[EMAIL PROTECTED]> >>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php >> >> > > > >- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problems deleting a user from "user" db
> 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problems deleting a user from "user" db
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'; -- denonymous www.coldcircuit.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problems deleting a user from "user" db
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, > Manuel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MS Access MyODBC MySQL and #DELETED
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). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Repost: mysql 3.23.26 + freebsd 4.4 stable cpu pinned
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 any documentation about a problem where the cpu gets pinned > in the high 90% after running for a while. > > While it was in this state I tried mysqladmin processlist and saw 7 threads > all in sleep (persistent dbi connection). There was minimal load on this as > people weren't really connecting to it much. I have since shutdown and > restarted and now everything is back to normal. > > So what do I do the next time this happens? > Is there a fix for this in a more recent codeset? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: problems deleting a user from "user" db
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 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. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql/php on Win2000
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 -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 1:29 PM To: 'Andrew Hazen'; [EMAIL PROTECTED] Subject: RE: mysql/php on Win2000 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 AM To: [EMAIL PROTECTED] Subject: mysql/php on Win2000 Hi, I want to set up my home computer (PIII,Win2000) for development and testing of php/mysql work. I know that both will install and work on a Win2000 box, my questions are about potential conflicts: My Win2000 came with IIS, are there any hitches to using php/mysql with IIS? Should I install Apache, and if so, do I need to completely uninstall IIS? I have a development edition of Oracle 8i running on the box already. Will this create conflicts with mysql? Does mysql run as a service that I can turn off like Oracle?(in other words, can I turn each on/off depending which I'm working with? Or are they happy running side by side on the same box?) Any advice, or links to useful docs would be appreciated. Andrew Hazen Database Developer Jatech Solutions Inc. 160 Bartley Drive Toronto, ON M4A 1E1 www.jatech.ca 416-288-9833 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem loading PC DB into Solaris
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 Solaris is dying over. 2. You may want to try is to see if this happens on another *nix platform if you can get your hands on one. See if you have the same problem on a Linux box, if not then try moving the data from the Linux box to the Solaris box. 3. If you still have no luck check the compile time options to see if there was any weirdness or try and recompile. I have moved data from an NT 4.0 server to a Redhat Linux server to a Solaris 2.7 box, without a single problem, so I know there isn't normally a problem doing this. Anyone is welcome to jump in at this point, I can feel the water getting deeper :-) Scott Helms Director of Technology, ZCorum (770) 888-8900 ext 2205 - Original Message - From: "Alexander, Chris" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 25, 2002 12:21 PM Subject: RE: Problem loading PC DB into Solaris > > | > | 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: > || phpinfo(); > | ?> > | > | and call it something original like info.php, and call it > | from a browser. > | It should show the mysl support section. > > Apache/PHP/Mysql on the Sol 2.6 box (Generic_105181-26). Yes, > paleo-computing but I don't think that is the problem. > > If I empty the data and keep the schema (i.e. start with a minimal-populated > DB) it works... > > In phpinfo() the mysql section looks like this: > > MySQL Supportenabled > Active Persistent Links 2 > Active Links 2 > Client API version 3.23.39 > MYSQL_MODULE_TYPEbuiltin > MYSQL_SOCKET /tmp/mysql.sock > MYSQL_INCLUDE > MYSQL_LIBS > > DirectiveLocal Value Master Value > mysql.allow_persistent On On > mysql.default_host no value no value > mysql.default_password no value no value > mysql.default_port no value no value > mysql.default_socket no value no value > mysql.default_user no value no value > mysql.max_links UnlimitedUnlimited > mysql.max_persistent UnlimitedUnlimited > > Hmm, include and libs is empty...can't see that being the issue though. This > is all stuff as set (default?) from the Sol 2.6 mysql package at > sunfreeware.com. > > The PHP error I am getting is: > > Warning: Supplied argument is not a valid MySQL result resource in > /www/sapdoc.rmoc.on.ca/html/lib/db.php on line 69 > > Which normally means the select from the db was malformed, but I can't see > where it is broken, and this exact same code works on the "identical" db > that is on the PC via a socket connection (but throws this error when data > is called from localhost). > > Weird. > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql/php on Win2000
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 Properties and select "Disable" in the drop down box -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 12:34 PM To: 'Todd Williamsen' Cc: [EMAIL PROTECTED] Subject: RE: mysql/php on Win2000 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 -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 1:29 PM To: 'Andrew Hazen'; [EMAIL PROTECTED] Subject: RE: mysql/php on Win2000 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 AM To: [EMAIL PROTECTED] Subject: mysql/php on Win2000 Hi, I want to set up my home computer (PIII,Win2000) for development and testing of php/mysql work. I know that both will install and work on a Win2000 box, my questions are about potential conflicts: My Win2000 came with IIS, are there any hitches to using php/mysql with IIS? Should I install Apache, and if so, do I need to completely uninstall IIS? I have a development edition of Oracle 8i running on the box already. Will this create conflicts with mysql? Does mysql run as a service that I can turn off like Oracle?(in other words, can I turn each on/off depending which I'm working with? Or are they happy running side by side on the same box?) Any advice, or links to useful docs would be appreciated. Andrew Hazen Database Developer Jatech Solutions Inc. 160 Bartley Drive Toronto, ON M4A 1E1 www.jatech.ca 416-288-9833 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problems deleting a user from "user" db
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. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MS Access MyODBC MySQL and #DELETED
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 to go back to it everything is filled with #DELETED. Does anyone out there have any words of wisdom or suggestions please? Alex --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.342 / Virus Database: 189 - Release Date: 14/03/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Thanks to whomever... for the tip on mySQLMan...
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 forward. I have known for a long time that I would eventually want to run mySQL but the inability to use a web browser to access and manipulate data was a show-stopper for me. I just could not see myself getting all that excited by a character-based interface. It works for some things but not for serious database development, IMO. Last time I checked, Oracle wanted about 1,000,000 US dollars for their front-end gizmo (Oracle Forms?). I'm sure it has come down some since I checked. And maybe there is an X-Windows GUI interface available, but I am not aware of it. I have worked with 3-GL's in character based mode for over a decade; I like being spoiled by a browser and a GUI. So, I waited and waited, and voila, someone finally invented the wheel. The only thing I KNEW for sure during this time was that I was not going to give in and begin to use a MS product like Access; one that runs only on Windoze based O/S's. There are lots of great products for Windoze and I have to hand it to MS for marketing, but I'm not interested in having to reboot and reboot just to regain resources with a production system. While there are lots of users of MS-Access, it doesn't come in a Linux flavor so I could not devote much of my mindshare to it. It is an unfortunate reality because I really need a good database but it had to run on Linux to get my attention. So, now that I have found mySQLMan, I owe someone a huge "Thank you!". I got it up and running in a day, or so, and I'm excited to be moving on with my little project. I do get the impression that mySQL is compatible with RH Interchange as the install asks this question during setup. Hope that proves to be true. If there is a better way to go for an ecommerce server than Interchange, I have not seen it--but I'm all ears! Any caveats or alternative recommendations would be considered but only for a short time...I'm about to attain lift off! Personally, I do think the security issues on mySQL take up an inordinate amount of time (from what I can see on this list, it's a major issue that needs revisited from a development point of view). Thankfully, by seeing that there is more than one table involved with the mySQL database, I poked at it long enough that I finally got the remote login to work. Geepers, what a nightmare... Wouldn't it just be easier to hang all of the illegally intruding b*$#(@+s until we eradicated them from the planet? Andrew Lietzow The ACL Group, Inc. alias Number 1 Plantsman at http://hostahaven.com - Original Message - From: "Brian Bray" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 25, 2002 11:35 AM Subject: fulltext server as replication client? > 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 the fulltext queries on the slave server? > > > Thanks, > Brian Bray > > > > [for the filter: sql,query] > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql/php on Win2000
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 that it is as stable as the person who built it. I prefer to run PHP/mysql on its native platform of linux, but it runs great on both systems. -Original Message- From: Curtis Maurand [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 11:34 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: mysql/php on Win2000 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 not as efficient with memory utilization/swap as any *nix on or off the market. Even OS/2 was better about it than Windoze is. Also bear in mind that I've never found Windows to be anywhere near as stable as Unix, though its gotten better. Curtis Chris Hedemark said: >> Any advice, or links to useful docs would be appreciated. > > You did say *any* advice. Keep that in mind... > > My advice to you is to load some popular flavor of UNIX on that > machine, such as Linux or OpenBSD, in order to have a more standard > environment for this. Windows may work, but you're going to be very > lonely finding help for that combination of OS and software. But on > the UNIX side you can't throw a rock without hitting someone who is > effectively running the combination of UNIX/Apache/MySQL/PHP. > > > > > - > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> To > unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql/php on Win2000
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 AM To: [EMAIL PROTECTED] Subject: mysql/php on Win2000 Hi, I want to set up my home computer (PIII,Win2000) for development and testing of php/mysql work. I know that both will install and work on a Win2000 box, my questions are about potential conflicts: My Win2000 came with IIS, are there any hitches to using php/mysql with IIS? Should I install Apache, and if so, do I need to completely uninstall IIS? I have a development edition of Oracle 8i running on the box already. Will this create conflicts with mysql? Does mysql run as a service that I can turn off like Oracle?(in other words, can I turn each on/off depending which I'm working with? Or are they happy running side by side on the same box?) Any advice, or links to useful docs would be appreciated. Andrew Hazen Database Developer Jatech Solutions Inc. 160 Bartley Drive Toronto, ON M4A 1E1 www.jatech.ca 416-288-9833 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: building latest mysql on mac os x
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 for the downloads? The manual is usually slightly ahead of the distributions that are available. Use 3.23.49a. > >I'd like to get a build of 3.23.50 or .49a, whichever is more >stable, on OS X soon. So if there isn't one available then I guess >I'll build it myself. Are there any known issues with building these >versions on Mac OS X? No. Well, yes. You can't use BDB tables. > >Thanks, >Gabriel Ricard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql/php on Win2000
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 the weirdness I am currently having with Slowaris. I don't recommend a production environment using Windows though... Everything will co-exist (I think). I haven't run IIS with Apache at the same time, although I don't see why they would conflict as long as they are both not trying to use port 80. I've run Oracle and Mysql at the same time, works fine if slow (Oracle is a pig on Windoze, er, is a pig). Everything runs as a service, you can up and down them at will if you want/need. HTH | I want to set up my home computer (PIII,Win2000) for development and | testing of php/mysql work. | | I know that both will install and work on a Win2000 box, my | questions | are about potential conflicts: | | My Win2000 came with IIS, are there any hitches to using | php/mysql with | IIS? Should I install Apache, and if so, do I need to completely | uninstall IIS? | | I have a development edition of Oracle 8i running on the | box already. | Will this create conflicts with mysql? Does mysql run as a | service that | I can turn off like Oracle?(in other words, can I turn each on/off | depending which I'm working with? Or are they happy running | side by side | on the same box?) | - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Table created on script Err
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 Message - >From: "Paul DuBois" <[EMAIL PROTECTED]> >To: "alan4100" <[EMAIL PROTECTED]>; "Gerald Clark" ><[EMAIL PROTECTED]> >Cc: <[EMAIL PROTECTED]> >Sent: Monday, March 25, 2002 10:56 AM >Subject: Re: Table created on script Err > > >> At 10:40 -0500 3/25/02, alan4100 wrote: >> >mysql >> > >> >Gerald, >> > >> >I will try that; Paul had suggested USE db_name. ..I will try both >ways..USE >> >db2 and USE db_xxx .. Will keep you both posted. >> >> Gerald's suggestion and mine are the *same*: The "USE" keyword followed by >> the name of the database you want to use. >> >> > >> >- Original Message - >> >From: "Gerald Clark" <[EMAIL PROTECTED]> >> >To: "alan4100" <[EMAIL PROTECTED]> >> >Cc: <[EMAIL PROTECTED]> >> >Sent: Monday, March 25, 2002 9:37 AM >> >Subject: Re: Table created on script Err >> > >> > >> >> USE db2; >> >> >> >> alan4100 wrote: >> >> >> >> >mysql >> >> > >> >> >Paul, >> >> > >> >> >I was afraid to hear that. It had said about line 2 in the error >message. >> >> >This line #2 looks normal. >> >> > >> >> >May I ask you to check this script below, but I am afraid it may be >> >> >annoying. I will eventually put this on posting. Remember I use >Windows >> >XP. >> >> > >> >> >I would like to know if there is such an mysql "reader" to check >syntax >> >> >before I run the script. I am using MySQL by Sams in 21 days. >> >> > >> >> >Alan >> >> > >> >> > >> >> > >> >> >== >> >> > >> >> >CREATE db db2; >> >> >USE db db2; >> >> >CREATE TABLE Customers (Customer_ID INT NOT NULL >> >> >PRIMARY KEY AUTO_INCREMENT, First_Name VARCHAR(20) >> >> >NOT NULL,Last_Name VARCHAR(30) NOT NULL, >> >> >Address VARCHAR(50), City VARCHAR(20), >> >> >State VARCHAR(2), Zip VARCHAR(20), >> >> >E_Mail VARCHAR(20), Age INT, Race VARCHAR(20), >> >> >Gender ENUM('M','F') DEFAULT 'F', >> >> >Eye_Color VARCHAR(10), Hair_Color VARCHAR(10), >> >> >Favorite_Activity ENUM('Programming', 'Eating', >> >> >'Biking', 'Running', 'None') DEFAULT 'None', >> >> >Favorite_Movie VARCHAR(50), Occupation VARCHAR(30), >> >> >Smoker Char(0)); > > > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Table created on script Err
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 PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, March 25, 2002 10:56 AM Subject: Re: Table created on script Err > At 10:40 -0500 3/25/02, alan4100 wrote: > >mysql > > > >Gerald, > > > >I will try that; Paul had suggested USE db_name. ..I will try both ways..USE > >db2 and USE db_xxx .. Will keep you both posted. > > Gerald's suggestion and mine are the *same*: The "USE" keyword followed by > the name of the database you want to use. > > > > >- Original Message - > >From: "Gerald Clark" <[EMAIL PROTECTED]> > >To: "alan4100" <[EMAIL PROTECTED]> > >Cc: <[EMAIL PROTECTED]> > >Sent: Monday, March 25, 2002 9:37 AM > >Subject: Re: Table created on script Err > > > > > >> USE db2; > >> > >> alan4100 wrote: > >> > >> >mysql > >> > > >> >Paul, > >> > > >> >I was afraid to hear that. It had said about line 2 in the error message. > >> >This line #2 looks normal. > >> > > >> >May I ask you to check this script below, but I am afraid it may be > >> >annoying. I will eventually put this on posting. Remember I use Windows > >XP. > >> > > >> >I would like to know if there is such an mysql "reader" to check syntax > >> >before I run the script. I am using MySQL by Sams in 21 days. > >> > > >> >Alan > >> > > >> > > >> > > >> >== > >> > > >> >CREATE db db2; > >> >USE db db2; > >> >CREATE TABLE Customers (Customer_ID INT NOT NULL > >> >PRIMARY KEY AUTO_INCREMENT, First_Name VARCHAR(20) > >> >NOT NULL,Last_Name VARCHAR(30) NOT NULL, > >> >Address VARCHAR(50), City VARCHAR(20), > >> >State VARCHAR(2), Zip VARCHAR(20), > >> >E_Mail VARCHAR(20), Age INT, Race VARCHAR(20), > >> >Gender ENUM('M','F') DEFAULT 'F', > >> >Eye_Color VARCHAR(10), Hair_Color VARCHAR(10), > >> >Favorite_Activity ENUM('Programming', 'Eating', > >> >'Biking', 'Running', 'None') DEFAULT 'None', > >> >Favorite_Movie VARCHAR(50), Occupation VARCHAR(30), > >> >Smoker Char(0)); > > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
fulltext server as replication client?
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 the fulltext queries on the slave server? Thanks, Brian Bray [for the filter: sql,query] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql/php on Win2000
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 not as efficient with memory utilization/swap as any *nix on or off the market. Even OS/2 was better about it than Windoze is. Also bear in mind that I've never found Windows to be anywhere near as stable as Unix, though its gotten better. Curtis Chris Hedemark said: >> Any advice, or links to useful docs would be appreciated. > > You did say *any* advice. Keep that in mind... > > My advice to you is to load some popular flavor of UNIX on that > machine, such as Linux or OpenBSD, in order to have a more standard > environment for this. Windows may work, but you're going to be very > lonely finding help for that combination of OS and software. But on > the UNIX side you can't throw a rock without hitting someone who is > effectively running the combination of UNIX/Apache/MySQL/PHP. > > > > > - > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> To > unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql and snort
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 > > > > - > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> To > unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Problem loading PC DB into Solaris
| | 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 something original like info.php, and call it | from a browser. | It should show the mysl support section. Apache/PHP/Mysql on the Sol 2.6 box (Generic_105181-26). Yes, paleo-computing but I don't think that is the problem. If I empty the data and keep the schema (i.e. start with a minimal-populated DB) it works... In phpinfo() the mysql section looks like this: MySQL Supportenabled Active Persistent Links 2 Active Links 2 Client API version 3.23.39 MYSQL_MODULE_TYPEbuiltin MYSQL_SOCKET /tmp/mysql.sock MYSQL_INCLUDE MYSQL_LIBS DirectiveLocal Value Master Value mysql.allow_persistent On On mysql.default_host no value no value mysql.default_password no value no value mysql.default_port no value no value mysql.default_socket no value no value mysql.default_user no value no value mysql.max_links UnlimitedUnlimited mysql.max_persistent UnlimitedUnlimited Hmm, include and libs is empty...can't see that being the issue though. This is all stuff as set (default?) from the Sol 2.6 mysql package at sunfreeware.com. The PHP error I am getting is: Warning: Supplied argument is not a valid MySQL result resource in /www/sapdoc.rmoc.on.ca/html/lib/db.php on line 69 Which normally means the select from the db was malformed, but I can't see where it is broken, and this exact same code works on the "identical" db that is on the PC via a socket connection (but throws this error when data is called from localhost). Weird. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL running on a MacOSX webserver - issues?
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 that sometimes results in a corrupted table. I'm not sure why though. We're replacing this with PHP code currently and that has not caused any corruption on our development server, so we're hopeful that whatever the problem is, it is related to the RealBASIC app or ODBC. Aside from that one problem, it runs wonderfully. We've got the main database running on a G4 867MHz with 1.12GB RAM, and we've got a replica running on an older 500MHz G4 that we use to backup the database. - Gabriel Rob Newman wrote: >Hi there, > >If you could please answer this question impartially as I know a lot of you >use UNIX, Linux and Win machines... > >I am building a website with mySQL and Cold Fusion, and was wondering if >there were any 'issues' with running it from a Mac OSX web server. I am >aware that Cold Fusion is not yet available for OSX, but will be soon, >therefore my question is predominantly to ask if anyone uses a OSX webserver >with mySQL. > >To those of you that helped build mySQL - are there any major problems as to >why I shouldn't use this setup? I am not committed to this setup, its just >that I need to decide whether to use a MacOSX or Linux machine (my boss >likes Macs - and if I want to have a Linux setup then I have to have >legitimate concerns as the why, such as security, support etc). > >Thanks for your time. > > >- Rob >_ > >Rob Newman Ph.D. >Institute of Geophysics and Planetary Physics >Scripps Institution of Oceanography >University of California, San Diego >9500 Gilman Drive >La Jolla, CA 92093-0225, USA > >[t] +1 858 822-1333 >[f] +1 858 534-5332 >[e] [EMAIL PROTECTED] > > >- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
building latest mysql on mac os x
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.23.50 or .49a, whichever is more stable, on OS X soon. So if there isn't one available then I guess I'll build it myself. Are there any known issues with building these versions on Mac OS X? Thanks, Gabriel Ricard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem loading PC DB into Solaris
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 browser. It should show the mysl support section. Scott Helms - Original Message - From: "Alexander, Chris" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, March 25, 2002 11:34 AM Subject: RE: Problem loading PC DB into Solaris > Yep, all that stuff works. I can list the contents of any table, etc. > > One thing I did notice is that in phpMyAdmin that the total sizes of both > tables are different - out by a few kb for some of the larger tables with > the Solaris ones being smaller. > > I dunno, it's weird - the mysql selects that are in the PHP should be > ignoring that level of stuff anyway...if it wasn't for the solaris box being > able to use the pc tables cleanly I wouldn't have started looking at mysql > being the problem. The php looks clean and it does work properly on the pc > data when run from solaris. > > Weirdness. :( > > | -Original Message- > | From: Scott Helms [mailto:[EMAIL PROTECTED]] > | Sent: Monday, March 25, 2002 11:40 AM > | To: Alexander, Chris; [EMAIL PROTECTED] > | Subject: Re: Problem loading PC DB into Solaris > | > | > | Chris, > | > | The first thing to do is try and access the data from > | the database on > | the Solaris box. This will show you if there is a problem > | with MySql. As > | for the data, there isn't anything you need to do it > | "except" make sure the > | permissions are correct on the data directory and its > | contents. Try this > | from the Solaris box, > | mysql -u -p > | Enter password: > | mysql> show databases; > | +---+ > | | Database | > | +---+ > | | | > | | mysql | > | | test | > | +---+ > | 3 rows in set (0.01 sec) > | mysql> use ; > | Reading table information for completion of table and column names > | You can turn off this feature to get a quicker startup with -A > | > | Database changed > | mysql> show tables; > | > | > | Then try a simple select, like: > | select * from ; > | > | If all of this works then the problem probably isn't MySql, > | however, I think > | you will identify the problem before reaching the end :-) > | > | Scott Helms > | Director of Technology, ZCorum > | > | > | > | - Original Message - > | From: "Alexander, Chris" <[EMAIL PROTECTED]> > | To: <[EMAIL PROTECTED]> > | Sent: Monday, March 25, 2002 11:01 AM > | Subject: Problem loading PC DB into Solaris > | > | > | > > | > Hi All! New list member here. > | > > | > I was wondering if I could get a little help with a > | problem I am having > | when > | > I load a databse into a Solaris mysql instance. > | > > | > I had populated a database that acts as a content > | repository for a web > | site > | > on my personal PC (Windows) as a proof of concept. The > | site works fine in > | > this environment. > | > > | > I have since gotten approval to move the site to one of > | our Solaris > | servers > | > (Sol 2.6). > | > > | > I have tried various methods of moving the database from > | the PC to the > | > Solaris system: copying the files directly, using backup, > | restore, import, > | > etc. directly from one mysql to another, using data and > | schema exports > | from > | > within phpMyAdmin. In each instance I still come up with > | the standard PHP > | > invalid resource error once I attempt to load the web site. > | > > | > Sounds like a PHP problem, right? That's what I thought > | too until I > | > connected directly to the database on my PC as opposed to > | the one local to > | > the Solaris box. Everything works fine! Additionally, I > | have not altered > | any > | > of the PHP scripts. > | > > | > I was wondering if there was some kind of processing of > | the data that must > | > be done when moving the data from a PC MySQL to a Solaris > | MySQL? I didn't > | > think there would be but that is kind of what it is > | looking like to me at > | > this point. When I browse the table from mysql or from > | phpMyAdmin they > | look > | > identical as far as I can tell visually. > | > > | > Any insights or help appreciated. > | > > | > Thanks! > | > > | > > | > - > | > Before posting, please check: > | >http://www.mysql.com/manual.php (the manual) > | >http://lists.mysql.com/ (the list archive) > | > > | > To request this thread, e-mail > | <[EMAIL PROTECTED]> > | > To un
Re: InnoDB books
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 message cannot be posted because it appears to be either spam or >simply off topic to our filter. To bypass the filter you must include >one of the following words in your message: > >sql,query > >If you just reply to this message, and include the entire text of it in the >reply, your reply will go through. However, you should >first review the text of the message to make sure it has something to do >with MySQL. Just typing the word MySQL once will be sufficient, for example. > >You have written the following: > > >does anyone know of any books that give innodb good coverage? > > >- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php