Re: mySQL Certification
There are courses, but there is no certification as yet, AFAIK. See http://mysql.com/training/ Sie schrieben am Samstag, 14. Juli 2001, 04:26:16: Is there some sort of mySQL certification course? sql -- 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[2]: Remote Access to SQL Server via Internet
IT is actually more of a security risk, because it is sending passwords in the clear. You should not send a password at all. Put your password in a file at a safe location on your server (you can always protect it with .htaccess), then let your program read this password and send it to MySQL. Also, look for a different ISP. They should make things easy, and there are plenty who know how to do it. No problem at all. If you are looking for an account in the US and need personal advice, contact Glen Pipkin at [EMAIL PROTECTED], for example. -- 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, 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. 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. 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. 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. [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 be released via mysql.org as GPL as previously announced - note that Gemini itself is not a derivative of MySQL in any way - it's roots date back to long before MySQL existed. Finally independent of the rest of this. I have the highest respect for Monty and what he has done creating MySQL. I'm certain we can move beyond this and make MySQL an even stronger open source project and I encourage everyone move to a constructive dialog. Britt -- D. Britton Johnston 603-578-6707 Nashua Chief Technology Officer 781-280-4954 Bedford NuSphere Corporation 781-280-4600 Main 14 Oak Park 781-280-4646 Fax Bedford, MA 01730 www.nusphere.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]: why it is like this... {}
I am taking some value from html form as i shown and i am inserting that value be getting thru request.getParameter(name) and inserting into the table along some other values. I am using in servlets. Hm. I don't know about servlets. Seems like that does something wrong. It is pretty dangerous to take html from a form. You can do lots of evil things. Therefore, most people take care to disable html from forms or at least only let simple things pass like B or the like. Hence I guess that the servlet does some sort or html-disabling/filtering and gets it wrong. Disabling html from forms is not easy either. See for example the discussion at http://php.net/manual/en/function.strip-tags.php for the function strip-tags, which should do just that. (Someone has found that even this can be circumvented, so they had to improve another time - see comment 14-Mar-2001 02:23 and following.) I use php which is very convenient. You can do eveything you dream of very easily. In particular, if anything goes wrong, you can have a look at it and understand why. But, I must admit, there is a learning curve, as is with everything. -- 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: character set
dodge wrote: I've problem with sorting table rows, thats why i need to get mysql work with my character set. can you explain better about ctype array when defining character set. I really did not understand about elements in this array. The rest ones to_lower, to_upper, sort it's simple just simbol codes in hexadecimal... I think answer you need is here: http://www.mysql.com/doc/C/h/Character_arrays.html Tõnu - 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: Different logs for different databases?
On Sat, Jul 14, 2001 at 01:27:36AM -0700, Jim Matzdorff wrote: Hello all, I was wondering, is it possible to have different log files for different databases somehow? RedBack? You're just down the street... Sort of. Anyway, right now there's not an easy solution that I know of. But having looked at the binary logging code a bit, I don't think it'd be difficult to do (add the necessary code to MySQL), provided that the logging code is as straightforward as the binary logging code. 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 213,537,453 queries (88/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: Sorry, no need to answer question about unions...
On Fri, Jul 13, 2001 at 08:44:54PM -0700, William M. Shubert wrote: Ugh, I couldn't find the mailing list archives until I looked at the bottom of my own message that got mailed back to me! I searched, found out about the temporary table workaround for no unions, sorry for bothering you all with a question that had been answered before. I'm still eager for MySql to have real unions so I can simplify my sql code, but this looks good enough for now! Code for UNIONs has started to appear in the MySQL 4.0 tree, so hope is in sight. :-) 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 213,541,496 queries (88/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
On Sat, Jul 14, 2001 at 03:10:34AM -0400, 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 good to see some discussion taking place here. Perhaps it will help make the issues a bit clearer to the folks who have been wondering what they heck is going on (that's the majority of the community). As far as NuSphere's contribution to MySQL, it is disappointing to see our efforts discounted so quickly. I don't think that folks are discounting your efforts. In many cases, folks knew little of what NuSphere had really done to date. 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 be released via mysql.org as GPL as previously announced - note that Gemini itself is not a derivative of MySQL in any way - it's roots date back to long before MySQL existed. There's another source of confusion for people. The difference between the Gemini table handler and the Gemini component itself. What is the difference? (I think I might know, but I suspect that it's not clear to folks who haven't heard you talk about Gemini in person.) Finally independent of the rest of this. I have the highest respect for Monty and what he has done creating MySQL. A sentiment we all share. And some (many?) of us realize that NuSphere has a done some incredible work in an effort to take MySQL up a notch. NuSphere's talent and responsiveness was clear to me during the Gemini beta program. I'm certain we can move beyond this and make MySQL an even stronger open source project and I encourage everyone move to a constructive dialog. I suspect that in the short term, the legal battles are likely to become less interesting to this community than: * Being presented with the mysql.org site and not understanding where it came from, who runs it, and why they should go there. * The affects that this will have on the community. Are there going to be separate mysql.org hosted mailing lists which overlap in funtionality and audience with those hosted here? * Will it become less clear where users should go for information, documentation, downloads, and so on? * Understanding the differences between NuSphere's MySQL and MySQL AB's MySQL distributions. I know that they are relatively few now, but will that continute to be the case? Who knows. Those are the sort of concerns which motivated my statements in the MySQL press release a few days ago. I think that the MySQL community today is excellent--one of the best surrounding any piece of Open Source software today: Linux, FreeBSD, Perl, Apache, PHP, Python, MySQL, etc. They all have great communities. None of us want to see the community sidetracked, fragmented, or otherwise damaged as a result of this. Having read about the old XEmacs fork from GNU Emacs, that sort of stuff doesn't sound pleasant. We have a great forum for discussion right here. I'd suggest that when feasible, folks should talk to the community. Find out what folks here think about having a new/different web site, forked code, or whatever may be brewing. Unlike slashdot, folks here are apt to think before writing the first thing that pops into their heads. Given that this mailing list has been a large part of the MySQL community, it'd be great to see folks from NuSphere on it in a while. Jeremy (trying not to fuel any fires) -- 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 213,565,627 queries (88/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: Urgent problem : recovering a table with no MYI file ?
On Sat, Jul 14, 2001 at 01:04:41AM +0200, Fournier Jocelyn [Presence-PC] wrote: Hi, I'm administrating a machine which has just badly crashed, and a MYI file has disappeared for one table. Is this possible to repair this table? Try to touch the file (to create an empty one), and see if that is sufficient to get MySQL doing what it should. Don't know if it will help, but you never know. 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 213,616,674 queries (88/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 performance monitoring?
On Fri, Jul 13, 2001 at 09:40:55AM -0200, Mario Witte wrote: I'm searching for a tool which will provide statistics about the usage of a mysql-server like avg queries/minute, cpu load etc. Other folks have made good suggestions. If you want something quick and interactive, mytop may give you some of the information you're looking for. 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 213,628,847 queries (88/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
Jeremy Zawodny wrote: [== snip, snip ==] Jeremy: You should be complimented for giving us a measured and rational posting on this potentially emotional issue. And also, it is good that Britt has clearly stated his understanding, though perhaps a bit too late to have prevented one of those common socialogical phenomena, the perception that sombody or a Company is somehow exploiting Open Source with its train of reactions: - NuSphere is a dirty bunch of guys - Monty is being screwed - et cetera ad infinitum Personally, I could care less about the mysql.org domain issue. I, more or less, see it just as another kind of ex-officio site supporting some Open Source effort. I cannot see why it would lead to confusion as to who is leading the MySQL development, as the information presented on the site makes everything very clear. But, somehow, possession of this domain is important to both of the disputing parties for reasons only known best to them. I think in the long run, to the community, the more sites/domains dedicated to the promotion of MySQL, the better. As for NuSphere being perceived as violating the GPL, it appears that they have just not handled it very well in their, er, PR, as, if the NuSphere exposed position is taken on face value, namely they have submitted their changes, but the community has not been really made aware of this because of the complex relationship between NuSphere/MySQL which, also, was not made clear by either party until recently. For me, this is a tempest in a teapot, mostly due to the silence of NuSphere on the mechanism of complying with the GPL and the details of NuSphere's position on the domain issue. In summary, with 20-20 hindsight, NuSphere has probably handled its PR badly, and now they are suffering for it. _jef -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - 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: MyODBC 2.50.37 and Access 2000
Venu Anuganti writes: Hi Kevin Can you please send us the ODBC trace generated by MyODBC as well as ODBC DM ? Thank you Venu Anuganti Hi! This was simply a case that Access table did not have auto-increment and timestamp columns in it. Unfortunately, there are some restrictions in working with MS Access, which is otherwise a fine tool. -- 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: Manual for sale? (was Re[2]: mysql.org)
Colin Faber writes: Michael, Interesting idea but I think it would problematic over all, The mysql manual changes almost everyday (anyone that syncs the bk tree's knows) I would suggest a better solution would be to provide the manual as a localized application (possibly even ported to PalmOS/WindowsCE), Anyone? ;-) I think that both yours and M. Collins ideas are fine and we shall definitely come up with something. -- 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: ERROR 1060: Duplicate column name
Thank you for your bug report. -- 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: AC_SYS_LARGEFILE patch for 3.23.39
[EMAIL PROTECTED] writes: The patch below syncs AC_SYS_LARGEFILE with the version shipping with autoconf 2.50. This is against MySQL 3.23.39. -- albert chin ([EMAIL PROTECTED]) Thank you for your contribution. -- 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: Can't find record in '#sql45e7_70df_3'
Lance Lovette writes: I recently upgraded from MySQL 3.23.36 to 3.23.39 and now the following query fails. SELECT DISTINCT Ring.*, Question.DefaultRingID, COUNT(RingMember.UserID) AS MemberCount FROM Ring, Question, QuestionXQuestionCategory, BrandXQuestionCategory LEFT JOIN RingMember ON (Ring.RingID = RingMember.RingID) WHERE (Ring.QuestionID = Question.QuestionID) AND (Question.QuestionID = QuestionXQuestionCategory.QuestionID) AND (QuestionXQuestionCategory.CategoryID = BrandXQuestionCategory.CategoryID) AND Ring.DirectoryListing = 1 AND BrandXQuestionCategory.BrandID = 1 GROUP BY Ring.RingID, QuestionXQuestionCategory.CategoryID HAVING (Ring.RingID != Question.DefaultRingID) ORDER BY MemberCount DESC LIMIT 5 ERROR 1032: Can't find record in '#sql45e7_7123_1' I ran 'myisamchk --medium-check --silent /var/lib/mysql/*/*.MYI' and nothing was reported. What might be causing the error? Thanks! Lance Hi! Do you always get that error when running the above query on the above tables ?? If yes, please check space available on TMPDIR partition when the above error occurs and check file permissions in the same dir. If this is not a problem, we would like to test it ourselves. How big are those tables when tar-gzipped ? -- 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: Replication and InnoDB
Christian Jaeger writes: At 16:17 Uhr +0300 13.7.2001, Sinisa Milivojevic wrote: Hi! We have been planning to use mysql/innodb with replication soon (mid/end of august). http://www.mysql.com/doc/B/i/Binary_log.html suggests that replication should work with transactional table(s) (like BDB tables), and I thought this was valid for current releases. Is this not the case for InnoDB, and why? Does it work ok now with BDB? Christian. It is the same. Replication works already with all table handlers, but all that remains to be solved is ROLLBACK. -- 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 Crash with show logs queries
Gustavo Vieira Gonçalves Coelho Rios writes: Description: MySQL Daemon crashes when a user with the necessary privileges issue a query show logs How-To-Repeat: Start your daemon with the option --skip-bdb: your-shell safe_mysqld --skip-bdb Then, issue a show logs using mysql utility, for instance. Hi! I have tried your test case, but I did not manage to crash 3.23.39. -- 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?
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 - Original Message - From: Sinisa Milivojevic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, July 14, 2001 1:24 PM Subject: Re: Any workaround for no union operation? Hi! Unions will soon come in 4.0. Meanwhile, your query can utilize indices if you have a composite index on seller and buyer. -- 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
Re: MySQL Crash with show logs queries
At 23:21 13/07/2001 -0300, Gustavo Vieira Gonçalves Coelho Rios wrote: Hi, Thanks for the bug report. I was be able to repeat and the issue should be fixed in the next release. Regards, Miguel Description: MySQL Daemon crashes when a user with the necessary privileges issue a query show logs How-To-Repeat: Start your daemon with the option --skip-bdb: your-shell safe_mysqld --skip-bdb Then, issue a show logs using mysql utility, for instance. Fix: MySQL admins: don't use the --skip-bdb option when starting the daemon. MySQL Developer: Be more carefull when coding (How much would i have to pay - since mysql is free - to get this advice seen) I'll be waiting for some feedback (Not only developer but the user comunity too) Submitter-Id: submitter ID Originator:Gustavo Vieira Gonçalves Coelho Rios Organization: Ifour Sistemas. MySQL support: none Synopsis: MySQL Crash with show logs queries Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.39 (yes) Environment: System: FreeBSD etosha.ifour.com.br 4.3-STABLE FreeBSD 4.3-STABLE #1: Tue Jul 10 04:36:12 BRT 2001 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/ETOSHA i386 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.3 [FreeBSD] 20010315 (release) Compilation info: CC='cc' CFLAGS='-O -pipe -march=pentiumpro' CXX='c++' CXXFLAGS='-O -pipe -march=pentiumpro -felide-constructors -fno-rtti -fno-exceptions' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1187948 10 Jul 04:17 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 10 Jul 04:17 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 574912 10 Jul 04:17 /usr/lib/libc.so.4 Configure command: ./configure --localstatedir=/var/db/mysql --without-perl --without-debug --without-readline --without-bench --with-mit-threads=no --with-libwrap --with-low-memory --with-comment --with-raid --with-berkeley-db --with-innodb --enable-assembler --with-berkeley-db --prefix=/usr/local i386--freebsd4.3 Perl: This is perl, version 5.005_03 built for i386-freebsd - 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 -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ 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
Justin, I very much agree with your compliment to Jeremy for his posting. Some notes on your posting follow. At 14/07/01 14:03 +0200, Justin wrote: Personally, I could care less about the mysql.org domain issue. I, more or less, see it just as another kind of ex-officio site supporting some Open Source effort. I cannot see why it would lead to confusion as to who is leading the MySQL development, as the information presented on the site makes everything very clear. Yes, now the mysql.org site is much clearer. At the time of our press announcement, the site looked different. The infringement of our trademark in the name of the site has not been cured, however. But, somehow, possession of this domain is important to both of the disputing parties for reasons only known best to them. I think in the long run, to the community, the more sites/domains dedicated to the promotion of MySQL, the better. To be specific: MySQL AB does not oppose the existence of community websites. On the contrary, we encourage them. But we are opposed to violations of our trademark and other rights, to the lack of identification of the people/organisations behind it or affiliated with it , and to anybody requiring registration before allowing downloading of our GPL software. The identification issue has now been fixed on mysql.org, and we are happy about that move, and Britt said in his recent posting that the registration issue has been fixed. We now look forward to seeing the intellectual property issues cured as well. As for NuSphere being perceived as violating the GPL, it appears that they have just not handled it very well in their, er, PR, as, if the NuSphere exposed position is taken on face value, namely they have submitted their changes, but the community has not been really made aware of this because of the complex relationship between NuSphere/MySQL which, also, was not made clear by either party until recently. I would say violating the GPL and submitting their changes are two different things (and maybe you would, too). Regarding the GPL violation we state the following: NuSphere is and has been shipping a product that includes the MySQL server under GPL and the Gemini component, with the Gemini component statically linked to the MySQL server. The source code of Gemini or a written offer to provide it is not included in the package, wherefore this constitutes a violation of GPL. When it comes to submitting changes there might be more than one discussion threads, and I might not personally be aware of all of them. I'll try to cover those that I believe are relevant and hope I cover what you intended. First thread: In case somebody thinks so, it is NOT possible to cure a GPL violation by submitting source code to MySQL AB. The source code or the written offer has to be in the product that is delivered to customers. Second thread: We at MySQL AB have not refused to accept Gemini source code into the tree, nor have we required transfer of copyright of it to us, or shared copyright (if anybody thought so). Third thread: There was a situation where NuSphere asked us to include in the MySQL server a crypting function that had been developed by a third party (not NuSphere, not MySQL AB). In the absence of shared copyright for us to the piece of code in question, we refused to take it in. This is a principle we have been following always, and it is followed by other open source companies as well, and by the Free Software Foundation (FSF). I hope the above adds clarity. Marten Mickos CEO MySQL AB [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
Database Backups
Hello All, 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. Any suggestions much appreciated :) THX, Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Security problems - Very Newbie!
Hi Ok, having sorted out my scripts, I'm understanding the concepts of Mqsql quite well, however, before i got too far into creating and manipulating data I want to understand the security issues. I run the mysql server on a win2K box and use the client from the same machine, therefore I can just type mysql at the c:\ and in I go. I have another pc which is networked so a great opportunity to try out the security. PROBLEM! I can't seem to get access rights set up or indeed users. below is what happens when I try to grant access to me on my machine rather than just type in mysql. mysql thinks I am called administrator, and my host name is sara (as shown in mysqlwinadmin) C:\mysql grant all on *.* to administrator@sara identified by delboy When I type in the statement to grant access it throws out the following text: MYSQL Ver 9.23 Distrib 3.22.7b-beta, for pc-cygwin32 (i386) By TCX Datakonsult AB, by Monty This software comes with ABSOLUTELY NO WARRANTY. Usage: MYSQL [OPTIONS] [database] -A, --no-auto-rehash No automatic rehashing. One has to use 'rehash' to get table and field completion. This gives a quicker start of mysql. -B, --batch Print results with a tab as separator, each row on a new line. Doesn't use history file -C, --compressUse compression in server/client protocol -#, --debug=... Output debug log. Often this is 'd:t:o,filename` -T, --debug-info Print some debug info at exit -e, --execute=... Execute command and quit.(--batch is implicit) -f, --force Continue even if we get an sql error. -?, --helpDisplay this help and exit -h, --host=...Connect to host -n, --unbuffered Flush buffer after each query -O, --set-variable var=option Give a variable an value. --help lists variables -o, --one-databaseOnly update the default database. This is useful for skipping updates to other database in the update log. -p[password], --password[=...] Password to use when connecting to server If password is not given it's asked from the tty. -P --port=...Port number to use for connection -q, --quick Don't cache result, print it row by row. This may slow down the server if the output is suspended. Doesn't use history file -r, --raw Write fields without conversion. Used with --batch -s, --silent Be more silent. -L, --skip-line-numbers Don't write line number for errors -S --socket=... Socket file to use for connection -t --table=... Output in table format -u, --user=# User for login if not current user -v, --verbose Write more (-v -v -v gives the table output format) -V, --version Output version information and exit -E, --verticalPrint the output of a query (rows) vertically -w, --waitWait and retry if connection is down Possible variables for option --set-variable (-O) are: max_allowed_packetcurrent value: 25165824l net_buffer_length current value: 16384l C:\mysql -h sara -u administrator -p Enter password: ** ERROR 1045: Access denied for user: 'administrator@sara' (Using password: YES) When I try to then login in to mysql as administrator (my win2k login name) which mysql thinks is the root it says access denied. If I try to update me (administrator as a user by execuiting the following command it won't accept it either, but I may be misunderstanding the syntax here? c:\ mysql -root mysql update users set password=passworddelboy where user=root two things here, if when I try to login as root it thinks I'm administrator should I be substituting root for administrator and is the password syntax correct? Im not sure if one substitutes the second password statement for mypassword Sorry this is so long, but I would like to get my thinking straight on here so that I can access the server on this machine from my other one. But with the grant access statements not working it will let me connect to the server but won't understandably allow me access to the db! In anticipation Regards Sara
RE: mysql.org
Britt == Britt Johnston [EMAIL PROTECTED] writes: Since Monty is travelling for 30 hours or so (from Australia) I will answer this. Britt Well, what a mess. It is regretable that this legal issue Britt needs to be aired so publically that was certainly not my Britt preference. I also will not get into a flame war, it is not in Britt the best interest of mysql. I appreciate all the email I've Britt received with advice and/or support - thanks. It was not our will to make the legal issue into a Public debate either. But you chose to mention the legal stuff to a journalist. I wont comment on everything in this email to avoid extra escalation. Britt It is important that everyone realize that there is a legal Britt agreement that both Monty and David personally signed that Britt provides NuSphere broad rights around the use of the MySQL Britt name. That agreement also allows NuSphere to release MySQL Britt under the GPL license forever and print and distribute the Britt manual. We paid significant money to Monty and David in Britt exchange for that agreement which was central to forming Britt NuSphere. This is public record. There WAS an interim agreement from June 2000 to be replaced within 3 months by a final agreement. We have confirmed to NuSphere in writing the termination of the interim agreement. It has not been in force for some time. Also I was the only one who signed (not Monty) it and sent it by fax (we where in a hurry). When it was in force, the interim agreement did NOT provide NuSphere broad rights to use the MySQL name and it did not grant any licenses forever. Under the agreement, Progress paid a total of USD 312,501 with the last check being cut in September 2000. See http://www.mysql.com/news/article-75.html for more information on this. And about the right to distribute under the GPL. I remember very well asking you why this paragraph was in the agreement. I thought it was stupid to add a right to distribute the GPL version of MySQL under the GPL. You said is was just something your lawyers wanted even if it was just stating a right everyone had. Of course any GPL software can be distributed by anyone as long as the GPL terms are followed. But we might choose to put a future version under a different license (free-software/open source compatible of course!) and we never granted you the right to distribute NEW versions of MySQL under the GPL ver 2 forever. And just like anybody in the whole world you can distribute any new version that we license under the GPL if you follow the requirements of the GPL. Britt Please consider these facts when you try to understand Britt NuSphere's rights and motivations - we actually worked hard to Britt get the details in writing before we even started the company Britt and we paid real money. It is under this agreement that we Britt believe we have a clear right to use mysql.org. You never ever had right to operate MySQL.org Britt Now it appears there is a need by MySQL AB to characterize that Britt agreement as no longer in effect - I hope you can respect the Britt fact that NuSphere believes it is fully in effect and we wish Britt to continue to abide by it. This is the central issue and Britt public debate will not resolve it. It was a interim agreement and has also been officially terminated. Britt As far as mysql.org goes, what NuSphere would like to see is a Britt non-profit organization running that site - we have been Britt consistent in this desire for over a year, but it has been Britt opposed by Monty and David. I discussed this with Monty as Britt recently as a few weeks ago in June and July and as always he Britt was not interested - I appreciate he is entitled to that Britt opinion as I am entitled to believe that it is time to take Britt this step in the MySQL community. I invite all those who are Britt skeptical to join mysql.org and be part of its formation. Why do you want us to be non-profit and you to be for profit? Can't you operate it as NuSphere.org? What you have wanted in the past is that MySQL AB should give up its copyright to MySQL and turn it over to a foundation more like Apache that has small commercial interests. Since I and Monty had a commercial business idea when we started MySQL in 94-95 that was not what we wanted. Since MySQL AB distributes EVERYTHING it develops under GPL/LPGL or Public domain licensing we already have a community site. If you want to set up another one, you are free to do so, but you must not use our name for it. We know that MySQL.com is not yet all what it could be. But we have worked on fixing this and we very recently showed our portals that will be the basis of much more easily navigable information on MySQL. Check them out (http://www.mysql.com/portal). If you want to help please help us include everything MySQL related here with comments and ratings! If you wan to help you can send mail to [EMAIL PROTECTED] Britt [BTW, the first community action was to get rid
Re: How do you insert into two tables at once
David [EMAIL PROTECTED] 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? Two inserts are required. You can insert multiple rows into a table via a single insert, but not into multiple tables. -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.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]: Mysql++ and Gcc 3.0 compile problems
SM I am sending a patch straight to you Do someone see improvements compiling Mysql with Gcc 3.0 ? 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: Remote Access to SQL Server via Internet
Thanks for all who responded. Here is the error message I get when I try to connect to my current WSP: MySQL Error Code: (1130) Host '63:160.226.3' is not allowed to connect to this MySQL server It looks like I need to find a new WSP. My current WSP is WebSiteSource (www.websitesource.com), and I've been pretty happy with them until now. I looked at Aletia Hosting (aletiahosting.com). They are very fast and it looks like I can get a package comparable to what I have with WebSiteSource. However, I jut got an e-mail from them that says they don't allow remote access to SQL databases either. Sigh --Bruce -Original Message- From: Bruce Vander Werf [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 7:20 PM To: [EMAIL PROTECTED] Subject: Remote Access to SQL Server via Internet Hi, I would like to be able to create some tables in a database on an SQL server at my web provider, then access those tables via a client application running on my PC over the Internet (dial-up connection). My understanding is that the client application accesses the SQL server via TCP/IP and not ODBC. My web provider says no way. They can enable an ODBC connection for one static IP address, which is not an acceptable solution, because a) I don't want to use ODBC, and b) my dial-up connection may use one of a range of IP addresses. They will not let me have direct TCP/IP access to the database. My question is why my ISP would say this. Of course the database is password protected, so I don't see why direct access is any more a security risk than using their web-based client. Is this common practice among ISPs, or do I need to shop for a new one? Any suggestions? -- Bruce Vander Werf [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
MySql - quit !
mysql --version mysql Ver 11.15 Distrib 3.23.39, for pc-linux-gnu (i586) mysql wont start and mysql error log says /usr/local/mysql/bin/mysqld: unrecognized option `--defaults-extra-file=/usr/local/mysql/data/my.cnf' I tracked that down to the /usr/local/mysql/bin/safe_mysqld script, and altered it to nothing, as the my.cnf does NOT exist anywhere on the raq. So I tried starting mysql again /etc/rc.d/init.d/mysql start and now i get a new error: 010714 14:22:36 mysqld started 010714 14:22:36 /usr/local/mysql/bin/mysqld: Can't find file: 'host.ISM' (errno: 2) 010714 14:22:36 /usr/local/mysql/bin/mysqld: Normal shutdown 010714 14:22:36 mysqld ended Yet this nice 'host.ISM' does exist ... hummm... Anyway im completly lost with mysql and this is a production server that uses mysql heavily, can anyone help ? beg beg Im quite happy to re-install mysql if its the easiest way, except the data is TRULY IMPORTANT and can NOT be lost at any cost ! (Ow and I have no idea how to set it all up again (tables), and/or backup the db's correctly) thanks guys _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Installation Problem
I have this message and I don't understand, plase help me. [root@cyril guest]# rpm -U /home/guest/Desktop/MySQL/MySQL-DBI-perl-bin-1.825-1.i386.rpm error: failed dependencies: DBI-perl-bin = 0.93 is needed by mysql-DBI-perl-bin-1.825-1 [root@cyril guest]# - 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
David Axmark wrote: Britt == Britt Johnston [EMAIL PROTECTED] writes: Since Monty is travelling for 30 hours or so (from Australia) I will answer this. [== snip, snip ==] WOW! Does everyone realize what is going on here? I don't know, I consider this stuff historic. Perhaps, at least to this quasi-agnostic observer, Open Source Legal Resolution has been invented by accident. I find it interesting that facts are coming out, two parties are at least tending to converge on a legal remedy in a gentlemanly manner in the forum of great pressure as exerted by the highly-interested MySQL community. One has seen already the removal of the download registration requirement on the NuSphere site, something that was technically meaningless in a strict legal sense, but perceived as onerous by the Community as representing some kind of insult to Open Source or designed for imagined sinister motives. One has seen the modification of the NuSphere site to gain clarity as to the identity of the MySQL developer(s), heretofor apparantly obscure. One has seen already the clarification by MySQL AB that the existence of ex-officio support sites for MySQL are encouraged, not confusing, and good for all, but that the mysql.org site is, technically, only a trademark issue, in their eyes. One has seen a convergence to the real nub, visible to all of us interested observers, that the remedy for GPL violations is not satisfied by late compliance or other possibly-obscure methods of compliance. One has seen a revelation of a lot of things behind the scenes that are perceived as a violation of the GPL and, usually, to the general member of the Open Source Community, may be complex, such as static linking, the idea of shared copyright, the mutual interpretation of the agreement process between the two parties, et cetera. Both parties are now letting everything hang out... One has seen a complete stake-out of all necessary legal positions of both parties out-in-the-open that would be necessary in any discovery process, and, as a humorous aside comment, almost pre-empts the necessity of having legal councel prior to going before the judge. By some quirk, we have become the court and jury of judgement that both parties feel the need to convince, and cannot ignore. This is very interesting, this Open Source Legal Resolution ;-) _jef -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - 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
HELP ! Myisamchk doesn't seem to see error in my table :(
Hi, I crash one table, and some datas are completely corrupted. However, myisamchk doesn't seem to see any errors (I try -e, -o and -r option)... Here is an extract of the table : 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 :( Do you have any idea how I can recover the table ? Thanks a lot ! Jocelyn Fournier Presence-PC
encrition /security
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 - 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 Variables
when you do a mysqladmin variables, where exactly are these variables stored, and can they be changed. Also if a /etc/my.cnf is going to be used, once it's been created does the MySQL server need to be shutdown and restarted to recognize the new my.cnf file?? Again, Thx for the help :) Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Variables
At 11:32 AM -0500 7/14/01, MikemickaloBlezien wrote: when you do a mysqladmin variables, where exactly are these variables stored, and can they be changed. They can be changed by placing set-variable= var_name=var_value lines in the [mysqld] group of the /etc/my.cnf option file (or any other option file that the server reads at startup time). Also if a /etc/my.cnf is going to be used, once it's been created does the MySQL server need to be shutdown and restarted to recognize the new my.cnf file?? Yes. Again, Thx for the help :) Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -- 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 Variables
At 11:46 AM -0500 7/14/01, Paul DuBois wrote: At 11:32 AM -0500 7/14/01, MikemickaloBlezien wrote: when you do a mysqladmin variables, where exactly are these variables stored, and can they be changed. They can be changed by placing set-variable= var_name=var_value lines in the [mysqld] group of the /etc/my.cnf option file (or any other option file that the server reads at startup time). I too have been trying to get a my.cnf file working properly with little success. The twist in my tale is that I have two copies of MySQL installed, one of which uses the standard install location (/usr/local/) and port, and the other a custom location, port, and socket. I would like for the second copy to always use the special port or socket whenever I utilize any of the mysql client programs (which I invoke from the special location of those files). I have read the manual about option files and looked for the answer in the MySQL DuBois book. I have used what I believe to be the correct parameters based on a file I found at /usr/local/share/mysql/my-small.cnf). This is a source install so I understand from the manual that the my.cnf file goes in the var directory. I have also tried a simple version of this: [client] port=14551 socket=/tmp/LassoMySQL.sock 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. Help? -- 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: MySQL Variables
At 10:11 AM -0700 7/14/01, Michael Collins wrote: At 11:46 AM -0500 7/14/01, Paul DuBois wrote: At 11:32 AM -0500 7/14/01, MikemickaloBlezien wrote: when you do a mysqladmin variables, where exactly are these variables stored, and can they be changed. They can be changed by placing set-variable= var_name=var_value lines in the [mysqld] group of the /etc/my.cnf option file (or any other option file that the server reads at startup time). I too have been trying to get a my.cnf file working properly with little success. The twist in my tale is that I have two copies of MySQL installed, one of which uses the standard install location (/usr/local/) and port, and the other a custom location, port, and socket. I would like for the second copy to always use the special port or socket whenever I utilize any of the mysql client programs (which I invoke from the special location of those files). If each server is compiled to use a different data directory, then you should be able to put a my.cnf file in the data directory to affect the respective server using the [mysqld] group in each file. I have read the manual about option files and looked for the answer in the MySQL DuBois book. I have used what I believe to be the correct parameters based on a file I found at /usr/local/share/mysql/my-small.cnf). This is a source install so I understand from the manual that the my.cnf file goes in the var directory. I have also tried a simple version of this: [client] port=14551 socket=/tmp/LassoMySQL.sock 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... Help? -- 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Slightly off-topic... Dump SQL editor thats cross-compat Win/Linux
Creating and editing dbdump SQL files from local dev in Win2k, moving to Linux for QA and production. Text files edited using Wordpad and Notepad have extraneous line-end chars (bold M). Any suggestions on configuration of any Win editor to save text without garbage chars showing up on Liux side? Thanks, Fred Atlanta - 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: Slightly off-topic... Dump SQL editor thats cross-compat Wi
On 14-Jul-01 Fred Dinkler wrote: Creating and editing dbdump SQL files from local dev in Win2k, moving to Linux for QA and production. Text files edited using Wordpad and Notepad have extraneous line-end chars (bold M). Any suggestions on configuration of any Win editor to save text without garbage chars showing up on Liux side? when you ftp the files, use text mode ( command cr - strip carriage returns) Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Variables
On Sat, 14 Jul 2001 11:46:15 -0500, Paul DuBois [EMAIL PROTECTED] wrote: Also if a /etc/my.cnf is going to be used, once it's been created does the MySQL server need to be shutdown and restarted to recognize the new my.cnf file?? Yes. is this the default location it looks for a 'my.cnf' file or can this be defined some where? Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql.org
Britt Johnston wrote: 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. Britt -- D. Britton Johnston Britt: Why is it necessary to create such a site? What is Progress' goal in doing so? MySQL.com, despite David's disclaimer that it isn't perfect is enormously useful. This list's value is immeasurable. I might see value in a gemini.lists.mysql.com entity, or gemini.mysql.com, if your db is compelling. I've heard gemini adds value, but, don't know what that added value might be. I programmed in Progress 6 years ago and found it ... interesting. Not bad; but, certainly interesting. I don't know if Progress looks more like SQL since my use of it, but, I doubt we're talking about Progress in those terms any more. I wouldn't know. I've been working with MySQL for the past 4 years and plan to continue doing so. FWIW, I always thought Progress was a competent product, and, in my past used it with huge success. So, I've always felt good about it. I was very excited last year when Progress announced MySQL support. This message from you is very encouraging. I'm impressed with it's candor and even tone. It's been a rough week for you and the people you work with, I'm sure. I doubt anyone here wants to see a dissolution of Nusphere and MySQL's relationship. Speaking for myself only, I'd like to see MySQL content/discussions stay where they are, and, development efforts continue to be maintained/announced for the core MySQL application at mysql.com, and, if there's any value in a mysql.org portal for issues extraneous to the core of mysql, fine, but, with a name that doesn't dilute the MySQL trademark. Hope you and the principles at MySQL can find common ground and move in a constructive direction. Monty and crew deserve a positive outcome to this issue. 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
Re: MySQL Variables
At 12:25 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... But if I use /Path/specialMySQL/var/my.cnf and my option file contains: [client] port=14551 socket=/tmp/LassoMySQL.sock Then, invoking the client from within /Path/specialMySQL/bin/mysql would use the different port and socket? And, using /usr/local/mysql would then use the default datadirectory and port? BTW, this is on Mac OS X, I wouldn't think it would matter but I thought to mention it. -- 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: MySQL Variables
At 12:51 PM -0500 7/14/01, MikemickaloBlezien wrote: On Sat, 14 Jul 2001 11:46:15 -0500, Paul DuBois [EMAIL PROTECTED] wrote: Also if a /etc/my.cnf is going to be used, once it's been created does the MySQL server need to be shutdown and restarted to recognize the new my.cnf file?? Yes. is this the default location it looks for a 'my.cnf' file or can this be defined some where? See: http://www.mysql.com/doc/O/p/Option_files.html Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -- 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: changing servers
I was able to use mysqldump to 'dump' the databases in to a file. However, I'm not able to figure out how I can recreate the databases on the new server using this file. Any suggestions? Thanks, Bill Omer On Friday 13 July 2001 16:04, Tillema, Glenn wrote: Bill, I think you want to use mysqldump. Check here for documentation on it; http://www.mysql.com/doc/m/y/mysqldump.html cheers, Glenn Glenn Tillema [EMAIL PROTECTED] ADC Telecommunications, Inc. PO Box 1101, MS 508 Minneapolis, MN 55440-1101 Learn about ADC - The Broadband Company - www.adc.com -Original Message- From: Bill Omer [mailto:[EMAIL PROTECTED]] Subject: changing servers Hello, We are installing a new server, and I'm having to transfer the databases in MySQL from the old server to the new one. However, I know _very_ little (almost nothing) about MySQL. Could someone please offer me any help/suggestions/advice on how I could do this? -- Regards, Bill Omer - 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: Slightly off-topic... Dump SQL editor thats cross-compat Win/Linux
Date |Sat, 14 Jul 2001 13:34:40 -0400 From |Fred Dinkler [EMAIL PROTECTED] Hello! FD Creating and editing dbdump SQL files from local dev in Win2k, moving to FD Linux for QA and production. FD Text files edited using Wordpad and Notepad have extraneous line-end chars FD (bold M). FD Any suggestions on configuration of any Win editor to save text without FD garbage chars showing up on Liux side? You can also use simple script like this cat your_windows_file|tr -d '\r' your_unix_file Truly yours, Grigory Bakunov ASPLinux Support Team http://www.asplinux.ru - 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:51 PM -0500 7/14/01, MikemickaloBlezien wrote:
is this the default location it looks for a 'my.cnf' file or can
this be defined
some where?
Straight from the manual:
4.16.5 Option Files
MySQL Version 3.22 can read default startup options for the server
and for clients from option files. MySQL reads default options from
the following files on Unix:
Filename Purpose
/etc/my.cnf Global options
DATADIR/my.cnf Server-specific options
defaults-extra-file The file specified with {defaults-extra-file=#
~/.my.cnf User-specific options
DATADIR is the MySQL data directory (typically
`/usr/local/mysql/data' for a binary installation or `/usr/local/var'
for a source installation). Note that this is the directory that was
specified at configuration time, not the one specified with --datadir
when mysqld starts up! (--datadir has no e ect on where the server
looks for option files, because it looks for them before it processes
any command-line arguments.)
MySQL tries to read option files in the order listed above. If
multiple option files exist, an option specified in a file read later
takes precedence over the same option specified in a file read
earlier. Options specified on the command line take precedence over
options specified in any option file. Some options can be specified
using environment variables. Options specified on the command line or
in option files take precedence over environment variable values. See
Appendix A [Environment variables], page 540.
--
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: Remote Access to SQL Server via Internet
At 05:19 PM 07/13/2001 , you wrote: Hi, I would like to be able to create some tables in a database on an SQL server at my web provider, then access those tables via a client application running on my PC over the Internet (dial-up connection). My understanding is that the client application accesses the SQL server via TCP/IP and not ODBC. My web provider says no way. They can enable an ODBC connection for one static IP address, which is not an acceptable solution, because a) I don't want to use ODBC, and b) my dial-up connection may use one of a range of IP addresses. They will not let me have direct TCP/IP access to the database. My question is why my ISP would say this. Of course the database is password protected, so I don't see why direct access is any more a security risk than using their web-based client. Is this common practice among ISPs, or do I need to shop for a new one? Any suggestions? Bruce; I have been following this thread, and I'm a little confused. I am a web hosting provider, quite small, but I have some very well connected collocation boxes, one of which is newly setup with MySql/PHP/SSL/ssh12 and optional Telnet. A full blown IP based hosting package on my box is $19.95/mo. Ok, enough advertising. What I'm confused about, and maybe missing something here, is why an ISP/WHP would not grant you remote access to your MySQL database? When I setup the grant tables for a user I give them access to ADD, DROP, etc. for their database only. They don't have access to anyone else's database. So where is the security risk. Generally I don't have telnet running, and by default I allow remote access via ssh 1 or 2. If the user wants to start and run telnet in their own server area that's up to them--they get to clean up after the crackers themselves. The main box is a Solaris, running Ensim Appliance software, and each webhost has RH 6.0, Apache, PHP4, and MySQL 3.22.32. MySQL will be upgraded next month. I am new to administering MySQL, so I would be happy to cut my price substantially to anyone who needs a virtual home in exchange for a little help in understanding and using MySQL. Please don't take this as a blatant opportunity to advertise, that's not my intention--however, feedback or criticism gladly accepted. Joe -- Bruce Vander Werf [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
Re: changing servers
using mysqlimport Usage: mysqlimport [OPTIONS] database textfile... HTH -- Bill Omer wrote: I was able to use mysqldump to 'dump' the databases in to a file. However, I'm not able to figure out how I can recreate the databases on the new server using this file. Any suggestions? Thanks, Bill Omer On Friday 13 July 2001 16:04, Tillema, Glenn wrote: Bill, I think you want to use mysqldump. Check here for documentation on it; http://www.mysql.com/doc/m/y/mysqldump.html cheers, Glenn Glenn Tillema [EMAIL PROTECTED] ADC Telecommunications, Inc. PO Box 1101, MS 508 Minneapolis, MN 55440-1101 Learn about ADC - The Broadband Company - www.adc.com -Original Message- From: Bill Omer [mailto:[EMAIL PROTECTED]] Subject: changing servers Hello, We are installing a new server, and I'm having to transfer the databases in MySQL from the old server to the new one. However, I know _very_ little (almost nothing) about MySQL. Could someone please offer me any help/suggestions/advice on how I could do this? -- Regards, Bill Omer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Michael B. Weiner, Linux+, Linux+ SME Systems Administrator/Partner The UserFriendly Network (UFN) -- Linux Registered User #94900Have you been counted? http://counter.li.org PGP: 30 1D CC BA 30 30 63 35 CD 58 E0 89 A9 17 CC C0 8C 55 F7 72 .Escape the 'Gates' of Hell `:::' ... .. ::: * `::.::' ::: .:: .:.::. .:: .:: `::. :' ::: :: :: :: :: :::::. ::: .::. .:: ::. `. .:' ::. ...:::.::' ... -- S/MIME Cryptographic Signature
Re: MySQL Variables
At 12:25 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... But if I use /Path/specialMySQL/var/my.cnf and my option file contains: [client] port=14551 socket=/tmp/LassoMySQL.sock Then, invoking the client from within /Path/specialMySQL/bin/mysql would use the different port and socket? And, using /usr/local/mysql would then use the default datadirectory and port? 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. BTW, this is on Mac OS X, I wouldn't think it would matter but I thought to mention it. Shouldn't make any difference. I've noticed no special problems with MySQL on Mac OS X other than that mysqladmin shutdown doesn't work. -- 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 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Remote Access to SQL Server via Internet
At 05:19 PM 07/13/2001 , you wrote: Hi, I would like to be able to create some tables in a database on an SQL server at my web provider, then access those tables via a client application running on my PC over the Internet (dial-up connection). My understanding is that the client application accesses the SQL server via TCP/IP and not ODBC. My web provider says no way. They can enable an ODBC connection for one static IP address, which is not an acceptable solution, because a) I don't want to use ODBC, and b) my dial-up connection may use one of a range of IP addresses. They will not let me have direct TCP/IP access to the database. My question is why my ISP would say this. Of course the database is password protected, so I don't see why direct access is any more a security risk than using their web-based client. Is this common practice among ISPs, or do I need to shop for a new one? Any suggestions? If your hosting provider runs SSH on the server, get an SSH client that does tunneling. Create a tunnel from your local machine on any port (3306 works well :), to port 3306 (or whatever port MySQL is running on) on the remote computer. When you log the SSH session in (the ssh.com client can do tunnels only), you have local access to the database. As far as the system is concerned, you're local to it. As far as your client app is concerned, the DB is on localhost. As far as anyone else is concerned, the passwords and all traffic is encrypted. -- Sapere aude My mind not only wanders, it sometimes leaves completely. - 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
Alright. I have received Mr. Johnson's permission to share the email response he made to me. it is included herewith for informational purposes without comment or prejudice: cut here NOTE: personal opening comments removed for brevity mysql.org has not been publically announced and it will take some time for it to become the thriving community it is destined to be. My hope is that rather than fighting it, you can join it and be part of an even more vibrant mysql community. It is disappointing that our friends from MySQL AB seem threatened by the creation of noncommercial site to promote mysql that they jump in and announce it themselves to the world and claim they were not informed. The facts are they were informed and invited to participate, their response is what you have read. You mention specifically that you believe we have no right to the domain name. The facts are that we believe we have a right under an agreement that was signed by both Monty and David that provided us with broad rights to mysql related names. In fact we paid a significant sum of money for the ability to use those names and other items and that same agreement in fact required MySQL to be released under the GPL. Now that MySQL AB has taken on venture capital funding and hired new management, they want to ignore those agreements. Your comments about us not participating in any meaninful fashion in the open source community are disappointing because it means NuSphere has not done a good job communicating its work, I believe we provide a significant service and have allowed many people who otherwise could not use open source software to use it because of our work on improving windows ports, integration of components, and major features. We contribute back fixes and improvements to many open source communities including apache, perl, php and mysql. Much of that work is available at no cost through downloads at our website. I'd invite you to download and try NuSphere MySQL and see an example of what we have done. The importance of our investment is reflected in Monty's own words: NuSphere has identified a very important technical enhancement needed to transform MySQL into an enterprise-enabled database capable of competing with commercial heavyweights, said Michael Monty Widenius, chief technology officer of MySQL AB. In MySQL's five-year history, this is the most significant contribution from a source outside MySQL AB that has ever occurred. We also support the community by sponsoring and helping organize events such as the OSCON 2001 with O'Reilly, Open Source Database Summit with OSDN, and the Linux Legacy through Geek Cruises to name a few. We are proud of the significant investment we make in these areas so that the open source community can meet and learn from each other face to face. As we said last January, we planned on Gemini being released under an open source license as part of the launch of MySQL 4.0, but that release has not shipped so we have decided to release the source through mysql.org instead soon after its launch (the community needs to setup CVS to support that effort). Note that Gemini has both commercial and open source licenses just like MySQL itself and the products we are currently shipping are provided with a commercial license of Gemini. We absolutely believe we have the right to do this. In closing, I hope you will take a moment to see things from our perspective and understand that we want a strong mysql community as strong as apache or php and one that is not controlled by a single commercial company. Thanks for your time, Britt... -- D. Britton Johnston 603-578-6707 Nashua Chief Technology Officer 781-280-4954 Bedford NuSphere Corporation 781-280-4600 Main 14 Oak Park 781-280-4646 Fax Bedford, MA 01730 www.nusphere.com cut here - 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
Loop an INSERT from form
I need to insert x amount of rows from one form. The form displays x
amount of rows. I then need to insert the values from the form x amount
of times. The form loop works fine but how do I INSERT x amount of
times within a loop from the values of the form? I think I need to use
some sort of array. I suck at arrays.
This executes when submit is hit:
$i = 1;
while ($i = $songsinalbum) {
$query = INSERT INTO songs VALUES ('$id',
'$songname','$rating','$video', '$album_id', '$movie');
$result = mysql_db_query(movies, $query);
};
Here is form:
form enctype=multipart/form-data method=post
action=?php echo $PHP_SELF ?
?
$i = 1;
while ($i = $songsinalbum) {
?
TR
TD align=rightID: /TDTDinput type=text name=id value=? echo
$i; ? size=3br/TD
TD align=rightSongname: /TDTDinput type=text name='songname'
size=30br/TD
TD align=rightRating: /TDTDinput type=text name='rating'
value='***' size=5 maxsize=5br/TD
TD align=rightVideo ID: /TDTDinput type=text name='video'
size=2 maxsize=3br/TD
TD align=rightAlbum ID: /TDTDinput type=text name='album_id'
value=? echo $id; ? size=2 maxsize=3br/TD
TD align=rightMovie ID: /TDTDinput type=text name='movie'
size=2 maxsize=3br/TD/TR
?
$i++;
};
?
input type=submit name=submit value=Upload
/form
-
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 Solaris 8 Tuning
On Tue, Jul 10, 2001 at 10:11:05AM +0200, Wolf Dieter Brandt wrote: Hi! I am currently installing and testing the latest stable version of mysql with an sunblade 1000 workstations (2 cpu, 750 MHz, 1 GB RAM). Does anybody know some hints how to tune the OS (solaris performance tuning). It depends. :-) Are you seeing performance bottlenecks already? Make sure you've given MySQL enough memory for it's key_buffer and other buffers. Watch your system closeley and see which appears to be the limiting factor: disk I/O or CPU utilization. Then you can further tune from that point. 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 215,791,475 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
Re: Slightly off-topic... Dump SQL editor thats cross-compat Win/Linux
Or, you could take Grigory's suggestion a step further and make a shell script ... # #!/bin/sh # $1 - Windows filename with extension (case counts) # $2 - Unix filename with extension (case as you want it) cat $1|tr -d '\r' $2 # - Original Message - From: Grigory Bakunov [EMAIL PROTECTED] To: Fred Dinkler [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, July 14, 2001 1:15 PM Subject: Re: Slightly off-topic... Dump SQL editor thats cross-compat Win/Linux Date |Sat, 14 Jul 2001 13:34:40 -0400 From |Fred Dinkler [EMAIL PROTECTED] Hello! FD Creating and editing dbdump SQL files from local dev in Win2k, moving to FD Linux for QA and production. FD Text files edited using Wordpad and Notepad have extraneous line-end chars FD (bold M). FD Any suggestions on configuration of any Win editor to save text without FD garbage chars showing up on Liux side? You can also use simple script like this cat your_windows_file|tr -d '\r' your_unix_file Truly yours, Grigory Bakunov ASPLinux Support Team http://www.asplinux.ru - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Loop an INSERT from form
While loops are quite dangerous when the stop condition never
occurs. This is the case here. You must increment $i to get a
break condition to step out of the loop! Insert $i++; in your
code and you will be fine.
This executes when submit is hit:
$i = 1;
while ($i = $songsinalbum) {
$query = INSERT INTO songs VALUES ('$id',
'$songname','$rating','$video', '$album_id', '$movie');
$result = mysql_db_query(movies, $query);
};
--
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
In response to the posting by Thomas J Keller of Britt Johnston's text, I feel I have to come with the following comments. (The quoted text marked with is by Britt Johnston) mysql.org has not been publically announced and it will take some time for it to become the thriving community it is destined to be. My hope is that rather than fighting it, you can join it and be part of an even more vibrant mysql community. We do not oppose communities that form around a common interest in our product. But we do mind if our trademark is used without authorisation. So we are not fighting the community, we are fighting the violations of our rights. Is there any reason for not operating the site under the nusphere.org name or some other name? It is disappointing that our friends from MySQL AB seem threatened by the creation of noncommercial site to promote mysql that they jump in and announce it themselves to the world and claim they were not informed. The facts are they were informed and invited to participate, their response is what you have read. The last sentence is untrue. MySQL AB was not invited, nor informed of this. The last record we have that relates to mysql.org is from early June when we asked NuSphere to transfer the domain to us, and Lorne Cooper replied that NuSphere refuses to do so. He also noted that NuSphere had not populated the site. We do not oppose any creation of a concommercial site to promote the MySQL server. But we do mind ... (see my comment above). You mention specifically that you believe we have no right to the domain name. The facts are that we believe we have a right under an agreement that was signed by both Monty and David that provided us with broad rights to mysql related names. In fact we paid a significant sum of money for the ability to use those names and other items and that same agreement in fact required MySQL to be released under the GPL. Now that MySQL AB has taken on venture capital funding and hired new management, they want to ignore those agreements. There WAS an interim agreement from June 2000 to be replaced within 3 months by a final agreement. We have confirmed to NuSphere in writing the termination of the interim agreement. It has not been in force for some time. For the records, it was only David Axmark who signed it and faxed it to Progress. Progress or NuSphere have never sent us a version with their signatures. When it was in force, the interim agreement did NOT provide NuSphere with broad rights to use the MySQL name. Under the agreement, Progress paid a total of USD 312,501 with the last check being cut in September 2000. See http://www.mysql.com/news/article-75.html for more information on this. The comment by Britt on vc funding and new management is under the belt in my opinion. Your comments about us not participating in any meaninful fashion in the open source community are disappointing because it means NuSphere has not done a good job communicating its work, I believe we provide a significant service and have allowed many people who otherwise could not use open source software to use it because of our work on improving windows ports, integration of components, and major features. We contribute back fixes and improvements to many open source communities including apache, perl, php and mysql. Much of that work is available at no cost through downloads at our website. I'd invite you to download and try NuSphere MySQL and see an example of what we have done. I would hope the discussion could stay away from topics of this sort. We appreciate and respect many things NuSphere, and Britt personally, have done. The importance of our investment is reflected in Monty's own words: NuSphere has identified a very important technical enhancement needed to transform MySQL into an enterprise-enabled database capable of competing with commercial heavyweights, said Michael Monty Widenius, chief technology officer of MySQL AB. In MySQL's five-year history, this is the most significant contribution from a source outside MySQL AB that has ever occurred. MySQL AB is not trying to devalue the investment in Gemini. But there are people who believe that NuSphere or Progress paid MySQL AB $2.5 million and that NuSphere is somehow part of the MySQL server development team, none of which is true. Therefore we have communicated that the development of the MySQL server is done by and funded by MySQL AB alone. We also support the community by sponsoring and helping organize events such as the OSCON 2001 with O'Reilly, Open Source Database Summit with OSDN, and the Linux Legacy through Geek Cruises to name a few. We are proud of the significant investment we make in these areas so that the open source community can meet and learn from each other face to face. This is fine, and nobody wants to take that pride away from NuSphere. However, from our perspective this is not related to the
RE: Loop an INSERT from form
On 14-Jul-01 David wrote:
I need to insert x amount of rows from one form. The form displays x
amount of rows. I then need to insert the values from the form x amount
of times. The form loop works fine but how do I INSERT x amount of
times within a loop from the values of the form? I think I need to use
some sort of array. I suck at arrays.
This executes when submit is hit:
$i = 1;
while ($i = $songsinalbum) {
$query = INSERT INTO songs VALUES ('$id',
'$songname','$rating','$video', '$album_id', '$movie');
$result = mysql_db_query(movies, $query);
};
$vals='';
for ($i=0; $i= $songsinalbum; $i++) {
$vals .=, ('$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, 'br;
$res=mysql_query($qry);
...
Here is form:
TD align=rightSongname: /TDTDinput type=text name='songname[]'
size=30br/TD
TD align=rightRating: /TDTDinput type=text name='rating[]'
etc.
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Escaping * character in a RLIKE? How? Help?
I have a very simple query that used to work and then recently stopped. It goes something like: SELECT name FROM Items WHERE category RLIKE '^\* new cat \*'; Now, I'm pretty familiar with how regex works, and I was pretty sure that when I put a \ in front of the * it would interpret it as a * instead of the 0 or more of previous operator. But it's giving me the following error: Got error 'repetition-operator operand invalid' from regexp I really need to figure this out. I was told by someone to double-escape them (like ^\\* new..), but to me that would read as 0 or more \ characters at the beginning of the string, not a string that starts with the * character which is what I need. Help? - 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: Escaping * character in a RLIKE? How? Help?
At 3:15 PM -0700 7/14/01, xris wrote: I have a very simple query that used to work and then recently stopped. It goes something like: SELECT name FROM Items WHERE category RLIKE '^\* new cat \*'; Now, I'm pretty familiar with how regex works, and I was pretty sure that when I put a \ in front of the * it would interpret it as a * instead of the 0 or more of previous operator. But it's giving me the following error: Got error 'repetition-operator operand invalid' from regexp I really need to figure this out. I was told by someone to double-escape them (like ^\\* new..), but to me that would read as 0 or more \ characters at the beginning of the string, not a string that starts with the * character which is what I need. Help? Did you try the advice you were given? What happened? -- 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
.org
In the interests of stemming some of the flood of invective being directed against NuSphere... I am an employee of NuSphere. Those of you who feel it necessary immediately to jump up and denounce NuSphere for their sins, please ask yourself: Do you think I'd work for them if I thought they were a bunch of scumbags? They're not. NuSphere is interested in promoting MySQL, not in destroying it. For example, they pay me a salary to support my writing about MySQL full time, and they make no demands that I mention NuSphere in my books (though they're of course happy if I do). You'll see some of the fruit of this support next month when the MySQL/Perl book comes out - a book that I hope will be of some service to the MySQL community. The dispute will be worked out by the parties involved. Nobody's happy about it, but resolving it is difficult because both sides feel they have a reasonable position. You can see this from the messages being posted by the directors of MySQL AB and NuSphere. And of course once the lawyers get involved, things don't get any easier. Make your opinions known, certainly. You're all part of the MySQL community and your views are valuable. But please, leave the flames out of it. They're not constructive. Please be clear what I'm saying. I am an employee of (not an apologist for) NuSphere, and I'm not saying don't criticize NuSphere. I'm saying that flames aren't helping anything, particularly if you are not in possession of all the facts behind the dispute. No one at NuSphere has asked that I write this. They've asked me for feedback, but no one has suggested that I take a side. I am reluctant to do so anyway because it's not clear that there's any merit in doing so, and I don't think I have all the facts, either. Paul DuBois Author, MySQL (the book, not the server!) -- 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
Marten Mickos wrote: In response to the posting by Thomas J Keller of Britt Johnston's text, I feel I have to come with the following comments. (The quoted text marked with is by Britt Johnston) mysql.org has not been publically announced and it will take some time for it to become the thriving community it is destined to be. My hope is that rather than fighting it, you can join it and be part of an even more vibrant mysql community. We do not oppose communities that form around a common interest in our product. But we do mind if our trademark is used without authorisation. So we are not fighting the community, we are fighting the violations of our rights. Is there any reason for not operating the site under the nusphere.org name or some other name? Now on this point, in consideration of the assertions of a temporary agreement which MySQL AB asserts to have formally terminated, NuSphere would appear to be violating MySQL AB's trademark. Marten's question regarding another name is quite proper. Unless NuSphere can provide solid evidence that there is a current formal agreement in force at this time, my opinion (humble, not huble, or otherwise *grin*) is that NuSphere should post-haste transfer mysql.org to MySQL AB. This is a sticky legal point, since both parties would appear to have differing interpretations of the nature, term and status of any agreement between them. It is disappointing that our friends from MySQL AB seem threatened by the creation of noncommercial site to promote mysql that they jump in and announce it themselves to the world and claim they were not informed. The facts are they were informed and invited to participate, their response is what you have read. The last sentence is untrue. MySQL AB was not invited, nor informed of this. The last record we have that relates to mysql.org is from early June when we asked NuSphere to transfer the domain to us, and Lorne Cooper replied that NuSphere refuses to do so. He also noted that NuSphere had not populated the site. We do not oppose any creation of a concommercial site to promote the MySQL server. But we do mind ... (see my comment above). Another point where the two parties would appear to have differing interpretations of events. You mention specifically that you believe we have no right to the domain name. The facts are that we believe we have a right under an agreement that was signed by both Monty and David that provided us with broad rights to mysql related names. In fact we paid a significant sum of money for the ability to use those names and other items and that same agreement in fact required MySQL to be released under the GPL. Now that MySQL AB has taken on venture capital funding and hired new management, they want to ignore those agreements. There WAS an interim agreement from June 2000 to be replaced within 3 months by a final agreement. We have confirmed to NuSphere in writing the termination of the interim agreement. It has not been in force for some time. For the records, it was only David Axmark who signed it and faxed it to Progress. Progress or NuSphere have never sent us a version with their signatures. This is in essence the same differing interpretation problem as noted above. When it was in force, the interim agreement did NOT provide NuSphere with broad rights to use the MySQL name. Under the agreement, Progress paid a total of USD 312,501 with the last check being cut in September 2000. See http://www.mysql.com/news/article-75.html for more information on this. Well, in the face of radically different interpretations, I see a few possible ways to resolve this: First: take it to court. Potentially expensive, and probably not good for public relations for either party. Second: (and I fully note that there could be any number of valid and compelling reasons for either or both parties to find this suggestion untenable) post the text of the agreement here, for the community to peruse. This suggestion carries with it an implicit expectation that the parties would be expected to abide by the opinion of the community (assuming an overwhelming majority interpret the agreement one way over another). Third: NuSphere could, in the interests of peace within the community, transfer the domain name to MySQL AB, and MySQL AB could back off the GPL violation issue (this presumes that NuSphere brings themselves into compliance with GPL immediately). Intent is an important issue here. It is entirely possible that NuSphere understood their procedures to be in compliance with GPL, and that MySQL believes them not to be, with both parties acting in good faith. NuSphere can confirm their good faith by accepting that their release is problematic and rectifying the situation immediately. MySQL AB can confirm their good faith by accepting this gesture and relenting on the GPL licensing issue. The comment by Britt on vc funding
Re: Escaping * character in a RLIKE? How? Help?
At 6:15 PM -0500 7/14/01, Paul DuBois wrote: At 3:15 PM -0700 7/14/01, xris wrote: I have a very simple query that used to work and then recently stopped. It goes something like: SELECT name FROM Items WHERE category RLIKE '^\* new cat \*'; Now, I'm pretty familiar with how regex works, and I was pretty sure that when I put a \ in front of the * it would interpret it as a * instead of the 0 or more of previous operator. But it's giving me the following error: Got error 'repetition-operator operand invalid' from regexp I really need to figure this out. I was told by someone to double-escape them (like ^\\* new..), but to me that would read as 0 or more \ characters at the beginning of the string, not a string that starts with the * character which is what I need. Help? Did you try the advice you were given? What happened? I decided to follow my own advice and check it out: mysql select '* new cat * ' rlike '^\* new cat \*'; ERROR 1139: Got error 'repetition-operator operand invalid' from regexp Okay, that matches what you got. Now to try double-\\ with a string that should match: mysql select '* new cat * ' rlike '^\\* new cat \\*'; +-+ | '* new cat * ' rlike '^\\* new cat \\*' | +-+ | 1 | +-+ 1 row in set (0.00 sec) And with a string that should not: mysql select ' * new cat * ' rlike '^\\* new cat \\*'; +--+ | ' * new cat * ' rlike '^\\* new cat \\*' | +--+ |0 | +--+ 1 row in set (0.00 sec) Looks like the double-\ is the correct thing. Your reasoning about why it wouldn't work is correct, except for one thing: one backslash gets stripped at the lexical level during the query parsing phase. That leaves the other one to be interpreted during query execution. That's why \\* and \* doesn't. -- 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: Loop an INSERT from form
Thanks for the help
I tried your code and received error.
Warning: No ending delimiter '^' found in addsongs.php on line 26
Songname: Array
INSERT Failed, check the code.
The code was: $vals=preg_replace('^,', '', $vals); // chop leading comma
Is the ^ an escape character so you can enter a comma within ' ' ?
I couldn't find reference to ^ as an escape character in php docs.
http://www.php.net/manual/en/function.preg-replace.php
I also tried '/,'
Warning: Unknown modifier ',' in /var/www/html/databases/music/addsongs.php on
line 26
Songname: Array
.
Any ideas?
Don Read wrote:
On 14-Jul-01 David wrote:
I need to insert x amount of rows from one form. The form displays x
amount of rows. I then need to insert the values from the form x amount
of times. The form loop works fine but how do I INSERT x amount of
times within a loop from the values of the form? I think I need to use
some sort of array. I suck at arrays.
This executes when submit is hit:
$i = 1;
while ($i = $songsinalbum) {
$query = INSERT INTO songs VALUES ('$id',
'$songname','$rating','$video', '$album_id', '$movie');
$result = mysql_db_query(movies, $query);
};
$vals='';
for ($i=0; $i= $songsinalbum; $i++) {
$vals .=, ('$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, 'br;
$res=mysql_query($qry);
...
Here is form:
TD align=rightSongname: /TDTDinput type=text name='songname[]'
size=30br/TD
TD align=rightRating: /TDTDinput type=text name='rating[]'
etc.
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
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
This is very interesting, this Open Source Legal Resolution ;-) Indeed it is. The thing I find most interesting, and a bit scary, is the way people seem to pick sides. For example - vermin, scum, obscure, are just a few of the words recently used to describe the likes of NuSphere. (And to the surprise of many, including myself, that includes our beloved Mr. DuBois.) And people base their opinions on what!? The statements of the opposing party. Did people verify the claims of MySQL and NuSphere? Was there an agreement? Was it, indeed, interim? Is a termination sent by fax even legal? Does MySQL even hold the US trademarks? (Answer: No, not yet as far as the online trademark searchengine is concerned - their application is in the mail.) An open conflict like this is indeed interesting, but people have based and will be basing their opinions on a distorted or incomplete picture of the whole conflict, because by nature, statements by two fighting parties are biased and should not be trusted until verfied true. This is a dangerous game to play, and the side with the best PR team / largest fanbase will always win the favor of the public. (See: Microsoft product sales figures.) Accepting that NuSphere employees are the spawn of the devil just because MySQL (or anyone else) says they are is not something I'm prepared to do. Where I live people are innocent until *proven* guilty, and so far there has been little real proof. Just both sides of a story, but little proof that can be easily verified by 3rd parties. Don't get me wrong here. The fact that there is a conflict at all means that someone, somewhere did something wrong. But it is most likely not a simple case of a good guy / bad guy. I just hope that people can post their comments in a rational way, without jumping to conclusions too fast. (Just what Mr. DuBois said a few posts back.) And about the domain - I think that MySQLs claim on the .ORG domain is a lot weaker then they want us to believe. (no US trademark YET, no attempt to gain control of the .NET and .ORG for the past years with the excuse 'friendly' people controlled them, etc) BUT, I still think that NuSphere should give it up. For the following reasons: 1) It was just launched, it does most likely not have a real large userbase yet, so changing it now would be relatively simple and cheap. 2) It is confusing. (The .COM/.ORG stuff) 3) Someday soon, MySQL will probably be granted their US trademarks, and when that happens it will be pried out of their hands. Since we're talking about a non-profit site, the fees that NuSphere is going to have to pay to lawyers to defend themselves would basically a waste of money. Is the .ORG domain worth that much to NuSphere? 4) It pisses off MySQL AB. Clearly it's in their best interest to be friends with MySQL AB. 5) Although MySQLs pressrelease (on MySQL.COM, Slashdot, etc) telling people NOT to visit MySQL.ORG probably had the effect that the site had more visitors then ever before (*1), it still was in a somewhat negative way they came to that site. Getting rid of the domain might get rid of some nasty memories of some potential clients. (*1 - who wouldn't want to see a real obscure website?! I only went to see MySQL.ORG after I saw MySQL AB's pressrelease. And with that thing posted on slashdot, my bet is that MySQL.ORG had a truckload of traffic most starting websites would be jealous of.) And last - 6) IMHO, two MySQL community sites is one too many. Why don't you guys play together? NuSphere stated they wanted to create a non-profit site, maybe ran by a 3rd party. MySQL AB said they wanted to expand their MySQL site. If you take a few steps back from this conflict then I'd see no reason not to cooperate. But then again, that's just me and my ?0.02 -S - 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
The more I think about this, the more convinced I am that someone needs to offer the following observations: It is unfortunate that so many people within this community are so eager to assume the worst about a company, simply because they ARE a company. Not all corporations are Mickey$lu$h (I guess my biases in this regard are obvious), and not all corporate leaders are Bill Gates. Bring in business to make a profit is not a bad thing. One might note that David and Monty are in business to make a profit, and by their own statements, this was always their intent. Good on them! As has been pointed out by several people, including myself, some of the issues involved in this dispute are very tricky and difficult to understand, even if one had ALL the relevant information to hand. The fact is that very few (perhaps 3?) of the participants in this brouhaha have more than a modicum of real information available to them. There have been comments made by both parties which are arguably less than totally correct. There have also been many comments made that perhaps should not have been. Big surprise, with both money and pride involved, people get hot under the collar when others don't see things THEIR way! The people who tend to become involved heavily in the Open Source community are often highly opinionated (who, ME?!) and quick to form judgements. This can work against us as a community when it leads to the kinds of recrminations and attacks we have seen here. The unfortunate truth is that when millions or billions of dollars are on the line, and when highly sophisticated legal concepts such as intellectual property and licensing are involved, it often requires people with special training (OK, I'll say it: lawyers) to sort things out. It is important to realize also that all any lawyer can do is offer their opinion and interpretation of the law. Only the Courts can offer a final statement as to the actual meanings of laws, and even then, things are seldom clear cut. Remember that laws have no inherent validity or meaning. They are abstract intellectual creations dreamed up by human beings, and are subject to the inherent inefficiencies of language. I seriously doubt that anyone from either of these companies has any nefarious intentions. Although some things have been said on both sides which may turn out not to be true, I rather suspect that this is due to differences of opinion, coupled with a little anger, rather than intentional mendacity. So...the upshot of all this, I suppose is: cool off, everyone. Let's see if the folks at MySQL AB and NuSphere can resolve this to their mutual satisfaction. Above all, PLEASE, let's stop calling each other names. None of us are little children here. tom - 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
Thomas, thanks for your suggestions. A few clarifications below. Thomas J Keller wrote: Marten Mickos wrote: In response to the posting by Thomas J Keller of Britt Johnston's text, I feel I have to come with the following comments. (The quoted text marked with is by Britt Johnston) mysql.org has not been publically announced and it will take some time for it to become the thriving community it is destined to be. My hope is that rather than fighting it, you can join it and be part of an even more vibrant mysql community. We do not oppose communities that form around a common interest in our product. But we do mind if our trademark is used without authorisation. So we are not fighting the community, we are fighting the violations of our rights. Is there any reason for not operating the site under the nusphere.org name or some other name? Now on this point, in consideration of the assertions of a temporary agreement which MySQL AB asserts to have formally terminated, NuSphere would appear to be violating MySQL AB's trademark. Marten's question regarding another name is quite proper. Unless NuSphere can provide solid evidence that there is a current formal agreement in force at this time, my opinion (humble, not huble, or otherwise *grin*) is that NuSphere should post-haste transfer mysql.org to MySQL AB. This is a sticky legal point, since both parties would appear to have differing interpretations of the nature, term and status of any agreement between them. Our interpretation is that even under the interim agreement, the operation by NuSphere of mysql.org would have been a trademark violation. It is disappointing that our friends from MySQL AB seem threatened by the creation of noncommercial site to promote mysql that they jump in and announce it themselves to the world and claim they were not informed. The facts are they were informed and invited to participate, their response is what you have read. The last sentence is untrue. MySQL AB was not invited, nor informed of this. The last record we have that relates to mysql.org is from early June when we asked NuSphere to transfer the domain to us, and Lorne Cooper replied that NuSphere refuses to do so. He also noted that NuSphere had not populated the site. We do not oppose any creation of a concommercial site to promote the MySQL server. But we do mind ... (see my comment above). Another point where the two parties would appear to have differing interpretations of events. When we learned in June that NuSphere had registered the mysql.org domain and refused to sign it over to us, we started to routinely attempt to visit the site. It happened to be me personally who found the populated site on Monday 9 July. That is the first moment we were aware of the site having been populated and at no point have we been aware of any -plans- to populate it. I would very much want to learn how NuSphere claims we were informed and invited and when that would have happened. We have presented all evidence we have on this issue, and it would be time for NuSphere to do the reciprocal. If Britt can fill in on this, please do so. You mention specifically that you believe we have no right to the domain name. The facts are that we believe we have a right under an agreement that was signed by both Monty and David that provided us with broad rights to mysql related names. In fact we paid a significant sum of money for the ability to use those names and other items and that same agreement in fact required MySQL to be released under the GPL. Now that MySQL AB has taken on venture capital funding and hired new management, they want to ignore those agreements. There WAS an interim agreement from June 2000 to be replaced within 3 months by a final agreement. We have confirmed to NuSphere in writing the termination of the interim agreement. It has not been in force for some time. For the records, it was only David Axmark who signed it and faxed it to Progress. Progress or NuSphere have never sent us a version with their signatures. This is in essence the same differing interpretation problem as noted above. When it was in force, the interim agreement did NOT provide NuSphere with broad rights to use the MySQL name. Under the agreement, Progress paid a total of USD 312,501 with the last check being cut in September 2000. See http://www.mysql.com/news/article-75.html for more information on this. Well, in the face of radically different interpretations, I see a few possible ways to resolve this: First: take it to court. Potentially expensive, and probably not good for public relations for either party. Second: (and I fully note that there could be any number of valid and compelling reasons for either or both parties to find this suggestion
Re: .org
Paul DuBois wrote: In the interests of stemming some of the flood of invective being directed against NuSphere... [== snip, snip ==] Paul: I have a certain sympathy for your personal discomfort. I feel that you/NuSphere are the victims of a kind of natural aspect of the human condition... This kind of discussion is difficult to keep flames out of. It is similar to trying to have a rational discussion about the virtue of Maria of Jersey City, with the older brother Salvatore... You have: 1. The great reservoir of goodwill that has been accumulated by MySQL AB over the years 2. The natural tendency to impugn sinister motives to anyone that disturbs this goodwill 3. The ease and anonomity provided by email to react What is usually never considered: 1. Heros _can_ make mistakes, and/or there are always two sides to every question 2. To extend good faith to both parties However, there are always two sides to every question, and disputes can easily arise out of any business relationship that range from innocent misunderstandings to covert manipulations. And, the third parties observing cannot know, apriori, what is true. For whatever worth it may have, I do not consider that you/NuSphere have left the human race, are scumbags, or members of the Evil Empire, as many on this list have knee-jerked to. That is probably small comfort. You are just stuck with your lot, for the moment. What I find so terribly interesting about this whole affair is how it is being, to some extent, settled, or at least converging on a settlement/understanding, right here in front of the eyes of the entire Community. To me this is a kind of historic phenomena. Cheer up. _jef -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - 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: 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? (I don't know about US legal aspects here, but I'ld assume in the mail is rather different from finished...) morecuts /morecuts /serious halfwayserious 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...) The track of needed documents will grow quite rapidly here. You might want a 3rd party, not-for-profit web site to publish it all. (Something like www.mysql-open-source-legal-resolution.org hosted by NuSphere *evilgrin*. This would be an application of broad name related usage rights...) /halfwayserious serious In any case, 1) Money always is the reason why a company is in business to do business. 2) As Tom DeMarco writes in one of his latest books, lawyers don't add much, since they cost money, take you out of your business, which is making money, and tend to destroy all good faith one would have for another. ... Not to disrespect either party, but I'm not to take a stand as I don't know any of the NuSphere products around MySQL. Take care of yourself, and eachother, Guus Short-time Mysql user. /serious PS: table, query, sql, database - 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 - an extra 2 cents
Regarding the recent thread on NuSphere. ( Jeapardy style so you don't have to read it again) GPL violation or not, part of my decisions are always based on morals (hard to find these days). Anyone trying to capture an audience using anothers name is un-ethical and un-moral. My business decision will be made with this in mind. Sometimes it is not the best business decision but I can always live with it. Joel Nelson Gerald R. Jensen wrote: Monty: I was on the verge of authorizing the purchase of 3 copies of NuSphere's PHPEd package (US$300 each) for our developers when I became aware of the controversy surrounding 'Enhanced MySQL' and mysql.org. The purchase order went into the round file, and Hell will freeze over before I buy anything from NuSphere. A small gesture, perhaps, but an appropriate one. At least our company won't be contributing to their largess. Even people with such deplorable business ethics understand a loss of income from sales. [ snip, snip ===] Do not jump to the conclusion that I am starting out to be an apologist for NuSphere/Progress. It is wise to honor the old dictum Never ascribe malice to that which can be attributed to ignorance. I am not sure if this type of emotional leap is proper until a bit more information comes out and some of the heat dies down. There are always two sides to every situation. There are two issues, the domain mysql.org, and the other, more difficult to understand, the aspect of GPL violation. The domain/trademark issue will get settled by legal means and there is enough of a corpus of law precedent that a settlement and/or judgement will occur. I personally do not see such a great importance of mysql.org in this matter. Obviously, many of you on this list do not share this opinion. Now most of us in/using Open Source probably do not _really_ understand the meaning and ramifications of the GPL. We _think_ we know, and we certainly have a feeling about what the GPL means. Ironically, Richard Stallman's take is, in a legal sense, crystal clear compared with the GPL. NuSphere indicated that is was going to put their products under the GPL. They have indicated that Gemini will be GPL's. Are they to be punished for being late in doing so? NuSphere supports Open Source and is public on this position. The irony of this situation is that it _may_ be to the advantage of the Open Source community if NuSphere is not knee-jerked pilloried, and tarred and feathered out of the minds of the Open Source community. It is complete speculation upon my part that ultimately, MySQL will be replaced in all those embedded applications where Progress now sits. Though it may change in the near future, commercial developers needing an embedded database usually prefer a solution like Progress because of the Company-behind-it, rather than have MySQL. MySQL may/would gain credibility if Progress is replaced. Now, I hope this is all settled to everybody's benefit. It may not be possible because of emotion. But I know that I would personally like to see MySQL start to creep into large manufacturing management systems and other systems where Progress now has a significant hold. Then, and only then, will the community be able to easily tap into MySQL and offer better intranets, tools, and other solutions. So, I am suggesting to everyone to just wait and see. It might not be as bad as it seems... -- Justin Farnsworth - Technical Director Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - 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
Newbie Questions
OK, mr newbie here. I'm trying to lern SQL using MySQL. I have a general SQL book, Sams Teach Yourself SQL in 10 Minutes, by Ben Forta. I also have mSQL and MySQL fromO'Reilly. And of course i have the MySQL Manual. The 10 minute book's syntax sometimes doesn't fit MySQL's, so I try to find the MySQL way by trial and error, or ny the O'Reilly book. Some times this works and sometines I fail. For instance, the 10 min book has a query: SELECT cust_contact FROM Customers WHERE cust_contact LIKE '[JM]%' ORDER BY cust_contact; The reply is: Empty set (0.02 sec) So I need to know the correct syntax for this query, such that it returns only cust_contacts which begin with J or M. I have searched the Manual and so on. Point me in the right direction or something. -- Bob Rea Fear of Hell is pernicious; So is fear of Heaven. [EMAIL PROTECTED] http://www.sirius.com/~rear - 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
community, open source, gpl, tld's.. these are long, long discussions, some pertinent, though not to this valuable list. i've read many opinions, respect some, but these are for lawyers, not hackers (in linus' sense of the word). nevertheless, there is a message for us nerds: let's keep it open!!! our greatest allies will be our peers, not some guys from legal. so, write decent code, open it wide, and rejoice. when this all started, i waited anxiously for monty's post. took me a while to digest it (may i suggest all of the involved in the whole discussion do so as well). my humble conclusion is: i'm really glad mysql ab is focused on development and training, and not on courts and deals. i believe many in our programming community feel the same. monty, keep it up!!! as north americans would say: mysql kicks some serious a**. btw: thank you so very much. warm regards to all mauricio portasio [EMAIL PROTECTED] sao paulo - brazil On Sat, Jul 14, 2001 at 03:10:34AM -0400, 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 good to see some discussion taking place here. Perhaps it will help make the issues a bit clearer to the folks who have been wondering what they heck is going on (that's the majority of the community). As far as NuSphere's contribution to MySQL, it is disappointing to see our efforts discounted so quickly. I don't think that folks are discounting your efforts. In many cases, folks knew little of what NuSphere had really done to date. 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 be released via mysql.org as GPL as previously announced - note that Gemini itself is not a derivative of MySQL in any way - it's roots date back to long before MySQL existed. There's another source of confusion for people. The difference between the Gemini table handler and the Gemini component itself. What is the difference? (I think I might know, but I suspect that it's not clear to folks who haven't heard you talk about Gemini in person.) Finally independent of the rest of this. I have the highest respect for Monty and what he has done creating MySQL. A sentiment we all share. And some (many?) of us realize that NuSphere has a done some incredible work in an effort to take MySQL up a notch. NuSphere's talent and responsiveness was clear to me during the Gemini beta program. I'm certain we can move beyond this and make MySQL an even stronger open source project and I encourage everyone move to a constructive dialog. I suspect that in the short term, the legal battles are likely to become less interesting to this community than: * Being presented with the mysql.org site and not understanding where it came from, who runs it, and why they should go there. * The affects that this will have on the community. Are there going to be separate mysql.org hosted mailing lists which overlap in funtionality and audience with those hosted here? * Will it become less clear where users should go for information, documentation, downloads, and so on? * Understanding the differences between NuSphere's MySQL and MySQL AB's MySQL distributions. I know that they are relatively few now, but will that continute to be the case? Who knows. Those are the sort of concerns which motivated my statements in the MySQL press release a few days ago. I think that the MySQL community today is excellent--one of the best surrounding any piece of Open Source software today: Linux, FreeBSD, Perl, Apache, PHP, Python, MySQL, etc. They all have great communities. None of us want to see the community sidetracked, fragmented, or otherwise damaged as a result of this. Having read about the old XEmacs fork from GNU Emacs, that sort of stuff doesn't sound pleasant. We have a great forum for discussion right here. I'd suggest that when feasible, folks should talk to the community. Find out what folks here think about having a new/different web site, forked code, or whatever may be brewing. Unlike slashdot, folks here are apt to think before writing the first thing that pops into their heads. Given that this mailing list has been a large part of the MySQL community, it'd be great to see folks from NuSphere on it in a while. Jeremy (trying not to fuel any fires) -- 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 213,565,627
RE: mysql.org
-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? (I don't know about US legal aspects here, but I'ld assume in the mail is rather different from finished...) These are the two primary applications: http://tarr.uspto.gov/servlet/tarr?regser=serialentry=76253509 (MYSQL) New application assigned to an examining attorney for examination http://tarr.uspto.gov/servlet/tarr?regser=serialentry=78002299 (MYSQL) no final determination as to the registrability of the mark has been made. Other trademarks that are related: ENHANCED MYSQL(TM) OFFICIAL MYSQL(TM) (Tried looking for MAXSQL, but didn't find anything.) Real trademarks seem to have a status of Registered. But contact your local trademark attorney for the fineprint and other legal babble about what it all means. IANAL, So for all I know in the mail is good enough to claim it. Other sites that violate the trademark (not including obscure country-tlds): MYSQL.NET XMYSQL.COM MYSQLPHP.COM PHPMYSQL.COM MYSQL-PHP.COM MYSQLHOST.COM -S - 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: Newbie Questions
Try RLIKE or REGEXP -- http://www.mysql.com/docs/S/t/String_comparison_functions.html On Sat, Jul 14, 2001 at 06:39:00PM -0700, Bob Rea wrote: OK, mr newbie here. I'm trying to lern SQL using MySQL. I have a general SQL book, Sams Teach Yourself SQL in 10 Minutes, by Ben Forta. I also have mSQL and MySQL fromO'Reilly. And of course i have the MySQL Manual. The 10 minute book's syntax sometimes doesn't fit MySQL's, so I try to find the MySQL way by trial and error, or ny the O'Reilly book. Some times this works and sometines I fail. For instance, the 10 min book has a query: SELECT cust_contact FROM Customers WHERE cust_contact LIKE '[JM]%' ORDER BY cust_contact; The reply is: Empty set (0.02 sec) So I need to know the correct syntax for this query, such that it returns only cust_contacts which begin with J or M. I have searched the Manual and so on. Point me in the right direction or something. -- Bob Rea Fear of Hell is pernicious; So is fear of Heaven. [EMAIL PROTECTED] http://www.sirius.com/~rear - 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 -- Hank Marquardt [EMAIL PROTECTED] http://web.yerpso.net Web Database Development in PHP, MySQL/PostgreSQL Small Office Networking Solutions - Debian GNU/Linux FreeBSD PHP Instructor - HTML Writers Guild http://www.hwg.org *** PHP II The Cool Stuff starts July 16, 2001 *** http://www.hwg.org/services/classes/p181.1.html - 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
First: take it to court. Potentially expensive, and probably not good for public relations for either party probably the only sentence that makes sense in this affaire from a mysql user point of view, nusphere's move is completely amateur i can't see any intelligent motivation for it, the existence of such a site will only spread confusion, bad press and discredit Mysql as well as open source in general , and oh, isn't nusphere's main stream business Open Source??? can someone from Nusphere explain it here the people from microsoft must be really pleased with this stuff At 01:25 15/07/01, Thomas J Keller wrote: Marten Mickos wrote: In response to the posting by Thomas J Keller of Britt Johnston's text, I feel I have to come with the following comments. (The quoted text marked with is by Britt Johnston) mysql.org has not been publically announced and it will take some time for it to become the thriving community it is destined to be. My hope is that rather than fighting it, you can join it and be part of an even more vibrant mysql community. We do not oppose communities that form around a common interest in our product. But we do mind if our trademark is used without authorisation. So we are not fighting the community, we are fighting the violations of our rights. Is there any reason for not operating the site under the nusphere.org name or some other name? Now on this point, in consideration of the assertions of a temporary agreement which MySQL AB asserts to have formally terminated, NuSphere would appear to be violating MySQL AB's trademark. Marten's question regarding another name is quite proper. Unless NuSphere can provide solid evidence that there is a current formal agreement in force at this time, my opinion (humble, not huble, or otherwise *grin*) is that NuSphere should post-haste transfer mysql.org to MySQL AB. This is a sticky legal point, since both parties would appear to have differing interpretations of the nature, term and status of any agreement between them. It is disappointing that our friends from MySQL AB seem threatened by the creation of noncommercial site to promote mysql that they jump in and announce it themselves to the world and claim they were not informed. The facts are they were informed and invited to participate, their response is what you have read. The last sentence is untrue. MySQL AB was not invited, nor informed of this. The last record we have that relates to mysql.org is from early June when we asked NuSphere to transfer the domain to us, and Lorne Cooper replied that NuSphere refuses to do so. He also noted that NuSphere had not populated the site. We do not oppose any creation of a concommercial site to promote the MySQL server. But we do mind ... (see my comment above). Another point where the two parties would appear to have differing interpretations of events. You mention specifically that you believe we have no right to the domain name. The facts are that we believe we have a right under an agreement that was signed by both Monty and David that provided us with broad rights to mysql related names. In fact we paid a significant sum of money for the ability to use those names and other items and that same agreement in fact required MySQL to be released under the GPL. Now that MySQL AB has taken on venture capital funding and hired new management, they want to ignore those agreements. There WAS an interim agreement from June 2000 to be replaced within 3 months by a final agreement. We have confirmed to NuSphere in writing the termination of the interim agreement. It has not been in force for some time. For the records, it was only David Axmark who signed it and faxed it to Progress. Progress or NuSphere have never sent us a version with their signatures. This is in essence the same differing interpretation problem as noted above. When it was in force, the interim agreement did NOT provide NuSphere with broad rights to use the MySQL name. Under the agreement, Progress paid a total of USD 312,501 with the last check being cut in September 2000. See http://www.mysql.com/news/article-75.html for more information on this. Well, in the face of radically different interpretations, I see a few possible ways to resolve this: First: take it to court. Potentially expensive, and probably not good for public relations for either party. Second: (and I fully note that there could be any number of valid and compelling reasons for either or both parties to find this suggestion untenable) post the text of the agreement here, for the community to peruse. This suggestion carries with it an implicit expectation that the parties would be expected to abide by the opinion of the community (assuming an overwhelming majority interpret the agreement one way over another). Third: NuSphere could, in the interests of
Re: Newbie Questions
At 6:39 PM -0700 7/14/01, Bob Rea wrote: OK, mr newbie here. I'm trying to lern SQL using MySQL. I have a general SQL book, Sams Teach Yourself SQL in 10 Minutes, by Ben Forta. I also have mSQL and MySQL fromO'Reilly. And of course i have the MySQL Manual. The 10 minute book's syntax sometimes doesn't fit MySQL's, so I try to find the MySQL way by trial and error, or ny the O'Reilly book. Some times this works and sometines I fail. For instance, the 10 min book has a query: SELECT cust_contact FROM Customers WHERE cust_contact LIKE '[JM]%' ORDER BY cust_contact; The reply is: Empty set (0.02 sec) So I need to know the correct syntax for this query, such that it returns only cust_contacts which begin with J or M. I have searched the Manual and so on. Point me in the right direction or something. This is what you want: WHERE cust_contact REGEXP '^[JM]' -- Bob Rea Fear of Hell is pernicious; So is fear of Heaven. [EMAIL PROTECTED] http://www.sirius.com/~rear -- 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: Newbie Questions
Date |Sat, 14 Jul 2001 20:38:23 -0500 From |Hank Marquardt [EMAIL PROTECTED] Hello! HM Try RLIKE or REGEXP -- HM http://www.mysql.com/docs/S/t/String_comparison_functions.html Little typo. right url : http://www.mysql.com/docs/S/t/String_comparison_functions.html _ For technical support contracts, visit https://order.mysql.com/ ** This email is sponsored by SWSoft, http://www.asplinux.ru/ ** __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ Glazov, Russia ___/ 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
I am facing this error [ Urgent ]
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
Re: Loop an INSERT from form
Getting closer:
After fixing the form I get:
Add songs for Record Array
INSERT INTO songs VALUES (' blah', ' ***', ' ', ' 1', ' ')Songname[1]=:
blahblah
INSERT Failed, check the code.
Here is the code:
$vals='';
for ($i=0; $i= $songsinalbum; $i++) {
$vals .=, ('$songname[$i]', '$rating[$i]', '$video[$i]', '$album_id[$i]',
'$movie[$i]');
}
// $vals=preg_replace(^,, , $vals);
$vals=preg_replace('/^,/', '', $vals); // chop leading comma
//$vals=preg_replace('//^,/', '', $vals); // chop leading comma
$qry=INSERT INTO songs VALUES $vals;
echo $qry;
$res=mysql_query($qry);
Don Read wrote:
On 14-Jul-01 David wrote:
Thanks for the help
I tried your code and received error.
Warning: No ending delimiter '^' found in addsongs.php on line 26
Songname: Array
INSERT Failed, check the code.
The code was: $vals=preg_replace('^,', '', $vals); // chop leading comma
Is the ^ an escape character so you can enter a comma within ' ' ?
No, in regular expressions that is the start of line, try it using
doublequotes : preg_replace(^,, , $vals);
PHP is weird on this.
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql.org
hassan el forkani wrote: First: take it to court. Potentially expensive, and probably not good for public relations for either party probably the only sentence that makes sense in this affaire from a mysql user point of view, nusphere's move is completely amateur i can't see any intelligent motivation for it, the existence of such a site will only spread confusion, bad press and discredit Mysql as well as open source in general , and oh, isn't nusphere's main stream business Open Source??? can someone from Nusphere explain it here [== snip, snip ==] 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. Anyway, I cannot see this but a pure-and-simple trademark issue, as far as the mysql.org site name is concerned. _jef -- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722 - 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 ]
Hi, What kind of Platform, MySQL Version, etc.? is the mysql daemon running? Guus -Original Message- From: Syed Sumair [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 3:12 AM To: [EMAIL PROTECTED] Subject: I am facing this error [ Urgent ] cut 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
Re: Re: mysql.org
Reposting because of annoying filter. On 15 Jul 2001 [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. You have written the following: Brooklyn Linux Solutions CEO [EMAIL PROTECTED] writes: They are releasing the produce for sale and it MUST be imediately released under the GPL. FTR, that obligation is to customers (or others) getting their binary packages. Something being GPLed doesn't force you to distribute it, it only gives you certain obligations if you do. -- Trond Eivind Glomsrød Red Hat, Inc. - 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
innobase 4gb rows
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. Does anyone have a suggestion? Thanks! Also I have been trying to find a data set that reproduces the two column index bug that was discovered a few weeks back, but I have not been able to... or rather, I havent been able to commit enough time. I should be able too in the following week. Thanks again, ryan - 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
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 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
RE: Security problems - Very Newbie!
C:\mysql grant all on *.* to administrator@sara identified by delboy Try this: C:\mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 463668 to server version: 3.23.39-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql grant all on *.* to administrator@sara identified by delboy; Query OK, 0 rows affected (0.01 sec) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: innobase 4gb rows
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
MySQL on OpenBSD 2.8
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) We did not have this problem when we were running MySQL 3.23.36 on RedHat 7.0. ( I didn't modify the codes I use either) We have recompiled, to update the threads, etc. Can someone help me figure this out, and if so what logs do I need to send to the list to help determine the problem? (Or should I upgrade to 3.23.39?) I appreciate all that you advise, as I have been reading this list for a while now, and have gained many pearls of wisdom from it. --Brian - 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:org
Friends, Wouldn't it be better if we kept the issues to be taken up by lawyers, once they have already been hired and keep this discussion forum to serve the larger purpose for which it was meant to ? As a simple user of services, I am feeling very disappointed at the sight of some of my idols flaming. I would love to have them in their coolest behaviour, as quite often, such remarks/counter remarks utilises that part of the brain, whose life, as we all know is short. Let the brains contribute positively to the growth of mankind, the coming generations. Let us not do something silly, that would make our future generations laugh at us. This doesn't mean that I and other commoners don't have a preference, I certainly do have one, but I wouldn't like to take out your useful time in analysing it. Cheers and God Bless. Raju database,sql,table,query - on webmasters' request - 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: Does anyone remember a MySQL to Oracle schema migration tool?
Hi Tim, lists: m2o.pl, http://www.pythian.com/papers.shtml Cheers, Paul -- Paul Vallee The Pythian Group, Inc - Oracle DBA Outsourcing - www.pythian.com [EMAIL PROTECTED] -- 613-565-8696 - Original Message - From: Tim Bunce [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, July 14, 2001 3:40 PM Subject: Does anyone remember a MySQL to Oracle schema migration tool? I recall that maybe a month or four ago someone posted a message (on the [EMAIL PROTECTED] list I think) saying that they'd written a utility to parse MySQL create table statements and write out equivalent Oracle create table statements. I remember replying to the message (possibly privately) and I'd like to take a look at the utility now, but I can't find the message now (either in my email or online archives). Can anyone help out? Thanks. Tim. - 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
Does anyone remember a MySQL to Oracle schema migration tool?
I recall that maybe a month or four ago someone posted a message (on the [EMAIL PROTECTED] list I think) saying that they'd written a utility to parse MySQL create table statements and write out equivalent Oracle create table statements. I remember replying to the message (possibly privately) and I'd like to take a look at the utility now, but I can't find the message now (either in my email or online archives). Can anyone help out? Thanks. Tim. - 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
