Re: How do you backup HUGE tables?
Something totally ghetto that might work... If you could convert the files to appear to be text with some kind of reversible fast translation, rsync might be able to handle the diff part. You'd sure want to test this out thoroughly... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: question about natural join
The natural join will JOIN on *all* the fields whose names match, not just the ones you want it to. In particular, the JOIN is matching up .expires and .expires with = You then use WHERE to get only the ones with This is a tautology: There are NO records both = and on the field .expires. You don't really want a natural JOIN here. And, honestly, natural JOIN generally ends up being problematic sooner or later. You end up adding some kind of field to both tables that should not be included (last_update, e.g.) and suddenly your query isn't right any more. Stick with the explicit WHERE clauses that make it crystal clear what your query does. Just as SELECT * is bad -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Data Inconsistent
Why are A and B letting you cram NULL into a column declared NOT NULL? Are your schemas consistent on A/B/C? Perhaps 5.0.32 does not enforce NOT NULL properly? Some tweak to config may change this? I don't know the answer, but with a bit of research in this direction, you should be there. In other words: Forget the replication part -- Focus on the NULL in a NOT NULL column part. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Is deleting the .FRM, .MYD and .MYI files the same as dropping table?
I think you may be over-panicing. :-) If you do a DROP on the master and that replicates through, just like the create did, then you're all set. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Restarting MySQLD when all transactions are complete
Read the mysqld man pages about what it does with kill -X signals. One of them may mean graceful stop Or not. If there is one, you'd still have to figure out how to tie that into a re-boot or whatever for updates. Sounds like a perfectly reasonable feature request if you find nothing at all... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Upgrage MYSQL 5.0 to 5.1 :: Using unsupported buffer type
Did you re-compile/re-link your C app with the new MySQL header files?... Sounds like you didn't. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: how to design book db
Just theories here: The same book re-issued by another publisher might have a different ISBN. A book with an insert (e.g., CDROM) may have a different ISBN, but be the same for some purposes. And mistakes can be made... Ultimately, I suspect that the uniqueness of ISBN to what normal folks call the same book is not as clear as one would hope. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: slow query log
I'm just guessing, but if the slow query log time resolution is seconds, perhaps 0.5 and higher rounds up? Or, perhaps it has an index, but it can't be used in that query. What does EXPLAIN [paste query here] tell you? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: installation nightmare
First of all, you are using a ports distribution system from BSD which means that you are not dealing with MySQL directly but with a BSD API layer on top of MySQL for installation. So much of your issues may end up being a BSD problem, not a MySQL problem at all. If the BSD scripts that are supposed to keep your fingers out of the installation gears are confusing you when you read the MySQL instructions that tell you how to turn the cranks without getting your fingers in the gears, then maybe you need to stop and find docs that are specific to BSD install of MySQL or install from source which matches the docs. That said, it sounds like you skipped the step about flush privileges And, once you set the root password, you need to add -p to mysql (and others) to ask it to prompt you for your password. It would help a great deal if you could more clearly document what you did, and where things FIRST went wrong, and STOP THERE and post instead of moving forward and then rambling on about how bad everything is and dumping several different issues into a giant rant. It makes it very difficult for anybody to help you when you do that. Also makes people less likely to WANT to help you, which is an even bigger issue. :-) There is no need to start/stop the server, but you MUST flush the privileges after you change them. Or, if you prefer, swat the fly with a cannon and stop/start the server. :-) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Function call reult in a WHERE-IN clause
Perhaps pass in a separator string arg, default to '' and do: GROUP_CONCAT(DISTINCT h.hostid, separator) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: stuck on a query
Hopefully your CILS table is not too many rows... select * from JOB, CILS as cyan, CILS as magenta where cyan.num_of = JOB.num_of and magenta.num_of = cyan.num_of and cyan.color = 'cyan' and magenta.color = 'magenta' or something not unlike that... You may want UNIQUE JOB.id_enc or somesuch, because this will get TWO JOBs each, since one is cyan and one is magenta. If any of these tables are large this could be an enormous number of temp records. Do an explain on the query to see just what sort of pain you are looking at... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Vexing permissions issue with partitioned CREATE TABLE
I've never created a partitioned table, but... $ perror 13 OS error code 13: Permission denied So I suspect some kind of file-system permissions issue... Are you sure that the path you are giving isn't relative to the mysql data dir? In which case it's trying to use something more like: /var/mysql/data/foo/ Or, perhaps, you need to do the mkdir of idx_foo for it??? Or, perhaps, MySQL really doesn't like the idea of root-owned DB files, and wants them owned by MySQL user? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql.org
Too bad it's not your list to make that decision, but Monteys Ruben mysql - the database written and owned by MYSQL AB On Sat, Jul 21, 2001 at 01:13:15PM +0100, Mark Tiramani wrote: Since these issues are between two private companies, please take your discussions off this list. It is none of our business. By all means, tell us the result. This discussion most certainly is our business. No it's not. MySQL is owned by MySQL AB. The fact that you get to use their code under GPL has no bearing on their commercial discussions. All these posts to this list only serve to inflame the situation. -- John Birrell - [EMAIL PROTECTED]; [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: mysql.org
the same time, a NuSphere-controlled mysql.org doesn't strike me as a disaster, provided they can do it with out shooting themselves in the foot, as they are doing now. Nah There using it as a marketing ploy to dup the public. The should have released their GPLed extentions on NuShpere.com rather than maysql.org, but they are unwilling to do this because they feel they have the right to be seen as the originators of MYSQL. Ruben - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Fact MYSQL owns their trademark Fact, what NuShpere brought form MYSQL is irrelevant as loing as they are infrringing on the MYSQL Trademark...and they were going to do WORSE until the public heat. Until they apologies fo the GPL violation, and then the Trademark infringment, they are pound scum and deserve no support attention, or benifit of any doubt. Ruben I think you see evil people, conspiracies and other unwanted stuff when in fact there are only misunderstandings and opposing viewpoints. I'm with Bob Hall on this one. Excellent statement Bob! -S Their is no conpsirisy, there is only one company trying to steel the good name of another company through immoral (and illegal) activities. Nusphere has no justffication, defense or right to take a product and push it on the public through the use of some elses trusted trademark... It's not. There was an agreement. Nusphere paid money for that agreement. MySQL sold SOMETHING to them, that much is clear. Have you seen the agreement? Do you have 100% proof that MySQL did not sell the right to use their (yet to be approved) trademark!? Temporary or otherwise? What makes you think this is not a case of Swedish and American laws and/or cultures clashing? I do not think you have seen the agreement, and I do not think you have enough information to make a sound and unbiased judgement in this matter. You have a right to your own opinion, ofcourse, as long as you realize that they are just that - opinions. Not facts. Regards, -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
mysql.org
You are, of course, welcome to your opinion, and to the expression of said opinion. You are also liable to be judged on the basis of that expression, and frankly, your expression leaves me wondering about your wisdom and your analytical capabilities, not to mention your social skills. What - you work for NuShpere. My analysis of this affair is correct. It comes down to trust I TRUST MONTY. I do not trust Brit, and man who has abused the GPL, abused the MYSQL trademark, and broke the trust between the two partners. What do I base that trust on 6 years of contant communication and dependency of the MYSQL staff and my PERSONAL relationship with Monty and his Fella's as he called them. Furthmore, the assumption that under any condition NuSphere BROUGHT the right to open up shop directly under the MYSQL name and conduct independent sales, promotion and business, is damn off the wall, far fetched, and ridicules to asume, that you'd have to be a complete utter moron to beleive this report, and in addition, the report should be playing tomorrow afternoon on the Opra show, and be reported right next to the alien abduction story in the National Enquirer. Furthermore, their behavior secondary to this, and the proposition that they opened the mysql.org site as a Community site flies right in the face of the proposition forwarded by NuShpere that they opened the site with full rights to do so under previous agreements because they purchased control over the MYSQL trademark because they did in secret, then protested they had they right ot, after saying it was a communitee site, and then finally, they release they're Gemini code on it, only after 100's of people complained that they were violating the GPL. This is NOT the actions of an honest person...period... No We need NuSphere to admit their wrongs, make a blanket apology, and everyone can call a no harm no foul, and forget it happened. Ruben - End of forwarded message from Brooklyn Linux Solutions CEO - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
MYSQL.NET XMYSQL.COM MYSQLPHP.COM PHPMYSQL.COM MYSQL-PHP.COM MYSQLHOST.COM -S Aside from being incorrect about the process of tradmarking in the US and the ability to defend a trademark while awaiting registry, all these above websites are not claiming to be the official place to download and collaberate on MYSQL. Only mmysql.org is promoting itself as THE place to download the database program. Ruben - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 greatest asset to using the MYSQL product over the years has been this mailing list and Monty's personal efforts to answer almost every question, no matter how stupid or repetitive, patiently and accurately. It's blown my mind to see him working so hard on handling the enormous communications on this list. He alone has given more technical support, provided more training, and is responsible for more enlightenment than the entire Tech Support hotline of MicroSoft. All that work is essentially values in the good name MYSQL provides for the code base. Nusphere, IMO, in this matter, is a theif, in addition to clearly violating the GPL under a ridicules pretense. Monty Widus, even GPL Czar... are you out of your mind Give me a break. When NuShpere was in NYC for the last Linux expo, they gave a presentation on Gemini. They clearly indicated that they are hacking at the MYSQL code base. They said NOTHING about making these estenssions propiatory only, and insisted that they planned on a server oriented business model through support. This action by them is a 100% turn around. SHAME SHAME SHAME on youi, NuSphere, for burning up valuable and scarce economic resources on legal mumbo jumbo NuSphere has ZERO chance on winning. And if they did win, the entire Free Software movemnt would undermined. Ruben I would like to whole heartedly add my support to this statement, I feel that Gerry has summed up perfectly everything I would like to say. We have been using MySQL for well over a year now and have found it to be a fast, reliable, efficient and scalable product. I happily recommend the use of it to colleagues and use it in my corporate work and when advising charities. The efforts of the developers shine through in the excellent performance of this product. It is sad to see people taking advantage of their efforts and I feel that MySQL AB has not in any way besmirched the principles of open source by taking the actions they have taken. best wishes and keep up the wonderful work, you are much appreciated Chris Dr Christopher Thorpe Information Architect GenomeBiology.com Middlesex House 34-42, Cleveland Street London W1P 6LB T 0207 631 9184 Whttp://genomebiology.com/ -Original Message- From: Gerry Sweeney [mailto:[EMAIL PROTECTED]] Sent: Friday, July 13, 2001 7:15 AM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: mysql.org Monty and all at MySQL, I am sorry to hear about this most unfortunate situation. It is sad to see that NuSphere have taken it upon themselves to attempt to steal your intellectual property and try to benefit from all of the MySQL team's hard work. My company has been licensing using MySQL for development of our products for the past 18 months or so and I have had nothing but good things to say about MySQL. You are a credit to the open source community and I believe you have found the perfect balance with MySQL for both open source and commercial users. Your comments that you totally rely on the trust of your users is admirable and very much appreciated by many people I am sure. However, being the human race, there are always people that are going to take liberties and abuse such trust. I hope that your legal defence is swift and successful and does not cause too much disruption to your day to day business. As far as I am concerned, if NuSphere are selling a product derived from MySQL, then they should be paying MySQL.com a license fee to ensure that the professionals that are responsible for the creation of MySQL can continue to develop MySQL. We *embed* MySQL into our products and pay commercial license fees for the use of MySQL. Having dealt with MySQL at a commercial level, I can honestly say that, there is absolutely no excuse for what NuSphere have done. Your licensing policies have been totally fair, non-restrictive and realistic. Needless to say, You have our full support and rest assured I, or anyone who works at my company will not have anything to do with either mysql.org or NuSphere now or in the future. Kind Regards Gerry Sweeney Hornbill Systems Limited - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Re: Re: mysql.org
database,sql,query,table 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. Oh Bull Making a derived work from a GPL product and not releasing it under the GPL is the very definition of a GPL violation, 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? Yes They are releasing the produce for sale and it MUST be imediately released under the GPL. Read the licence. NuSphere supports Open Source and is public on this position. Not that I see so far. 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. Their in violation and sued out of existence. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
updating mysql
hallo! how do i update my mysql-database to a new version? -simon- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 License
You can charge for any GPL'ed product you wish too. Ruben On 2001.03.05 22:31:41 -0500 Jeff Platzer wrote: Maybe someone can help me out with MySQL's commercial license. If MySQL server has a GPL license and MySQL client libraries have LGPL licenses, how can a paid commercial license be required for products that incorporate LGPL MySQL client libraries and depend on the GPL MySQL server? Does this not violate the GPL and LGPL license terms? MySQL commercial applications should be similar to Linux commercial applications that use the LGPL Linux shared libraries and depend on the GPL Linux OS. No Linux paid license can be required in this case. However, the developer can charge for the commercial application in this case. -- Brooklyn Linux Solutions http://www.mrbrklyn.com http://www.brooklynonline.com 1-718-382-5752 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Persistant Connection
Good Morning: We have a system of databases (in the plural) which number in the hundreds on individual servers. I want to open a persistant connection on the server and switch databases without closing the handle in DBI and reopening it. Is this possible without getting a rollback warning using DBI? Ruben -- Brooklyn Linux Solutions http://www.mrbrklyn.com http://www.brooklynonline.com 1-718-382-5752 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
NuSphere
What exactly is now the relationship between NuShpere and MYSQL/TSX. Who is working on the Gemini COde and the documentation? Ruben -- Brooklyn Linux Solutions http://www.mrbrklyn.com http://www.brooklynonline.com 1-718-382-5752 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php