C API - intermittent problems with insert
Hello, I'm using the Suse-provided binary of 3.23.47 on Suse7.3 Linux, and I'm having a funny problem with my program, which uses the C API, on this database. The database I'm accessing is using only the BDB table type. The host system is a relatively low powered IBM 300XL, (PII-233, 96MB RAM, 2GB WD EIDE disk). Every so often, (under heavy load?), the database appears to miss an INSERT operation. This happens intermittantly, so is not predicatable. It also doesn't happen very often, ( 1%), but even so it's darned annoying when it does happen (sigh!). Has anyone out there in MySQL land got any ideas on how I can track this down? I was going to enable the ascii log and see if an actual INSERT is being issued, (in which case I've got a MySQL bug) or not (in which case my code is defective in some way - more likely methinks). Any opinions welcomed, and feel free to take this off the list, so as not to annoy everyone else with my stupidity. Regards Bob Cross. (filter bypass: mysql database table sql query). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Home Uses
Jeffrey Flowers wrote: What I would like to hear is how other people are putting MySQL to work in their home environment. Like you said yourself the most obvious application is cataloging music CD's. What I'm doing is using it to keep a track of magazine cover disks. I got really annoyed with knowing that I have a particular program, but not being sure where on the collection of cover CD/DVD's the darned thing is. Just got a simple script that traverses the tree of a CD and inserts the filename, disk id, etc into a suitable MySQL database. Someone I was speaking to had a darned good idea. Now we've got 100+GB disks why not use the binary column type to build a library of MP3 files for use with these 'MP3man' type devices, (SonicBlue Rio, Samsung Yepp, etc). Then he could use a nice PHP/HTML front end to select what type of music he fancied, then add further preferences, before being given a final list that could then be automatically uploaded to his player. bob cross disclaimer: writing for myself. (filter: sql query on mysql database table). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
microsoft uses MySQL too?
Anyone seen this yet http://www.theregister.co.uk/content/53/24714.html good advert for MySQL if it's true!? (if you want a commercial grade, fully cross platform database, then get MySQL) Bob Cross. Spam filter bypass: mysql database table query Disclaimer: my opinion and no one elses. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It is not an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability is accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses. You should check for viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability is accepted in relation to those sites. This Company randomly monitors its e-mail system (including incoming e-mails) for operational purposes. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[O/T] problem with the list and Eudora/attachments
I've been having an off-list discussion with gordon52 at slingshot dot co dot nz, who is having a problem posting anything to the list. Apparently when he sends something, the list manager thinks it's got attachments and bounces it. Now when he sends me a message - no attachments. Can anyone out there in MySQL-land help, since I'm using Lotus Notes, and not Eudora? At this 16:45 5/04/02 +0200 told us all something interesting :- Your message cannot be postsed to mysql@ because it contained an attachment. If you need to make a file publically available you should upload it to some public URL, and then paste the URL into your message instead of trying to send it to everyone on the list. Disallowing attachments protects our list from being used to spread a virus. If you do not remember sending a message to the this list, it is possible that your computer has been infected by a virus which tried to spread itself using our list. It is also possible that some spammer used your e-mail address to hide his identity. Some mail clients default to sending messages in HTML or multipart format. In this case, your message will also appear as if it has an attachment. Such message formats increase the volume of traffic, and cause readability problems in some mail programs without providing any extra value. Such formats are also frequently used by spammers. For these reasons we disallow such messages. You should disable them in your mail program to be able to post. We have tried to look up the information on how to turn off HTML/multipart in your e-mail program, but our bot unfortunately does not know how to do it for QUALCOMM Windows Eudora Version 5.1, which is what you appear to be using. Please consult the manual of your e-mail program on how to send messages in plain text. Regards Bob Cross filter bypass: mysql database table sql query * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It is not an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability is accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses. You should check for viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability is accepted in relation to those sites. This Company randomly monitors its e-mail system (including incoming e-mails) for operational purposes. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: PERL/SQL, again? - Re: Procedures
Russell E Glaue wrote: Actually, I like this proposal of being able to plug in any language into MySQL. I also want to make a note that Greg Cope has a very good point. And going from what Greg mentioned in an earlier e-mail in this thread, the embedded language of choice really needs to be a small and compact language. Perhaps it is feature rich, but still small. A big language like java or perl will most likely slow down the database. Couldn't agree more. After all, there'll be some folk who would probably really like to use VB-4-Apps, (not me I hasten to add!). With a scripting language API you're free to choose the language that suits you and the job in hand. Now that'd be a good feature to hang over SQLserver, Oracle, DB2, et al. What language could MySQL try to standardize on that would not cause the server to slow down or become bulky in memory? How about shell scripting languages, like the ones in ksh, bash, etc? Might be too *nix-centric to suit the Wintel crowd, (if so apologies), and probably doesn't thread too well, (no idea - anyone care to enlighten me?). After all look at PL/SQL, it doesn't have a whole lot of bells-and-whistles, but it has enough to do the job. So maybe that's a recommendation to keeping whatever it finally ends up as feature tight. If this becomes a serious feature, how about asking the users what they need, (functions), as opposed to what they'd like (fancy GUI's etc). That way we get a scripting system that's 'focussed'. As far as creating a language just to embed in MySQL... this may be tempting, but I think it to be far better to not do this. Agree totally, the world needs yet another great programming language like the proverbial hole in the head, not even that keen on C#. (Oh, and please no Java either, old guys like me just can't get our heads round the almost-C-but-not-quite-ness of it). Bob Cross. (spam-filter bypass: mysql database table query) * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It is not an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability is accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses. You should check for viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability is accepted in relation to those sites. This Company randomly monitors its e-mail system (including incoming e-mails) for operational purposes. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RedHat6.2 and kernel 2.2.14
We've got a RedHat 6.2 system here, and every so often it fails to commit an INSERT to the database, (using BDB table type). Apart from that the system works fine. I was wondering if this is a symptom of the kernel 2.2.14 problem that's mentioned on the download page. Anyone got any views on this? Regards Bob Cross. (anti-spam filter bypass: sql query on table stored in mysql 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: Impact of Free ORACLE
Ron Jamison [EMAIL PROTECTED] wrote: I'd be hardpressed to find a better, more stable database (MySQL) with the wonderful support that comes from the whole community. Couldn't agree more. It's a shame that Microsoft, Oracle, IBM's support for their DB's isn't as good, (and inexpensive!!) as MySQL's. Oracle will continue to be slowly abandoned as the decision makers choose open source and low (no) cost over proprietary and stupendous costs. And if you truely believe that, would you be interested in this bridge I've got for sale ;-) ?! The commercial databases will always have the the advantages of better image to the damned bean-counters and a better feature set or app support, (If you've standardised on M$ tools for building then - surprise, surprise - it's easier if you're using SQLServer as the backend). Don't misunderstand me - MySQL is great, (in fact the last place I used it, I couldn't have used SQLServer, Oracle, DB2 - the technical requirements meant that it had to be either MySQL or PostgreSQL). I for one will be glad to see those inflated price tags go. Hear, hear - mind you with Larry E's guys it'd be nice to get a consistent price, (three different prices for the same piece of software in the space of 30 days!!) Bob Cross. (mysql query database table) * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It is not an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability is accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses. You should check for viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability is accepted in relation to those sites. This Company randomly monitors its e-mail system (including incoming e-mails) for operational purposes. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Mystery files
mysql mailing list user wrote: Hi, I my mysql server database directory (that is the directory that holds the .err and .pid files) so strange files have apeared. They look line machine-name-bin.001 machine-name-bin.002 etc machine-name-bin.index Some of them are huge! They seem like binary files, but are full readable SQL commands that could be from my applications. While we're on the subject of files that MySQL is generating, anyone out there got an idea what log.01, log.02, etc in the data directory are? Better still how-can/can-I stop them being produced? I know they're not the binary log files since they're being sent elsewhere. (extract from my.cnf #log= /home/mysql/tay-log #log-update = /var/mysql/updates log-bin = /var/mysql/binary/bin ) Sorry if this is another RTFM . . . . Bob Cross. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It is not an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability is accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses. You should check for viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability is accepted in relation to those sites. This Company randomly monitors its e-mail system (including incoming e-mails) for operational purposes. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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_num_rows/insert/3.23.41
Found a strange problem with a system here I'm wondering if anyone can help with. Got a v3.23.41 installation (source build) on RedHat 6.2 using BDB tables. A front end program uses this database via the C API. gcc on this system is egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) At one point the front end generates an INSERT query to put a new record into the main table of the database. In another bit of the code it does a check to see if a particular record exists (SELECT query on the primary key followed by a mysql_num_rows on the result) before trying to update the record. Now this program has been running fine for a good while, but yesterday in the space of five minutes I got 6 warnings from my front end program that the users were trying to update records that didn't exist. When I did some digging, it looks like the records were/should-have-been present. So I've got two possibilities: 1. The initial insert for the six records didn't work. I'm not sure about this, since there were other record inserts being done around the same time frame that did work. 2. For some reason, either my SELECT decided to return no results, or mysql_num_rows decided to return zero. I'm going to put in some error trapping on the insert now, so if it does fail at least I get an error message. I'm a bit loathe to do this since the system has been so stable, (100K's of transactions at these are the first failures, so replicating the problem is near enough impossible). Plan B is to replace the r41 install with a local build of r49a(/r50?) in case it's a know problem now solved. Any ideas oh great MySQL gurus? Regards Bob Cross. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It is not an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability is accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses. You should check for viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability is accepted in relation to those sites. This Company randomly monitors its e-mail system (including incoming e-mails) for operational purposes. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Server uptime.
Neil Silvester wrote: The server is a lightning fast Pentium Pro 90 with 32 MB EDO RAM and RedHat 7.0. So anyone who still says that the MySQL database can't cut the mustard, obviously hasn't tried. Mysql 3.23.43 Up 212 days, Processed 199,654 queries (average = 0.01/sec) For comparison: Pentium II/233, 96MB RAM, RedHat 6.2 MySQL 3.23.41 (replicating to an identical system for resiliancy). Uptime: 7 days 21 hours 17 min 3 sec Threads: 3 Questions: 897638362 Slow queries: 2 Opens: 16 Flush tables: 1 Open tables: 9 Queries per second avg: 1317.300 imho MySQL definitely *can* cut the mustard. My client decided to do a stability test on the above system, so he set it processing, then just pulled the plug out. The system needed some serious fsck-ing when he reapplied the power, but MySQL restarted automatically - and processing continued more-or-less exactly from where it left off! Recently, they had a power outage during the weekend. It wasn't until Monday afternoon that anyone noticed that the MySQL host had been down, and then only because Apache had failed to restart. Now *that's* impressive!! I just love software that just works, and works, and works (takes a licking and keeps on ticking, etc). Thanks MySQL AB! :-) Regards Bob Cross. database, sql, table, query, * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It is not an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability is accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses. You should check for viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability is accepted in relation to those sites. This Company randomly monitors its e-mail system (including incoming e-mails) for operational purposes. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL PHP Development IDE
His interest lies not so much in using for database table modeling, but for PHP and Perl development. How does PHPEd stack up compared to other PHP IDE's? What experience (good or bad) has anyone had with it? Is there another product that is better? I've just finished using Quanta+ for doing a fairly small PHP frontend to a MySQL database. I didn't choose this for any reason other than it got installed on the Suse-based laptop I was using. Got to say though, it's pretty slick (syntax highlighting, inbuilt docs, inbuilt preview, etc) - and best of all free from Sourceforge. However, since I'm now getting more into the web development, (heck I quite like PHP!), side of things I'm now thinking of spending the USD49.99 (CD version, download-only is USD10 cheaper) and getting the uprated version - Quanta Gold - from TheKompany. Certainly the feature list and screenshots look good. To me, USD500 sounds an awful lot of money for a 'mere' PHP/Perl editor. The cynic in me would wonder if it's not overkill. I used to do all my PHP and Perl stuff just using the appropriate modes in Xemacs which is free. Xemacs doesn't have the nice inbuilt docs and project handling that Quanta does though. Just my personal opinion above. Regards Bob Cross. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It is not an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability is accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses. You should check for viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability is accepted in relation to those sites. This Company randomly monitors its e-mail system (including incoming e-mails) for operational purposes. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: suse linux 7.3
agc wrote: well I am running suse linux 7.3 and well to be honest I am a real newbie, so here I go I am gettingh this error msg cant connect to local mysql server through socket /var/liv/mysql/mysql.sock so what should I do_ what does this error msg mean_ cheers I had the same problem and I got round it easily by doing ln -s /var/lib/mysql/socket.mysql /var/lib/mysql/mysql.sock When I checked out the system after the fault came up, there was a socket.mysql but no mysql.sock, so I created a link. The better way is to modify the startup so that it's picking up the correct file, but I'm short of time at the moment. Regards Bob Cross, EDS UK Ltd. Disclaimer: The stuff above about MySQL, databases, SQL, tables or queries is my personal stuff and not anything to do with my employer. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability can be accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability can be accepted in relation to those sites. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Probably OT - SQL join help needed
Hello experts, I've got a small problem with an sql query here that's got me completely stuck. In my MySQL database I've got two tables here that have identical design, e.g. table 'detail' - columns sales-order, quantity, part-number, price, date-sent and table 'archived' - columns sales-order, quantity, part-number, price, date-sent. Detail is for 'active' orders, and Archived is for fulfilled orders. Now some genius here wants to see all the records that reference a particular part number, irrespective of whether in archived or detail. My current approach is to create a temporary table with all the suitable records from detail, add in any suitable records from archived, and then do a select * query from this temporary table, before dropping it. Worst still, I'm going to have to do this all via PHP :-( Now it strikes me that this isn't a very smart way to do this, and it's probably achievable via joins but, try as I might, I can't get the system to do it. Anyone got any bright ideas/suggestions? Regards Bob Cross. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability can be accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability can be accepted in relation to those sites. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Uploading to MySQL?
You wrote: Suppose I wanted to upload a lot of files (1000 or so) to MySQL... sort of like FTP-ing files to another server's directory... Is there a way to get them all into MySQL like that? Uploading to a database seems much different than uploading to a server... Next, suppose I just FTP-ed a bunch of files to a directory on my server, and then I wanted to catalog all the links in a MySQL database table... Is there a way to get all those links into the database without having to manually insert them one at a time? You're going to need some script, in which case you've got one of three routes: 1. LOAD DATA mysql command, (see manual section 3.2.3 for details). 2. A program using one of the API's, (I'm doing something vaguely similar to what you want, and I'm using a C program). 3. PHP and a web page, (i.e. click this button to upload these files)? Regards Robert Cross, EDS UK Ltd. (Disregard below it's just to get past the spam filter). Oh great MySQL database, that contains the myriad tables of data. Who knows what wonders my sql queries may bring forth? Disclaimer 1: Everything above this line has nothing to do with my employer, their contribution follows * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability can be accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability can be accepted in relation to those sites. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Probably OT - SQL join help needed
Hello experts, I've got a small problem with an sql query here that's got me completely stuck. In my MySQL database I've got two tables here that have identical design, e.g. table 'detail' - columns sales-order, quantity, part-number, price, date-sent and table 'archived' - columns sales-order, quantity, part-number, price, date-sent. Detail is for 'active' orders, and Archived is for fulfilled orders. Now some genius here wants to see all the records that reference a particular part number, irrespective of whether in archived or detail. My current approach is to create a temporary table with all the suitable records from detail, add in any suitable records from archived, and then do a select * query from this temporary table, before dropping it. Now it strikes me that this isn't a very smart way to do this, and it's probably achievable via joins but, try as I might, I can't get the system to do it. Anyone got any bright ideas/suggestions? Regards Bob Cross. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability can be accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability can be accepted in relation to those sites. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Suse V/S Redhat - mysql performance difference.
Jatin Nansi wrote: I have 2 servers 1 running redhat 7.2 and the other running suse 7.3. the hardware config is : RH7.2: Fast desktop (IDE HDD/128 MB memory PIII 550 MHz). Suse 7.3: Low end server (Ultra SCSI 2, PIII 850 MHz, 256 MB RAM). Now i expect to see the suse server go faster than RH, but i am having the reverse happening. The RH server returns a query about 5 times faster. [here be snippage] Jatin, not sure about the low level stuff in MySQL, but a couple of things occur to my challenged brain: 1. It's not necessarily true that a U-SCSI system will go faster than an IDE one. I've seen some pretty convincing benchmarks with 'old' 7200 rpm SCSI disks against the latest 7200 ATA-100, which show that the IDE system is faster in real world tests. Now if it were a 10K UltraStar disk on a fancy U160 controller, that might be different 2. Check what else the Suse system has installed and is running in the background. I've migrated my two systems, (Athlon-based 'base' station and PII/266 laptop) to Suse 7.3 from RH7.0, and there appears to be way more background systems running on Suse than on the old RH one. (Like why do Mandrake/Suse/RedHat insist on running the PCMCIA service on a system that doesn't have PCMCIA sockets?) 3. What file system are you running. I've heard that ReiserFS, and journalling systems in particular, make better use of the device-peering facilities that SCSI has, presumably where you've got a multi disk setup. That said, I'm concerned about the 5x difference. If this is the same RPM binary (from MySQL where else?), then I'd be VERY tempted to put in a support call or, failing that, raise it on one of the Suse user lists. At the end of the day, the best way to benchmark OSs is to put one on, do the tests, then clear system, install OS#2 and repeat test. Regards Bob Cross. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability can be accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability can be accepted in relation to those sites. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: PCAnywhere like linux client - mysql data files administration
Jack A Fobel wrote: I remember seeing a program awhile back that acts like pcanywhere or terminal services, to connect to a linux or windows box. Anyone remember the name? Depends what you mean: a. Terminal services, or b. pcanywhere(tm) If it's (a), then you've got a wide choice of: ocommand line services, telnet, etc. (the command line mysql client is pretty good imho). oX-windows, (using the DISPLAY variable) oVNC, etc... If you're looking for a PCAnyWhere-alike, then the only one I've found is x0rfbserver, which is available at http://www.hexonet.de/software/x0rfbserver/ (not tried it myself, but I've heard it's pretty good) This should allow you to control a server, (your database one?) from many clients, (it's supposed to be compatible with the VNC clients), from PalmPilots through to PC's etc. Note that VNC gives you (unless there's been a lot of changes since I last looked at it a year ago!) a desktop on the destination machine. It doesn't give you control of a particular screen, the same way that the Windows remote control software does. Regards Bob Cross. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability can be accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability can be accepted in relation to those sites. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: [OT] Undescriptive subjects.
Gordan Bobic wrote I've got an additional idea - how about configuring the mailing list remailer to put something like [MySQL-General] or [MySQL-Internals] in the subject line? For some of us who are on multiple lists, it gets really hard to work out what is what without reading the whole lot. I'll second that, not because I'm on a lot of MySQL lists, but because I'm on a lot of lists period! While we're on posting protocol: 1. Always put a subject otherwise you run the risk of being deleted without being read. I certainly do this, and I know I lot of other people who do likewise. 2. Don't use HTML - some of us are using command line clients which don't like it. Besides, it generates an attachment which, in these days of rampant virii, is a really bad idea. Best wishes for the season folks Bob Cross. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability can be accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability can be accepted in relation to those sites. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Hacked Servers
mysql at hotchilli.co.uk wrote: We have 2 Redhat 6.1 servers and MySQL 3.22.32 and both boxes appear to have been hacked on Friday last and MYSQL client just hangs when connecting to the localhost MYSQL server. MySQL is running on both boxes and suffer the same problems. We have Intrusion software but its very long winded trying to find how to fix it - and ultimately we will re-install. I found a neat checklist on one of the official sites, (CERT, etc) and their recommendations were something along the lines of. 1. Network isolate all infected machines. 2. Get backups of user data, at least two, and verified if possible. Also save any local configuration files for the applications. Don't save any o/s configurations, such as /etc/services, unless absolutely necessary. 3. Reformat disk on infected machine and reload o/s from known clean source 4. Add local configurations. 5. Add o/s and application patches, concentrating especially on security ones. 6. Restore user data, being careful not to restore any user scripts or more especially executables until such time that they can be proven to be untampered with. Personally I'd seriously think about upgrading from '6.1 to a 7.x distro so you can get the RedHat support. Regards Bob Cross. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability can be accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability can be accepted in relation to those sites. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: opinion - voating
Neil Zanella wrote: On Mon, 26 Nov 2001, Ken Kinder wrote: Oracle is certainly more full-featured, but if you know very little about databases, Oracle is not the right choice. I agree. First of all the system requirements are high. For instance the Oracle Universal Installer took something like three hours on a fairly high end PIII with 133MHz FSB! Must have been a pretty lousy system then. I managed to complete an 8i server install on a long obsolete dual-processor SPARCstation10 in about 45 minutes. I've heard rumblings that the Windoze implementation of Oracle is crap when compared to the Unix ones - maybe this is true? Have you ever used the sqlplus command line utility (which is the equivalent of the mysql command line tool or PostgreSQL's psql command line client). Well, sqlplus assumes your terminal is 24x80 even after you resize it. First day on my Oracle course they showed us how to change this (PAGESIZE LINESIZE settings). Granted that the mysql command line client is way better than the Oracle equivalent. Now my other point: Oracle8i is highly non-SQL compliant No it isn't! From the Oracle 8i documentation, appendix B In addition to full compliance at the Entry level, Oracle complies partially at the Transitional, Intermediate, and Full levels as described in Table B-1 (including both SQL-DDL and SQL-DML) [levels defined in ANSI document, X3.135-1992, Database Language SQL. ]. There are a quite a few areas of change, but most peoples problems seem to stem from using Oracle-own feature enhancements. Not sure what the SQL99 compliance is like, as I've not had a chance to get my hands on 9i yet. My last point about Oracle is that it is based on Java (see that JServer stuff when you start sqlplus?) and that is perhaps one of the reason it needs so much RAM. Oh no it isn't! A lot of the support tools use Java, (like all the trendy webby stuff), but the database ain't. As to RAM requirements my little SPARCstation test box only has 128MB of RAM, (sheez even my home PC has more than this), and it runs okay, (that said I wouldn't like to run a production system on this!!). We've got fairly chunky production systems running on Oracle in 512MB of RAM, (not on Intel kit I hasten to point out). Getting back to the original question, I don't think there is such a thing as a 'best' database. I use Oracle, DB2 and MySQL, and each has it's pros and cons. That said, the support on MySQL is just about the best I've seen. It's also about the best on smallish hardware, and master-slave replication is a piece of cake to setup, (unlike Oracle :-( ) Ah well, back to sleep . . . . (oh, and mysql is way quicker to install!!) Regards Bob Cross, DBA and developer. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability can be accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability can be accepted in relation to those sites. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to copy table structure easily.
Dexter wrote: Just want to copy the table structure of a table i Have but dont have the the create statement and dont want to have to type it again , it has a lot of fields. Can I easily replicate a table. Hi Dexter, I had the same problem and seem to remember finding the answer hidden in the excellent MySQL book, (the Paul DuBois one). If your table was CUSTOMERS and your new table was to be BLACKLISTED, then CREATE TABLE BLACKLISTED SELECT * FROM CUSTOMERS WHERE 1=0; will create the structure you want, but not put any data in it. When you say replicate a table, what exactly to you mean - replicate to another system, (relatively easy), or produce a copy of a table? If it's the latter then use the SQL above, but use WHERE 1=1; as the clause to select all the data, (or don't bother with a WHERE at all, probably simpler!). Replication between servers is covered in the online manual. Hope this helps. Bob Cross, (apologies for the disclaimer that follows). * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability can be accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability can be accepted in relation to those sites. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: intro mysql book
another oracle dba [EMAIL PROTECTED] wrote: Can someone recommend an intro MySQL book. I'm looking for a book with info on MySQL Like you I too have come from an Oracle background to Mysql. Two main sources of information as far as I'm concerned: 1. The MySQL manual that comes with the source install, (also available on the site). I've got the HTML version readily accessible on the servers that are running MySQL. If it was multiple page HTML rather than a single file it'd be great. 2. MySQL by Paul DuBois. Like I've said on AmazonUK, I regard this as being the 'Kernighan and Ritchie' of MySQL. It's well written, reasonable concise, easy to follow and pretty good value-for-money. I could do without the chapters on installation and the API's myself, (I prefer to use the online manual as books tend to date in these areas fast), but I can see a use for them, (maybe less of the installation please in the revision for MySQL4.0 please Mr Dubois?). As an aside I also found 'PHP and MySQL' and 'SQL in a nutshell' (O'Reilly) quite useful. The Nutshell book is quite nice if you are an experienced code warrior with one of the other implementations of SQL. Just my random meanderings Bob Cross Disclaimer 1: writing for myself * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability can be accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability can be accepted in relation to those sites. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Video game programming????
It has a wierd review from someone which says I was extremely dissapointed to say the least. This book doesn't even begin to cover **video game programming in mySQL**, not even the basics. In fact, it doesn't cover **video game programming at all**. . blah blah . What's video game programming got to do with MySQL ?? Hi Nilesh, yes I saw that 'review' as well and my first thought was boy, what a class 1 jerk! (or a SQL Server advocate - same thing ;-) ! ). But then I got to thinking: 1. Two of MySQL's strengths are that it's small and fast - pre-requisites for video game work. 2. Most (and I would have thought all) games have pretty extensive data structures for player position, position of bad guys, ammo etc. Given this why couldn't MySQL be used as the data backend for a video game? In fact, once the geniuses at MySQL give us peer-to-peer replication then this would be ideal for some kind of MUD-type game, (each player would effectively have a local copy of the DB, transmit their moves out and receive other peoples moves). Even without this you could do a type of DOOM, where all the layout would be stored in the DB, heck, you could even have a leave-rejoin facility for multiple players, (single player game) since the DB could be used to store the users configuration, the same way it can be used to store personalised Web page configuration. Or maybe something similar to the old SGI flight/dog 'sims', (that was an ace timewaster and I sure wish someone would port it to Linux!) Further it occurs to my fevered imagination that you could use Blender to make the graphics bit for a DOOM clone, and link it to a MySQL backend, or embed it. AFAIK Blender uses Python and I seem to remember seeing a Python interface to MySQL. Ain't MySQL wonderful, and so flexible too! Bob Cross, rapidly turning into a major MySQL advocate. Disclaimer 1: The rabid dribblings above are personal to the author only, my employer has much more common sense. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability can be accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability can be accepted in relation to those sites. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Faster mysql
Marcin wrote: How I can make my mysql faster ? Can I compile it with special options? Check out section 5.5 of the manual. I found there's also some very useful information readily available in the file INSTALL-SOURCE* in the top level of the source directory. I'm not sure whether GCC v3.0 might make a difference, as I've heard mixed reviews of it so far. Maybe someone else on this list has got some hard data on this. Bob Cross. * I turned on the O3 flag for my v.41 build and I'm not sure how much better performance I got, (there was an observable speedup), but the memory requirement dropped to just about 60% of what it previously was. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability can be accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability can be accepted in relation to those sites. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: command line open source ARRRGGGGGG!!!!!!
Chadrick Mahaffey wrote: what does all this mean? I tried to type this in my command console changin / to \ and I don't understand what is happening. I get all kinds of errors. It looks to me that you're trying to use the Unix install notes - don't! Refer to section 2.1.2 in the excellent manual, (worth downloading so you've a local copy). Open source would go much farther if they had self explanatory GUIs and had basic pre-setup apps that were ready for the average user to use. Why? Maybe I'm really offbeam, but I'd suggest that MySQL is more of a server product than one which should reside on the desktop. Further, why then saddle the server admin with a GUI. In my experience even the best GUI is not as flexible as a half-decent command line installer. A GUI is fine if you've to install on just your PC, but there's no way I'd be happy if I was doing multiple installs - at least with the command line you can make a small (one-line?) batch file to do the job on however many systems you have. I could be mean and turn this on it's head - if you want a GUI, do it yourself and then contribute it back! Most open source apps I have attempted to use have some of the worse documentation around. The writers assume so much about the users. You've been very unlucky then. Nearly all the major apps, (and most of the smaller ones), have excellent docs, simply because the vocal user community wouldn't let them away with anything else! (If you don't like a bit in the manual rewrite it and submit it back ?) That said, I will agree slightly in that some of the app docs are very Unix-centric (not MySQL's), and I personally find the Apache manual a bit hard to use. For your core apps it's probably worth getting one of the 3rd party books, (the MySQL one is very good indeed). OK - call me inept, stupid, or whatever but I had to say it. Fair enough - you're stupid! ;-) Quote for you real stupidity is quite rare, (except in politicians where it seems to be a qualification), and what is generally perceived as 'stupidity' is nothing more than inexperience, can't remember who to attribute this to, but it seems pretty apposite. As to MySQL I'm just past the caveman stage myself. Keep in there and it'll all fall into place, (with a bit of help from this mailing list), and then who knows? Regards Bob Cross - writing for myself in this instance * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability can be accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability can be accepted in relation to those sites. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Licensing terms for an Intranet site
If I'm using MySQL for an intranet site within my corporation, is there any licensing required? John, we're in the same kind of situation here, (I'm using MySQL as part of something that I'm delivering to another part of the business for their internal use). AFAIK the position is that if you make money from it you *must* pay for it, otherwise it's left to your own morality. We've taken the decision to buy the requisite number of licenses and annual support once the system goes live. After all, MySQL must make some money - these guys (and gals?) gotta eat, the same as the rest of us! (and personally I think the current license costs are more than reasonable) Regards Bob Cross. (sorry about the disclaimer that follows - darned lawyers!) * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability can be accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability can be accepted in relation to those sites. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Downsides of MySQL?
Chris Boget wrote: MySQL - as I said at our meeting, we would not be comfortable with this as an enterprise strength solution. MySQL is unsupported freeware No it isn't, both MySQL AB (and NuSphere?) provide commercial-grade support. Given that the top level of MySQL AB support involves direct contact to the developers, I would argue that this is a level above that available for Oracle or DB2. Certainly the level of free support offered through this mailing list is exemplary, [ :-) ], and my customer will be buying in annual support from MySQL AB before their system goes live. and lacks enterprise management functionality. Also incorrect, there are a number of free admin clients available or even roll your own since the API is well defined. It has a small limited feature set compared to ORACLE, DB/2 It is true that is has a smaller level of functionality when compared to Oracle and DB/2, but it would appear to me that some of the more glaring omissions from the standards are being addressed. Further, the question must be asked does the 'missing' functionality cause any difficulties? For me, with the exception of subselects, the answer is no. and is lacking the functionality to support data replication and has little capability for generating management info. Utter rubbish! MySQL doesn't support data synchronisation, but most defintely supports master/slave replication, what some refer to as 'hot-sparing' and in fact I'm using this capability in the 'solution' that I'm about to deliver. There are question marks around the scalability of the product, I'm not sure of the locking algorithms used (whether row level or record level) - the fact that it is not generally used in multi-user solutions is a good enough indication that this is not accepted database technology for industrial-strength multi-user systems. This is M$-like FUD. Locking mechanisms depends on the table types chosen. I hardly think that Yahoo, Slashdot, Freshmeat et al would be using MySQL if they weren't convinced of it's utility and stability. The fact that it is unsupported freeware would mean that an end user would potentially be held to ransom by a DBA with specific knowledge. As mentioned before it isn't unsupported or freeware.The specific knowledge concern is is true of any DB system, such as Oracle, DB2, SQL Server. The mySQL security model is also not sufficiently developed for any system that involves money. This would need explanation as it seems to me that there is little or no difference between the user security in MySQL and that in the other DB systems mentioned. Before my current project I hadn't come across MySQL, (being a die-hard Oracle DBA), and what we needed was a SQL-drivable DB with a well defined C API, small resource requirements and sustainable on-going costs to run on a Linux platform. We could have gone DB2, Oracle or PostgreSQL, but eliminated the first two due to their resource requirements, and further discounted PostgreSQL due to the beta nature of its replication. I haven't had cause to reconsider this decision, as MySQL has proven to be easy to install/configure, resource-miserly, and fast. Like I said I'm fairly new to MySQL so maybe some of what I've written may not be 100% the gospel, as it's based on my knowledge. I would strongly recommend that your colleague take a few minutes and has a look at the on-line copy of the MySQL documentation to clear up some of their misconceptions. Regards Robert Cross. Disclaimer: Writing for myself, not my employers. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability can be accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability can be accepted in relation to those sites. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http
Replication housekeeping
I've got a fairly simple MySQL system here using replication, one master and one slave. Looking at the system the other day and the database logs are sure building up. Is there any standard way (best practice) - preferably automated - to keep these under control? If not, I've have a go at doing my own Thanks Bob Cross * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability can be accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability can be accepted in relation to those sites. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 problem with 3.23.38
I've got a wierd problem with 3.23.38, built from source, running on RedHat v6.2 (Intel). Put simply the wildcard character for user access doesn't work. From my reading of the docs any of the following: grant all on mtdb.* to user1 identified by bozo1; grant all on mtdb.* to user2@% identified by bozo2; should allow the specified users access to the mtdb database from any host (assuming that they can input the password correctly!). Well - it doesn't work. Unless I GRANT for each user on each system that they are likely to use they can't get in and get error 1045 - access denied. Am I doing something terminally stupid, is there something wrong with my build, or is it a bug? Ta Bob Cross. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability can be accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability can be accepted in relation to those sites. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 problem with 3.23.38
I wrote: I've got a wierd problem with 3.23.38, built from source, running on RedHat v6.2 (Intel). Put simply the wildcard character for user access doesn't work. From my reading of the docs any of the following: grant all on mtdb.* to user1 identified by bozo1; grant all on mtdb.* to user2@% identified by bozo2; should allow the specified users access to the mtdb database from any host (assuming that they can input the password correctly!). Well - it doesn't work. Unless I GRANT for each user on each system that they are likely to use they can't get in and get error 1045 - access denied. Mr. Sinisa Milivojevic replied: Try first granting USAGE on *.* to both users with 'identified by ...' and then try granting database rights. Thanks Sinisa, that works perfectly. I've now got a wonderful small and fast database that I can let the users into! Bob Cross. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It does not constitute an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability can be accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses and it is recommended that you check for such viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability can be accepted in relation to those sites. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php