Force password
Hi guys could someone tell me how I could force people to their enter password otherwise deny entry. I've looked through the mysql manual but I can't seem to find anything on this. your help is greatly appreciated. Tom
Re: Force password
On Sun, Jul 15, 2001 at 04:26:50PM -0700, Tom Gao wrote: Hi guys could someone tell me how I could force people to their enter password otherwise deny entry. I've looked through the mysql manual but I can't seem to find anything on this. I'm not sure what you're after. As long as you set a password on a user's account, they must use the password to gain access to MySQL. Have you found an exception to that? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 -- NEW MySQL 3.23.29: up 28 days, processed 216,711,418 queries (86/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
what' about my current database if I reinstall mysql and my linux
Dear my beloved e-pals, Would you like to be so kind to answer my question ? Please.. Where is located the database of my mysql database engine...? Under which directory is my database located ? And which harddisk ? I want to reinstall my linux. I have more than one harddisk... I have to make sure that the database is located on the other harddisks. Because I will reformat the harddisk whose linux OS. If I have reinstall my Linux and my MySQL, how can I use my previous database ? __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.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
problems untarring mysql under solaris
Hi all: I am running solaris 2.5.1 and I am having difficulties untarring mysql. It decompresses a fair bit and then it shows a crc error. I tried 2 diff ver .38 and .39. In addition, I tried using gnu tar to decompress it however that binary just hangs. any help would be greatly appreciated. regards Imran.
Re: problems untarring mysql under solaris
Hi, This is a known problem with solaris tar, I suggest you use gnu tar for solaris, This should solve your current problem. You can get a pre-build package of gnu tar at www.sunfreeware.com [EMAIL PROTECTED] wrote: Hi all: I am running solaris 2.5.1 and I am having difficulties untarring mysql. It decompresses a fair bit and then it shows a crc error. I tried 2 diff ver .38 and .39. In addition, I tried using gnu tar to decompress it however that binary just hangs. any help would be greatly appreciated. regards Imran. - 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: mysqlbug
hallo With reference to root on 14.07 20:31: Hello: When attempting to perform rpm installation I get: [root@...]# rpm -i MySQL-3.23.39-1.i386.rpm error: MySQL-3.23.39-1.i386.rpm cannot be installed first try this rpm -qa | grep mysql the original rpms have only lowercases with rpm -hUv you can upgrade the mysql with rpm -e you can uninstall the packages try it with rpm -hiv i hope telling you more error, perhaps missing dependence I am running RedHat 7.0 kernel 2.2.16-22 on an i586 (AMD K6-2 to be exact). Thank you for your assistance. Dylan Doxey [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 -- Gruß bye Michael Ott - - Siemens AG - IS IT PS 51 ERL - - Werner-von-Siemens-Strasse 60 - - 91050 Erlangen- - Tel. +49 91 31 7 42 0 54 - - [EMAIL PROTECTED] - - open-source and you have much fun - 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: what' about my current database if I reinstall mysql and my linux
In my setting, it is /usr/local/mysql The data is at /usr/local/mysql/var Sie schrieben am Sonntag, 15. Juli 2001, 10:00:17: Dear my beloved e-pals, Would you like to be so kind to answer my question ? Please.. Where is located the database of my mysql database engine...? Under which directory is my database located ? And which harddisk ? I want to reinstall my linux. I have more than one harddisk... I have to make sure that the database is located on the other harddisks. Because I will reformat the harddisk whose linux OS. If I have reinstall my Linux and my MySQL, how can I use my previous database ? __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.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 -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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: Any workaround for no union operation?
Kevin Smith writes: Will the following be in version 4 as well? UPDATE table1 SET cola = SELECT [colb] FROM table2 WHERE table1.id = table2.id And sub-selects as well? Thanks, Kevin Multi-table updates should come in 4.0, while sub-selects will come in 4.1. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Force password
Maybe you need to restrict access through .htaccess or some other form of login-procedure. There are lots of packets out there realising user login. Sie schrieben am Montag, 16. Juli 2001, 01:26:50: Hi guys could someone tell me how I could force people to their enter password otherwise deny entry. I've looked through the mysql manual but I can't seem to find anything on this. your help is greatly appreciated. Tom -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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: encrition /security
webmaster wrote: I have a customer who needs to have a very secure site, more secure than usual, he thinks that having a secure server is not enough so what kind of security for his transactions can I offer him? we are not talking about money transfers, his bussines is not about money is about information, I need to implement for him a very secure way in wich the infromatino inserted in to a database (oracle) be encripted, wheren can I get info about this= cheers Ps my customer in in europe, cheers You can't do it in way I will learn fast by reading something. Pay to some expert who will consult you for all time of this project. Without you loose your customer now or in future. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ 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: HELP ! Myisamchk doesn't seem to see error in my table :(
Fournier Jocelyn [Presence-PC] wrote: mysql SELECT * FROM forumconthardwarefr6 order by date desc limit 0,20; +--+-++-+-+---+---+-+-+-+-+ | titre| numeropost | ouvert | date| auteur | icone | nbrep | maxnumrep | vue | lastauteur | sondage | +--+-++-+-+---+---+-+-+-+-+ | Vds Barette EDO pour moins j| 8387233509356368993 | 0 | /-/-0--)0 26:25:28 | ssonneur_de_vie | 117 | 0 | 723859610131712 | 27016 | | 10 | | artitionz| 7300902383298871296 |100 | J521-99-51 55:87:56 | hork | 108 | 0 | 8289623147154535528 | 7696240 | fman | 118 | | city | 8320800813073630040 |117 | p706-83-13 97:69:41 | inary Finary | 108 | 105 | 8241943594372651008 | 5138548 | et | 0 | | et | 661841128741497964 | 7 | Å.()-*(-+. 79:64:86 | | 101 | 0 | 270336 | 24 | AZIZDELAZUP | 0 | cut The date column is DATETIME, and as you can see, the datas are completely corrupted, but myisamchk doesn't see anything wrong :( I believe your data is not restorable. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ 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: Database Backups
MikeBlezien wrote: We just installed MySQL 3.23.39 on a Redhat/Linux6.2 system,..so far so good. We have about 30 customers who are currently using various dbs and was wondering if someone could recommend or has setup some sort of automated back up system for the db's. We use the mysqldump utility do backups, but was wonder if it's possible to setup some of program to execute a 'cron' type back utilizing the mysqldump utility, like once a day. Yes, cron is good tool and you should use it. Why do you need some else cron type when cron is avalaible? Just put right commands in /etc/crontab Ando take a look on mysqlhotcopy script. Some people prefer this to make backups of MySQL database. I do not take position in this. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ 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: what' about my current database if I reinstall mysql and my linux
So sprach »Prabu Subroto« am 2001-07-15 um 01:00:17 -0700 : Dear my beloved e-pals, Hello beloved Prabu! :) engine...? Under which directory is my database On RedHat/Mandrake it's in /var/lib/mysql. But actually you might not need it. Have a look at mysqldump. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 2 hours 20 minutes - 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: Getting more than 256 connections with MySQL/Linux
Alex Coke-Smyth wrote: max_connections=300 basically anything over 256 ends up giving the error : Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug after 256 connections are open. There is plenty of memory available and checking the docs says you should be able to get up to 1500 : If you are using our binary or RPM version 3.23.25 or later, you can safely set `max_connections' at 1500 using a linux 2.2.19 kernel and glibc2.1. Has anyone experienced this problem or know how I can get around it? Yes sure! This is limit of linux 2.2.x kernel. Upgrade to 2.4.x OR change values in file limits.h of linux 2.2.x kernel. There is a value of NR_TASKS set to 512 which you should to increase. There are some comments about it also. All this is documented in manual... -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ 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: mysql.org
BAUMEISTER Alexandre writes: Michael, It's years now that I use Mysql, post/read the mailing list, try to help you solving bugs, testing new features (like InnoDB currently). Why ? Because I really like Mysql, GPL licence and the way you work ! What NuLsphere is doing is really disgusting and I really understand how much you are upset, considering the hard work you did, that someone else could try to take advantage of your work that way. I'm sure that we are really numerous to understand what NuLsphere is doing and to be behind you in this 'fight' against vermin. May the force be with you :) Regards, Alex. Alex, As Monty is on two-day flight from Australia to Finland, I would like to thank you very much for your support. By support I do not just mean this mail, but all nice things that you do ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Re[2]: Mysql++ and Gcc 3.0 compile problems
BAUMEISTER Alexandre writes: Do someone see improvements compiling Mysql with Gcc 3.0 ? Regards, Alex. Don't ask me. I do not have time to install 3.0 on my machine. What improvements would you like to see in the compiled library ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: Any workaround for no union operation?
o sprach Sinisa Milivojevic am 2001-07-14 um 15:24:32 +0300: Unions will soon come in 4.0. Yes, I know, bad question, but anyhow: How soon is 4.0 going to come? Tomorrow :), end of the month, end of the year? PS: database,sql,query,table Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 2 hours 18 minutes - 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: Any workaround for no union operation?
Is there no easy way to do this in the current version (3.29.39) without using a program that loops through to perform each update? Thanks, Kevin - Original Message - From: Sinisa Milivojevic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, July 15, 2001 12:13 PM Subject: Re: Any workaround for no union operation? Kevin Smith writes: Will the following be in version 4 as well? UPDATE table1 SET cola = SELECT [colb] FROM table2 WHERE table1.id = table2.id And sub-selects as well? Thanks, Kevin Multi-table updates should come in 4.0, while sub-selects will come in 4.1. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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 - 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 are NULL treated in stelects
My dealing with other relational databases NULL is treat as an unknown. Therefore, this statement is will not provide complete informations. select * from table where column 25. Column that are not populated or contain a NULL would not be selected. Jeff Kearns
Problem Running a Script File
Hi All, I am trying to run the following syntax on a Windows NT Box. mysql -h host -u user -pPassword Scriptfile If this command is entered into a console window all is well (it works fine). This will also WORK if it is entered in a batch file and then run in the batch file. This command need needs to be scheduled and run unattended. For security reasons I wanted to put the mysql -h host -u user -pPassword part of the command in a compiled file. So I've written a small VB app to shell the command out. It fails when the Scriptfile portion is added to the command. The above syntax will also fail to run from Windows Run box. Fail, Fails = Can see the console window open and the help text scroll through. It appears, possibly to have to do with the character Any help would be appreciated. Thanks, Jeff Jeffries - 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.org
Hi, Sorry.. can't keep my mouth shut.. A few comments on the legal matter: GPL has been spoken about more then enough here.. Trademark: If no license or agreement exists which allows nusphere to use MYSQL AB's trademark it's probably illegal. One could think of situations where it might be perfectly legal.. MYSQL AB must act otherwise MYSQL AB will probably loose the right to use their trademark and the right to defend it againts others. Having a word in a domainname that corresponds with a trademark does not always mean you're in violation of a trademark.. one might have obtained a license to use the trademark.. or one might have a trademark of their own with the word MYSQL and not violate any trademark.. This is in a nutshell how most laws I've seen work. I studied a few laws which have to do with intellectual property.. NOTE: I did use the word probably quite often.. It's not always sure.. If I look at the mysql.org website it looks to me like I found the home of MySQL. This is what most visitors which are unfamiliar with MySQL might or will think. It's a very thin line.. I know.. If nushere want to provide the mysql community with addons or enhancements.. why can't that be done via mysqladdons.com (if that one is still free).. Or even via mysql.org but without attempting to look like the home of MySQL.. I don't think it's generally a good idea to split a community amongst several websites.. having multiple lists and such.. just my 2 cents.. - 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 on OpenBSD 2.8
Brian E. Beck writes: I guess I've lurked long enough. I am a relative newbie to MySQL (and to all things SQL, actually.) I am running MySQL 3.23.37 on my OpenBSD 2.8 server. (I currently support 6 different, non-related databases on the server) Here is the problem... MySQL seems to open too many threads and die... (i.e., if I run top mysqld sems to take up over 90% of the CPU cycles, for hours, if I let it.) Once it does this, I can't shut it down with mysqladmin. It will not respond to anything... No queries, no mysqladmin functions. Nothing. I had a friend of mine write a monitor script, which simply checks every 45 seconds to see the CPU usage of mysqld, and if it is over 90% for longer than 2 minutes, it kill -9's it, and restarts it. (A VERY sloppy solution) --Brian What you are getting looks like a mutex contention problem. Make sure you build MySQL with OpenBSD native threads and not with MIT threads. If you use native threads, use our super-smack program to find out how OpenBSD threads perform. If they don't perform well (compare results with Linux 2.4 kernel), write to OpenBSD. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: mysql.org
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Justin Farnsworth Sent: Sunday, July 15, 2001 4:56 AM Hassan: I respectfully disagree with your suggestion that such a site would spread confusion and give discredit to MySQL. I think it is a fine distinction to say the (slight?) difference between mysql.com and mysql.org would lead to confusion. Are you confused by the extant mysql.net? What about xmysql.com? There have been arguments by both parties that these so-called support sites are in everyone's interest. This practice is common, just think of linux-help.com/linux-support.com/linux-this-or-that.com ad infinitum, and all these play in certain niches without necessarily confusing the linux user, or to-be linux user. I see one HUGE difference between these support sites and .net, in regards to .com: Every one but .net clearly state that this is a product of MySQL AB, tell people about and make very explicit links mysql.com. I came across mysql.org through a search engine some days before this discussion exploded. I, too, wondered why there was no mention of the people behind the web page, what the intent of the page was, etc. One thing I did notice, though, was that not mention AT ALL was made of either MySQL AB or mysql.com. This is still the case today. While people may download the software and documentation, they are completely cut off from the existing community @ .com. I am in no position to discuss the technical merits or legal issues concerning the NuSphere debacle in this context; As such, my point of view is limited to the fact that I see .org as an attempt to pull people away from/split up the community surrounding .com. I wonder why anyone would consider this a bright idea. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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
Environment variables for mm.sql type 4 driver on WIndows 2000
Could some one please tell me what the correct environment variable setting for the mm.mysql type 4 driver should beI can't seem to get it to work THank you
Simple Array Question
Simple question: Using multiple checkboxes and assigning the value from mysql field with. a loop showing all the data I need. I am created a form to delete selected users from database. So I loop through all the ids and this is the checkbox line. not exactly but close. print input type=\checkbox\ name=\idnum\ value=\$id\; in perl Now I need to grab all the idnums and make an array in my action perl-cgi script my @idnums = param(idnum); my blah = $query-param(blah); etc.. My question is how do I make the simpliest loop to delete each idnum from the database. the way I have it now it only deletes the first selection. foreach(@idnums){ $theid=$_; delete from database name where id = $theid # does other things sends email to user } There must be a better way? can I find the length of the array with $length=@idnums; $theid = 0; if ($theid $length) { delete from database name where id = $idnums($theid) #send email to user and other stuff $theid = $theid +1 } }else{ end - 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.org
Guus, Thanks for your good suggestions. Some clarifications below. Guus Leeuw jr. wrote: From: Dipl.-Inf. Guus Leeuw jr. Date: Sun, 15 Jul 2001 03:21:32 +0200 -Original Message- From: Marten Mickos [mailto:[EMAIL PROTECTED]] cut /cut serious Our interpretation is that even under the interim agreement, the operation by NuSphere of mysql.org would have been a trademark violation. Then, Marten, tell us what the status is of the trademark application? Under way, finished, or in the mail as suggested by the other post from Sander Pilon? The MySQL trademark is registered in Sweden and 13 other countries. In the US, the registration has been filed and we are awaiting registration. When we started to use the MySQL mark in the mid-90's it had not been used earlier as far as we can tell. As a side note, this was before the now so popular MyYahoo and MySAP etc. trademarks were taken into use. Monty has told me that he got a lot of criticism for choosing such a silly name. People said it is only toys that carry such names, referring to My Little Pony. And yes, if Britt would agree, you might post documents like the interim agreement and the termination thereof. Of course, this would involve posting the journal of the faxed termination, and a statement from Britt that NuSphere actually received it. Fax communication sometimes don't work... (An aspect sofar not discussed...) I believe it is Lorne Cooper, President of NuSphere that needs to agree. I do not know where the fax thing came from, because the letter referring to the termination was delivered by our lawyers (iIt was the interim agreement from June 2000 that was faxed by David Axmark to Progress). And I would off the top of my head remember that NuSphere responded to it. Marten Mickos CEO MySQL AB - 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
Problem inserting array of rows
I am trying to insert an array of rows or values from a PHP form into a MySQL database. There are six columns in the table songs: id, songname, rating, video, album_id, movie. Here is what I get when I submit the form Add songs for Record Array INSERT INTO songs VALUES (' 1, blah', ' ***', ' 45', ' 2', ' ') id[0]=: 2 this is debug code INSERT Failed, check the code.this is debug code The problem seems to be with this part: for ($i=0; $i= $songsinalbum; $i++) { $vals .=, ('$id[$i], $songname[$i]', '$rating[$i]', '$video[$i]', '$album_id[$i]', '$movie[$i]'); } // $vals=preg_replace(^,, , $vals); $vals=preg_replace('/^,/', '', $vals); // chop leading comma Complete code: When the user presses submit on the form this part executes: mysql_connect(192.168.0.1, mysqluser, mypassword); $vals=' '; for ($i=0; $i= $songsinalbum; $i++) { $vals .=, ('$id[$i], $songname[$i]', '$rating[$i]', '$video[$i]', '$album_id[$i]', '$movie[$i]'); } // $vals=preg_replace(^,, , $vals); $vals=preg_replace('/^,/', '', $vals); // chop leading comma $qry=INSERT INTO songs VALUES $vals; echo $qry; $res=mysql_query($qry); Here is part of the form: ? $i = 1; while ($i = $songsinalbum) { ? TD align=rightID: /TDTDinput type=text name=id[] size=3br/TD TD align=rightSongname: /TDTDinput type=text name=songname[] size=30br/TD ? $i++; }; - 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
--default-character-set
Hi there is no UTF-8 possibility for --default-character-set mysqld starting option. How can I tell mysql to send to clients utf-8 if everything on the database is latin-1 ? if --default-character-set=UTF-8 would exists in shared/charsets, does it mean I have to recode all the content of my database or does it mean mysql would convert it dynamically when sending something to a client ? has anyone got the same problem ? looked in the docs, but not a word on utf-8. thanks pascal barbedor
Re: mysql.org
I see one HUGE difference between these support sites and .net, in regards to .com: Every one but .net clearly state that this is a product of MySQL AB, tell people about and make very explicit links mysql.com. The impression I get from the .org site, is that they are promoting a product called MySQL, and that MySQL AB (found at mysql.com) is a different product all together. This, is in my opinion is simply not on. I have been using MySQL for many years and I am now wondering if there actually is a difference between MySQL and MySQL AB simply because mysql.org are implying such a fact. Their web site is also giving me the impression that they are responsible for the development of MySQL.I know Nusphere have given both time and money to the development of MySQL but I really don't think it quite justifies building a web site with the intention of deceiving users that may not know the full history of MySQL. I'm no lawyer but I would say that the content on mysql.org is very misleading and should be changed, pronto. Another thing that concerns me greatly, is that almost every page on mysql.org contains the word free. Too much use of the word free, to me, sends big time warning signals. Kind regards, Andy. - 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 inserting array of rows
Hi, if you have 6 colums, you are inserting only 5 in table INSERT INTO songs VALUES (' 1, blah', ' ***', ' 45', ' 2', ' ') [1th ] [2nd] [3rd] [4th] [5th] i think that first apostrophe is shifted to left side should be: INSERT INTO songs VALUES (1, 'blah', ' ***', 45, 2, ' '); hint: numeric fields don't required to be in apostrophes Michal Dvoracek [EMAIL PROTECTED] database, table, 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: Any workaround for no union operation?
At 02:13 PM 7/15/01 +0300, Sinisa Milivojevic wrote: Multi-table updates should come in 4.0, while sub-selects will come in 4.1. Not to be a nag, but when will 4.x be here? John Meyer [EMAIL PROTECTED] Programmer If we didn't have Microsoft, we'd have to blame ourselves for all of our programs crashing - 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: How do you insert into two tables at once
David wrote: I have two tables under the one database. What is the best way to INSERT data into both tables at once. Can I use one INSERT statement or do I have to use two? Do those tables have exactly same tructure? If you then you do not have to insert into two table but use MERGE table type instead when doing SELECTs later. I do not know your exact problem but looks like MERGE may help. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ 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
Slient install - Win32 Mysql
Hi, I am trying to create a Mysql Install packages with other Programs (Such as apache). Does any one know what registry keys need to be updated or how can I perform a silent install of win32-mysql ? 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: mysql.org
Andy, a clarification below Andy Woolley wrote: I see one HUGE difference between these support sites and .net, in regards to .com: Every one but .net clearly state that this is a product of MySQL AB, tell people about and make very explicit links mysql.com. The impression I get from the .org site, is that they are promoting a product called MySQL, and that MySQL AB (found at mysql.com) is a different product all together. This, is in my opinion is simply not on. I have been using MySQL for many years and I am now wondering if there actually is a difference between MySQL and MySQL AB simply because mysql.org are implying such a fact. Their web site is also giving me the impression that they are responsible for the development of MySQL.I know Nusphere have given both time and money to the development of MySQL but I really don't think it quite justifies building a web site with the intention of deceiving users that may not know the full history of MySQL. NuSphere is not and was not participating in the development of the MySQL server, which always has been in the hands of Monty at MySQL AB. NuSphere's development effort goes into the Gemini component and other software (I hope this is a fair statement, and NuSphere is welcome to comment and elaborate on it). I'm no lawyer but I would say that the content on mysql.org is very misleading and should be changed, pronto. Another thing that concerns me greatly, is that almost every page on mysql.org contains the word free. Too much use of the word free, to me, sends big time warning signals. Kind regards, Andy. Marten Mickos MySQL AB - 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.org
Just to clarify the U.S. trademark point raised here ... The fact that it is in the mail, in progress, or whatever is really immaterial. It is not at all unusual for the formal application for trademarks, service marks, patents, copyrights, etc. to come months or even years after the product's introduction. According to my Patent Attorney, you are generally protected so long as you can demonstrate proof of 'first use' in the event of a dispute or contest by another applicant. For example, my company introduced a product in April of 1998 at a trade show, but didn't start the wheels in motion to secure the trademark until a few months ago (lawyers cost $$$!). Among the exhibits our attorney is filing with our application is a trade publication reporting on the show where our product was mentioned and copies of literature and logos we used. Monty, David and their associates can point to mountain of magazine articles, trade publications, websites, etc. to prove their claim of first use. In the same vein ... they must aggressively pursue their disagreement with NuSphere. Failure to take legal action to protect a trademark or service mark would be serious mistake, and could result in them losing any protections they would otherwise have. Gerald Jensen database,sql,query,table - 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: Slient install - Win32 Mysql
MySQL doesn't create any Registry keys. The only registry entry that relates directly to MySQL (in addition to the one Monty's InstallShield sets so you can uninstall) is the one the Service Control Manager creates when you install the service. If you install MyODBC, you'll need to account for the keys your DSN's need (HKEY_LOCAL_MACHINE\Software\ODBC) Gerald Jensen - Original Message - From: Eyal Rif [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, July 15, 2001 10:06 AM Subject: Slient install - Win32 Mysql Hi, I am trying to create a Mysql Install packages with other Programs (Such as apache). Does any one know what registry keys need to be updated or how can I perform a silent install of win32-mysql ? Thanks, - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - 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:Replication and InnoDB
Hi! As far as I know, replication works with InnoDB and BDB, and some users have at least tested it with InnoDB. MySQL only writes complete transactions to the binlog and therefore ROLLBACK does not need to be implemented in replication. LOAD TABLE FROM MASTER does not currently work with InnoDB. Look at the Restrictions section in the InnoDB manual at http://www.innodb.com for workarounds. Since the slave executes the binlog in the autocommit=1 mode, you may have to set innodb_flush_log_at_trx_commit=0 in my.cnf of the slave if you have performance problems with the commits in the slave. In crashes there exists the following problem: the MySQL binlog flush and the InnoDB log flush are not synchronized. It means that after a master crash, in some cases the binlog may contain less (or more) transactions than the InnoDB log. Thus, after a master crash, when you restart the master and InnoDB does its crash recovery using it own logs, the master database may end up in a different state from the slave. Then you have to manually resolve the out-of-sync problem. For example, copy the slave database to be the new master. Of course, since MyISAM is a non-transactional table type, users of MyISAM replication need to resolve the same out-of-sync problems. Regards, Heikki Copied message: ... Sinisa, SM It is the same. Replication works already with all table handlers, SM but all that remains to be solved is ROLLBACK. What could be the problem is servers are recording in their binary log only committed transactions ? Why should ROLLBACK be implemented in replication ? If only committed transactions are recorded in the binary log then if a server crashes and it has to rollback it's uncommitted transactions, this has no impact on the replicating scheme isn't it ? Let me know if I'm wrong. Regards, Alex. - 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 inserting array of rows
Hi, I was missing two single quotes in the $val line after $id[$i] and before songname : Here is the corrected code $vals .=, ('$id[$i]', '$songname[$i]', '$rating[$i]', '$video[$i]', '$album_id[$i]', '$movie[$i]'); Now the problem is it only inserts one row into the table, when there should be more than one row inserted. Here is the updated code: ? if (isset($songname) isset($rating)){ mysql_connect(24.1.15.33, webuser, ); echo $id[0]; $vals=''; for ($i=0; $i= $songsinalbum; $i++) { $vals .=, ('$id[$i]', '$songname[$i]', '$rating[$i]', '$video[$i]', '$album_id[$i]', '$movie[$i]'); } $vals=preg_replace('/^,/', '', $vals); // chop leading comma $qry=INSERT INTO songs VALUES $vals; echo $qry; $result = mysql_db_query(movies, $qry); // $res=mysql_query(movies, $qry); $error_number = mysql_errno(); $error_msg = mysql_error(); echo MySQL error $error_number: $error_msg; Here is part of the form: TD align=rightSongname: /TDTDinput type=text name=songname[] size=30br/TD Dvoøáèek Michal wrote: Hi, if you have 6 colums, you are inserting only 5 in table INSERT INTO songs VALUES (' 1, blah', ' ***', ' 45', ' 2', ' ') [1th ] [2nd] [3rd] [4th] [5th] i think that first apostrophe is shifted to left side should be: INSERT INTO songs VALUES (1, 'blah', ' ***', 45, 2, ' '); hint: numeric fields don't required to be in apostrophes Michal Dvoracek [EMAIL PROTECTED] database, table, 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: Parallel Databases
Hi! I'm writing in as to how I can contribute in the development in Parallel databasing. I understand MySQL currently supports replications which is a nice way of keeping live backups of a mysql server, however is hardly the preferred method when dealing with load-balancing and redundancy, just because it becomes a burden at application level to manage your selects to load-balance and any update,insert,alter statements to the parent server. In MySQL 4.0 we will make it very easy for the client to automaticly send updates to the current master and queries to any of the slaves. We will provide both automatic handling of this and also provide a way to force a statement to sent to the master or to a slave. I'm interested in implementing Parallel databasing such as the feature found in Oracle. This would involve (i imagine) some very complex algorithms and some very sophisticated monitor and checking systems however I do have a very heavy c/c++ knowledge. If someone could contact me and update me on the current status of a true parallel databasing support in mysql I'd love to hear about any progress made and how I can help. I tried to subscribe to this mailing list but it seems as if the subscribing system is broken at the moment. Please reply back to my email address, fyi. Thanks, Trevor F. Linton ([EMAIL PROTECTED]) We here at MySQL AB don't have any developers that are working on this. We regard parallel databases something that will be very interesting in the future, but for the moment we have to concentrate on extending the current functionality and the things we have on the TODO for the MySQL 4.x versions. If you start working on this and have any questions about the internals of MySQL, feel free to mail them to [EMAIL PROTECTED] On this mailing list there has been some discussions about parallel servers in the past; Please check some of the searchable email archives that you can find on www.mysql.com for this topic. 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
changing mysql prompt
Hi! Nissim Hi , is there a way to change the default mysql prompt to have the current Nissim GMT time embedded in the mysql command line prompt and look something Nissim like this Nissim (and also have the time increase every time the carriage return is pressed) Nissim [GMT:193/12:13:45] Mysql Nissim [GMT:193/12:13:46] Mysql Nissim : Nissim : Nissim [GMT:193/12:13:58] Mysql Nissim is it possible? Nissim thanks Nissim Nissim Nissim Lugasy Nissim 216-433-2708 Nissim [EMAIL PROTECTED] Nissim For the moment this isn't possible. We have thought a long about providing a configurable prompt for the command line tool but we haven't yet found time to do this. I have now updated our TODO with this, which should ensure that we don't forget about this next time we update the command line client. Regards, Monty - 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: innobase 4gb rows
Hi! I am back from holiday! I guess using SELECT INTO OUTFILE (= mysqldump) and LOAD FROM INFILE is as fast as converting InnoDB-MyISAM-InnoDB. I assume Ryan has a file system with 2 GB files? The outfile or the MyISAM table will be very big. If you do not have 2 GB files then you have to SELECT your table INTO OUTFILE in pieces, not the whole table at a time. Note that the new BLOB code is not well tested yet, though I have not received any bug reports for it. It may be best to experiment first with pieces of your table instead of doing the whole, maybe several hours long, conversion at once. Regards, Heikki http://www.innodb.com Copied message: . On Sat, Jul 14, 2001 at 11:12:21PM -0500, ryc wrote: I have a table that were created using innobase compiled with 64kb page tables. Now I want to upgrade to the newer version of innobase that supports the larger row sizes but as it mentions on the innobase .39b download page ( http://www.innodb.com/download.html ) I must export the tables, and then import them again after upgraded to the new innodb code. The table has 10million rows and takes up 15-20 gigs of disk space, I dont think that mysqldump will work so well on this table. By work so well do you mean work quickly? It may be faste to convert the tables to MyISAM tables, upgrade, and convert them back to InnoDB tables. But I've not compared the speed of the two operations. It's more of a hunch. Jeremy-- Jeremy D. Zawodny, [EMAIL PROTECTED]Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 -- NEW MySQL 3.23.29: up 28 days, processed 216,528,232 queries (86/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
Re: mysql.org
Monty et al and fellow list people, I've been following this thread with interest for the last couple days, have read all the postings (unfortunate flames included), and my opinion has generally been: well, there's been an unfortunate break down in communication between MySQL and NuSphere, I'm sure it's just a mis-understanding, and it'll get sorted out amicably soon. Then I actually went and looked at the mysql.org site. Now I find I must strongly agree with what Andy Wooley wrote: At 15:05 +0100 2001/07/15, Andy Woolley wrote: The impression I get from the .org site, is that they are promoting a product called MySQL, and that MySQL AB (found at mysql.com) is a different product all together. This, is in my opinion is simply not on. I have been using MySQL for many years and I am now wondering if there actually is a difference between MySQL and MySQL AB simply because mysql.org are implying such a fact. Their web site is also giving me the impression that they are responsible for the development of MySQL.I know Nusphere have given both time and money to the development of MySQL but I really don't think it quite justifies building a web site with the intention of deceiving users that may not know the full history of MySQL. I'm no lawyer but I would say that the content on mysql.org is very misleading and should be changed, pronto. I got very much the same impression. Let me expand a bit... 1. it makes sense for an 'Open Source' project to have a .org TLD, many of them do. 2. on the Home page it says: - its a center for free downloads, information and communication, as well as all the files you need to build applications based on MySQL, the #1 open source database. - mySQL.org offers easy access to the best binaries and source available to database programmers. - For those willing to help maintain the code, documentation, or support resources, please email [EMAIL PROTECTED] - For those of you interested in getting other sites or books added to our list of MySQL resources, please send email to [EMAIL PROTECTED] Then, at the bottom, it says that it's not affiliated with some company called 'MySQL AB.' Nowhere does it say that 'MYSQL AB' *is* MySQL: the company that has created, developed, promoted, and is the *owner* of the MySQL database engine. It looks very much like 'MySQL AB' is some other company that happens to have a similar name, especially considering that most people will know it simply as MySQL, not by the formal 'MySQL AB.' So it would be very easy for a recent arrival to assume that mysql.org is *the* MySQL site -- there's really nothing telling them otherwise. The creators of the mysql.org site did not go to any effort to make the situation clear -- on the contrary, it seems to step very carefully *around* mentioning that MySQL is someone else's property. Something like this doesn't happen by accident and, legal-babble aside, these are, quite simply, not the actions of one who's respectful of other's work and property, and not the actions of one who's dedicated to open communication and a win/win partnership. I find it dishonourable. It leaves a pretty bad taste in my mouth. /Robert Alexander Ob. MySQL content: database, sql, query, table ~ Robert Alexander~~ Programmer/Analyst/DBA/Admin WWW Database Applications~~http://www.ra1.net Web Software and Hosting ~~ http://www.workmate.ca The edifice of civil rights has degenerated into a naked spoils system. ... laws have come close to outlawing undesired thought. The iron rule of political correctness has distinct resemblance to Soviet-style social control. Much of this is imposed less by the official government than by the meta- government of academia, media, and Hollywood. Yet it's there. -- Fred Reed - 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: innobase 4gb rows
Note that the new BLOB code is not well tested yet, though I have not received any bug reports for it. It may be best to experiment first with pieces of your table instead of doing the whole, maybe several hours long, conversion at once. Can you tell us a bit more about the BLOB code? In MyISAM you could gain performance by seperating variable part fields from the fixed length fields. Does that still hold for InnoDB tables? (I know that some other databases, like oracle, can do the seperation for you.) Are the blobs slower or faster then the MyISAM counterparts? (Or about as fast, etc.) BLOB / TEXT support was one of the few reasons I haven't tried out InnoDB so far (since I need to store large articles), but now that that limitation is lifted I want to try it out ASAP. Regards, Sander - 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: Somebody kindly get me off this list
At 15:17 -0700 2010-05-02, Angela Neff wrote: I have tried numerous methods as instructed in the mySQL listerserv e-mail to get off this list but am still on it. Can somebody help me out? I got 779 e-mails today. Set your date correctly and try again..! -- Matthias Urlichs - 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 Variables
At 1:47 PM -0500 7/14/01, Paul DuBois wrote: Any solution I've tried using the LassoMySQL/var/my.cnf or ~/.my.cnf files affect both the special installation as well as the standard MySQL installation. I find I will always get the standard port. Settings in the [client] group of your ~/.my.cnf file would affect any client that you run. I would expect that all clients would therefore connect to the same server... The clients won't use the option file in the data directory. They will only use the shared option file /etc/my.cnf, and the .my.cnf in your home directory. You might be better off creating aliases that specify the options on the command line. Thank you Paul with your help so far. As a reminder my situation is having a Mac OS X server with two MySQL server binaries installed (with a complete set of MySQL installed files in the two separate locations). One uses the standard /usr/local/bin location for MySQL the other installs into the Application directory. I am trying to find an easier way to not have to specify the socket option each time I use one of the MySQL client programs for databases hosted by Lasso MySQL. As an example to run these commands they need to use the form: root% ./bin/mysql --socket=/tmp/SpecialMySQL.sock MCExample /Import_MCExample.mysql root% ./bin/mysqlshow --socket=/tmp/SpecialMySQL.sock root% ./bin/mysqladmin --socket=/tmp/SpecialMySQL.sock create newDatabaseName In short, it becomes burdensome to type --socket=/tmp/LassoMySQL.sock each time. So what I am left with is that I will need to create a startup file to map the command you type in to the actual command with the -socket specified? Example, create a .cshrc (Mac OS X uses the tcsh shell) and locate it in my user directory or in /etc (I am not sure about this?). Set up the alias lines as follows: alias mysqldump /Applications/special/specialMySQL/bin/mysqldump --socket=/tmp/SpecialMySQL.sock alias mysqladmin /Applications/special/specialMySQL/bin/mysqladmin --socket=/tmp/SpecialMySQL.sock alias mysql /Applications/special/specialMySQL/bin/mysql --socket=/tmp/SpecialMySQL.sock I would actually need to use a somewhat different name for the alias as this will interfere with use of the command for the standard install. The question though is will parameters be passed in? Will it then work, for example, to import a file using: root% mysql MCExample /Import_MCExample.mysql I cannot test it since so far the alias file idea does not work, I put the .cshrc file into my home directory, logged out and started a new telnet session. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.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[2]: Problem inserting array of rows
Now the problem is it only inserts one row into the table, when there should be more than one row inserted. Of course it does, you have to enclose the insert statement into your for loop. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - 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.org
Well, I have gone and looked more closely at mysql.org. I am forced to confess that I find several disheartening features at this site. I am unwilling at this juncture to typify these issues as deliberate or ill-intentioned, but I will say that NuSphere needs to make a concerted, immediate effort to resolve these points. 1) While they do point out that they are not affliated, and provide a link to MySQL AB, they do not state why this is relevant, or why someone might WANT to go to MySQL AB. 2) They do not explicitly claim to be the developers of MySQL, but they also do not explicitly state that they are not. While experienced MySQL users would recognize this fact, new-comers or persons searching for information in support of a product decision would most likely not recognize that distinction. 3) The tone and content of the requests for participation and assistance in development do suggest that participating in the NuSphere mysql.org development effort is identical to participating in MySQL development, which is clearly not the case. In my opinion, Nusphere needs to take the following actions immediately: 1) Explicitly and prominently identify on their front page, the ownership of the MySQL trademark as belonging to MySQL AB, and point at the mysql.com website. 2) Clearly delineate the difference between NuSphere MySQL and MySQL, on the front page, and prominently. 3) Cause their site not to resemble mysql.com in any way related to design or format. 4) NuSphere needs to clarify the extent and nature of their investments in MySQL. Investment in their inhouse products does not qualify as investment in the MySQL server product. Monies paid to MySQL AB, subject to the details of whatever agreements said monies were paid under, may qualify. None of these are onerous, and doing these things will go a long way to putting NuSphere back into good graces with this community and with the folks at MySQL AB. As a separate issue, I will offer my comments re: the domain name/trademark dispute: It is my opinion that regardless of what rights NuSphere may believe, correctly or otherwise, they have to the use of the MySQL trademark, that the only honorable and acceptable action for them to take is to transfer the domain name to MySQL AB immediately. This is a matter of ethics and courtesy (and good PR), not legality. As for the issue of trademark infringement and protection, it is true that failure to take appropriate legal action to defend a trademark can, and sometimes does, lead to loss of legal protection for that trademark. This being the case, NuSphere and MySQL AB need to work up a written agreement which asserts that the trademark MySQL does explicitly belong to MySQL AB, and that NuSphere formally acknowledges that ownership. Such an agreement gives MySQL AB proof of defense, which is their largest single concern (in my interpretation). The actual use of the trademark by NuSphere is an issue that should be settled betwen NuSphere and MySQL, or in the courts, if that unfortunate necessity arises. - 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[4]: Mysql++ and Gcc 3.0 compile problems
Do someone see improvements compiling Mysql with Gcc 3.0 ? SM What improvements would you like to see in the compiled library ?? In fact I just wanted to know if there is any advantage to use Gcc 3.0 for compiling Mysql. Regards, Alex. - 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 Variables
At 11:09 AM -0700 7/15/01, Michael Collins wrote: At 1:47 PM -0500 7/14/01, Paul DuBois wrote: Any solution I've tried using the LassoMySQL/var/my.cnf or ~/.my.cnf files affect both the special installation as well as the standard MySQL installation. I find I will always get the standard port. Settings in the [client] group of your ~/.my.cnf file would affect any client that you run. I would expect that all clients would therefore connect to the same server... The clients won't use the option file in the data directory. They will only use the shared option file /etc/my.cnf, and the .my.cnf in your home directory. You might be better off creating aliases that specify the options on the command line. Thank you Paul with your help so far. So what I am left with is that I will need to create a startup file to map the command you type in to the actual command with the -socket specified? Hey, maybe I answered part of my own question (thanks to the book Essential System Administration from O'Reilly). There is a file on Mac OS X at: /usr/share/init/tcsh/rc that starts with the following: ## # TCSH Expanded C-Shell INITIALIZATION FILE # # Wilfredo Sanchez Jr. | [EMAIL PROTECTED] # July 09, 1992 # # MIT Project Athena # # ORIGINAL SOURCES: /usr/athena/lib/init/cshrc (ATHENA REL 7.3P) ## Adding the following and restarting the telnet session seems to work: alias specialmysqldump /Applications/Special/SpecialMySQL/bin/mysqldump --socket=/tmp/SpecialMySQL.sock alias specialmysqladmin /Applications/Special/SpecialMySQL/bin/mysqladmin --socket=/tmp/SpecialMySQL.sock alias specialmysql /Applications/Special/SpecialMySQL/bin/mysql --socket=/tmp/SpecialMySQL.sock I now get the list of databases for the Special installation when using specialmysql as a command. And if I use with parameters or redirect to a file it also works: specialmysqldump --opt special_site_1 /temp.mysql And this actually added a database called special: root% specialmysqladmin create special Hurray! -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql.org
1) While they do point out that they are not affliated, and provide a link to MySQL AB, they do not state why this is relevant, or why someone might WANT to go to MySQL AB. Hmmm.. The NuSphere people may not be saying very much on this list, but they're certainly listening in on what's being said! The reference to MySQL AB was not there when I started this discussion of missing links to the .com site 6 hours ago, and judging from the HTTP header and the timestamp of your mail, you hit their site just 10-15 minutes after their last update of the front page. I, for one, am happy to see that this sort of discussion *does* lead to changes being made. I must say that I am very impressed with the level of the discussion in this thread. Though many feel an emotional attachment to the One and only MySQL, people such as Justin and Jeremy have helped keeping everybodys heads up above the murky waters of flames and sticking very close to the facts, trying to unravel what's going on - very unlike e.g. the discussions taking place on /. Kudos also to the MySQL team for following up very fast on questions regarding what has been communicated between them and the NuSphere people, leaving no-one to try and guess the facts. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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[2]: mysql.org
On Saturday, July 14, 2001, 9:25:51 PM, you wrote: snip JN GPL violation or not, part of my decisions are always based on JN morals (hard to find these days). Anyone trying to capture an JN audience using anothers name is un-ethical and un-moral. My JN business decision will be made with this in mind. Sometimes it is JN not the best business decision but I can always live with it. JN Joel Nelson A lot has been said during this discussion. You covered the points I think are most important. I've learned a lot. I did not, for example, know (or remember, most likely) that Paul DuBois is employed by NuSphere. This isn't terribly relevant to the issues involved, but it does underscore the point that this is a pretty mixed-up business. I own Paul's book and will purchase the next one. I appreciate NuSphere's support of such a useful addition to the body of documentation available. However, that said, the only way NuSphere will come out of this situation unsullied is by deciding to do the right thing. The right thing, in this case, has nothing to do with what lawyers decide they can get away with. I always worry about any entity, whether individual or collective, that constantly expresses expectations or intentions using phrases including the terms rights, legal, etc. This is generally a red flag indicating every intent to take the unethical, immoral, or amoral, course. This isn't all that difficult an issue to reconcile, in my opinion. One post described a lot of the messages dealing with this issue (including my initial message, I suspect) as knee-jerk. Generally, in issues involving morality and ethics, a knee-jerk reaction is the one most likely to produce the correct answer. We often instinctively know whether something feels right or not. It's only after the justifications and rationalizations have messed with our minds that we begin to have difficulty knowing what the right thing is. In this issue, MySQL clearly belongs to MySQL AB, and so do the domains in question. I've looked at the .org site. With that in mind: NuSphere, please don't insult my intelligence by maintaining the pretense that the site is purely benevolent in intent. This reminds me of something that passes through my mind frequently when I hear politicians speak: Either this guy is stupid, or he thinks I am. Either way, I won't waste my time listening to him. Benevolence, good intentions, a legitimate and sincere desire to contribute to the success of MySQL are easily proven: Just turn over the domain name. It's incredibly simple to right the wrong here, unless, again, you allow yourself to rationalize and justify your actions, to convince yourself that shrewdness is an acceptable substitute for rightness. Sometimes, a shrewd course of action results in financial profit (albeit at the expense of conscience). In this case, everyone will lose, I predict, unless the right thing is done, especially NuSphere, judging from the knee-jerk comments, which is as it should be. If you really have an insatiable desire impress the MySQL community with your benevolence, perhaps MySQL AB would be happy to let you use mysqlmongers.org or another name that more clearly and ethically conveys your intent. Mark Chalkley - 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
Replication Drama
Hi there I have a triangular replication setup, works like a dream In my haste I went and created a table in Site A's database, and then dialled into Site B and created the table. As yet I haven't done a slave start to start the replication process because I caught onto my vital mistake. i.e. The replication will now complain that Site B already contains a table called some_tablename. So, my question is, what do I do about this? Is there a way of getting it to skip the create or can I delete one of them but if I delete it, Site C will complain that the table does not exist, Site A won't update because the table exists and the Add table was the first command, etc etc etc, turns into a vicious loop. Is there a way I can recover from this? Regards Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 - 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
Heap Tables
Hello When I store some data in a table of type Heap, this data will be lost when the server is shutdown (and later restarted), won't it? Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 6 hours 7 minutes - 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 command for which tables supported?
Hello, Is there a command to see which tables are supported by mysql from the mysql prompt? when I am telneted into my remote server? Ken - 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: Heap Tables
Hello When I store some data in a table of type Heap, this data will be lost when the server is shutdown (and later restarted), won't it? Correct. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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: Heap Tables
So sprach »Fournier Jocelyn [Presence-PC]« am 2001-07-15 um 23:37:57 +0200 : Hi, Definitely yes :) But the table structure won't be lost. Thanks to all who replied! filter: sql Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 6 hours 56 minutes - 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 command for which tables supported?
Hello, Is there a command to see which tables are supported by mysql from the mysql prompt? when I am telneted into my remote server? mysql SHOW VARIABLES; - look at lines starting with have_ ... / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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 Variables
At 12:39 PM -0700 7/15/01, Michael Collins wrote: At 11:09 AM -0700 7/15/01, Michael Collins wrote: At 1:47 PM -0500 7/14/01, Paul DuBois wrote: Any solution I've tried using the LassoMySQL/var/my.cnf or ~/.my.cnf files affect both the special installation as well as the standard MySQL installation. I find I will always get the standard port. Settings in the [client] group of your ~/.my.cnf file would affect any client that you run. I would expect that all clients would therefore connect to the same server... The clients won't use the option file in the data directory. They will only use the shared option file /etc/my.cnf, and the .my.cnf in your home directory. You might be better off creating aliases that specify the options on the command line. Thank you Paul with your help so far. So what I am left with is that I will need to create a startup file to map the command you type in to the actual command with the -socket specified? Hey, maybe I answered part of my own question (thanks to the book Essential System Administration from O'Reilly). There is a file on Mac OS X at: /usr/share/init/tcsh/rc that starts with the following: ## # TCSH Expanded C-Shell INITIALIZATION FILE # # Wilfredo Sanchez Jr. | [EMAIL PROTECTED] # July 09, 1992 # # MIT Project Athena # # ORIGINAL SOURCES: /usr/athena/lib/init/cshrc (ATHENA REL 7.3P) ## Adding the following and restarting the telnet session seems to work: alias specialmysqldump /Applications/Special/SpecialMySQL/bin/mysqldump --socket=/tmp/SpecialMySQL.sock alias specialmysqladmin /Applications/Special/SpecialMySQL/bin/mysqladmin --socket=/tmp/SpecialMySQL.sock alias specialmysql /Applications/Special/SpecialMySQL/bin/mysql --socket=/tmp/SpecialMySQL.sock I now get the list of databases for the Special installation when using specialmysql as a command. And if I use with parameters or redirect to a file it also works: specialmysqldump --opt special_site_1 /temp.mysql And this actually added a database called special: root% specialmysqladmin create special Hurray! Sounds like that should do it. (O'Reilly also has a book Using csh tcsh specifically on the shell that you're using that has a chapter on startup files and another on aliases. It's written by, er ... never mind.) -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com -- Paul DuBois, [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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[ANN] MySQLConnect for 4D 1.0 Demo
FOR IMMEDIATE RELEASE Exenevex, SA ( http://www.exenevex.com ) announces release of MySQLConnect for 4D 1.0 demo version Paris, France - Monday, July 16th, 2001: Exenevex, SA, today announced the release of demo version of MySQLConnect for 4D 1.0 (MacOS Windows). MySQLConnect for 4D is a 4th Dimension plugin which provides connection routines between 4th Dimension-4D Server-4D Runtime-4D Runtime Classic- Engined 4D applications and MySQL Databases Servers. WHAT'S MYSQL ? MySQL is a very popular open source RDBMS that comes with 70% of web hosting plans over the world. MySQL runs on several systems like Linux, FreeBSD, Windows NT/2000, MacOS X, Mac OS X Server and moreMySQL is mainly used with Apache/Php to build dynamic web sites for eBusiness solutions. For more informations about MySQL, please visit : http://www.mysql.com For more informations about Apache, please visit : http://www.apache.org For more informations about PHP, please visit : http://www.php.net FEATURES Using MySQLConnect for 4D, 4D developers have a set of 4D routines to manage : - Connections to/Disconnection from MySQL Databases Servers - Structure SQL queries (Create/Alter/Drop Databases Tables) - Data SQL queries (Insert/Update/Delete data) - Administration SQL queries (Grant/Revoke ...) - Support for 4D datatypes including BLOB PICTURE data types - Internal mecanisms to manage simple quotes used in SQL queries Using MySQLConnect for 4D, 4D developers can create well designed systems to manage, exchange, synchronize 4D Applications with eBusiness web hosted solutions, or simply use 4D as a GUI generator for distant MySQL systems. MySQLConnect for 4D 1.0 doesn't use any external librairy to work with MySQL Databases Servers and returns real good performances. MySQLConnect for 4D 1.0 is the first release in a suite of data management oriented 4D Plugins that will be released soon by Exenevex, SA. PRICING AVAILABILITY MySQLConnect for 4D 1.0 MacOS MySQLConnect for 4D 1.0 Windows will be available to orders very soon directly from our secured store area at http://www.4ee4.com. Orders will be accepted using credit cards in USD and Euro. Pricing and licencing issues will be exposed at the same time. DOWNLOAD MACOS WIN DEMO VERSIONS You can immediatly download demo versions of MySQLConnect for 4D (MacOS Windows) with documentation at http://www.exenevex.com/dev/demoform.html For more informations, contact : [EMAIL PROTECTED] ABOUT EXENEVEX, SA. Based in Paris, France, Exenevex SA was founded in 1998 by Stéphane Pinel to provide development and consulting services for MacOS, MacOS X, Windows Unix platforms. Specifically, Exenevex SA develops softwares and development tools around different RDMS. For more informations about Exenevex SA, please contact : [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 command for which tables supported?
At 2:05 PM -0700 7/15/01, Ken Sommers wrote: Hello, Is there a command to see which tables are supported by mysql from the mysql prompt? when I am telneted into my remote server? Yes, it's in the MySQL Reference Manual under SHOW TABLES. :-) http://www.mysql.com/doc/S/H/SHOW.html Ken -- Paul DuBois, [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.org
On Sat, Jul 14, 2001 at 07:59:14AM -0700, Michael Collins wrote: Thank you, Michael, for accidentally posting this. :) At 3:10 AM -0400 7/14/01, Britt Johnston wrote: Well, what a mess. It is regretable that this legal issue needs to be aired so publically that was certainly not my preference. I also will not get into a flame war, it is not in the best interest of mysql. I appreciate all the email I've received with advice and/or support - thanks. It is important that everyone realize that there is a legal agreement that both Monty and David personally signed that provides NuSphere broad rights around the use of the MySQL name. That agreement also allows NuSphere to release MySQL under the GPL license forever and print and distribute the manual. We paid significant money to Monty and David in exchange for that agreement which was central to forming NuSphere. This is public record. NuSphere has created a public image problem for itself, and seems to be oblivious to it. I haven't seen the agreement between NuSphere and MySQL AB. I assume that it was signed by both parties in good faith. I assume that each party is astonished at the other party's interpretation of their agreement. The contract was signed, if I recall correctly, in Bedford MA, so the laws of the state of MA will apply. I don't know anything about business law in MA, but I know that American common law uses the principle that a contract is not binding unless both parties provide something of value. I know what NuSphere was supposed to privide under the contract: $2.5 million. What MySQL AB was supposed to privide in return has never been explained. I know that in reality NuSphere paid ~$350,000. I have no idea what it received in return, if anything. However, MySQL AB has made the following claims about the agreement, and NuSphere hasn't denied the claims: 1) It was an interim agreement. An interim agreement that gave one party rights to another party's trademark even after the two parties failed to negotiate a permanent agreement would be somewhat unusual. 2) The agreement called for NuSphere to pay MySQL AB $2.5 million. Only slightly over 10% of the money was paid. Normally, one party cannot enforce the terms of a contract if they themselves have failed to fulfill its terms. 3) MySQL AB has informed NuSphere that the agreement is terminated. NuSphere has not explained why it believes the contract is still in force. Please consider these facts when you try to understand NuSphere's rights and motivations - we actually worked hard to get the details in writing before we even started the company and we paid real money. It is under this agreement that we believe we have a clear right to use mysql.org. See above. This right isn't clear to anyone except NuSphere. MySQL AB's right to the trademark is clear to everyone. Now it appears there is a need by MySQL AB to characterize that agreement as no longer in effect - I hope you can respect the fact that NuSphere believes it is fully in effect and we wish to continue to abide by it. This is the central issue and public debate will not resolve it. No, but NuSphere's public statements influence our perception of the matter. NuSphere has not explained why an interim contract whose terms NuSphere didn't fulfill is still in force. (The last sentence describes the perception NuSphere has created. I have no idea if it describes the reality.) As far as mysql.org goes, what NuSphere would like to see is a non-profit organization running that site - we have been consistent in this desire for over a year, but it has been opposed by Monty and David. I discussed this with Monty as recently as a few weeks ago in June and July and as always he was not interested - I appreciate he is entitled to that opinion as I am entitled to believe that it is time to take this step in the MySQL community. I invite all those who are skeptical to join mysql.org and be part of its formation. I think mysql.org is dead in the water unless you can persuade developers that you have a right to the name and the site serves some useful purpose. Under present circumstances, mysql.org is doing NuSphere more harm than good. [BTW, the first community action was to get rid of the registration requirement at the site - it is no longer required for downloading files rather it is a membership registration only now.] As far as NuSphere's contribution to MySQL, it is disappointing to see our efforts discounted so quickly. At a minimum there are specific bug fixes, features, and language statements focused around transaction support in the server that are in MySQL due to NuSphere's efforts in cooperation with Monty. The Gemini table handler itself is already part of MySQL and is licensed under the GPL - go find ha_gemini.cc and you will see it we checked it in long ago in V4 and again in 3.23 when V4 was late. The Gemini component itself will
Re: mysql command for which tables supported?
I must be missing something. Where does this tell me that this server supports ISAM and MyISAM tables but that server supports InnoDB, BDB, Isam and MyISAM tables. Paul DuBois wrote: At 2:05 PM -0700 7/15/01, Ken Sommers wrote: Hello, Is there a command to see which tables are supported by mysql from the mysql prompt? when I am telneted into my remote server? Yes, it's in the MySQL Reference Manual under SHOW TABLES. :-) http://www.mysql.com/doc/S/H/SHOW.html Ken -- Paul DuBois, [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
beowulfen and mysql
Howdy. My company needs to implement a data mining setup. I am building a cluster using dual athlons and perhaps firewire instead of 100baseTX. I need to find out as much as I can from those who have done mysql on beowulfen. Please contact me at [EMAIL PROTECTED] Thanks :) +++ Joey Kelly /Minister of the Gospel | Computer Networking Consultant/ http://nolalinuxcoop.dhs.org/~jkelly/home/ Experience hath shewn, that even under the best forms [of government] those entrusted with power have, in time, and by slow op erations, perverted it into tyranny. - Thomas Jefferson - 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
beowulfen and mysql
Howdy. My company needs to implement a data mining setup. I am building a cluster using dual athlons and perhaps firewire instead of 100baseTX. I need to find out as much as I can from those who have done mysql on beowulfen. Please contact me at [EMAIL PROTECTED] Thanks :) +++ Joey Kelly /Minister of the Gospel | Computer Networking Consultant/ http://nolalinuxcoop.dhs.org/~jkelly/home/ Experience hath shewn, that even under the best forms [of government] those entrusted with power have, in time, and by slow op erations, perverted it into tyranny. - Thomas Jefferson - 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 Variables
At 6:12 PM -0500 7/15/01, Paul DuBois wrote: Sounds like that should do it. (O'Reilly also has a book Using csh tcsh Actually, after having problems finding this file I started looking for a reference to buy and came across Using csh tcsh and did recognize the author. This book has a 1995 release date on it which in internet time makes it an antique, but in the case of Unix probably not a whole lot has changed I imagine. Nevertheless, it would be a dream if you could write the version of Using tcsh specifically for Mac OS X. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com database,sql,query,table - 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 installing under solaris 2.5.1
I am trying to compile mysql by it is failing in the ./configure step. I am running solaris 2.5.1 , gcc 2.95, binutils 2.11.2. It fails with the following error ./configure -prefix=/usr/local/mysql . . loading cache ./config.cache checking for a BSD compatible install... ./install-sh -c checking for bison... no checking for byacc... no checking for pdftex... no checking return type of sprintf... configure: error: can not run test program while cross compiling any help would be greatly appreciated. regards Imran.
Re: mysql command for which tables supported?
At 4:51 PM -0700 7/15/01, Mike Wexler wrote: I must be missing something. Where does this tell me that this server supports ISAM and MyISAM tables but that server supports InnoDB, BDB, Isam and MyISAM tables. In that case, you want SHOW VARIABLES, which shows the table *types* supported among the variable list. But that was not the original question. Or at least that's not what it sounded like to me. Paul DuBois wrote: At 2:05 PM -0700 7/15/01, Ken Sommers wrote: Hello, Is there a command to see which tables are supported by mysql from the mysql prompt? when I am telneted into my remote server? Yes, it's in the MySQL Reference Manual under SHOW TABLES. :-) http://www.mysql.com/doc/S/H/SHOW.html Ken -- Paul DuBois, [EMAIL PROTECTED] -- Paul DuBois, [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: Client Command Line interface auto compellation 3.23.39
Yep, some things work others don't. if I type shtab then I get 'show ' seltab give 'select ' but I thought I was able to type select * from tbltab and that this used to give me all a list of all the table names that started with tbl (or if there was only one it would just auto complete it of course). Now I just get the mysql commands and none of the nice tablename and fieldname completion that I'm sure used to be there (or was I just wishfully dreaming??). Here's the full list of what I get if I just press tab without entering anything: ? ego notee show fields from alter table exit pager show keys from clear explain print show tables connect goquit source create database help rehashstatus create table insertreplace tee deleteload data fromselectunlock tables drop lock tables set optionupdate edit nopager show databasesuse interestingly, if I type shtab I get 'show ' but if I type show tatab I don't get 'show tables' which is what I would expect. If there is anything else that I can provide to help sort this out I'd be only too happy to. cheers, noel On Friday, July 13, 2001 9:59 PM, Sinisa Milivojevic [SMTP:[EMAIL PROTECTED]] wrote: Noel Clarkson writes: Hi all, When using the 3.23.39 client to connect to the server, pressing tab to complete table names and field names etc doesn't seem to work. I seem to get the mysql commands, but I thought in past clients I was able to get table name and field name completion as well. Have others noticed this or is it just me who's lucky?!? I'm using the rpm off the mysql site, maxsql is also installed (from rpm) and it's on a red hat 6 box. cheers, noel It works for me ... Try first to type in some command, then try TAB ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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 - 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
empty mysql_install_db file in sol8 i386 distribution
SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: oliver To: [EMAIL PROTECTED] Subject: empty mysql_install_db file in sol8 i386 distribution Description: I'm running down the list of installation shell commands as indicated by http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#In stalling_binary I am using GNU tar. But the scripts/mysql_install_db file is empty. when i get to the last command to actually start mysql I get the following error 'Starting mysqld demon with databases from /usr/local/mysql-3.23.39-pc-solaris2.8-i386/data' 'Segmentation Fault - core dumped' '010707 21:33:19 mysql ended' How-To-Repeat: execute bin/safe_mysqld --user=mysql Fix: unknown Submitter-Id: submitter ID Originator: Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-3.23.39 (Official MySQL binary) Environment: machine, os, target, libraries (multiple lines) System: SunOS 5.8 Generic i86pc i386 i86pc Architecture: i86pc Some paths: /usr/bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/i386-pc-solaris2.8/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions - fno-rtti' LDFLAGS='' LIBC: -rw-r--r-- 1 root bin 1555316 Jan 5 2000 /lib/libc.a lrwxrwxrwx 1 root root 11 Jun 24 18:52 /lib/libc.so - ../libc.so.1 -rwxr-xr-x 1 root bin 918640 Jan 5 2000 /lib/libc.so.1 -rw-r--r-- 1 root bin 1555316 Jan 5 2000 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Jun 24 18:52 /usr/lib/libc.so - ../libc.so.1 -rwxr-xr-x 1 root bin 918640 Jan 5 2000 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --disable-shared Perl: This is perl, version 5.005_03 built for i86pc-solaris - 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: beowulfen and mysql
First, lets make sure we're all talking about the same thing. A general definition of data mining would be the automated extraction of predictive information from large databases. Automated implies some sort of agent, and by its very nature the predictions are statistical (hence the large data sets). Most agents that I have seen could be classified as decision tree, neural network, or genetic algorithm. Note that data mining is not considered to be data warehousing, ad hoc querying, OLTP or visualization. Are you trying to build some sort of predictive model? Perhaps you can describe it a bit further. In general, once you pick an algorithm or approach you would have to build an application layer above your query layer. I imagine you would do that in C, for speed. You probably want to read about MySQL replication here http://www.mysql.com/documentation/mysql/bychapter/manual_Replication.html#R eplication Now, regarding Beowulf clusters. They are defined as (by the people that created it, Donald Becker and company) solely a computational cluster and not something geared toward data mining. You certainly can learn some great lessons from their architecture (channel bonded ethernet or myrinet) but don't expect them to answer any questions in the database arena! Regards, Gary SuperID Huntress === FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org - Original Message - From: Joey Kelly [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, July 15, 2001 8:26 PM Subject: beowulfen and mysql Howdy. My company needs to implement a data mining setup. I am building a cluster using dual athlons and perhaps firewire instead of 100baseTX. I need to find out as much as I can from those who have done mysql on beowulfen. Please contact me at [EMAIL PROTECTED] Thanks :) +++ Joey Kelly /Minister of the Gospel | Computer Networking Consultant/ http://nolalinuxcoop.dhs.org/~jkelly/home/ Experience hath shewn, that even under the best forms [of government] those entrusted with power have, in time, and by slow op erations, perverted it into tyranny. - Thomas Jefferson - 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 installing under solaris 2.5.1
Shouldn't it be ./configure --prefix=/usr/local/mysql On Mon, 16 Jul 2001 12:44, you wrote: I am trying to compile mysql by it is failing in the ./configure step. I am running solaris 2.5.1 , gcc 2.95, binutils 2.11.2. It fails with the following error ./configure -prefix=/usr/local/mysql . . loading cache ./config.cache checking for a BSD compatible install... ./install-sh -c checking for bison... no checking for byacc... no checking for pdftex... no checking return type of sprintf... configure: error: can not run test program while cross compiling any help would be greatly appreciated. regards Imran. - 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 installing under solaris 2.5.1
You need to make sure that the gcc on your box is build on that box, Using a package won't do it, most of them where compiled on greater or lesser hardware versions than you might be running, This in turn causes the compiler it self to think that its running in cross-compile mode and mysql won't allow a cross compile(er) build. Martin Cameron wrote: Shouldn't it be ./configure --prefix=/usr/local/mysql On Mon, 16 Jul 2001 12:44, you wrote: I am trying to compile mysql by it is failing in the ./configure step. I am running solaris 2.5.1 , gcc 2.95, binutils 2.11.2. It fails with the following error ./configure -prefix=/usr/local/mysql . . loading cache ./config.cache checking for a BSD compatible install... ./install-sh -c checking for bison... no checking for byacc... no checking for pdftex... no checking return type of sprintf... configure: error: can not run test program while cross compiling any help would be greatly appreciated. regards Imran. - 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
about the mkstemp64 in mysql3.23.39
hi, I have some question about the mysql3.23.39 in my linux686 system when I configure it neither CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti ./configure --prefix=/usr/local/mysql --enable-assembler --with-mysqld-ldflags=-all-static nor ./configure directly, error comes out when make, gcc -O3 -DDBUG_OFF -O3 -mpentiumpro -felide-constructors -fno-exceptions -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rttm ../libmysql/.libs/libmysqlclient.a(mf_tempfile.o): In function `create_temp_file': mf_tempfile.o(.text+0x104): undefined reference to `mkstemp64' collect2: ld returned 1 exit status make[2]: *** [mysql] Error 1 make[2]: Leaving directory `/home/agent/mysql-3.23.39/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/agent/mysql-3.23.39' make: *** [all-recursive-am] Error 2 why??? what is the mkstemp64? how to solute the trouble? thanks to email me Johnson 2001/07/16 === ΪÄã¶ø½¨£¬ÎªÄã¶øÉ裬ÈÃÄã´«µÝÕæÐÄÕæÒâ 163.netºØ¿¨Õ¾£¨http://ecard.163.net£© 163µç×ÓÓʾÖȫзîÏ×£¬¾«²ÊÎÞÏ޵ĵç×Ӻؿ¨Õ¾¡£ === - 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
Running multiple MySQL servers on one machine
Hi, I was wondering if anyone has any opinions on the advantages and disadvantages of running multiple servers on one machine. Each server would be used to access different databases. Note also that these databases will both be replicated and there shall be multiple machines. Possibly some machines would be replicate one database but not the other. would it be more desirable given these circumstances to run multiple servers on the master, to facilitate the synchronisation of the two databases? thanks in advance, William - 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: I am facing this error [ Urgent ]
Thanks for your replies but my problem is still there this is the php code iam using for connecting to Database: $ss_conn = mysql_connect($db_host,$db_usr,$db_pwd); and hosting infos are: Red hat linux mysql-3.23 php 4 From the error message, I'd guess you are using RedHat distribution. If not, ignore this. You must make sure that the directory /var/lib/mysql is owned by mysql and not root, so that mysql can write to it. Also see all the added comments in the relevant subsections of the online manual (link is added to all posts at the end). They are constantly being added to. Hope this helps. Edna At 19:12 11/07/01 -0700, you wrote: What to do do I am facing this error !! Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /web/sites/188/pisps/www.pisps.f2s.com/signup/index.php on line 372 Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) - 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: Client Command Line interface auto compellation 3.23.39
Yep, some things work others don't. if I type shtab then I get 'show ' seltab give 'select ' but I thought I was able to type select * from tbltab and that this used to give me all a list of all the table names that started with tbl (or if there was only one it would just auto complete it of course). Now I just get the mysql commands and none of the nice tablename and fieldname completion that I'm sure used to be there (or was I just wishfully dreaming??). Here's the full list of what I get if I just press tab without entering anything: ? ego notee show fields from alter table exit pager show keys from clear explain print show tables connect goquit source create database help rehashstatus create table insertreplace tee deleteload data fromselectunlock tables drop lock tables set optionupdate edit nopager show databasesuse interestingly, if I type shtab I get 'show ' but if I type show tatab I don't get 'show tables' which is what I would expect. Does show tables actually produce a list of tables, or no tables? On some systems, there is a bug in glibc that prevents it from working properly, in which case auto-completion won't work. (I have one such system, and I see the same behavior you do, even if I type rehash to force re-hashing of the names.) -- Paul DuBois, [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: I am facing this error [ Urgent ]
Have you checked that you've got a musql server running. (ps ax|grep mysqld) On Fri, 13 Jul 2001 05:51, you wrote: Thanks for your replies but my problem is still there this is the php code iam using for connecting to Database: $ss_conn = mysql_connect($db_host,$db_usr,$db_pwd); and hosting infos are: Red hat linux mysql-3.23 php 4 From the error message, I'd guess you are using RedHat distribution. If not, ignore this. You must make sure that the directory /var/lib/mysql is owned by mysql and not root, so that mysql can write to it. Also see all the added comments in the relevant subsections of the online manual (link is added to all posts at the end). They are constantly being added to. Hope this helps. Edna At 19:12 11/07/01 -0700, you wrote: What to do do I am facing this error !! Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /web/sites/188/pisps/www.pisps.f2s.com/signup/index.php on line 372 Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) - 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 installing under solaris 2.5.1
On 16-Jul-01, Colin Faber said something totally profound about Re: Problems installing under solaris 2.5.1 that made me ponder... CF You need to make sure that the gcc on your box is build on that box, CF Using a package won't do it, most of them where compiled on greater or CF lesser hardware versions than you might be running, This in turn causes CF the compiler it self to think that its running in cross-compile mode CF and mysql won't allow a cross compile(er) build. I've been using gcc packages from SunFreeware.com for the last couple of years. I've not run into this problem yet. I have also always kept my version of gcc recent, and have had no problems compiling, installing, or running MySQL binaries created by gcc v3.0. However, this question (installation problems on Solaris with the cross compile error message) has been asked and answered on this list NUMEROUS times. To quote every message on this list: Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) [snip] CF CF loading cache ./config.cache CF checking for a BSD compatible install... ./install-sh -c CF checking for bison... no CF checking for byacc... no CF checking for pdftex... no CF checking return type of sprintf... configure: error: can not run test CF program while cross compiling You don't have bison, which is recommended, although off the top of my head I can't remember where I read that. I've been using the instructions detailed on my page below for quite some time now, without incident. The source of the page details from where I compiled the information. Please keep in mind that that is a bare minimum install, and you may have other options you wish to use. http://users.talstar.com/forager/MySQL-HOWTO.html This has worked for SPARC Solaris 2.4, 2.5.1, 2.6, and 7, as well as Intel Solaris 7 and 8. Good luck. -- Alan W. Rateliff, II: YourVillage.com Assistant Systems Administrator : 2700 Apalachee Pkwy [EMAIL PROTECTED] : Tallahassee, FL 32301 (850) 942-7021--- [EMAIL PROTECTED] http://support.yourvillage.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: Client Command Line interface auto compellation 3.23.39
cut interestingly, if I type shtab I get 'show ' but if I type show tatab I don't get 'show tables' which is what I would expect. Does show tables actually produce a list of tables, or no tables? On some systems, there is a bug in glibc that prevents it from working properly, in which case auto-completion won't work. (I have one such system, and I see the same behavior you do, even if I type rehash to force re-hashing of the names.) Thanks Paul rehash fixed my problems with it not showing up (I've never had to use rehash before). I was actually getting a list of tables with show tables, now the only thing that doesn't work is the two worded commands where one word is common to multiple commands (eg show tables, show database etc completes the show but then thinks that it is the start of another separate command for the next word - and tables or database aren't commands), but I guess that's a reasonable thing because there might be times when that behaviour is needed. cheers, noel - 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: I am facing this error [ Urgent ]
This is a very common problem. It is documented in the manual and also in other places as Edna has already mentioned. Your php code has nothing to do with the cause of the problem. Basics: 1. Your server isn't running 2. Your paths to the socket file are incorrect. (Check php and mysql settings) 3. Permissions are incorrect. - Original Message - From: Syed Sumair [EMAIL PROTECTED] To: Edna Walton [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, July 13, 2001 1:51 Subject: Re: I am facing this error [ Urgent ] Thanks for your replies but my problem is still there this is the php code iam using for connecting to Database: $ss_conn = mysql_connect($db_host,$db_usr,$db_pwd); and hosting infos are: Red hat linux mysql-3.23 php 4 From the error message, I'd guess you are using RedHat distribution. If not, ignore this. You must make sure that the directory /var/lib/mysql is owned by mysql and not root, so that mysql can write to it. Also see all the added comments in the relevant subsections of the online manual (link is added to all posts at the end). They are constantly being added to. Hope this helps. Edna At 19:12 11/07/01 -0700, you wrote: What to do do I am facing this error !! Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /web/sites/188/pisps/www.pisps.f2s.com/signup/index.php on line 372 Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) - 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: Client Command Line interface auto compellation 3.23.39
At 1:32 PM +1000 7/16/01, Noel Clarkson wrote: cut interestingly, if I type shtab I get 'show ' but if I type show tatab I don't get 'show tables' which is what I would expect. Does show tables actually produce a list of tables, or no tables? On some systems, there is a bug in glibc that prevents it from working properly, in which case auto-completion won't work. (I have one such system, and I see the same behavior you do, even if I type rehash to force re-hashing of the names.) Thanks Paul rehash fixed my problems with it not showing up (I've never had to use rehash before). I was actually getting a list of tables with show tables, now the only thing that doesn't work is the two worded commands where one word is common to multiple commands (eg show tables, show database etc completes the show but then thinks that it is the start of another separate command for the next word - and tables or database aren't commands), but I guess that's a reasonable thing because there might be times when that behaviour is needed. You might wanna check to see if you have no-auto-rehash specified in your .my.cnf file. That's probably not so if completion worked before, but ... cheers, noel -- Paul DuBois, [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
Where to find help??
Where is a good place to find help with some basic sql? I am having a problem getting the query results I need. Don't tell me to consult the manual because that is the first place I turned to. I just need a real life example of the solution to see be able to pick it apart. I posted the request to this list (see Two table query help...) and only got one off-list reply that didn't help. Is there a better place to get such assistance or a better way of requesting it here??? -- A Newbie
Version 3.22.32 Source to upgrade??
I am spending considerable time working with MySQL...DB2...Sybase..PostgreSQL I am deciding on Project development tools.. Each RDBMS has some short coming for me.. Addressing MySQL which I like very much.. I use v. 3.22.32 because there is not a binary RPM for Caldera 2.3 and 2.4 edesktop. I also installed to OS/2 and Winnt. As I had to compile my install and can't determine if I can upgrade for Caldera Install. I can only locate source for 3.23.39 or 3.22.32 and I am not sure if 3.23.39 will compile properly on my 2.2.10 kernal. Where is the source hidden for 3.22.33 thru 3.23.38?? ?? Question: What version do you suggest in my situation..? ??Questions: with 3.22.32... Work around suggestions for 1 Searching on two keys ( In Tutorial) as 3.22.32 can not create temporary tables.. 2 Select * from table to Output I understand this will not work with 3.22.32 ?? Comments suggestions Temp tables can be a valuable tool.. Would you create new permanant tables temporarily and then drop them. What features do you believe sorely lacking in 3.22.32 which would force an upgrade.. Including perhaps Application Interface changes to perl or java.. Thank you for you time.. Bob T - 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: Where to find help??
At 11:52 PM -0500 7/15/01, Jeff Holzfaster wrote: Where is a good place to find help with some basic sql? http://w3.one.net/%7Ejhoffman/sqltut.htm http://www.devshed.com/Server_Side/MySQL/Intro/ http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html For a reference book: SQL in a Nutshell Author: Kevin Kline with Daniel Kline, Ph.D. ISBN: 1-56592-744-3 Published: December 2000, O'Reilly Associates 224 pages http://www.oreilly.com/catalog/sqlnut/ http://www.bookpool.com/.x/SSCOLL/sm/1565927443 -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.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
Meet MySQL Users Developers at OSCON in San Diego...
Are you coming to the Open Source Convention next week in San Diego, California? Would you like to meet fellow MySQL users and some of the MySQL developers? If so, plan to be in the room Harbor Island II (East) between 8pm and 10pm on Wednesday the 25th of July. There will be a BOF (Birds of a Feather session) during which we can meet and talk about MySQL. The description posted on the O'Reilly conference Web site reads: Come and meet some of the MySQL developers as well as new and experienced users. Ask questions. Answer questions. Learn what folks are doing with MySQL. Find out where MySQL is headed in the coming months. Last year's MySQL BOF went very well. A lot of folks got questions answered and had the chance to put faces with some of the names they'd seen on the mailing lists and in the code. Details of all the BOF sessions, in case you decide not to join us, are listed here: http://conferences.oreillynet.com/cs/os2001/pub/10/bofs.html Hope to see some of you in San Diego! Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 -- NEW MySQL 3.23.29: up 29 days, processed 225,096,896 queries (87/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
mysqlbug
mysql£¬ÄúºÃ£¡ СµÜÔÚsco openserver5Öа²×°Mysqlʱ£¬³öÏֵĴíÎóÌáʾÈçÏ£º scripts/mysql_install_db: 11738 Killed scripts/mysql_install_db: 11739 Killed WARNING: Your libc libraries are not 100 % compatible with this MySQL version mysqld should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Creating db table Creating host table Creating user table Creating func table Creating tables_priv table Creating columns_priv table dynamic linker : ./bin/mysqld : error opening libz.so scripts/mysql_install_db: 11740 Killed Installation of grant tables failed! ¸ÃÈçºÎ´¦Àí£¿ ÇëÇó¸ßÊÖÔ®Öú£¬²»Ê¤¸Ð¼¤£¡ Ö Àñ£¡ xg [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: Where to find help??
Jeff Holzfaster wrote: Where is a good place to find help with some basic sql? I am having a problem getting the query results I need. Don't tell me to consult the manual because that is the first place I turned to. I just need a real life example of the solution to see be able to pick it apart. I posted the request to this list (see Two table query help...) and only got one off-list reply that didn't help. Is there a better place to get such assistance or a better way of requesting it here??? -- A Newbie Jeff: The way it works is thusly: Send an example of the query you're having trouble with. Indicate whether the query is executed in a PHP, c, or perl application. Send the result of the query, or error messages if they exist. Ex.: The query: $rs2=mysql_query( select count(*) from dlg where hid='$UId' and (dlgdate = DATE_SUB(now(), INTERVAL 31 DAY) and (dlgdate = '$DlgNow' and dialog like '%$rowexpl[expletive]%'))); PHP application. Result in this example is successful. No errors. Start from there. You could also get Paul Dubois excellent book: ISBN 0-7357-0921-1. Best Regards, Van -- = Linux rocks!!! http://www.dedserius.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