Re: .org
Dear Paul, I have a high respect and esteem for you, your book and your valuable and effective answers to questions made by dozens of MySQL users. I am really sorry if I have offended you with my previous e-mail. I think, we are very busy at work, and it is better to leave for the lawyers the solution of the MySQL-NuSphere conflict. However, just as a simple MySQL/PHP/Java/Apache user, I still thinking that MySQL is doing the right thing. Best regards, Santi Paul DuBois wrote: At 9:34 AM +0100 7/16/01, Santi Chumbe wrote: Interesting position. The NuSpheres people are really very clever. If I'm reading your statement correctly, you appear to be using clever as an innuendo for mendacious. If that is so, I must respectfully disagree, and point out that statements of that nature are not helpful to the discussion. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: locking problem!
I have got an example with a simple and very often used select here also... | 28 | DELAYED | localhost| dbSmurfa | Delayed_insert | 1| Waiting on cond | GuestBook | 479 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | SELECT Users.ID, Users.Alias | 480 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | SELECT Users.ID, Users.Alias | 496 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | UPDATE Users SET Logons=Logons+1 | 494 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 0| Locked | UPDATE Users SET Logons=Logons+1 | 511 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | SELECT Users.ID, Users.Alias | 517 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | SELECT Users.ID, Users.Alias | 518 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | SELECT Users.ID, Users.Alias | 528 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | SELECT Hits FROM UserCounters | 525 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | SELECT Hits FROM UserCounters | 523 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | SELECT Hits FROM UserCounters | 531 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | SELECT Users.Alias, Users.ID | 536 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | SELECT ID, Alias, Name, Email | 539 | smurfa | smurfa-www.inets.net | dbSmurfa | Sleep | 0| | NULL | 538 | smurfa | smurfa-www.inets.net | dbSmurfa | Sleep | 0| | NULL | 537 | smurfa | smurfa-www.inets.net | dbSmurfa | Sleep | 0| | NULL | 546 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | SELECT Users.ID, Users.Alias | 549 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | SELECT Users.ID, Users.Alias | 533 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | SELECT ID, Alias, Name, Email | 532 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | UPDATE UserCounters SET Hits=Hits+1 | 530 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | UPDATE UserCounters SET Hits=Hits+1 | 550 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | SELECT MezzIndex.ID, MezzIndex.Title | 553 | root| localhost| NULL | Query | 0| NULL| show processlist | 555 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Sending data| SELECT ID, Alias, Password | 556 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 0| Locked | SELECT Users.ID, Users.Alias | 558 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | UPDATE UserCounters SET Hits=Hits+1 | 557 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | UPDATE Users SET LastAccess= | 559 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 1| Locked | SELECT ID, Alias, Password | 560 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 0| Locked | SELECT Users.ID, Users.Alias | 561 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 0| Locked | UPDATE Users SET LastAccess= | 562 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 0| Locked | SELECT MezzIndex.ID, MezzIndex.Title | 563 | smurfa | smurfa-www.inets.net | dbSmurfa | Query | 0| Locked | SELECT MezzIndex.ID, MezzIndex.Title - Original Message - From: "Andrius Armonas" [EMAIL PROTECTED] To: "Johan Wahlstrm" [EMAIL PROTECTED] Sent: Tuesday, July 17, 2001 6:19 AM Subject: Re: locking problem! if you're using write lock and do not unlock tables for a longer time, it is normal. .:: Andrius Armonas ::. .:: [EMAIL PROTECTED] ::. .:: http://baubas.andrius.org ::. - Original Message - From: "Johan Wahlstrm" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 16, 2001 10:12 PM Subject: locking problem! I have problem with table lockings scince i upgraded the MySQL version, and i have tried with both RedHat 7.1 rpm version 2.23.36 and compile myself with 2.23.39. The result is the same. As can be seen in the "screenshot" below there is one process running, and a lot sleeping. In this example it happens to be an update running, but it might as well be an INSERT or SELECT. When the lock is released the server starts working on all locked querries at the same time, the result is a slow server with a load average around 60 where it can be run
Install MySQL GUI
Sir, I'm using Linux Mandrake 8.0. This is the first time I'm using Linux OS. My question is: how to install MySQL GUI to Linux. Please help me. Thank you very much. My email : [EMAIL PROTECTED] Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 with a LEFT JOIN
At 09:02 16.07.01 -0700, John Hawkins wrote: I'm having a bit of trouble doing a LEFT JOIN. Any input would be greatly appreciated. table 1 (sites, has approx 30 records) has a list of sites with the following fields: ID, sitename, url table 2 has (ratings, has approx 2020 records) has a list of member ratings for the different sites with the following fields: ID, siteID, memID, rating - sites.ID matches up with ratings.memID - memID is the ID of the member who performed this rating Is this really so?? it should be sites.ID matches ratings.siteID? I want to show the member who is logged in a list of all the sites that he has not yet rated. here is the select statement I have created, but isn't quite working: SELECT sites.* FROM sites LEFT JOIN ratings ON sites.ID = ratings.siteID WHERE ratings.memID != '1' then the select looks like that: SELECT sites.* FROM sites LEFT JOIN ratings ON sites.ID = ratings.siteID WHERE sites.ID = ratings.siteID and ratings.memID!=1 Or have I understand something wrong?? Regards Gerlinde I am getting approx 2020 results (which, oddly enough, matches the amount of records I have in the ratings table). Like I said, any help would be greatly appreciated. Best, John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php BLITZ Internet Service GmbH Kronacher Strasse 41 D-96052 Bamberg, Germany Tel. +49/951/9685160, Fax +49/951/9685164 http://www.blitz.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Beginner help with selecting
Hello, can you send the datastruktur, so it is difficult to answer your question. You don't need, if the other answers were ok. Regards Gerlinde Fischer At 08:40 16.07.01 -0400, Technodium.net wrote: Hello there, I would need some help with a select statement for my databases. I've done all the design of the database and I think it's all good, but I can't make a select as I want to do it. There is the problem: I have one table for the list of events and one for the list of djs for this event. I have also one linking table with the list of events keys with their according djs I would like to do a select so that for one event it gives me all the djs.. But I'm not able to do it. And after that I'd like to dothe same to be able to get the djs, the outlets, etc in less queries than getting the djs ID from the linking table and then doing a new query in the dj table to get the info If you'd like more info please don't hesitate.. This bug is stopping my progress in the DB design and I can't get help anywhere for this Etienne BLITZ Internet Service GmbH Kronacher Strasse 41 D-96052 Bamberg, Germany Tel. +49/951/9685160, Fax +49/951/9685164 http://www.blitz.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 error
Hi, I just installed a new version of mysql (not the latest) 3.23.36 which came with rh 7.1 cd. I know that it is buggy but I have the following problems that have been discussed in the list. I search the archives but did not see how the problem got solved. The error: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) I did a ps aux | grep mysqld root 924 0.0 0.0 18560 ?SW 09:55 0:00 [safe_mysqld] mysql 974 0.0 0.0 12252 24 ?S09:55 0:00 [mysqld] mysql 986 0.0 0.0 12252 24 ?S09:55 0:00 [mysqld] mysql 987 0.0 0.0 12252 24 ?S09:55 0:00 [mysqld] When I try to restart or stop using /etc/init.d/mysqld stop Stopping MySQL:[FAILED] The log shows : 010717 12:34:42 mysqld started 010717 12:34:43 Can't start server: Bind on TCP/IP port: Address already in use010717 12:34:43 Do you already have another mysqld server running on port: 3306 ? 010717 12:34:43 Aborting 010717 12:34:43 mysqld ended 010717 12:50:02 mysqld started 010717 12:50:02 Can't start server: Bind on TCP/IP port: Address already in use010717 12:50:02 Do you already have another mysqld server running on port: 3306 ? 010717 12:50:02 Aborting 010717 12:50:02 mysqld ended 010717 12:55:26 mysqld started /usr/libexec/mysqld: ready for connections I tried to change the /etc/my.cnf socket to /tmp/mysql.sock but I still get the error ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) How do I solve this as I am in the middle of a web database project TIA Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
jdbc connection to mysql in linux
this is my code: import java.sql.*; import java.util.*; public class Connected { public static void main (String[] args) throws Exception{ Connection con = null; try{ String url = jdbc:mysql://localhost:3306/mydatabase; Statement stmt; ResultSet rs; Class.forName(org.gjt.mm.mysql.Driver).newInstance(); System.out.println(Class.forName); con = DriverManager.getConnection(url,root,mypasswd); stmt = con.createStatement(); } catch(SQLException e) { System.out.println(Unable to load driver.); e.printStackTrace(); } finally{ if (con != null){ try{con.close();} catch (Exception e){} } } } } my dir structure in linux is as such: mysql dir -- /usr/local/mysql mmmysql dir -- /usr/local/mysql/mmmysql source code resides in -- /usr/local/mysql source code able to be complied, but when run, gives the error: Unable to load driver. java.sql.SQLException: Invalid authorization specification: Access denied for user:'[EMAIL PROTECTED]'( Using password: YES) at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:330) at org.gjt.mm.mysql.Connection.connectionInit(Connection.java:261) at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Connection.java:89) at org.gjt.mm.mysql.Driver.connect(Driver.java:167) at java.sql.DriverManager.getConnection(DriverManager.java:517) at java.sql.DriverManager.getConnection(DriverManager.java:177) at Connected.main(Connected.java:16) Can anyone please help? thks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
terminal display width?
Hi, I like to chyeck my mysql db's/tables using the unix command line, and doing a select * from table. However some field are very long - varchar 255 - is there a way to set the display width when viewing the data. ie - so that binary/large text fields are truncated after a few characters. That way I would be able to see all the columns clearly. Thanks Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
VB?
Hi, Is it possible to use Visual Basic to access a MySQL db running under NT? Regards, Jim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Return query from php- seperate into several pages
Hi all, php beginner say, I have query from a php page that returns several rows, but I don't want to display them all in a single page, but separate them in several pages and then be able to navigate by means of next and previous. Codes snippet would be very helpful. Kind of of page limit property. Thanks in advance Erymuzuan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: REPAIR TABLE question...
Hi, The manual http://www.mysql.com/doc/R/E/REPAIR_TABLE.html mentions the QUICK and EXTENDED options for REPAIR TABLE. But it does not say which is the default. Anyone know? I think the default might actually be neither. I think the two options correspond roughly to two options of the myisamchk program (unless someone can correct me). EXTENDED probably matches the '--extend-check' option and QUICK matches the '--quick' option. According to the help text they do this: --extend-check: Try to recover every possible row from the data file. Normally this will also find a lot of garbage rows; Don't use this option if you are not totally desperate. --quick: Faster repair by not modifying the data file. One can give a second '-q' to force myisamchk to modify the original datafile in case of duplicate keys. I agree that this section of the manual could do with some clarification. It only seems to talk about re-creating indexes... Regards, Basil Hussain --- Internet Developer, Kodak Weddings E-Mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: terminal display width?
Hi, I like to chyeck my mysql db's/tables using the unix command line, and doing a select * from table. However some field are very long - varchar 255 - is there a way to set the display width when viewing the data. ie - so that binary/large text fields are truncated after a few characters. That way I would be able to see all the columns clearly. Although you cannot get the mysql client program to truncate output of BLOB or TEXT fields, you can get it to output results in a format other than the default horizontal table style. If you terminate your query string with '\G' (as opposed to ';' or '\g') you will get the vertical output format, like so: mysql select * from mytable limit 3\G *** 1. row *** category_code: 0 agent_code: 14427 *** 2. row *** category_code: 0 agent_code: 14562 *** 3. row *** category_code: 0 agent_code: 44114 3 rows in set (0.00 sec) This has the benefit of long text fields being wrapped on your display. Regards, Basil Hussain --- Internet Developer, Kodak Weddings E-Mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Incorrect manipulation of some czech characters under WIN32
Hi, I have this problem with czech characters under WIN32 (exactly MySQL ver. 3.23.33, today upgraded to 3.23.39a running on Win98, ODBC ver. 2.50.33): czech characters (s with wedge), (S with wedge), (z with wedge) and (Z with wedge) are improperly sorted and manipulated (e.g. with lower and upper functions). By me this is done by differences in iso latin charset used normally by MySQL on UNIX installations and charset used by Win32: - is 0x9A on WIN32 comparing to 0xB9 used in MySQL - is 0x8A (instead of 0xA9) - is 0x9E (instead of 0xBE) - is 0x8E (instead of 0xAE). Is this problem caused by improper setting in e.g. MyODBC driver, or is there a bug in MySQL? By me this should be solved by character translations by ODBC driver, because hard coding charsets into MySQL will do it not platform independent. Thanks for your help Vladimir Horsky
Contact
I have made a script in PHP which creates a table in my MySQL database on Linux environment. When I run the script and give the name of table to create, there isn't problem if I'm using ASCII; but if I use a Japanese Charater encoded (JIS), I'm getting error message on those encoded characters, they are converted in ASCII codes with special charters + numbers, and mysql cannot takes it for a name of table!. I need help on this matter. Alain.
RE: mysql error
as opposed to using safe_mysqld try starting mysql using /etc/init.d/rc.d/mysql start and stopping using /etc/init.d/rc.d/mysql stop I had the same problem on a cobalt raq running a variant of red hat and that solved it. Sean -Original Message- From: Adrian D'Costa [mailto:[EMAIL PROTECTED]] Sent: 17 July 2001 08:32 To: Mysql Mailing List Subject: mysql error Hi, I just installed a new version of mysql (not the latest) 3.23.36 which came with rh 7.1 cd. I know that it is buggy but I have the following problems that have been discussed in the list. I search the archives but did not see how the problem got solved. The error: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) I did a ps aux | grep mysqld root 924 0.0 0.0 18560 ?SW 09:55 0:00 [safe_mysqld] mysql 974 0.0 0.0 12252 24 ?S09:55 0:00 [mysqld] mysql 986 0.0 0.0 12252 24 ?S09:55 0:00 [mysqld] mysql 987 0.0 0.0 12252 24 ?S09:55 0:00 [mysqld] When I try to restart or stop using /etc/init.d/mysqld stop Stopping MySQL:[FAILED] The log shows : 010717 12:34:42 mysqld started 010717 12:34:43 Can't start server: Bind on TCP/IP port: Address already in use010717 12:34:43 Do you already have another mysqld server running on port: 3306 ? 010717 12:34:43 Aborting 010717 12:34:43 mysqld ended 010717 12:50:02 mysqld started 010717 12:50:02 Can't start server: Bind on TCP/IP port: Address already in use010717 12:50:02 Do you already have another mysqld server running on port: 3306 ? 010717 12:50:02 Aborting 010717 12:50:02 mysqld ended 010717 12:55:26 mysqld started /usr/libexec/mysqld: ready for connections I tried to change the /etc/my.cnf socket to /tmp/mysql.sock but I still get the error ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) How do I solve this as I am in the middle of a web database project TIA Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.org (comments to old messages)
Monty: You started MySQL as a database server derived from msql several years ago, and, you made it quick. You made it a bunch of other things, but, what's most important is that you made it quick. You made it stable. Quick is good. Stable is better. When both are paired, it's a pure win. This is YOUR contribution. Your development and any assistance you got from the community and crew. Take credit. It's yours. We might have given suggestions, but, you wrote the code. We use it. And, we love how it works. isam, mysam, gemini, bdb, etc., table implementations are meaningless unless we know what is behind it. What's useful to me is that I can start a new application using the same db engine I've used for 5 years and not have to worry that it's going to corrupt my data. I know the interfaces, and, the new features I can use. ISAM is fine, or MySAM. I'll program on the front. I love stability. What is Gemini? And, what will it do for my clients that MySQL hasn't done for the past 5 years using ISAM, or MySAM? Put that on the NuSphere.Org site (whoops; mysql.org site). I don't care. My clients want stability and speed and a development community they can trust and who's track record they can check. They already have it. That's how you, Sinisa, David, and crew (MySQL AB) put this stuff together. That's why we all stuck around. Because it's great stuff and we've built useful, stable, quick applications using it. And, you and Sinisa are always here. I don't know how you do it. Perhaps, because you know it has a credible future. I'd hope Progress could see the light. Best Regards, Van Regards, Monty PS: Thanks for all support. If anyone thinks I am unfair in any of the comments above, feel free to write privately to me about this and I will try to correct myself in future postings. It's quite hard to keep ones temper in check when one is burning with passion to defend oneself and the thing one has been part of creating. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- = Linux rocks!!! http://www.dedserius.com/ = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql.org (comments to old messages)
http://www.nusphere.org Is available to register but I don't now why you would what to ;o).? Simon -Original Message- From: Van [mailto:[EMAIL PROTECTED]] Sent: 17 July 2001 10:36 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: mysql.org (comments to old messages) Monty: You started MySQL as a database server derived from msql several years ago, and, you made it quick. You made it a bunch of other things, but, what's most important is that you made it quick. You made it stable. Quick is good. Stable is better. When both are paired, it's a pure win. This is YOUR contribution. Your development and any assistance you got from the community and crew. Take credit. It's yours. We might have given suggestions, but, you wrote the code. We use it. And, we love how it works. isam, mysam, gemini, bdb, etc., table implementations are meaningless unless we know what is behind it. What's useful to me is that I can start a new application using the same db engine I've used for 5 years and not have to worry that it's going to corrupt my data. I know the interfaces, and, the new features I can use. ISAM is fine, or MySAM. I'll program on the front. I love stability. What is Gemini? And, what will it do for my clients that MySQL hasn't done for the past 5 years using ISAM, or MySAM? Put that on the NuSphere.Org site (whoops; mysql.org site). I don't care. My clients want stability and speed and a development community they can trust and who's track record they can check. They already have it. That's how you, Sinisa, David, and crew (MySQL AB) put this stuff together. That's why we all stuck around. Because it's great stuff and we've built useful, stable, quick applications using it. And, you and Sinisa are always here. I don't know how you do it. Perhaps, because you know it has a credible future. I'd hope Progress could see the light. Best Regards, Van Regards, Monty PS: Thanks for all support. If anyone thinks I am unfair in any of the comments above, feel free to write privately to me about this and I will try to correct myself in future postings. It's quite hard to keep ones temper in check when one is burning with passion to defend oneself and the thing one has been part of creating. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- = Linux 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error while trying to compile MySQL 4.0
Fournier Jocelyn [Presence-PC] writes: Hi, Compilation fail with the following error message : makeinfo -I . --no-headers --no-split --output manual.txt manual.texi Fabrication du fichier text «manual.txt» à partir de «manual.texi». manual.texi:56: Commande inconnue «setcontentsaftertitlepage».. What should I do to fix the error ? Thank you, Jocelyn Fournier Presence-PC Get more recent makeinfo or add --force in the command args. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Enable BDB table handler
MikemickaloBlezien [EMAIL PROTECTED] writes: I have a client using MySQL 3.23.37. We wanted to use the Berkeley tables but for some reason they are disabled. when I do a show variables I get: have_bdb NO What is the best way to permanently enable the BDB type tables?? THX's Mike(mickalo)Blezien Get latest MySQL-Max distro dor that OS. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How Can I disable the use of temporary tables in a select wuth left join sentence?
the explain of this sentence shows that mysql uses temporary tables, and this was slow (think about the sentence only takes one record in his Limit Clause) of course all the fields used in relations and orders in the sentence are primary keys. SELECT CPOSTAL.* FROM CPOSTAL left JOIN PROVINCI ON CPOSTAL.COD=PROVINCI.COD AND CPOSTAL.PAIS=PROVINCI.PAIS ORDER BY CPOSTAL.IND LIMIT 1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ERROR 1060: Duplicate column name
Lance Lovette writes: Thanks for the clarification. Is it a MySQL bug then that the CREATE query converts all the VARCHAR fields into CHAR fields so the query 'CREATE TEMPORARY TABLE User2 SELECT * FROM User' creates a temporary table much larger than the User table? No, this is not a bug, this is a feature ... ;o) If you wish that VARCHAR are created instead of CHAR, then you should add TYPE=PACKED in CREATE statement. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Ynt: Slient install - Win32 Mysql
check : http://www.avukatpro.com/mysql.html for Visual Basic Mysql , Asp Mysql , Mysql Myodbc silent installation - Original Message - From: Eyal Rif [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, July 15, 2001 6:06 PM Subject: Slient install - Win32 Mysql Hi, I am trying to create a Mysql Install packages with other Programs (Such as apache). Does any one know what registry keys need to be updated or how can I perform a silent install of win32-mysql ? 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Ynt: VB?
yes : check : http://www.avukatpro.com/mysql.html for Visual Basic Mysql , Asp Mysql , Mysql Myodbc silent installation - Original Message - From: Evan James Dembskey [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Tuesday, July 17, 2001 11:26 AM Subject: VB? Hi, Is it possible to use Visual Basic to access a MySQL db running under NT? Regards, Jim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
invalid authorization. pls help!
Hi, i tried searching through the net for help, but could not find an answer. Could anyone out there please help? i'm running the mysql server on a redhat linux 7.0, kernel 2.2.16-22enterprise on a 2-processor i686. I've been trying to connect to a database but i keep getting the access denied error. I've logged in sucessfully using the exact userid and password at the mysql console, so my grant tables are definitly set correctly. this is my code: import java.sql.*; import java.util.*; public class Connected { public static void main (String[] args) throws Exception{ Connection con = null; try{ String url = jdbc:mysql://localhost:3306/mydatabase; Statement stmt; ResultSet rs; Class.forName(org.gjt.mm.mysql.Driver).newInstance(); System.out.println(Class.forName); con = DriverManager.getConnection(url,root,mypasswd); stmt = con.createStatement(); } catch(SQLException e) { System.out.println(Unable to load driver.); e.printStackTrace(); } finally{ if (con != null){ try{con.close();} catch (Exception e){} } } } } my dir structure in linux is as such: mysql dir -- /usr/local/mysql mmmysql dir -- /usr/local/mysql/mmmysql source code resides in -- /usr/local/mysql source code able to be complied, but when run, gives the error: Unable to load driver. java.sql.SQLException: Invalid authorization specification: Access denied for user:'[EMAIL PROTECTED]'( Using password: YES) at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:330) at org.gjt.mm.mysql.Connection.connectionInit(Connection.java:261) at org.gjt.mm.mysql.jdbc2.Connection.connectionInit(Connection.java:89) at org.gjt.mm.mysql.Driver.connect(Driver.java:167) at java.sql.DriverManager.getConnection(DriverManager.java:517) at java.sql.DriverManager.getConnection(DriverManager.java:177) at Connected.main(Connected.java:16) thks shane - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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[2]: I got it hanged !
Hello Jamie, Tuesday, July 17, 2001, 7:40:03 AM, you wrote: If I'm not mistaken this was other bug. At least I remember I've reported really same looking bug which make sometimes mysql hang after optimize or repair table (may be alter table also had it). JM I've been experiencing a simmilar problem only with MyISAM tables. JM This is under 3.23.35 and 3.23.36 on Sparc/Solaris 2.7. JM For me the problem occurs when doing an ALTER TABLE or a simmilar JM operation (eg OPTIMIZE) on relatively large tables (4 millon rows) JM with one or two indeces. JM The table in question is occasionally accessed by other queries; JM these access could occur during the ALTER TABLE. In this case, JM the application running the other queries would not mind seeing the JM old structure (for read) or wating until the ALTER is complete JM (for write). Yes. All of them was only read queries so it should not be the problem. But still I'm not quite shure how INNODB works in this case... JM The symptom is the same as described below; with ALL threads JM (not just those touching the ALTERed table) getting stuck in JM opening tables or closing tables. JM To recover it is necessary to terminate mysqld a SIGKILL; JM though data loss can usually be avoided by doing a JM FLUSH TABLES first (which also hangs) and also sending JM a SIGTERM and waiting a minute before sending the KILL. Well. I also used this with above bug. But with this bug it looks like killing mysqld does not make it to flush any tables, nor flush tables forks. So the only way is to kill it with 9th signal. JM Would upgrading to 3.23.39 fix this problem? Or is it JM still a live bug in the current version? Your bug probably allready fixed as I didn't have such bug using only MYISAM with mysql 3.23.39. -- Best regards, Petermailto:[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-compile mysql to use multiple character sets
Hi, I have configured mysql using the parameter --with-charset=latin2, made some databases and tables full of latin2 text. Now I have to add another database, which will store text in latin1. As I red the articles related to these problems, if I understand well, I have to do the followings: - shut down running mysql - do a configure --with-charset=latin2 --with-extra-charset=latin1 - do a make make install - keep all preexisting databases (including mysql itself) - run myisamchk -r -q on every table - start mysql Is this correct? Is there any other way to avoid re-compileing the whole mysql source distribution? If I want to feed my new database which uses latin1, how should I connect to the database from perl to be able to use latin1? What will happen with the old latin2 tables? Shall I use the connection method in the future that I use currently? Regards, Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
innodb and raw disks
Hi, In the InnoDB section of the MySQL manual, it mentions that InnoDB can be used with raw disks, rather than data files. I've been trying to get this to work under Linux (RedHat 6.2), but so far without success. I installed a new slave disk on the second IDE bus, brought up the system and verified that the disk was available and partitionable at /dev/hdd. Then, in /etc/my.cnf, I pointed innodb_data_home_dir and innodb_data_file_path at /dev/hdd, with a size calculated from the autodetected values as reported in /var/log/messages. I then started mysql: it reported that the given size was not the same as the actual file size for /dev/hdd, and ended. I delved into the code and ran a few experiments: the problem appears to be that the code uses the lseek system call to determine the file size, and this reports 0 for the /dev/hdd device special file. I tried using a raw device grafted onto the /dev/hdd device, but same result. Has anyone else tried this under Linux and, if so, have they got it to work? (If not, do we have a route towards getting it to work?) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication
I saw this in the manual comments on http://www.mysql.com/doc/R/e/Replication_Options.html: : Note that if you client does not do a USE dbname, binlog-do-db=dbname will not :binlog a query like: update in dbname.foobar set foo=1 You explicitly have to do a :USE before a query in order to have your query binlogged, it looks like. Replication on the slave side can do wildcard matches .. but the master cannot (a la binlog-wild-do-table=dbname.%). So make sure your clients do a use, if you plan to replicate those tables it updates. Is this still true in the latest version of MySQL? Is this behaviour by design? Cheers, Ollie -- Oliver CookSystems Administrator, ClaraNET [EMAIL PROTECTED] 020 7903 3065 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SMP on Sparc/Solaris7
Hi all, Is there someone which use mysql-3.22.* or mysql-3.23.* on a UltraSparc bi cpu with Solaris7? In my case, mysqld (with all its threads ;)) is always on one cpu... the second is never used... Thanks -- Cédric Gavage [EMAIL PROTECTED] [www] http://linuxbe.org - http://bsdbe.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
stupid install question
Dear support, I would like to use your GUI with my already installed and running mysql-3.23.39 on my Linux 7.1 ppc susie installation. As a real beginner to using Linux I quickly get stuck! I have downloaded the mysqlgui-1.7.5-1-linux-static tar file, and uncompressed it. The read-me states that to use this I need to move the binary mysqlgui into a PATH directory. I have tried copying the file into my bin directory and selecting it to run but nothing seems to happen. I'm sorry if this e-mail is not a strictly related mysql question but any help greatly appreciated - the screen shots look great - this will really help the productivity! Regards, Martin = | e-mail: [EMAIL PROTECTED] | | website: http://www.powerhouseuk.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
NT install Users/Permissions
Hello, I downloaded and installed the binary version about 2 months ago, and finally got into using mysql last week. All is well, and I am using the command line interface. I have one issue though, and I cannot seem to find the docs on this, or perhaps I am overlooking them. It has to deal with the users. The install is located on my machine, but I am going to use dbi and connect remotely. It appears that I can login to the mysql (command line) with about any name and password eg. mysql -u spurcell -ppperl5 and it takes it, and I can do command line things, but when I connect with dbi, it does not like spurcell pperl5 for a username and password. It says permission denied. I would like to know how to add users and grant them access to different DB's. And also, find out who is in the system, what is the root password, etc. Just get a solid understanding of what I have currently in front of me. Thank you for your time, Scott Purcell - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Multiple values for a column
Hi all, I'm fairly new to MySQL and to SQL in general, but not a complete newbie. I have the o'reilly book, as well as dubois and the SAMS PHP MySQL books . . . I think I know the answer to the question but I want to make sure I'm not missing anything I'm building a database that will list application vulnerabilities tied to ports and OS's and I'm ending up with a many-to-many relationship with the applications - OS's section for example: application X - NT3, NT4 SP1, NT4 SP2 building a cross product style table of all OS combinations is impractical, therefore I think that I just need to create some multiple (say 10) of the OS fields, and enter them that way +-+ | app | os1 | os2 | os3| +-+ | app x | 1 | 3 | 4 | +-+ where the numbers in the OS column are the primary key from the OS table granted, this isn't elegant, but I think it should work, am I missing anything? Thanks, Chip - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Install MySQL GUI
Syed Zuhdi writes: Sir, I'm using Linux Mandrake 8.0. This is the first time I'm using Linux OS. My question is: how to install MySQL GUI to Linux. Please help me. Thank you very much. My email : [EMAIL PROTECTED] Just download 1.7.5-2 static binary for Linux and follow instructions in README. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Simple SQL Query?
How can I get a list of all PersonID's who are not in ProjectID 2 (i.e. PersonID 3 and 4)? Table: PersonProject PersonID| ProjectID --- 1 | 1 2 | 1 3 | 1 1 | 2 2 | 2 1 | 3 2 | 3 3 | 3 4 | 3 BTW SELECT PersonID from PersonProject where ProjectID != '2' doesn't work - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Simple SQL Query?
select distinct PersonID from PersonProject where ProjectID != '2'; Is this what you are looking for? Simon -Original Message- From: Glenn Wearen [mailto:[EMAIL PROTECTED]] Sent: 17 July 2001 14:18 To: '[EMAIL PROTECTED]' Subject: Simple SQL Query? How can I get a list of all PersonID's who are not in ProjectID 2 (i.e. PersonID 3 and 4)? Table: PersonProject PersonID| ProjectID --- 1 | 1 2 | 1 3 | 1 1 | 2 2 | 2 1 | 3 2 | 3 3 | 3 4 | 3 BTW SELECT PersonID from PersonProject where ProjectID != '2' doesn't work - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Database Replication
Hello, We are looking to replicate a couple of databases on to a second server. Having looked through the manual it says we need to add various commands to my.cnf. It turns out that we do not have a my.cnf (so apprently MySQL just defaults), so can we just create this file with the replication commands in it ? My apologies if this seems a simple question, but i don't usually deal with this side of things ! Many thanks in advance. Ben. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Missing tables in User dB??
Greets- Newbie to the MySql gig, and I hope I don't come off sounding like an idiot. I checked the manual, archives etc. and did not find anything about this: My user dB seems to have nothing in it - no tables no columns no nothing. I'm logged in as root and have full grants to all dB's. I know if I did not have permissions it would not show me any tables - but this is not the case. The heart of the problem is this: I'm running Mnogo search and am able to index beautifully. However - nothing is being written to the dB. I'm wondering if this has anything to do with the fact that there are no users/permissions in my user dB. I spent hours making sure Mnogo was configured correctly and have since ruled it out as being part of the problem. I would recreate the user dB - but I'm not sure exactly where the file is to re-create it. (yes I'm new to Linux too.) Thanks in advance for any help. Frank T. Gragnano IT/Web Specialist EDO Corporation - Combat Systems Division (757)424-1004 [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: Multiple values for a column
Hi again, I've been given a better solution (wow you guys are speedy!), which is to use an application_os junction table, which is the thing I was missing . . . I was thinking of the junction table wrong, Thanks! If anyone has any other suggestions, they will be appreciated, it's just that once I saw the obvious answer, I wanted to stem the flow of those. Thanks, Chip At 09:01 AM 7/17/01 -0400, you wrote: Hi all, I'm fairly new to MySQL and to SQL in general, but not a complete newbie. I have the o'reilly book, as well as dubois and the SAMS PHP MySQL books . . . I think I know the answer to the question but I want to make sure I'm not missing anything I'm building a database that will list application vulnerabilities tied to ports and OS's and I'm ending up with a many-to-many relationship with the applications - OS's section for example: application X - NT3, NT4 SP1, NT4 SP2 building a cross product style table of all OS combinations is impractical, therefore I think that I just need to create some multiple (say 10) of the OS fields, and enter them that way +-+ | app | os1 | os2 | os3| +-+ | app x | 1 | 3 | 4 | +-+ where the numbers in the OS column are the primary key from the OS table granted, this isn't elegant, but I think it should work, am I missing anything? Thanks, Chip - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Sorting strings
Hi, I have some large tables, which contain also IP-Adresses as strings. Is there any workaround (which uses MySQL-functions) to sort strings as numbers ? Because, when i sort the records, the order is always 1.1.1.1; 1.1.1.10; 1.1.1.2. (which is correct if i'm sorting strings...) But i need the result : 1.1.1.1; 1.1.1.2; 1.1.1.10... There is no possibility to change the IP-Adresses to 001.002.003.004 or so... :-(( Thanx in advance : Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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:innodb and raw disks
Hi! You should make an unformatted partition whose size is divisible by 1 MB. If fseek does not understand the partition size, we can disable the size check from InnoDB code. Please report if you succeed. If not, I change InnoDB-3.23.40 so that you can disable the file size check. I haver not tested raw disks on Unix. Other problems may also arise. For example, what does Linux do if fsync is called on a raw disk partition? I hope Linux ignores such OS calls. Regards, Heikki http://www.innodb.com Copied message: . fdisk /dev/hdd and set up partition 1.Then try using hdd1. Peter Duffy wrote: Hi, In the InnoDB section of the MySQL manual, it mentions that InnoDB can be used with raw disks, rather than data files. I've been trying to get this to work under Linux (RedHat 6.2), but so far without success. I installed a new slave disk on the second IDE bus, brought up the system and verified that the disk was available and partitionable at /dev/hdd. Then, in /etc/my.cnf, I pointed innodb_data_home_dir and innodb_data_file_path at /dev/hdd, with a size calculated from the autodetected values as reported in /var/log/messages. I then started mysql: it reported that the given size was not the same as the actual file size for /dev/hdd, and ended. I delved into the code and ran a few experiments: the problem appears to be that the code uses the lseek system call to determine the file size, and this reports 0 for the /dev/hdd device special file. I tried using a raw device grafted onto the /dev/hdd device, but same result. Has anyone else tried this under Linux and, if so, have they got it to work? (If not, do we have a route towards getting it to work?) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php-- Gerald L. [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
innodb on nt4
Ok, tried to update existing table(s) to InnoDB [from MYISAM] using alter table da_table type=InnoDB;, but show variables still shows table_type as MYISAM. I have the newest mysql ddb from mysql.com, but it installs with MYISAM only, not InnoDB options. I cannot find any documentation on instaling mysql on NT with InnoDB compiled in. Is there such a thing? Where? Bottom line, how do I get InnoDB compiled in with a standard mysql database installation. All I want out of this is transaction support. Best Rgards! Pete ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Parser woes
user() is a function. [EMAIL PROTECTED] wrote: Description: I try to run mysql in conjunction with Apple WebObjects5 (the EnterpriseObjects Framework). This framework generates certain SQL Statements which fail (see How-To-Repeat). How-To-Repeat: Ok first the positive test: create table test ( name varchar(255), test_id varchar(255)); insert into test(name, test_id) values ('1','2'); The above works without flaws.. The negative test: mysql create table user ( address int not null, email varchar(255) not null, first_name varchar(255) not null, last_name varchar(255) not null, login varchar(255) not null, pwd varchar(255) not null, state int not null, user_id int not null primary key); insert into user(address, email, first_name, last_name, login, pwd, state, user_id) values (1,'a','a','a','a','a',1,1); The above statement returns: ERROR 1064: You have an error in your SQL syntax near 'user(address, email, first_name, last_name, login, pwd, state, user_id) values (' at line 1 When I insert a whitespace between the tablename and the ( everything works fine. In the positive test it works without whitespace... Fix: Submitter-Id:submitter ID Originator: Organization: MySQL support: none Synopsis:SQL Parser woes Severity:non-critical Priority:medium Category:mysql Class: sw-bug Release: mysql-3.23.39 (Source distribution) Server: /usr/local/bin/mysqladmin Ver 8.21 Distrib 3.23.39, for apple-darwin1.3.3 on powerpc Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version3.23.39 Protocol version 10 ConnectionLocalhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 1 day 3 hours 12 min 32 sec Threads: 1 Questions: 95 Slow queries: 0 Opens: 26 Flush tables: 1 Open tables: 4 Queries per second avg: 0.001 Environment: System: Darwin localhost 1.3.7 Darwin Kernel Version 1.3.7: Sat Jun 9 11:12:48 PDT 2001; root:xnu/xnu-124.13.obj~1/RELEASE_PPC Power Macintosh powerpc Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/libexec/gcc/darwin/ppc/2.95.2/specs Apple Computer, Inc. version gcc-926, based on gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxr-xr-x 1 root wheel 15 Jul 14 00:11 /usr/lib/libc.dylib - libSystem.dylib Configure command: ./configure --mandir=/usr/local/share/man/ --with-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 -- Gerald L. Clark [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
[ANNOUNCE] BLUE WORLD LASSO 5 PRODUCT LINE TO PROVIDE TIGHTINTEGRATION WITH LEADING OPERATING SYSTEM, DATABASE, WEB SERVER and WEBAUTHORING PRODUCTS
Greetings MySQL Aficionados, The announcement below may interest some of you exploring new options for connecting MySQL to the Web. Also, we're looking for more MySQL experts to participate in our pre-release software testing of Lasso Professional 5 with its embedded MySQL database. If any of you have time to participate and are interested, please drop me a line. Thanks! CC - FOR IMMEDIATE RELEASE July 17, 2001 BLUE WORLD LASSO 5 PRODUCT LINE TO PROVIDE TIGHT INTEGRATION WITH LEADING OPERATING SYSTEM, DATABASE, WEB SERVER and WEB AUTHORING PRODUCTS Bellevue, WA--July 17, 2001--Blue World Communications, Inc.--pioneers of the Web Data Engine(tm)--today announced industry support for its recently announced Lasso 5 product line. Lasso 5 products will be tightly integrated with a number of leading operating system, database, Web server and Web authoring products. In the Internet software business it is critically important to interoperate well with many best-of-breed products, said Bill Doerrfeld, CEO of Blue World. The Lasso 5 product line will provide the hub which interconnects many leading database, Web server and Web authoring products with unique ease, power and control. Operating System Support Lasso Professional 5 will support Mac OS X, Mac OS X Server, Windows 2000 and Red Hat Linux. Lasso Studio 5 will support operating systems supported by Adobe GoLive and Macromedia Dreamweaver including Mac OS 9 and Windows 2000. Mac OS X and Mac OS X Server are unsurpassed in power, stability and ease-of-use, said Ron Okamoto, Apple's vice president of Worldwide Developer Relations. Blue World and Lasso products have distinguished themselves in the Mac community and we are delighted to see their support for the Mac platform with Lasso Professional 5. Database Support Lasso 5 products provide built-in support for MySQL and FileMaker Pro databases. In addition, several third parties plan to release free Lasso data source connectors which provide direct, high-performance connectivity between Lasso Professional 5 and their databases. FileMaker, Inc. is pleased to see Blue World provide advanced support for FileMaker Pro in Lasso Professional 5, said Chris Trytten, director of product management at FileMaker, Inc. Lasso products are a perfect complement to FileMaker products and together offer a great solution for quickly building data-driven Web sites. We're delighted to partner with Blue World to bring our widely used MySQL database to Lasso customers, said Erik Granstrom, VP of Marketing at MySQL AB. With MySQL at the heart of a well-regarded, easy-to-use Web application server such as Lasso, Web developers have a superb total solution for quickly and easily delivering data-driven Web sites. 4D, Inc. is committed to delivering a Lasso connector for 4D Server offering the performance and durability customers have come to expect from 4D, Inc. and Blue World, said Brendan Coveney, CEO of 4D, Inc. We're excited with the possibilities offered in Blue World's Lasso 5 product line and encourage Web developers to discover how the Lasso 5 and 4D combination can ease the process of building robust database-driven Web solutions. FrontBase is pleased to announce a forthcoming Lasso Connector for FrontBase providing tight integration between Lasso Professional 5 and FrontBase, our industrial-strength SQL database server, said Geert B. Clemmensen, CEO of FrontBase, Inc. The new extensibility features in Lasso Professional 5 make it possible for us to build and maintain robust connectivity between Lasso and FrontBase. We're delighted to announce support for Lasso Professional 5 via our forthcoming Lasso Connector for PrimeBase, said Ulrich Zimmer, CEO of PrimeBase. Web developers will be able to easily connect Lasso to PrimeBase Server, our high-performance cross platform SQL database server. Web Server Support Lasso Professional 5 will provide built-in support for Apache on Mac OS X and Red Hat Linux, IIS on Windows 2000, and WebSTAR V on Mac OS X. Vendors may use Lasso Connector Protocol to connect any other Web server to Lasso Professional 5. Lasso has long been the leading Web Data Engine for WebSTAR Server Suite, said Brendan Coveney, CEO of 4D, Inc. We're very pleased to see Blue World support WebSTAR V in its forthcoming Lasso Professional 5 providing WebSTAR users a powerful yet easy-to-use solution for serving data-driven Web sites. Web Authoring Support Lasso Studio 5 will offer a complete Web application development environment within leading Web site editing programs including support for Adobe GoLive, Macromedia Dreamweaver and Macromedia Dreamweaver UltraDev. Third party offerings--including Lasso 5 Glossary for BBEdit from Kuwago Web Services and LDML 5 Plug-in for BBEdit 6.1 from SuiteSync--will extend Bare Bones Software's BBEdit providing support for LDML 5, the programming language used in the
Re: Sorting strings
Check the misc. functions section in the users manual 7.4.12 or thereabouts. Specifically INET_NTOA() and INET_ATON(). [EMAIL PROTECTED] wrote: Hi, I have some large tables, which contain also IP-Adresses as strings. Is there any workaround (which uses MySQL-functions) to sort strings as numbers ? Because, when i sort the records, the order is always 1.1.1.1; 1.1.1.10; 1.1.1.2. (which is correct if i'm sorting strings...) But i need the result : 1.1.1.1; 1.1.1.2; 1.1.1.10... There is no possibility to change the IP-Adresses to 001.002.003.004 or so... :-(( Thanx in advance : Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [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
help with crosstable SEARCH
Hi, I have two tables: whenever I tried doing this select, mysql would hang indefinitely trying to resolve it or at least took t long I would rather shutdown the whole machine. SELECT m.username, m.class, u.password FROM masterlist m, user u WHERE m.class '' LIMIT 20; However, when I include u.username = m.username in the WHERE field, it immediately produces the result in 0.0x seconds. Why does it hang on the 1st case? was it because there were cases wherein a row in masterlist is not present in user list that's causing it to croak? Jaime mysql describe masterlist; +--+--+ | Field| Type | +--+--+ | username | char(8) | | class| char(8) | +--+--+ mysql describe user; ++--+ | Field | Type | ++--+ | username | varchar(20) | | password | varchar(20) | ++--+ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: transactions
Thanks Monty! will this work on NT as well? or do I need to move to Linux. I don't much care if the tables are BDB or InnoDB, just that I have transaction support. Good luch with the Nusphere thing! Pete Michael Widenius wrote: hi! Pete == Pete Kuczynski [EMAIL PROTECTED] writes: Pete Hi, Pete I updated my tables to BDB, but it still shows MYISAM. Pete Do I need to remove mysql and reinstall it compiled for BDB like the Pete manual suggests? I'm using nusphere's mysql on NT4 server, so I'm not Pete shure that's even possible. Pete http://www.mysql.com/doc/B/D/BDB_install.html Pete Pete I don't think NuSphere MySQL version supports BDB tables. If you want to try these out, you should download MySQL-Max from http://www.mysql.com/downloads/mysql-max-3.23.html With NuSphere's distribution, you should be able to use GEMINI tables instead of BDB tables. Have you tried this? Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Simple SQL Query?
select distinct PersonID from PersonProject where ProjectID != '2'; Is this what you are looking for? No, what I'm looking for is... SELECT PersonID FROM PersonProject AND PersonID NOT IN (SELECT PersonID FROM PersonProjectID WHERE ProjectID='2') But this can't be done in MySQL, so does anybody know a work-around? Original question follows... How can I get a list of all PersonID's who are not in ProjectID 2 (i.e. PersonID 3 and 4)? Table: PersonProject PersonID | ProjectID --- 1 | 1 2 | 1 3 | 1 1 | 2 2 | 2 1 | 3 2 | 3 3 | 3 4 | 3 BTW SELECT PersonID from PersonProject where ProjectID != '2' doesn't work - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: transactions
Pete Kuczynski writes: Thanks Monty! will this work on NT as well? or do I need to move to Linux. I don't much care if the tables are BDB or InnoDB, just that I have transaction support. Good luch with the Nusphere thing! Pete -- ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 Download MySQL-Max binary for NT ... That will do ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: innodb on nt4
Hi, For windows systems, you can install mysql-max-3.23.39, that has support for both BDB and InnoDB. For InnoDB you need to change my.cnf and include these lines: # For Innodb Databases # change D:\WebApp\mysql\innodb and the other parameters to fit your # needs innodb_data_home_dir = D:\Webapp\mysql\innodb\ibdata innodb_data_file_path = ibdata1:20M;ibdata2:20M set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = D:\webapp\mysql\innodb\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = D:\webapp\mysql\innodb\iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 Then you use mysql\bin\mysqld-max-nt --install to install it as a service. You can run SHOW VARIABLES to see the which table types are available. That's it. If you need more help, just email-me. I'd be glad to help you out. []'s Crercio O. Silva -Original Message- From: Pete Kuczynski [mailto:[EMAIL PROTECTED]] Sent: terça-feira, 17 de julho de 2001 11:20 To: [EMAIL PROTECTED] Subject: innodb on nt4 Ok, tried to update existing table(s) to InnoDB [from MYISAM] using alter table da_table type=InnoDB;, but show variables still shows table_type as MYISAM. I have the newest mysql ddb from mysql.com, but it installs with MYISAM only, not InnoDB options. I cannot find any documentation on instaling mysql on NT with InnoDB compiled in. Is there such a thing? Where? Bottom line, how do I get InnoDB compiled in with a standard mysql database installation. All I want out of this is transaction support. Best Rgards! Pete ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ERROR 1060: Duplicate column name
TYPE=PACKED does not seem to be documented in Chapter 7.7 in the online documentation. Where can I find a description of the PACKED option? Also, can it be noted in the documentation that CREATE ... SELECT * FROM ... does not create an exact copy of the table? Had I not been paying attention I would not have noticed all the 320MB temporary tables I'd have been creating. -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 17, 2001 6:40 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: ERROR 1060: Duplicate column name Lance Lovette writes: Thanks for the clarification. Is it a MySQL bug then that the CREATE query converts all the VARCHAR fields into CHAR fields so the query 'CREATE TEMPORARY TABLE User2 SELECT * FROM User' creates a temporary table much larger than the User table? No, this is not a bug, this is a feature ... ;o) If you wish that VARCHAR are created instead of CHAR, then you should add TYPE=PACKED in CREATE statement. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Simple SQL Query?
Read all about Join in the manual -- it includes hints like this query: SELECT DISTINCT(PersonID) FROM PersonProject AS P1 LEFT JOIN PersonProject AS P2 ON P2.PersonID=P1.PersonID AND P2.ProjectID=2 WHERE P2.PersonID IS NULL; Cheers, Kent - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Return query from php- seperate into several pages
You need to specify an initial record and limit number. Try this: ? $initial_record = 0; $records_to_display = 10; $query = SELECT something FROM some_table WHERE a=b ; $query .= limit 0, 10; // carry out query here and add code to display results... ? This will give you the first 10 results, starting at record 0 and moving up. From this page you can add something like this: ? $initial_next = ($initial_record + $records_to_display); a href=\yourlink.php?initial_record=$initial_next\clickable text/a //yadda, yadda, yadda... ? That link will transfer in the next initial record as number 10, so you will get 10 through 20. That's quick, but that's the idea. -- Jason On 7/17/01 4:33 AM, Erymuzuan Mustapa was heard saying: Hi all, php beginner say, I have query from a php page that returns several rows, but I don't want to display them all in a single page, but separate them in several pages and then be able to navigate by means of next and previous. Codes snippet would be very helpful. Kind of of page limit property. Thanks in advance Erymuzuan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
seg fault --- HELP!
I am hoping the someone may be able to help me. I re-compiled mysql with debug on. The server starts ok .. reports that mysqld is ready for connections. However I cannot use ANY of the client tools .. mysql , mysqladmin etc ... as soon as I try to run any of them it dumps with a seg fault ... spent 1 day on this. OS = solaris 2.5.1. I checked the archives and read the manual but I cannot find a solution. I am attaching a trace of mysqld.trace ... Regards Imran. # tail -200 mysqld.trace T@1: | info: charsets dir='/export/mysql/share/mysql/charsets/' T@1: get_charsets_dir T@1: my_stat T@1: | my: path: '/export/mysql/share/mysql/charsets/latin5.conf', stat_area: e7b8, MyFlags: 0 T@1: my_stat T@1: my_malloc T@1: | my: Size: 14 MyFlags: 16 T@1: | exit: ptr: 199100 T@1: my_malloc T@1: my_free T@1: | my: ptr: 19b8b0 T@1: my_free T@1: unireg_init T@1: | calc_daynr T@1: | | exit: year: 2001 month: 7 day: 17 - daynr: 731048 T@1: | calc_daynr T@1: unireg_init T@1: init_errmessage T@1: | read_texts T@1: | | fn_format T@1: | | | enter: name: errmsg.sys dsk: /export/mysql/share/mysql/english/ form: flag: 4 T@1: | | | dirname_part T@1: | | | | enter: 'errmsg.sys' T@1: | | | dirname_part T@1: | | | unpack_dirname T@1: | | | | dirname_part T@1: | | | | | enter: '/export/mysql/share/mysql/english/' T@1: | | | | dirname_part T@1: | | | | cleanup_dirname T@1: | | | | | enter: from: '/export/mysql/share/mysql/english/' T@1: | | | | | exit: to: '/export/mysql/share/mysql/english/' T@1: | | | | cleanup_dirname T@1: | | | unpack_dirname T@1: | | | strlength T@1: | | | strlength T@1: | | fn_format T@1: | | my_open T@1: | | | my: Name: '/export/mysql/share/mysql/english/errmsg.sys' Flags: 0 MyFlags: 0 T@1: | | my_open T@1: | | my_malloc T@1: | | | my: Size: 45 MyFlags: 0 T@1: | | | exit: ptr: 19bcd0 T@1: | | my_malloc T@1: | | exit: fd: 4 T@1: | | my_read T@1: | | | my: Fd: 4 Buffer: e7a8 Count: 32 MyFlags: 4 T@1: | | my_read T@1: | | my_free T@1: | | | my: ptr: 0 T@1: | | my_free T@1: | | my_malloc T@1: | | | my: Size: 10945 MyFlags: 0 T@1: | | | exit: ptr: 19eed8 T@1: | | my_malloc T@1: | | my_read T@1: | | | my: Fd: 4 Buffer: 19f218 Count: 416 MyFlags: 4 T@1: | | my_read T@1: | | my_read T@1: | | | my: Fd: 4 Buffer: 19f218 Count: 10113 MyFlags: 4 T@1: | | my_read T@1: | | my_close T@1: | | | my: fd: 4 MyFlags: 0 T@1: | | | my_free T@1: | | | | my: ptr: 19bcd0 T@1: | | | my_free T@1: | | my_close T@1: | read_texts T@1: init_errmessage T@1: lex_init T@1: lex_init T@1: hash_init T@1: | enter: hash: 18e890 size: 16 T@1: | init_dynamic_array T@1: | | my_malloc T@1: | | | my: Size: 128 MyFlags: 16 T@1: | | | exit: ptr: 19b8b0 T@1: | | my_malloc T@1: | init_dynamic_array T@1: hash_init T@1: my_setwd T@1: | my: dir: '/export/mysql/var/' MyFlags 16 T@1: my_setwd T@1: server_init T@1: | general: IP Socket is 3306 T@1: | general: UNIX Socket is /tmp/mysql.sock T@1: | info: server started T@1: server_init T@1: hash_init T@1: | enter: hash: 18fffc size: 80 T@1: | init_dynamic_array T@1: | | my_malloc T@1: | | | my: Size: 640 MyFlags: 16 T@1: | | | exit: ptr: 19c8c8 T@1: | | my_malloc T@1: | init_dynamic_array T@1: hash_init T@1: mysql_rm_tmp_tables T@1: | my_dir T@1: | | my: path: '/tmp/' stat: 528 MyFlags: -268438480 T@1: | | my_malloc T@1: | | | my: Size: 32704 MyFlags: 528 T@1: | | | exit: ptr: 1a19e0 T@1: | | my_malloc T@1: | my_dir T@1: | my_dirend T@1: | | my_free T@1: | | | my: ptr: 1a19e0 T@1: | | my_free T@1: | my_dirend T@1: mysql_rm_tmp_tables T@1: hash_free T@1: hash_free T@1: hash_init T@1: | enter: hash: 1a1a40 size: 128 T@1: | init_dynamic_array T@1: | | my_malloc T@1: | | | my: Size: 1024 MyFlags: 16 T@1: | | | exit: ptr: 19cb50 T@1: | | my_malloc T@1: | init_dynamic_array T@1: hash_init T@1: fn_format T@1: | enter: name: master.info dsk: . form: flag: 52 T@1: | dirname_part T@1: | | enter: 'master.info' T@1: | dirname_part T@1: | unpack_dirname T@1: | | dirname_part T@1: | | | enter: './' T@1: | | dirname_part T@1: | | cleanup_dirname T@1: | | | enter: from: './' T@1: | | | exit: to: './' T@1: | | cleanup_dirname T@1: | unpack_dirname T@1: | strlength T@1: | strlength T@1: fn_format T@1: my_stat T@1: | my: path: './master.info', stat_area: eac8, MyFlags: 0 T@1: my_stat T@1: init_key_cache T@1: | my_malloc T@1: | | my: Size: 16016384 MyFlags: 0
missing /usr/lib/libsocket.so.2
'm install mysql on SCO 5.05 with apache. When I follow the binary install inst. I get the following messages. 161# ./bin/safe_mysqld dynamic linker : ./bin/my_print_defaults : error opening /usr/lib/libsocket.so.2 ./bin/safe_mysqld: 24215 Killed Starting mysqld daemon with databases from /usr/local/mysql-3.23.39-pc-sco3.2v5.0.6-i386/data ./bin/safe_mysqld: 24224 Killed 010717 12:07:10 mysqld ended -- Ken - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: selecting the newest/oldest record...
Hello. On Mon, Jul 16, 2001 at 05:51:34PM -0700, [EMAIL PROTECTED] wrote: Question: given data in a table such as id, value, date 0, value1, 1999-01-25 1, value2, 1999-01-02 2, value2, 1999-01-04 3, value1, 1999-01-22 4, value2, 2000-01-01 how can i select the latest 'id' for a given same set of 'value' based on 'date'? ie: i would like to be able to get records id's 0 and 4 from above, since id 0 has the latest date for value1 (1999-01-25) and id 4 has the least date for value2 (2000-01-01). Assuming, that 'date' is really some kind of DATE type and not CHAR, you may want to try the following: SELECT * FROM your_table WHEREvalue='value1' ORDER BY date LIMIT1 which will return the records with 'value1' in ascending order and restrict the result to the first one, i.e. the one with the latest date. SELECT * FROM your_table WHEREvalue='value2' ORDER BY date DESC LIMIT1 will do the same for 'value2' and the least date. i was thinking of using a least function on it, but my problem is I don't know how exactly it can be done without some (outside) processing. Am I missing something? Regards, Benjamin. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Contact
Mr Alain KABUIKA wrote: I have made a script in PHP which creates a table in my MySQL database on Linux environment. When I run the script and give the name of table to create, there isn't problem if I'm using ASCII; but if I use a Japanese Charater encoded (JIS), I'm getting error message on those encoded characters, they are converted in ASCII codes with special charters + numbers, and mysql cannot takes it for a name of table!. I need help on this matter. Most places in MySQL accept anything if you provide them between ` marks. And watch out they are not ' but ` -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: help with crosstable SEARCH
Well, you have to tell MySQL somehow how to connect those two tables. You may want to check the syntax for JOINS to understand what's going on. I have two tables: whenever I tried doing this select, mysql would hang indefinitely trying to resolve it or at least took t long I would rather shutdown the whole machine. SELECT m.username, m.class, u.password FROM masterlist m, user u WHERE m.class '' LIMIT 20; However, when I include u.username = m.username in the WHERE field, it immediately produces the result in 0.0x seconds. Why does it hang on the 1st case? was it because there were cases wherein a row in masterlist is not present in user list that's causing it to croak? -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Simple SQL Query?
That is exactly what I want, Thanks Rafal PS: does anybody know if there are plans to support nested queries in mySQL? Hi, maybe something like this: select a.PersonId from PersonProject a left join PersonProject b on(a.PersonID=b.PersonID and b.ProjectID=2) where b.PersonID is null group by a.PersonID; -- _/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625 _/ _/ _/ ==* http://szukaj.wp.pl *==-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how do I do this?
Jeff S Wheeler wrote: [This is an email copy of a Usenet post to mailing.database.mysql] Just insert a row with the initial value you want minus one, and then delete it. That will make the table do what you want. mysql INSERT INTO Orders VALUES (-1, , NOW(), -1, 125478); Query OK, 1 row affected (0.03 sec) mysql DELETE FROM Orders WHERE OrderNumber=125478; Query OK, 1 row affected (0.02 sec) mysql INSERT INTO Orders VALUES (-1, , NOW(), -1, 0); Query OK, 1 row affected (0.02 sec) mysql SELECT LAST_INSERT_ID(); +--+ | last_insert_id() | +--+ | 125479 | +--+ 1 row in set (0.02 sec) You did not supplied us any information about your table structure. If this is an column named OrderNumber where you insert -1 then everything seems OK to me. Please descibe where you can see problem and what is your table structure. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: table types
Pete Kuczynski wrote: Hi, I understand mysql supported InnoDB and BDB table types for the purposes of transaction logging, which I need to use. Which is recommended by you folks for NT4 boxes. Test both if you need to know :) I believe that InnoDB is better now but this depends of context of usage. Test it! -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: missing /usr/lib/libsocket.so.2
On Tue, 17 Jul 2001, ken wrote: When I follow the binary install inst. I get the following messages. 161# ./bin/safe_mysqld dynamic linker : ./bin/my_print_defaults : error opening /usr/lib/libsocket.so.2 ./bin/safe_mysqld: 24215 Killed Starting mysqld daemon with databases from /usr/local/mysql-3.23.39-pc-sco3.2v5.0.6-i386/data ./bin/safe_mysqld: 24224 Killed 010717 12:07:10 mysqld ended OSR 5.0.6 has some new libraries that OSR 5.0.5 does not have. I have found that on a OSR 5.0.5 system in /usr/lib you can make a link ln -s libsocket.so.1 libsocket.so.2 then the binary works. I hope that Caldera/SCO will release a patch for OSR 5.0.5 with this file. They have not yet. So a temporay fix is the above. Good Luck, -- Boyd Gerber [EMAIL PROTECTED] ZENEZ 3748 Valley Forge Road, Magna Utah 84044 Office 801-250-0795 FAX 801-250-7975 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: stupid install question
Date |Tue, 17 Jul 2001 13:45:06 +0100 From |Martin [EMAIL PROTECTED] Hello! M Dear support, M I would like to use your GUI with my already installed and running M mysql-3.23.39 on my Linux 7.1 ppc susie installation. M As a real beginner to using Linux I quickly get stuck! I have downloaded the M mysqlgui-1.7.5-1-linux-static tar file, and uncompressed it. M The read-me states that to use this I need to move the binary mysqlgui into M a PATH directory. I have tried copying the file into my bin directory and M selecting it to run but nothing seems to happen. You need to recompile MySQLGUI because linux-static binaries compiled for linux-x86. Just get sources from http://www.mysql.com/downloads/gui-clients.html You need also fltk library for compiling. ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
can't connect from web page, but works fine from command line
I have a web page form that writes to a database and it has been working just fine for a couple weeks now, and all of a sudden it's not working today. The fail to connect message doesn't even come up. ? if(isset($submit)): if (!$db = mysql_connect(localhost,root)): print(h1Can't connect to database/h1\n); else: mysql_select_db(todaysnews, $db); endif; $date = date(Y-m-d); $sql = insert into bulletin values(null,'$heading','$body','$date','$author_name','$author_email','$bulletin_number','$bulletin_subject', '$bulletin_from1','$bulletin_date','$bulletin_from2'); mysql_query($sql); print(h2The Data has been entered!/h2\n); print(strongYou can add another Dealer Bulletin below/strongbr /hr\n); endif; ? I have purposely changed the name todaysnews to be incorrect and the page, on submit, will just continue to the next web page as if all is well and good. I can add data from the mysql command line, and also from within webmin, just not from the web page. Is it a permissions problem, or access rights problem, or something like that? The only change made recently was to the web server, apache, it now listens on port 8080 rather than port 80. This should have no effect on mysql though, right? Chip Wiegand Computer Services www.simradusa.com [EMAIL PROTECTED] Simrad, Inc Lynnwood, WA 425-712-1138 There is no reason anyone would want a computer in their home. --Ken Olson, president, chairman and founder of Digital Equipment Corp., 1977 (-- Then why do I have nine? Somebody help me!) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 on OpenBSD 2.8
Brian, Sorry for the late post, I would also recommend an upgrade to 3.23.39 this did help me on FreeBSD with a similar problem (that did not happen very often). Also if you are compiling from source make sure you use flags similar to this to configure: CC=gcc CFLAGS=-O3 CXX=gcc \ CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \ ./configure $DEBUG --enable-large-files --with-berkeley-db --with-innodb bash-2.04$ - Original Message - From: Brian E. Beck [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, July 15, 2001 12:44 AM Subject: MySQL on OpenBSD 2.8 I guess I've lurked long enough. I am a relative newbie to MySQL (and to all things SQL, actually.) I am running MySQL 3.23.37 on my OpenBSD 2.8 server. (I currently support 6 different, non-related databases on the server) Here is the problem... MySQL seems to open too many threads and die... (i.e., if I run top mysqld sems to take up over 90% of the CPU cycles, for hours, if I let it.) Once it does this, I can't shut it down with mysqladmin. It will not respond to anything... No queries, no mysqladmin functions. Nothing. I had a friend of mine write a monitor script, which simply checks every 45 seconds to see the CPU usage of mysqld, and if it is over 90% for longer than 2 minutes, it kill -9's it, and restarts it. (A VERY sloppy solution) We did not have this problem when we were running MySQL 3.23.36 on RedHat 7.0. ( I didn't modify the codes I use either) We have recompiled, to update the threads, etc. Can someone help me figure this out, and if so what logs do I need to send to the list to help determine the problem? (Or should I upgrade to 3.23.39?) I appreciate all that you advise, as I have been reading this list for a while now, and have gained many pearls of wisdom from it. --Brian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Simple problem compiling example program Simple1.cc under Linux
I am quite new to programming in Linux although I am no stranger to programming in Windows. This is my problem: I downloaded the mysql++ API and extracted it to /root/mysql++-1.7.9/ I browsed to /examples/ and thought I would try and compile simple1.cc. This is what I did from the terminal: terminal # g++ simple1.cc -I/usr/local/mysql/include/ -I/root/mysql++-1.7.9/sqlplusint/ /usr/local/mysql/ is where my MySQL 3.23.38 is installed /root/mysql++-1.7.9/ is the extracted API files I downloaded from mysql.com All I get is gumph pc-xx-34-111-118-du:~/mysql++-1.7.9/examples # g++ simple1.cc -I/usr/local/mysql/include/ -I/root/mysql++-1.7.9/sqlplusint/ /tmp/ccrKLeaN.o: In function `main': /tmp/ccrKLeaN.o(.text+0x30): undefined reference to `MysqlConnection::MysqlConnection(char const *, char const *, char const *, char const *, bool)' /tmp/ccrKLeaN.o(.text+0x55b): undefined reference to `operator(ostream , mysql_ColDataconst_string const )' /tmp/ccrKLeaN.o(.text+0x6a2): undefined reference to `MysqlConnection::~MysqlConnection(void)' /tmp/ccrKLeaN.o(.text+0x80d): undefined reference to `MysqlConnection::~MysqlConnection(void)' /tmp/ccrKLeaN.o(.rodata+0x1ac): undefined reference to `mysql_date type_info node' /tmp/ccrKLeaN.o(.rodata+0x1e4): undefined reference to `mysql_time type_info node' /tmp/ccrKLeaN.o: In function `MysqlDate type_info function': /tmp/ccrKLeaN.o(.gnu.linkonce.t.__tf9MysqlDate+0x18): undefined reference to `mysql_date type_info function' /tmp/ccrKLeaN.o: In function `MysqlTime type_info function': /tmp/ccrKLeaN.o(.gnu.linkonce.t.__tf9MysqlTime+0x18): undefined reference to `mysql_time type_info function' /tmp/ccrKLeaN.o: In function `MysqlRes::~MysqlRes(void)': /tmp/ccrKLeaN.o(.gnu.linkonce.t._._8MysqlRes+0x1b): undefined reference to `MysqlResUse::~MysqlResUse(void)' /tmp/ccrKLeaN.o: In function `MysqlQuery::preview(void)': /tmp/ccrKLeaN.o(.MysqlQuery::gnu.linkonce.t.preview(void)+0x1b): undefined reference to `SQLQuery::str(SQLQueryParms const ) const' /tmp/ccrKLeaN.o: In function `MysqlRes::num_rows(void) const': /tmp/ccrKLeaN.o(.MysqlRes::gnu.linkonce.t.num_rows(void) const+0x14): undefined reference to `mysql_num_rows' /tmp/ccrKLeaN.o: In function `MysqlQuery::store(SQLQueryParms , query_reset)': /tmp/ccrKLeaN.o(.MysqlQuery::gnu.linkonce.t.store(SQLQueryParms , query_reset) +0x40): undefined reference to `SQLQuery::str(SQLQueryParms const , query_reset)' /tmp/ccrKLeaN.o: In function `MysqlFieldNames::MysqlFieldNames(MysqlResUse const *)': /tmp/ccrKLeaN.o(.MysqlFieldNames::gnu.linkonce.t.(MysqlResUse const *)+0x4d): undefined reference to `MysqlFieldNames::init(MysqlResUse const *)' /tmp/ccrKLeaN.o: In function `MysqlResUse::num_fields(void) const': /tmp/ccrKLeaN.o(.MysqlResUse::gnu.linkonce.t.num_fields(void) const+0x12): undefined reference to `mysql_num_fields' /tmp/ccrKLeaN.o: In function `MysqlRes::fetch_row(void) const': /tmp/ccrKLeaN.o(.MysqlRes::gnu.linkonce.t.fetch_row(void) const+0xd8): undefined reference to `mysql_fetch_row' /tmp/ccrKLeaN.o(.MysqlRes::gnu.linkonce.t.fetch_row(void) const+0xec): undefined reference to `mysql_fetch_lengths' /tmp/ccrKLeaN.o: In function `MysqlRes::data_seek(unsigned int) const': /tmp/ccrKLeaN.o(.MysqlRes::gnu.linkonce.t.data_seek(unsigned int) const+0x1c): undefined reference to `mysql_data_seek' /tmp/ccrKLeaN.o: In function `MysqlConnection::store(basic_stringchar, string_char_traitschar, __default_alloc_templatetrue, 0 const )': /tmp/ccrKLeaN.o(.MysqlConnection::gnu.linkonce.t.store(basic_stringchar, string_char_traitschar, __default_alloc_templatetrue, 0 const )+0x1d): undefined reference to `MysqlConnection::store(basic_stringchar, string_char_traitschar, __default_alloc_templatetrue, 0 const , bool)' /tmp/ccrKLeaN.o: In function `FieldTypes::FieldTypes(MysqlResUse const *)': /tmp/ccrKLeaN.o(.FieldTypes::gnu.linkonce.t.(MysqlResUse const *)+0x4d): undefined reference to `FieldTypes::init(MysqlResUse const *)' collect2: ld returned 1 exit status pc-62-31-190-118-du:~/mysql++-1.7.9/examples # g++ simple1.cc -I/usr/local/mysql/include/ -I/root/mysql++-1.7.9/sqlplusint/ /tmp/ccbSuqTq.o: In function `main': /tmp/ccbSuqTq.o(.text+0x30): undefined reference to `MysqlConnection::MysqlConnection(char const *, char const *, char const *, char const *, bool)' /tmp/ccbSuqTq.o(.text+0x55b): undefined reference to `operator(ostream , mysql_ColDataconst_string const )' /tmp/ccbSuqTq.o(.text+0x6a2): undefined reference to `MysqlConnection::~MysqlConnection(void)' /tmp/ccbSuqTq.o(.text+0x80d): undefined reference to `MysqlConnection::~MysqlConnection(void)' /tmp/ccbSuqTq.o(.rodata+0x1ac): undefined reference to `mysql_date type_info node' /tmp/ccbSuqTq.o(.rodata+0x1e4): undefined reference to `mysql_time type_info node' /tmp/ccbSuqTq.o: In function `MysqlDate type_info function': /tmp/ccbSuqTq.o(.gnu.linkonce.t.__tf9MysqlDate+0x18): undefined reference to `mysql_date type_info function' /tmp/ccbSuqTq.o: In function `MysqlTime type_info function':
mysqlbug
Can not start mysql nor run mysqladmin like: [root@MrTamada data]# more MrTamada.err 010717 23:26:58 mysqld started 010717 23:26:58 /usr/local/mysql-3.23.39-unknown-linux-gnu-sparc/bin/mysqld: Ca n't create/write to file '/usr/local/mysql-3.23.39-unknown-linux-gnu-sparc/data/ MrTamada.pid' (Errcode: 13) 010717 23:26:58 /usr/local/mysql-3.23.39-unknown-linux-gnu-sparc/bin/mysqld: Ca n't find file: './mysql/host.frm' (errno: 13) 010717 23:26:58 /usr/local/mysql-3.23.39-unknown-linux-gnu-sparc/bin/mysqld: Er ror on delete of '/usr/local/mysql-3.23.39-unknown-linux-gnu-sparc/data/MrTamada .pid' (Errcode: 13) 010717 23:26:58 mysqld ended [root@MrTamada bin]# ./mysqladmin version ./mysqladmin: error in loading shared libraries: libmysqlclient.so.10: cannot op en shared object file: No such file or directory __ Do You Yahoo!? Get personalized email addresses from 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
Re: innodb and raw disks
Hi! Ok, I will add a special 'raw' keyword to 3.23.40, like: innodb_data_file_path = hdd1:2000Mraw Then it is enough that the raw disk partition is bigger than 2000 x 1024 x 1024 bytes. InnoDB will only use the specified amount of the partition from the low end, and will also skip the size check at startup. Peter, if you compile yourself, you can just try commenting out the size check on about line 367 of mysql/innobase/srv/srv0start.c Your disk partition should just be bigger than the size (1M = 1024 x 1024 bytes) you specify in innodb_file_path. What happens now? Regards, Heikki http://www.innodb.com -Original Message- From: Peter Duffy [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Date: Tuesday, July 17, 2001 8:27 PM Subject: Re: innodb and raw disks Hi Heikki, You mean lseek? As far as I'm aware, fseek doesn't report the file size? (the code that I've been looking at in os0file.c definitely uses lseek.) Using the current disk, I can't make a partition which is *precisely* a multiple of 1M - the cylinder geometry doesn't allow it (correct me if I'm wrong, someone! I'm using fdisk, and if I specify 100M, I get 104391 blocks.) Does it have to be a multiple of 1M to satisfy the size-checking? I wrote a little program to experiment with lseek in isolation: it reports 0 bytes for both /dev/hdd and /dev/hdd1 (whatever size I make the latter.) I also tried mapping /dev/raw/raw1 over /dev/hdd1: the program still gives 0 bytes. (As a control, I tested the program against some regular files: for these, it reports the correct sizes.) Is it likely to make any difference if I put a BSD disklabel on /dev/hdd1? (I'm not even sure I can do that in an x86 environment: fdisk understands disklabels, but doesn't appear to be able to create them.) Rather than disable the file size check, would it be possible to check the file type, and for block devices substitute some other check? (Currently not sure what: maybe look up the device in /proc/partitions?) Regards, Peter Heikki Tuuri wrote: Hi! You should make an unformatted partition whose size is divisible by 1 MB. If fseek does not understand the partition size, we can disable the size check from InnoDB code. Please report if you succeed. If not, I change InnoDB-3.23.40 so that you can disable the file size check. I haver not tested raw disks on Unix. Other problems may also arise. For example, what does Linux do if fsync is called on a raw disk partition? I hope Linux ignores such OS calls. Regards, Heikki http://www.innodb.com Copied message: . fdisk /dev/hdd and set up partition 1.Then try using hdd1. Peter Duffy wrote: Hi, In the InnoDB section of the MySQL manual, it mentions that InnoDB can be used with raw disks, rather than data files. I've been trying to get this to work under Linux (RedHat 6.2), but so far without success. I installed a new slave disk on the second IDE bus, brought up the system and verified that the disk was available and partitionable at /dev/hdd. Then, in /etc/my.cnf, I pointed innodb_data_home_dir and innodb_data_file_path at /dev/hdd, with a size calculated from the autodetected values as reported in /var/log/messages. I then started mysql: it reported that the given size was not the same as the actual file size for /dev/hdd, and ended. I delved into the code and ran a few experiments: the problem appears to be that the code uses the lseek system call to determine the file size, and this reports 0 for the /dev/hdd device special file. I tried using a raw device grafted onto the /dev/hdd device, but same result. Has anyone else tried this under Linux and, if so, have they got it to work? (If not, do we have a route towards getting it to work?) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php-- Gerald L. [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL: my.cnf in Windows 2000
Anybody: I've installed (and got working!) MySQL on my Windows 2000 pc and am trying to use the my.cnf file. 1) The manual says that my.cnf is included in the installation and that I should copy it to c:\my.cnf. (Copy the file `\mysql\my-x.cnf' to `C:\my.cnf' and edit it to suit your setup.) However I searched and searched for the suggested file and could not find it (or anything like it...); 2) I created my own c:\my.cnf based on the my.ini file but it didn't work (i.e. the commands I put in to my.cnf had no effect); 3) I then put the same options into my.ini and everything worked just fine. I'm wondering 1) if using my.ini is O.K.; and 2) am I doing something wrong? Thanks, Phil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
EO - New FREE web development engine
Hello, I'm contacting you because we have recently released a new web development platform, EO, that I would like for you to try out for use in building dynamic sites. EO is a portable, flexible yet robust system that you can use to quickly build interactive sites, plus it has features that protect you, the web developer. The Engine behind EO has been in development since 1996 and has been used to build simple to complex systems in many industries including retail, automotive, financial, marine and more. BEST OF ALL IT'S FREE! Please visit http://www.eodeveloper.com/eo/eo.exe/eofree?01 to find out more and download your FREE copy. Thank you! Team EO http://www.eodeveloper.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: FreeBSD issues
Hi Michael, As another FreeBSD user that has posted many times on FreeBSD topics realted to MySQL it only took me a few minutes to find resolutions, the problem is that some of the thread topics are related and the answers were posted in a different thread from the ones that orginally started a question. I think the search engine could be improved! Freebsd 4.2 does have a number of bugs related to threads and the compiler for threaded programs . (Search 'freebsd compiler threads) first topic on second page) I would recommend an upgrade to 4.3 and an upgrade to a more recent MySQL is also highly recommended (3.23.39 or .40 when it comes outs). Upgrade your ports collection and install from ports or find my previous posts or e-mail me direclty and I will send you some compilation instructions as the manual seems to be outdated in relation to compiling freebsd. Best of luck, hope this helps Ken - Original Message - From: Michael Caplan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 16, 2001 5:54 PM Subject: FreeBSD issues Hello, I am working with MySQL (Ver 9.38 Distrib 3.22.32, for -freebsd4.1.1 (i386)) on FreeBSD 4.2-STABLE running (I believe) on a dual 233 Intel box. We have been having some problems as of recently where system swap becomes flooded and the system is brought to a halt. We believe we have isolated the problem to MySQLd. In searching through the mysql discussion list, I noticed several people raising similar issues on FreeBSD systems. I did not however come across any solutions. Perhaps I missed something. What are the current install recommendations for the above mentioned system, and has the above mentioned problem been resolved? Regards, Michael Caplan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: transactions
Hi! Pete == Pete Kuczynski [EMAIL PROTECTED] writes: Pete Thanks Monty! Pete will this work on NT as well? or do I need to move to Linux. Yes; We have MySQL-Max for both NT and Linux. Pete I don't much care if the tables are BDB or InnoDB, just that I have Pete transaction support. ok. Pete Good luch with the Nusphere thing! Thanks! Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
modifying table with sort/unique
I have a table in which I want to eliminate duplicates, where I define a duplicate to be any two rows with the same values on field1 and field2 This gives me the sort I want SELECT * FROM this_table ORDER BY name, time; But in addition I would like to drop duplicates. Is there a way to modify the table in place to remove the duplicates? If not, how do I create a temporary table with duplicates suppressed, and then rename/copy this table to the original table name? Thanks, John Hunter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error while trying to compile MySQL 4.0
Bonjour Jocelyn, Avez vous installé automake, autoconf, autoheader et aclocal? Also you can try updating I noticed several manual commits today use this to update your source: cd mysql-4.0 bk pull bk -r edit Which build script did you use? j'utile quelque chose comme ceci: bash-2.04$ cat build.sh cd mysql-4.0 YACC='bison -y ' ./BUILD/compile-pentium-debug-max bash-2.04$ J'espère que ca vous aide! Amicalement, Ken - Original Message - From: Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 16, 2001 12:17 PM Subject: Error while trying to compile MySQL 4.0 Hi, Compilation fail with the following error message : makeinfo -I . --no-headers --no-split --output manual.txt manual.texi Fabrication du fichier text «manual.txt» à partir de «manual.texi». manual.texi:56: Commande inconnue «setcontentsaftertitlepage».. manual.texi:5157: itemize exige un argument: le formateur pour @item. manual.texi:20066: «.» ou «,» doit suivre une référence croisée, non pas a. manual.texi:30568: itemize exige un argument: le formateur pour @item. manual.texi:30980: itemize exige un argument: le formateur pour @item. manual.texi:44531: itemize exige un argument: le formateur pour @item. makeinfo: Enlèvement du fichier de sortie «manual.txt» à cause d'erreurs; utiliser l'option --force pour préserver. make[2]: *** [manual.txt] Erreur 2 make[2]: Quitte le répertoire `/usr/local/mysql-4.0/Docs' make[1]: *** [all-recursive] Erreur 1 make[1]: Quitte le répertoire `/usr/local/mysql-4.0' make: *** [all-recursive-am] Erreur 2 What should I do to fix the error ? Thank you, Jocelyn Fournier Presence-PC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
create new user in mySQL
I am moving from MS SQL to mySQL, Can anybody know how to create and grant rights for a new user except of root? 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
mysqldump loses auto_increment
Hello. I've just created a table with a auto_increment column. I then did ALTER TABLE tbl AUTO_INCREMENT=4711; Now, when I insert one row into this table, it get's 4711 as the auto_increment column's value. However, dumping this table with mysqldump --opt DB tbl loses the auto_increment value i set. So, if I'd replay the dump, the first time I insert a row it would get 1 for the auto_increment, and not 4711. How to circumvent this? Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 13 hours 25 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: my.cnf in Windows 2000
Problem under Win2000 with any file having a .cnf extension. That extension is reserved by Win2000 as a system (Speed Dial) file and will automatically hide the extension from you. You can't search for it and it will not show it. IF you create a my.cnf file, it appears as my I use 'WINNT\my.ini' just fine as documented in 4.16.5 of the Manual and it works well. Regards, Fred \\|// (@ @) ---oOO---(_)---OOo || | Fred Dinkler | | SVP Technology | | DFII Atlanta | | Office: 01.770.596.1443| || -- |__|__| || || ooO Ooo -Original Message- From: Philip Daggett [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 17, 2001 2:40 PM To: [EMAIL PROTECTED] Subject: MySQL: my.cnf in Windows 2000 Anybody: I've installed (and got working!) MySQL on my Windows 2000 pc and am trying to use the my.cnf file. 1) The manual says that my.cnf is included in the installation and that I should copy it to c:\my.cnf. (Copy the file `\mysql\my-x.cnf' to `C:\my.cnf' and edit it to suit your setup.) However I searched and searched for the suggested file and could not find it (or anything like it...); 2) I created my own c:\my.cnf based on the my.ini file but it didn't work (i.e. the commands I put in to my.cnf had no effect); 3) I then put the same options into my.ini and everything worked just fine. I'm wondering 1) if using my.ini is O.K.; and 2) am I doing something wrong? Thanks, Phil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: modifying table with sort/unique
So sprach »John Hunter« am 2001-07-17 um 14:42:13 -0500 : I have a table in which I want to eliminate duplicates, where I define a duplicate to be any two rows with the same values on field1 and field2 This gives me the sort I want SELECT * FROM this_table ORDER BY name, time; Untested: SELECT * FROM this_table ORDER BY name, time GROUP BY CONCAT(field1, field2); Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 13 hours 28 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: innodb on nt4
Hi, have a question about the inno_data_home_dir line on mysql-max3.23 do I create a file called ibdata cause it's not in any directory by default by default. innodb_data_home_dir = D:\Webapp\mysql\innodb\ibdata Pete Crercio Osmaildo da Silva wrote: Hi, For windows systems, you can install mysql-max-3.23.39, that has support for both BDB and InnoDB. For InnoDB you need to change my.cnf and include these lines: # For Innodb Databases # change D:\WebApp\mysql\innodb and the other parameters to fit your # needs innodb_data_home_dir = D:\Webapp\mysql\innodb\ibdata innodb_data_file_path = ibdata1:20M;ibdata2:20M set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = D:\webapp\mysql\innodb\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = D:\webapp\mysql\innodb\iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 Then you use mysql\bin\mysqld-max-nt --install to install it as a service. You can run SHOW VARIABLES to see the which table types are available. That's it. If you need more help, just email-me. I'd be glad to help you out. []'s Crercio O. Silva -Original Message- From: Pete Kuczynski [mailto:[EMAIL PROTECTED]] Sent: terça-feira, 17 de julho de 2001 11:20 To: [EMAIL PROTECTED] Subject: innodb on nt4 Ok, tried to update existing table(s) to InnoDB [from MYISAM] using alter table da_table type=InnoDB;, but show variables still shows table_type as MYISAM. I have the newest mysql ddb from mysql.com, but it installs with MYISAM only, not InnoDB options. I cannot find any documentation on instaling mysql on NT with InnoDB compiled in. Is there such a thing? Where? Bottom line, how do I get InnoDB compiled in with a standard mysql database installation. All I want out of this is transaction support. Best Rgards! Pete ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
tricky RAND() function...
I am using MySQL 3.22, and need to know how to randomly select a record, therefore I can't just use the ORDER BY RAND() clause, because of my version. so i do this: SELECT field1,field2*0+RAND() as rand_col FROM TableName WHERE field3=5 ORDER BY rand_col; --according to paul dubois' book I have to do that field2*0+rand to override mysql's query optimizer...? This works great randomly selecting records, but it obviously also returns the rand_col column, which I can't have (I have to output the data (a picture) straight into a web browser). How can I either re-write this statement or hide that rand_col column from showing up? all i want to do is randomly select one column using mysql 3.22, is this that hard? thanks in advance! -derick
Re: create new user in mySQL
On Tuesday 17 July 2001 15:44, Colin TMC wrote: I am moving from MS SQL to mySQL, Can anybody know how to create and grant rights for a new user except of root? Thanks! - I know a lot of you don't believe it, but this really is good advice, and you'll find what you need here... Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Database Replication
On Tue, Jul 17, 2001 at 02:49:15PM +0100, Ben Smith wrote: We are looking to replicate a couple of databases on to a second server. Having looked through the manual it says we need to add various commands to my.cnf. It turns out that we do not have a my.cnf (so apprently MySQL just defaults), so can we just create this file with the replication commands in it ? Yes, you can. Just make sure that they all appear in a [mysqld] section. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 -- NEW MySQL 3.23.29: up 31 days, processed 237,155,060 queries (87/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: Shutting down Mysql
On 17-Jul-01 Chris Aitken wrote: Hi Guys, What im looking at doing is working out the best way to safely shut down mysql so I can do a full backup of the system, then restart it back. (im running on a FreeBSD box) I know I can kill the PID and other drastic measures but I dont want to do anything that might corrupt the data. Which is the best method for stopping mysql and then restarting it ? mysqladmin shutdown ? Yes and whats the best way to start it back up again just running the .sh file(s) from /usr/local/etc/rc.d ? and Yes Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: modifying table with sort/unique
Paul == Paul DuBois [EMAIL PROTECTED] writes: Paul ALTER IGNORE this_table ADD PRIMARY KEY (name,time) They are not null so this works well with a slight modification: ALTER IGNORE TABLE this_table ADD PRIMARY KEY (name,time) ^ One further question. Will this automatically keep my rows ordered by the primary key with future inserts? Thanks for your help, John Hunter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: my.cnf in Windows 2000
Just go (in windows explorer) to view-optoins, and uncheck hide extensions of known file types, and the extensions will show up. You can also un-associate it through this. On Tuesday 17 July 2001 15:47, Dinkler, Fred wrote: Problem under Win2000 with any file having a .cnf extension. That extension is reserved by Win2000 as a system (Speed Dial) file and will automatically hide the extension from you. You can't search for it and it will not show it. IF you create a my.cnf file, it appears as my I use 'WINNT\my.ini' just fine as documented in 4.16.5 of the Manual and it works well. Regards, Fred \\|// (@ @) ---oOO---(_)---OOo | Fred Dinkler | | SVP Technology | | DFII Atlanta | | Office: 01.770.596.1443| -- |__|__| ooO Ooo -Original Message- From: Philip Daggett [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 17, 2001 2:40 PM To: [EMAIL PROTECTED] Subject: MySQL: my.cnf in Windows 2000 Anybody: I've installed (and got working!) MySQL on my Windows 2000 pc and am trying to use the my.cnf file. 1) The manual says that my.cnf is included in the installation and that I should copy it to c:\my.cnf. (Copy the file `\mysql\my-x.cnf' to `C:\my.cnf' and edit it to suit your setup.) However I searched and searched for the suggested file and could not find it (or anything like it...); 2) I created my own c:\my.cnf based on the my.ini file but it didn't work (i.e. the commands I put in to my.cnf had no effect); 3) I then put the same options into my.ini and everything worked just fine. I'm wondering 1) if using my.ini is O.K.; and 2) am I doing something wrong? Thanks, Phil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
mysql dumps core while mysqld runs ok on Solaris
Hi All: I am running 3.23.39 and I compiled it using gcc 2.95.3. I am having a very difficult time getting *ANY* of the client progs to work (mysql, mysqladmin etc) ... they immediately seg faults and core dumps without any message. mysqld is running fine ... with debug on it says waiting to connections (I can telenet to the port etc) I found a similar problem listed in the archive (shown below) but there were no resolution posted. I need to get a resolution soon ... spending my second day on this and it is getting really frustrating. I'm about to ditch this but the application that we are installing requires mysql as its database so I am stuck. Any help would be greatly appreciated. regards Imran --- My environment is shown below: MySQL support: [none | licence | email support | extended email support ] Synopsis: synopsis of the problem (one line) Severity: [ non-critical | serious | critical ] (one line) Priority: [ low | medium | high ] (one line) Category: mysql Class: [ sw-bug | doc-bug | change-request | support ] (one line) Release: mysql-3.23.39 (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: SunOS radius2 5.5.1 Generic_103640-31 sun4m sparc SUNW,SPARCclassic Architecture: sun4 Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/ucb/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.5.1/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: -rw-r--r-- 1 bin bin 1159728 Dec 24 1999 /lib/libc.a lrwxrwxrwx 1 root root 11 Jun 11 1998 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 665816 Dec 24 1999 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1159728 Dec 24 1999 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Jun 11 1998 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 665816 Dec 24 1999 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/export/mysql --with-debug # Date: Sun, 29 Aug 1999 14:11:27 -0600 Marcin Owsiany wrote: Hello! I have created mysql 3.22.25 from a source package. After a few tries (fixing the system include files as described in documentation) it compiled and installed cleanly. I've ran mysql_create_db and safe_mysqld - they didn't complain and the mysqld's log looked very good. However when i run mysql, it segfaults, dumps core and doesn't say anything. The same for mysqladmin, mysqlshow, mysqldump only mysqld runs OK.. I tried stracing them, but after a few attempts strace only says: ERROR: tracer exists and i do not know how to use it under Solaris :( (my native OS is Linux :) It seems to me that the stuff that segfaults are the stale binaries from the old corrupted/incompatible distribution. Make sure everything is what you've actually built from source. -- Sasha Pachev
RE: mysqldump loses auto_increment
Hi I am no pro with Mysql, but had similar results when first starting out. My understanding is that the Auto Increment value is held in a file other than the actual data file, so when it uses the auto-increment it is not reading the last value from the actual DB and then adding one, but rather looking in 'another file' and using the 'control' record. Therefore when creating the table the control record is set to one, if you specify a auto-increment number when importing data, the mysql handler does not goto the 'control' record and add one, because you specified a value. If you do not specify a value, then the handler WILL go the 'control' record and add one. a simple test is 1. create a test table 2. insert a record specifying your auto-increment value as 1 3. try inserting a record without specifying a auto-increment value, the first one may/may not work, but the second will definatelly not (sometimes if I remember correctly the first number may be 0, so the second one will be 1.) in my plain language there it is, but the pro's may give a more detailed approach. Regards Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ]On Behalf Of Alexander Skwar Sent: 17 July 2001 21:58 To: [EMAIL PROTECTED] Subject: mysqldump loses auto_increment Hello. I've just created a table with a auto_increment column. I then did ALTER TABLE tbl AUTO_INCREMENT=4711; Now, when I insert one row into this table, it get's 4711 as the auto_increment column's value. However, dumping this table with mysqldump --opt DB tbl loses the auto_increment value i set. So, if I'd replay the dump, the first time I insert a row it would get 1 for the auto_increment, and not 4711. How to circumvent this? Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 13 hours 25 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: modifying table with sort/unique
On Tue, Jul 17, 2001 at 03:34:01PM -0500, John Hunter wrote: Paul == Paul DuBois [EMAIL PROTECTED] writes: Paul ALTER IGNORE this_table ADD PRIMARY KEY (name,time) They are not null so this works well with a slight modification: ALTER IGNORE TABLE this_table ADD PRIMARY KEY (name,time) ^ Oops! My mistake. One further question. Will this automatically keep my rows ordered by the primary key with future inserts? Umm... no. It will prevent duplicate records from being created, but you don't have any control over the order in which records are stored. That's the server's job. To retrieve records in the order you want to see them, always use ORDER BY. Thanks for your help, John Hunter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: my.cnf in Windows 2000
Mike - Actually, your procedure below doesn't work for this extension. I always reset my system to show all extensions, including systems and hidden files, and this extension still doesn't appear. Haven't tried to unassociate the extension, as that's more invasive than I want to do. Anyway, the ini file work fine. Fred -Original Message- From: Mike Baranski [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 17, 2001 4:28 PM To: Dinkler, Fred; Philip Daggett Cc: Mysql List (E-mail) Subject: Re: MySQL: my.cnf in Windows 2000 Just go (in windows explorer) to view-optoins, and uncheck hide extensions of known file types, and the extensions will show up. You can also un-associate it through this. On Tuesday 17 July 2001 15:47, Dinkler, Fred wrote: Problem under Win2000 with any file having a .cnf extension. That extension is reserved by Win2000 as a system (Speed Dial) file and will automatically hide the extension from you. You can't search for it and it will not show it. IF you create a my.cnf file, it appears as my I use 'WINNT\my.ini' just fine as documented in 4.16.5 of the Manual and it works well. Regards, Fred \\|// (@ @) ---oOO---(_)---OOo | Fred Dinkler | | SVP Technology | | DFII Atlanta | | Office: 01.770.596.1443| -- |__|__| ooO Ooo -Original Message- From: Philip Daggett [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 17, 2001 2:40 PM To: [EMAIL PROTECTED] Subject: MySQL: my.cnf in Windows 2000 Anybody: I've installed (and got working!) MySQL on my Windows 2000 pc and am trying to use the my.cnf file. 1) The manual says that my.cnf is included in the installation and that I should copy it to c:\my.cnf. (Copy the file `\mysql\my-x.cnf' to `C:\my.cnf' and edit it to suit your setup.) However I searched and searched for the suggested file and could not find it (or anything like it...); 2) I created my own c:\my.cnf based on the my.ini file but it didn't work (i.e. the commands I put in to my.cnf had no effect); 3) I then put the same options into my.ini and everything worked just fine. I'm wondering 1) if using my.ini is O.K.; and 2) am I doing something wrong? Thanks, Phil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqldump loses auto_increment
So sprach »Warren van der Merwe« am 2001-07-17 um 22:31:02 +0200 : in my plain language there it is, but the pro's may give a more detailed approach. Yeah, that's sorta how I understand it as well. Also auto_increments BREAK when you manually insert a row and set the column with the auto_inc. to 0. Doing a dump will dump the 0 just fine - but using the dump to rebuild the table will set the row with the 0 to 1. In short, my experience is that if you use auto_incs you better do *NOT* touch columns with auto_inc values - especially do not modify them in a way mysql would not have done it itself. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 14 hours 30 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Database Replication
MySQL 3.23.29: up 31 days, processed 237,155,060 queries (87/sec. avg) Ok Jeremy I have to ask: How do you get your MySQL stats in your signature like that?:- Doug Henry - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Ben Smith [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, July 17, 2001 3:14 PM Subject: Re: Database Replication On Tue, Jul 17, 2001 at 02:49:15PM +0100, Ben Smith wrote: We are looking to replicate a couple of databases on to a second server. Having looked through the manual it says we need to add various commands to my.cnf. It turns out that we do not have a my.cnf (so apprently MySQL just defaults), so can we just create this file with the replication commands in it ? Yes, you can. Just make sure that they all appear in a [mysqld] section. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 -- NEW MySQL 3.23.29: up 31 days, processed 237,155,060 queries (87/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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: innodb on nt4
Hi, Actually both (ibdata and iblogs) are folders in ibdata. The files are written by InnoDB in these folders automatically. Just create yourself the folders: /some_dir/innodb/ibdata /some_dir/innodb/iblogs and it should work fine []s Crercio O. Silva -Original Message- From: Pete Kuczynski [mailto:[EMAIL PROTECTED]] Sent: terça-feira, 17 de julho de 2001 17:07 To: Crercio Osmaildo da Silva Cc: [EMAIL PROTECTED] Subject: Re: innodb on nt4 Hi, have a question about the inno_data_home_dir line on mysql-max3.23 do I create a file called ibdata cause it's not in any directory by default by default. innodb_data_home_dir = D:\Webapp\mysql\innodb\ibdata Pete - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: innodb and raw disks
database,sql,query,table Just to the record: I've written a small program too, and it reports correct sizes for normal disk devices under both linux 2.2 and 2.4, as long as the partition sizes don't exceed the 2GB limit (I don't have large file support, since I use debian potato with just the necessary packages upraded for running 2.4). I've NOT tried with *unbuffered raw* partitions, however (linux 2.4 supports both partition access with and without buffering), I don't know yet how to setup these. lseek returns 0 if there's no partition on the disk for the device being opened. #include iostream #include sys/types.h #include fcntl.h #include unistd.h #include errno.h #include string.h int main(int argn, char * args[]) { for (int i=1;iargn;i++) { int fd= open (args[i], O_RDONLY); if (fd!=-1) { off_t eof = lseek (fd, 0, SEEK_END); if (eof != -1) cout Eof of ` args[i] ' is at: eof \n; else cerrCould not lseek `args[i]': strerror(errno)\n; if (close (fd)==-1) cerr ??\n; } else { cerrCould not open `args[i]': strerror(errno)\n; } } } ./lseektest /dev/hda* Could not lseek `/dev/hda': Value too large for defined data type Could not lseek `/dev/hda1': Value too large for defined data type Eof of `/dev/hda10' is at: 0 Eof of `/dev/hda11' is at: 0 Eof of `/dev/hda12' is at: 0 Eof of `/dev/hda13' is at: 0 Eof of `/dev/hda14' is at: 0 Eof of `/dev/hda15' is at: 0 Eof of `/dev/hda16' is at: 0 Eof of `/dev/hda17' is at: 0 Eof of `/dev/hda18' is at: 0 Eof of `/dev/hda19' is at: 0 Eof of `/dev/hda2' is at: 1024 Eof of `/dev/hda20' is at: 0 Eof of `/dev/hda3' is at: 197406720 Could not lseek `/dev/hda4': Value too large for defined data type Could not lseek `/dev/hda5': Value too large for defined data type Could not lseek `/dev/hda6': Value too large for defined data type Eof of `/dev/hda7' is at: 682665984 Could not lseek `/dev/hda8': Value too large for defined data type Eof of `/dev/hda9' is at: 0 root@pflanze raw\ partitions# fdisk -l /dev/hda Disk /dev/hda: 255 heads, 63 sectors, 2110 cylinders Units = cylinders of 16065 * 512 bytes Device BootStart EndBlocks Id System /dev/hda1 * 1 383 3076416b Win95 FAT32 /dev/hda2 384 1659 10249470f Win95 Ext'd (LBA) /dev/hda3 1660 1683192780 82 Linux swap /dev/hda4 1684 2110 3429877+ 83 Linux /dev/hda5 384 766 3076416b Win95 FAT32 /dev/hda6 767 1149 3076416b Win95 FAT32 /dev/hda7 1150 123266b Win95 FAT32 /dev/hda8 1233 1659 3429846b Win95 FAT32 root@pflanze raw\ partitions# Cheers, Christian. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Simple problem compiling example program Simple1.cc under Linux
I am quite new to programming in Linux although I am no stranger to programming in Windows. This is my problem: I downloaded the mysql++ API and extracted it to /root/mysql++-1.7.9/ I browsed to /examples/ and thought I would try and compile simple1.cc. This is what I did from the terminal: terminal # g++ simple1.cc -I/usr/local/mysql/include/ -I/root/mysql++-1.7.9/sqlplusint/ /usr/local/mysql/ is where my MySQL 3.23.38 is installed /root/mysql++-1.7.9/ is the extracted API files I downloaded from mysql.com What am I doing wrong? PLEASE any ideas!! You should read README after you extract mysql++ :o) If you want to compile mysql++ libraries and examples do in your mysql++-1.7.9 directory: automake autoconf ./configure make make install Bye, .:: Andrius Armonas ::. .:: [EMAIL PROTECTED] ::. .:: http://baubas.andrius.org ::. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: innodb on nt4
Pete, no, below you have a path: innodb_data_home_dir = D:\Webapp\mysql\innodb\ibdata ibdata is a directory name, not a file name. InnoDB will add the extra backslash after it. But InnoDB does not create directories. You must manually create the directories you use. Regards, Heikki http://www.innodb.com Copied message: . Hi, have a question about the inno_data_home_dir line on mysql-max3.23 do I create a file called ibdata cause it's not in any directory by default by default. innodb_data_home_dir = D:\Webapp\mysql\innodb\ibdata Pete Crercio Osmaildo da Silva wrote: Hi, For windows systems, you can install mysql-max-3.23.39, that has support for both BDB and InnoDB. For InnoDB you need to change my.cnf and include these lines: # For Innodb Databases # change D:\WebApp\mysql\innodb and the other parameters to fit your # needs innodb_data_home_dir = D:\Webapp\mysql\innodb\ibdata innodb_data_file_path = ibdata1:20M;ibdata2:20M set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = D:\webapp\mysql\innodb\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = D:\webapp\mysql\innodb\iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 Then you use mysql\bin\mysqld-max-nt --install to install it as a service. You can run SHOW VARIABLES to see the which table types are available. That's it. If you need more help, just email-me. I'd be glad to help you out. []'s Crercio O. Silva -Original Message- From: Pete Kuczynski [mailto:[EMAIL PROTECTED]] Sent: terça-feira, 17 de julho de 2001 11:20 To: [EMAIL PROTECTED] Subject: innodb on nt4 Ok, tried to update existing table(s) to InnoDB [from MYISAM] using alter table da_table type=InnoDB;, but show variables still shows table_type as MYISAM. I have the newest mysql ddb from mysql.com, but it installs with MYISAM only, not InnoDB options. I cannot find any documentation on instaling mysql on NT with InnoDB compiled in. Is there such a thing? Where? Bottom line, how do I get InnoDB compiled in with a standard mysql database installation. All I want out of this is transaction support. Best Rgards! Pete ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php-- ___Pete KuczynskiSr. Field Engineer DHL Airways Inc.Infrastructure Technology Services(773)-462-9758 24/7 Helpdesk 1-800-434-5767 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: innodb on nt4
Aha! that's what I need to know, thanks a bunch. Pete Heikki Tuuri wrote: Pete, no, below you have a path: innodb_data_home_dir = D:\Webapp\mysql\innodb\ibdata ibdata is a directory name, not a file name. InnoDB will add the extra backslash after it. But InnoDB does not create directories. You must manually create the directories you use. Regards, Heikki http://www.innodb.com Copied message: . Hi, have a question about the inno_data_home_dir line on mysql-max3.23 do I create a file called ibdata cause it's not in any directory by default by default. innodb_data_home_dir = D:\Webapp\mysql\innodb\ibdata Pete Crercio Osmaildo da Silva wrote: Hi, For windows systems, you can install mysql-max-3.23.39, that has support for both BDB and InnoDB. For InnoDB you need to change my.cnf and include these lines: # For Innodb Databases # change D:\WebApp\mysql\innodb and the other parameters to fit your # needs innodb_data_home_dir = D:\Webapp\mysql\innodb\ibdata innodb_data_file_path = ibdata1:20M;ibdata2:20M set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = D:\webapp\mysql\innodb\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = D:\webapp\mysql\innodb\iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=80M set-variable = innodb_additional_mem_pool_size=10M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 Then you use mysql\bin\mysqld-max-nt --install to install it as a service. You can run SHOW VARIABLES to see the which table types are available. That's it. If you need more help, just email-me. I'd be glad to help you out. []'s Crercio O. Silva -Original Message- From: Pete Kuczynski [mailto:[EMAIL PROTECTED]] Sent: terça-feira, 17 de julho de 2001 11:20 To: [EMAIL PROTECTED] Subject: innodb on nt4 Ok, tried to update existing table(s) to InnoDB [from MYISAM] using alter table da_table type=InnoDB;, but show variables still shows table_type as MYISAM. I have the newest mysql ddb from mysql.com, but it installs with MYISAM only, not InnoDB options. I cannot find any documentation on instaling mysql on NT with InnoDB compiled in. Is there such a thing? Where? Bottom line, how do I get InnoDB compiled in with a standard mysql database installation. All I want out of this is transaction support. Best Rgards! Pete ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php-- ___Pete KuczynskiSr. Field Engineer DHL Airways Inc.Infrastructure Technology Services(773)-462-9758 24/7 Helpdesk 1-800-434-5767 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] -- ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqldump loses auto_increment
At 11:03 PM +0200 7/17/01, Alexander Skwar wrote: So sprach »Warren van der Merwe« am 2001-07-17 um 22:31:02 +0200 : in my plain language there it is, but the pro's may give a more detailed approach. Yeah, that's sorta how I understand it as well. Also auto_increments BREAK when you manually insert a row and set the column with the auto_inc. to 0. Doing a dump will dump the 0 just fine - but using the dump to rebuild the table will set the row with the 0 to 1. Yeah, doing that is asking for trouble. So is setting AI column values to negative numbers. In short, my experience is that if you use auto_incs you better do *NOT* touch columns with auto_inc values - especially do not modify them in a way mysql would not have done it itself. Alexander Skwar -- Paul DuBois, [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
archive of the mailing list
Hi all, My OutLook express some how got rib most of the mails I received from the mailing list for no reason. I have to say most of the mails are very good reference/resource and I would like to keep them for reference. I wonder if there is any way I can obtain an archive of the mailing list? does someone keep archiving the list at all? Thank you. Regards, Michael
RE: MySQL: my.cnf in Windows 2000
Hi Fred I have had the exac same problem, seems to be associated with 'SpeedDial', what I do it left click once on the file so that it is selected, then hold down the shift button and right click on the file, then gives you the option 'Open With', and use choose open width Notepad, or wordpad. Works well, but a bit of a hassle each time :-) Regards Warren ~ Warren van der Merwe Software Director PRT Trading (Pty) Ltd t/a RedTie Durban, South Africa Cell (+27-83) 262-9163 Office (+27-31) 767-0249 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ]On Behalf Of Dinkler, Fred Sent: 17 July 2001 22:45 To: [EMAIL PROTECTED]; Philip Daggett Cc: Mysql List (E-mail) Subject: RE: MySQL: my.cnf in Windows 2000 Mike - Actually, your procedure below doesn't work for this extension. I always reset my system to show all extensions, including systems and hidden files, and this extension still doesn't appear. Haven't tried to unassociate the extension, as that's more invasive than I want to do. Anyway, the ini file work fine. Fred -Original Message- From: Mike Baranski [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 17, 2001 4:28 PM To: Dinkler, Fred; Philip Daggett Cc: Mysql List (E-mail) Subject: Re: MySQL: my.cnf in Windows 2000 Just go (in windows explorer) to view-optoins, and uncheck hide extensions of known file types, and the extensions will show up. You can also un-associate it through this. On Tuesday 17 July 2001 15:47, Dinkler, Fred wrote: Problem under Win2000 with any file having a .cnf extension. That extension is reserved by Win2000 as a system (Speed Dial) file and will automatically hide the extension from you. You can't search for it and it will not show it. IF you create a my.cnf file, it appears as my I use 'WINNT\my.ini' just fine as documented in 4.16.5 of the Manual and it works well. Regards, Fred \\|// (@ @) ---oOO---(_)---OOo | Fred Dinkler | | SVP Technology | | DFII Atlanta | | Office: 01.770.596.1443| -- |__|__| ooO Ooo -Original Message- From: Philip Daggett [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 17, 2001 2:40 PM To: [EMAIL PROTECTED] Subject: MySQL: my.cnf in Windows 2000 Anybody: I've installed (and got working!) MySQL on my Windows 2000 pc and am trying to use the my.cnf file. 1) The manual says that my.cnf is included in the installation and that I should copy it to c:\my.cnf. (Copy the file `\mysql\my-x.cnf' to `C:\my.cnf' and edit it to suit your setup.) However I searched and searched for the suggested file and could not find it (or anything like it...); 2) I created my own c:\my.cnf based on the my.ini file but it didn't work (i.e. the commands I put in to my.cnf had no effect); 3) I then put the same options into my.ini and everything worked just fine. I'm wondering 1) if using my.ini is O.K.; and 2) am I doing something wrong? Thanks, Phil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
The mysig script (WAS Re: Database Replication)
On Tue, Jul 17, 2001 at 04:11:44PM -0500, doug wrote: MySQL 3.23.29: up 31 days, processed 237,155,060 queries (87/sec. avg) Ok Jeremy I have to ask: How do you get your MySQL stats in your signature like that?:- It's a bit of a hack, but you're not the first to ask... So here goes. It's a combo of 2 things: some small muttrc file changes and a script called `mysig' which generates the signature. Mind you, my original goal was to simply get something in my signature on every post to the MySQL lists so that the filter wouldn't bug me and I wouldn't have to think about it. But once that was done, I just took things a step or to farther... Maybe too far. :-) Anyway, I have the following lines in my ~/.mutt/muttrc file: ---snip--- folder-hook .*mysql.*set signature=~/bin/mysig| folder-hook .*nusphere.* set signature=~/bin/mysig| ---snip--- Those essentially tell mutt to use a custom signature (produced by running ~/bin/mysig) any time I compose a message while I'm any any folder that contains mysql or nusphere in its name. (The nusphere bit was a leftover from the Gemini beta program.) So what does ~/bin/mysig look like? It's a perl script which is bit longer that it may need to be and relies on a subclass (Finance::DBI) of a perl module (Db::MySql) that not available to the public (yet). But you should get the basic ideas. ---snip--- #!/usr/local/bin/perl # # mysig - grab some mysql stats for my signature on some mailing # lists.. Why? Because I could. # # Jeremy Zawodny [EMAIL PROTECTED]. This is GPL'd. use strict; use Finance::DBI; my $db = Finance::DBI-Connect('test'); my $debug = 0; die $! unless $db; my $version = get_variable(version); my $num_queries = get_status(Questions); my $uptime = get_status(Uptime); my $days_up = int($uptime / (60 * 60 * 24)); my $queries_per_sec = int($num_queries / $uptime); $version =~ s/-log//g; $version =~ s/-gamma//g; $version =~ s/-alpha//g; $version =~ s/-beta//g; print $num_queries $uptime $ days_up $queries_per_sec\n if $debug; open SIG, /home/jzawodn/.sig or die $!; print while SIG; close SIG; print \nMySQL $version: up $days_up days, processed , commify($num_queries), queries ($queries_per_sec/sec. avg)\n; exit; sub get_status($) { my $name = shift; my $sql = qq[SHOW STATUS LIKE $name]; return ($db-Array($sql))[1]; } sub get_variable($) { my $name = shift; my $sql = qq[SHOW VARIABLES LIKE $name]; return ($db-Array($sql))[1]; } sub commify($) { local $_ = shift; return 0 unless defined $_; 1 while s/^([-+]?\d+)(\d{3})/$1,$2/; return $_; } ---snip--- For the record, I'll be talking about that elusive perl module at the upcoming Open Source Database Summit. I'm working to clean it up so that I can put it on CPAN this summer. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 -- NEW MySQL 3.23.29: up 31 days, processed 237,496,954 queries (87/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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql.org
Re: Open Invitation to NuSphere and Progress NuSphere accepts MySQL AB's invitation to discuss resolution of our business issues. NuSphere and MySQL AB have already spoken via phone and confirmed discussions will commence on Friday, July 20th. NuSphere would welcome a fresh approach by MySQL AB to resolving these issues. The public postings and attempts to incite the community were not in the best interest of MySQL. We would welcome a productive dialog rather than a public campaign. NuSphere requests that MySQL AB continue discussions in the tone and spirit of the invitation. The pattern that has taken place over the past several months of extreme action by MySQL AB, followed by overtures for negotiation, continues to damage the trust needed to establish the further agreements that MySQL AB seeks. We note that public statements have been made after the invitation, statements that are not in the spirit of the invitation. During our discussions commencing Friday, we are willing to address the issue of delaying legal proceedings. MySQL AB must understand that its strong and very public statements denying the validity of the agreement we entered into on June 21, 2000, denying the rights granted to use MySQL related trademarks, and now denying the financial and technical contributions that NuSphere has made to MySQL, all underscore the need to seek legal enforcement of our rights. Any delay that NuSphere could agree to would require that MySQL AB show restraint and a spirit of cooperation in its ongoing public statements. As you are aware, we are forming a not-for-profit corporation to focus on building and supporting a larger MySQL development community and promoting MySQL. The mysql.org domain is expected to be transferred to that organization. NuSphere has taken the lead and is covering the costs of forming this organization and expects it will take some time before it can operate on its own. We firmly believe that establishing a source of information independent of any for-profit corporation is an important step for the long term health of the MySQL community. We encourage you to reconsider your opposition and join us in supporting this effort. The Gemini storage manager is now available under the GPL license via mysql.org. The new Gemini table handler, storage manager, and the existing MyISAM table handler provide the most scalable and reliable version of MySQL ever. This release completes the commitment NuSphere made and we jointly announced in January 2001 when our relationship was strong. Gemini as released under the GPL provides all the support for transactions, row level locking and crash recovery essential for building commercial applications. MySQL AB is encouraged to incorporate this significant contribution to the MySQL server sources to eliminate concerns about a fork. Regrettably MySQL AB cut off NuSphere's prior direct access to make those changes. NuSphere is a major sponsor of the OSCON 2001 conference and intends to heavily promote MySQL at the event. NuSphere has organized a MySQL track to further promote MySQL on both a technical and business level at the conference. NuSphere continues to support the formation of a noncommercial organization. All of these demonstrate the strength and depth of our commitment to the MySQL community. Your willingness to return to resolving our issues in a business-like fashion would be welcome. Sincerely, Britt Johnston CTO, NuSphere Corporation -- D. Britton Johnston 603-578-6707 Nashua Chief Technology Officer 781-280-4954 Bedford NuSphere Corporation 781-280-4600 Main 14 Oak Park 781-280-4646 Fax Bedford, MA 01730 www.nusphere.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