Re: Info on 4.0.x release date
Subject: Re: Info on 4.0.x release date From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com)) === Subject: Re: Info on 4.0.x release date From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com)) === Subject: Re: Info on 4.0.x release date From: Joel Rees [EMAIL PROTECTED] === I know I'm not really involved here, but I would like to suggest a few things. Obviously you don't agree with me and that is something I readily accept. I do have difficulty with the fact that you clearly spent more time typing your response than considering my points, which were intended to be constructive. Well, as a bystander, I think you've shot a little wide. You got the truth. Would you prefer someone lie to you about it? I will assume that your interest in mysql and participation in this list indicates that you are somehow involved in the process of software development. What is less clear is whether this may be a hobby or your profession. If it is the latter, I would love to know where it is that one can work in this industry where one is not expected to make projections about when project milestones might be met. Microsoft? This is called project management. And while those of us who simply love writing code find such pursuits annoying, they are nonetheless necessary and worthwhile -- accepting this is part of growing up. _All_ the areas where we can reliably set schedules are areas where the profit margin is, well, something like the profit margin for manufacturing pencils. Unless you own the virtual monopoly, in which case you can fill in with fud. And while I applaud the honesty of saying we won't declare it stable until it is stable, surely you can see your way clear that if you were explaining a similar situation to your boss or to your client, they would almost certainly (and justifyably) want you to give them more details. This is called accountability. So they gave you all the details they could. That is being accountable. Or did you want to see the list of remaining issues, the assignment list for who gets to cover each, and so forth? What more information would be helpful, exactly? Do guesses really help? Guesses are nice... estimates are better. What is the difference, you ask? The word guess connotes random selection or selection based upon whimsy. Estimates, on the other hand, are approximations based upon some rational methodology. Whimsy, or the cognizance of the existance of more unknowns and their limits on manpower? Suppose you take your car into the shop and after looking at it they inform you that it cannot be driven again until a new part is installed and that part will need to be special ordered. Would you not expect them to give you an estimate of how long that will take? Following your logic, they would be justified in telling you that it will be here when it gets here. Perhaps you would feel better if they said something like the computer says they have plenty in stock and it usually takes 1-2 days for shipments to arrive. In the later, the parts manager cannot say with absolute certainty when the part will arrive. But short of that certainty, he has given you the next best thing - his best estimate based upon a methodology (based upon past history and his experience). Using the manufacturing analogy, what happens when the special order part is not being manufactured any more (because of, say, an earthquake), or has been recalled? But the analogy does not fit. These guys are cutting new ground. If we want to get a real fit on the analogy, we have to turn the clock back a hundred years. There are no factories that we can just order parts from. There are the big guys, but you're not asking for the Model T in black. (Otherwise, you'd have gone with Microsoft or Oracle, wouldn't you?) Since you didn't go to Microsoft or Oracle, we can only assume that you don't want the standard model. The folks at MySQL are developing something that apparently looks close to what you want, so you chose to go with them, based on their previous estimates. Well, they are designing it, inventing parts as they go, and rushing it to the factory floor as fast as they can. Except for one thing, they are trying to avoid the sort of situations that lead to recalls. And yes that means they uncover unknowns as they go, and most unknowns push the schedule back a bit. But that money isn't paid *to* MySQL AB, so how is that relevant? Which was a response to your assertions that the time and planning that you've put into the design based on the dev version of MySQL are real money, and the concept that since you've spent that money you are entitled to estimates, even though you have never bought a license. Not incidentally, did you ever consider that the small license fee might have been small enough to go ahead and pay it? This is where I think you've gone south. Usually, if you spec a product that is under development, you would want to
MS Access and mySQL
Subject: MS Access and mySQL From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com)) === Subject: MS Access and mySQL From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com)) === Subject: MS Access and mySQL From: =?iso-8859-1?q?Jonathan=20Coleman?= [EMAIL PROTECTED] === Hi. I have a situation where a church I am doing some volunteer work for has a MS Access (office 97) database running on NT. They are (woohoo) upgrading to a QUBE (linux box) for a server which has mySQL installed (and I can upgrade it etc..) My job therefore is to a) port MS Access data and queries to mySQL database b) use the MS Access forms to access the data and queries through ODBC. Is there anyone who can point me in the right direction, either to where the searchable discussion archives are, OR even better, someone who has gone through this before? Cheers Jon http://digital.yahoo.com.au - Yahoo! Digital How To - Get the best out of your PC! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Info on 4.0.x release date
Subject: Re: Info on 4.0.x release date From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com)) === Subject: Re: Info on 4.0.x release date From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com)) === Subject: Re: Info on 4.0.x release date From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com)) === Subject: Re: Info on 4.0.x release date From: Joel Rees [EMAIL PROTECTED] === I know I'm not really involved here, but I would like to suggest a few things. Obviously you don't agree with me and that is something I readily accept. I do have difficulty with the fact that you clearly spent more time typing your response than considering my points, which were intended to be constructive. Well, as a bystander, I think you've shot a little wide. You got the truth. Would you prefer someone lie to you about it? I will assume that your interest in mysql and participation in this list indicates that you are somehow involved in the process of software development. What is less clear is whether this may be a hobby or your profession. If it is the latter, I would love to know where it is that one can work in this industry where one is not expected to make projections about when project milestones might be met. Microsoft? This is called project management. And while those of us who simply love writing code find such pursuits annoying, they are nonetheless necessary and worthwhile -- accepting this is part of growing up. _All_ the areas where we can reliably set schedules are areas where the profit margin is, well, something like the profit margin for manufacturing pencils. Unless you own the virtual monopoly, in which case you can fill in with fud. And while I applaud the honesty of saying we won't declare it stable until it is stable, surely you can see your way clear that if you were explaining a similar situation to your boss or to your client, they would almost certainly (and justifyably) want you to give them more details. This is called accountability. So they gave you all the details they could. That is being accountable. Or did you want to see the list of remaining issues, the assignment list for who gets to cover each, and so forth? What more information would be helpful, exactly? Do guesses really help? Guesses are nice... estimates are better. What is the difference, you ask? The word guess connotes random selection or selection based upon whimsy. Estimates, on the other hand, are approximations based upon some rational methodology. Whimsy, or the cognizance of the existance of more unknowns and their limits on manpower? Suppose you take your car into the shop and after looking at it they inform you that it cannot be driven again until a new part is installed and that part will need to be special ordered. Would you not expect them to give you an estimate of how long that will take? Following your logic, they would be justified in telling you that it will be here when it gets here. Perhaps you would feel better if they said something like the computer says they have plenty in stock and it usually takes 1-2 days for shipments to arrive. In the later, the parts manager cannot say with absolute certainty when the part will arrive. But short of that certainty, he has given you the next best thing - his best estimate based upon a methodology (based upon past history and his experience). Using the manufacturing analogy, what happens when the special order part is not being manufactured any more (because of, say, an earthquake), or has been recalled? But the analogy does not fit. These guys are cutting new ground. If we want to get a real fit on the analogy, we have to turn the clock back a hundred years. There are no factories that we can just order parts from. There are the big guys, but you're not asking for the Model T in black. (Otherwise, you'd have gone with Microsoft or Oracle, wouldn't you?) Since you didn't go to Microsoft or Oracle, we can only assume that you don't want the standard model. The folks at MySQL are developing something that apparently looks close to what you want, so you chose to go with them, based on their previous estimates. Well, they are designing it, inventing parts as they go, and rushing it to the factory floor as fast as they can. Except for one thing, they are trying to avoid the sort of situations that lead to recalls. And yes that means they uncover unknowns as they go, and most unknowns push the schedule back a bit. But that money isn't paid *to* MySQL AB, so how is that relevant? Which was a response to your assertions that the time and planning that you've put into the design based on the dev version of MySQL are real money, and the concept that since you've spent that money you are entitled to estimates, even though you have never bought a license. Not incidentally, did you ever consider that the small license fee might have been small enough to go ahead and pay it? This is where I
Re: Info on 4.0.x release date
Subject: Re: Info on 4.0.x release date From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com)) === Subject: Re: Info on 4.0.x release date From: Dean Ellis [EMAIL PROTECTED] === -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 27 August 2002 09:51 pm, Will French wrote: accepting this is part of growing up. And while I applaud the honesty = of saying we won't declare it stable until it is stable, surely you can= see your way clear that if you were explaining a similar situation to your = boss or to your client, they would almost certainly (and justifyably) want y= ou to give them more details. This is called accountability. Just curious: Are you a customer of or investor in MySQL AB? Have you=20 actually purchased a license or support agreement from them? Or are you, like so many others, expecting to have everything precisely t= he=20 way you want it, before you even realize that you want it, even though yo= u=20 are not paying a dime for it? Really. Just curious. Ironically, the fact that I pay no license fees to MySQL AB is based up= on Ahhh, I see. So, you are _completely irrelevant_. You are fully entitled to your opinion. Yes, communication with regard t= o the=20 4.x series needs some improvement. Yes, they have taken considerably lon= ger=20 than they originally projected. But you are not a customer. You have no right to demand anything of them= =2E =20 They are not accountable to you in any way, shape or form. You get what you pay for. Accepting this is a part of growing up. Dean Ellis -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9bGprRU3T/K5ORe8RAuqrAJwLiBdMvZzRXY7ttCfyAzVUGJAEPQCfRml/ /KYoxBSm4mmMnAieLXFPH2s=3D =3DI7h3 -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MS Access and mySQL
Subject: MS Access and mySQL From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com)) === Subject: MS Access and mySQL From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com)) === Subject: MS Access and mySQL From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com)) === Subject: MS Access and mySQL From: =?iso-8859-1?q?Jonathan=20Coleman?= [EMAIL PROTECTED] === Hi. I have a situation where a church I am doing some volunteer work for has a MS Access (office 97) database running on NT. They are (woohoo) upgrading to a QUBE (linux box) for a server which has mySQL installed (and I can upgrade it etc..) My job therefore is to a) port MS Access data and queries to mySQL database b) use the MS Access forms to access the data and queries through ODBC. Is there anyone who can point me in the right direction, either to where the searchable discussion archives are, OR even better, someone who has gone through this before? Cheers Jon http://digital.yahoo.com.au - Yahoo! Digital How To - Get the best out of your PC! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 4.0.3 crashes every 5 seconds.
Steven, I assume you are running on Linux, since you were able to resolve the stack traces. Which distro: rpm or .tar.gz? I am right now running all my stress tests on 4.0.3 on the .tar.gz distro on a 4-way Linux-2.4.16-64GB-SMP, and it seems to work. Your bug is probably query- or platform-specific. Regards, Heikki - Original Message - From: Steven Roussey [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, August 28, 2002 6:10 AM Subject: 4.0.3 crashes every 5 seconds. I downloaded a copy of 4.0.3 from the download page and it crashes every five seconds! Resolving the stack trace gives: 0x806ebdb handle_segfault__Fi + 447 0x8261718 pthread_sighandler + 184 0x828cf8f memcpy + 31 0x80a89ce write__9MYSQL_LOGP3THDPCcUil + 1210 0x80783fd dispatch_command__F19enum_server_commandP3THDPcUi + 4105 0x80773e5 do_command__FP3THD + 93 0x8076c2e handle_one_connection__FPv + 674 0x825edfc pthread_start_thread + 204 0x82941fa thread_start + 4 and 0x806ebdb handle_segfault__Fi + 447 0x8261718 pthread_sighandler + 184 0x828cf97 memcpy + 39 0x80a89ce write__9MYSQL_LOGP3THDPCcUil + 1210 0x80783fd dispatch_command__F19enum_server_commandP3THDPcUi + 4105 0x80773e5 do_command__FP3THD + 93 0x8076c2e handle_one_connection__FPv + 674 0x825edfc pthread_start_thread + 204 0x82941fa thread_start + 4 keep repeating. Unfortunately, the query field is (nil). :( Nice to have the sym file... I guess I rushed to download too quickly... I'll write back with more info soon. Sincerely, Steven Roussey http://Network54.com/?pp=e - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 4.0.3 crashes every 5 seconds.
Hi, I'm happy to know I'm not the only one which have this segfault problem. Do you have any idea of what kind of queries causes those segfault ? (I unfortunatly have also a nil pointer) Thanks and regards, Jocelyn - Original Message - From: Steven Roussey [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Wednesday, August 28, 2002 5:02 AM Subject: 4.0.3 crashes every 5 seconds. I downloaded a copy of 4.0.3 from the download page and it crashes every five seconds! Resolving the stack trace gives: 0x806ebdb handle_segfault__Fi + 447 0x8261718 pthread_sighandler + 184 0x828cf8f memcpy + 31 0x80a89ce write__9MYSQL_LOGP3THDPCcUil + 1210 0x80783fd dispatch_command__F19enum_server_commandP3THDPcUi + 4105 0x80773e5 do_command__FP3THD + 93 0x8076c2e handle_one_connection__FPv + 674 0x825edfc pthread_start_thread + 204 0x82941fa thread_start + 4 and 0x806ebdb handle_segfault__Fi + 447 0x8261718 pthread_sighandler + 184 0x828cf97 memcpy + 39 0x80a89ce write__9MYSQL_LOGP3THDPCcUil + 1210 0x80783fd dispatch_command__F19enum_server_commandP3THDPcUi + 4105 0x80773e5 do_command__FP3THD + 93 0x8076c2e handle_one_connection__FPv + 674 0x825edfc pthread_start_thread + 204 0x82941fa thread_start + 4 keep repeating. Unfortunately, the query field is (nil). :( Nice to have the sym file... I guess I rushed to download too quickly... I'll write back with more info soon. Sincerely, Steven Roussey http://Network54.com/?pp=e - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
synopsis of the problem (one line)
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.49 (Source distribution) Environment: System: Linux Ilixo 2.2.16-22 #1 Tue Aug 22 16:16:55 EDT 2000 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.0) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 14 mai 17 04:03 /lib/libc.so.6 - libc-2.1.92.so -rwxr-xr-x1 root root 4686077 aoû 30 2000 /lib/libc-2.1.92.so -rw-r--r--1 root root 22607104 aoû 30 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 aoû 30 2000 /usr/lib/libc.so Configure command: ./configure - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Info on 4.0.x release date
Subject: Re: Info on 4.0.x release date From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com)) === Subject: Re: Info on 4.0.x release date From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com)) === Subject: Re: Info on 4.0.x release date From: Dean Ellis [EMAIL PROTECTED] === -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 27 August 2002 09:51 pm, Will French wrote: accepting this is part of growing up. And while I applaud the honesty = of saying we won't declare it stable until it is stable, surely you can= see your way clear that if you were explaining a similar situation to your = boss or to your client, they would almost certainly (and justifyably) want y= ou to give them more details. This is called accountability. Just curious: Are you a customer of or investor in MySQL AB? Have you=20 actually purchased a license or support agreement from them? Or are you, like so many others, expecting to have everything precisely t= he=20 way you want it, before you even realize that you want it, even though yo= u=20 are not paying a dime for it? Really. Just curious. Ironically, the fact that I pay no license fees to MySQL AB is based up= on Ahhh, I see. So, you are _completely irrelevant_. You are fully entitled to your opinion. Yes, communication with regard t= o the=20 4.x series needs some improvement. Yes, they have taken considerably lon= ger=20 than they originally projected. But you are not a customer. You have no right to demand anything of them= =2E =20 They are not accountable to you in any way, shape or form. You get what you pay for. Accepting this is a part of growing up. Dean Ellis -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9bGprRU3T/K5ORe8RAuqrAJwLiBdMvZzRXY7ttCfyAzVUGJAEPQCfRml/ /KYoxBSm4mmMnAieLXFPH2s=3D =3DI7h3 -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MS Access and mySQL
Subject: MS Access and mySQL From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com)) === Subject: MS Access and mySQL From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com)) === Subject: MS Access and mySQL From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com)) === Subject: MS Access and mySQL From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com)) === Subject: MS Access and mySQL From: =?iso-8859-1?q?Jonathan=20Coleman?= [EMAIL PROTECTED] === Hi. I have a situation where a church I am doing some volunteer work for has a MS Access (office 97) database running on NT. They are (woohoo) upgrading to a QUBE (linux box) for a server which has mySQL installed (and I can upgrade it etc..) My job therefore is to a) port MS Access data and queries to mySQL database b) use the MS Access forms to access the data and queries through ODBC. Is there anyone who can point me in the right direction, either to where the searchable discussion archives are, OR even better, someone who has gone through this before? Cheers Jon http://digital.yahoo.com.au - Yahoo! Digital How To - Get the best out of your PC! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 4.0.3 crashes every 5 seconds.
Subject: Re: 4.0.3 crashes every 5 seconds. From: Heikki Tuuri [EMAIL PROTECTED] === Steven, I assume you are running on Linux, since you were able to resolve the stack traces. Which distro: rpm or .tar.gz? I am right now running all my stress tests on 4.0.3 on the .tar.gz distro on a 4-way Linux-2.4.16-64GB-SMP, and it seems to work. Your bug is probably query- or platform-specific. Regards, Heikki - Original Message - From: Steven Roussey [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, August 28, 2002 6:10 AM Subject: 4.0.3 crashes every 5 seconds. I downloaded a copy of 4.0.3 from the download page and it crashes every five seconds! Resolving the stack trace gives: 0x806ebdb handle_segfault__Fi + 447 0x8261718 pthread_sighandler + 184 0x828cf8f memcpy + 31 0x80a89ce write__9MYSQL_LOGP3THDPCcUil + 1210 0x80783fd dispatch_command__F19enum_server_commandP3THDPcUi + 4105 0x80773e5 do_command__FP3THD + 93 0x8076c2e handle_one_connection__FPv + 674 0x825edfc pthread_start_thread + 204 0x82941fa thread_start + 4 and 0x806ebdb handle_segfault__Fi + 447 0x8261718 pthread_sighandler + 184 0x828cf97 memcpy + 39 0x80a89ce write__9MYSQL_LOGP3THDPCcUil + 1210 0x80783fd dispatch_command__F19enum_server_commandP3THDPcUi + 4105 0x80773e5 do_command__FP3THD + 93 0x8076c2e handle_one_connection__FPv + 674 0x825edfc pthread_start_thread + 204 0x82941fa thread_start + 4 keep repeating. Unfortunately, the query field is (nil). :( Nice to have the sym file... I guess I rushed to download too quickly... I'll write back with more info soon. Sincerely, Steven Roussey http://Network54.com/?pp=e - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 4.0.3 crashes every 5 seconds.
Subject: Re: 4.0.3 crashes every 5 seconds. From: Jocelyn Fournier [EMAIL PROTECTED] === Hi, I'm happy to know I'm not the only one which have this segfault problem. Do you have any idea of what kind of queries causes those segfault ? (I unfortunatly have also a nil pointer) Thanks and regards, Jocelyn - Original Message - From: Steven Roussey [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Wednesday, August 28, 2002 5:02 AM Subject: 4.0.3 crashes every 5 seconds. I downloaded a copy of 4.0.3 from the download page and it crashes every five seconds! Resolving the stack trace gives: 0x806ebdb handle_segfault__Fi + 447 0x8261718 pthread_sighandler + 184 0x828cf8f memcpy + 31 0x80a89ce write__9MYSQL_LOGP3THDPCcUil + 1210 0x80783fd dispatch_command__F19enum_server_commandP3THDPcUi + 4105 0x80773e5 do_command__FP3THD + 93 0x8076c2e handle_one_connection__FPv + 674 0x825edfc pthread_start_thread + 204 0x82941fa thread_start + 4 and 0x806ebdb handle_segfault__Fi + 447 0x8261718 pthread_sighandler + 184 0x828cf97 memcpy + 39 0x80a89ce write__9MYSQL_LOGP3THDPCcUil + 1210 0x80783fd dispatch_command__F19enum_server_commandP3THDPcUi + 4105 0x80773e5 do_command__FP3THD + 93 0x8076c2e handle_one_connection__FPv + 674 0x825edfc pthread_start_thread + 204 0x82941fa thread_start + 4 keep repeating. Unfortunately, the query field is (nil). :( Nice to have the sym file... I guess I rushed to download too quickly... I'll write back with more info soon. Sincerely, Steven Roussey http://Network54.com/?pp=e - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql error in RH7.3
On Wed, 2002-08-28 at 03:35, nflorez wrote: I am trying to run Mysql for the first time and it fail. -- #mysql -u root -p Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) - I'm new to this list so I could be wrong, but it seems to me like your mysqld isn't running. Check which services are running and if mysqld isn't running start it and try again, that worked for me. (btw I made sure the daemon now starts every time I boot.) If you're running a gui: go to the control panel open the services dialog and simply check the correct box. HTH -- # Mertens Bram M8ram [EMAIL PROTECTED] Linux User #249103 # # Red Hat Linux 7.3 KDE 3.0.0-10 kernel 2.4.18-3 i686 128MB RAM # # A priest advised Voltaire on his death bed to renounce the devil. # # Replied Voltaire, This is no time to make new enemies. # - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: synopsis of the problem (one line)
Does anyone have any preference regarding the use of Connector/J version 2+ or version 3? I am confused after reading the mySQL website as to whether some of the following features are new as of version 2 or version 3 of the driver: 1. 50-100% faster than previous version. 2. Supports prepared statement. These factors plus any positive/negative experience would be valuable in making a decision as to which version of the driver to use. Any thoughts? Thanks. Neal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Info on 4.0.x release date
Subject: Re: Info on 4.0.x release date From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com)) === Subject: Re: Info on 4.0.x release date From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com)) === Subject: Re: Info on 4.0.x release date From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com)) === Subject: Re: Info on 4.0.x release date From: Dean Ellis [EMAIL PROTECTED] === -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 27 August 2002 09:51 pm, Will French wrote: accepting this is part of growing up. And while I applaud the honesty = of saying we won't declare it stable until it is stable, surely you can= see your way clear that if you were explaining a similar situation to your = boss or to your client, they would almost certainly (and justifyably) want y= ou to give them more details. This is called accountability. Just curious: Are you a customer of or investor in MySQL AB? Have you=20 actually purchased a license or support agreement from them? Or are you, like so many others, expecting to have everything precisely t= he=20 way you want it, before you even realize that you want it, even though yo= u=20 are not paying a dime for it? Really. Just curious. Ironically, the fact that I pay no license fees to MySQL AB is based up= on Ahhh, I see. So, you are _completely irrelevant_. You are fully entitled to your opinion. Yes, communication with regard t= o the=20 4.x series needs some improvement. Yes, they have taken considerably lon= ger=20 than they originally projected. But you are not a customer. You have no right to demand anything of them= =2E =20 They are not accountable to you in any way, shape or form. You get what you pay for. Accepting this is a part of growing up. Dean Ellis -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9bGprRU3T/K5ORe8RAuqrAJwLiBdMvZzRXY7ttCfyAzVUGJAEPQCfRml/ /KYoxBSm4mmMnAieLXFPH2s=3D =3DI7h3 -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
synopsis of the problem (one line)
Subject: synopsis of the problem (one line) From: root [EMAIL PROTECTED] === Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.49 (Source distribution) Environment: System: Linux Ilixo 2.2.16-22 #1 Tue Aug 22 16:16:55 EDT 2000 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.0) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 14 mai 17 04:03 /lib/libc.so.6 - libc-2.1.92.so -rwxr-xr-x1 root root 4686077 aoû 30 2000 /lib/libc-2.1.92.so -rw-r--r--1 root root 22607104 aoû 30 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 aoû 30 2000 /usr/lib/libc.so Configure command: ./configure - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Info on 4.0.x release date
Subject: Re: Info on 4.0.x release date From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com)) === Subject: Re: Info on 4.0.x release date From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com)) === Subject: Re: Info on 4.0.x release date From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com)) === Subject: Re: Info on 4.0.x release date From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com)) === Subject: Re: Info on 4.0.x release date From: [EMAIL PROTECTED] (MySQL Newsgroup (@Basebeans.com)) === Subject: Re: Info on 4.0.x release date From: Joel Rees [EMAIL PROTECTED] === I know I'm not really involved here, but I would like to suggest a few things. Obviously you don't agree with me and that is something I readily accept. I do have difficulty with the fact that you clearly spent more time typing your response than considering my points, which were intended to be constructive. Well, as a bystander, I think you've shot a little wide. You got the truth. Would you prefer someone lie to you about it? I will assume that your interest in mysql and participation in this list indicates that you are somehow involved in the process of software development. What is less clear is whether this may be a hobby or your profession. If it is the latter, I would love to know where it is that one can work in this industry where one is not expected to make projections about when project milestones might be met. Microsoft? This is called project management. And while those of us who simply love writing code find such pursuits annoying, they are nonetheless necessary and worthwhile -- accepting this is part of growing up. _All_ the areas where we can reliably set schedules are areas where the profit margin is, well, something like the profit margin for manufacturing pencils. Unless you own the virtual monopoly, in which case you can fill in with fud. And while I applaud the honesty of saying we won't declare it stable until it is stable, surely you can see your way clear that if you were explaining a similar situation to your boss or to your client, they would almost certainly (and justifyably) want you to give them more details. This is called accountability. So they gave you all the details they could. That is being accountable. Or did you want to see the list of remaining issues, the assignment list for who gets to cover each, and so forth? What more information would be helpful, exactly? Do guesses really help? Guesses are nice... estimates are better. What is the difference, you ask? The word guess connotes random selection or selection based upon whimsy. Estimates, on the other hand, are approximations based upon some rational methodology. Whimsy, or the cognizance of the existance of more unknowns and their limits on manpower? Suppose you take your car into the shop and after looking at it they inform you that it cannot be driven again until a new part is installed and that part will need to be special ordered. Would you not expect them to give you an estimate of how long that will take? Following your logic, they would be justified in telling you that it will be here when it gets here. Perhaps you would feel better if they said something like the computer says they have plenty in stock and it usually takes 1-2 days for shipments to arrive. In the later, the parts manager cannot say with absolute certainty when the part will arrive. But short of that certainty, he has given you the next best thing - his best estimate based upon a methodology (based upon past history and his experience). Using the manufacturing analogy, what happens when the special order part is not being manufactured any more (because of, say, an earthquake), or has been recalled? But the analogy does not fit. These guys are cutting new ground. If we want to get a real fit on the analogy, we have to turn the clock back a hundred years. There are no factories that we can just order parts from. There are the big guys, but you're not asking for the Model T in black. (Otherwise, you'd have gone with Microsoft or Oracle, wouldn't you?) Since you didn't go to Microsoft or Oracle, we can only assume that you don't want the standard model. The folks at MySQL are developing something that apparently looks close to what you want, so you chose to go with them, based on their previous estimates. Well, they are designing it, inventing parts as they go, and rushing it to the factory floor as fast as they can. Except for one thing, they are trying to avoid the sort of situations that lead to recalls. And yes that means they uncover unknowns as they go, and most unknowns push the schedule back a bit. But that money isn't paid *to* MySQL AB, so how is that relevant? Which was a response to your assertions that the time and planning that you've put into the design based on the dev version of MySQL are real money, and the concept that since you've spent that money you
MySQL/InnoDB-4.0.3 is released
Hi! InnoDB is a table type which adds transactions, row level locking, and foreign key constraints to MySQL. InnoDB is included in all distributions of MySQL-4.0, both in the plain and the -Max release. InnoDB in the stable MySQL-Max-3.23 branch is now frozen except for bug fixes. New InnoDB features will appear in the 4.0 branch or in 4.1. Compared to 4.0.2, the release 4.0.3 adds new SQL commands: - SHOW INNODB STATUS returns the output of the InnoDB Monitor to the MySQL client. This is very useful in performance tuning and finding out the reasons of transaction deadlocks. - SET UNIQUE_CHECKS = 0 speeds up disk-bound table imports. - SET FOREIGN KEY CHECKS = 0 allows one to import table dumps in any order regardless of foreign key constraints. - HANDLER commands now work also for InnoDB type tables. In some cases HANDLER can be used as a substitute of server-side cursors. See the MySQL manual about the details of HANDLER. Full changelogs are shown below. Compared to 4.0.2, also all the changes of 3.23.52 are included in 4.0.3. MySQL/InnoDB-4.0.3, August 28, 2002: * Removed unnecessary deadlocks when inserts have to wait for a locking read, update, or delete to release its next-key lock. * The MySQL HANDLER SQL commands now work also for InnoDB type tables. InnoDB does the HANDLER reads always as consistent reads. HANDLER is a direct access path to read individual indexes of tables. In some cases HANDLER can be used as a substitute of server-side cursors. * Fixed a bug in 4.0.2: even a simple insert could crash the AIX version. * Fixed a bug: if you used in a table name characters whose code is 127, in DROP TABLE InnoDB could assert on line 155 of pars0sym.c. * Compilation from source now provides a working version both on HP-UX-11 and HP-UX-10.20. The source of 4.0.2 worked only on 11, and the source of 3.23.52 only on 10.20. * Fixed a bug: if compiled on 64-bit Solaris, InnoDB produced a bus error at startup. MySQL/InnoDB-3.23.52, August 16, 2002: * Many CPU-bound join queries now run faster. On Windows also many other CPU-bound queries run faster. * A new SQL command SHOW INNODB STATUS returns the output of the InnoDB Monitor to the client. The InnoDB Monitor now prints detailed info on the latest detected deadlock. * InnoDB made the SQL query optimizer to avoid too much index-only range scans and choose full table scans instead. This is now fixed. * BEGIN and COMMIT are now added in the binlog around transactions. The MySQL replication now respects transaction borders: a user will no longer see half transactions in replication slaves. * A replication slave now prints in crash recovery the last master binlog position it was able to recover to. * A new setting innodb_flush_log_at_trx_commit=2 makes InnoDB to write the log to the operating system file cache at each commit. This is almost as fast as the setting innodb_flush_log_at_trx_commit=0, and the setting 2 also has the nice feature that in a crash where the operating system does not crash, no committed transaction is lost. If the operating system crashes or there is a power outage, then the setting 2 is no safer than the setting 0. * Added checksum fields to log blocks. * SET FOREIGN_KEY_CHECKS=0 helps in importing tables in an arbitrary order which does not respect the foreign key rules. * SET UNIQUE_CHECKS=0 speeds up table imports into InnoDB if you have UNIQUE constraints on secondary indexes. * SHOW TABLE STATUS now lists also possible ON DELETE CASCADE or ON DELETE SET NULL in the comment field of the table. * When CHECK TABLE is run on any InnoDB type table, it now checks also the adaptive hash index for all tables. * If you defined ON DELETE CASCADE or SET NULL and updated the referenced key in the parent row, InnoDB deleted or updated the child row. This is now changed to conform to SQL-92: you get the error 'Cannot delete parent row'. * Improved the auto-increment algorithm: now the first insert or SHOW TABLE STATUS initializes the auto-inc counter for the table. This removes almost all surprising deadlocks caused by SHOW TABLE STATUS. * Fixed a bug: If you updated the primary key of a table so that only the case of characters changed, that could cause assertion failures, mostly in page0page.ic line 515. * Fixed a bug: If you delete or update a row referenced in a foreign key constraint and the foreign key check has to wait for a lock, then the check may report an erroneous result. This affects also the ON DELETE... operation. * Fixed a bug: A deadlock or a lock wait timeout error in InnoDB causes InnoDB to roll back the whole transaction, but MySQL could still write the earlier SQL statements to the binlog, even though InnoDB rolled them back. This could, for example, cause replicated databases to get out-of-sync. * Fixed a bug: If the database happened to crash in the middle of a commit, then the recovery might leak tablespace pages. * Fixed a bug: If you specified a non-latin1 character set in
Re: 4.0.3 crashes every 5 seconds.
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Wednesday 28 August 2002 05:02, Steven Roussey wrote: I downloaded a copy of 4.0.3 from the download page and it crashes every five seconds! Resolving the stack trace gives: 0x806ebdb handle_segfault__Fi + 447 0x8261718 pthread_sighandler + 184 0x828cf8f memcpy + 31 0x80a89ce write__9MYSQL_LOGP3THDPCcUil + 1210 0x80783fd dispatch_command__F19enum_server_commandP3THDPcUi + 4105 0x80773e5 do_command__FP3THD + 93 0x8076c2e handle_one_connection__FPv + 674 0x825edfc pthread_start_thread + 204 0x82941fa thread_start + 4 and 0x806ebdb handle_segfault__Fi + 447 0x8261718 pthread_sighandler + 184 0x828cf97 memcpy + 39 0x80a89ce write__9MYSQL_LOGP3THDPCcUil + 1210 0x80783fd dispatch_command__F19enum_server_commandP3THDPcUi + 4105 0x80773e5 do_command__FP3THD + 93 0x8076c2e handle_one_connection__FPv + 674 0x825edfc pthread_start_thread + 204 0x82941fa thread_start + 4 keep repeating. Unfortunately, the query field is (nil). :( Nice to have the sym file... I guess I rushed to download too quickly... I'll write back with more info soon. Ouch! Thanks for the report. Can you please give us some more details? Which operating system (kernel, glibc), which package did you use? Fortunately I did not send out the announcement yet... Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE9bIB6SVDhKrJykfIRAtPKAJ9cpRmfSenXKY9lJUX5R2rp+lbTMQCfYg9Z eRdHC8jtmR+Tn9qvV0CchM8= =v1qU -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
load data into table from file or how to set the local-infile=1variable
Hi, I was following the example in the manual (the menagerie database) but I can not load a file into the table, i get the following error: mysql LOAD DATA LOCAL INFILE ~/testmysql/pet.txt INTO TABLE pet; ERROR 1148: The used command is not allowed with this MySQL version I searched the archives and found that a variable local-infile=1 must be set for the client, but I can not find how to do that. Can somebody help me with this please? I'm using mysql version 3.23.49 on a Red Hat Linux 7.3. -- # Mertens Bram M8ram [EMAIL PROTECTED] Linux User #249103 # # Red Hat Linux 7.3 KDE 3.0.0-10 kernel 2.4.18-3 i686 128MB RAM # # A priest advised Voltaire on his death bed to renounce the devil. # # Replied Voltaire, This is no time to make new enemies. # - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Slow select query, need some clues to speed it up please ...
Have you tried the command : EXPLAIN SELECT select_options (http://www.mysql.com/doc/en/EXPLAIN.html). Maybe it can help you to see what Indexes are used ... Stephan -Original Message- From: David Bordas [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 5:16 PM To: Mikhail Entaltsev Cc: [EMAIL PROTECTED] Subject: Re: Slow select query, need some clues to speed it up please ... ME In this case... ME Can you try again? Sure. query 1 : SELECT Field1,Field2,Field3,Field4,Field5,Field6,Field7 FROM MyTable WHERE Field7=15 AND Field2=0 AND (Field3 LIKE '%John%' OR Field4 LIKE '%John%' OR Field5 LIKE '% John%' ) ORDER BY Field6 LIMIT 0,20; query 2: SELECT Field1,Field2,Field3,Field4,Field5,Field6,Field7 FROM MyTable WHERE Field7=15 AND Field2=0 AND (Field3 LIKE '%John%' OR Field4 LIKE '%John%' ) ORDER BY Field6 LIMIT 0,20; Results : query | time 1 0.78s 2 1.20s 1 0.77s 2 1.21s 1 0.78s 2 1.22s IMHO there are 2 ways: 1. It will work much faster. 2. It won't change speed of execution significantly. Euh Third one ? Remove a condition slow the query ... Perhaps i've a problem somewhere, but where .. Perhaps with some cache variables ? I don't know. This is the my.cnf : # The MySQL server [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking skip-name-resolve set-variable= key_buffer=128M set-variable= back_log=100 set-variable= record_buffer=1M set-variable= sort_buffer=2M set-variable= max_allowed_packet=1M set-variable= thread_stack=128K set-variable= max_connections=700 set-variable= max_connect_errors=100 set-variable= table_cache=256 set-variable= net_read_timeout=180 set-variable= net_write_timeout=180 set-variable= wait_timeout=3600 Server have got 1Go and run only mysql ... Table have 4M rows and index. Mytable.MYD : 1109586816 bytes Mytable.MYI : 93065216 Thanks David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Searching text in a big table
Check out full-text indexing: http://www.mysql.com/doc/en/Fulltext_Search.html I don't think there's any other way to improve searching in unstructured text using MySQL -steve At 3:58 PM -0700 8/27/02, Sanny Sun wrote: Hi there, I have a big table which has 25 rows.And each row has a BLOB field which stores lots of text. When I search text in this table(using the query: where CONTENT like '%news%'),the searching speed is quite slow. is there anybody also have such problem? Any ideas about improving the speed of searching text in big table? Thanks in advance. -- ++ | Steve Edberg [EMAIL PROTECTED] | | University of California, Davis (530)754-9127 | | Programming/Database/SysAdmin http://pgfsun.ucdavis.edu/ | ++ | The end to politics as usual: | | The Monster Raving Loony Party (http://www.omrlp.com/) | ++ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Slow select query, need some clues to speed it up please ...
BS Have you tried the command : EXPLAIN SELECT select_options BS (http://www.mysql.com/doc/en/EXPLAIN.html). Maybe it can help you to see BS what Indexes are used ... Yep i do that but varchar and text fields aren't index so ... I'm also having a look to FULLTEXT index, but i think that the index will be really really big ... :( I'm also reading docs about locking. In fact i saw while using show full processlist that when mysql is executing the query, all other ones are 'locked' but why lock table for a SELECT query ? And that's a good question. I surely missed something about the lock statement ... David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Slow select query, need some clues to speed it up please ...
What do you mean varchar and text fields are not index? alter table mytable add index (myvarchar, mytext(100)) One last resort that may work for you is to try the regexp instead of LIKE. The functionality of regexps for me has at best been unpredictable, sometimes it is faster, sometimes at par with LIKEs. So, where CONTENT like '%word1%' or CONTENT like '%word2%' or CONTENT like '%word3%' becomes, where CONTENT regexp 'word1|word2|word3' Cheers Shanx | Yep i do that but varchar and text fields aren't index so ... | | I'm also having a look to FULLTEXT index, but i think | that the index will be really really big ... :( | Shashank Tripathi www.shanx.com 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: Slow select query, need some clues to speed it up please ...
David, | | As I understand...after removing Field5 LIKE '%John' | | condition the query works much faster. | | Nop, sorry i'm not clear, the query works mush slower ... This will be fast if you have the right index-- field5 like 'John%' These will NOT be fast -- field5 like '%John%' field5 like '%John' Putting a wildcard character (%) before the term will avoid the index. Shashank Shashank Tripathi www.shanx.com 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: Slow select query, need some clues to speed it up please ...
From: Shashank Tripathi [EMAIL PROTECTED] This will be fast if you have the right index-- field5 like 'John%' These will NOT be fast -- field5 like '%John%' field5 like '%John' Putting a wildcard character (%) before the term will avoid the index. Yep, and it's for that point that an index on varchars and text will not help me ... alter table mytable add index (myvarchar, mytext(100)) I think that the index will too big to be usefull for me. Other way if i need an index, so perhaps i can try FULLTEXT. I'm currently building a fulltext index on a test server but it's lonnng to do that :) One last resort that may work for you is to try the regexp instead of LIKE. The functionality of regexps for me has at best been unpredictable, sometimes it is faster, sometimes at par with LIKEs. So, where CONTENT like '%word1%' or CONTENT like '%word2%' or CONTENT like '%word3%' becomes, where CONTENT regexp 'word1|word2|word3' Why not regexp but this is not i mean, in fact where CONTENT like '%word1%' or CONTENT like '%word2%' or CONTENT like '%word3%' shoud be : where CONTENT1 like '%word%' or CONTENT2 like '%word%' or CONTENT3 like '%word%' So i'll be 3 regexp i think ... Other big problem is why mysql locked all queries during executing this one ... Thanks David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Slow select query, need some clues to speed it up please ...
Hi David, | Why not regexp but this is not i mean, in fact | where CONTENT like '%word1%' | or CONTENT like '%word2%' | or CONTENT like '%word3%' | shoud be : | where CONTENT1 like '%word%' | or CONTENT2 like '%word%' | or CONTENT3 like '%word%' | So i'll be 3 regexp i think ... No, that'll be one regexp. That is the beauty of using regexp. Try it. | Other big problem is why mysql locked all queries during | executing this one ... Agree on this one, this is a little unfortunate. But MySQL 4 should give you row level locking, and well, using index on '%WORD%' as well. Meanwhile, a full text index should be the only way out for you. Its big but its worth it in your case. Cheers, Shashank Shashank Tripathi www.shanx.com 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: job database with invoicing
Subject: job database with invoicing Date: Tue, 27 Aug 2002 22:05:43 +0200 From: Kai Vermehr [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] I'm building a job database with simple invoicing. I have one table called JOBS and one called INVOICES. In INVOICES there's a foreign key column called job_id referencing INVOICES to JOBS.job_id. in a simplified way it looks like this: (there are a lot of other columns of course) table JOBS ( job_id int not null auto_increment, jobname char(30), primary key job_id ) and table INVOICES ( invoice_id int not null auto_increment, job_id int(11), foreign key job_id, primary key invoice_id ) Would this make sense if in the future I want to find out: #1 which jobs have and have not been invoiced #2 what invoices are linked to specific job What would the MySQL statement look like? I've tried to find out but I'm not sure if the relations between both tables make sense at all ... thanks for any help! K:) I'm in the middle of writing my own accounts receivable db so this caught my eye. My first question though concerns your first question. If a job hasn't been invoiced, there won't / shouldn't be an entry for 'job_id' in the INVOICES table, right? When I start work on a new db, I usually put some dummy data down on paper in a grid and do all my testing there. Once I have an answer to a query, I can then test it against the real db by comparing results. The dummy data I used: mysql select * from invoices; +++ | invoice_id | job_id | +++ |701 | 1 | |702 | 2 | |703 | 1 | |704 | 3 | |705 | 1 | |706 | 3 | |707 | 2 | |708 | 5 | |709 | 1 | |710 | 2 | +++ 10 rows in set (0.00 sec) mysql select * from jobs; ++--+ | job_id | job_name | ++--+ | 1 | A| | 2 | B| | 3 | C| | 4 | D| | 5 | E| ++--+ 5 rows in set (0.00 sec) *** Note that job_id 4 (D) does not have an entry in the invoices table, therefore it hasn't been invoiced. In this case your first question can be translated into something like: Q: what jobs have been invoiced mysql select invoices.*, jobs.* from invoices,jobs - where jobs.job_id=invoices.job_id - group by invoices.job_id; ++++--+ | invoice_id | job_id | job_id | job_name | ++++--+ |701 | 1 | 1 | A| |702 | 2 | 2 | B| |704 | 3 | 3 | C| |708 | 5 | 5 | E| ++++--+ 4 rows in set (0.00 sec) Q; what jobs have not been invoiced? mysql select jobs.*,invoices.* from jobs left join invoices on - jobs.job_id=invoices.job_id; ++--+++ | job_id | job_name | invoice_id | job_id | ++--+++ | 1 | A|701 | 1 | | 1 | A|703 | 1 | | 1 | A|705 | 1 | | 1 | A|709 | 1 | | 2 | B|702 | 2 | | 2 | B|707 | 2 | | 2 | B|710 | 2 | | 3 | C|704 | 3 | | 3 | C|706 | 3 | | 4 | D| NULL | NULL | | 5 | E|708 | 5 | ++--+++ 11 rows in set (0.11 sec) or, perhaps a better query ... mysql select jobs.*,invoices.* - from jobs left join invoices on jobs.job_id=invoices.job_id - where invoices.job_id is null; ++--+++ | job_id | job_name | invoice_id | job_id | ++--+++ | 4 | D| NULL | NULL | ++--+++ 1 row in set (0.00 sec) Q: what invoices are linked to specific job mysql select invoices.*,jobs.* from invoices,jobs - where job_name like '%A%' - and invoices.job_id=jobs.job_id - order by invoice_id; ++++--+ | invoice_id | job_id | job_id | job_name | ++++--+ |701 | 1 | 1 | A| |703 | 1 | 1 | A| |705 | 1 | 1 | A| |709 | 1 | 1 | A| ++++--+ 4 rows in set (0.05 sec) That should get you on your way. -- /* All outgoing email scanned by Norton Antivirus 2002 */ Amer Neely, Softouch Information Services W: www.softouch.on.ca E: [EMAIL PROTECTED] V: 519.438.5887 Perl | PHP | MySQL | CGI programming for all data entry forms. We make web sites work!
Re: Slow select query, need some clues to speed it up please ...
From: Shashank Tripathi [EMAIL PROTECTED] | Why not regexp but this is not i mean, in fact | where CONTENT like '%word1%' | or CONTENT like '%word2%' | or CONTENT like '%word3%' | shoud be : | where CONTENT1 like '%word%' | or CONTENT2 like '%word%' | or CONTENT3 like '%word%' | So i'll be 3 regexp i think ... No, that'll be one regexp. That is the beauty of using regexp. Try it. I'll have a look to doc and try it soon ... | Other big problem is why mysql locked all queries during | executing this one ... Agree on this one, this is a little unfortunate. But MySQL 4 should give you row level locking, and well, using index on '%WORD%' as well. Meanwhile, a full text index should be the only way out for you. Its big but its worth it in your case. As soon as fulltext index will be built, i'll try some test and see what's is better ... Thanks David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Slow select query, need some clues to speed it up please ...
Hi, - Original Message - From: Shashank Tripathi [EMAIL PROTECTED] To: 'David Bordas' [EMAIL PROTECTED]; 'BRACHET,STEPHAN (Non-HP-France,ex1)' [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, August 28, 2002 12:25 PM Subject: RE: Slow select query, need some clues to speed it up please ... What do you mean varchar and text fields are not index? alter table mytable add index (myvarchar, mytext(100)) ...or one index for many fields. One last resort that may work for you is to try the regexp instead of LIKE. The functionality of regexps for me has at best been unpredictable, sometimes it is faster, sometimes at par with LIKEs. ...yearight. So, where CONTENT like '%word1%' or CONTENT like '%word2%' or CONTENT like '%word3%' ...and you have good results, using bitwise operator? becomes, where CONTENT regexp 'word1|word2|word3' .anyway this is not the same with the David problem. Regards, Gelu Cheers Shanx | Yep i do that but varchar and text fields aren't index so ... | | I'm also having a look to FULLTEXT index, but i think | that the index will be really really big ... :( | Shashank Tripathi www.shanx.com Sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql performance problem
- Original Message - From: Supriya Shiyekar [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, August 27, 2002 10:59 PM Subject: MySql performance problem Hi, We are having strange performance problem with mysql on Solaris.Our application makes JDBC calls to mysql database which resides locally on the machine. It takes 3 minutes to execute a piece of code(which involves select, insert and update queries) on a Windows machine but an hour on Solaris. Both databases(on windows and solaris) have exactly same database structure including indexes and table sizes. We are using mysql 3.23.44. Is this something to do with the memory allocated to mysql on Solaris machine ? Do we need to check any server parameters for mysql ? What is the setup of the two machines? (CPU/RAM/Disk/SCSI/IDE, etc), and what configuration parameters are you using now? Without this, you're asking us to guess, more information from you would get a better answer. -Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: job database with invoicing
Hi Armer, thanks a lot for your help ... it was very usefull!!! After understanding the principles I wonder why I didn't think it up myself ... but then solutions often appear obvious after a problem is solved. Also I like your remarks on testing queries on paper first -- I'll see if I can use that ... And finally I noticed that I can find out how many invoices have been issued per job using the count term. Thus making it easy to keep track about monitions: mysql select jobs.*, count(invoices.invoice_id) - from invoices, jobs - where jobs.job_id = invoices.job_id - group by invoices.job_id thanks again!! -- K:) on 28/8/02 11:47 Uhr, Amer Neely at [EMAIL PROTECTED] wrote: Subject: job database with invoicing Date: Tue, 27 Aug 2002 22:05:43 +0200 From: Kai Vermehr [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] I'm building a job database with simple invoicing. I have one table called JOBS and one called INVOICES. In INVOICES there's a foreign key column called job_id referencing INVOICES to JOBS.job_id. in a simplified way it looks like this: (there are a lot of other columns of course) table JOBS ( job_id int not null auto_increment, jobname char(30), primary key job_id ) and table INVOICES ( invoice_id int not null auto_increment, job_id int(11), foreign key job_id, primary key invoice_id ) Would this make sense if in the future I want to find out: #1 which jobs have and have not been invoiced #2 what invoices are linked to specific job What would the MySQL statement look like? I've tried to find out but I'm not sure if the relations between both tables make sense at all ... thanks for any help! K:) I'm in the middle of writing my own accounts receivable db so this caught my eye. My first question though concerns your first question. If a job hasn't been invoiced, there won't / shouldn't be an entry for 'job_id' in the INVOICES table, right? When I start work on a new db, I usually put some dummy data down on paper in a grid and do all my testing there. Once I have an answer to a query, I can then test it against the real db by comparing results. The dummy data I used: mysql select * from invoices; +++ | invoice_id | job_id | +++ |701 | 1 | |702 | 2 | |703 | 1 | |704 | 3 | |705 | 1 | |706 | 3 | |707 | 2 | |708 | 5 | |709 | 1 | |710 | 2 | +++ 10 rows in set (0.00 sec) mysql select * from jobs; ++--+ | job_id | job_name | ++--+ | 1 | A| | 2 | B| | 3 | C| | 4 | D| | 5 | E| ++--+ 5 rows in set (0.00 sec) *** Note that job_id 4 (D) does not have an entry in the invoices table, therefore it hasn't been invoiced. In this case your first question can be translated into something like: Q: what jobs have been invoiced mysql select invoices.*, jobs.* from invoices,jobs - where jobs.job_id=invoices.job_id - group by invoices.job_id; ++++--+ | invoice_id | job_id | job_id | job_name | ++++--+ |701 | 1 | 1 | A| |702 | 2 | 2 | B| |704 | 3 | 3 | C| |708 | 5 | 5 | E| ++++--+ 4 rows in set (0.00 sec) Q; what jobs have not been invoiced? mysql select jobs.*,invoices.* from jobs left join invoices on - jobs.job_id=invoices.job_id; ++--+++ | job_id | job_name | invoice_id | job_id | ++--+++ | 1 | A|701 | 1 | | 1 | A|703 | 1 | | 1 | A|705 | 1 | | 1 | A|709 | 1 | | 2 | B|702 | 2 | | 2 | B|707 | 2 | | 2 | B|710 | 2 | | 3 | C|704 | 3 | | 3 | C|706 | 3 | | 4 | D| NULL | NULL | | 5 | E|708 | 5 | ++--+++ 11 rows in set (0.11 sec) or, perhaps a better query ... mysql select jobs.*,invoices.* - from jobs left join invoices on jobs.job_id=invoices.job_id - where invoices.job_id is null; ++--+++ | job_id | job_name | invoice_id | job_id | ++--+++ | 4 | D| NULL | NULL | ++--+++ 1 row in set (0.00 sec) Q: what invoices are linked to specific job mysql select invoices.*,jobs.* from invoices,jobs - where
msql document
hii, I am trying to learn how to use mysql with php on windows.. Can you help me to find some tutorial , e-book or any helpfull url ...? By the way, I am new at this .. so I need something covering the basic informations... thanks a lot Meltem - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MS Access and mySQL
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jonathan, If you are going to be completely converting the Access db to MySQL, and just using Access as the frontend, you will need to download MyODBC: http://www.mysql.com/downloads/api-myodbc.html You can download either the stable or development release. There is also a FAQ that will answer your questions there about how to setup almost exactly what you are referring to. http://www.mysql.com/products/myodbc/faq_toc.html This FAQ is for the development release (3.51.03) but can also be used for the stable release (2.50.xx). I recently had to do the same thing with a Paradox database for a client, and have had relatively few issues following the documentation. After downloading and installing MyODBC you will be able to export the database directly to your Linux MySQL, however you will lose your table structures for the most part and will have to do some ALTER TABLE statements to put your keys back and the majority of your fields set to their proper type. HTH, Bryant Hester Juxtapose, inc. - -Original Message- From: Jonathan Coleman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 12:40 AM To: [EMAIL PROTECTED] Subject: MS Access and mySQL Hi. I have a situation where a church I am doing some volunteer work for has a MS Access (office 97) database running on NT. They are (woohoo) upgrading to a QUBE (linux box) for a server which has mySQL installed (and I can upgrade it etc..) My job therefore is to a) port MS Access data and queries to mySQL database b) use the MS Access forms to access the data and queries through ODBC. Is there anyone who can point me in the right direction, either to where the searchable discussion archives are, OR even better, someone who has gone through this before? Cheers Jon http://digital.yahoo.com.au - Yahoo! Digital How To - - Get the best out of your PC! - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -BEGIN PGP SIGNATURE- Version: PGPfreeware 7.0.3 for non-commercial use http://www.pgp.com iQA/AwUBPWzH6UlWu7/HFp4nEQJOGwCgr5af7wIi1AcbpP1rih/vABg/zb8An13w 4Tm8I6eugdNnVhLYZ+CcTYq2 =Z0ov -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 error in RH7.3
Two ideas: 1) Mysql is not running, so try: /etc/rc.d/init.d/mysqld start If you get an error, that it is already running, than you can be sure that it really is running. 2) When mysql is installed, than the root account is without password. Just log into your linux as root and run mysql. You do not need (maybe even must not) use -u root -p Just try it without it. Simply mysql. Jan Kovar -Original Message- From: Mertens Bram [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 9:12 AM To: [EMAIL PROTECTED] Subject: Re: mysql error in RH7.3 On Wed, 2002-08-28 at 03:35, nflorez wrote: I am trying to run Mysql for the first time and it fail. -- #mysql -u root -p Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) - I'm new to this list so I could be wrong, but it seems to me like your mysqld isn't running. Check which services are running and if mysqld isn't running start it and try again, that worked for me. (btw I made sure the daemon now starts every time I boot.) If you're running a gui: go to the control panel open the services dialog and simply check the correct box. HTH -- # Mertens Bram M8ram [EMAIL PROTECTED] Linux User #249103 # # Red Hat Linux 7.3 KDE 3.0.0-10 kernel 2.4.18-3 i686 128MB RAM # # A priest advised Voltaire on his death bed to renounce the devil. # # Replied Voltaire, This is no time to make new enemies. # - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
performance tunning 4.x
Are there any documents on how to performance tune mySQL 4.x? sean. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error during replication in mysql
Hello, I have implemented replication between 2 tables in MySQL since then, once in a while I see this error in the error log files Error reading packet from server: Lost connection to MySQL server during query (read_errno 134,server_errno=2013) Any ideas? Thanks.. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Where is mysql_server_init defined ?
Hi, I'm trying to figure out how to implement an embedded mySQL database in my application, but seems to have stumbled on something strange. The documentation and on the web everyone seems to refer to a method/function called 'mysql_server_init()' however, my compiler complained about that it does not exists, I then searched through all the files that comes with mysql normal install, and realized that there is no such method/function. What am I doing wrong, is there a particular package I would have to download in order to get it working or ... ? Regards Tobias Tobias Eriksson ComOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 e-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: performance tunning 4.x
Hello, Yes, there are lots of good documentation: First, the official MySQL Technical Reference, Section 5 at http://www.mysql.com/doc/en/index.html Then scroll down to 5 MySQL Optimisation and read those. Also, check this: http://www.devshed.com/Server_Side/MySQL/Optimize/page1.html It's a bit older, but still useful. And finally, use www.google.com. :-) Regards, Iikka On Wed, 28 Aug 2002, Sean Hager wrote: Are there any documents on how to performance tune mySQL 4.x? sean. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Strange behaviour of mysqld after dropping a column
Cams Ismael writes: Description: A time ago I reported next bug: The ALTER TABLE command behaves very strange when stopping and restarting the MySQL server afterwards. I noticed this after having rebooted my PC (which means that the MySql server is stopped and restarted). Before the reboot I dropped a column in one of my tables. After I had done this all the data was available in my table. However after have been rebooting my PC all the data was gone !!! It even becomes crazier. After the second reboot the data was visisble again. The tests I have executed showed that this problem shows up for both adding and deleting a column of a table. Also I noticed that when you add data after have beenstopping the MySQL server the first time this data is dissapeared after a second stop of the MySQL server. This problem should be solved in mysql-3.23.52. I have checked this and came to the conclusion the problem is indeed solved when adding a column, but after dropping a column the problem still exists !!! Kind regards, Ismaël Thank you for your test case. It helped us fix a bug in ALTER TABLE with BDB handler. Fix will come up in 3.23.53 and 4.0.4. This is a patch that fixes it: = sql/sql_table.cc 1.103 vs edited = *** /tmp/sql_table.cc-1.103-25819 Mon Aug 5 18:50:34 2002 --- edited/sql/sql_table.cc Wed Aug 28 15:10:52 2002 *** *** 1665,1675 VOID(pthread_cond_broadcast(COND_refresh)); goto err; } - #ifdef HAVE_BERKELEY_DB - extern bool berkeley_flush_logs(void); - if (old_db_type == DB_TYPE_BERKELEY_DB berkeley_flush_logs()) - goto err; - #endif thd-proc_info=end; mysql_update_log.write(thd, thd-query,thd-query_length); if (mysql_bin_log.is_open()) --- 1665,1670 *** *** 1679,1684 --- 1674,1687 } VOID(pthread_cond_broadcast(COND_refresh)); VOID(pthread_mutex_unlock(LOCK_open)); + #ifdef HAVE_BERKELEY_DB + extern bool berkeley_flush_logs(void); + if (old_db_type == DB_TYPE_BERKELEY_DB) + { + (void)berkeley_flush_logs(); + table=open_ltable(thd,table_list,TL_READ); + } + #endif end_temporary: sprintf(tmp_name,ER(ER_INSERT_INFO),(ulong) (copied+deleted), -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: synopsis of the problem (one line)
neal wrote: Does anyone have any preference regarding the use of Connector/J version 2+ or version 3? I am confused after reading the mySQL website as to whether some of the following features are new as of version 2 or version 3 of the driver: 1. 50-100% faster than previous version. Valid for version 3. Version 2 (2.0.14) is just a re-packaged version of MM.MySQL-2.0.14, so that once I (the driver author) joined MySQL, they had a stable version of the driver that was under their brand. 2. Supports prepared statement. Has been true for years...What are you referring to in the feature list that leads you to this conclusion? -Mark -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Info on 4.0.x release date
Okay, This is getting very nasty. There is no need for harsh words. Let's take a step back and look at the problem a bit differently. The story, as I understand it, is this; Will made a decision some time ago to develop applications on MySQL. Will based his decision at least partially on the fact that the developers at MySQL stated/estimated/guessed/hoped that they would have a stable version of MySQL 4.0 in January or February. It is now August and no stable version seems to be forthcoming. From this, I draw the following conclusions: - Will has a schedule he has to meet but he will not be able to unless he has a stable version of 4.0 - The MySQL team has found the last few outstanding problems in 4.0 very difficult to fix and so they can't say when a stable 4.0 will go out the door I think know what your problem is Will. You made your purchasing decision based on a beta version of the software. This is a big no no. MySQL AB is not the first company to miss the mark when it comes to a release date. Always, always, always make your decision based on the current version of the software. You can never know what may happen to completely derail another companies project or a feature. Now, to the boys with the goods. What's the hold up guys? Saying it will be stable when it's stable kind of sounds like go ask someone who cares. Getting a little visibility on the outstanding issues and exit conditions would give everyone the warm-fuzzies. Is there a specific Web page or email you can point us to? Looking forward to an answer from MySQL AB, John -Original Message- From: Dean Ellis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 2:15 AM To: [EMAIL PROTECTED] Subject: Re: Info on 4.0.x release date -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 27 August 2002 09:51 pm, Will French wrote: accepting this is part of growing up. And while I applaud the honesty of saying we won't declare it stable until it is stable, surely you can see your way clear that if you were explaining a similar situation to your boss or to your client, they would almost certainly (and justifyably) want you to give them more details. This is called accountability. Just curious: Are you a customer of or investor in MySQL AB? Have you actually purchased a license or support agreement from them? Or are you, like so many others, expecting to have everything precisely the way you want it, before you even realize that you want it, even though you are not paying a dime for it? Really. Just curious. Ironically, the fact that I pay no license fees to MySQL AB is based upon Ahhh, I see. So, you are _completely irrelevant_. You are fully entitled to your opinion. Yes, communication with regard to the 4.x series needs some improvement. Yes, they have taken considerably longer than they originally projected. But you are not a customer. You have no right to demand anything of them. They are not accountable to you in any way, shape or form. You get what you pay for. Accepting this is a part of growing up. Dean Ellis -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9bGprRU3T/K5ORe8RAuqrAJwLiBdMvZzRXY7ttCfyAzVUGJAEPQCfRml/ /KYoxBSm4mmMnAieLXFPH2s= =I7h3 -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: performance tunning 4.x
In the Ziff Daveis eWeek benchmark http://www.eweek.com/article/0,3658,s=708a=23115,00.asp )I noticed the following: MySQL's great performance was due mostly to our use of an in-memory query results cache that is new in MySQL 4.0.1. When we tested without this cache, MySQL's performance fell by two-thirds. I couldn't find any information in the online document on how to configure this in-memory query results chache. Can anyone point me to some information on how to do this? sean. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Iikka Meriläinen Sent: Wednesday, August 28, 2002 8:37 AM To: Sean Hager Cc: mySQL (E-mail) Subject: Re: performance tunning 4.x Hello, Yes, there are lots of good documentation: First, the official MySQL Technical Reference, Section 5 at http://www.mysql.com/doc/en/index.html Then scroll down to 5 MySQL Optimisation and read those. Also, check this: http://www.devshed.com/Server_Side/MySQL/Optimize/page1.html It's a bit older, but still useful. And finally, use www.google.com. :-) Regards, Iikka On Wed, 28 Aug 2002, Sean Hager wrote: Are there any documents on how to performance tune mySQL 4.x? sean. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Info on 4.0x release date
From: Joel Rees [EMAIL PROTECTED] To: Will French [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Info on 4.0.x release date Date: 28 Aug 2002 14:41:51 +0900 I know I'm not really involved here, but I would like to suggest a few things. Obviously you don't agree with me and that is something I readily accept. I do have difficulty with the fact that you clearly spent more time typing your response than considering my points, which were intended to be constructive. Well, as a bystander, I think you've shot a little wide. You got the truth. Would you prefer someone lie to you about it? I will assume that your interest in mysql and participation in this list indicates that you are somehow involved in the process of software development. What is less clear is whether this may be a hobby or your profession. If it is the latter, I would love to know where it is that one can work in this industry where one is not expected to make projections about when project milestones might be met. Microsoft? This is called project management. And while those of us who simply love writing code find such pursuits annoying, they are nonetheless necessary and worthwhile -- accepting this is part of growing up. _All_ the areas where we can reliably set schedules are areas where the profit margin is, well, something like the profit margin for manufacturing pencils. Unless you own the virtual monopoly, in which case you can fill in with fud. And while I applaud the honesty of saying we won't declare it stable until it is stable, surely you can see your way clear that if you were explaining a similar situation to your boss or to your client, they would almost certainly (and justifyably) want you to give them more details. This is called accountability. So they gave you all the details they could. That is being accountable. Or did you want to see the list of remaining issues, the assignment list for who gets to cover each, and so forth? What more information would be helpful, exactly? Do guesses really help? Guesses are nice... estimates are better. What is the difference, you ask? The word guess connotes random selection or selection based upon whimsy. Estimates, on the other hand, are approximations based upon some rational methodology. Whimsy, or the cognizance of the existance of more unknowns and their limits on manpower? Suppose you take your car into the shop and after looking at it they inform you that it cannot be driven again until a new part is installed and that part will need to be special ordered. Would you not expect them to give you an estimate of how long that will take? Following your logic, they would be justified in telling you that it will be here when it gets here. Perhaps you would feel better if they said something like the computer says they have plenty in stock and it usually takes 1-2 days for shipments to arrive. In the later, the parts manager cannot say with absolute certainty when the part will arrive. But short of that certainty, he has given you the next best thing - his best estimate based upon a methodology (based upon past history and his experience). Using the manufacturing analogy, what happens when the special order part is not being manufactured any more (because of, say, an earthquake), or has been recalled? But the analogy does not fit. These guys are cutting new ground. If we want to get a real fit on the analogy, we have to turn the clock back a hundred years. There are no factories that we can just order parts from. There are the big guys, but you're not asking for the Model T in black. (Otherwise, you'd have gone with Microsoft or Oracle, wouldn't you?) Since you didn't go to Microsoft or Oracle, we can only assume that you don't want the standard model. The folks at MySQL are developing something that apparently looks close to what you want, so you chose to go with them, based on their previous estimates. Well, they are designing it, inventing parts as they go, and rushing it to the factory floor as fast as they can. Except for one thing, they are trying to avoid the sort of situations that lead to recalls. And yes that means they uncover unknowns as they go, and most unknowns push the schedule back a bit. But that money isn't paid *to* MySQL AB, so how is that relevant? Which was a response to your assertions that the time and planning that you've put into the design based on the dev version of MySQL are real money, and the concept that since you've spent that money you are entitled to estimates, even though you have never bought a license. Not incidentally, did you ever consider that the small license fee might have been small enough to go ahead and pay it? This is where I think you've gone south. Usually, if you spec a product that is under development, you would want to back it with real
SQL - Update problem
Hi, how can I do sql command like this: update sekce set pocet = count(*) from odkaz where odkaz.sekce_id = sekce.id Thanks for answer j. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
JAMES KADEH mysql !
mysql , My dear, Good day, I wish to introduce myself to you. I am Lt. Col. James Kadeh, (rtd.). I am the personal assistant to President Laurent Kabila of Democratic Rep. of Congo. I got your contact information from your country's information directory over the internet during my desperate search for a reliable person that will assist me personally in moving some funds. Please I have not disclosed this to any other person, and if you cannot do it for me , do not disclose it to any other persons I humbly wish to notify you of my intention to use your name and address in the lifting out of the some of $18.6m currently deposited with a finance company here in South Africa to a finance security in Europe. This fund was deposited by me on behalf of President Laurent Kabila before he met his untimely death through a bloody assassination by one of his body guards at the height of the political crisis that swept through our country. This fund was meant for the purchase of arms and ammunition for defending his regime against the Rebel forces in dare need to over throw his regime. I was lucky to escape with copies of the documents covering the funds deposited with the security company to South Africa in other to save my dear life and that of my family. Presently, we are here without any reasonable source of livelihood. And there has not been any trace of this fund or its location up to date, since the new regime as I am solely in possession of the documents guiding it. This is actually what I want you to do for me: To help me clear and accommodate this fund when it gets to Europe's To assist me in managing this fund in good and profitable venture in your country , where I will also come and settle down. I highly hoped that my request will be granted and viewed with favor. Please I anticipate your urgent response to this very request and also emphasize that you keep every bit of this transaction strictly to yourself alone, bearing in mind its nature and the confidentiality it requires. Thank you. Best Regards, Lt. Col. James Kadeh (rtd.). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: SQL - Update problem
you cant update from is NOT supported -Original Message- From: Jakub Mach [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 9:15 AM To: Mysql Subject: SQL - Update problem Hi, how can I do sql command like this: update sekce set pocet = count(*) from odkaz where odkaz.sekce_id = sekce.id Thanks for answer j. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MS Access and mySQL
I have been there done that with old access data, but no forms. Your plans should be focused around what you know and what your systems are tied to. Since its an NT box you could go with pretty much any language ie java/vb/c++. VB would be the obvious choice for ease of transfering the Access VBA forms to straight VB. The only thing you have to be careful is the access querys. A lot of them will not work on MySQL and the funny thing is a lot of them will not work on M$'s on SQL server :) go figure. As far as the data goes the easist thing I found to transfer it into mysql is a program called dbtools. You can find it at: http://www.dbtools.com.br/EN/ It's fairly easy to use and has a great import wizard. If you have an specific questions let me know and I'll try my best to answer them. -Nick MySQL Newsgroup (@Basebeans.com) wrote: Subject: MS Access and mySQL From: =?iso-8859-1?q?Jonathan=20Coleman?= [EMAIL PROTECTED] === Hi. I have a situation where a church I am doing some volunteer work for has a MS Access (office 97) database running on NT. They are (woohoo) upgrading to a QUBE (linux box) for a server which has mySQL installed (and I can upgrade it etc..) My job therefore is to a) port MS Access data and queries to mySQL database b) use the MS Access forms to access the data and queries through ODBC. Is there anyone who can point me in the right direction, either to where the searchable discussion archives are, OR even better, someone who has gone through this before? Cheers Jon http://digital.yahoo.com.au - Yahoo! Digital How To - Get the best out of your PC! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[BUG] Table corrupted by specific sequence (4.0.3-beta)
Description: The following sequence corrupts the table with MySQL 4.0.3-beta. It works fine with 3.23.51. LOCK TABLES t WRITE; DELETE FROM t; OPTIMIZE TABLE t; How to reproduce: - mysql SELECT version(); ++ | version() | ++ | 4.0.3-beta | ++ 1 row in set (0.00 sec) mysql CREATE TABLE t (a INT); Query OK, 0 rows affected (0.00 sec) mysql INSERT t VALUES (1), (2), (3); Query OK, 3 rows affected (0.00 sec) Records: 3 Duplicates: 0 Warnings: 0 mysql LOCK TABLES t WRITE; Query OK, 0 rows affected (0.00 sec) mysql DELETE FROM t; Query OK, 3 rows affected (0.00 sec) mysql OPTIMIZE TABLE t; ++--+--++ | Table | Op | Msg_type | Msg_text | ++--+--++ | test.t | optimize | warning | Number of rows changed from 0 to 3 | | test.t | optimize | status | OK | ++--+--++ 2 rows in set (0.00 sec) mysql SELECT * FROM t; ERROR 1030: Got error 127 from table handler mysql CHECK TABLE t; ++---+--+--+ | Table | Op| Msg_type | Msg_text | ++---+--+--+ | test.t | check | error| Size of datafile is: 0 Should be: 15 | | test.t | check | error| Corrupt | ++---+--+--+ 2 rows in set (0.00 sec) Environment: System: Linux ***.fr 2.4.19 #3 SMP Fri Aug 9 15:18:06 CEST 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/ccGCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.3 2.96-110) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Jul 18 13:18 /lib/libc.so.6 - libc-2.2.5.so -rwxr-xr-x1 root root 1260480 Apr 15 15:44 /lib/libc-2.2.5.so -rw-r--r--1 root root 2310808 Apr 15 16:02 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 15 15:55 /usr/lib/libc.so Configure command: ./configure --with-innodb --localstatedir=/data/mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: JAMES KADEH mysql !
wow...do you think this is real.we could all be rich!...:-P - Original Message - From: James Kadeh [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 28, 2002 3:34 PM Subject: JAMES KADEH mysql ! mysql , My dear, Good day, I wish to introduce myself to you. I am Lt. Col. James Kadeh, (rtd.).I am the personal assistant to President Laurent Kabila of Democratic Rep. of Congo. I got your contact information from your country's information directory over the internet during my desperate search for a reliable person that will assist me personally in moving some funds. Please I have not disclosed this to any other person, and if you cannot do it for me , do not disclose it to any other persons I humbly wish to notify you of my intention to use your name and address in the lifting out of the some of $18.6m currently deposited with a finance company here in South Africa to a finance security in Europe. This fund was deposited by me on behalf of President Laurent Kabila before he met his untimely death through a bloody assassination by one of his body guards at the height of the political crisis that swept through our country. This fund was meant for the purchase of arms and ammunition for defending his regime against the Rebel forces in dare need to over throw his regime. I was lucky to escape with copies of the documents covering the funds deposited with the security company to South Africa in other to save my dear life and that of my family. Presently, we are here without any reasonable source of livelihood. And there has not been any trace of this fund or its location up to date, since the new regime as I am solely in possession of the documents guiding it. This is actually what I want you to do for me: To help me clear and accommodate this fund when it gets to Europe's To assist me in managing this fund in good and profitable venture in your country , where I will also come and settle down. I highly hoped that my request will be granted and viewed with favor. Please I anticipate your urgent response to this very request and also emphasize that you keep every bit of this transaction strictly to yourself alone, bearing in mind its nature and the confidentiality it requires. Thank you. Best Regards, Lt. Col. James Kadeh (rtd.). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: performance tunning 4.x
On Wed, 28 Aug 2002, Sean Hager wrote: In the Ziff Daveis eWeek benchmark http://www.eweek.com/article/0,3658,s=708a=23115,00.asp )I noticed the following: MySQL's great performance was due mostly to our use of an in-memory query results cache that is new in MySQL 4.0.1. When we tested without this cache, MySQL's performance fell by two-thirds. I couldn't find any information in the online document on how to configure this in-memory query results chache. Can anyone point me to some information on how to do this? Hi, Start by looking at the MySQL documentation: http://www.mysql.com/doc/en/Query_Cache.html Read the entire 6.9 section. It offers quite a bit of information on how the cache operates, how you should configure it and so on. Regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: load data into table from file or how to set the local-infile=1
Mertens, Wednesday, August 28, 2002, 10:54:12 AM, you wrote: MB I was following the example in the manual (the menagerie database) but I MB can not load a file into the table, i get the following error: MB mysql LOAD DATA LOCAL INFILE ~/testmysql/pet.txt INTO TABLE pet; MB ERROR 1148: The used command is not allowed with this MySQL version MB I searched the archives and found that a variable local-infile=1 must MB be set for the client, but I can not find how to do that. MB Can somebody help me with this please? MB I'm using mysql version 3.23.49 on a Red Hat Linux 7.3. Put into my.cnf file : [mysql] local-infile=1 or start mysql client with --local-infile=1 option. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error during replication in mysql
Vaso, Wednesday, August 28, 2002, 4:09:56 PM, you wrote: VK I have implemented replication between 2 tables in MySQL since then, VK once in a while VK I see this error in the error log files VK Error reading packet from server: Lost connection to MySQL server VK during query (read_errno 134,server_errno=2013) VK Any ideas? Check your tables with CHECK TABLE statement or myisamchk. $ perror 134 Error code 134: Unknown error 134 134 = Record was already deleted (or record file crashed) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: granting grant option creates user ?!
Markus, Wednesday, August 28, 2002, 3:48:42 PM, you wrote: MR we are using mysql 3.23... for our webservices.=20 MR the following question about grant: MR granting grant option to a user has the consequence, that this user can grant to other users - even if this other user doesn't exist!! MR e.g. grant grant option on db.* to somene; It's a wrong syntax. You should use GRANT .. WITH GRANT OPTION; MR creates a user somene - with no password. MySQL creates new user when in the table 'user' there is no existing user with the same user name and host name. New user doesn't have a password because you don't specify a password in the GRANT statement. MR but what strikes me most is - it can create a user!!! Yes, if the user has UPDATE privilege on the database 'mysql'. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL/InnoDB-4.0.3 is released
Harald, thank you for reminding. I forgot to add this to the changelog of InnoDB-3.23.52: a.. Aligned some buffers used in reading and writing to data files. This allows using unbuffered raw devices as data files in Linux. I am grateful if someone has time to test this. Regards, Heikki Harald Fuchs writes: In article 007401c24e65$83a49520$a1f6d5d4@omnibook, Heikki Tuuri [EMAIL PROTECTED] writes: Full changelogs are shown below. Compared to 4.0.2, also all the changes of 3.23.52 are included in 4.0.3. [ Lots of good stuff deleted ] Heikki, I think there's something missing in the changelog. About a month ago, someone named Christian Jaeger from ETH Zurich asked about unbuffered raw device support for Linux. You replied immediately with two sets of patches for 3.23.x (regaring unaligned access) which apparently fixed the problems, for Mr. Jaeger at least. When I tried to apply those patches to 4.0.2, I still got operating system error #22. Thus I decided to wait for 4.0.3. So I'd like to know about the status of these patches. [ Filter fodder: 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: MS Access and mySQL
the join syntax is what is differnt between Access and MYSQL. in MS-SQL = indexs will be used on tables mentioned in the JOIN clause and they will not in MYSQL -Original Message- From: Nicholas Stuart [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 9:40 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: MS Access and mySQL I have been there done that with old access data, but no forms. Your plans should be focused around what you know and what your systems are tied to. Since its an NT box you could go with pretty much any language ie java/vb/c++. VB would be the obvious choice for ease of transfering the Access VBA forms to straight VB. The only thing you have to be careful is the access querys. A lot of them will not work on MySQL and the funny thing is a lot of them will not work on M$'s on SQL server :) go figure. As far as the data goes the easist thing I found to transfer it into mysql is a program called dbtools. You can find it at: http://www.dbtools.com.br/EN/ It's fairly easy to use and has a great import wizard. If you have an specific questions let me know and I'll try my best to answer them. -Nick MySQL Newsgroup (@Basebeans.com) wrote: Subject: MS Access and mySQL From: =?iso-8859-1?q?Jonathan=20Coleman?= [EMAIL PROTECTED] === Hi. I have a situation where a church I am doing some volunteer work for has a MS Access (office 97) database running on NT. They are (woohoo) upgrading to a QUBE (linux box) for a server which has mySQL installed (and I can upgrade it etc..) My job therefore is to a) port MS Access data and queries to mySQL database b) use the MS Access forms to access the data and queries through ODBC. Is there anyone who can point me in the right direction, either to where the searchable discussion archives are, OR even better, someone who has gone through this before? Cheers Jon http://digital.yahoo.com.au - Yahoo! Digital How To - Get the best out of your PC! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: JAMES KADEH mysql !
I reported him already... to [EMAIL PROTECTED] [EMAIL PROTECTED] and several others.. also wrote back and asked if he thought I was a complete idiot... -Original Message- From: John Wards [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 9:49 AM To: [EMAIL PROTECTED] Subject: Re: JAMES KADEH mysql ! wow...do you think this is real.we could all be rich!...:-P - Original Message - From: James Kadeh [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 28, 2002 3:34 PM Subject: JAMES KADEH mysql ! mysql , My dear, Good day, I wish to introduce myself to you. I am Lt. Col. James Kadeh, (rtd.).I am the personal assistant to President Laurent Kabila of Democratic Rep. of Congo. I got your contact information from your country's information directory over the internet during my desperate search for a reliable person that will assist me personally in moving some funds. Please I have not disclosed this to any other person, and if you cannot do it for me , do not disclose it to any other persons I humbly wish to notify you of my intention to use your name and address in the lifting out of the some of $18.6m currently deposited with a finance company here in South Africa to a finance security in Europe. This fund was deposited by me on behalf of President Laurent Kabila before he met his untimely death through a bloody assassination by one of his body guards at the height of the political crisis that swept through our country. This fund was meant for the purchase of arms and ammunition for defending his regime against the Rebel forces in dare need to over throw his regime. I was lucky to escape with copies of the documents covering the funds deposited with the security company to South Africa in other to save my dear life and that of my family. Presently, we are here without any reasonable source of livelihood. And there has not been any trace of this fund or its location up to date, since the new regime as I am solely in possession of the documents guiding it. This is actually what I want you to do for me: To help me clear and accommodate this fund when it gets to Europe's To assist me in managing this fund in good and profitable venture in your country , where I will also come and settle down. I highly hoped that my request will be granted and viewed with favor. Please I anticipate your urgent response to this very request and also emphasize that you keep every bit of this transaction strictly to yourself alone, bearing in mind its nature and the confidentiality it requires. Thank you. Best Regards, Lt. Col. James Kadeh (rtd.). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL/InnoDB-4.0.3 is released
In the last episode (Aug 28), Harald Fuchs said: I think there's something missing in the changelog. About a month ago, someone named Christian Jaeger from ETH Zurich asked about unbuffered raw device support for Linux. You replied immediately with two sets of patches for 3.23.x (regaring unaligned access) which apparently fixed the problems, for Mr. Jaeger at least. When I tried to apply those patches to 4.0.2, I still got operating system error #22. Thus I decided to wait for 4.0.3. On a similar topic, many OSes support Direct I/O on files, which causes reads and writes to bypass the system's buffer cache. It's usually enabled by adding the O_DIRECT (or O_DIRECTIO) flag to your open() call. From a quick Google search, FreeBSD and IRIX use O_DIRECT, Tru64 uses O_DIRECTIO, and Solaris has you call a directio() function on the file descriptor after you open the file. Adding this should really help performance on large InnoDB tablespaces, and keeps you from having to fall back to raw partitions for unbuffered IO, which are a pain to manage. -- Dan Sql Query Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[select into] RE: SQL - Update problem
Hmm .. isn't there any workaround for this .. Maybe something like: select count(*) into :somerVar FROM table; update sekce set pocet = :someVar WHERE ... blabla; I've seen things like this in other databas servers but haven't been able to find out if it's supported by MySQL, and if so, how... Thanks, Wouter -Oorspronkelijk bericht- Van: Mary Stickney [mailto:[EMAIL PROTECTED]] Verzonden: August 28, 2002 16:37 Aan: Jakub Mach; Mysql Onderwerp: RE: SQL - Update problem you cant update from is NOT supported -Original Message- From: Jakub Mach [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 9:15 AM To: Mysql Subject: SQL - Update problem Hi, how can I do sql command like this: update sekce set pocet = count(*) from odkaz where odkaz.sekce_id = sekce.id Thanks for answer j. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MS Access and mySQL
That and Access also uses sub-selects and some other mutlitable features that MySQL does not yet implement. Aslo, most of the internal functions are different as well such as: To get only the top row of a query in Access you use SELECT TOP 1 blah blah, but in MySQL you use SELECT blah blah LIMIT 1 All it means is you may have rewrite your queries. For the most part there are no queries in Access that you can't do in MySQL. It will just take some time to convert the queries is all. -Nick Mary Stickney wrote: the join syntax is what is differnt between Access and MYSQL. in MS-SQL = indexs will be used on tables mentioned in the JOIN clause and they will not in MYSQL -Original Message- From: Nicholas Stuart [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 9:40 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: MS Access and mySQL I have been there done that with old access data, but no forms. Your plans should be focused around what you know and what your systems are tied to. Since its an NT box you could go with pretty much any language ie java/vb/c++. VB would be the obvious choice for ease of transfering the Access VBA forms to straight VB. The only thing you have to be careful is the access querys. A lot of them will not work on MySQL and the funny thing is a lot of them will not work on M$'s on SQL server :) go figure. As far as the data goes the easist thing I found to transfer it into mysql is a program called dbtools. You can find it at: http://www.dbtools.com.br/EN/ It's fairly easy to use and has a great import wizard. If you have an specific questions let me know and I'll try my best to answer them. -Nick MySQL Newsgroup (@Basebeans.com) wrote: Subject: MS Access and mySQL From: =?iso-8859-1?q?Jonathan=20Coleman?= [EMAIL PROTECTED] === Hi. I have a situation where a church I am doing some volunteer work for has a MS Access (office 97) database running on NT. They are (woohoo) upgrading to a QUBE (linux box) for a server which has mySQL installed (and I can upgrade it etc..) My job therefore is to a) port MS Access data and queries to mySQL database b) use the MS Access forms to access the data and queries through ODBC. Is there anyone who can point me in the right direction, either to where the searchable discussion archives are, OR even better, someone who has gone through this before? Cheers Jon http://digital.yahoo.com.au - Yahoo! Digital How To - Get the best out of your PC! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL - Update problem
Jakub, Wednesday, August 28, 2002, 5:15:01 PM, you wrote: JM how can I do sql command like this: JM update sekce set pocet = count(*) from odkaz where odkaz.sekce_id = sekce.id First: multi-table updates is supported only since 4.0.2 Second: even on 4.0.2 you can't do it with above query -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MS Access and mySQL
I would strongly urg you not to use Access as the front end. The biggest problem is that the Jet Engine/Access backend is pretty much completly different then MySQL and you will run into problems with table structure and the like. Also, using access as the front end has been extremly slow when ever I tried it. You will however need to download the MyODBC driver if you wish to access MySQL through VB. -Nick -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jonathan, If you are going to be completely converting the Access db to MySQL, and just using Access as the frontend, you will need to download MyODBC: http://www.mysql.com/downloads/api-myodbc.html You can download either the stable or development release. There is also a FAQ that will answer your questions there about how to setup almost exactly what you are referring to. http://www.mysql.com/products/myodbc/faq_toc.html This FAQ is for the development release (3.51.03) but can also be used for the stable release (2.50.xx). I recently had to do the same thing with a Paradox database for a client, and have had relatively few issues following the documentation. After downloading and installing MyODBC you will be able to export the database directly to your Linux MySQL, however you will lose your table structures for the most part and will have to do some ALTER TABLE statements to put your keys back and the majority of your fields set to their proper type. HTH, Bryant Hester Juxtapose, inc. - -Original Message- From: Jonathan Coleman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 12:40 AM To: [EMAIL PROTECTED] Subject: MS Access and mySQL Hi. I have a situation where a church I am doing some volunteer work for has a MS Access (office 97) database running on NT. They are (woohoo) upgrading to a QUBE (linux box) for a server which has mySQL installed (and I can upgrade it etc..) My job therefore is to a) port MS Access data and queries to mySQL database b) use the MS Access forms to access the data and queries through ODBC. Is there anyone who can point me in the right direction, either to where the searchable discussion archives are, OR even better, someone who has gone through this before? Cheers Jon http://digital.yahoo.com.au - Yahoo! Digital How To - - Get the best out of your PC! - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -BEGIN PGP SIGNATURE- Version: PGPfreeware 7.0.3 for non-commercial use http://www.pgp.com iQA/AwUBPWzH6UlWu7/HFp4nEQJOGwCgr5af7wIi1AcbpP1rih/vABg/zb8An13w 4Tm8I6eugdNnVhLYZ+CcTYq2 =Z0ov -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
incorrect ordering of tables in mysqldump
Description: innodb table types introduce dependancies on one table by another. Thus the order of table loading is important. If a table is loaded before one it depends on an error is triggered. mysqldump will dump tables in the wrong order, it seems to dump tables sorted alphabetically. How-To-Repeat: create some tables that depend on one another such that the those that depend on others come before them in the alphabet. Fix: either constrian the names so that they are ordered correctly or edit the output in a text editor to put the tables in the correct order Submitter-Id: [EMAIL PROTECTED] Originator:Matthew Carey Organization: System Simulation Ltd MySQL support: none Synopsis: incorrect ordering of tables in mysqldump Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.52 (Official MySQL RPM) Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.52, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.52-Max-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 3 hours 33 min 10 sec Threads: 1 Questions: 12820 Slow queries: 0 Opens: 76 Flush tables: 1 Open tables: 10 Queries per second avg: 1.002 Environment: System: Linux demo.ssl.co.uk 2.4.7-10 #1 Thu Sep 6 16:46:36 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Jul 16 15:44 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x2 root root 5734740 Apr 2 17:44 /lib/libc-2.2.4.so -rw-r--r--1 root root 27332668 Apr 2 17:42 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 2 17:42 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --with-other-libc=/usr/local/mysql-glibc --without-berkeley-db --without-innodb --enable-assembler --enable-local-infile --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/share/info --includedir=/usr/include --mandir=/usr/share/man '--with-comment=Official MySQL RPM' CC=gcc 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' CXX=gcc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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/InnoDB-4.0.3 is released
Dan, - Original Message - From: Dan Nelson [EMAIL PROTECTED] To: Harald Fuchs [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, August 28, 2002 6:10 PM Subject: Re: MySQL/InnoDB-4.0.3 is released In the last episode (Aug 28), Harald Fuchs said: I think there's something missing in the changelog. About a month ago, someone named Christian Jaeger from ETH Zurich asked about unbuffered raw device support for Linux. You replied immediately with two sets of patches for 3.23.x (regaring unaligned access) which apparently fixed the problems, for Mr. Jaeger at least. When I tried to apply those patches to 4.0.2, I still got operating system error #22. Thus I decided to wait for 4.0.3. On a similar topic, many OSes support Direct I/O on files, which causes reads and writes to bypass the system's buffer cache. It's usually enabled by adding the O_DIRECT (or O_DIRECTIO) flag to your open() call. From a quick Google search, FreeBSD and IRIX use O_DIRECT, Tru64 uses O_DIRECTIO, and Solaris has you call a directio() function on the file descriptor after you open the file. this may come some time in future. It is just a small change to innodb_flush_method in my.cnf. I am cautious to use O_DIRECT on Unixes. There is evidence that fdatasync() corrupted files both in Linux and Solaris. That is why also the InnoDB flush method O_DSYNC is currently internally mapped to normal O_SYNC. Thus the problem in these nonstandard file i/o methods is that they often seem to be buggy. But giving users the option to test these would be good. Adding this should really help performance on large InnoDB tablespaces, and keeps you from having to fall back to raw partitions for unbuffered IO, which are a pain to manage. -- Dan Sql Query Nelson [EMAIL PROTECTED] Best regards, Heikki - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: SQL - Update problem
Hi, ...adding a new query and using variable: SET @a:=0; --initialize variable a; select @:=COUNT(*) from odkaz where odkaz.sekce_id = sekce.id; update sekce set pocet = @a where odkaz.sekce_id = sekce.id; Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jakub Mach [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Wednesday, August 28, 2002 5:15 PM Subject: SQL - Update problem Hi, how can I do sql command like this: update sekce set pocet = count(*) from odkaz where odkaz.sekce_id = sekce.id Thanks for answer j. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Where is mysql_server_init defined ?
Hi, From what i know , embedded MySQL is implemented begin with version 4.0.x. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Tobias Eriksson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 28, 2002 4:15 PM Subject: Where is mysql_server_init defined ? Hi, I'm trying to figure out how to implement an embedded mySQL database in my application, but seems to have stumbled on something strange. The documentation and on the web everyone seems to refer to a method/function called 'mysql_server_init()' however, my compiler complained about that it does not exists, I then searched through all the files that comes with mysql normal install, and realized that there is no such method/function. What am I doing wrong, is there a particular package I would have to download in order to get it working or ... ? Regards Tobias Tobias Eriksson ComOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 e-mail: [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
First thoughts on mysql-4.0.3
Hi, after upgrading, I had two problems: /usr/local/mysql/bin/mysqld: ERROR: unknown variable 'query_buffer_size=32M' I had to comment out this variable, it seems it got renamed. I have to figure out what's the new name. 020828 17:30:12 mysqld started 020828 17:30:12 Can't find messagefile 'mysql-4.0.3-beta-pc-linux-gnu-i686/share/mysql/english/errmsg.sys' 020828 17:30:12 Aborting 020828 17:30:12 mysqld ended This I've already posted once. My fix is: # cd /usr/local/mysql(/usr/local/mysql is a link to /usr/local/mysql-4.0.3-beta-pc-linux-gnu-i686) # ln -s . mysql-4.0.3-beta-pc-linux-gnu-i686 # /etc/rc3.d/S98mysql start Hope this helps -- Martin Mokrejs [EMAIL PROTECTED], [EMAIL PROTECTED] PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs MIPS / Institute for Bioinformatics http://mips.gsf.de GSF - National Research Center for Environment and Health Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany tel.: +49-89-3187 3683 , fax:+49-89-3187 3585 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: synopsis of the problem (one line)
Can connector/J coexist with mm.mysql on the same tomcat? I'd like to upgrade one site at a time rather than then all the sites at once. On Wed, 28 Aug 2002, Mark Matthews wrote: Date: Wed, 28 Aug 2002 08:59:33 -0500 From: Mark Matthews [EMAIL PROTECTED] To: neal [EMAIL PROTECTED] Cc: mySQL [EMAIL PROTECTED] Subject: Re: synopsis of the problem (one line) neal wrote: Does anyone have any preference regarding the use of Connector/J version 2+ or version 3? I am confused after reading the mySQL website as to whether some of the following features are new as of version 2 or version 3 of the driver: 1. 50-100% faster than previous version. Valid for version 3. Version 2 (2.0.14) is just a re-packaged version of MM.MySQL-2.0.14, so that once I (the driver author) joined MySQL, they had a stable version of the driver that was under their brand. 2. Supports prepared statement. Has been true for years...What are you referring to in the feature list that leads you to this conclusion? -Mark -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Info on 4.0x release date
Other companies require you to sign up for a Beta program before you can even look at it. The public doesn't even hear about it until the Beta is through, and the product is ready. You probably will never know how long the Beta cycle lasted. You are privileded to be given such early access to Beta and Alpha code. rm wrote: From: Joel Rees [EMAIL PROTECTED] To: Will French [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: Info on 4.0.x release date Date: 28 Aug 2002 14:41:51 +0900 I know I'm not really involved here, but I would like to suggest a few things. Obviously you don't agree with me and that is something I readily accept. I do have difficulty with the fact that you clearly spent more time typing your response than considering my points, which were intended to be constructive. Well, as a bystander, I think you've shot a little wide. You got the truth. Would you prefer someone lie to you about it? I will assume that your interest in mysql and participation in this list indicates that you are somehow involved in the process of software development. What is less clear is whether this may be a hobby or your profession. If it is the latter, I would love to know where it is that one can work in this industry where one is not expected to make projections about when project milestones might be met. Microsoft? This is called project management. And while those of us who simply love writing code find such pursuits annoying, they are nonetheless necessary and worthwhile -- accepting this is part of growing up. _All_ the areas where we can reliably set schedules are areas where the profit margin is, well, something like the profit margin for manufacturing pencils. Unless you own the virtual monopoly, in which case you can fill in with fud. And while I applaud the honesty of saying we won't declare it stable until it is stable, surely you can see your way clear that if you were explaining a similar situation to your boss or to your client, they would almost certainly (and justifyably) want you to give them more details. This is called accountability. So they gave you all the details they could. That is being accountable. Or did you want to see the list of remaining issues, the assignment list for who gets to cover each, and so forth? What more information would be helpful, exactly? Do guesses really help? Guesses are nice... estimates are better. What is the difference, you ask? The word guess connotes random selection or selection based upon whimsy. Estimates, on the other hand, are approximations based upon some rational methodology. Whimsy, or the cognizance of the existance of more unknowns and their limits on manpower? Suppose you take your car into the shop and after looking at it they inform you that it cannot be driven again until a new part is installed and that part will need to be special ordered. Would you not expect them to give you an estimate of how long that will take? Following your logic, they would be justified in telling you that it will be here when it gets here. Perhaps you would feel better if they said something like the computer says they have plenty in stock and it usually takes 1-2 days for shipments to arrive. In the later, the parts manager cannot say with absolute certainty when the part will arrive. But short of that certainty, he has given you the next best thing - his best estimate based upon a methodology (based upon past history and his experience). Using the manufacturing analogy, what happens when the special order part is not being manufactured any more (because of, say, an earthquake), or has been recalled? But the analogy does not fit. These guys are cutting new ground. If we want to get a real fit on the analogy, we have to turn the clock back a hundred years. There are no factories that we can just order parts from. There are the big guys, but you're not asking for the Model T in black. (Otherwise, you'd have gone with Microsoft or Oracle, wouldn't you?) Since you didn't go to Microsoft or Oracle, we can only assume that you don't want the standard model. The folks at MySQL are developing something that apparently looks close to what you want, so you chose to go with them, based on their previous estimates. Well, they are designing it, inventing parts as they go, and rushing it to the factory floor as fast as they can. Except for one thing, they are trying to avoid the sort of situations that lead to recalls. And yes that means they uncover unknowns as they go, and most unknowns push the schedule back a bit. But that money isn't paid *to* MySQL AB, so how is that relevant? Which was a response to your assertions that the time and planning that you've put into the design based on the dev version of MySQL are real money, and the concept that since you've spent that money you are entitled to estimates, even though you have never bought a license. Not incidentally, did you ever consider that the small license fee might have
Re: load data into table from file or how to set the local-infile=1
On Wed, 2002-08-28 at 16:51, Egor Egorov wrote: Put into my.cnf file : [mysql] local-infile=1 or start mysql client with --local-infile=1 option. I tried the first option and it works when use the following command to load the data-file: mysql LOAD DATA LOCAL INFILE '/home/M8ram/testmysql/pet.txt' INTO TABLE pet; Query OK, 3 rows affected (0.19 sec) Records: 3 Deleted: 0 Skipped: 0 Warnings: 0 But when I use the above command without the LOCAL option it displays the following error: mysql LOAD DATA INFILE '/home/M8ram/testmysql/pet.txt' INTO TABLE pet; ERROR 1045: Access denied for user: 'M8ram@localhost' (Using password: NO) Is this 'normal behaviour'? About the second suggestion: where should this file be located? Is it possible that it does not exist yet? If so can I create a file named my.cnf with a text-editor (like KWrite) and put it in my home directory? Thanks for the help! -- # Mertens Bram M8ram [EMAIL PROTECTED] Linux User #249103 # # Red Hat Linux 7.3 KDE 3.0.0-10 kernel 2.4.18-3 i686 128MB RAM # # A priest advised Voltaire on his death bed to renounce the devil. # # Replied Voltaire, This is no time to make new enemies. # - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: synopsis of the problem (one line)
William R. Mussatto wrote: Can connector/J coexist with mm.mysql on the same tomcat? I'd like to upgrade one site at a time rather than then all the sites at once. No, because there are classname clashes. If you remove the org subdirectory from the .jar file, it might work okay. -Mark -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to repeat.
burger17, Tuesday, August 27, 2002, 7:07:45 PM, you wrote: b In dos-prompt, I type at c:\mysql\binmysql for testing to see if mysql is b connected successful but b the error is : Error 2003: Can't connect to MySQL server on 'localhost' b 10061 b How to solve this problem? b Hope to hear from you soon. Check if your MySQL server is running. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MS Access and mySQL
Mary Stickney wrote: the join syntax is what is differnt between Access and MYSQL. in MS-SQL = indexs will be used on tables mentioned in the JOIN clause and they will not in MYSQL This is not true. MySQL uses indexes in joins, if you've put them in the right columns, just as in MS-SQL. What gives you the idea that it doesn't? -Mark -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: JAMES KADEH mysql !
also wrote back and asked if he thought I was a complete idiot... Unfortunately, you may be. Now he has your e-mail address. As my father always sez, smooth move Ex-Lax -Original Message- From: Mary Stickney [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 10:12 AM To: John Wards; [EMAIL PROTECTED] Subject: RE: JAMES KADEH mysql ! I reported him already... to [EMAIL PROTECTED] [EMAIL PROTECTED] and several others.. also wrote back and asked if he thought I was a complete idiot... -Original Message- From: John Wards [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 9:49 AM To: [EMAIL PROTECTED] Subject: Re: JAMES KADEH mysql ! wow...do you think this is real.we could all be rich!...:-P - Original Message - From: James Kadeh [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 28, 2002 3:34 PM Subject: JAMES KADEH mysql ! mysql , My dear, Good day, I wish to introduce myself to you. I am Lt. Col. James Kadeh, (rtd.).I am the personal assistant to President Laurent Kabila of Democratic Rep. of Congo. I got your contact information from your country's information directory over the internet during my desperate search for a reliable person that will assist me personally in moving some funds. Please I have not disclosed this to any other person, and if you cannot do it for me , do not disclose it to any other persons I humbly wish to notify you of my intention to use your name and address in the lifting out of the some of $18.6m currently deposited with a finance company here in South Africa to a finance security in Europe. This fund was deposited by me on behalf of President Laurent Kabila before he met his untimely death through a bloody assassination by one of his body guards at the height of the political crisis that swept through our country. This fund was meant for the purchase of arms and ammunition for defending his regime against the Rebel forces in dare need to over throw his regime. I was lucky to escape with copies of the documents covering the funds deposited with the security company to South Africa in other to save my dear life and that of my family. Presently, we are here without any reasonable source of livelihood. And there has not been any trace of this fund or its location up to date, since the new regime as I am solely in possession of the documents guiding it. This is actually what I want you to do for me: To help me clear and accommodate this fund when it gets to Europe's To assist me in managing this fund in good and profitable venture in your country , where I will also come and settle down. I highly hoped that my request will be granted and viewed with favor. Please I anticipate your urgent response to this very request and also emphasize that you keep every bit of this transaction strictly to yourself alone, bearing in mind its nature and the confidentiality it requires. Thank you. Best Regards, Lt. Col. James Kadeh (rtd.). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[BUG] Table corrupted by specific sequence (4.0.3-beta)
Hi, I can confirm this on Linux i386 with official binaries on MyISAM tables: mysql check table blast; DELETE FROM ++---+--+--+ | Table | Op| Msg_type | Msg_text | ++---+--+--+ | test_mmo.blast | check | status | OK | ++---+--+--+ 1 row in set (3.40 sec) mysql LOCK TABLES blast write; Query OK, 0 rows affected (0.00 sec) mysql DELETE FROM blast; Query OK, 69549 rows affected (0.10 sec) mysql select count(*) from blast; +--+ | count(*) | +--+ |0 | +--+ 1 row in set (0.04 sec) mysql OPTIMIZE TABLE blast; ++--+--++ | Table | Op | Msg_type | Msg_text | ++--+--++ | test_mmo.blast | optimize | warning | Number of rows changed from 0 to 69549 | | test_mmo.blast | optimize | status | OK | ++--+--++ 2 rows in set (0.03 sec) mysql select count(*) from blast; +--+ | count(*) | +--+ |0 | +--+ 1 row in set (0.00 sec) mysql check table blast; ++---+--+---+ | Table | Op| Msg_type | Msg_text | ++---+--+---+ | test_mmo.blast | check | error| Size of indexfile is: 1024 Should be: 10120192 | | test_mmo.blast | check | error| Size of datafile is: 0 Should be: 92046876| | test_mmo.blast | check | error| Corrupt | ++---+--+---+ 3 rows in set (0.00 sec) Martin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MS Access and mySQL
Or you could just use the libmySQL.dll and handle everything yourself through VB. You will however need to download the MyODBC driver if you wish to access MySQL through VB. -Nick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 password ( )
I have used the mysql password(\$pass \) function in the past to encrypt passwords into the db. but can not decrypt them if needed. I know this is not something new. Is there a better way to protect passwords in the db and then decrypt them if needed ? Thanks Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: SQL - Update problem
Hi, Egor has right and i didn't read very carefully you e-mail.Sorry You can try this : SET @a:=0; SET @b:=0; SELECT @a:=COUNT(*),@b:=sekce.id FROM odkaz,sekce WHERE odkaz.sekce_id = sekce.id; UPDATE sekce SET pocet = @a WHERE id= @b; Now...i think it's corect... Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Jakub Mach [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Wednesday, August 28, 2002 5:15 PM Subject: SQL - Update problem Hi, how can I do sql command like this: update sekce set pocet = count(*) from odkaz where odkaz.sekce_id = sekce.id Thanks for answer j. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MS Access and mySQL
see my message re--- index problem ok when I do explain in this , it is not using an index for the AdminCoverage_writingagents table... SELECT admincoverage_writingagents.WritingAgentID, admincoverage_writingagents.WritingAgentSlot, ProducerID, TaxID, (ModalPremium * BillModeID * (PercentOfCase / 100)) AS TotalPaidPremium, AdminCoverage.CoverageID, AdminCoverage.CoverageIDSbc, admincoverage_writingagents.RegionCode, AdminProduct.LobId, AdminCoverage.StatusID, AdminCoverage.StatusDate, AdminCoverage.InitialPremiumDate, AdminCoverage.PaidToDate, GROUPID FROM admincoverage_writingagents INNER JOIN AdminCoverage ON admincoverage_writingagents.CoverageID=AdminCoverage.CoverageID AND admincoverage_writingagents.CoverageIDSbc=AdminCoverage.CoverageIDSbc LEFT JOIN AdminProducer ON AdminProducer.ProducerID=admincoverage_writingagents.WritingAgentID LEFT JOIN AdminProduct ON AdminCoverage.ProductID=AdminProduct.ProductID WHERE AdminCoverage.InitialPremiumDate = '2101' AND AdminCoverage.InitialPremiumDate = '20020701' AND TaxID='003349715' ORDER BY admincoverage_writingagents.WritingAgentSlot,AdminCoverage.CoverageId, AdminCoverage.CoverageIdSbc ,ProducerID table in question has 900,000 records CREATE TABLE admincoverage_writingagents ( Source char(1) NOT NULL , CoverageId char(15) NOT NULL , CoverageIdSbc char(10) NOT NULL , WritingAgentSlot int(11) , WritingAgentId char(15) NOT NULL , PercentOfCase double , RadDistributionCode char(5) , RegionCode char(5) , LobId char(15), KEY coverageid (CoverageId), KEY coverageidsbc (CoverageIdSbc), KEY coverageidandsbc (CoverageId, CoverageIdSbc), KEY writingagentid (WritingAgentId), KEY writingagentslot (WritingAgentSlot) ); -Original Message- From: Mark Matthews [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 11:11 AM To: Mary Stickney Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: MS Access and mySQL Mary Stickney wrote: the join syntax is what is differnt between Access and MYSQL. in MS-SQL = indexs will be used on tables mentioned in the JOIN clause and they will not in MYSQL This is not true. MySQL uses indexes in joins, if you've put them in the right columns, just as in MS-SQL. What gives you the idea that it doesn't? -Mark -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: First thoughts on mysql-4.0.3
At 17:48 +0200 8/28/02, Martin MOKREJ· wrote: Hi, after upgrading, I had two problems: /usr/local/mysql/bin/mysqld: ERROR: unknown variable 'query_buffer_size=32M' I had to comment out this variable, it seems it got renamed. I have to figure out what's the new name. It's no longer used, according to the 4.0.3 change notes in the manual. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Info on 4.0.x release date
Joel, you obviously put some thought into his response and I very much appreciate the insight. All in all, I feel you make some good points. I did find a couple of things that I want to rebut. Well, as a bystander, I think you've shot a little wide. When you say bystander, are you referring to yourself of me? If you are referring to me, then I think you are wrong. My ideas and suggestions should stand or fall on their merits -- not whether I attended the online launch party. In fact, the perspective of the uninitiated can, in many cases, prove the most useful. Microsoft? Indeed Microsoft, Lotus, Word Perfect, Borland, Oracle and every other major software manufacturer in the world has missed deadlines, stuff happens. I am no stranger to this myself. My point is that every successful software company also spends a serious amount of effort to manage the development process and to communicate with the ultimate beneificiaries of their work. Frankly, based upon the volume and high quality of the MySQL code that I've seen, they must be doing this also. I did not write to criticize them for missing their projected deadline -- my criticism was about my perception that they had failed to communicate adequately with their community about it. So they gave you all the details they could. Did they? That was my whole argument. Over the past 6 months I have read no fewer than 10 responses from the team which have, in effect, said we don't know, quit bugging us. During the same period, they have found time to name the dolphin and get venture funding and write about the booths they are setting up at various trades shows. All of this is important. I strongly support their efforts to be financially successful. I just think that it would be good (and in their economic interest) to more prominently feature news that summarized the development efforts, how they are going, and what the latest thinking is about the timing of milestones. are areas where the profit margin is [slim] But all of their more profitable areas are derrived from this one. But the analogy does not fit. These guys are cutting new ground. The analogy absolutely fits. They are not cutting new ground! Does their work involve innovation? Absolutely! But they are not building the super-collider or mapping the human genome here. They are writing business software, and that, my friend, is a well-traveled road. Otherwise, you'd have gone with Microsoft or Oracle... Actually, you have this backwards. I have been a Microsoft SQL Server developer for years and find it to be an incredibly good tool. I explored MySQL because I like the open source model and I am interested in offering my clients a choice. While I know that many in this group will consider this blastphamous, at this stage, SQL Server is a vastly superior product in many ways. A discussion of why I feel this would require a separate thread all its own, and frankly I am not interested in a pissing match with the MS haters. I use MS products when I feel they are the best solution to my clients business problems. I would like to reccomend and use MySQL in a similar fashion and I feel that when 4.1 is released, I will be able to do so without reservation. I am not so much interested in re-engineering every system I ever wrote to use MySQL. [you feel that] since you've spent that money you are entitled Actually, no. My two points are that 1) being free isn't enough, by itself, to make it a good buy -and- 2) their for-pay business model might well benefit from the improved communications I have suggested. Have you been working with the alphas and betas, reporting actual bugs, etc.? Have I installed the alphas and played with them? Yes. Have I endeavored to try using them in a production environment? No. The testing you are referring to, I believe, is best suited to users who have existing mysql systems that can be trial-migrated to the new version. I have no such system. Furthermore, the systems that I envision using the product for cannot be developed until a couple of missing (my view) features such as multi-table updates and sub-selects are available. the small license fee might have been small enough to go ahead and pay it Why don't you and everyone else who may read this each send me $1. Its a very small amount, I'm sure you wouldn't even miss it. What? You say that you will not send me a dollar? Why not? Is it because I haven't provided anything of value in exchange? I am in the same boat with MySQL. While thousands of people around the world may find that MySQL is a great fit with their needs (and make no mistake, I think it is a fine product), I have yet to personally come accross a suitable application for it in my work. The product simply is of no use to me, other than academic, until it has the core set of features that my apps require. I am willing to contribute my ideas and feedback because I see the potential of this
how does one successfully use mysql_store_result()?
HOW does one use this to confirm a record set? for instance, if mysql_store_result() = 0 then do nothing end if where mysql_store_result() returns an empty set on a select statement. any help obtained would be WONDERFUL!!! sorry, i'm new to this, the syntaxtual information is quite confusing to me. angel IT Services Trintex Corporation 770-258-5551 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: First thoughts on mysql-4.0.3
Hi, About query_buffer_size, you can find in the changelog : - Removed unused variable query_buffer_size. Regards, Jocelyn - Original Message - From: Martin MOKREJ [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 28, 2002 5:48 PM Subject: First thoughts on mysql-4.0.3 Hi, after upgrading, I had two problems: /usr/local/mysql/bin/mysqld: ERROR: unknown variable 'query_buffer_size=32M' I had to comment out this variable, it seems it got renamed. I have to figure out what's the new name. 020828 17:30:12 mysqld started 020828 17:30:12 Can't find messagefile 'mysql-4.0.3-beta-pc-linux-gnu-i686/share/mysql/english/errmsg.sys' 020828 17:30:12 Aborting 020828 17:30:12 mysqld ended This I've already posted once. My fix is: # cd /usr/local/mysql(/usr/local/mysql is a link to /usr/local/mysql-4.0.3-beta-pc-linux-gnu-i686) # ln -s . mysql-4.0.3-beta-pc-linux-gnu-i686 # /etc/rc3.d/S98mysql start Hope this helps -- Martin Mokrejs [EMAIL PROTECTED], [EMAIL PROTECTED] PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs MIPS / Institute for Bioinformatics http://mips.gsf.de GSF - National Research Center for Environment and Health Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany tel.: +49-89-3187 3683 , fax: +49-89-3187 3585 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MS Access and mySQL
True you could, but then that way you will loose portability if Jon (for whatever reason) decides to move to another type of DB. Never used libmySQL so I dont know how the speed is, but assume its as fast if not faster then ODBC. ODBC has the plus of being user friendly and of being an M$ Universal Standard. -Nick Roger Davis wrote: Or you could just use the libmySQL.dll and handle everything yourself through VB. You will however need to download the MyODBC driver if you wish to access MySQL through VB. -Nick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Info on 4.0.x release date
I wrote Ironically, the fact that I pay no license fees to MySQL AB is based upon... Dean Ellis wrote Ahhh, I see. So, you are _completely irrelevant_. My relevance stems from the fact that I am a very good prospect to a company that has a stated interest in growing their community of satisfied users/customers. My feedback about what is preventing me from signing on the bottom line, to the extent that it may be representative of others like me, is like gold to a growing company (ask anyone who is in marketing or sales). To the extent that you have already been proselytized, you are likely less relevant than I. Dean Ellis wrote You are fully entitled to your opinion. Yes I am, Thank you. == NOTE: The information in this email is confidential and may be legally privileged. If you are not the intended recipient, you must not read, use or disseminate the information. Although this email and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free and no responsibility is accepted by Cadwalader, Wickersham Taft for any loss or damage arising in any way from its use. == - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: JAMES KADEH mysql !
HE ALREADY DID FROM PREVIOUS EMAILS TO MY ACCOUNT... I HAVE A WEB PAGE AND THEY ARE MINING EMAIL ADDRESSES.. DUH SAME BACK AT YOU -Original Message- From: Kenneth Hylton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 11:29 AM To: 'Mary Stickney'; John Wards; [EMAIL PROTECTED] Subject: RE: JAMES KADEH mysql ! also wrote back and asked if he thought I was a complete idiot... Unfortunately, you may be. Now he has your e-mail address. As my father always sez, smooth move Ex-Lax -Original Message- From: Mary Stickney [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 10:12 AM To: John Wards; [EMAIL PROTECTED] Subject: RE: JAMES KADEH mysql ! I reported him already... to [EMAIL PROTECTED] [EMAIL PROTECTED] and several others.. also wrote back and asked if he thought I was a complete idiot... -Original Message- From: John Wards [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 9:49 AM To: [EMAIL PROTECTED] Subject: Re: JAMES KADEH mysql ! wow...do you think this is real.we could all be rich!...:-P - Original Message - From: James Kadeh [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 28, 2002 3:34 PM Subject: JAMES KADEH mysql ! mysql , My dear, Good day, I wish to introduce myself to you. I am Lt. Col. James Kadeh, (rtd.).I am the personal assistant to President Laurent Kabila of Democratic Rep. of Congo. I got your contact information from your country's information directory over the internet during my desperate search for a reliable person that will assist me personally in moving some funds. Please I have not disclosed this to any other person, and if you cannot do it for me , do not disclose it to any other persons I humbly wish to notify you of my intention to use your name and address in the lifting out of the some of $18.6m currently deposited with a finance company here in South Africa to a finance security in Europe. This fund was deposited by me on behalf of President Laurent Kabila before he met his untimely death through a bloody assassination by one of his body guards at the height of the political crisis that swept through our country. This fund was meant for the purchase of arms and ammunition for defending his regime against the Rebel forces in dare need to over throw his regime. I was lucky to escape with copies of the documents covering the funds deposited with the security company to South Africa in other to save my dear life and that of my family. Presently, we are here without any reasonable source of livelihood. And there has not been any trace of this fund or its location up to date, since the new regime as I am solely in possession of the documents guiding it. This is actually what I want you to do for me: To help me clear and accommodate this fund when it gets to Europe's To assist me in managing this fund in good and profitable venture in your country , where I will also come and settle down. I highly hoped that my request will be granted and viewed with favor. Please I anticipate your urgent response to this very request and also emphasize that you keep every bit of this transaction strictly to yourself alone, bearing in mind its nature and the confidentiality it requires. Thank you. Best Regards, Lt. Col. James Kadeh (rtd.). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check:
NULL values inserted with \N not NULL?
Hi, I'm using version 3.23.49 on RH7.3. I'm following the menagerie example and have added some lines to the pet tabel using the LOAD DATA LOCAL INFILE... construction. I have created a file pet.txt like the manual suggests and have added \N in some fields to include NULL values. However when I perfom a simple SELECT on the table the formatting seems broken, and when I run a query looking for NULL values the result is Empty set... Here are a few lines from the pet.txt: flufyy harold cat f 1993-02-04 \n Chirpy \n bird\n \n \n [snip] Here's the first query and some of the output: mysql SELECT * FROM pet; +++-+--+++ | name | owner | species | sex | birth | death | +++-+--+++ | flufyy | harold | cat | f| 1993-02-04 | -00-00 | | Chirpy | | bird| | -00-00 | -00-00 | [snip] +++-+--+++ 13 rows in set (0.44 sec) And here's the other query: mysql SELECT * FROM pet WHERE death IS NULL; Empty set (0.23 sec) What am I doing wrong? TIA -- # Mertens Bram M8ram [EMAIL PROTECTED] Linux User #249103 # # Red Hat Linux 7.3 KDE 3.0.0-10 kernel 2.4.18-3 i686 128MB RAM # # A priest advised Voltaire on his death bed to renounce the devil. # # Replied Voltaire, This is no time to make new enemies. # - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: load data into table from file or how to set the local-infile=1
I doubt mysql as access to /home/M8ram/testmysql/pet.txt. Mertens Bram wrote: On Wed, 2002-08-28 at 16:51, Egor Egorov wrote: Put into my.cnf file : [mysql] local-infile=1 or start mysql client with --local-infile=1 option. I tried the first option and it works when use the following command to load the data-file: mysql LOAD DATA LOCAL INFILE '/home/M8ram/testmysql/pet.txt' INTO TABLE pet; Query OK, 3 rows affected (0.19 sec) Records: 3 Deleted: 0 Skipped: 0 Warnings: 0 But when I use the above command without the LOCAL option it displays the following error: mysql LOAD DATA INFILE '/home/M8ram/testmysql/pet.txt' INTO TABLE pet; ERROR 1045: Access denied for user: 'M8ram@localhost' (Using password: NO) Is this 'normal behaviour'? About the second suggestion: where should this file be located? Is it possible that it does not exist yet? If so can I create a file named my.cnf with a text-editor (like KWrite) and put it in my home directory? Thanks for the help! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how does one successfully use mysql_store_result()?
If I understand you correctly, then you are trying to figure out how to distinguish between an empty result set vs. no result set (i.e. an error if statement was a SELECT). In the case of an error (or a not result set returning statement like INSERT), mysql_store_result will return null. In the case of an empty set, it will return a (non-null) pointer to a set that is empty. Subsequent to this, mysql_fetch_row() will return a null pointer indicating you have reached EOF for the result set. Hope this helps original message text HOW does one use this to confirm a record set? for instance, if mysql_store_result() = 0 then do nothing end if where mysql_store_result() returns an empty set on a select statement. any help obtained would be WONDERFUL!!! sorry, i'm new to this, the syntaxtual information is quite confusing to me. == NOTE: The information in this email is confidential and may be legally privileged. If you are not the intended recipient, you must not read, use or disseminate the information. Although this email and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free and no responsibility is accepted by Cadwalader, Wickersham Taft for any loss or damage arising in any way from its use. == - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: load data into table from file or how to set the local-infile=1
On Wed, 2002-08-28 at 20:02, Gerald Clark wrote: I doubt mysql as access to /home/M8ram/testmysql/pet.txt. Sorry, I don't understand: why would mysql have access to a file when I run LOAD DATA LOCAL... and not when I run it without the LOCAL? If I run it with LOCAL the data is added to the table without a problem -- well not entirely without a problem, see my post about NULL values. (I actually have no idea what the LOCAL does so this may be a dumb question) Thanks for the help. p.s. just in case that wasn't what you meant: M8ram is my username, so on my (RH7.3) Linux box /home/M8ram is simply my home-directory... -- # Mertens Bram M8ram [EMAIL PROTECTED] Linux User #249103 # # Red Hat Linux 7.3 KDE 3.0.0-10 kernel 2.4.18-3 i686 128MB RAM # # A priest advised Voltaire on his death bed to renounce the devil. # # Replied Voltaire, This is no time to make new enemies. # - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MS Access and mySQL
Hi, Using directly libmysql.dll ?How ? On http://www.a1vbcode.com/app.asp?ID=1764 is gmysql.zip.TypeLibrary for VB and work with libmysql ver 4.xCan be an alternative. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Roger Davis [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, August 28, 2002 7:32 PM Subject: RE: MS Access and mySQL Or you could just use the libmySQL.dll and handle everything yourself through VB. You will however need to download the MyODBC driver if you wish to access MySQL through VB. -Nick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 password ( )
I dont know if it helps, but I dont decrypt, instead, I compare the crypted value on the DB against the output of the function PASSWORD() filled with the pwd I get from the user... It works for me (and I'm using APACHE and MySQL all in plain ANSI C). Leonardo Javier Belén. AFIP-AR - Original Message - From: Mark Stringham [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 28, 2002 1:47 PM Subject: mysql password ( ) I have used the mysql password(\$pass \) function in the past to encrypt passwords into the db. but can not decrypt them if needed. I know this is not something new. Is there a better way to protect passwords in the db and then decrypt them if needed ? Thanks Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Re: MS Access and mySQL]
You didn't mention whether they are planning on keeping the NT box, but I assume that they are, and that what you want to do is leave the Access app working, but point it to the Linux-MySQL QUBE. I have been there and done that (well, except for the QUBE part -- I run Mandrake 8 on an old P-233. I second the choice of DB Tools. There are other tools with import wizards but this one works very well. The only problem is that neither DB Tools nor any other similar tool that I came across is capable of importing the index information. All you get is the data. In one of my apps there are 400+ tables, and it's a considerable pain to have to manually create the indexes. However, there is a Windows-based shareware tool called dbScripter (from DKG Advanced Solutions). It only costs something like $50 US for the full version. I may have the price wrong since I bought it a couple of years ago (and have received two or three free updates since). dbScripter doesn't do direct imports. As the name implies, it generates scripts which you can run to achieve the same end. It breaks down a job into 3 possible scripts: structure, data and indexes. It works with profiles so that you can direct it to change a currency or yes/no column to the appropriate MySQL data type. It took me about 10 minutes to create a profile for MySQL. I generated the script to create all the indexes for me and then ran it in MySQL, no problem. I have several applications that I ported from Access MDBs to MySQL, and I continue to use Access with them, thanks to MyODBC. I simply set up a DSN on my Windows box that points to the Linux box and the rest was a piece of cake. I dispute Nicholas's contention that a lot of Access queries will not work in MySQL. Technically, he is correct: if you try to run a query that says SELECT TOP 10 * FROM mytable, that of course won't work in MySQL; nor will Access's crosstab queries. However, if you leave them in Access and execute them against a MySQL database, almost all of them continue to work. There is an added advantage to this route, as well. Leaving them in Access preserves their existence as objects with names, meaning that you can create a couple of queries and use them in subsequent queries. This is a very powerful feature of Access, and there is no reason to abandon it when you move the data to MySQL -- unless of course you are also abandoning Access. If you have any specific questions, feel free to ask. Arthur Original Message From: Nicholas Stuart [EMAIL PROTECTED] Subject: Re: MS Access and mySQL To: [EMAIL PROTECTED], [EMAIL PROTECTED] I have been there done that with old access data, but no forms. Your plans should be focused around what you know and what your systems are tied to. Since its an NT box you could go with pretty much any language ie java/vb/c++. VB would be the obvious choice for ease of transfering the Access VBA forms to straight VB. The only thing you have to be careful is the access querys. A lot of them will not work on MySQL and the funny thing is a lot of them will not work on M$'s on SQL server :) go figure. As far as the data goes the easist thing I found to transfer it into mysql is a program called dbtools. You can find it at: http://www.dbtools.com.br/EN/ It's fairly easy to use and has a great import wizard. If you have an specific questions let me know and I'll try my best to answer them. -Nick MySQL Newsgroup (@Basebeans.com) wrote: Subject: MS Access and mySQL From: =?iso-8859-1?q?Jonathan=20Coleman?= [EMAIL PROTECTED] === Hi. I have a situation where a church I am doing some volunteer work for has a MS Access (office 97) database running on NT. They are (woohoo) upgrading to a QUBE (linux box) for a server which has mySQL installed (and I can upgrade it etc..) My job therefore is to a) port MS Access data and queries to mySQL database b) use the MS Access forms to access the data and queries through ODBC. Is there anyone who can point me in the right direction, either to where the searchable discussion archives are, OR even better, someone who has gone through this before? Cheers Jon http://digital.yahoo.com.au - Yahoo! Digital How To - Get the best out of your PC! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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:
Re: mysql error in RH7.3
Thanks to all that reply to my help request. Yes, mysqld was not running. Thanks again, Nestor :-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MS Access and mySQL
That has not been my experience, in fact my experience has been completely the opposite. As my first test case I ported the Northwind sample database to MySQL. I had to make a few changes here and there, most notably to some queries, but also including (and I forgot to mention this in my previous reply on this subject) adding a column of type TimeStamp to every table in the database. This is necessary so that you can read auto-increment values. Next, I took my current app, with about 94 tables, and ported it. The production app is in MS SQL 2000, but I wanted to port it because I wanted a proof-of-concept to show management. The absence of sprocs was a big problem (come on, 4.1 :-) but I worked around it. No one but me and a few testers is using this version. The production app remains in MS SQL. Finally, I took my killer-database, whose tables number 400+. Fortunately, with dbScripter in hand I didn't have to create say 1000 indexes by hand! It ported well and my Access front end talks blissfully to it. The MySQL part resides on a P233 running Mandrake, set up for InnoDB. This may simply be high praise for MyODBC, but my Access app has no difficulty at all talking to the database. Arthur - Original Message - From: [EMAIL PROTECTED] To: Arthur Fuller [EMAIL PROTECTED] Sent: Wednesday, August 28, 2002 1:57 PM Subject: [Fwd: RE: MS Access and mySQL] wodya think? Original Message From: Nicholas Stuart [EMAIL PROTECTED] Subject: RE: MS Access and mySQL To: [EMAIL PROTECTED] CC: [EMAIL PROTECTED], [EMAIL PROTECTED] I would strongly urg you not to use Access as the front end. The biggest problem is that the Jet Engine/Access backend is pretty much completly different then MySQL and you will run into problems with table structure and the like. Also, using access as the front end has been extremly slow when ever I tried it. You will however need to download the MyODBC driver if you wish to access MySQL through VB. -Nick -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jonathan, If you are going to be completely converting the Access db to MySQL, and just using Access as the frontend, you will need to download MyODBC: http://www.mysql.com/downloads/api-myodbc.html You can download either the stable or development release. There is also a FAQ that will answer your questions there about how to setup almost exactly what you are referring to. http://www.mysql.com/products/myodbc/faq_toc.html This FAQ is for the development release (3.51.03) but can also be used for the stable release (2.50.xx). I recently had to do the same thing with a Paradox database for a client, and have had relatively few issues following the documentation. After downloading and installing MyODBC you will be able to export the database directly to your Linux MySQL, however you will lose your table structures for the most part and will have to do some ALTER TABLE statements to put your keys back and the majority of your fields set to their proper type. HTH, Bryant Hester Juxtapose, inc. - -Original Message- From: Jonathan Coleman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 12:40 AM To: [EMAIL PROTECTED] Subject: MS Access and mySQL Hi. I have a situation where a church I am doing some volunteer work for has a MS Access (office 97) database running on NT. They are (woohoo) upgrading to a QUBE (linux box) for a server which has mySQL installed (and I can upgrade it etc..) My job therefore is to a) port MS Access data and queries to mySQL database b) use the MS Access forms to access the data and queries through ODBC. Is there anyone who can point me in the right direction, either to where the searchable discussion archives are, OR even better, someone who has gone through this before? Cheers Jon http://digital.yahoo.com.au - Yahoo! Digital How To - - Get the best out of your PC! - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -BEGIN PGP SIGNATURE- Version: PGPfreeware 7.0.3 for non-commercial use http://www.pgp.com iQA/AwUBPWzH6UlWu7/HFp4nEQJOGwCgr5af7wIi1AcbpP1rih/vABg/zb8An13w 4Tm8I6eugdNnVhLYZ+CcTYq2 =Z0ov -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try:
CREATE TABLE adds ZEROFILL
Description: I am porting MySQL to Linux/Alpha. On some occasions the CREATE TABLE statement adds ZEROFILL for int(11) fields. If you don't know this problem, let me know so I can try to fix it. If you know the problem please let me know what to do (I don't want to re-invent the wheel). How-To-Repeat: CREATE TABLE article ( id int(11) NOT NULL auto_increment, up int(11) NOT NULL default '0', topic int(11) NOT NULL default '0', title varchar(255) NOT NULL default '', abstract longtext NOT NULL, content longtext NOT NULL, author int(11) NOT NULL default '0', created datetime NOT NULL default '-00-00 00:00:00', url varchar(255) NOT NULL default '', calstart date default NULL, caldays int(11) NOT NULL default '0', icon int(11) NOT NULL default '0', view int(11) NOT NULL default '0', print int(11) NOT NULL default '0', extra1 varchar(255) NOT NULL default '', extra2 varchar(255) NOT NULL default '', extra3 varchar(255) NOT NULL default '', name varchar(255) NOT NULL default '', creator int(11) NOT NULL default '0', revisor int(11) NOT NULL default '0', revision int(11) NOT NULL default '0', approver int(11) NOT NULL default '0', revised datetime NOT NULL default '-00-00 00:00:00', approved datetime NOT NULL default '-00-00 00:00:00', score int(11) NOT NULL default '0', type int(11) NOT NULL default '0', locked datetime NOT NULL default '-00-00 00:00:00', locker int(11) NOT NULL default '0', sitegroup int(11) NOT NULL default '0', PRIMARY KEY (id), KEY topic(topic,title(14)), KEY article_sitegroup_idx(sitegroup), KEY article_name_idx(name(10)) ); results in: -- MySQL dump 8.22 -- -- Host: localhostDatabase: midgard - -- Server version 3.23.52-log -- -- Table structure for table 'article' -- CREATE TABLE article ( id int(11) zerofill NOT NULL auto_increment, up int(11) zerofill NOT NULL default '000', topic int(11) NOT NULL default '0', title varchar(255) NOT NULL default '', abstract longtext NOT NULL, content longtext NOT NULL, author int(11) NOT NULL default '0', created datetime NOT NULL default '-00-00 00:00:00', url varchar(255) NOT NULL default '', calstart date default NULL, caldays int(11) NOT NULL default '0', icon int(11) NOT NULL default '0', view int(11) NOT NULL default '0', print int(11) NOT NULL default '0', extra1 varchar(255) NOT NULL default '', extra2 varchar(255) NOT NULL default '', extra3 varchar(255) NOT NULL default '', name varchar(255) NOT NULL default '', creator int(11) NOT NULL default '0', revisor int(11) NOT NULL default '0', revision int(11) NOT NULL default '0', approver int(11) NOT NULL default '0', revised datetime NOT NULL default '-00-00 00:00:00', approved datetime NOT NULL default '-00-00 00:00:00', score int(11) NOT NULL default '0', type int(11) NOT NULL default '0', locked datetime NOT NULL default '-00-00 00:00:00', locker int(11) NOT NULL default '0', sitegroup int(11) NOT NULL default '0', PRIMARY KEY (id), KEY topic (topic,title(14)), KEY article_sitegroup_idx (sitegroup), KEY article_name_idx (name(10)) ) TYPE=MyISAM; Fix: I did not examine the problem yet. Do you know it or do I have to investigate it myself? Submitter-Id: Martin Brulisauer Originator:[EMAIL PROTECTED] Organization: Martin Brulisauer, Switzerland MySQL support: none Synopsis: CREATE TABLE adds zerofill on int(11) fields Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-3.23.52 (Source distribution) Environment: System: Linux alps 2.4.19 #1 Wed Aug 28 17:24:26 MEST 2002 alpha EV5 Architecture: alpha EV5 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/alphaev5-bruli-linux/3.0.4/specs Configured with: ./configure --prefix=/usr --exec-prefix=/usr --host=alphaev5-bruli-linux --enable-threads=posix --enable-shared --disable-static Thread model: posix gcc version 3.0.4 Compilation info: CC='gcc' CFLAGS='-O3 -mcpu=ev5 -Wa,-mev5,-m21164 -fomit-frame-pointer' CXX='g++' CXXFLAGS='-O4 -mcpu=ev5 -Wa,-mev5,-m21164 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -rwxr-xr-x1 root root 2486187 Apr 24 2001 /lib/libc.so.6.1 -rw-r--r--1 root root 6564480 Apr 24 2001 /usr/lib/libc.a -rw-r--r--1 root root 180 Apr 24 2001 /usr/lib/libc.so Configure command: ./configure --build=alphaev5-bruli-linux-gnu --host=alphaev5-bruli-linux-gnu --prefix=/usr --sysconfdir=/etc --localstatedir=/var --enable-shared --disable-static --enable-thread-safe-client --with-unix-socket-path=/var/mysql/mysql.sock --with-mysqld-user=mysql --without-debug --with-berkeley-db
RE: [PHP] Re: Command Line
You can also use TRUNCATE TABLE table_name; this recreates the table, instead if just removing all data from it. To get to know more about the table structure, you may want to use: SHOW CREATE TABLE table_name; It shows you the create table statement of the table. -Oorspronkelijk bericht- Van: Adam Williams [mailto:[EMAIL PROTECTED]] Verzonden: 28 August 2002 03:19 Aan: Trevor Tregoweth CC: mysql; PHP Onderwerp: Re: [PHP] Re: Command Line if you just wanna delete everything from the tables you can do DELETE FROM table_name; for each table. or you can do DROP table_name; for each one but then you have to re-create each table that you drop with CREATe TABLE ( stuff here ); Only use DROP table_name; if you know the structure of each table. If you need the table names do SHOW TABLES; and if you need their structure use DESCRIBE table_name; Adam On Wed, 28 Aug 2002, Trevor Tregoweth wrote: Hi I am very new to mysql, so any help please how to drop tables from a database from the command line i have 6 tables in there, and need to be able to flush all the data out, (of 2 tables only) so there might be another way Thanks Trevor - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: NULL values inserted with \N not NULL?
On 28 Aug 2002, at 19:49, Mertens Bram wrote: Here are a few lines from the pet.txt: flufyyharold cat f 1993-02-04 \n Chirpy\n bird\n \n \n [snip] What am I doing wrong? Not paying attention to case. As you said earlier, the code for NULL is \N, not \n. [Filter fodder: SQL] -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Info on 4.0x release date
Hello. On Wed 2002-08-28 at 09:19:46 -0500, [EMAIL PROTECTED] wrote: [...] serious. It becomes harmful to MySQL in general when a release that was once predicted in 2001, becomes no where in sight in late 2002. Do you (all) realize you can only complain about this (falling so far from their prediction), because they happened to give out some estimate in the first place? Sounds only reasonable to me to try to avoid the same situation by not giving out estimations to begin with. [...] I realize that developments of this nature are unpredictable, and no one expects perfect estimates - but a clearer idea of what's going on and range of possible expectations would go a long way to help those of us that argue against the advocates of those serious DBMS's. Of course I still think MySQL is an outstanding and serious product, but a little more help in convincing others would be appreciated. I think the difference to conventional products it that MySQL AB strives to only ship a stable release, when the lack of bug reports shows that it is stable, while a lot of other vendors ship on a (maybe once shifted) release date, no matter what (some of them may have good reasons to do so). Regards, Benjamin. -- [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
REcommende set up for a MYSQL server
I was given the task of finding out what is need it to set a our Mysql DB on separate server from our webserver. The OS is will be RH7.3 There will be a lot of transactions accessing this serverMysql. My questions are: 1) What is the recommended ram and hard Drives for a server that will be getting a lot of transactions? Is a 1 gig pentium good enough? What should I keep in consideration? any other info is welcome. 2) This might sound like a dumb question, but I alway set up websites running Mysql on the same server. How is the configuration different when the DB is on a different server. What should I take into consideration. What is needed to set a mirror hard drive for the DB in case one hard drive crashes? Thanks, Nestor :-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php