Re: SHOW TABLES; show nothing
Hi. On Mon, Dec 03, 2001 at 11:41:38PM -0800, [EMAIL PROTECTED] wrote: These areI thinkpre-built Dunno for sure. # rpm -qa | grep -i glibc compat-glibc-6.2-2.1.3.2 glibc-devel-2.2-5 glibc-common-2.2.4-13 glibc-2.2.4-13 # mysql --version mysql Ver 11.6 Distrib 3.23.28-gamma, for pc-linux-gnu (i586) # rpm -qa | grep -i gcc gcc-2.96-69 kgcc-1.1.2-40 Although I can't tell you if this was the case when it was built... It had to have been a while ago. I have been trying to build a new mysql, however, if you check the messages a few days ago, I am having compile problems. I.E; # cd /usr/src/mysql-3.23.46/ # ./configure --prefix=/usr/local/mysql --with-unix-socket-path=/usr/local/mysql/lock/mysql.sock --enable-assembler --with-libwrap --without-berkeley-db \ --with-ipv6 --without-bench --with-mysqld-ldflags=-all-static --disable-shared --with-extra-charset=complex --without-mit-threads --with-other-libc=/lib make ...blah... ...blah... Making all in client make[2]: Entering directory `/src/mysql-3.23.46/client' c++ -DUNDEF_THREADS_HACK -I./../include What output gives c++ -v From the output, I don't see whether kgcc or gcc is used. -I../include -I./.. -I..-I..-O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -fpermissive -I/lib/include -c mysql.cc cc1plus: Invalid option `-fpermissive' In file included from client_priv.h:19, from mysql.cc:28: ../include/global.h:680: abstract declarator used as declaration [...] Any help there? Well, since I never encountered build problems with MySQL myself, I am probably not of much help. The error above occurs in the follwing part of the code: 679 #if !defined(bool) !defined(bool_defined) (!defined(HAVE_BOOL) || !defined(__cplusplus)) 680 typedef charbool; /* Ordinary boolean values 0 1 */ 681 #endif And is probably about declaring bool when it is already defined. The question is why the #if evaluates to true. I just checked, and for me (RH 6.2, egcs-2.91.66), HAVE_BOOL and __cplusplus are both defined (the first by configure in config.h and the second by gcc itself, because it compiles a C++ source). So, without knowing, my first bet would be that HAVE_BOOL is not set in config.h. If this really is the case, then the question is, why the detection by configure failed. Most time, when such a simple test by configure fails, it is some missing lib or so (i.e. the compile fails not due to the test itself, but other stuff). On the other hand, I never had a configure finish when such problems occured (because too much tests failed with basic stuff going wrong). Hope that helped somehow. Btw, what is the reason that you don't use the official binaries? Bye, 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
[ot] harsh mail rejection
[EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table Why does this list not include SELECT and INSERT?! Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Efficient Boolean combination of results of several SELECTs
...in MySQL, to keep the list filter happy :-( Hi, I have several different SELECTs, each of which returns a set of results which I'd like to combine in a boolean fashion. So, say I have 4 selects, w, x, y, and z, I might want to do: ((x AND y) OR Z ) AND (NOT w) What's the best way of going about this? any of the selects could on their own return 10,000's of result, but all combined, they should return less than 100, so how should I go abotu doign the boolean combination? cheers, Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: does mysql.sock come with a linux 323 installation
Hi. mysql.sock is created by the mysqld process when it is started. The lack of it usually means that either mysqld doesn't run or that the file got deleted by an other process. For more info, see http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html Bye, Benjamin. On Thu, Dec 06, 2001 at 04:30:40PM +1100, [EMAIL PROTECTED] wrote: I'd like to know if mysql.sock comes with a linux installation as I have follwed the instructions to install linux but it always says ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) . but mysql.sock does not seem to be anywhere on my linux machine [...] -- [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: Slow results with SELECT's that return large numbers of results
neeraj arora wrote: Hi, I think indexing the column(s) can help you. Already spent a week figuring how to get the SELECT to work fast when a few results are returned, os all appropriate columns are indexed ;-) u can find more on this page http://www.linux-mag.com/cgi-bin/printer.pl?issue=2001-06article=mysql i hope this will help you. Yup, had a good read... My specific problem isn't with indexing as such, I reckon I have prettymuch optimal indexes for the SELECTs I'm doing, but I have problem when _lots_ of results are returned. Is there any efficient way I can just get the count of rows returned by a SELECT rahter than making MySQL go through all the hassle of generating all the results and returning them to me? cheers, Chris mysql, etc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 64bit mysql and gcc
Hi! Greg == Greg Cope [EMAIL PROTECTED] writes: cut Greg We use the Sun's cc complier - this is the standard complier here on Spark / Greg Solaris. The problem is that we don't have access to a system to a Solaris 8 system with SUN cc installed. (If anyone want to make one available to use to compile MySQL binaries, you can always send an email to me about this :) Greg Have you had poblems with 64 bit gcc code ? One thing I've noticed is that Greg few people are doing 64bit work in the Open Source world (well, certainly Greg many perl XS modules are not 64 bit safe). And I64 could hardly be called Greg stable! I have used gcc on Linux Alpha and Linux Ia64 with good results. Last time I checked this out, I saw some recommendation to not use gcc 2.95. to compile 64 bit code for anything else than testing. I just checked out sun-freeware and they have recently released gcc 3.0.2. I am downloading this now and as soon as I get some time over I will see if this can be used to generate 64 bit binaries. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [ot] harsh mail rejection
On Thu, Dec 06, 2001 at 09:08:41AM +, Chris Withers wrote: [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table Why does this list not include SELECT and INSERT?! Because it's not yet perfect. Perhaps someone at MySQL.com and update the filters a bit. Sasha, maybe? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 7 days, processed 156,603,951 queries (257/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: queries on particular table produce errors
On Wed, Dec 05, 2001 at 04:57:42PM -0700, Jon Gardiner wrote: I can't speak for other table formats but in MyIsam tables you can take your database down, rename the table's files (.frm .MYI .MYD), and restart the server. I'd make a backup if you are going to try it, though. Watch out if the table is named in any GRANT statements, of course. :-) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 7 days, processed 156,700,351 queries (257/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Efficient Boolean combination of results of several SELECTs
On Thu, Dec 06, 2001 at 11:15:03AM +, Chris Withers wrote: Jeremy Zawodny wrote: Hm. It sounds like you just want to combine the WHERE clauses (intelligently) and end up with one big query, right? Yup, but given that each WHERE clause is already pretty hairy, I was hoping someone would say oh, sure, here's some set operations to complement UNION ;-) How about, try out MySQL 4.0 with UNION support? :-) If that's not the case, then is there an algorith for combining there WHERE clauses? Programmatically? Not that I know of. It'd be a non-trivial task... Manually, it's that--manual. :-( Chris . o ( I have visions of writign a compiler to generate a SELECT ;-) ) Ahh. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 7 days, processed 157,288,180 queries (257/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Slow results with SELECT's that return large numbers of results
On Thu, Dec 06, 2001 at 09:28:10AM +, Chris Withers wrote: neeraj arora wrote: Already spent a week figuring how to get the SELECT to work fast when a few results are returned, os all appropriate columns are indexed ;-) u can find more on this page http://www.linux-mag.com/cgi-bin/printer.pl?issue=2001-06article=mysql i hope this will help you. Yup, had a good read... Glad you liked it. :-) My specific problem isn't with indexing as such, I reckon I have prettymuch optimal indexes for the SELECTs I'm doing, but I have problem when _lots_ of results are returned. Ah, that's a different problem alright. SQL_BUFFER_RESULT (http://www.mysql.com/doc/S/E/SELECT.html) my help, depending on what the real bottleneck is. Is there any efficient way I can just get the count of rows returned by a SELECT rahter than making MySQL go through all the hassle of generating all the results and returning them to me? Sure, change your SELECT * FROM foo WHERE ... to SELECT COUNT(*) FROM foo WHERE ... to get the cound of matching rows. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 7 days, processed 157,472,311 queries (257/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Access denied for user
Hi check if mysqld is running if not start it and try again. daniel josep wrote: I get the following message when trying to view a php page Warning: Access denied for user: 'jupshoes@localhost' (Using password: YES) in /home/jupshoes/public_html/guest/index.php on line 27 Unable to connect to SQL server What is going wrong Josep - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: optimize for SELECTs on multiple large tables
On Thu, Dec 06, 2001 at 09:39:18AM +1000, Arjen G. Lentz wrote: Well, you have to realise that the server can only use a one index per table (for obvious reasons). That's far from being obvious to a lot of folks... You can actually split a table into multiple identical ones, by using MERGE tables (see manual). But that just makes managing them easier (and inserts into one table faster), it wouldn't speed up your SELECT. In fact, doing so introduces a bit more overhead. So i wonder if there's any way to optimise MySQL so that i will be able to actually do a SELECT on those tables. Maybe tweak parameters like join_buffer_size? table_cache? Anyone has some experience with these?... What's the best way to optimize MySQL for running SELECTs on multiple large tables? Yes, server settings are important, and the 'right' settings depend on your system (amount of RAM, etc) as well as on your database and the type of queries that you run most often. And pick up a copy of the December Linux Magazine. There's an article on MySQL Server Tuning in there. It'll be on the web in a couple months, too. There is no magic wand, I'm afraid. But... you may find it advantagious to do a MySQL training course (www.mysql.com/training/). Optimisation is a very important part of the course material, in this message I've just touched briefly on a few little items. Good plan, too. :-) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 7 days, processed 157,486,781 queries (257/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Efficient Boolean combination of results of several SELECTs
Jeremy Zawodny wrote: Yup, but given that each WHERE clause is already pretty hairy, I was hoping someone would say oh, sure, here's some set operations to complement UNION ;-) How about, try out MySQL 4.0 with UNION support? :-) Can UNION do boolean AND, NOT and OR combination of sets generated by SELECTs? Chris . o ( I have visions of writign a compiler to generate a SELECT ;-) ) Ahh. *grinz* Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 results with SELECT's that return large numbers of results
Jeremy Zawodny wrote: SQL_BUFFER_RESULT (http://www.mysql.com/doc/S/E/SELECT.html) my help, depending on what the real bottleneck is. H... I thought temporary tables were bad? Sure, change your SELECT * FROM foo WHERE ... to SELECT COUNT(*) FROM foo WHERE ... to get the cound of matching rows. This doesn't seem to work :-S Maybe it's 'cos of the GROUP BY clause on the end of my select... How can I get this to work with a GROUP BY? cheers, Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Efficient Boolean combination of results of several SELECTs
On Thu, Dec 06, 2001 at 11:59:04AM +, Chris Withers wrote: Jeremy Zawodny wrote: Yup, but given that each WHERE clause is already pretty hairy, I was hoping someone would say oh, sure, here's some set operations to complement UNION ;-) How about, try out MySQL 4.0 with UNION support? :-) Can UNION do boolean AND, NOT and OR combination of sets generated by SELECTs? Hmm... http://www.mysql.com/doc/U/N/UNION.html Nope. :-( Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 7 days, processed 157,639,970 queries (257/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
User Privileges being set to 'N'
Hello, At seemingly random intervals all of the privileges for every user in the mysql.user table get set to 'N'. I found the statements below in the binlog. Is there a way to find out who/what ran these? Answers to some security questions: There are only three users in MySQL. Root and noonand have access to everything, netweb has SELECT, INSERT, UPDATE, DELETE on selected databases, not including mysql. All of them have good (8 char alphanum) passwords. The box is a dept web server inside corporate firewalls. I notice that the REVOKEs only removed privileges that had been granted. For instance File_priv wasn't revoked for netweb as that user never had the privilege. I'd think if this were a person they'd have done REVOKE ALL PRIVILEGES ON *.* FROM ... and not gone through individual tables, etc. There aren't any jobs that run at 0146. The only one close is the 0100 update of htDig but that doesn't use MySQL. That's all I can think to pass on at the moment. If anyone can give me a clue I'd appreciate it. Thanks, Dave Noonan === REVOKE SELECT, INSERT, UPDATE, DELETE ON `agora`.* FROM 'netweb'@'%'; # at 197583 #011204 1:46:36 server id 1 Query thread_id=10969 exec_time=0 error_code=0 SET TIMESTAMP=1007448396; REVOKE SELECT, INSERT, UPDATE, DELETE ON `owl`.* FROM 'netweb'@'%'; # at 197679 #011204 1:46:36 server id 1 Query thread_id=10970 exec_time=0 error_code=0 SET TIMESTAMP=1007448396; REVOKE SELECT, INSERT, UPDATE, DELETE ON `phpBB`.* FROM 'netweb'@'%'; # at 19 #011204 1:46:37 server id 1 Query thread_id=10971 exec_time=0 error_code=0 SET TIMESTAMP=1007448397; REVOKE SELECT, INSERT, UPDATE, DELETE ON `tccweb`.* FROM 'netweb'@'%'; # at 197876 #011204 1:46:37 server id 1 Query thread_id=10972 exec_time=0 error_code=0 SET TIMESTAMP=1007448397; REVOKE ALL PRIVILEGES ON *.* FROM 'noonand'@'%'; # at 197953 #011204 1:46:38 server id 1 Query thread_id=10973 exec_time=0 error_code=0 SET TIMESTAMP=1007448398; REVOKE GRANT OPTION ON *.* FROM 'noonand'@'%'; # at 198028 #011204 1:46:38 server id 1 Query thread_id=10974 exec_time=0 error_code=0 SET TIMESTAMP=1007448398; REVOKE ALL PRIVILEGES ON *.* FROM 'root'@'%'; # at 198102 #011204 1:46:38 server id 1 Query thread_id=10975 exec_time=0 error_code=0 SET TIMESTAMP=1007448398; REVOKE GRANT OPTION ON *.* FROM 'root'@'%'; # at 198174 #011204 1:46:39 server id 1 Query thread_id=10976 exec_time=0 error_code=0 SET TIMESTAMP=1007448399; REVOKE ALL PRIVILEGES ON *.* FROM 'root'@'localhost'; # at 198256 #011204 1:46:39 server id 1 Query thread_id=10977 exec_time=0 error_code=0 SET TIMESTAMP=1007448399; REVOKE GRANT OPTION ON *.* FROM 'root'@'localhost'; # at 198336 === - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: reliability on the server
On Tue, Dec 04, 2001 at 11:05:52AM +0100, Ornella Fasolo wrote: Hallo, i would like to know if there is a reliability mechanism inside mysql. I have a server on a machine and several clients that access to the server My problem is to find a way to assure that if the Data base machine go down, i assure however the services to the clients. You are looking for some form of high-availability. MySQL doesn't have anything built-in. But a load-balancer such as LVS may help. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 7 days, processed 158,110,521 queries (257/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: porting mysql to ibm os/390 open edition
On Mon, Dec 03, 2001 at 08:01:11PM -0800, Peschko, Edward wrote: hey, I was wondering if you had any plans to port mysql to os-390, and the open edition environment there. I think it would be a really cool idea, considering that most shops that have a IBM mainframe are looking for ways to leverage it in the unix world without spending mega-bucks on IBM proprietary solutions like DB2 If you do find someone running MySQL on Linux on the big iron, I'd love to hear about it. Heck, if GCC, Perl, and Apache can work on it, there's a chance that some hacker at IBM has alredy managed to get MySQL working, too. That'd be excellent. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 7 days, processed 158,115,933 queries (257/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Some questions to the pre-sale technical support of MySQL
On Tue, Dec 04, 2001 at 04:37:31PM +0200, Sinisa Milivojevic wrote: Hofhauser, Bela writes: Hi, MySQL 3.23 already has synchronous replication. It is in a widespread use already. I'd call it asynchronous replication. The master really has little concept of what the slaves are doing most of the time, right? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 7 days, processed 158,339,071 queries (257/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ISAM 2 MyISAM Conversion
On Mon, Dec 03, 2001 at 09:28:11AM -0800, Steve Osborne wrote: I have an existing database with ISAM tables that I would like to convert to MyISAM tables. Using phpMyAdmin, I can change the table type using a drop-down box, however I do not know the repercussions of the table type conversion. Shouldn't be any. :-) -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 7 days, processed 158,349,997 queries (257/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Efficient Boolean combination of results of several SELECTs
Jeremy Zawodny writes: On Thu, Dec 06, 2001 at 11:59:04AM +, Chris Withers wrote: Can UNION do boolean AND, NOT and OR combination of sets generated by SELECTs? Hmm... http://www.mysql.com/doc/U/N/UNION.html Nope. :-( Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 7 days, processed 157,639,970 queries (257/sec. avg) No, but in 4.1 there will be INTERCEPT and MINUS too, beside UNION's (with or without ALL option). Those three combined can produce any of the above relational operations. -- 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: porting mysql to ibm os/390 open edition
Jeremy Zawodny writes: If you do find someone running MySQL on Linux on the big iron, I'd love to hear about it. Heck, if GCC, Perl, and Apache can work on it, there's a chance that some hacker at IBM has alredy managed to get MySQL working, too. That'd be excellent. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 7 days, processed 158,115,933 queries (257/sec. avg) It is working now for almost a year. You can find a binary tarball on 3.23download page too ... ;o) It was done by one developer from one University in Florida, with a little help of yours truly. -- 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: Some questions to the pre-sale technical support of MySQL
Jeremy Zawodny writes: I'd call it asynchronous replication. The master really has little concept of what the slaves are doing most of the time, right? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 7 days, processed 158,339,071 queries (257/sec. avg) Right ! -- 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
howto change db privileges?
I'm able to connect to connect to the database but unable to select elements. Josep - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: porting mysql to ibm os/390 open edition
On Thu, Dec 06, 2001 at 02:57:15PM +0200, Sinisa Milivojevic wrote: Jeremy Zawodny writes: If you do find someone running MySQL on Linux on the big iron, I'd love to hear about it. Heck, if GCC, Perl, and Apache can work on it, there's a chance that some hacker at IBM has alredy managed to get MySQL working, too. That'd be excellent. It is working now for almost a year. You can find a binary tarball on 3.23download page too ... ;o) It was done by one developer from one University in Florida, with a little help of yours truly. Ah, excellent. Do you know if he's one any benchmarks with it? Those machines tend to have great I/O systems, so I'd expect very good performance. Any chance I could get his e-mail address via private mail? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 7 days, processed 158,783,550 queries (257/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: howto change db privileges?
Josep As root you need to log in to the database mysql. You then need to give whatever priviledges you want to your normal account. See section 6.14 in the manual (Adding New user Privileges to MySQL). Dave From: josep [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: howto change db privileges? Date: Thu, 6 Dec 2001 14:01:51 +0100 I'm able to connect to connect to the database but unable to select elements. Josep - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: PHP + MySQL problem (strange behavior)
I've had a few queries that worked strangely worked in Mysql monitor, but did not work from PHP. I was able to solve every one of them by ensure that the query in PHP did not have any line breaks in it. It normally doesn't matter if there are line breaks in the code, but on occassion, a line break can cause strange results. Hope this helps. Mike On Wed, 5 Dec 2001, Javier Muniz wrote: Hello, I'm having trouble determining what's going wrong with a MySQL query that I'm doing from PHP. I have a table with the following columns: id (int) name (varchar 20) starttime (int) duration (int) now, i have a row that has a starttime of 60, when i attempt to do the following update with PHP, it sets it to 0: UPDATE mytable SET starttime=starttime-30 WHERE name = 'myname' but when I run it from the MySQL command line, copy/pasted from the code, it sets the value of starttime to 30 as expected. Any thoughts on where this problem originates from? PHP or MySQL? They're pretty commonly used in unison so I'd imagine something like this should work fairly smoothly. I've also posted this to the PHP list in case there's someone there that's encountered this before. Javier Muniz Chief Technology Officer Granicus, LTD. Tel: (415) 522-5216 Fax: (415) 522-5215 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Michael J. Ridinger Lead Web Developer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Efficient Boolean combination of results of several SELECTs
Sinisa Milivojevic wrote: No, but in 4.1 there will be INTERCEPT and MINUS too, beside UNION's (with or without ALL option). Those three combined can produce any of the above relational operations. wooah! *dribble*! :-) When can I start using this code? Where can I get it from? cheers, Chris (mysql, just to be safe :-P) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Host
Just a small bit of help... Before a make this change I would like some help Am I right in think if in the MySQL database on the db tables there are no blank host enters then there is no point in having anything in the host table? Thanks Simon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL cobalt raq 3
Hello I have installed MySQL in Cobalt Raq 3 Please can sendme info for aneble MySQL to mi customers in cobalt raq? Please Beste regards Pablo 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
mysqld-max: Table 'mysql.host' doesn't exist
Hi, I am new to MySQL and installed the Win2000 version on my labtop. I had no problems until I got to the security part and did the following according to the docs: The default privileges on Windows give all local users full privileges to all databases without specifying a password. To make MySQL more secure, you should set a password for all users and remove the row in the mysql.user table that has Host='localhost' and User=''. You should also add a password for the root user. The following example starts by removing the anonymous user that can be used by anyone to access the test database, then sets a root user password: C:\ C:\mysql\bin\mysql mysql mysql DELETE FROM user WHERE Host='localhost' AND User=''; mysql QUIT C:\ C:\mysql\bin\mysqladmin reload C:\ C:\mysql\bin\mysqladmin -u root password your_password After you've set the password, if you want to take down the mysqld server, you can do so using this command: C:\ mysqladmin --user=root --password=your_password shutdown After this step I found I was unable to start up the mysqld server. So today, I dropped the database, removed the service and started again = mysqld-max --basedir=c:/mysql --datadir=c:/mysql/data -standalone The database and service created successfully but I am still unable to start or connect to anything These are errors I see 1. C:\mysql\binmysql mysql ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) 2. The error in the file 'MYSQL.ERR' is mysqld-max: Table 'mysql.host' doesn't exist 3. And cannot start the service MYSQL Error C:\mysql\binNET START MySQL The MySql service is starting. The MySql service could not be started. A system error has occurred. System error 1067 has occurred. The process terminated unexpectedly. If any one can help, I would be very grateful thanks, Anne-Marie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Connection issue with Kylix to Mysql 3.23
Hi, Did you make contact with Borland Support? Did you post message in Borland Newsgroup, 'newsgroups.borland.com'? Edward Valentine wrote: I downloaded and installed the new patch from Borland that allows Kylix to use versions of MySQL 3.23 and newer. Most of the errors on connection stopped and it seems to connect. What I am getting now is a "username/password invalid" error. I have connected with Webmin, MySQL at a prompt and kmysql using the same me and password. I have checked on the web and found several others with the same issue but no answers. I am using Caldera 3.1 with updates and all of the software versions included with that distro. I would appreciate any help. Thanks. -- TAKAHASHI, Tomohiro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: porting mysql to ibm os/390 open edition
Jeremy Zawodny writes: Ah, excellent. Do you know if he's one any benchmarks with it? Those machines tend to have great I/O systems, so I'd expect very good performance. Any chance I could get his e-mail address via private mail? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 7 days, processed 158,783,550 queries (257/sec. avg) Yup. [EMAIL PROTECTED] But I think it is also used by [EMAIL PROTECTED] -- 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
replication pb w/ mysql 3.23.35 as master and mysql 3.23.45 as slave
hi, i just upgrade mysql to newer version 3.23.45 and now the slave that is just upgraded (the master will be the next to be upgraded but in one week) return such error: 011206 15:29:41 Slave thread: error connecting to master: Unknown MySQL Server Host 'hostname' (0) (76), retry in 60 sec i upgrade it on AIX 4.3.3 using gcc compiler on a PS640 machine (multiprocessor). i do the same 1 week ago to another slave using the same master and it's working fine. i don't understand the problem, that i fix myself by changing host of master to the corresponding IP adress (even the IP name is into the hosts file and into DNS). do you have a solution to let me put back to host name instead of IP because i have a cluster set in failure mode that can take tare of the domain name and not the ip. thx a lot in advance, - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 results with SELECT's that return large numbers of results
:Now, is there any way I can quickly return the length of the :result set withotu :actually returning the result set itself? : : :Chris : :(MySQL question, obviously ;-) Dunno if this was answered cause I'm on digest but, Try SELECT Count(*) from... erik st.m _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [ot] harsh mail rejection
On 6 Dec 2001, at 9:08, Chris Withers wrote: database,sql,query,table Why does this list not include SELECT and INSERT?! Worse, why do we have to put up with the filtering at all when it's not doing its job? The Portuguese spam got through yesterday, but legitimate messages are blocked. Other lists seem to survive without such filtering. Why can't this list be set up to allow only subscribers to post? Are these spammers really subscribing before they send the spam? (If they are, then obviously the situation is more complicated.) -- Keith C. Ivey [EMAIL PROTECTED] Washington, DC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ANN: EMS MySQL Manager 1.22 released
Dear Sirs and Madams, EMS HiTech company is announcing the next version (1.22) of MySQL Manager -- A Powerful MySQL Administration and Development Tool for Windows95/98/ME/NT/2000/XP. You can download the latest version from http://www.mysqlmanager.com/download.phtml What's new in version 1.22? 1. Export Data: data export as INSERT statement now works in compliance with order of selected fields. (*) 2. DB Explorer: Fixed bug with host name editing in the registered database. Now edited database will be added to corresponding host node properly. 3. BLOB Viewer/Editor: Fixed bug with changes loss after current record is changed. Now the question dialogue will appear on record or field changing. (*) 4. Edit Field dialogue: 'Multiple primary key defined' error now doesn't occur after field is renamed and setted as primary key at the same time. 5. Fixed bug with data extracting with apostrophe within field value. Now each apostrophe within value will be duplicated after data extraction. 6. Fixed bug with exporting fields of type ENUM('N','Y') as INSERT statement. (*) 7. Fixed bug with ENUM('Y','N') field type. Now default values for this type will be displayed properly in the data view. 8. Import Data Wizard: Design of Import Data Wizard form was changed. (*) 9. Some minor bugfixes and small improvements. (*) -- Professional Edition only What is the EMS MySQL Manager? EMS MySQL Manager provides you powerful and effective tools for MySQL Server administration and objects management. Its Graphical User Interface (GUI) allows you to create/edit of all MySQL database objects most easy and simple way, run SQL scripts, manage users and administrate users' privileges, visually build SQL queries, extract or print metadata, export/import data, view/edit BLOBs and many more services that will make you work with MySQL server as easy as you want... Best regards, EMS HiTech development team. http://www.ems-hitech.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: select statement group by unusual results
DL Neil [EMAIL PROTECTED] on 12/06/2001 12:26:45 AM Internet mail from: Please respond to DL Neil [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED] Subject: Re: select statement group by unusual results Chip, I have a database with 12 tables. I am running a query to select certain fields from 3 of the tables, like this - select Title, Details, StartDate, City, State from phpCalendar_Details, phpCalendar_Daily, phpCalendar_EventLocations where phpCalendar_Details.EventLocationID = phpCalendar_EventLocations.EventLocationID group by City; The problem is the StartDate field data for the first returned row is carried down through all the rows, rather than picking up the correct StartDate data. All the other data is picked up correctly. When I change group by to State or Title or any field, I get the same problem, whatever the first returned field, it is carried down through all the rows. How do I get around this, or what am I doing wrong? |From this can we assume (you don't give table schema) that StartDate is in the |phpCalendar_Daily table and is |the only field selected from that table? | |Take a look at the WHERE clause: the query is using three tables but only joins two. | |Is that it? |=dn I guess I left a bit out. Here's the set up - 3 tables are phpCalendar_Details (fields are Title, Details), phpCalendar_Daily (field StartDate) , phpCalendar_EventLocations (fields are City, State). Two tables (_Details and _EventLocations) have a common field - EventLocationID, the third table does not have a field common to those two tables. I suppose I have to have one common to all 3 to make it work? |=you got it - that's why they're called relational databases! |-otherwise there is no way of working out which row/StartDate from the phpCalendar_Daily |table is relevant to |the Event being described be the other two tables' data. | |=Should you be thinking about having an EventID which appears in both the |phpCalendar_Details and |phpCalendar_Daily tables - or collapsing the StartDate into the phpCalendar_Details table? |Either way, it is |beginning to sound like a db design/normalisation issue rather than a query-writing |problem. | |=Hope it helps, |=dn Thanks for the tips. So here's my latest attemp: select distinct Title, Details, StartDate, StopDate, City, State from phpCalendar_Details t1, phpCalendar_Daily t2, phpCalendar_EventLocations t3 where t1.LocationID = t2.LocationID and t1.EventLocationID = t3.EventLocationID group by StartDate; And this one works! Amazing, my first attempt at a join statement. Thanks again, Chip W. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [ot] harsh mail rejection
On Thursday 06 December 2001 03:50 am, Jeremy Zawodny wrote: Because it's not yet perfect. ?Perhaps someone at MySQL.com and update the filters a bit. ?Sasha, maybe? It is important to understand that no bot could ever get it right in 100% of the cases regardless of how sophisticated the rules are. So we will always have a trade-off and need to draw the line somewhere. Please do not be offended if your beautifully written message gets bounced the first time you try it. Expanding the good word list will reduce the number of legitimate messages being rejected, but at the same time, it will allow more spam to slip by. The problem with insert, select and delete is that they are rather common words and are likely to appear in spam messages. So I am rather hestitant to add them to the good word list. If you post to the list often, you can protect yourself from spurious bounces by saying something about MySQL in your signature, our favorite, of course, would be : MySQL AB offers commercial support for MySQL. For more info, please visit https://order.mysql.com;. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Cluster?
-Original Message- From: Barry Roomberg [mailto:[EMAIL PROTECTED]] A few notes: 1) All data is readonly. No write requirement except monthly load. use myisam pack to compress the data / indexs. Also use -rq --analyse --sort-index as myisam arguments to rebuild the index file in a more optimal way. I've found a good performance improvements (20% ish) on selects using this. 1st Goal: Setup 2 systems that share data and allow either to satisfy read requests. Seems like a simple replication to 2 box scenario, with application level handling to go to the live box if 1 is down. Are there any preferred projects that handle the director portion of this? I assume I will have total data duplication on each system, ie: they won't be reading the same disk. tricky - if using Linux the you can use heartbeat to take over an IP address, but your client code will not be connected to this myql server. I would prefer a client code based solution - in that if your code cannot connect, or execute a query, failover to another server and connect. 2nd goal: Setup a cluster of systems sharing the same disk (it is a fibrechannel back end). I ASSUME I can read/only mount to a BUNCH of independent systems, which will then serve queries. Simple? Seems so. Can MySQL open a database read-only of a truly read-only file system? pass - but using myisam pack the data / index files have to be read only as MySQL cannot write to a compress data file. The actual performance the disk is capable of providing is far more than MySQL reads for a query, so I should be able to stacka few systems against it before it degrades. Will this outperform a local disk ? How big is your dataset - as with memory being so cheap I would stuff the machines full of it and allocate arround half to mysql. The rest would be used by the OS as a disk / buffer cache. Greg PFIZER GLOBAL RESEARCH AND DEVELOPMENT This message and any attachment has been virus checked by the PGRD Sandwich Data Centre. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
installing of mysql
Hello, I want to install mysql on my sun (solaris 2.7). But I have a problem. The output after configuring is: loading cache ./config.cache checking host system type... sparc-sun-solaris2.7 checking target system type... sparc-sun-solaris2.7 checking build system type... sparc-sun-solaris2.7 checking for a BSD compatible install... ./install-sh -c checking whether build environment is sane... yes checking whether make sets ${MAKE}... (cached) yes checking for working aclocal... missing checking for working autoconf... found checking for working automake... found checking for working autoheader... missing checking for working makeinfo... missing checking whether to enable maintainer-specific portions of Makefiles... no checking whether build environment is sane... yes checking whether make sets ${MAKE}... (cached) yes checking for gawk... (cached) nawk checking for gcc... (cached) gcc checking whether the C compiler (gcc ) works... yes checking whether the C compiler (gcc ) is a cross-compiler... no checking whether we are using GNU C... (cached) yes checking whether gcc accepts -g... (cached) yes checking for c++... (cached) c++ checking whether the C++ compiler (c++ ) works... yes checking whether the C++ compiler (c++ ) is a cross-compiler... yes checking whether we are using GNU C++... (cached) yes checking whether c++ accepts -g... (cached) yes checking how to run the C preprocessor... (cached) gcc -E checking for ranlib... (cached) ranlib checking for ld used by GCC... (cached) /usr/ccs/bin/ld checking if the linker (/usr/ccs/bin/ld) is GNU ld... (cached) yes checking for BSD-compatible nm... (cached) /usr/ccs/bin/nm -p checking whether ln -s works... (cached) yes loading cache ./config.cache within ltconfig checking for object suffix... o checking for executable suffix... (cached) no checking for gcc option to produce PIC... -fPIC checking if gcc PIC flag -fPIC works... yes checking if gcc supports -c -o file.o... yes checking if gcc supports -c -o file.lo... yes checking if gcc supports -fno-rtti -fno-exceptions ... yes checking if gcc static flag -static works... -static checking if the linker (/usr/ccs/bin/ld) is GNU ld... yes checking whether the linker (/usr/ccs/bin/ld) supports shared libraries... yes checking command to parse /usr/ccs/bin/nm -p output... ok checking how to hardcode library paths into programs... immediate checking for /usr/ccs/bin/ld option to reload object files... -r checking dynamic linker characteristics... solaris2.7 ld.so checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... yes checking for objdir... .libs creating libtool loading cache ./config.cache checking for a BSD compatible install... ./install-sh -c checking for bison... bison -y checking for pdftex... no checking return type of sprintf... configure: error: can not run test program while cross compiling Where is/are the error/s ? Best regards Bettina - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ANN: EMS MySQL Manager 1.22 released
At 20:25 2001-12-06 +0500, Igor Brynskich wrote: allo Is this product free like MYSQLfront? If it is not free, Can I considere it as a SPAM (SPAM is a no sollocited commercial email) on a Mailling List? Ray Dear Sirs and Madams, EMS HiTech company is announcing the next version (1.22) of MySQL Manager -- A Powerful MySQL Administration and Development Tool for Windows95/98/ME/NT/2000/XP. You can download the latest version from http://www.mysqlmanager.com/download.phtml What's new in version 1.22? 1. Export Data: data export as INSERT statement now works in compliance with order of selected fields. (*) 2. DB Explorer: Fixed bug with host name editing in the registered database. Now edited database will be added to corresponding host node properly. 3. BLOB Viewer/Editor: Fixed bug with changes loss after current record is changed. Now the question dialogue will appear on record or field changing. (*) 4. Edit Field dialogue: 'Multiple primary key defined' error now doesn't occur after field is renamed and setted as primary key at the same time. 5. Fixed bug with data extracting with apostrophe within field value. Now each apostrophe within value will be duplicated after data extraction. 6. Fixed bug with exporting fields of type ENUM('N','Y') as INSERT statement. (*) 7. Fixed bug with ENUM('Y','N') field type. Now default values for this type will be displayed properly in the data view. 8. Import Data Wizard: Design of Import Data Wizard form was changed. (*) 9. Some minor bugfixes and small improvements. (*) -- Professional Edition only What is the EMS MySQL Manager? EMS MySQL Manager provides you powerful and effective tools for MySQL Server administration and objects management. Its Graphical User Interface (GUI) allows you to create/edit of all MySQL database objects most easy and simple way, run SQL scripts, manage users and administrate users' privileges, visually build SQL queries, extract or print metadata, export/import data, view/edit BLOBs and many more services that will make you work with MySQL server as easy as you want... Best regards, EMS HiTech development team. http://www.ems-hitech.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
ALTER TABLE error
Can anyone tell me why I am receiving the following error? I am connecting to a remote server via ssh, and accessed the mysql prompt by typing: mysql The following is the screen contents after trying to use the ALTER TABLE command; 'dbname' has been sub'd for actual database name. screen contents start Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1451062 to server version: 3.23.43 Type 'help' for help. mysql connect dbname Connection id:1451083 Current database: dbname mysql ALTER TABLE Advertisers PACK_KEYS=0; ERROR 2000: Access denied for user: '@localhost' to database 'dbname' screen contents end Can anyone give me some insight as to why I cannot do this? Do I require root privileges to do this (right now I am logged in as a user, as this remote server is an ISP)? Steve Osborne Database Programmer Chinook Multimedia Inc. [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: installing of mysql
Bettina Ketzmerick wrote: Hello, I want to install mysql on my sun (solaris 2.7). But I have a problem. The output after configuring is: loading cache ./config.cache checking host system type... sparc-sun-solaris2.7 checking target system type... sparc-sun-solaris2.7 checking build system type... sparc-sun-solaris2.7 checking for a BSD compatible install... ./install-sh -c checking whether build environment is sane... yes checking whether make sets ${MAKE}... (cached) yes checking for working aclocal... missing checking for working autoconf... found checking for working automake... found checking for working autoheader... missing checking for working makeinfo... missing checking whether to enable maintainer-specific portions of Makefiles... no checking whether build environment is sane... yes checking whether make sets ${MAKE}... (cached) yes checking for gawk... (cached) nawk checking for gcc... (cached) gcc checking whether the C compiler (gcc ) works... yes checking whether the C compiler (gcc ) is a cross-compiler... no checking whether we are using GNU C... (cached) yes checking whether gcc accepts -g... (cached) yes checking for c++... (cached) c++ checking whether the C++ compiler (c++ ) works... yes checking whether the C++ compiler (c++ ) is a cross-compiler... yes checking whether we are using GNU C++... (cached) yes checking whether c++ accepts -g... (cached) yes checking how to run the C preprocessor... (cached) gcc -E checking for ranlib... (cached) ranlib checking for ld used by GCC... (cached) /usr/ccs/bin/ld checking if the linker (/usr/ccs/bin/ld) is GNU ld... (cached) yes checking for BSD-compatible nm... (cached) /usr/ccs/bin/nm -p checking whether ln -s works... (cached) yes loading cache ./config.cache within ltconfig checking for object suffix... o checking for executable suffix... (cached) no checking for gcc option to produce PIC... -fPIC checking if gcc PIC flag -fPIC works... yes checking if gcc supports -c -o file.o... yes checking if gcc supports -c -o file.lo... yes checking if gcc supports -fno-rtti -fno-exceptions ... yes checking if gcc static flag -static works... -static checking if the linker (/usr/ccs/bin/ld) is GNU ld... yes checking whether the linker (/usr/ccs/bin/ld) supports shared libraries... yes checking command to parse /usr/ccs/bin/nm -p output... ok checking how to hardcode library paths into programs... immediate checking for /usr/ccs/bin/ld option to reload object files... -r checking dynamic linker characteristics... solaris2.7 ld.so checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... yes checking for objdir... .libs creating libtool loading cache ./config.cache checking for a BSD compatible install... ./install-sh -c checking for bison... bison -y checking for pdftex... no checking return type of sprintf... configure: error: can not run test program while cross compiling Where is/are the error/s ? Since I just went through this on sol 8 I'll take this one. Including the gcc lib directory in my path (usually /usr/local/lib or where ever you installed it) fixed the problem for me. George Best regards Bettina - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
I need some help translating a PostgreSQL Query to MySQL
I was wondering if anyone could help me converting some PostgreSQL queries with sub-queries into a similar form usable (hopefully) by both, or at least into a form that I can use in place of the PostgreSQL ones. I'm going to post them - I hope no one minds. If this is the wrong mailing list for these kinds of questions, I apologize. I'm currently using the latest Version 3.23.43, but I can change to Version 4 if these queries are supported there. If it matters, these are for the new version of Freeside, an ISP billing program that (reluctantly) has supported transaction-safe (InnoDB, in my case) tables in MySQL. I think the first one lists all of the customers that have uncancelled packages. Here they are: SELECT * FROM cust_main WHERE 0 ( SELECT COUNT(*) FROM cust_pkg WHERE cust_pkg.custnum = cust_main.custnum AND ( cust_pkg.cancel IS NULL OR cust_pkg.cancel = 0 ) ) OR 0 = ( SELECT COUNT(*) FROM cust_pkg WHERE cust_pkg.custnum = cust_main.custnum ) SELECT * FROM cust_pkg WHERE 0 ( SELECT count(*) FROM pkg_svc WHERE pkg_svc.pkgpart = cust_pkg.pkgpart AND pkg_svc.quantity ( SELECT count(*) FROM cust_svc WHERE cust_svc.pkgnum = cust_pkg.pkgnum AND cust_svc.svcpart = pkg_svc.svcpart ) ) SELECT * FROM svc_acct WHERE 0 ( SELECT count(*) FROM cust_svc WHERE cust_svc.svcnum = svc_acct.svcnum AND pkgnum IS NULL ) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ANN: EMS MySQL Manager 1.22 released
Hmm 30 days trial then you have to register. Seems like spam to me Raymond Abel wrote: At 20:25 2001-12-06 +0500, Igor Brynskich wrote: allo Is this product free like MYSQLfront? If it is not free, Can I considere it as a SPAM (SPAM is a no sollocited commercial email) on a Mailling List? Ray Dear Sirs and Madams, SNIP spam - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Ulf Bäckman System developer Skanova Networks Network Security - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: select statement group by unusual results
Hi Chip, Thanks for the tips. So here's my latest attemp: select distinct Title, Details, StartDate, StopDate, City, State from phpCalendar_Details t1, phpCalendar_Daily t2, phpCalendar_EventLocations t3 where t1.LocationID = t2.LocationID and t1.EventLocationID = t3.EventLocationID group by StartDate; And this one works! Amazing, my first attempt at a join statement. =it works, great! Join our happy throng of MySQL-ers! but... (I'm going to make loads of assumptions because you have changed the schema of two or even all three of the involved tables (since describing them before) - it works, so that's not bothering me) What is? 1 why use DISTINCT? ie what do you think it is contributing to the query result? 2 why use GROUP BY? ie what do you want to happen if there is more than one event starting on the same date? Yes relational algebra can be fun - provided you didn't sleep through set theory etc at school. Congratulations on your success, that is an inner join and in fact is also a equi-join (and there's plenty of other jargon that you can use to describe it). Your first example had a join in its WHERE clause too - did you mean that this is your first multi-way join? Now is the time when all good (wo)men go out and pick up a decent text and get stuck in... Regards, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ANN: EMS MySQL Manager 1.22 released
I think you are overreacting with your spam thing. Quoted from the link he gave: === This trial version is FULLY functional! An unregistered copy of the EMS MySQL Manager may be used for evaluation purposes for a period of 30 (thirty) days following the initial installation. At the end of the TRIAL PERIOD, the user must either register the EMS MySQL Manager or remove it from his system. === I mean, It's *directly* related to mySQL. Put a filter on OT, Off-topic, Ann and you won't see them. My 2 cents, Etienne Raymond Abel wrote: At 20:25 2001-12-06 +0500, Igor Brynskich wrote: allo Is this product free like MYSQLfront? If it is not free, Can I considere it as a SPAM (SPAM is a no sollocited commercial email) on a Mailling List? Ray Dear Sirs and Madams, EMS HiTech company is announcing the next version (1.22) of MySQL Manager -- A Powerful MySQL Administration and Development Tool for Windows95/98/ME/NT/2000/XP. You can download the latest version from http://www.mysqlmanager.com/download.phtml What's new in version 1.22? 1. Export Data: data export as INSERT statement now works in compliance with order of selected fields. (*) 2. DB Explorer: Fixed bug with host name editing in the registered database. Now edited database will be added to corresponding host node properly. 3. BLOB Viewer/Editor: Fixed bug with changes loss after current record is changed. Now the question dialogue will appear on record or field changing. (*) 4. Edit Field dialogue: 'Multiple primary key defined' error now doesn't occur after field is renamed and setted as primary key at the same time. 5. Fixed bug with data extracting with apostrophe within field value. Now each apostrophe within value will be duplicated after data extraction. 6. Fixed bug with exporting fields of type ENUM('N','Y') as INSERT statement. (*) 7. Fixed bug with ENUM('Y','N') field type. Now default values for this type will be displayed properly in the data view. 8. Import Data Wizard: Design of Import Data Wizard form was changed. (*) 9. Some minor bugfixes and small improvements. (*) -- Professional Edition only What is the EMS MySQL Manager? EMS MySQL Manager provides you powerful and effective tools for MySQL Server administration and objects management. Its Graphical User Interface (GUI) allows you to create/edit of all MySQL database objects most easy and simple way, run SQL scripts, manage users and administrate users' privileges, visually build SQL queries, extract or print metadata, export/import data, view/edit BLOBs and many more services that will make you work with MySQL server as easy as you want... Best regards, EMS HiTech development team. http://www.ems-hitech.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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ALTER TABLE error
are you sure you don't want to UPDATE Advertisers SET PACK_KEYS=0;? Steve Osborne wrote: Can anyone tell me why I am receiving the following error? I am connecting to a remote server via ssh, and accessed the mysql prompt by typing: mysql The following is the screen contents after trying to use the ALTER TABLE command; 'dbname' has been sub'd for actual database name. screen contents start Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1451062 to server version: 3.23.43 Type 'help' for help. mysql connect dbname Connection id:1451083 Current database: dbname mysql ALTER TABLE Advertisers PACK_KEYS=0; ERROR 2000: Access denied for user: '@localhost' to database 'dbname' screen contents end Can anyone give me some insight as to why I cannot do this? Do I require root privileges to do this (right now I am logged in as a user, as this remote server is an ISP)? Steve Osborne Database Programmer Chinook Multimedia Inc. [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ALTER TABLE error
Steve Osborne writes: ERROR 2000: Access denied for user: '@localhost' to database 'dbname' Can anyone give me some insight as to why I cannot do this? Do I require root privileges to do this (right now I am logged in as a user, as this remote server is an ISP)? What unix user you are is irrelevant. However, what MySQL user you are is not. You should read the chapters on privileges and security, and ask your ISP to do so too. You shouldn't be able to connect as the anonymous user. BTW, your clock is off by ~65 minutes. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Strange 'sleep'
Hi, we have a mysql server with a strange behaviour: when we execute a query, it takes about 5 seconds, even for simple selects which should return almost immediately. I run mysqladmin --sleep=1 processlist to see what happens, and the process is in 'sleep' mode for 5 seconds. I never see the actual query, I don't know if it sleeps for 5 seconds, then execute the query, or if it executes the query, then sleeps for 5 seconds. The returned result is correct. We have tried different queries, the result is the same for all. The server have been working for months, and we have never seen this behaviour before. We did some changes today (tried to configure replication), but undoing the changes did not make the error disappear... The error only happens when we run the query from our python-based cgi, not when we run the same query directly from the command line (using mysql -v -v -v databasestatement.sql it shows a execution time of 0.09 sec). The error does not happen when we run it against a different mysql server (with identical database, our future slave), using the same cgi... Platform is solaris sparc, version is 3.23.39. Have anyone seen this behaviour before? -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ALTER TABLE error
It means you're connecting to the server as an annonymous user. If you have a username to connect to the server, run the following query: mysql show grants for your_user_name@localhost; and it will show you all the priveleges that you have for specific databases and tables. That's the best way to figure out what happened. If it says that you do not have ALTER privelege for 'dbname', then update the grants for yourself, or ask your ISP to do that if you dont have su access -- The road to hell is paved with melting snowballs. -- Larry Wall in [EMAIL PROTECTED] Carl Troein wrote: CT: CT: Steve Osborne writes: CT: CT: ERROR 2000: Access denied for user: '@localhost' to database 'dbname' CT: CT: Can anyone give me some insight as to why I cannot do this? Do I require CT: root privileges to do this (right now I am logged in as a user, as this CT: remote server is an ISP)? CT: CT: What unix user you are is irrelevant. However, what MySQL user CT: you are is not. You should read the chapters on privileges and CT: security, and ask your ISP to do so too. You shouldn't be able CT: to connect as the anonymous user. CT: CT: BTW, your clock is off by ~65 minutes. CT: CT: //C CT: CT: - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Why can't I get ORDER BY to work with FULLTEXT?
Has anyone had a similar problem? I can't figure out what I'm doing wrong. Help! (database description in previous post) THIS QUERY WORKS: SELECT * FROM products WHERE (MATCH (title,short_desc,long_desc,spec_desc,item_no) AGAINST ('rubber')) THIS QUERY DOES NOT WORK -- RETURNS NOTHING: SELECT * FROM products WHERE (MATCH (title,short_desc,long_desc,spec_desc,item_no) AGAINST ('rubber')) order by item_no 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
Duplicate Keys and Myisam tables
Hi, I'm getting Duplicate Keys errors from mysql when i have more than one application attempting to insert into a table. I've tried using LOCK TABLES to no avail. Can anyone describe how the Duplicate Keys error occurs so I can understand how to code around it ? regards, Graeme Wallace XXI Technologies - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
NULL Strings
I don't know how this affects anything, but, I'm running the most recent version of mySQL for win98. Why is it that an SQL statement like this (or any variation)... SELECT * FROM classification WHERE level1 = FOO AND level2 = NULL; will return an empty set. I know that there should be results. The NULL value is screwing me up. Am I even referencing it properly? Mark Ward - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: select statement group by unusual results
DL Neil [EMAIL PROTECTED] on 12/06/2001 05:27:55 PM Internet mail from: Please respond to DL Neil [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED] Subject: Re: select statement group by unusual results Hi Chip, Thanks for the tips. So here's my latest attemp: select distinct Title, Details, StartDate, StopDate, City, State from phpCalendar_Details t1, phpCalendar_Daily t2, phpCalendar_EventLocations t3 where t1.LocationID = t2.LocationID and t1.EventLocationID = t3.EventLocationID group by StartDate; And this one works! Amazing, my first attempt at a join statement. |=it works, great! Join our happy throng of MySQL-ers! | |but... |(I'm going to make loads of assumptions because you have changed the schema of two or even |all three of the |involved tables (since describing them before) - it works, so that's not bothering me) |What is? |1 why use DISTINCT? |ie what do you think it is contributing to the query result? Actually, it isn't contributing anything, it was left over from my experimenting. I took it out and it still works fine. |2 why use GROUP BY? |ie what do you want to happen if there is more than one event starting on the same date? Turns out the results are slightly differant with or withou group by - I get 20 results with group by and 32 results without it. I should only be getting 20 results, right now I don't have time to figure out where the odd results are coming from when not using group by. I'll check into that later. |Yes relational algebra can be fun - provided you didn't sleep through set theory etc at |school. Relational aglebra? I haven't a clue what that is. Set theory? Don't know what that is either. |Congratulations |on your success, that is an inner join and in fact is also a equi-join (and there's |plenty of other jargon |that you can use to describe it). Your first example had a join in its WHERE clause too - |did you mean that this |is your first multi-way join? This is the first join of any type I have had to make. So far my databases have been simple with just a single table. This one in particular I got off the web, it's a calendar app, quite nice one too,from appIdeas.com. I have to send the data in csv to our parent company in Norway. I'm also doing a dump just so they get everything. I don't know what they're using for sql server or just exactly they want from me, they just want the data. (They're taking some of my work away from me, the dirty rats) :-( |Now is the time when all good (wo)men go out and pick up a |decent text and get |stuck in... | |Regards, |=dn I picked up a book called MySQL/PHP Database Applications by Greenspan Bulger, seems to pretty good, and a couple other php books that have a little mysql stuff. -- Regards, Chip - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Strings
SELECT * FROM classification WHERE level1 = FOO AND level2 IS NULL; IS NULL instead of = NULL null is not a value, it's the abscence of value Etienne Ward, Mark wrote: I don't know how this affects anything, but, I'm running the most recent version of mySQL for win98. Why is it that an SQL statement like this (or any variation)... SELECT * FROM classification WHERE level1 = FOO AND level2 = NULL; will return an empty set. I know that there should be results. The NULL value is screwing me up. Am I even referencing it properly? Mark Ward - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Why can't I get SORT BY to work with FULLTEXT?
Hi! Sorry for delay :-( On Dec 05, Mark J. Degallier wrote: I need a repeatable test case. CREATE TABLE products ( id mediumint(6) default NULL auto_increment, numOfFileUploads tinyint(2) NOT NULL default '2', category_id text NOT NULL, item_no varchar(30) NOT NULL default ' ', title varchar(50) NOT NULL default ' ', short_desc text NOT NULL, long_desc text NOT NULL, spec_desc text NOT NULL, p_weight float(6,2) NOT NULL default '0.00', p_width float(6,2) NOT NULL default '0.00', p_height float(6,2) NOT NULL default '0.00', p_depth float(6,2) NOT NULL default '0.00', retail_price float(7,2) NOT NULL default '0.00', wholesale_price float(7,2) NOT NULL default '0.00', taxable_list text NOT NULL, special_expiration date NOT NULL default '-00-00', special_retail_price float(7,2) NOT NULL default '0.00', special_wholesale_price float(7,2) NOT NULL default '0.00', quantity_breaks text NOT NULL, within_category tinyint(1) NOT NULL default '0', min_order float(7,2) NOT NULL default '0.00', max_order float(7,2) NOT NULL default '0.00', inventory mediumint(7) NOT NULL default '0', inventory_flag_amount smallint(6) NOT NULL default '0', inventory_allow_order tinyint(1) NOT NULL default '0', inventory_decrease mediumint(6) NOT NULL default '1', inventory_comment varchar(100) NOT NULL default ' ', shipping_comment varchar(50) NOT NULL default ' ', PRIMARY KEY (id), FULLTEXT KEY text_search(item_no,title,short_desc,long_desc,spec_desc) ) TYPE=MyISAM; INSERT INTO products VALUES (13,1,'::1::5::4::','102a','Scent Clip 2-Pack','From bows to firearms any big game hunting can be enhanced by the Scent Clip#8482;. Molded in tough polypropylene the Scent Clip is inexpensive, easy to use, and the special Buna N O-Ring seal prevents leaks. ','Use multiple Scent Clips for cover scents, attractants, or curiosity scents. Transport them on arrow shafts or bow limbs. When removed, the cap conveniently fits into the bottom keeping the cap and housing together. Simply clip it to a limb, corn stalk, etc. to catch the wind more effectively. Leave the woods without leaving any scent trace behind. \r\n\r\nBFONT COLOR=#FF000Very effective with rut scents!/FONT/B Patent Pending.\r\n\r\nTwo (2) Scent Clips (1 brown 1 green) with seals installed. (1) Little Shiner (reflective tape strip), unscented cotton balls. \r\n\r\n-Poly bagged.\r\n-Punched header card. \r\n-UPC code.','4-3/4 x 6','0.00','0.00','0.00','0.00','4.99','0.00','::','-00-00','0.00','0.00','','','0.00','0.00',100,10,1,1,'',''); INSERT INTO products VALUES (11,1,'::3::','101','The Hunters Log ©','Provide insight into big game movement with the Hunter\'s Log©. Record date and time, wind direction, temperature, phase of the moon, location, and details of each hunt. \r\n\r\nThe pocket size Hunter\'s Log is also ideal when hunting out of state, for sketching maps of landmarks, roads, compass bearings or making field notes for reference on future hunts. \r\n\r\nEntries in the Hunter\'s Log will provide a legacy of hunting experiences for generations to come.\r\n','-Poly bagged\r\n-Punched header card\r\n-UPC coded.','4-3/4 x 7-1/2','0.00','0.00','0.00','0.00','2.49','0.00','::','-00-00','0.00','0.00','','','0.00','0.00',30,10,'',10,'',''); INSERT INTO products VALUES (21,1,'::5::','110','Predator Camo Slip On Camo Caps set','(1) Green\r\n(1) Fall Gray','long description','','0.00','0.00','0.00','0.00','7.99','0.00','::','-00-00', '0.00','0.00','','','0.00','0.00',100,10,'',1,'','boo'); INSERT INTO products VALUES (24,1,'::5::','113','Service/Replacement Rubber Kit / Std. Rubber parts','short desc','long desc','','0.00','0.00','0.00','0.00','4.99','0.00','','-00-00','0.00','0.00','','','0.00','0.00',100,10,'',1,'',''); SELECT * FROM products WHERE (MATCH (title,short_desc,long_desc,spec_desc,item_no) AGAINST ('rubber')); SELECT * FROM products WHERE (MATCH (title,short_desc,long_desc,spec_desc,item_no) AGAINST ('rubber')) order by item_no; Can you duplicate my problem? Thank you for a test case - it was exactly what I asked for! But both these queries produce identical one-row results for me. I've tried both 3.23 and 4.0 versions. Isn't your MySQL version too old ? Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
dos prompt help
Okay, got through that NULL problem. Thanks. My next question is regarding using the DOS prompt. At work, I'm using Win2000. When I'm using mySQL, if I want to repeat commands, I can just press the up key without retyping the whole thing. But at home I use Win98. I can't do the same thing, even though I've got doskey running. Is there anyway to get this working under win98? I'm sure there is, but I can't really figure it out. Mark Ward - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Cluster?
I can tell you how we solved this problem. we have a 24/7 op where we need to constantly pull data from mysql machines. This data can be updated at anytime by our tools, but the live servers will only be reading data. So we have one machine which is connected to our tools box, this is where all of our updates go, then we use one way mysql replication to the 2 machines we have in the datacenter. Our app picks one of these at random, if it can't get a connection, it will try the other one. We find that we actually get pretty good load balancing on these machines. We've also been able to turn off one machine to do upgrades and such, and found that we don't suffer any downtime. btw, the machines that are in prod are Sun E250's but the machine that is connected to the tools is a linux box. I don't see any problems doing this with linux hardware, we just prefer sun's for our prod db's. hope this helps.. --shak Barry Roomberg wrote: I'm trying to determine the correct way of dealing with a high availability situation, which might also be a high performance (spread queries across multiple systems) situation. I've googled for MySQL cluster, and found one project that last seems last touched a year ago. 1) All data is readonly. No write requirement except monthly load. 2) We'd rather spend money on hardware and MySQL support than Oracle or some other commercial database. Hardware and MySQL is scalable at a reasonable price, Oracle is not. 3) This will be a 24/7/365 environment, so there can't be any single points of failure. 4) I already have the back end disk, so new purchase there is not an option. Same with network gear and fibre channels. Systems may be purchased, but we'd prefer to reuse current until we have to get more. 5) I can have dual net cards and dual fibre-channel cards in each system, along with 2 net switches and 2 FC switches, to allow full matrix connectivity. 6) I've already proven that the data can be served by MySQL in a rapid fashion, now I need to prove it can be continuous. 1st Goal: Setup 2 systems that share data and allow either to satisfy read requests. Seems like a simple replication to 2 box scenario, with application level handling to go to the live box if 1 is down. Are there any preferred projects that handle the director portion of this? I assume I will have total data duplication on each system, ie: they won't be reading the same disk. 2nd goal: Setup a cluster of systems sharing the same disk (it is a fibrechannel back end). I ASSUME I can read/only mount to a BUNCH of independent systems, which will then serve queries. Simple? Seems so. Can MySQL open a database read-only of a truly read-only file system? The actual performance the disk is capable of providing is far more than MySQL reads for a query, so I should be able to stacka few systems against it before it degrades. There will not be a regular SQL connection to these systems, there will be an application specific deamon handling requests via network pipes, so I don't nead to deal with client side issues (yet). Feel free to point me in a FAQ/Doc direction, I love to read. 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 -- Shakeel Sorathia Systems Administrator (626) 660-3502 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
More info on mysqlbinlog strangeness
I've been using mysqlbinlog to capture a file of inserts/updates/deletes on numerous servers since the early 3.23.x days. I have 3.23.46-max on a pair of servers now though where it is exhibiting some strange behavior. Based on some emailed suggestions I've tried leaving off the -uroot -ppassword parameters and also tried a binary from an older release of MySQL (3.23.39 which works fine on another server with .39 of MySQL running). The server I'm testing on right now has system-bin.001 and system-bin.002 files where I stopped/started the server without a flush. The first file logged basically nothing and I see a rotate to server-bin.002 line when I dump it so the files obviously have internal links to each other (which I didn't know previously). Anyway, the server is 3.23.46-max and I am using InnoDB tables on this server which I am NOT using on any of the other numerous servers which are acting more the way I think they should. Some details: .46 binlog binary without -uroot: Running it against the .001 log file shows the contents of that file only. Does not link to .002 but does give the # prompt back as soon as it finishes. .46 binlog binary with -uroot: Links to .002 and shows me everything logged from both files and hangs and never (waited 5+ minutes) gives back the # prompt. .39 binlog binary without -uroot: Same as .46 version above .39 binlog binary with -uroot: Same as .46 version above but errors and drops back to a # prompt perhaps 2 minutes later. Gives error ERROR: Error reading packet from server: At this point I will experiment with processing the .001, .002, .003 ... files individually in turn without providing the -uroot -ppassword parameters. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: dos prompt help
hum maybe you can cut/paste with the right button of your mouse. this does not work under winNT4, but on my win2k it does, and you could try it on your machine. right click in the screen replaces the ctrl-v used for paste and it automatically cuts any highlighted text (as in mIRC) HTH Etienne Ward, Mark wrote: Okay, got through that NULL problem. Thanks. My next question is regarding using the DOS prompt. At work, I'm using Win2000. When I'm using mySQL, if I want to repeat commands, I can just press the up key without retyping the whole thing. But at home I use Win98. I can't do the same thing, even though I've got doskey running. Is there anyway to get this working under win98? I'm sure there is, but I can't really figure it out. Mark Ward - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problems compiling mysql 3.23.36 on Solaris 8
I have compiled mySql before on Solaris, and never had this problem. On this system, configure goes fine, and make chugs along until the 'sql' directory, at which point the following occurs: gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_CURSES_H -I/export/home/ahrensj/build/mysql-3.23.46/include -DHAVE_RWLOCK_T -o mysqld sql_lex.o item.o item_sum.o item_buff.o item_func.o item_cmpfunc.o item_strfunc.o item_timefunc.o thr_malloc.o item_create.o field.o key.o sql_class.o sql_list.o net_serv.o violite.o net_pkg.o lock.o my_lock.o sql_string.o sql_manager.o sql_map.o mysqld.o password.o hash_filo.o hostname.o convert.o sql_parse.o sql_yacc.o sql_base.o table.o sql_select.o sql_insert.o sql_update.o sql_delete.o procedure.o item_uniq.o sql_test.o log.o log_event.o init.o derror.o sql_acl.o unireg.o time.o opt_range.o opt_sum.o opt_ft.o records.o filesort.o handler.o ha_heap.o ha_myisam.o ha_myisammrg.o ha_berkeley.o ha_innobase.o ha_gemini.o ha_isam.o ha_isammrg.o sql_db.o sql_table.o sql_rename.o sql_crypt.o sql_load.o mf_iocache.o field_conv.o sql_show.o sql_udf.o sql_analyse.o sql_cache.o slave.o sql_repl.o mini_client.o mini_client_errors.o md5.o stacktrace.o -static ../isam/libnisam.a ../merge/libmerge.a ../myisam/libmyisam.a ../myisammrg/libmyisammrg.a ../heap/libheap.a ../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a -ldl -lpthread -lthread -lz -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread ld: fatal: library -ldl: not found ld: fatal: library -lpthread: not found ld: fatal: library -lthread: not found ld: fatal: library -lz: not found ld: fatal: library -lpthread: not found ld: fatal: library -lthread: not found ld: fatal: File processing errors. No output written to mysqld collect2: ld returned 1 exit status make[3]: *** [mysqld] Error 1 make[3]: Leaving directory `/export/home/ahrensj/build/mysql-3.23.46/sql' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory `/export/home/ahrensj/build/mysql-3.23.46/sql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/export/home/ahrensj/build/mysql-3.23.46' make: *** [all-recursive-am] Error 2 I cannot make head or tails of why this error comes up. All the libraries that ld is complaining about are available, either in /usr/lib or (as with pthread) where the mysql make file puts them. I have asked a few other people, and they cannot explain what is going on either. I am using: cc: gcc version 2.95 19990728 (release) ld: ld: Software Generation Utilities - Solaris-ELF (4.0) [Solaris 8 default] make: make: GNU Make version 3.79 Thanks for any help... Jason -- Jason Ahrens, Systems Analyst TELUS Enterprise Solutions http://www.telus.com The Future is Friendly - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
just moved from windows to linux mysql
Hi, I have just setup a dedicated linux/php/mysql dev box in my office and I am gearing up to move my databases from a windows box to the linux box. There are a couple of things I would like to be clear on before I start. 1) when I am logged into linux as user1 and I create a database, does this mean that my username and password for the database will be the same as the linux login, or do you have to set username and password when you are creating the database? 2) can somebody, anybody offer up some links to a quicky tutorial on loading a database with existing data, and backing up an existing database. I don't mean the ones in the mysql manual, I am looking for more of a made for dorks like me version. Thank you in advance _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: porting mysql to ibm os/390 open editionjzawodn@yahoo-inc.com
On Thu, Dec 06, 2001 at 04:30:29AM -0800, Jeremy Zawodny wrote: On Mon, Dec 03, 2001 at 08:01:11PM -0800, Peschko, Edward wrote: hey, I was wondering if you had any plans to port mysql to os-390, and the open edition environment there. I think it would be a really cool idea, considering that most shops that have a IBM mainframe are looking for ways to leverage it in the unix world without spending mega-bucks on IBM proprietary solutions like DB2 If you do find someone running MySQL on Linux on the big iron, I'd love to hear about it. Heck, if GCC, Perl, and Apache can work on it, there's a chance that some hacker at IBM has alredy managed to get MySQL working, too. That'd be excellent. well, technically, its not linux, its omvs... it has its *own* pthreading, c compiler, etc. etc... And I guess that was what I was offering. I've got the environment, don't really have enough info about porting mysql to make it work, have cursory info about automake, etc... If I knew who to contact in IBM, that might make it a lot easier, too... Ed - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: just moved from windows to linux mysql
On Thursday, December 6, 2001, at 02:15 PM, Curtis Gordon wrote: Hi, I have just setup a dedicated linux/php/mysql dev box in my office and I am gearing up to move my databases from a windows box to the linux box. There are a couple of things I would like to be clear on before I start. Good move. 1) when I am logged into linux as user1 and I create a database, does this mean that my username and password for the database will be the same as the linux login, or do you have to set username and password when you are creating the database? Some people are confused by the way MySQL keeps track of users because MySQL also features a user called root (like in Unix/Linux). But be assured that you must create your users in MySQL (using GRANT commands) separate from your Unix/Linux users. For sake of ease, you can use the same names, but you don't have to. If you're in Linux, logged in as User1, you can log in to MySQL as User55 like this: $ bin/mysql -u User55 -p samp_db or you can just let the mysql client program assume that you want to log in to MySQL under the same name as your current Linux username (User1) like this: $ bin/mysql -p samp_db see? Omit the -u argument and the mysql client uses your Unix/Linux username as the MySQL username. Note that the -p flag is optional if you do not have a password set for that particular MySQL account. 2) can somebody, anybody offer up some links to a quicky tutorial on loading a database with existing data, and backing up an existing database. I don't mean the ones in the mysql manual, I am looking for more of a made for dorks like me version. MySQL by Paul DuBois (New Riders). Sorry I don't have a web reference, but this book is very helpful. Erik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Creating MySQL table w/2 primary keys
Hello everyone, I have this create table statement, drop table IF EXISTS GROUP_CONCLUSION_GROUPING CASCADE; CREATE TABLE IF NOT EXISTS GROUP_CONCLUSION_GROUPING( ANALYSIS_RESULT_ID MEDIUMINT(20) PRIMARY KEY REFERENCES PAD_ANALYSIS_RESULT(ANALYSIS_RESULT_ID), GROUP_CONCLUSION_IDMEDIUMINT(20) PRIMARY KEY REFERENCES GROUP_CONCLUSION(GROUP_CONCLUSION_ID) ) Type=InnoDB; where I want to create table with 2 primary keys, but it won't let me. How could I do it. Regards, Oganes Demirchyan Motorola Life Science 757 S.Raymond Pasadena, CA 91105 Tel: 626-584-5900 email: [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: just moved from windows to linux mysql
Just to add a few side notes. We have 2 MySQL's running on a RH/Linux 6.2 box, and it has proven to be very stable and very reliable. :) We have approx., 30+ clients that use the one of the MySQL servers, and we set up each client with a .my.cnf in each of the respective root directories: /home/user_name/.my.cnf so when they login thru the shell, all they need to do is type in at the prompt: $bash mysql and they are logged into their database. We do use their UN*X account username and password, as they find this easier then trying to remember separate username/password or password to access the MySQL client. This has worked very well for us :) On Thu, 6 Dec 2001 14:46:19 -0500, Erik Price [EMAIL PROTECTED] wrote: Good move. 1) when I am logged into linux as user1 and I create a database, does this mean that my username and password for the database will be the same as the linux login, or do you have to set username and password when you are creating the database? Some people are confused by the way MySQL keeps track of users because MySQL also features a user called root (like in Unix/Linux). But be assured that you must create your users in MySQL (using GRANT commands) separate from your Unix/Linux users. For sake of ease, you can use the same names, but you don't have to. If you're in Linux, logged in as User1, you can log in to MySQL as User55 like this: $ bin/mysql -u User55 -p samp_db or you can just let the mysql client program assume that you want to log in to MySQL under the same name as your current Linux username (User1) like this: $ bin/mysql -p samp_db see? Omit the -u argument and the mysql client uses your Unix/Linux username as the MySQL username. Note that the -p flag is optional if you do not have a password set for that particular MySQL account. Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Creating MySQL table w/2 primary keys
As far as I know, you can't do tht. What you could do instead is have one Primary Key col and make another one UNIQUE. I did that several times, and it does work! -- What they need to teach in school is for people to think for themselves. :-) -- Larry Wall in [EMAIL PROTECTED] Demirchyan Oganes-AOD098 wrote: DO: Hello everyone, DO: DO: I have this create table statement, DO: DO: drop table IF EXISTS GROUP_CONCLUSION_GROUPING CASCADE; DO: DO: CREATE TABLE IF NOT EXISTS GROUP_CONCLUSION_GROUPING( DO: ANALYSIS_RESULT_ID MEDIUMINT(20) PRIMARY KEY REFERENCES PAD_ANALYSIS_RESULT(ANALYSIS_RESULT_ID), DO: GROUP_CONCLUSION_IDMEDIUMINT(20) PRIMARY KEY REFERENCES GROUP_CONCLUSION(GROUP_CONCLUSION_ID) DO: ) Type=InnoDB; DO: DO: where I want to create table with 2 primary keys, but it won't let me. DO: DO: How could I do it. DO: DO: Regards, DO: DO: Oganes Demirchyan DO: Motorola Life Science DO: 757 S.Raymond DO: Pasadena, CA 91105 DO: Tel: 626-584-5900 DO: email: [EMAIL PROTECTED] DO: DO: DO: - DO: Before posting, please check: DO:http://www.mysql.com/manual.php (the manual) DO:http://lists.mysql.com/ (the list archive) DO: DO: To request this thread, e-mail [EMAIL PROTECTED] DO: To unsubscribe, e-mail [EMAIL PROTECTED] DO: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php DO: - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: just moved from windows to linux mysql
Thank you Eric and Mike, I really appreciate the help! From: Mike(mickalo)Blezien [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Curtis Gordon [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: just moved from windows to linux mysql Date: Thu, 06 Dec 2001 13:50:52 -0600 Just to add a few side notes. We have 2 MySQL's running on a RH/Linux 6.2 box, and it has proven to be very stable and very reliable. :) We have approx., 30+ clients that use the one of the MySQL servers, and we set up each client with a .my.cnf in each of the respective root directories: /home/user_name/.my.cnf so when they login thru the shell, all they need to do is type in at the prompt: $bash mysql and they are logged into their database. We do use their UN*X account username and password, as they find this easier then trying to remember separate username/password or password to access the MySQL client. This has worked very well for us :) On Thu, 6 Dec 2001 14:46:19 -0500, Erik Price [EMAIL PROTECTED] wrote: Good move. 1) when I am logged into linux as user1 and I create a database, does this mean that my username and password for the database will be the same as the linux login, or do you have to set username and password when you are creating the database? Some people are confused by the way MySQL keeps track of users because MySQL also features a user called root (like in Unix/Linux). But be assured that you must create your users in MySQL (using GRANT commands) separate from your Unix/Linux users. For sake of ease, you can use the same names, but you don't have to. If you're in Linux, logged in as User1, you can log in to MySQL as User55 like this: $ bin/mysql -u User55 -p samp_db or you can just let the mysql client program assume that you want to log in to MySQL under the same name as your current Linux username (User1) like this: $ bin/mysql -p samp_db see? Omit the -u argument and the mysql client uses your Unix/Linux username as the MySQL username. Note that the -p flag is optional if you do not have a password set for that particular MySQL account. Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Creating MySQL table w/2 primary keys
why not use a concatenated Primary key? create table tname col_name1 int, col_name2 int, PRIMARY KEY (col_name1,col_name2) you get the drift On Thu, 6 Dec 2001, sherzodR wrote: As far as I know, you can't do tht. What you could do instead is have one Primary Key col and make another one UNIQUE. I did that several times, and it does work! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: just moved from windows to linux mysql
At 2:46 PM -0500 12/6/01, Erik Price wrote: On Thursday, December 6, 2001, at 02:15 PM, Curtis Gordon wrote: 2) can somebody, anybody offer up some links to a quicky tutorial on loading a database with existing data, and backing up an existing database. I don't mean the ones in the mysql manual, I am looking for more of a made for dorks like me version. MySQL by Paul DuBois (New Riders). Sorry I don't have a web reference, but this book is very helpful. Erik I just happen to have it handy. :-) http://www.kitebird.com/mysql-book/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Packet is Larger than max_allowed_packet from server configuration of 65536 bytes
Hi, I am having a problem with the configuration of the mysql server or client. I have a very large query that I need to send to MySQL from Java. The query has approximately 5000 individual items in the where clause. (i.e. WHERE i!='AP' AND i != 'J3' AND...to 5000). When I try to execute the Query I get the error: Packet is Larger than max_allowed_packet from server configuration of 65536 bytes I read the MySQL documentation and increased my max_allowed_packet to 24M on both the client and the Server in the my.cnf, but I still get the same errorIs there another variable I need to increase, because no matter what I change the value of max_allowed_packet to, I still get the 65535 bytes error?? Please help!! Thanks, Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Creating MySQL table w/2 primary keys
On 6 Dec 2001 [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: * A PRIMARY KEY can be a multiple-column index. However, you cannot create a multiple-column index using the PRIMARY KEY key attibute in a column specification. Doing so will mark only that single column as primary. You must use the PRIMARY KEY(index_col_name, ...) syntax. On Thu, 6 Dec 2001, sherzodR wrote: As far as I know, you can't do tht. What you could do instead is have one Primary Key col and make another one UNIQUE. I did that several times, and it does work! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 can I download berkeley DB 3.2.9a for MySQL 3.23.46 installation?
We are interested in installing MySQL 3.23.46 from source on our Solaris 2.8 machine. However, we could not find berkeley DB 3.2.9a that is required by MySQL package. Does anyone know where to find it? Thanks. Since I am not on this mailing list, please send the reply to [EMAIL PROTECTED] Thanks again, Ziying Sherwin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 can I download berkeley DB 3.2.9a for MySQL 3.23.46 installation?
Ziying Sherwin [EMAIL PROTECTED] writes: We are interested in installing MySQL 3.23.46 from source on our Solaris 2.8 machine. However, we could not find berkeley DB 3.2.9a that is required by MySQL package. Does anyone know where to find it? Thanks. Since I am not on this mailing list, please send the reply to [EMAIL PROTECTED] Newer releases of mysql come with a bundled bdb in a subdir. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: does mysql.sock come with a linux 323 installation
mysql.sock is created by mysqld and deleted when mysqld stops -Original Message- From: David Phoon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 05, 2001 11:31 PM To: [EMAIL PROTECTED] Subject: does mysql.sock come with a linux 323 installation I'd like to know if mysql.sock comes with a linux installation as I have follwed the instructions to install linux but it always says ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) . but mysql.sock does not seem to be anywhere on my linux machine 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: Creating MySQL table w/2 primary keys
using primary key (col1, col2) makes no index on col2... which is not good if you lookup only in col2 primary key (col1), unique index (col2) don't forget to add not null beside your col2 definition. Etienne rc wrote: why not use a concatenated Primary key? create table tname col_name1 int, col_name2 int, PRIMARY KEY (col_name1,col_name2) you get the drift On Thu, 6 Dec 2001, sherzodR wrote: As far as I know, you can't do tht. What you could do instead is have one Primary Key col and make another one UNIQUE. I did that several times, and it does work! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: just moved from windows to linux mysql
http://www.linux-mag.com/2001-03/mysql_01.html There ya go, you can't have it better explained, as for the user access part. For the data transfer, that I don't know Etienne Curtis Gordon wrote: Hi, I have just setup a dedicated linux/php/mysql dev box in my office and I am gearing up to move my databases from a windows box to the linux box. There are a couple of things I would like to be clear on before I start. 1) when I am logged into linux as user1 and I create a database, does this mean that my username and password for the database will be the same as the linux login, or do you have to set username and password when you are creating the database? 2) can somebody, anybody offer up some links to a quicky tutorial on loading a database with existing data, and backing up an existing database. I don't mean the ones in the mysql manual, I am looking for more of a made for dorks like me version. Thank you in advance _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Creating MySQL table w/2 primary keys
I found a way to have two primary key, if those keys relate on many columns. mysql create table keytest( - col1 int not null, - col2 int not null, - unique index (id1,id2), - unique index (id2,id1) Query OK, 0 rows affected (0.01 sec) mysql describe keytest; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | id1 | int(11) | | PRI | 0 | | | id2 | int(11) | | PRI | 0 | | +---+-+--+-+-+---+ 2 rows in set (0.00 sec) here ya go, two primary key. in my app, it's very useful for the tables linking two other tables (two tables are N:N so the middle one links) +-+ +---+ +--+ | users | | userdepts | | depts| +-+ +---+ +--+ | usrID || usrID || deptID | | usrDept | | deptID| | deptName | | usrName | +---+ +--+ +-+ (do you like my relational DB ascii figure? Then when selecting all linked entried, it uses only the index! Since it's only numbers and the indexes for search in each directions are there.. HTH Etienne sherzodR wrote: As far as I know, you can't do tht. What you could do instead is have one Primary Key col and make another one UNIQUE. I did that several times, and it does work! -- What they need to teach in school is for people to think for themselves. :-) -- Larry Wall in [EMAIL PROTECTED] Demirchyan Oganes-AOD098 wrote: DO: Hello everyone, DO: DO: I have this create table statement, DO: DO: drop table IF EXISTS GROUP_CONCLUSION_GROUPING CASCADE; DO: DO: CREATE TABLE IF NOT EXISTS GROUP_CONCLUSION_GROUPING( DO: ANALYSIS_RESULT_ID MEDIUMINT(20) PRIMARY KEY REFERENCES PAD_ANALYSIS_RESULT(ANALYSIS_RESULT_ID), DO: GROUP_CONCLUSION_IDMEDIUMINT(20) PRIMARY KEY REFERENCES GROUP_CONCLUSION(GROUP_CONCLUSION_ID) DO: ) Type=InnoDB; DO: DO: where I want to create table with 2 primary keys, but it won't let me. DO: DO: How could I do it. DO: DO: Regards, DO: DO: Oganes Demirchyan DO: Motorola Life Science DO: 757 S.Raymond DO: Pasadena, CA 91105 DO: Tel: 626-584-5900 DO: email: [EMAIL PROTECTED] DO: DO: DO: - DO: Before posting, please check: DO:http://www.mysql.com/manual.php (the manual) DO:http://lists.mysql.com/ (the list archive) DO: DO: To request this thread, e-mail [EMAIL PROTECTED] DO: To unsubscribe, e-mail [EMAIL PROTECTED] DO: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php DO: - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Creating MySQL table w/2 primary keys (fwd)
for a table in a database (just so my message makes it to the list): can you make a concatenated primary key, then make the second one an index? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 3.23.46 - Redhat 6.2 - cannot connect to server
We're having severe problems here. We've been running 2.23.3 on Redhat 6.2 for a while and all has been well. I've also installed mysql several times with no issues. We had a hard drive go out today, and since then we have not been able to get mysql to successfully start and accept connections. Typing an simple mysqladmin version gives no error message whatsoever. When trying to reinstall and use the latest version, running 'make test' hangs at Installing Master Databases. Though the server does start up, we can't interact with it in any way. If anyone can be of use, please advise. Thanks, -Bart - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: locking specific rows
Hi, I need to implement an access/logging system in mysql+php, which once a user logs in, does not let another individuals log in using the same user-password. I don´t care if users share a user-password, the only thing I want to avoid is that this users sharing the same user-pw combination, don´t acces at the same time. is there a way to lock the row when the user first logs-in I know that it exist table locking, but I only need to lock a specific row when the user is logged in. sorry if I´m not very clear, hope everybody can figure out what I´m trying to do thanx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PASSWORD() question
Hello, I have some usernames and passwords. The passwords have had the PASSWORD() function used on them. I need to set up an area of a site to allow users to have their passwords e-mailed to them. I can't just say SELECT password FROM table WHERE email='$email' AND username='$username' because that will give me a bunch of gibberish. Is there anyway to get the password back into plaintext to be emailed to the user? Thanks, Tyler Longren - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: PASSWORD() question
No - instead, update the password with a new, random one, and e-mail the random one to the user. - Jonathan -Original Message- From: Tyler Longren [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 06, 2001 1:37 PM To: MySQL List Subject: PASSWORD() question Hello, I have some usernames and passwords. The passwords have had the PASSWORD() function used on them. I need to set up an area of a site to allow users to have their passwords e-mailed to them. I can't just say SELECT password FROM table WHERE email='$email' AND username='$username' because that will give me a bunch of gibberish. Is there anyway to get the password back into plaintext to be emailed to the user? Thanks, Tyler Longren - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Creating MySQL table w/2 primary keys
Hi, That may have the desired effect of two unique keys, but you stil only have one primary key (probably id1,id2). PRI is listed against each column involved in the Primary key. Regards Quentin -Original Message- From: Etienne Marcotte [mailto:[EMAIL PROTECTED]] Sent: Friday, 7 December 2001 9:42 a.m. To: sherzodR Cc: Demirchyan Oganes-AOD098; '[EMAIL PROTECTED]' Subject: Re: Creating MySQL table w/2 primary keys I found a way to have two primary key, if those keys relate on many columns. mysql create table keytest( - col1 int not null, - col2 int not null, - unique index (id1,id2), - unique index (id2,id1) Query OK, 0 rows affected (0.01 sec) mysql describe keytest; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | id1 | int(11) | | PRI | 0 | | | id2 | int(11) | | PRI | 0 | | +---+-+--+-+-+---+ 2 rows in set (0.00 sec) here ya go, two primary key. in my app, it's very useful for the tables linking two other tables (two tables are N:N so the middle one links) +-+ +---+ +--+ | users | | userdepts | | depts| +-+ +---+ +--+ | usrID || usrID || deptID | | usrDept | | deptID| | deptName | | usrName | +---+ +--+ +-+ (do you like my relational DB ascii figure? Then when selecting all linked entried, it uses only the index! Since it's only numbers and the indexes for search in each directions are there.. HTH Etienne sherzodR wrote: As far as I know, you can't do tht. What you could do instead is have one Primary Key col and make another one UNIQUE. I did that several times, and it does work! -- What they need to teach in school is for people to think for themselves. :-) -- Larry Wall in [EMAIL PROTECTED] Demirchyan Oganes-AOD098 wrote: DO: Hello everyone, DO: DO: I have this create table statement, DO: DO: drop table IF EXISTS GROUP_CONCLUSION_GROUPING CASCADE; DO: DO: CREATE TABLE IF NOT EXISTS GROUP_CONCLUSION_GROUPING( DO: ANALYSIS_RESULT_ID MEDIUMINT(20) PRIMARY KEY REFERENCES PAD_ANALYSIS_RESULT(ANALYSIS_RESULT_ID), DO: GROUP_CONCLUSION_IDMEDIUMINT(20) PRIMARY KEY REFERENCES GROUP_CONCLUSION(GROUP_CONCLUSION_ID) DO: ) Type=InnoDB; DO: DO: where I want to create table with 2 primary keys, but it won't let me. DO: DO: How could I do it. DO: DO: Regards, DO: DO: Oganes Demirchyan DO: Motorola Life Science DO: 757 S.Raymond DO: Pasadena, CA 91105 DO: Tel: 626-584-5900 DO: email: [EMAIL PROTECTED] DO: DO: DO: - DO: Before posting, please check: DO:http://www.mysql.com/manual.php (the manual) DO:http://lists.mysql.com/ (the list archive) DO: DO: To request this thread, e-mail [EMAIL PROTECTED] DO: To unsubscribe, e-mail [EMAIL PROTECTED] DO: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php DO: - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: locking specific rows
Hi What about a table with logged in user ids and a timestamp (I use a sessions table). Update the timestamp when they access the system. Check when a user tries to login. If that user id, but a different person, has accessed the system within the last xx minutes or seconds then consider them logged in and deny the second user. You need to deal with browser crashes and such, but it works otherwise. email me off list if you want the table structure and php code HTH Peter -Original Message- From: Walter D. Funk [mailto:[EMAIL PROTECTED]] Sent: 06 December 2001 21:31 To: [EMAIL PROTECTED] Subject: Fw: locking specific rows Hi, I need to implement an access/logging system in mysql+php, which once a user logs in, does not let another individuals log in using the same user-password. I don´t care if users share a user-password, the only thing I want to avoid is that this users sharing the same user-pw combination, don´t acces at the same time. is there a way to lock the row when the user first logs-in I know that it exist table locking, but I only need to lock a specific row when the user is logged in. sorry if I´m not very clear, hope everybody can figure out what I´m trying to do thanx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
MYSQL time and system time differs
Hi, I get difference of 15 hours when i issue select sysdate(); command on mysql prompt and date command on bash shell. I am using cobalt linux. I change system time from server interface control panel. Can anyone tell me what would be the problem. My time format is ICT. I changed my format to UTC then it gave me 7 hours difference. Thanking You, Paurin Dalal _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
removing PACK_KEYS
HELP PLEASE !! I have run into a problem where my ISP upgraded their mysql version, and now the dump files (.sql) from the mysqldump command cannot be restored on my local server. Unfortunately, I have to wait for our server to be updated, so the simplest solution is not an option. The error that I have been receiving is as follows: ERROR 1064 at line 12: You have an error in your SQL syntax near 'PACK_KEYS=1' at line 11 Dump file excerpt: DROP TABLE IF EXISTS Advertisers; CREATE TABLE Advertisers ( AdvertisersKey smallint(5) unsigned NOT NULL auto_increment, AdvertiserID int(11) NOT NULL default '0', Advertiser char(50) NOT NULL default '', AdvertiserFr char(50) default NULL, AdvertDescr char(250) default NULL, PRIMARY KEY (AdvertisersKey), UNIQUE KEY AdvertiserID (AdvertiserID), KEY IdxAdvert (Advertiser(10)), UNIQUE KEY Advertiser (Advertiser) ) TYPE=ISAM PACK_KEYS=1; Cmd used to create sql: mysqldump --user=username --add-drop-table -pblahblah dbdatabasenamefilename.sql Cmd used to restore from sql: mysql --user=root -p backupdatabasenamefilename.sql It has been suggested that I use: ALTER TABLE Advertisers PACK_KEYS=0; I have done this, however I receive the same error, at the same line location, so the PACK_KEYS value is not an issue. The ISP's version of mysql is 3.23.43. My version is 3.22.32. I know this is a very old version, but as I've said, I cannot upgrade it at this time. This problem is taking a lot of time to fix, and work is getting put off trying to solve it. Is there anyone who has a solution? Steve Osborne Database Programmer Chinook Multimedia Inc. [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: Why can't I get SORT BY to work with FULLTEXT?
But both these queries produce identical one-row results for me. I've tried both 3.23 and 4.0 versions. Isn't your MySQL version too old ? Thanks -- sorry for being a pest! I was using a beta 3.23 version -- I upgraded and it is fixed. ... a lesson learned :-( -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
sort_buffer size
Hi all, We have a system in place that is a LAMP application. The system we have it running on is a FreeBSD 4.3 on a Pentium 3 1Ghz with 500MB of RAM. A mysqladmin -i5 stat returns: Uptime: 44254 Threads: 24 Questions: 779657 Slow queries: 531 Opens: 213 Flush tables: 1 Open tables: 207 Queries per second avg: 17.618 We have a sort_buffer of 32M! Is this to big? Does anyone have any recommendations of what size it should be? Drew. Andrew Toussaint Richardson-Shaw Pty Ltd [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: removing PACK_KEYS
Pack keys is the only flag that we had trouble with when we were upgrading. As an emergency fix you could use the following to restore: sed -e s/PACK_KEYS=1//g filename.sql | mysql --user=root -p backupdatabasename Jon Gardiner. -Original Message- From: Steve Osborne [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 06, 2001 4:01 PM To: MySQL (E-mail) Subject: removing PACK_KEYS HELP PLEASE !! I have run into a problem where my ISP upgraded their mysql version, and now the dump files (.sql) from the mysqldump command cannot be restored on my local server. Unfortunately, I have to wait for our server to be updated, so the simplest solution is not an option. The error that I have been receiving is as follows: ERROR 1064 at line 12: You have an error in your SQL syntax near 'PACK_KEYS=1' at line 11 Dump file excerpt: DROP TABLE IF EXISTS Advertisers; CREATE TABLE Advertisers ( AdvertisersKey smallint(5) unsigned NOT NULL auto_increment, AdvertiserID int(11) NOT NULL default '0', Advertiser char(50) NOT NULL default '', AdvertiserFr char(50) default NULL, AdvertDescr char(250) default NULL, PRIMARY KEY (AdvertisersKey), UNIQUE KEY AdvertiserID (AdvertiserID), KEY IdxAdvert (Advertiser(10)), UNIQUE KEY Advertiser (Advertiser) ) TYPE=ISAM PACK_KEYS=1; Cmd used to create sql: mysqldump --user=username --add-drop-table -pblahblah dbdatabasenamefilename.sql Cmd used to restore from sql: mysql --user=root -p backupdatabasenamefilename.sql It has been suggested that I use: ALTER TABLE Advertisers PACK_KEYS=0; I have done this, however I receive the same error, at the same line location, so the PACK_KEYS value is not an issue. The ISP's version of mysql is 3.23.43. My version is 3.22.32. I know this is a very old version, but as I've said, I cannot upgrade it at this time. This problem is taking a lot of time to fix, and work is getting put off trying to solve it. Is there anyone who has a solution? Steve Osborne Database Programmer Chinook Multimedia Inc. [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: are my queries bloated?
I haven't populated this database yet. There are actually many more columns, this was kind of a rough draft -- I only featured the ones that I needed to see if my JOINs were okay. I just got a little nervous when I drafted a few sample queries and saw that much text !! That makes me feel much relieved, thanks Rodney. I suppose there's nothing wrong after all but, it seemed like a lot of joins (more than I see in other examples). I guess I will get started with the PHP !!! -- Erik On Thursday, December 6, 2001, at 06:05 PM, Rodney Broom wrote: What you've got looks fine to me. Joins like this are not uncommon at all. I wonder, where is your concern with this? Is it in how much text you've typed to create a query, or is the query itself actually running slowly? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Linux vs. Sun and getting Linux to behave like Sun
Greetings everyone: I've noticed that when mySQL runs on Sun Solaris (6, 7, and 8) there will be two processes running (safe_mysqld and mysqld). And this number of processes running will very rarely change, if at all, without concern over the number of connections or how heavily mySQL is being utilized. On Linux there appears to be a correlation to the number of mysqld processes and how heavily mySQL is being hit (connections, queries, etc.). Questions: 1. Are my observations correct? 2. Is there a way to compile mySQL on Linux so that it behaves like on Sun where by there is the safe_mysqld and mysqld process only no matter the activity? If so, how? Thank you. Peter M. Perchansky, President/CEO Dynamic Net, Inc. Helping companies do business on the Net 420 Park Road; Suite 201 Wyomissing PA 19610 Non-Toll Free: 1-610-736-3795 Personal Email: [EMAIL PROTECTED] Company Email: [EMAIL PROTECTED] Web:http://www.dynamicnet.net/ http://www.manageddedicatedservers.com/ http://www.wemanageservers.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: Linux vs. Sun and getting Linux to behave like Sun
Linux creates each new thread as a whole new process ID, where as Solaris creates each new thread within the same process ID. If you ps -aefL | fgrep mysql (on your Solaris box) you will see the individual threads. I've found MySQL is extremely faster in Linux compared to Solaris..so I wouldn't suggest trying to mess with linux. nickg -Original Message- From: Peter M. Perchansky [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 06, 2001 5:31 PM To: [EMAIL PROTECTED] Subject: Linux vs. Sun and getting Linux to behave like Sun Greetings everyone: I've noticed that when mySQL runs on Sun Solaris (6, 7, and 8) there will be two processes running (safe_mysqld and mysqld). And this number of processes running will very rarely change, if at all, without concern over the number of connections or how heavily mySQL is being utilized. On Linux there appears to be a correlation to the number of mysqld processes and how heavily mySQL is being hit (connections, queries, etc.). Questions: 1. Are my observations correct? 2. Is there a way to compile mySQL on Linux so that it behaves like on Sun where by there is the safe_mysqld and mysqld process only no matter the activity? If so, how? Thank you. Peter M. Perchansky, President/CEO Dynamic Net, Inc. Helping companies do business on the Net 420 Park Road; Suite 201 Wyomissing PA 19610 Non-Toll Free: 1-610-736-3795 Personal Email: [EMAIL PROTECTED] Company Email: [EMAIL PROTECTED] Web:http://www.dynamicnet.net/ http://www.manageddedicatedservers.com/ http://www.wemanageservers.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Linux vs. Sun and getting Linux to behave like Sun
they're both behaving similarly, it's just that linux's implementation and display of threads is different than solaris'. the same correlation of threads for connections is there on solaris, you just won't see it on a ps command's output. -tcl. On Thu, 6 Dec 2001, Peter M. Perchansky wrote: Greetings everyone: I've noticed that when mySQL runs on Sun Solaris (6, 7, and 8) there will be two processes running (safe_mysqld and mysqld). And this number of processes running will very rarely change, if at all, without concern over the number of connections or how heavily mySQL is being utilized. On Linux there appears to be a correlation to the number of mysqld processes and how heavily mySQL is being hit (connections, queries, etc.). Questions: 1.Are my observations correct? 2.Is there a way to compile mySQL on Linux so that it behaves like on Sun where by there is the safe_mysqld and mysqld process only no matter the activity? If so, how? Thank you. Peter M. Perchansky, President/CEO Dynamic Net, Inc. Helping companies do business on the Net 420 Park Road; Suite 201 Wyomissing PA 19610 Non-Toll Free:1-610-736-3795 Personal Email: [EMAIL PROTECTED] Company Email:[EMAIL PROTECTED] Web: http://www.dynamicnet.net/ http://www.manageddedicatedservers.com/ http://www.wemanageservers.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Symbolically linked database, unknown database problem.
I've created databases on a partition without problems, now I come to create a new database on a different partition and I can't access the database at all. At this stage I have the following in the mysql data directory (among others): lrwxrwxrwx1 mysqlmysql 17 Sep 3 11:56 candi - /asp/mysql/candi/ lrwxrwxrwx1 mysqlmysql 24 Dec 7 12:40 cc - /home/fastbase/cc/mysql/ The first database (candi) is fine (along with others in the /asp/mysql path) but the cc database is not accessible. If I log-in as user mysql I can access that directory fine so I thought it may be another problem but I guess rights may still be an issue. Any ideas? What are the rules/requirements for mysql to recognise the database directory? I haven't created any tables yet (as I can't access the database). Peter Campbell http://www.fastbase.co.nz Phone NZ 04 385 2230, Fax 04 385 2224. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
OT mail_to_db.pl to ReRoute Misdirected Mail
Greetings: Over the past weekend I pulled a server off-line and about a hundred messages got misrouted to the postmaster. Has anyone ever used the mysql perl scripts for mail to manipulate mail messages for rerouting? I'd like to strip all the administrative notices from the messages and have them forwarded off to their proper owners brand new. Any other scripts that solve the same problem would be helpful. TIA. Regards, Van -- = Linux rocks!!! http://www.dedserius.com/ = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: sort_buffer size
Hi Drew, - Original Message - From: Drew Toussaint [EMAIL PROTECTED] We have a system in place that is a LAMP application. The system we have it running on is a FreeBSD 4.3 on a Pentium 3 1Ghz with 500MB of RAM. A mysqladmin -i5 stat returns: Uptime: 44254 Threads: 24 Questions: 779657 Slow queries: 531 Opens: 213 Flush tables: 1 Open tables: 207 Queries per second avg: 17.618 We have a sort_buffer of 32M! Is this to big? Does anyone have any recommendations of what size it should be? sort_buffer is allocated per thread: memory required for sort_buffer = threads * sort_buffer, so 24 * 32 = 768 MB. Already more than your RAM (and that's without any of the other memory requirements!), plus I'm guessing that 24 threads is not your peak load. Basically, the same rules would apply to sort_buffer as they would for record_buffer, and I know you've got notes for that one ;-) The setting shouldn't necessarily be exactly the same, but similar considerations apply. Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia ___/ 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
MERGE TABLE limitations
Other than a horrendous number of file descriptors, what other performance issues should one be worried about when using merge tables? Is there an upper limit on the number of tables one can use in generating a merge table? Please send a copy to [EMAIL PROTECTED] as I am not a subscriber. -- [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