Re: Replication priority / speed
MyTOP says this particular slave has been up 47 days, 2 hours... It's had 56M queries, of those 4,559 were slow... Not being a MySQL expert, I'm not sure how to get slow queries/hour directly from MySQL. You would use SHOW STATUS, but mytop did it for you :-) Do you mean using a load balancer accross all the slaves? That would defeat the purpose of having a local slave on each web server-- that purpose being to return results as quickly as possible (network traffic is expensive compaired to local disk)... It's a design choice. Personally I prefer to load-balance across multiple boxes as it gives me the fail-over protection and umm... load balancing :-) Obviously local disk will always be faster than TCP/IP (MySQL AB claims 30% faster), but chances are your users won't see a difference if your LAN is any decent. However fail-over load-balancing is a big benefit of such a set up. Have you tried enabling DELAY_KEY_WRITE on the 4 tables that your bulk-loader updates? I'm using DELAY_KEY_WRITE on my slaves... I didn't know it, but I just looked and it says ON in 'show variables';... When looking through the docs on this, I also found low_priority_updates, which I could set on the slaves-- would this help? You must set DELAY_KEY_WRITE on each of the four tables: ALTER TABLE table_name DELAY_KEY_WRITE=1 You could certainly try low_priority_updates, although it is possible that it will make even harder for your slave to catch-up with master's binlog. This function delays your updates until no more clients are reading from the table. Please note that there was a bug in low_priority_updates that wasn't fixed until 3.23.40. Why not modify your software so that it doesn't read from the slave while your bulk-loader runs? The bulk load can happen on any web server, how would it notify the others? Do you need to notify the others? You say that you are using a local slave on each webserver. In that case, you'd simply have the server read the data from master while the bulk load occurs. Or you could create an agent process that would watch for bulk loading on all web servers. RedHat 6.2 on i386, stock RPM install of MySQL-3.23.36-1... The only options we set up on the slaves are to connect to the master-- everything else is stock... If you are using a stock distribution, then there are many optimizations that you could implement to increase the performance. You should really review: http://www.mysql.com/doc/en/MySQL_Optimisation.html Why don't you try to upgrade to the latest MySQL 3.23.54a. I don't know about 3.23.36, but I know that replication was buggy. Also, feel free to send me the remaining info: 1. How much RAM do you have in your master slaves? 2. Perform 'SHOW VARIABLES' and 'SHOW STATUS' queries on the master slaves and send me the output. Simon Grabowski GetResponse.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: Is the Max edition of 4.0.7 required if running on a server with RAID?
Is the Max edition of 4.0.7 necessary for a server with RAID. Or can the standara edition be used? By 'a server with RAID' you likely mean a server with a hardware RAID array. In that case you can use any distribution. This is totally independent of MySQL. Your only concern is to make your operating system see the RAID array. Once it does, it will work fine with MySQL. Simon Grabowski GetResponse.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
How to use HANDLER statement with primary key ?
Hi, I'm trying to use to following HANDLER syntax : HANDLER tbl_name READ index_name=(value1); However I fail since I don't know what is 'index_name' for a PRIMARY KEY (I already tried PRIMARY, `PRIMARY KEY`, and the column name without success). Any idea ? BTW, are HANDLER statements cached by the query cache ? Thanks and regards, Jocelyn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: An Idea
David, Oh, to be sure. And maybe we could even get the mysql.com folks to prominently list a pointer to the off-site FAQ if they don't want to maintain it or give out accounts to maintain it. I just wouldn't want to see it dropped if they don't jump on it at the start. I agree. Will you set it up at http://justpickone.org/? (BTW, I like your website, especially the PIX :-) Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: David T-G [EMAIL PROTECTED] To: mysql users [EMAIL PROTECTED] Cc: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 1:35 AM Subject: Re: An Idea -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan -- ...and then Stefan Hinz, iConnect (Berlin) said... % % David, % % regarding the MySQL FAQ: % % Why should it have to be there? Let anyone with a site set it up and ... % % MySQL.com would be the natural place for the FAQ. Any other place % wouldn't be half as good. Oh, to be sure. And maybe we could even get the mysql.com folks to prominently list a pointer to the off-site FAQ if they don't want to maintain it or give out accounts to maintain it. I just wouldn't want to see it dropped if they don't jump on it at the start. HAND Happy New Year mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+EjfnGb7uCXufRwARAvWNAJ9GWPaZm2tjJh4pdQNNG7EV9cdxLACdGWpV tC44gsIMkjgUkNtZlkpZ+Y0= =XS30 -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: An Idea
James, something that can be based upon pages of htm and emails that exists, and that can sit under a few web pages using Htdig or alkaline or something... Do these tools work better that the search tool (Mnogo search) at http://lists.mysql.com/php/search.php? This thing sucks - I was looking for mysql_fix_privilege_tables, and it found nothing! Guten Rutsch Danke, Dir auch! Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: JamesD [EMAIL PROTECTED] To: David T-G [EMAIL PROTECTED]; mysql users [EMAIL PROTECTED] Cc: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 5:11 AM Subject: RE: An Idea we find people just like to ask questions, and no matter how good our FAQ's and help are, many people have circumstances that make it more efficient to push the question into the queue, and wait for an answer to pop back later. lists work, and faq's work, some like to call...etc. personally, I'd prefer a search engine style... like google, but only for mySQL topics, and with a visible list of most popular search terms. something that can be based upon pages of htm and emails that exists, and that can sit under a few web pages using Htdig or alkaline or something... Guten Rutsch Jim -Original Message- From: David T-G [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 31, 2002 4:36 PM To: mysql users Cc: Stefan Hinz, iConnect (Berlin) Subject: Re: An Idea -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan -- ...and then Stefan Hinz, iConnect (Berlin) said... % % David, % % regarding the MySQL FAQ: % % Why should it have to be there? Let anyone with a site set it up and ... % % MySQL.com would be the natural place for the FAQ. Any other place % wouldn't be half as good. Oh, to be sure. And maybe we could even get the mysql.com folks to prominently list a pointer to the off-site FAQ if they don't want to maintain it or give out accounts to maintain it. I just wouldn't want to see it dropped if they don't jump on it at the start. HAND Happy New Year mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+EjfnGb7uCXufRwARAvWNAJ9GWPaZm2tjJh4pdQNNG7EV9cdxLACdGWpV tC44gsIMkjgUkNtZlkpZ+Y0= =XS30 -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: load data local infile
Terence, Rich, I have tried: LOAD DATA LOCAL INFILE lcopen1.txt INTO TABLE lcopen; but it shows: ERROR 1148: The used command is not allowed with this MySQL version This is because of security issues, as the manual says: In MySQL 3.23.49 and MySQL 4.0.2, we added some new options to deal with possible security issues when it comes to LOAD DATA LOCAL. [snip] If you don't configure MySQL with --enable-local-infile, then LOAD DATA LOCAL will be disabled by all clients, unless one calls mysql_options(... MYSQL_OPT_LOCAL_INFILE, 0) in the client. [snip] For the mysql command-line client, LOAD DATA LOCAL can be enabled by specifying the option -- local-infile[=1], or disabled with --local-infile=0. Full text: http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html I use 4.0.7-max-nt on a Win2K box, and whatever I do, I cannot use LOAD DATA LOCAL (keep getting error 1148). I tried: - Starting the server with --local-infile=1, and once more with --local-infile. - Starting the mysql client with --local-infile[=1] - Combining server and client options The manual page on this is quite contradictory. I agree with the user comment on that manual page: I just wasted 3 hours of my time tracking down this annoying security improvement -- thanks but no thanks, MySQL developers. This was poorly thought out and poorly implemented. Any hints how to make LOAD DATA LOCAL work? Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: rich allen [EMAIL PROTECTED] To: Terence Ng [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 6:23 AM Subject: Re: load data local infile sound like you may want to add the following to your my.cnf file for MySQL [mysqld] local-infile=1 [mysql] local-infile=1 - hcir On Tuesday, December 31, 2002, at 06:23 PM, Terence Ng wrote: Hi, I have just upgraded to 3.23.54 How to input bulk data into table? I have tried: LOAD DATA LOCAL INFILE lcopen1.txt INTO TABLE lcopen; but it shows: ERROR 1148: The used command is not allowed with this MySQL version How come? What method can I use to input bulk data? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: FAQ hosting site (was Re: An Idea)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan, et al -- ...and then Stefan Hinz, iConnect (Berlin) said... % % David, % % see it dropped if they don't jump on it at the start. % % I agree. Will you set it up at http://justpickone.org/? (BTW, I like Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp (I wish we could sftp without then also having ssh; darn) and, meanwhile, it seems like this should be the sort of thing where we could either use CVS or a web update form or the like... Maybe a wiki will do for now, but I don't like only being able to get at it from the web :-) Anyone have any thoughts? % your website, especially the PIX :-) Thanks! :-) It needs an overhaul, but it gets the job done. % % Regards, % -- % Stefan Hinz [EMAIL PROTECTED] % Geschäftsführer / CEO iConnect GmbH http://iConnect.de % Heesestr. 6, 12169 Berlin (Germany) % Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 HTH HAND HNY :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+EwVbGb7uCXufRwARAmHWAJ9j2Zd/syBro07AQ5hj0n7lAeeFMACfYch+ QFYwxXNLMvUSbTYxxp2JQOE= =g9Q2 -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: SQL Lists comment
To the MySQL group!Happy 2003 and have a safe holiday season... Hopefully this got past the filter LOL Chuck - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to get the sum of rows in 2 tables ?
Hello and hope that everybody on this list will pass a wonderful 2003 year, Here's my worry: I have 3 tables, one for genre, one for html and one for shockwave html and shockwave have a foreign key genreID I want to count for each genre how many html and shockwave entries have the same genreID, so I can have as a result : genreID ! nbgenre 1 ! 6 2 ! 2 3 ! 8 where for exemple genreID 1 has 4 html and 2 shockwave entries. Here's one query I've tested and that doesn't return the addition of html and shockwave entries, but their multiplication !!!?? (in the exemple I obtain for genbreID 1 = 4 * 2 = 8 instead of 6) $query = SELECT COUNT(*) as nbgenre, g.intitule, g.genreID FROM genre g, html h, shockwave s WHERE g.genreID = s.genreID AND g.genreID = h.genreID GROUP BY g.intitule, g.genreID ORDER BY nbgenre DESC, g.intitule I've tried using LEFT JOIN from exemples on the web, but I don't have enough experience in SQL to use them correctly in my own queries, and I am not sure it would solve the problem or if it's just another way of obtaining the same (wrong) result. Cheers, Damien - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
join help: i am lost
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, all -- I need, I think, some pointers to basic JOIN tutorials. I don't really know how to approach this query. I should say early on that I don't expect the list to write my code for me, though any help anyone can send is VERY much appreciated; rather, I don't even know where to look to do the required reading :-) I have a schedule table that looks like create table schedule ( # ID number id smallint not null default 0 auto_increment primary key , class smallint not null , # references classtypes.id client smallint not null , # references client.id instr smallint not null , # references personnel.id place smallint not null , # references places.id timeslot datetime not null ,# when #unique (timeslot,client) , # no double-bookings #unique (timeslot,instr) , # no double-bookings index (timeslot,client) , # no double-bookings index (timeslot,instr) ,# no double-bookings index (timeslot,place) ,# cannot be unique 'cuz of group classes cancelled datetime not null # cancelled? when? ) ; that holds my bookings. Classes can be either private (one client) or group (some number N, though perhaps only 1 client will sign up). I started out, as you can see, with unique indexes for the client and instructor, but since I had the brilliant idea of creating some N rows for a group class, all with empty client fields, that doesn't work. I'm not so worried about that; it just means that I'm going to have to do some work on my own to ensure no double-bookings (except for a group class). [OK, so maybe it wasn't that brilliant; better approaches will be heard with avid interest. But it worked in my *head*! :-] Then I had the idea of using client id '0', which will never occur in the client table (create table clients ( id smallint unsigned not null default 0 auto_increment primary key , ...);), as a way to black out a time slot so that the instructor can be guaranteed a lunch break or so. That's where my problem really came up. Thinking at first only of an instructor and single clients I came up with (deep breath) select substring(s.timeslot,1,13) , concat(c.fname,' ',c.lname) from personnel as i , clients as c , schedule as s where i.id = s.instr and c.id = s.client and i.fname = 'penelope' order by timeslot; which gives me a lovely ++-+ | substring(s.timeslot,1,13) | concat(c.fname,' ',c.lname) | ++-+ | 2002-12-27 06 | david t-g | | 2002-12-27 07 | david t-g | | 2002-12-27 10 | david t-g | | 2002-12-27 11 | harmon | | 2002-12-27 13 | larry thorburn | ++-+ and I write my table in php without a second thought. Then, however, comes the mess of pulling out any records where the client id is 0; for every timeslot like that, I get a row for each client in the clients table! Here's where I'm really swamped. I can write a separate query for schedule records where the client is 0, and I can write a separate query for schedule records where the class is not private, but how can I combine all three to get one lovely result to use to build my table? TIA HAND Happy New Year mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+ExYNGb7uCXufRwARAp0EAJ9a5C3emiflZGtuiXPOcWnMJo7iXQCeKVMw 0w2kNXILUltbWs/rxUwG22E= =kYIn -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Search Engine (text search) like functionality...need to build
Hello All, I have a need to build some user functionality (text search) that is similar to the search functions available in most search engines. I would like to have users input a search string and find the appropriate records in MySql, for example: database software development linux Part of the difficulty I am having is how to handle the pieces of text to search with. A simple parse of the data would break apart the text inside the double quotes. My intent was to capture the search string in a PHP form, but I am unsure where to go to from there. Any thoughts on how to approach this would be 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: join help: i am lost
David, I am unsure if I followed your example completely, but maybe this might help. Not knowing your complete database structure, I am unsure if my comments will be entirely valid but here goes. I think you could achieve your goal if you think of your groups as containing one or many clients. Each single client would be in a group of their own. Yes, this is a little strange, but it makes the structure a lot easier and consistent. So this is what you would have: Time slot -- class -- group -- client So the structure, in english: Each time slot has a one-to-many relationship to classes Each class has a one-to-many relationship to groups Each group has a one-to-many relationship to clients Now, you can query the database and see how many time slots have more than one class. You no longer need to worry about double booking. Hope this helps At 11:23 AM 1/1/03 -0500, David T-G wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, all -- I need, I think, some pointers to basic JOIN tutorials. I don't really know how to approach this query. I should say early on that I don't expect the list to write my code for me, though any help anyone can send is VERY much appreciated; rather, I don't even know where to look to do the required reading :-) I have a schedule table that looks like create table schedule ( # ID number id smallint not null default 0 auto_increment primary key , class smallint not null , # references classtypes.id client smallint not null , # references client.id instr smallint not null , # references personnel.id place smallint not null , # references places.id timeslot datetime not null ,# when #unique (timeslot,client) , # no double-bookings #unique (timeslot,instr) , # no double-bookings index (timeslot,client) , # no double-bookings index (timeslot,instr) ,# no double-bookings index (timeslot,place) ,# cannot be unique 'cuz of group classes cancelled datetime not null # cancelled? when? ) ; that holds my bookings. Classes can be either private (one client) or group (some number N, though perhaps only 1 client will sign up). I started out, as you can see, with unique indexes for the client and instructor, but since I had the brilliant idea of creating some N rows for a group class, all with empty client fields, that doesn't work. I'm not so worried about that; it just means that I'm going to have to do some work on my own to ensure no double-bookings (except for a group class). [OK, so maybe it wasn't that brilliant; better approaches will be heard with avid interest. But it worked in my *head*! :-] Then I had the idea of using client id '0', which will never occur in the client table (create table clients ( id smallint unsigned not null default 0 auto_increment primary key , ...);), as a way to black out a time slot so that the instructor can be guaranteed a lunch break or so. That's where my problem really came up. Thinking at first only of an instructor and single clients I came up with (deep breath) select substring(s.timeslot,1,13) , concat(c.fname,' ',c.lname) from personnel as i , clients as c , schedule as s where i.id = s.instr and c.id = s.client and i.fname = 'penelope' order by timeslot; which gives me a lovely ++-+ | substring(s.timeslot,1,13) | concat(c.fname,' ',c.lname) | ++-+ | 2002-12-27 06 | david t-g | | 2002-12-27 07 | david t-g | | 2002-12-27 10 | david t-g | | 2002-12-27 11 | harmon | | 2002-12-27 13 | larry thorburn | ++-+ and I write my table in php without a second thought. Then, however, comes the mess of pulling out any records where the client id is 0; for every timeslot like that, I get a row for each client in the clients table! Here's where I'm really swamped. I can write a separate query for schedule records where the client is 0, and I can write a separate query for schedule records where the class is not private, but how can I combine all three to get one lovely result to use to build my table? TIA HAND Happy New Year mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+ExYNGb7uCXufRwARAp0EAJ9a5C3emiflZGtuiXPOcWnMJo7iXQCeKVMw 0w2kNXILUltbWs/rxUwG22E= =kYIn -END PGP SIGNATURE- - Before posting, please
Re: join help: i am lost
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Frank, et al -- ...and then Frank Peavy said... % % David, % I am unsure if I followed your example completely, but maybe this might % help. Not knowing your complete database structure, I am unsure if my % comments will be entirely valid but here goes. I didn't want to throw the whole thing to the list; I thought that might be considered rude :-) % % I think you could achieve your goal if you think of your groups as Hmmm... You mean like a group class? % containing one or many clients. Each single client would be in a group of % their own. Yes, this is a little strange, but it makes the structure a lot Not necessarily; I already think of a private instruction as basically the same as a group instruction except only one slot. I don't know that I've managed to *write* the schema that way, but that's how it's in my head ;-) % easier and consistent. So this is what you would have: % % Time slot -- class -- group -- client % % So the structure, in english: % Each time slot has a one-to-many relationship to classes % Each class has a one-to-many relationship to groups % Each group has a one-to-many relationship to clients Here's where I'm not sure how to make that fit -- probably just because of my own terminology. A scheduling, or a booking, eventually has to have a class type (private or one of many groups -- so I suppose I could simply make a group class type 'private' and that type has only one slot), an instructor, a place, a time slot, and the client or clients to go in it. I currently have a clients table, a classtypes table (various types of group classes), a personnel table (instructors), a places table (what room), and a schedule table (drawing from each of these plus a timeslot field). When I have a private classs I just leave the classtype empty (but I'm open to change). If I get you right, I'd have a class table pulling together the type of class (one of the typical group classes or this new 'private' one) and, somehow, the client(s) enrolled, and then the schedule table need only have the class instantiation (which doesn't yet make sense without a timestamp; I don't get it), the instructor, and the time slot 'cuz the location (maybe), the type, and the clients in it are set in the class table. First, I wonder if I successfully followed you :-) Second, though, I don't get how I can have some clients in a class table when the class hasn't been assigned a time slot; how can the clients avoid collisions? % % Now, you can query the database and see how many time slots have more than % one class. % You no longer need to worry about double booking. Because I can come back to an unique index, you mean, perhaps? % % Hope this helps It's a start; thanks a bunch! HAND HNY :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+EykaGb7uCXufRwARAi6CAJ9ACpgYWfWhHSaaLRBitc5bHL7tZgCfceL9 KTGOGwF4KfWPUNVSrLcYlEw= =+giV -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: join help: i am lost
David, Just some thoughts.. See my comments below... A scheduling, or a booking, eventually has to have a class type (private or one of many groups -- so I suppose I could simply make a group class type 'private' and that type has only one slot), an instructor, a place, a time slot, and the client or clients to go in it. Sounds like you are on the right track. Looking at your first sentence below, you state that there are various types of groups classes, so why not have a type of 'private'. If I get you right, I'd have a class table pulling together the type of class (one of the typical group classes or this new 'private' one) and, somehow, the client(s) enrolled, and then the schedule table need only have the class instantiation (which doesn't yet make sense without a timestamp; This is unclear, what do you mean by timestamp...do you mean it has no time scheduled? From a technical standpoint, this is not an issue, but from a business standpoint, you would have people enrolled in a class that has not been scheduled. (Can happen but awkward...) First, I wonder if I successfully followed you :-) Second, though, I don't get how I can have some clients in a class table when the class hasn't been assigned a time slot; how can the clients avoid collisions? This is unclear collisions?... Are you asking how the clients would avoid double booking themselves? If that is the question, I think your business process has to control that i.e. you need to schedule class timeslots. Or, as the classes get scheduled, you would have to notify your clients about the schedule. Wouldn't you have to do that any way, since they would not know when the classes are supposed to be? I % Now, you can query the database and see how many time slots have more than % one class. % You no longer need to worry about double booking. Because I can come back to an unique index, you mean, perhaps? You run a query that counts the number of classes that are booked for each location at each timeslot and if the count is greater than 1, you have a problem. (simple SQL query would give you this) Just to re-itereate, I think you want to enroll groups..! not clients..! A client can be a group of one. This allows you to enroll groups of one or many. I am assuming that your clients may be, for examplle, John Smith or local community center(?) Also, if it was me, I would probably create a table for time slots. The way you have it structured, it works but it is not as flexible. Your finally scheduling table would have pointers to places, timeslots, personnel, groups, classes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
a problem with sum()
Hi, I have got 2 tables one of the is customers the other is bill. In the customers table i store my customers informations. In the bill table i store my billings. if i take a bill bill.direction=0, if i give a bill bill.direction=1. And now i must take a report Like This.. Customer Code Customerloan credit total - 10021 Bob 2515$ 500$2015$ 10022 Mark530$ 600$-70$ 10023 Fred7500$ 0 7500$ .. and its goes on... Bill Table --- CREATE TABLE `bill` ( `ID` int(11) NOT NULL auto_increment, `direction` tinyint(4) NOT NULL default '0', `BillNo` varchar(16) NOT NULL default '', `BillDate` date default '-00-00', `Customer` int(11) default '0', `Total` float(10,2) default '0.00' PRIMARY KEY (`ID`), UNIQUE KEY `ID` (`ID`), UNIQUE KEY `BillNo` (`BillNo`), KEY `BillDate` (`BillDate`), KEY `Customer` (`Customer`) ) TYPE=MyISAM; Customer Table --- CREATE TABLE `customer` ( `ID` int(10) unsigned NOT NULL auto_increment, `Code` varchar(32) NOT NULL default '0', `Name` varchar(80) default NULL, PRIMARY KEY (`ID`), UNIQUE KEY `Code` (`Code`), KEY `Name` (`Name`) ) TYPE=MyISAM; use a query like -- SELECT cus.`Code` AS `Customer Code`, cus.`Name` AS `Customer`, IF (bil.`direction`=0,SUM(bil.`Total`), NULL ) AS Loan, IF (bil.`direction`=1,SUM(bil.`Total`), NULL ) AS Credit FROM customer AS cus, bill AS bil WHERE bil.`Customer` = cus.`ID` GROUP BY bil.`Customer` ORDER BY cus.`Name` But it gives wrong results. My query is to add all Totals, its doesnt look if direction is 1 or 0. The out put like this Customer Code Customerloan credit 10021 Bob 3015$ 0 10022 Mark0 1030$ 10023 Fred7500$ 0 .. I must send only one query ! Is there any body can help me??? Aziz Durmaz - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: join help: i am lost
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Frank -- ...and then Frank Peavy said... % % David, % Just some thoughts.. % See my comments below... Thanks! % % A scheduling, or a booking, eventually has to have a class type (private % or one of many groups -- so I suppose I could simply make a group class % type 'private' and that type has only one slot), an instructor, a place, % a time slot, and the client or clients to go in it. % Sounds like you are on the right track. Looking at your first sentence % below, you state % that there are various types of groups classes, so why not have a type of % 'private'. Yeah. In fact, I have that now, though it hasn't gotten me far. % % If I get you right, I'd have a class table pulling together the type of % class (one of the typical group classes or this new 'private' one) and, % somehow, the client(s) enrolled, and then the schedule table need only % have the class instantiation (which doesn't yet make sense without a % timestamp; % This is unclear, what do you mean by timestamp...do you mean it has % no time scheduled? From a technical standpoint, this is not an issue, but % from a business standpoint, you would have people enrolled in a class % that has not been scheduled. (Can happen but awkward...) Right, and it certainly would be awkward. It seems to me that you have to have the instructor, the class type, the place, and the time before you can offer it to clients. So that was my worry. % % First, I wonder if I successfully followed you :-) Second, though, I % don't get how I can have some clients in a class table when the class % hasn't been assigned a time slot; how can the clients avoid collisions? % This is unclear collisions?... Are you asking how the clients would avoid % double booking themselves? If that is the question, I think your business Exactly; see above. % process has to control that i.e. you need to schedule class timeslots. OK. I like that. % Or, as the classes get scheduled, you would have to notify your clients % about the schedule. Wouldn't you have to do that any way, since they would % not know when the classes are supposed to be? Right -- but that's not a good approach, IMHO. % % % Now, you can query the database and see how many time slots have more % than % % one class. % % You no longer need to worry about double booking. % % Because I can come back to an unique index, you mean, perhaps? % You run a query that counts the number of classes that are booked for each % location at each timeslot and if the count is greater than 1, you have a % problem. (simple SQL query would give you this) OK. Yeah, I figured I'd have to do that on my own. I also want to make sure someone doesn't try to sign up a client in two spots at the same time, and will have to do that on my own. No biggie. % % Just to re-itereate, I think you want to enroll groups..! not clients..! % A client can be a group of one. Hmmm... OK; I can see that... % This allows you to enroll groups of one or many. % I am assuming that your clients may be, for examplle, John Smith or local % community center(?) John Smith, or maybe six or seven people taking a group class. % % Also, if it was me, I would probably create a table for time slots. The way % you have it structured, it works but it is not as flexible. At the very least, it stores a lot of redundant data; you're probably right. Then I don't have to worry about how to define the time slots (are we open from 6a - 7p today or do we close at noon or whatever?) to ensure that the classes get booked only at appropriate times. So this part looks easy and helpful. Hmmm... I'll wait until later to figure out whether to stick with one field or split into day and time -- and then fret about all of those duplicated day values for each hour ;-) % % Your finally scheduling table would have pointers to places, timeslots, % personnel, groups, classes OK. Here's where I have more questions, then. The class type will say what kind it is and how many slots it can have, so I know what kind of 'group' can go in here. Are you suggesting that I should have a table defining a group for each instance? Basically every time you have an instructor doing something, you have a corresponding entry in another table listing who's being taught? That seems just a little *too* redundant, and maybe a little less so if I reused groups (every client would automatically become a group of one, to be reused for any private instruction, and then there would be other groups as people came together in a group class). Even so, that still doesn't answer the question of how to have data of different magnitude in the same table. If I have one class with one person and another with two people, how would I have a single record for each which lists the client(s)? Thanks again HAND HNY mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL
Re: join help: i am lost
Even so, that still doesn't answer the question of how to have data of different magnitude in the same table. If I have one class with one person and another with two people, how would I have a single record for each which lists the client(s)? Easy, Your scheduling query results, as I said: places, timeslots, personnel, groups, classes 5th floor room, 1 to 2, BestInstructor, Local community center, yoga (group lesson) 5th floor room, 2 to 3, BestInstructor, Jon Smith group, yoga (private) 5th floor room, 5 to 6, BestInstructor, Open Group, yoga (open) In order to find out if Jon is scheduled twice, you would need to know if he is part of the Local community center group. Any way You may have to re-think parts of your database structure. A good book on ERD diagrams might help. Best of luck. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: An Idea
alkaline has been around awhile. the model is similiar to mysql in that they have a commercial version that sustains them, and a free version that sustains the rest of us. there is not a doubt that its better than the php script you refer to below... http://alkaline.vestris.com/docs/alkaline-faq/af-general.html#AF-GEN-WHY its claim is very high speed searching, partial word searching, multiple remote site indexing and spidering etc. good for high speed results on a document set of 500,000 pages or so. with a list of mysql urls to spider and index, it can be setup and live, fast. Jim -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 01, 2003 5:31 AM To: JamesD; David T-G; mysql users Subject: Re: An Idea James, something that can be based upon pages of htm and emails that exists, and that can sit under a few web pages using Htdig or alkaline or something... Do these tools work better that the search tool (Mnogo search) at http://lists.mysql.com/php/search.php? This thing sucks - I was looking for mysql_fix_privilege_tables, and it found nothing! Guten Rutsch Danke, Dir auch! Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: JamesD [EMAIL PROTECTED] To: David T-G [EMAIL PROTECTED]; mysql users [EMAIL PROTECTED] Cc: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 5:11 AM Subject: RE: An Idea we find people just like to ask questions, and no matter how good our FAQ's and help are, many people have circumstances that make it more efficient to push the question into the queue, and wait for an answer to pop back later. lists work, and faq's work, some like to call...etc. personally, I'd prefer a search engine style... like google, but only for mySQL topics, and with a visible list of most popular search terms. something that can be based upon pages of htm and emails that exists, and that can sit under a few web pages using Htdig or alkaline or something... Guten Rutsch Jim -Original Message- From: David T-G [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 31, 2002 4:36 PM To: mysql users Cc: Stefan Hinz, iConnect (Berlin) Subject: Re: An Idea -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan -- ...and then Stefan Hinz, iConnect (Berlin) said... % % David, % % regarding the MySQL FAQ: % % Why should it have to be there? Let anyone with a site set it up and ... % % MySQL.com would be the natural place for the FAQ. Any other place % wouldn't be half as good. Oh, to be sure. And maybe we could even get the mysql.com folks to prominently list a pointer to the off-site FAQ if they don't want to maintain it or give out accounts to maintain it. I just wouldn't want to see it dropped if they don't jump on it at the start. HAND Happy New Year mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+EjfnGb7uCXufRwARAvWNAJ9GWPaZm2tjJh4pdQNNG7EV9cdxLACdGWpV tC44gsIMkjgUkNtZlkpZ+Y0= =XS30 -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try:
Re: a problem with sum()
By looking at your query and table description, I guess you can try something like: SELECT cus.`Code` AS `Customer Code`, cus.`Name` AS `Customer`,SUM((1-bil.direction)*bil.Total) AS Loan, SUM(bil.direction*bil.Total) AS Credit FROM customer AS cus, bill AS bil WHERE bil.`Customer` = cus.`ID` GROUP BY bil.`Customer` ORDER BY cus.`Name` Adolfo On Wed, 2003-01-01 at 14:41, Aziz Durmaz wrote: Hi, I have got 2 tables one of the is customers the other is bill. In the customers table i store my customers informations. In the bill table i store my billings. if i take a bill bill.direction=0, if i give a bill bill.direction=1. And now i must take a report Like This.. Customer Code Customerloan credit total - 10021 Bob 2515$ 500$2015$ 10022 Mark530$ 600$-70$ 10023 Fred7500$ 0 7500$ .. and its goes on... Bill Table --- CREATE TABLE `bill` ( `ID` int(11) NOT NULL auto_increment, `direction` tinyint(4) NOT NULL default '0', `BillNo` varchar(16) NOT NULL default '', `BillDate` date default '-00-00', `Customer` int(11) default '0', `Total` float(10,2) default '0.00' PRIMARY KEY (`ID`), UNIQUE KEY `ID` (`ID`), UNIQUE KEY `BillNo` (`BillNo`), KEY `BillDate` (`BillDate`), KEY `Customer` (`Customer`) ) TYPE=MyISAM; Customer Table --- CREATE TABLE `customer` ( `ID` int(10) unsigned NOT NULL auto_increment, `Code` varchar(32) NOT NULL default '0', `Name` varchar(80) default NULL, PRIMARY KEY (`ID`), UNIQUE KEY `Code` (`Code`), KEY `Name` (`Name`) ) TYPE=MyISAM; use a query like -- SELECT cus.`Code` AS `Customer Code`, cus.`Name` AS `Customer`, IF (bil.`direction`=0,SUM(bil.`Total`), NULL ) AS Loan, IF (bil.`direction`=1,SUM(bil.`Total`), NULL ) AS Credit FROM customer AS cus, bill AS bil WHERE bil.`Customer` = cus.`ID` GROUP BY bil.`Customer` ORDER BY cus.`Name` But it gives wrong results. My query is to add all Totals, its doesnt look if direction is 1 or 0. The out put like this Customer Code Customerloan credit 10021 Bob 3015$ 0 10022 Mark0 1030$ 10023 Fred7500$ 0 .. I must send only one query ! Is there any body can help me??? Aziz Durmaz - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Foreign Key problem? in MySQL 4.0.7
I was able to create the gid table with no problem under mysql 4.0.7 CREATE TABLE gid ( id INT(11) NOT NULL auto_increment, groupname VARCHAR(128) NOT NULL, passwd VARCHAR(128) NULL, gidINT(11) NOT NULL, username VARCHAR(128) NULL, inserted_byVARCHAR(128) NOT NULL default 'root', epoch_inserted DATETIME NULL, modified_byVARCHAR(128) NOT NULL default 'root', epoch_modified DATETIME NULL, UNIQUE KEY keyword(id,groupname,gid), PRIMARY KEY (groupname, gid) ) TYPE=INNODB; but when I attempt to create the uid table below I get the following foreign key error. What am I doing wrong? ERROR 1005: Can't create table './vhadmindb/uid.frm' (errno: 150) CREATE TABLE uid ( id INT(11) NOT NULL auto_increment, username VARCHAR(128) NOT NULL, passwd VARCHAR(128) NOT NULL, uidINT(11) NOT NULL, gidINT(11) NOT NULL, INDEX gid_ind (gid), FOREIGN KEY (gid) REFERENCES gid(gid), gecos VARCHAR(128) NULL, homedirVARCHAR(128) NOT NULL, shell VARCHAR(128) NOT NULL, inserted_byVARCHAR(128) NOT NULL default 'root', epoch_inserted DATETIME NULL, modified_byVARCHAR(128) NOT NULL default 'root', epoch_modified DATETIME NULL, UNIQUE KEY keyword(id, username, uid), PRIMARY KEY (username,uid) ) TYPE=INNODB; - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Configure error: no curses/termcap library found
Can anyone help me? I get this whenever I run ./configure --prefix=/usr/local/mysql checking for termcap functions library... configure: error: No curses/termcap library found then configure quits. I'm really new to linux, so please give me the lamans version of it ;) _ MSN 8: advanced junk mail protection and 2 months FREE*. http://join.msn.com/?page=features/junkmail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Maintaining a UNIQUE INDEX in a MERGED Table
If I am reading the documentation correctly, MySQL will not maintain a UNIQUE INDEX across the tables that make-up a merged table. Does anyone have any tips for maintaining a UNIQUE INDEX across tables that make up a merged table? Is there an easier way than running a SELECT statement on all of the sub tables and then inserting the item if all tables return 0 found? Thank you in advance! Andrew sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: join help: i am lost
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Frank -- ...and then Frank Peavy said... % % Even so, that still doesn't answer the question of how to have data of % different magnitude in the same table. If I have one class with one % person and another with two people, how would I have a single record for % each which lists the client(s)? % % Easy, So you say ;-) % % Your scheduling query results, as I said: % % places, timeslots, personnel, groups, classes % % 5th floor room, 1 to 2, BestInstructor, Local community center, yoga (group % lesson) % 5th floor room, 2 to 3, BestInstructor, Jon Smith group, yoga (private) % 5th floor room, 5 to 6, BestInstructor, Open Group, yoga (open) % % In order to find out if Jon is scheduled twice, you would need to know if % he is part of the Local community center group. Ahhh... No, it doesn't work that way; a group class is whoever signs up for that time slot that day. Think even non-appointment signin. Well, that may be what you're thinking with the open group. We need to track who attends, though. Even if we did use this approach, how would we track the group membership? Either we look at the client record and note of which groups Jon is a member, from zero to N, or (probably better) we have a groups table listing the groups and who is a member -- and we're once again back to how to list anything from 1 to N members. Do I just define up to N fields per row and fill in the left-most empty one? Do I stick the IDs in a text field and then parse my way across that field, or can the DB do it? % % Any way % You may have to re-think parts of your database structure. A good book on % ERD diagrams might help. Indeed. % % Best of luck. Thanks again HNY :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+E1XCGb7uCXufRwARAm1cAKDkppWDoxVj86a12k8uDZaYejiK3ACgrX6d BoUc+3g7mN6Oysyl3ul7Sh4= =QLVn -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Maintaining a UNIQUE INDEX in a MERGED Table
Hello. On Wed 2003-01-01 at 15:38:23 -0500, [EMAIL PROTECTED] wrote: If I am reading the documentation correctly, MySQL will not maintain a UNIQUE INDEX across the tables that make-up a merged table. Correct. Although it is called a UNIQUE index, the MERGE table doesn't hold it's own index and uniqueness is only guaranteed on sub-table basis (presumed you have the corresponding UNIQUE index on the sub-tables). Does anyone have any tips for maintaining a UNIQUE INDEX across tables that make up a merged table? No. You have to check uniqueness yourself. Or use a procedure that assures you uniqueness, if possible. Is there an easier way than running a SELECT statement on all of the sub tables and then inserting the item if all tables return 0 found? Do the SELECT on the MERGE table instead? HTH, 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
Re: FAQ hosting site (was Re: An Idea)
David, Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Fine. http://mysql.justpickone.org/ works :) Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp Let's set up a PHP thing with MySQL. That's quite fast and easy to do. I could contribute some code. My suggestions (database design): 1. We need an authors table, and everyone who wants to be an author (contributor) can mail you, and you will set up accounts for these persons. The authors table will, of course, be used for database authentification / to update the admin pages. 2. For the actual content, we will need only one table, with question (varchar), answer (text), timestamp and a couple of id's that refer to other tables. 3. For the beginning, I would suggest we only have two more tables: category (installation, privilege system, ..., generally speaking, the main chapters of the manual) and difficulty (beginner, advanced, expert). _Not_ to be edited by the authors, to keep the FAQ smooth and simple. - We can make this more complex when necessity comes, with ratings, automated checks for double entries etc. My suggestions (frontend): 1. For end users, a very simple search. As Jim (JamesD) pointed out, Alkaline could do the job. Then again, Alkaline will search (and before, index) documents, and not databases. For the beginning, I would prefer just a simple input box for the search. 2. Output preferably as html files, i.e. nothing like index.php?cat=installationdifficulty=beginnersearchterm=windows, but rather something like /installation/beginner/windows/1.html. IMHO, this is easier to refer to in a mailing list, and easier to click. Maybe we can set up Alkaline on those html files, as an alternative search for the database search. 3. Authors should be instructed to first search via the end user interface before inserting a new entry. If they do want to insert something new, they should simply select category, difficulty, paste the question, type (or paste) the answer. 4. The author login should be extremely convenient, with a persistent cookie, so an author will not actually have to login more than once (from the same browser/machine). 5. An author should be able to insert new content and to update his / her own content, nothing else. - What I said about database design applies to the frontend, too. We can make it more complex later on, when the need arises. We can have user contributed notes, fine grained search criteria, etc. In the beginning, I would suggest to follow the KISS principle (keep it simple stupid). I send this to the list, because a) maybe someone has written exactly what we want, or can give a URL to where to find it, b) maybe someone has better ideas or comments on this. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Great. We should discuss everything else via this list, then. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: David T-G [EMAIL PROTECTED] To: mysql users [EMAIL PROTECTED] Cc: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 4:12 PM Subject: Re: FAQ hosting site (was Re: An Idea) -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan, et al -- ...and then Stefan Hinz, iConnect (Berlin) said... % % David, % % see it dropped if they don't jump on it at the start. % % I agree. Will you set it up at http://justpickone.org/? (BTW, I like Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp (I wish we could sftp without then also having ssh; darn) and, meanwhile, it seems like this should be the sort of thing where we could either use CVS or a web update form or the like... Maybe a wiki will do for now, but I don't like only being able to get at it from the web :-) Anyone have any thoughts? % your website, especially the PIX :-) Thanks! :-) It needs an overhaul, but it gets the job done. % % Regards, % -- % Stefan Hinz [EMAIL PROTECTED] % Geschäftsführer / CEO iConnect GmbH http://iConnect.de % Heesestr. 6, 12169 Berlin (Germany) % Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 HTH HAND HNY :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur
synopsis of the problem (one line)
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.53 (Source distribution) Environment: System: Linux localhost.localdomain 2.4.7-10 #1 Thu Sep 6 17:27:27 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 ene 1 06:09 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 1282588 sep 4 2001 /lib/libc-2.2.4.so -rw-r--r--1 root root 27304836 sep 4 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 sep 4 2001 /usr/lib/libc.so Configure command: ./configure --without-debug --prefix=/usr/local/mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: front ends?
I recently found this web-based front end and am extremely impressed by it. Among other things,it lets you bookmark your sql queries. http://eskuel.sourceforge.net/ -bill Richard Nagle wrote: what would be the easy to use, gui front end for mySQL 3.23.53 (for Mac OS X ) Thanks Again, Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Search Engine (text search) like functionality...need to build
Hi Frank, the full text search from MySQL is probably what you are looking for. You can read more about it in the online documentation. http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Ful ltext_Search Cheers, Pieter - Original Message - From: Frank Peavy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 6:08 PM Subject: Search Engine (text search) like functionality...need to build Hello All, I have a need to build some user functionality (text search) that is similar to the search functions available in most search engines. I would like to have users input a search string and find the appropriate records in MySql, for example: database software development linux Part of the difficulty I am having is how to handle the pieces of text to search with. A simple parse of the data would break apart the text inside the double quotes. My intent was to capture the search string in a PHP form, but I am unsure where to go to from there. Any thoughts on how to approach this would be 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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/root
Well after 3 times installing mysql, finally got it working (tks to those whom help) now I need to take care of user and root. first root. mysql mysql -u root mysql just want to confirm this is correct before I push enter. mysql update user set password=password('tko') where user='root'; Then next this, mysql flush privileges; So, this should add a password for root, yes? and flush all other privileges? Thanks- Rick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: FAQ hosting site (was Re: An Idea)
I'm not following this threath.. but.. Use PHP to fetch mail from a mailbox, insert all questions into a database. Create a searchtool to search the database. No need to have way to many ppl as author. If you want you could have some ppl maintaining a list of keywords per question or remove a question from the database.. If you really persist to create something of your own you shouldn't create catagories. Most ppl don't really understand under which catagory their question could be found. Those who do will probably find an answer much quicker using google. --B. -Oorspronkelijk bericht- Van: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Verzonden: woensdag 1 januari 2003 22:26 Aan: David T-G; mysql users Onderwerp: Re: FAQ hosting site (was Re: An Idea) David, Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Fine. http://mysql.justpickone.org/ works :) Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp Let's set up a PHP thing with MySQL. That's quite fast and easy to do. I could contribute some code. My suggestions (database design): 1. We need an authors table, and everyone who wants to be an author (contributor) can mail you, and you will set up accounts for these persons. The authors table will, of course, be used for database authentification / to update the admin pages. 2. For the actual content, we will need only one table, with question (varchar), answer (text), timestamp and a couple of id's that refer to other tables. 3. For the beginning, I would suggest we only have two more tables: category (installation, privilege system, ..., generally speaking, the main chapters of the manual) and difficulty (beginner, advanced, expert). _Not_ to be edited by the authors, to keep the FAQ smooth and simple. - We can make this more complex when necessity comes, with ratings, automated checks for double entries etc. My suggestions (frontend): 1. For end users, a very simple search. As Jim (JamesD) pointed out, Alkaline could do the job. Then again, Alkaline will search (and before, index) documents, and not databases. For the beginning, I would prefer just a simple input box for the search. 2. Output preferably as html files, i.e. nothing like index.php?cat=installationdifficulty=beginnersearchterm=windows, but rather something like /installation/beginner/windows/1.html. IMHO, this is easier to refer to in a mailing list, and easier to click. Maybe we can set up Alkaline on those html files, as an alternative search for the database search. 3. Authors should be instructed to first search via the end user interface before inserting a new entry. If they do want to insert something new, they should simply select category, difficulty, paste the question, type (or paste) the answer. 4. The author login should be extremely convenient, with a persistent cookie, so an author will not actually have to login more than once (from the same browser/machine). 5. An author should be able to insert new content and to update his / her own content, nothing else. - What I said about database design applies to the frontend, too. We can make it more complex later on, when the need arises. We can have user contributed notes, fine grained search criteria, etc. In the beginning, I would suggest to follow the KISS principle (keep it simple stupid). I send this to the list, because a) maybe someone has written exactly what we want, or can give a URL to where to find it, b) maybe someone has better ideas or comments on this. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Great. We should discuss everything else via this list, then. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: David T-G [EMAIL PROTECTED] To: mysql users [EMAIL PROTECTED] Cc: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 4:12 PM Subject: Re: FAQ hosting site (was Re: An Idea) -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan, et al -- ...and then Stefan Hinz, iConnect (Berlin) said... % % David, % % see it dropped if they don't jump on it at the start. % % I agree. Will you set it up at http://justpickone.org/? (BTW, I like Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp (I wish we could sftp without then also having ssh; darn) and, meanwhile, it seems like this should be the sort of
¹§Ï²·¢²Æ£¨Ëõ¶ÌÓëÊÀ½çµÄ¾àÀë´ÓÍøÂçµç»°¿ªÊ¼£©
Title: ÌØ´óϲѶ ×â ´º½Ú°ÙÍò´óÐж¯ ËÍ ¡¡ ÉϺ£Í®Èð¿Æ¼¼Ã³Ò×ÓÐÏÞ¹«Ë¾ http://www.tongrei.com Net2phone´ÓÊÀ½ç¸÷µØ´ò»ØÖйúÒѽµµ½$0.11/·ÖÖÓ Èç¹ûÕâ·âÓʼþ´òÈÅÄúÁË£¬·³ÇëËæÊÖɾµô£¬²¢Çë¼ûÁ¡£ÈôÄú²»Ï£ÍûÔÙ´ÎÊÕµ½ÎÒÃǵÄÓʼþ£¬Çëµã»÷ÕâÀï - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: FAQ hosting site (was Re: An Idea)
Hi Like the look of the way its taking shape. I am not sure if there is existing faq software (I've checked sourceforge and freshmeat without much luck) we could use, or if someone can do a better job :) but I have a content management system written, together with a lot of the search functionality needed for the faq. It can mix database stored content with static content, so it would probably do the job with a little work. It also does the membership authorisation/management. I'd be happy to build the software, if that helps. Let me know Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: 01 January 2003 21:26 To: David T-G; mysql users Subject: Re: FAQ hosting site (was Re: An Idea) David, Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Fine. http://mysql.justpickone.org/ works :) Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp Let's set up a PHP thing with MySQL. That's quite fast and easy to do. I could contribute some code. My suggestions (database design): 1. We need an authors table, and everyone who wants to be an author (contributor) can mail you, and you will set up accounts for these persons. The authors table will, of course, be used for database authentification / to update the admin pages. 2. For the actual content, we will need only one table, with question (varchar), answer (text), timestamp and a couple of id's that refer to other tables. 3. For the beginning, I would suggest we only have two more tables: category (installation, privilege system, ..., generally speaking, the main chapters of the manual) and difficulty (beginner, advanced, expert). _Not_ to be edited by the authors, to keep the FAQ smooth and simple. - We can make this more complex when necessity comes, with ratings, automated checks for double entries etc. My suggestions (frontend): 1. For end users, a very simple search. As Jim (JamesD) pointed out, Alkaline could do the job. Then again, Alkaline will search (and before, index) documents, and not databases. For the beginning, I would prefer just a simple input box for the search. 2. Output preferably as html files, i.e. nothing like index.php?cat=installationdifficulty=beginnersearchterm=windows, but rather something like /installation/beginner/windows/1.html. IMHO, this is easier to refer to in a mailing list, and easier to click. Maybe we can set up Alkaline on those html files, as an alternative search for the database search. 3. Authors should be instructed to first search via the end user interface before inserting a new entry. If they do want to insert something new, they should simply select category, difficulty, paste the question, type (or paste) the answer. 4. The author login should be extremely convenient, with a persistent cookie, so an author will not actually have to login more than once (from the same browser/machine). 5. An author should be able to insert new content and to update his / her own content, nothing else. - What I said about database design applies to the frontend, too. We can make it more complex later on, when the need arises. We can have user contributed notes, fine grained search criteria, etc. In the beginning, I would suggest to follow the KISS principle (keep it simple stupid). I send this to the list, because a) maybe someone has written exactly what we want, or can give a URL to where to find it, b) maybe someone has better ideas or comments on this. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Great. We should discuss everything else via this list, then. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: David T-G [EMAIL PROTECTED] To: mysql users [EMAIL PROTECTED] Cc: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 4:12 PM Subject: Re: FAQ hosting site (was Re: An Idea) -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan, et al -- ...and then Stefan Hinz, iConnect (Berlin) said... % % David, % % see it dropped if they don't jump on it at the start. % % I agree. Will you set it up at http://justpickone.org/? (BTW, I like Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too.
Using files stored as blob
OK I got files to upload to my MySQL server but now how do I retreive them for distribution by email for instance. When I do a query the filename looks something like: /var/tmp//phptkYxkV I'm not sure where that is but I need to retrieve that file and distribute it... Any suggestions would be greatly appreciated... /T - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: FAQ hosting site (was Re: An Idea)
I really need your help, I installed MySQL and I can connect to it through localhost but when trying to access it from outside I get: ERROR 2003: Can't connect to MySQL server on 'IP' (111) Any suggestions? Someone suggested that the problem is because the server has 2 nics (2 ips set up). Does anyone know a solution for this? --- Peter Lovatt [EMAIL PROTECTED] wrote: Hi Like the look of the way its taking shape. I am not sure if there is existing faq software (I've checked sourceforge and freshmeat without much luck) we could use, or if someone can do a better job :) but I have a content management system written, together with a lot of the search functionality needed for the faq. It can mix database stored content with static content, so it would probably do the job with a little work. It also does the membership authorisation/management. I'd be happy to build the software, if that helps. Let me know Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: 01 January 2003 21:26 To: David T-G; mysql users Subject: Re: FAQ hosting site (was Re: An Idea) David, Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Fine. http://mysql.justpickone.org/ works :) Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp Let's set up a PHP thing with MySQL. That's quite fast and easy to do. I could contribute some code. My suggestions (database design): 1. We need an authors table, and everyone who wants to be an author (contributor) can mail you, and you will set up accounts for these persons. The authors table will, of course, be used for database authentification / to update the admin pages. 2. For the actual content, we will need only one table, with question (varchar), answer (text), timestamp and a couple of id's that refer to other tables. 3. For the beginning, I would suggest we only have two more tables: category (installation, privilege system, ..., generally speaking, the main chapters of the manual) and difficulty (beginner, advanced, expert). _Not_ to be edited by the authors, to keep the FAQ smooth and simple. - We can make this more complex when necessity comes, with ratings, automated checks for double entries etc. My suggestions (frontend): 1. For end users, a very simple search. As Jim (JamesD) pointed out, Alkaline could do the job. Then again, Alkaline will search (and before, index) documents, and not databases. For the beginning, I would prefer just a simple input box for the search. 2. Output preferably as html files, i.e. nothing like index.php?cat=installationdifficulty=beginnersearchterm=windows, but rather something like /installation/beginner/windows/1.html. IMHO, this is easier to refer to in a mailing list, and easier to click. Maybe we can set up Alkaline on those html files, as an alternative search for the database search. 3. Authors should be instructed to first search via the end user interface before inserting a new entry. If they do want to insert something new, they should simply select category, difficulty, paste the question, type (or paste) the answer. 4. The author login should be extremely convenient, with a persistent cookie, so an author will not actually have to login more than once (from the same browser/machine). 5. An author should be able to insert new content and to update his / her own content, nothing else. - What I said about database design applies to the frontend, too. We can make it more complex later on, when the need arises. We can have user contributed notes, fine grained search criteria, etc. In the beginning, I would suggest to follow the KISS principle (keep it simple stupid). I send this to the list, because a) maybe someone has written exactly what we want, or can give a URL to where to find it, b) maybe someone has better ideas or comments on this. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Great. We should discuss everything else via this list, then. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: David T-G [EMAIL PROTECTED] To: mysql users [EMAIL PROTECTED] Cc: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]
RE: FAQ hosting site (was Re: An Idea)
Hi Is '111' the IP it is trying to connect on? If so it is an invalid IP. If the IP is valid how are you trying to connect? Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: mnbv [mailto:[EMAIL PROTECTED]] Sent: 02 January 2003 00:23 To: Peter Lovatt; Stefan Hinz, iConnect (Berlin); David T-G; mysql users Subject: RE: FAQ hosting site (was Re: An Idea) I really need your help, I installed MySQL and I can connect to it through localhost but when trying to access it from outside I get: ERROR 2003: Can't connect to MySQL server on 'IP' (111) Any suggestions? Someone suggested that the problem is because the server has 2 nics (2 ips set up). Does anyone know a solution for this? --- Peter Lovatt [EMAIL PROTECTED] wrote: Hi Like the look of the way its taking shape. I am not sure if there is existing faq software (I've checked sourceforge and freshmeat without much luck) we could use, or if someone can do a better job :) but I have a content management system written, together with a lot of the search functionality needed for the faq. It can mix database stored content with static content, so it would probably do the job with a little work. It also does the membership authorisation/management. I'd be happy to build the software, if that helps. Let me know Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: 01 January 2003 21:26 To: David T-G; mysql users Subject: Re: FAQ hosting site (was Re: An Idea) David, Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Fine. http://mysql.justpickone.org/ works :) Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp Let's set up a PHP thing with MySQL. That's quite fast and easy to do. I could contribute some code. My suggestions (database design): 1. We need an authors table, and everyone who wants to be an author (contributor) can mail you, and you will set up accounts for these persons. The authors table will, of course, be used for database authentification / to update the admin pages. 2. For the actual content, we will need only one table, with question (varchar), answer (text), timestamp and a couple of id's that refer to other tables. 3. For the beginning, I would suggest we only have two more tables: category (installation, privilege system, ..., generally speaking, the main chapters of the manual) and difficulty (beginner, advanced, expert). _Not_ to be edited by the authors, to keep the FAQ smooth and simple. - We can make this more complex when necessity comes, with ratings, automated checks for double entries etc. My suggestions (frontend): 1. For end users, a very simple search. As Jim (JamesD) pointed out, Alkaline could do the job. Then again, Alkaline will search (and before, index) documents, and not databases. For the beginning, I would prefer just a simple input box for the search. 2. Output preferably as html files, i.e. nothing like index.php?cat=installationdifficulty=beginnersearchterm=windows, but rather something like /installation/beginner/windows/1.html. IMHO, this is easier to refer to in a mailing list, and easier to click. Maybe we can set up Alkaline on those html files, as an alternative search for the database search. 3. Authors should be instructed to first search via the end user interface before inserting a new entry. If they do want to insert something new, they should simply select category, difficulty, paste the question, type (or paste) the answer. 4. The author login should be extremely convenient, with a persistent cookie, so an author will not actually have to login more than once (from the same browser/machine). 5. An author should be able to insert new content and to update his / her own content, nothing else. - What I said about database design applies to the frontend, too. We can make it more complex later on, when the need arises. We can have user contributed notes, fine grained search criteria, etc. In the beginning, I would suggest to follow the KISS principle (keep it simple stupid). I send this to the list, because a) maybe someone has written exactly what we want, or
Re: FAQ hosting site (was Re: An Idea)
On Wed, Jan 01, 2003 at 11:08:58PM -, Peter Lovatt wrote: I am not sure if there is existing faq software (I've checked sourceforge and freshmeat without much luck) Really? That's a wheel I've seen re-invented many times. I know there's stuff out there. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 17 days, processed 617,666,871 queries (401/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: FAQ hosting site (was Re: An Idea)
Hi I was looking for a reasonably heavyweight php application, there are some lightweight ones and some half finished ones and some perl ones, but none that were what I was looking for. Any suggestions would be appreciated, no point in reinventing the wheel. Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: 02 January 2003 00:37 To: Peter Lovatt Cc: Stefan Hinz, iConnect (Berlin); David T-G; mysql users Subject: Re: FAQ hosting site (was Re: An Idea) On Wed, Jan 01, 2003 at 11:08:58PM -, Peter Lovatt wrote: I am not sure if there is existing faq software (I've checked sourceforge and freshmeat without much luck) Really? That's a wheel I've seen re-invented many times. I know there's stuff out there. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 17 days, processed 617,666,871 queries (401/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: user/root
On 1/1/03 2:31 PM, Richard Nagle [EMAIL PROTECTED] wrote: Well after 3 times installing mysql, finally got it working (tks to those whom help) now I need to take care of user and root. first root. mysql mysql -u root mysql just want to confirm this is correct before I push enter. mysql update user set password=password('tko') where user='root'; Then next this, mysql flush privileges; So, this should add a password for root, yes? and flush all other privileges? Thanks- Rick You have a recent installation of mysql then you can just run SET PASSWORD FOR root@localhost=PASSWORD('tko'); and skip the flush privileges. All explained here: http://www.mysql.com/doc/en/Default_privileges.html Best/h - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Using files stored as blob
OK I got files to upload to my MySQL server but now how do I retreive them for distribution by email for instance. When I do a query the filename looks something like: /var/tmp//phptkYxkV I'm not sure where that is but I need to retrieve that file and distribute it... Any suggestions would be greatly appreciated... /T - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: FAQ hosting site (was Re: An Idea)
The 111 is the error code that MySQL generates. Check if your computer has a firewall, and make sure to enable port 3306 from external IPs e.g. on redhat using ipchains-based firewall, add: -A input -s 0/0 -d 0/0 3306 -p tcp -y -j ACCEPT to your /etc/sysconfig/ipchains file (or however the box is configured for the firewall). You'll also want to replace -s 0/0 with something a little more restrictive. cheers.. Dan On Thu, 2 Jan 2003, Peter Lovatt wrote: Hi Is '111' the IP it is trying to connect on? If so it is an invalid IP. If the IP is valid how are you trying to connect? Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: mnbv [mailto:[EMAIL PROTECTED]] Sent: 02 January 2003 00:23 To: Peter Lovatt; Stefan Hinz, iConnect (Berlin); David T-G; mysql users Subject: RE: FAQ hosting site (was Re: An Idea) I really need your help, I installed MySQL and I can connect to it through localhost but when trying to access it from outside I get: ERROR 2003: Can't connect to MySQL server on 'IP' (111) Any suggestions? Someone suggested that the problem is because the server has 2 nics (2 ips set up). Does anyone know a solution for this? --- Peter Lovatt [EMAIL PROTECTED] wrote: Hi Like the look of the way its taking shape. I am not sure if there is existing faq software (I've checked sourceforge and freshmeat without much luck) we could use, or if someone can do a better job :) but I have a content management system written, together with a lot of the search functionality needed for the faq. It can mix database stored content with static content, so it would probably do the job with a little work. It also does the membership authorisation/management. I'd be happy to build the software, if that helps. Let me know Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: 01 January 2003 21:26 To: David T-G; mysql users Subject: Re: FAQ hosting site (was Re: An Idea) David, Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Fine. http://mysql.justpickone.org/ works :) Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp Let's set up a PHP thing with MySQL. That's quite fast and easy to do. I could contribute some code. My suggestions (database design): 1. We need an authors table, and everyone who wants to be an author (contributor) can mail you, and you will set up accounts for these persons. The authors table will, of course, be used for database authentification / to update the admin pages. 2. For the actual content, we will need only one table, with question (varchar), answer (text), timestamp and a couple of id's that refer to other tables. 3. For the beginning, I would suggest we only have two more tables: category (installation, privilege system, ..., generally speaking, the main chapters of the manual) and difficulty (beginner, advanced, expert). _Not_ to be edited by the authors, to keep the FAQ smooth and simple. - We can make this more complex when necessity comes, with ratings, automated checks for double entries etc. My suggestions (frontend): 1. For end users, a very simple search. As Jim (JamesD) pointed out, Alkaline could do the job. Then again, Alkaline will search (and before, index) documents, and not databases. For the beginning, I would prefer just a simple input box for the search. 2. Output preferably as html files, i.e. nothing like index.php?cat=installationdifficulty=beginnersearchterm=windows, but rather something like /installation/beginner/windows/1.html. IMHO, this is easier to refer to in a mailing list, and easier to click. Maybe we can set up Alkaline on those html files, as an alternative search for the database search. 3. Authors should be instructed to first search via the end user interface before inserting a new entry. If they do want to insert something new, they should simply select category, difficulty, paste the question, type (or paste) the answer. 4. The author login should be
How to print the results to the printer in Windows2000 environment
Hi! How can I print the results to the printer in Windows2000 environment? Is there any MySQL command for this purpose? How about the MySQL Control Center? I have tried to search for an answer, but mostly for the unix system. Is there any simple solution since I am not a programmer? Terence _ Lonely Christmas(³¯«³¨³)¡A·ºå»P·(Twins)¡AµL¶¡¹D(¹q¼v)... ¦ÜIn¤â¾÷¹aÁn ³§A¹L¥V¤Ñ http://ringtone.yahoo.com.hk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.frm
./myqld: Can't find file : './mysql/host.frm' (errno:13) does anyone know how to solve this problem? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php