Join causing Error?
Can anyone tell me why this: Line 282mysql_select_db("centraldb",$db); Line 283$qorder++; Line 284$result = mysql_query("SELECT q.questid, q.question, q.answer, q.qorder, q.depart, q.catid, q.active, q.global, q.adate, q.author, q.authoremail, q.askemail, c.catid, c.category, c.under, c.corder, c.active FROM central_groupfaqq q, central_groupfaqcat c WHERE q.active = '1' AND q.global = '1' AND c.active = '1' ORDER BY c.under, c.order, q.qorder",$db); Line 285while ($myrow = mysql_fetch_row($result)) Would cause this error: Warning: Supplied argument is not a valid MySQL result resource in faqbody.php3 on line 285 When changing the same SELECT statement to: Line 284$result = mysql_query("SELECT * FROM central_groupfaqq WHERE active = '1' ORDER BY qorder",$db); Works perfectly? Keith Spiller a.k.a. Larentium
Re: Index Usage weirdness
On Sun, Feb 25, 2001 at 12:37:32AM -0500, Mark Chalkley wrote: At this point, there's only 1 row in companies, and 8 in contacts. MySQL won't use an index on tables with so few rows. It is simply faster to scan the whole table. As you tables grow, however, MySQL will begin to use the indexes. This is documented in the manual (though maybe not with hard numbers). Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Replication question.
On Sun, Feb 25, 2001 at 03:29:37PM +0900, wrote: It sounds like you are using a version of MySQL that had a replication bug in it. I suspect that if you upgrade to 3.23.33 the problem will go away. No, Master is 3.23.33, and slave is 3.23.32 3.23.32 was troublesome for slaves. Here http://www.mysql.com/doc/N/e/News-3.23.33.html you'll find an entry which says: Fixed bug in replication that broke slave server start with existing master.info. This fixes a bug introduced in 3.23.32. I'd suggest and upgrade to see if it solves your problem... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Strange database-problem: deletion of rows
On Sun, Feb 25, 2001 at 12:16:39AM +0100, Katja Ide wrote: Hi everyone, We've got a database with 46 tables running on the server of Schlund for four months now. During these four months we've been inserting data into the database by PHP-scripts without any problem whatsoever - until two weeks ago. Then we suddenly noticed that some of the data had disappeared: it had been deleted from the database. These deletions mostly followed the same structure: I've only seen this when my data files wrapped the 4G limit in 3.22.27. Data would just be gone without an error message that the table was full or any sign that the table was corrupted (I didn't do an isamchk though). The oldest data would always disappear. What MySQL version and what type of tables (ISAM/MyISAM) do you use? Did you run an (my)isamchk on the tables? Regards, Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL as spider database.
Vahan Yerkanian [EMAIL PROTECTED] writes: Atle Veka wrote: Why not use something that's already created for you, and is probably *much* faster than your solution :) Oh... if it really was an acceptable choice, I won't post this question. :)) Out of interest, what's unacceptable about ht::/Dig for you? -- Dave Hodgkinson, http://www.hodgkinson.org Editor-in-chief, The Highway Star http://www.deep-purple.com Apache, mod_perl, MySQL, Sybase hired gun for, well, hire - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Index Usage weirdness
I got to wondering about that after your question about how many rows were there. I was just playing with a test copy of the db, preparing to set the log options on the production one, and noticed that. I rummaged around in the .pdf version of the manual for over an hour before posting the question. Obviously, I missed it. Maybe I should've gone to bed earlier instead. It certainly makes sense for MySQL not to use the index in that case, of course. As for me, it's another situation of: If you're gonna train a dog, it helps to be smarter than the dog. Thanks! Mark Chalkley *** REPLY SEPARATOR *** On 2/25/2001 at 12:30 AM Jeremy D. Zawodny wrote: MySQL won't use an index on tables with so few rows. It is simply faster to scan the whole table. As you tables grow, however, MySQL will begin to use the indexes. This is documented in the manual (though maybe not with hard numbers). Jeremy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ROLLBACK not working in Red Hat Linux 7 but does in RedHat Linux 6.2 (MySQL3.23.33)
Hi all, has anyone also seen problems with ROLLBACK not working when installing MySQL on Red Hat Linux 7.0? On Red Hat Linux 7.0, ROLLBACK does nothing (though it doesn't generate an error either, and the table is listed as a BDB in show table status, and locking works as expected with a BDB table). Is there a known problem with RH7? I am using an all-defaults Red Hat server installation. On a stock Red Hat Linux 6.2 server installation, it works. I found a number of people mentioning they had problems with RH7 and ROLLBACK on the mailing lists, but with beta versions, not the stable code. I am installing from tarball source using the following configuration: shell ./configure --prefix=/usr/local/mysql shell make shell make install shell scripts/mysql_install_db shell chown -R mysql /usr/local/mysql shell chgrp -R mysql /usr/local/mysql shell /usr/local/mysql/bin/safe_mysqld --user=mysql And this is my BDB test: create table bdbtest (pk int primary key, name varchar(20)) type=bdb; begin; insert into bdbtest values (1, 'tim'); rollback; select * from bdbtest; (I see the row but should not) set autocommit=0; begin update bdbtest set name='tim2' where pk=1; rollback; select * from bdbtest; (the row was updated but should not have been) All these commands complete OK without errors. In Red Hat 6.2, the changes are indeed rolled back. This testing in part of a review I'm doing for eWEEK on this release of MySQL. Thanks, Tim Dyck eWEEK Labs Timothy Dyck, West Coast Technical Director, eWEEK Labs e-mail: [EMAIL PROTECTED], phone/fax: 519-746-4241
unable to save result ...
Hi- I just crashed my computer and after restart it gives me this message on some SELECT queries: Warning: MySQL: Unable to save result set in c:/apache/htdocs/neobt/otherservices.php3 on line 382 On line 382 I have: $gething = mysql_query("SELECT * FROM etc WHERE type='transfer' AND subid='type4'"); But that`s just one example of very many... What might the problem be? Thanks Siim Einfeldt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ROLLBACK not working in Red Hat Linux 7 but does in RedHat Linux 6.2 (MySQL3.23.33)
* Irmund Thum [EMAIL PROTECTED] wrote on 25.02.01 17:20: ERROR 1196: Warning: Some non-transactional changed tables couldn't be rolled back *** so I'm not that expert knowing what "non-transactional changed tables" exactly means You're probably using the RPM version or otherwise just don't have BDB support compiled in. If you do a "show table status" you'll see that the tables you just created with type=bdb actually are MyISAM or ISAM. -- Tomi Junnila [EMAIL PROTECTED] http://www.badzilla.net/~topeju/ Electronics and Information Technology, University of Turku, Finland - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: GROUP BY Aggregate Funtion?
Hi all, I'm trying to get a query to work but am having no luck. It seems so simple, it should work, but obviously, I'm doing something wrong. Table: Employees Fields: FirstName LastName EmployeeID Table: Sales Fields: SubTotal EmployeeID What I want to do is join the tables by the EmployeeID, Sum the SubTotal Field by EmployeeID and order the rows by the subtotal in DESC order to show the employee with the highest sales volume first. I'm using Win2k MyODBC Any help would be greatly appreciated. Sir, try SELECT e.EmployeeID, Sum(s.SubTotal) AS sum_st FROM Employees AS e INNER JOIN Sales AS s ON e.EmployeeID = s.EmployeeID GROUP BY e.EmployeeID ORDER BY sum_st; BTW, Is LIMIT MySQL's version of the TOP predicate? More or less. LIMIT can't return a percentage of the rows, and TOP can't return a specified count of rows starting at some arbitrary row. Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ?difference between Primary Key, Key, Index, Unique
On Sat, Feb 24, 2001 at 09:43:45AM -0700, Karl Stubsjoen wrote: I'm trying to understand MySQL indexing but am having trouble understanding the differnences (and when to use each) between Primary Key, Key, Unique, an Index. Can you help? Index and Key are the same. A Primary Key is a Unique Index. With the NOT NULL constraint. UNIQUE indices allow NULLs. Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: What index is needed to speed up query?
Sir, LEFT JOINs rule out the use of indices on the join column in the left table, making LEFT JOINs inherently slow. Try putting indices on the columns used in your WHERE and ORDER BY clauses. I'm not promising it will help, but it is recommended in Paul's book. Bob Hall Hi folks, after having carefully tuned all statements within a larger web based application rewriting SQL statements and optimizing them by adding indices, there are still two statements left, which are awkward concerning performance. Maybe I am just too blind to see how to get them working faster, but I am puzzled at the moment. Can someone help me out with the following two SELECTs and their EXPLAINs, please? The only thing which changes from query to query is the date used in the WHERE clause AND the combination of the two active flags in the WHERE condition, which may be permutated giving all four possible combinations (p=Y/d=Y, p=N/d=N, p=N/d=Y and p=Y/d=N), alas this should not affect the querys execution plan in any way, if I see it right. With my best regards ... Ralph ... EXPLAIN SELECT DISTINCT p.dam_id, p.lastchanged FROM products p LEFT JOIN dams d ON (p.dam_id=d.dam_id) WHERE p.active='Y' AND d.active='Y' AND p.lastchanged='2001-02-01' ORDER BY p.lastchanged ASC, d.dam ASC; +---+--+---+---+-+--- ---+--- ---+-+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+--+---+---+-+--- ---+--- ---+-+ | p | ALL | NULL | NULL |NULL | NULL | 9137 | where used; Using temporary; Using filesort | | d | ref | dam_id_active_idx | dam_id_active_idx | 4 | p.dam_id | 1| where used; Distinct| +---+--+---+---+-+--- ---+--- ---+-+ 2 rows in set (0.01 sec) EXPLAIN SELECT DISTINCT p.dam_id, p.lastchanged FROM products p LEFT JOIN dams d ON (p.dam_id=d.dam_id) LEFT JOIN gags g ON (d.dam_id=g.dam_id AND (ISNULL(g.year) AND ISNULL(g.product_id)) OR (NOT ISNULL(g.year) AND g.product_id=g.dam_id)) WHERE p.active='Y' AND d.active='Y' AND p.lastchanged='2001-02-01' ORDER BY p.lastchanged ASC, d.dam ASC; +---+--++---+ -+- -+--+-+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+--++---+ -+- -+--+-+ | p | ALL | NULL | NULL |NULL | NULL | 9137 | where used; Using temporary; Using filesort | | d | ref | dam_id_active_idx | dam_id_active_idx | 4 | p.dam_id |1 | where used; Distinct| | g | ALL | dam_id_year_active_idx | NULL |NULL | NULL | 287 | Distinct| +---+--++---+ -+- -+--+-+ 3 rows in set (0.00 sec) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Table joining/setup advise?
Sir, you are trying to construct a many-to-many join. (One list has many members, one member subscribes to many lists.) This is done with a join table. join_lists_members(list_id, member_id) To get all the e-mail addresses for a given list name, use SELECT m.email FROM (lists AS l INNER JOIN join_lists_member AS j ON l.id = j.list_id) INNER JOIN members AS m ON j.member_id = m.id WHERE l.name = some list name; This is a little complicated, but it is the standard way of doing it, and it doesn't limit either lists or members. Bob Hall Hi, I`m setting up a email system, the same type of system as Yahoh Groups, Topica etc.. I`m just in need of some advise as to how best to handle my tables. At the moment I have the following tables setup.. Lists - Stores info about the list ListOwners - Stores all List Owners info Members - Stores all member info Archive - Stores all messages sent to the lists I am trying to figure out the best way to associate Members with Lists that they have signed up to, at the moment I can only think of 2 methods both of which wouldn`t be very good. First being to have a couple of fields in the Members table which would store the title of the list they signed up to, the problem with this is that they would be limited to how many lists they sign up to. Second method would to store in the Lists table the members ID but again this would be limited to however many rows I create. Another method I have just thought of would be to create a table called Subscribe and store the List name, Member ID and email address. But that might slow it down a bit when searching for the email address`s to send the actual message out. Any one else offer any thoughts on this. Thanks Ade - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't find ./mysql/host.frm when starting mysqld
I have mysql-server-3.23.22.6 and mysql-3.23.22.6, packages installed on my PC during Linux RedHat 7.0 installation. The problem occurs when starting mysqld program : The command : mysql install db is OK but the command : safe mysqld starts the server mysqld witch stops immediately after. When I look at the file : /var/lib/mysql/my local host.err I find the lines : 010212 13:26:29 mysqld started 010212 13:26:30 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010212 13:26:30 mysqld ended The file host.frm is in : /var/lib/mysql/mysql/ I tried to copy all the files from /var/lib/mysql/mysql/ to /var/lib/mysql/ but the problem still remain. Can you help me please. Thank you. [EMAIL PROTECTED]
./configure --libexecdir=/opt/mysql/libexec
Hi, I ran into the following problem : I,ve got suse 7 , and I tried to compile mysql-3.23.33 with the following options : /usr/src/mysql-3.23.33 # ./configure \ --prefix=/opt/mysql \ --localstatedir=/var/mysql \ --libexecdir=/opt/mysql/libexec \ --with-mysqld-user=mysql \ --with-unix-socket-path=/opt/mysql/var/mysql \ make \ make install \ scripts/mysql_install_db and I got this : scripts/mysql_install_db: my_print_defaults: command not found Didn't find /usr/local/mysql/libexec/mysqld You should do a 'make install' before executing this script - any help please? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP-DB] Join causing Error?
Sir, I don't see anything wrong with the syntax in your query. If I haven't over looked something, and if you haven't misspelled anything, then you have a data problem. Since your first query returns a Cartesian product, you should get something if the WHERE clause returns = 1 row for each table. So either there are no rows in q that meet the conditions q.active = '1' AND q.global = '1' or there are no rows in c that meet the condition c.active = '1' Run the first query with only the first WHERE condition. If you get rows, add the second condition. If that works, add the third. The point at which the query stops returning rows is the point at which a subset of your WHERE conditions aren't met by the any of the rows in one of the tables. BTW, why are you putting quotes around numbers? I'm assuming that's not the problem, since you say you did it in the query that worked, but I don't see the point. Bob Hall Can anyone tell me why this: Line 282mysql_select_db("centraldb",$db); Line 283$qorder++; Line 284$result = mysql_query("SELECT q.questid, q.question, q.answer, q.qorder, q.depart, q.catid, q.active, q.global, q.adate, q.author, q.authoremail, q.askemail, c.catid, c.category, c.under, c.corder, c.active FROM central_groupfaqq q, central_groupfaqcat c WHERE q.active = '1' AND q.global = '1' AND c.active = '1' ORDER BY c.under, c.order, q.qorder",$db); Line 285while ($myrow = mysql_fetch_row($result)) Would cause this error: Warning: Supplied argument is not a valid MySQL result resource in faqbody.php3 on line 285 When changing the same SELECT statement to: Line 284$result = mysql_query("SELECT * FROM central_groupfaqq WHERE active = '1' ORDER BY qorder",$db); Works perfectly? Keith Spiller a.k.a. Larentium Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: XML support under mySQL
Ed Carp wrote: Gorjan Todorovski ([EMAIL PROTECTED]) writes: Since XML is a way to exchange data...and it is protocol/platform indepdnent there is a very good reason to have XML docuemts going in and out the No, it's not. You store *data* in a database, *not* metadata. Do you understand the difference? There is no difference. What is metadata in one context, is data in another context. It's just a matter of your standpoint, which can change with time. XML is a format to store/exchange data. Jan Dvorak - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Problem installing MySQL php
I had pretty much the same problem. I was unhappy with the RH v7.0 distro of MySQL and downloaded the MySQL rpm's (v3.23.33). It installed and ran with _no_ problems! My problem was the RH distro of php did not recognize that MySQL was there. I decided to upgrade to php 4.0.4. I downloaded the rpms from RH, but when it came time to install php-mysql, it said MySQL was not there. I was very reluctant to uninstall php and try to install and compile the tarball. What I did instead is... rpm -ivh php-my*.rpm --nodeps This installed mysql-php without checking for dependencies. After a reboot, I can connect to MySQL databases with php. Ken Nordquist "Did I Do That?" - Original Message - From: "Pope, Alan" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 22, 2001 2:25 PM Subject: Problem installing MySQL php Hi all, Newbie alert, please be gentle. My system is Redhat 7.0 with glibc-2.2-12, kernel 2.2.16-22. I have started a project which involves learning php mysql, so I bought myself a couple of big books to sit down and do some learning! Problem is, I cannot get MySQL php installed together nicely... let me explain. I currently have php-4.0.1pl2-9, mod-php-4.0.1pl2-9, and would like to install mysql and php-mysql-4.0.1pl2-9 to go with it. However, I have two versions of mysql neither of which will install properly. Problem 1 with mysql-3.23.32 (obtained from updates.redhat.com) rpm -i mysql-3.23.32.1.7.i386.rpm I get a whole load of error messages from ldconfig complaining that "/sbin/ldconfig: /usr/local/lib/xxx.so is not a symbolic link" - I get about 40 of these. It's right - they aren't, they are files. The mysql install stops at that point.. sorta half installed. I can deinstall with rpm -e (also getting the same ldconfig error, but I actually want to install it! What do I do? Problem 2 with MySQL-3.23.33 (note the case of MySQL) (obtained from mysql.com) rpm -i MySQL-3.23.33-1.i386.rpm All seems to go okay - no problems. However, when I try to install the php-mysql package it complains that "mysql is not installed" (it's a pre-req). The stupid thing is, it IS installed although when I look with rpm -q, I find the package called "MySQL", not "mysql".. What do I do here? I thought renaming the rpm might do it, but sorta knew it wouldn't - and it didn't work... Please, I need help. Cheers, Al. http://www.popey.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: XML support under mySQL
Glorious Sunday morning greetings to you Jan, No, XML is a format for 2 different applications, usually 2 totally separate applications, to be able to exchange data. It is not an appropriate choice for storing large amounts of data that will have to be queried. Nor is it an appropriate choice of language for talking to an RDBMS. Outside of the fact that it can be extremely verbose, we already have a perfectly good language for that, SQL. SQL is a language for committing data to a storage mechanism and retrieving the data back. It is superior to XML in those tasks. Again, if you have need to talk to your RDBMS via XML then a thin wrapper written in the language of your choice is the proper way to go. This allows you to do your job without bloating my application with unnecessary code. And I also disagree with your statement that there is no difference between metadata and data. there most certainly is. But that's a discussion for another thread. humbly, Cal http://www.calevans.com p.s. another reason not to include it is NOBODY wants to distract the MySQL coders from getting 4.0 frozen and out the door! :) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jan Dvorak Sent: Sunday, February 25, 2001 10:13 AM To: Ed Carp Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: XML support under mySQL Ed Carp wrote: Gorjan Todorovski ([EMAIL PROTECTED]) writes: Since XML is a way to exchange data...and it is protocol/platform indepdnent there is a very good reason to have XML docuemts going in and out the No, it's not. You store *data* in a database, *not* metadata. Do you understand the difference? There is no difference. What is metadata in one context, is data in another context. It's just a matter of your standpoint, which can change with time. XML is a format to store/exchange data. Jan Dvorak - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL as spider database.
Dave Hodgkinson wrote: Out of interest, what's unacceptable about ht::/Dig for you? -- Dave Hodgkinson, http://www.hodgkinson.org Editor-in-chief, The Highway Star http://www.deep-purple.com Apache, mod_perl, MySQL, Sybase hired gun for, well, hire - My task is to implement several custom word parsing/modification before writing the keywords into the database, as well as I just want to have my own code ;-) -- Vahan Yerkanian Email: [EMAIL PROTECTED] Leading Web Developer / Designer Phone: (374) 158-2723 Web Development DepartmentFax: (374) 128-5082 ARMINCO Global Telecommunications http://www.arminco.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
synopsis of the problem (one line)
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:Shadow Inc. Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.33 (Official MySQL RPM) Environment: System: Linux cs151414-a 2.2.9-27mdk #1 Mon Jun 14 16:44:05 CEST 1999 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/i586-mandrake-linux/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='egcs' CFLAGS='-O6 -fomit-frame-pointer -mpentium' CXX='egcs' CXXFLAGS='-O6 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Aug 27 1999 /lib/libc.so.6 - libc-2.1.1.so -rwxr-xr-x 1 root root 1282102 May 20 1999 /lib/libc-2.1.1.so -rw-r--r-- 1 root root 2293016 May 20 1999 /usr/lib/libc.a -rw-r--r-- 1 root root 178 May 20 1999 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --without-berkeley-db '--with-comment=Official MySQL RPM' Perl: This is perl, version 5.005_03 built for i386-linux I dont have mysqladmin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Need some suggestions/advise
Hello All, I have a project coming up that we are programming with Perl, the coding is no problems, just need to get some advise as to setting up the db tables properly so they are efficient and meet our needs. If some one on the list may have some spare time to take a look at our notes and advise as to the best way to layout the tables, it would be much appreciated. TIA, ### Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
missing library libz.so
Hi there, I just installed mysql (3.23) but when I run mysql_install_db or mysqld it comes with an error message that the programming can't load the libz.so file. I've found that file online and copied it into all myysql directories but still it can't load the file. I propably should copy the file to the /local/lib directorie or something, but I can't acces those directories. So is it possible to disable the use of this lib or can I specify the path to it? I am using the binary version on a BSDI 4.01 server... Thanks! Rutger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
TCP Wrapper configuration help needed
Hello I have managed to build and install MySQL --with-libwrap. What next? I haven't found any information on what to put in /etc/hosts.allow or .deny. Of course the rules depend on what I want. I want to close all access from outside the local LAN. I know I can put the barrier in the grant tables, but I want to stop the connection at an earlier stage. Any example of hosts.allow would help me enough to get going. So please share yours. TIA Petri -- [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
upload of a patched myodbc driver
Hi everyone. I applied a patch (for Omniform 4.0 support) to the myodbc driver and would like to upload the patched driver to the maintainers so that everybody in the near future can profit from it. Where do I have to send the driver? Best regards, Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Setting access rights
Hi everyone, I have problem with Database inteded for setting access rights. The problem is that IP addresses set in table 'db' dont affect access rights. With no problem I accessed database from IP 147.229.177.57. Dumping data for this database are as follows: # DATABASE mysql # # Dumping data for table 'user' # INSERT INTO user VALUES ('%','YYY','passwd','N','N','N','N','N','N','N','N','N','N','N','N','N','N'); INSERT INTO user VALUES ('localhost','root','passwd','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y' ,'Y'); # # Dumping data for table 'db' # INSERT INTO db VALUES ('localhost','XXX','YYY','Y','Y','Y','Y','N','N','N','N','N','N'); INSERT INTO db VALUES ('193.179.240.193','XXX','YYY','Y','Y','Y','Y','N','N','N','N','N','N'); INSERT INTO db VALUES ('193.179.240.194','XXX','YYY','Y','Y','Y','Y','N','N','N','N','N','N'); INSERT INTO db VALUES ('193.179.240.195','XXX','YYY','Y','Y','Y','Y','N','N','N','N','N','N'); INSERT INTO db VALUES ('193.179.240.196','XXX','YYY','Y','Y','Y','Y','N','N','N','N','N','N'); INSERT INTO db VALUES ('193.179.240.197','XXX','YYY','Y','Y','Y','Y','N','N','N','N','N','N'); INSERT INTO db VALUES ('193.179.240.198','XXX','YYY','Y','Y','Y','Y','N','N','N','N','N','N'); Server Configuration is: RedHat v7.0 + Apache 1.3.14 + PHP 4.0.4pl1(patched zend_list.c) + MySQL v 3.23.33. Can somebody help me? What is wrong? Best regards Dave. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Aborted connections
Hi everyone, in mysql log file I found many, many errors as follows: 010224 13:32:43 Aborted connection 5 to db: 'XXX' user: 'YYY' host: `localhost' (Got an error reading communication packets) 010224 15:18:34 Aborted connection 6 to db: 'XXX' user: 'YYY' host: `localhost' (Got an error reading communication packets) 010224 15:44:00 Aborted connection 3 to db: 'XXX' user: 'YYY' host: `localhost' (Got an error reading communication packets) 010224 15:44:40 Aborted connection 11 to db: 'XXX' user: 'YYY' host: `localhost' (Got an error reading communication packets) 010224 15:44:55 Aborted connection 8 to db: 'XXX' user: 'YYY' host: `localhost' (Got an error reading communication packets) I read about this problem not a few articles, but described solution had no positive effect. Server Configuration is: RedHat v7.0 + Apache 1.3.14 + PHP 4.0.4pl1(patched zend_list.c) + MySQL v 3.23.33. Can somebody help me? What is wrong? Best regards Dave. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: upload of a patched myodbc driver
At 20:46 25/02/2001 +0100, Thomas Thaele wrote: Hi, You can download it at: ftp://support.mysql.com/pub/mysql/secret/ Thanks. Regards, Miguel Hi everyone. I applied a patch (for Omniform 4.0 support) to the myodbc driver and would like to upload the patched driver to the maintainers so that everybody in the near future can profit from it. Where do I have to send the driver? Best regards, Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solrzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ So Paulo, Brazil ___/ Development Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Redhat 7 newbie.....
I just installed Redhat 7.0 and MySql while i was at it. But the deamon is not running. I get the ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) when i try to use the client. Could someone please clue me in as to home I get this baby going... Thanks! Tom
Re: Redhat 7 newbie.....
when i try to use the client. Could someone please clue me in as to home I get this baby going... Thanks! Tom RTFM (Read The Fine Manual) :-) you can find it at www.mysql.com Search the archive: http://lists.mysql.com Checkout www.devshed.com Bye, B. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Redhat 7 newbie.....
Hi: Make sure MySQL is started when your system boots up. Run 'setup' as root and go to 'System Services' and make sure mysqld is checked. If you want to start the daemon without restarting run '/etc/init.d/mysqld start' as root. Seung-woo Nam Thomas O'Neill wrote: I just installed Redhat 7.0 and MySql while i was at it. But the deamon is not running. I get the ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) when i try to use the client. Could someone please clue me in as to home I get this baby going... Thanks! Tom - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Random record
Does anyone have any good ideas on how to pull a random record? I've been using PHP's random function to create a random number to pull, but the problem is that if I delete a record, it could still try to pull it. Is there a better way? I'd really like to be able to just pull it in the SQL statement instead of pulling a bunch of records then sorting throught that. Thanks, JOE
Re : Question???
At 11:15 22/02/2001 +0800, edith wrote: Hi, Other Microsoft products like Access doesn't permit the edition of MySQL tables without a primary key on the table. If this is your case, try to add a primary key on the MySQL table. Regards, Miguel Dear Sir/Madam, I'm a Visual FoxPro programmer. I want to use MySQL database for my programs. However, I cannot update MySQL database with my Visual FoxPro programs through ODBC (but I can view the record of table). My commands are as follow: CREATE CONNECTION conn1 DATASOURCE "MySQL" USERID "users" DATABASE "tempdata" STORE SQLSTRINGCONNECT('dsn=MySQL; uid=root; pwd=') TO xConnHandle //return of 'xConnHandle' is positive that means connection is successful// =SQLSETPROP(xConnHandle,'Transactions',2) //this return is negative that means there is an error on connection level// I don't know why I can view the table but I cannot update the table through ODBC. Would you help me to solve this problem? Thank you! Regards, Edith __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solrzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ So Paulo, Brazil ___/ Development Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Random record
Check the archives. The answer you seek is there. Cal http://www.calevans.com -Original Message- From: joe [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 25, 2018 5:40 PM To: MySQL Subject: Random record Does anyone have any good ideas on how to pull a random record? I've been using PHP's random function to create a random number to pull, but the problem is that if I delete a record, it could still try to pull it. Is there a better way? I'd really like to be able to just pull it in the SQL statement instead of pulling a bunch of records then sorting throught that. Thanks, JOE - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Random record
Instead of pulling using equals, ie "select * from table where id = $php_random_variable" you can do this instead "select * from table where id = $php_random_variable LIMIT 1"... As long is there is atleast one row in the table you will get back a result. Hope that helps. ryan - Original Message - From: "joe" [EMAIL PROTECTED] To: "MySQL" [EMAIL PROTECTED] Sent: Sunday, February 25, 2018 5:39 PM Subject: Random record Does anyone have any good ideas on how to pull a random record? I've been using PHP's random function to create a random number to pull, but the problem is that if I delete a record, it could still try to pull it. Is there a better way? I'd really like to be able to just pull it in the SQL statement instead of pulling a bunch of records then sorting throught that. Thanks, JOE - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: XML support under mySQL
At 10:37 AM -0600 2/25/01, Cal Evans wrote: Glorious Sunday morning greetings to you Jan, No, XML is a format for 2 different applications, usually 2 totally separate applications, to be able to exchange data. It is not an appropriate choice for storing large amounts of data that will have to be queried. Nor is it an appropriate choice of language for talking to an RDBMS. Outside of the fact that it can be extremely verbose, we already have a perfectly good language for that, SQL. SQL is a language for committing data to a storage mechanism and retrieving the data back. It is superior to XML in those tasks. Is anybody on this thread really rationally suggesting using XML instead of SQL? I hope not. It would no longer be an SQL database. Of course SQL is the language for committing data to the storage mechanism. What the data consists of is another matter. If some of my data is a paragraph of text of which some of the words may be bold, others italics and so on, then I will want to make this formatting information part of my data by using XML, RTF or some other tagged structure. If anyone is suggesting that I shouldn't ever do this, but only use raw data, then they are nuts. On the other hand if its being argued that the formatting information should be separated from the raw data because you may want to look at it in both forms, I can buy that, but the formatting information is still data, still stored in the database, maybe just in a separate field if you like. If anyone is arguing that the formatting information should be stored in some other database, they are also nuts. Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error while trying to run binary mySQL on FreeBSD4.0
Hi all, I have just tried to use the mysql binary supplied for FreeBSD (mysql-3.23.32-unknown-freebsdelf4.2-i386.tar.gz) on FreeBSD4.0 I have gcc-2.95.2 installed. M problem is I get this error when I try and run the scripts/mysql_install_db: /usr/libexec/ld-elf.so.1: /usr/lib/libstdc++.so.3: Undefined symbol "__ti9exception" I also get the same error when I try and run mysql itself. Here is what the mysqlbug script returned: System: FreeBSD heffalump.ricshaw.com.au 4.0-RELEASE FreeBSD 4.0-RELEASE #0: Wed Aug 2 13:05:22 EST 2000 [EMAIL PROTECTED]:/usr/src/sys-altq/compile/ALTQ i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1128450 Mar 21 2000 /usr/lib/libc.a lrwxrwxrwx 1 root wheel 9 Jul 18 2000 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 531444 Mar 21 2000 /usr/lib/libc.so.4 Configure command: ./configure --enable-large-files Perl: This is perl, version 5.005_03 built for i386-freebsd Any heap will be much appreciated. Thankyou in advance. Drew Andrew Toussaint Richardson-Shaw Pty Ltd [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Max_allowed_packet variable ??
Hi, This is how I set the variables in the my.cnf file. [mysqld] set-variable = key_buffer_size=16M set-variable = max_allowed_packet=16M I can only insert 8M at any one time using SQLPutData. Even if I insert 1024K more, the SQLPutData will return a "Function sequence error". Does max_allowed_packet means half of what is stated? Coz I tried setting the max_allowed_packet=2M, and eventually I can only insert 1M at any one time. I'm not sure whether I have to set any other variables as well. Please advise. Thanks, Li Sze
Re: can create, cannot drop...?
Suggestion: Check file permissions. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, February 25, 2001 12:33 Subject: can create, cannot drop...? i'm newbie. how come i can create but cannot drop? (errno: 21) i am root. mysqladmin asks if i am sure... i say 'yes' and i get the same (can't rmdir. errno: 21) TIA - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: missing library libz.so
I'm assuming this is on Solaris. One workaround that you may be able to do is to set you LD_LIBRARY_PATH to the path where libz.so is. I've seen this problem with other products and it turned out to be a Solaris install issue. I had to back rev to 2.7 in order to get it to work. I _belive_ that later versions of Solaris 2.8 include this library, but am not sure. Brady... Original Message Follows From: "Rutger Beens" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: missing library libz.so Date: Sun, 25 Feb 2001 19:37:55 +0100 Hi there, I just installed mysql (3.23) but when I run mysql_install_db or mysqld it comes with an error message that the programming can't load the libz.so file. I've found that file online and copied it into all myysql directories but still it can't load the file. I propably should copy the file to the /local/lib directorie or something, but I can't acces those directories. So is it possible to disable the use of this lib or can I specify the path to it? I am using the binary version on a BSDI 4.01 server... Thanks! Rutger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get your FREE download of MSN Explorer at http://explorer.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't drop tables
I just installed mysql 3.23 and then ran a script to create a database I had previously been using in an older version. I have a couple questions. First, how can I make a drop database statement not fail if the database doesn't exist. A book I was using seemed to say: drop database dbname if exists; Would work, but I get an error with this. What is the correct syntax? Second, on this newest installation, I can't drop a database. I get the error "failed to rmdir ./dbname, errno 21" or something similar. If I su to my mysql user, and cd to the data directory, an rmdir dbname works successfully, so I'm not sure why this is failing. The actual data files in the database are all gone after the drop statement. Only the empty directory sticks around. Any help would be appreciated. Thanks, Geoff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
help configure mysql
It is appeat "restartable system calls .. configure:error can not run test program while cross compiling". thanks.
Got a Build for mysql-3.23.33 Alpha-Linux-2.4.2 64-bit
Greets All: I've got the above (subject) build created and, need to free up some space on the machine. Anyone want it, and, is there a good way to shrink it down or make a binary package? Let me know. Regards, Van -- = Linux rocks!!! http://www.dedserius.com = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Server Tuning
Hi I am running Mysql on a Machine with two PIII-600, and 1 GB of RAM. The disks are connected via U2W-SCSI. I tried tuning mysql for maximal performance the last days, but I'm not exactly sure which parameters I should increase, und to what value. Our web application is quite slow at the moment, and often the server is slower in doing the queries than they are created by the users, which steadily increases the number of running mysql-processes until they reach max_connection (which is 100 at the moment). Our Application searches through about 1.000.000 Records, and does heavy grouping, sometimes over 100.000 records. Is there any chance, that we can keep doing this queries on the fly, or will we have to cache them somehow? (which has a _lot_ of downsides, since the data changes quite frequently, about once every 1/2 hour). Which server parameters should we increase to make things faster? Since a lot of users "do the same thing" on this website, we often have the very _same_ query running 5 to 10 times, one started within 5 seconds or so after the other. Is there a way the prevent mysql from doing the query twice, and instead just wait for the first to be finished and then return the result to both clients? If not, I will code this feature in PHP, using shared memory unless anyone has already done this and is willing to share the code. Greetings, Florian Pflug - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Max_allowed_packet variable ??
At 09:54 26/02/2001 +0800, Li Sze wrote: Hi! Did you read with attention the ODBC documentation about sending long data ?. For example SQLPutData is used to send pieces of data exactly to work on limited memory resources, in the code you define the size of data which is send at every time, how to control when the each piece and the whole input operation is completed. If you don't have the ODBC documentation, I advice you to download from Microsoft the Data Access SDK and read the relative articles. With this I don't mean that we can't have a problem on the MyODBC code to handling large binary data, but without you have used all the recommendations about, we can not to put work time for this unusual case. Regards, Miguel Hi, This is how I set the variables in the my.cnf file. [mysqld] set-variable = key_buffer_size=16M set-variable = max_allowed_packet=16M I can only insert 8M at any one time using SQLPutData. Even if I insert 1024K more, the SQLPutData will return a "Function sequence error". Does max_allowed_packet means half of what is stated? Coz I tried setting the max_allowed_packet=2M, and eventually I can only insert 1M at any one time. I'm not sure whether I have to set any other variables as well. Please advise. Thanks, Li Sze __ ___ __ / |/ /_ __/ __/ __ \/ / http://www.mysql.com/ / /|_/ / // /\ \/ /_/ / /__ Miguel Solrzano [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ So Paulo, Brazil ___/ Development Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql is really a slow rdbms
This table contains more than 2.5 million records. I created index on column hari. It needs more than 3797 secs, and have not finished yet. Anybody has advice? mysql describe tb_trafik_bulanan; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | thn | smallint(5) unsigned | YES | | NULL | | | bln | tinyint(3) unsigned | YES | | NULL | | | hari | tinyint(3) unsigned | YES | | NULL | | | id_hari | int(10) unsigned | YES | | NULL | | | kd_link | char(4) | YES | | NULL | | | ip_asal | int(10) unsigned | YES | MUL | NULL | | | sip_asal | char(19) | YES | | NULL | | | port_asal | smallint(5) unsigned | YES | MUL | NULL | | | ip_tujuan | int(10) unsigned | YES | MUL | NULL | | | sip_tujuan| char(19) | YES | | NULL | | | port_tujuan | smallint(5) unsigned | YES | MUL | NULL| | | jml_byte | int(10) unsigned | YES | | NULL | | | jml_flow | smallint(5) unsigned | YES | | NULL | | | jml_packet| int(10) unsigned | YES | | NULL | | | kd_neg| char(2) | YES | MUL | NULL | | | id_pelanggan | char(8) | YES | MUL | NULL | | | kd_jasa | char(2) | YES | MUL | NULL | | | arah_dan_tipe | tinyint(3) unsigned | YES | MUL | NULL| | | kd_server | char(2) | YES | MUL | NULL| | | kd_non_server | char(2) | YES | MUL | NULL| | +---+--+--+-+-+---+ mysql show processlist; +++---+--+-+--+--+---+ | Id | User | Host | db | Command | Time | State| Info | +++---+--+-+--+--+---+ | 31 | netmon | localhost | tracemon | Query | 3797 | Repair with keycache | create index hari on tb_trafik_bulanan (hari) | | 40 | netmon | localhost | tracemon | Query | 0 | NULL | show processlist | +++---+--+-+--+--+---+ 2 rows in set (0.00 sec) regards -ilham- __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.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
create table
Anyone can give me an example of create a transactional table in V3.22.23? Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: create table
On Mon, Feb 26, 2001 at 01:26:55PM +0800, WANG_KING wrote: Anyone can give me an example of create a transactional table in V3.22.23? Thanks. Simply append "Type=BDB" to any CREATE TABLE statement. CREATE TABLE foo ( bar int not null, baz varchar(10) not null ) Type=BDB Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
??: create table
Hi,Thanks.I just do so. But how can I make mysql supported by BDB On Mon, Feb 26, 2001 at 01:26:55PM +0800, WANG_KING wrote: Anyone can give me an example of create a transactional table in V3.22.23? Thanks. Simply append "Type=BDB" to any CREATE TABLE statement. CREATE TABLE foo ( bar int not null, baz varchar(10) not null ) Type=BDB Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql is really a slow rdbms
It is not that mysql it slow, its your database design and the fact you have 2.5 million records in the table. It is not clear from your description of the problem what you are trying to do, so giving advice is that much harder. If you are creating an index on the column hari, it will take a long time. However this time is negligable because you only do it once, and never again. But if you are talking about a query that uses the column hari going slow, making it a key in the table will speed up your query considerably. Hope this helps. This table contains more than 2.5 million records. I created index on column hari. It needs more than 3797 secs, and have not finished yet. Anybody has advice? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: XML support under mySQL
Michael, Is anybody on this thread really rationally suggesting using XML instead of SQL? I hope not. It would no longer be an SQL database. Of course SQL is the language for committing data to the storage mechanism. What the data consists of is another matter. I'm suggesting there is a good reason for allowing access to a database in XML in parallel to SQL. I don't care it wouldn't be an SQL database. Please, read on. If some of my data is a paragraph of text of which some of the words may be bold, others italics and so on, then I will want to make this formatting information part of my data by using XML, RTF or some other tagged structure. If anyone is suggesting that I shouldn't ever do this, but only use raw data, then they are nuts. On the other hand if its being argued that the formatting information should be separated from the raw data because you may want to look at it in both forms, I can buy that, but the formatting information is still data, still stored in the database, maybe just in a separate field if you like. If anyone is arguing that the formatting information should be stored in some other database, they are also nuts. You shouldn't forget that formatting markup is just one use of XML. The other one, perhaps the by far the most progressive one, being semantics markup. To see the difference, let's take the example of an invoice. If it's represented in a formatting-driven markup, it goes like: h1Invoice no. 1/2001/h1 p iCustomer:/ibr / MathAn Praha, Ltd.br / Dlazdena 4br / Prahabr / CZ-11000br / Czech Republicbr / Europe /p table tr thItem #/th thItem description/th thQuantity/th thUnit price/th thAmount/th /tr tr td1/td tdMySQL license/td td1/td td200 USD/td td200 USD/td /tr tr td2/td tdMySQL e-mail support/td td1 year/td td170 EURO/year/td tdEURO 170/td /tr tr th colspan="4"Total/th tdb342.45 USD/b/td /tr /table That was HTML, purely presentation. But machines will also need to understand invoices. The same invoice could be written as: invoice id="invoice:1/2001" customer party company-nameMathAn Praha, Ltd./company-name address type="street" site="HQ" address-linestreetDlazdena/street house-number4/house-number/address-line address-linezip-codeCZ-11000/zip-code cityPraha/city/address-line address-linecountryCzech Republic/country, continentEurope/continent/address-line /address /party customer invoice-lines invoice-line order="1" item code="124897435" description xml:lang="en"MySQL license/description description xml:lang="cs"Licence MySQL/description /item quantity units="piece"1/quantity unit-price units="USD/piece"200/unit-price amount units="USD"200/amount /invoice-line invoice-line order="2" item code="124897439" description xml:lang="en"MySQL basic e-mail support/description description xml:lang="cs"Zakladni e-mailova podpora MySQL/description /item quantity units="piece/year"1/quantity unit-price units="EUR/piece*year"170/unit-price amount units="EUR"170/amount /invoice-line /invoice-lines invoice-total total units="USD"342.654/total /invoice-total /invoice O.k., a real invoice will have a bit more information in it, but that's not important here. Now, take the data-oriented markup. To represent the same information in a relational database, you'll need several tables: Invoice, InvoiceLine, Item, ItemDescription, Language(a look-up table), Unit (another look-up table), Party, and Address. You can parse the document and isolate every XML element value and every XML attribute and insert them into appropriate columns of the tables. Probably a glue script to do this is the best choice today. Likewise, you can take the data stored in the tables of the RDBMS and run "a few" selects on them and combine the results in such a way that the XML document for the invoice comes to existence. Again, a glue script is a clear candidate to do the job. Now, I'm claiming that in a future that's not at all distant, the need to do these conversions more and more often will lead to the following consequences: 1. The XML - RDBMS translation will be understood theoretically and a formal language to describe the mapping will arise. 2. DBMS's will be incorporating the translation functionality, for efficiency and ease-of-use of the XML side of a DBMS will get focus. The XML interface will call the internal storage API of the DBMS, not any SQL tier. 3. With XML becoming more and more popular, data structures we'll be getting from a DBMS will move from linear tables to trees. Even internally, the database engines will start storing data in something else than tables. 4. The SQL interface will continue to exist and work, but it will not be the only interface to the data in the database. Alternative interfaces will rise, some of which may be based on XML. Michael, admit that an XML interface to database would give additional
Re: mysql is really a slow rdbms
Just simple question.. why u designed it such a way that differentiate the 'thn','bln' and 'hari' field when you can do it just using one field and using DATE type field instead of integer. and when you query u can use your SQL sorting to speed up searching. Regards Teddy - Original Message - From: "Muhammad Ilhami" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 26, 2001 12:41 PM Subject: mysql is really a slow rdbms This table contains more than 2.5 million records. I created index on column hari. It needs more than 3797 secs, and have not finished yet. Anybody has advice? mysql describe tb_trafik_bulanan; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | thn | smallint(5) unsigned | YES | | NULL | | | bln | tinyint(3) unsigned | YES | | NULL | | | hari | tinyint(3) unsigned | YES | | NULL | | | id_hari | int(10) unsigned | YES | | NULL | | | kd_link | char(4) | YES | | NULL | | | ip_asal | int(10) unsigned | YES | MUL | NULL | | | sip_asal | char(19) | YES | | NULL | | | port_asal | smallint(5) unsigned | YES | MUL | NULL | | | ip_tujuan | int(10) unsigned | YES | MUL | NULL | | | sip_tujuan | char(19) | YES | | NULL | | | port_tujuan | smallint(5) unsigned | YES | MUL | NULL | | | jml_byte | int(10) unsigned | YES | | NULL | | | jml_flow | smallint(5) unsigned | YES | | NULL | | | jml_packet | int(10) unsigned | YES | | NULL | | | kd_neg | char(2) | YES | MUL | NULL | | | id_pelanggan | char(8) | YES | MUL | NULL | | | kd_jasa | char(2) | YES | MUL | NULL | | | arah_dan_tipe | tinyint(3) unsigned | YES | MUL | NULL | | | kd_server | char(2) | YES | MUL | NULL | | | kd_non_server | char(2) | YES | MUL | NULL | | +---+--+--+-+-+---+ mysql show processlist; +++---+--+-+--+- -+---+ | Id | User | Host | db | Command | Time | State| Info | +++---+--+-+--+- -+---+ | 31 | netmon | localhost | tracemon | Query | 3797 | Repair with keycache | create index hari on tb_trafik_bulanan (hari) | | 40 | netmon | localhost | tracemon | Query | 0 | NULL | show processlist | +++---+--+-+--+- -+---+ 2 rows in set (0.00 sec) regards -ilham- __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: XML support under mySQL
Cal, Cal Evans wrote: Glorious Sunday morning greetings to you Jan, No, XML is a format for 2 different applications, usually 2 totally separate applications, to be able to exchange data. It is not an appropriate choice for storing large amounts of data that will have to be queried. But the XML markup is just a manifestation of a deeper structure: trees. Trees are more general than tuples, a piece of XML can convey more information than a piece of a relational table. Nor is it an appropriate choice of language for talking to an RDBMS. Outside of the fact that it can be extremely verbose, ...it compresses magnificiently... we already have a perfectly good language for that, SQL. SQL is a language for committing data to a storage mechanism and retrieving the data back. It is superior to XML in those tasks. No. SQL is limited by the linear structure of tables. If you need to retrieve/store more complex information, you need to place several SELECTs/INSERTs in a row. Compare this to the rich structure of trees XML is based on. I know I can represent a Request for Quote in one XML document, but the same thing would take me five tables of a relational database. I know I can represent a Quote - which is a result of the Request for Quote query - with just one XML document, while the same thing would take me at least four relational tables. Again, if you have need to talk to your RDBMS via XML then a thin wrapper written in the language of your choice is the proper way to go. This allows you to do your job without bloating my application with unnecessary code. I'm already tired of thin wrappers. Plus they are not exactly efficient; the two overheads are in place and hogging: 1. The client/server communication overhead, even if we go locally thru a socket; 2. The SQL overhead of having to parse, understand and optimize a query can kill you on thousands of queries. As a rule, new functionalities in MySQL are optional. You don't have to enable them. And I also disagree with your statement that there is no difference between metadata and data. there most certainly is. But that's a discussion for another thread. It's always data. You call it metadata if it describes some other data. But on its own, it's data in the first place. humbly, Cal http://www.calevans.com Yours, Jan p.s. another reason not to include it is NOBODY wants to distract the MySQL coders from getting 4.0 frozen and out the door! :) Hey, eventually a good reason against XML in MySQL! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jan Dvorak Sent: Sunday, February 25, 2001 10:13 AM To: Ed Carp Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: XML support under mySQL Ed Carp wrote: Gorjan Todorovski ([EMAIL PROTECTED]) writes: Since XML is a way to exchange data...and it is protocol/platform indepdnent there is a very good reason to have XML docuemts going in and out the No, it's not. You store *data* in a database, *not* metadata. Do you understand the difference? There is no difference. What is metadata in one context, is data in another context. It's just a matter of your standpoint, which can change with time. XML is a format to store/exchange data. Jan Dvorak - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php