RE: out of memory
Hi, David! Try to write your query without order by ... Sort operations need a lot of memory. But, if you want to use sorting, try to split your big table to smaller tables. Dmitri Lubinski -Original Message- From: David Keeney [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 6:14 AM To: MySQL List Subject: out of memory Sorry. I omitted an important detail from the previous post: I have a database of almost 6 million records, and 1.5 Gbyte table size. I need to iterate over the table with a Perl script, examining every record. This code : $sth_gnr = $dbh-prepare( 'SELECT SQL_BIG_RESULT * FROM Tiger_main '. WHERE rdid '' . 'ORDER BY rdid ' #. ) or die 'bad prepare gnr'; $sth_gnr-execute; dies (during the execute statement) with the error : Out of Memory: Killed process 31666 (temp.pl). Killed The same query executed by the mysql client dies with an almost identical error message. Is there a fast way to iterate over the database with a succession of 'Select ... ' queries? A statement like 'Select * from Tiger_main limit 1,1' is very slow, and iterating over the entire table would take weeks. I am using MySQL server version 3.23.36 under RH Linux 7.1. Thanks for any support you can offer. David Keeney --- End of forwarded message --- -- David Keeney [EMAIL PROTECTED] Travel By Road http://www.travelbyroad.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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Insert text/string which is contain semicolon
Hi all, can some body help me ... ? I have a problem to insert string which is contain semicolon to mySQL Database. For your info : When I try to insert string which is contain semicolon to mySQL in the free webserver www.f2s.com (see my project http://www.verisdev.f2s.com ), I have no problem, but the problem prompt when I try to insert the string which is contain semicolon to mySQL in the free webserver www.webappcabaret.com ( see my project http://www.webappcabaret.com/verisdev ) Thanks in advanced, Veris e-mail : [EMAIL PROTECTED] url : http://www.verisdev.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: tables locked
Hello I use TQuery for select requests and TTable for update, insert and delete, it's easier than typing an SQL sentence :-) My problem has been resolved by a checkbox on the MyODBC driver: I checked Safety (check this if you have problems) and I've no problem anymore. Strange or magic, isn't it ? *** REPLY SEPARATOR *** On 10/07/2001 at 10:21 Noel Clarkson wrote: How are you updating in delphi and what is the error? if you are running a query, setting the edit state and request live (either at design or run time) and then updating the data and it complains that someone else has changed the record then check the TQuery settings, there is one that determines whether delphi uses the key field(s) or the entire row to match when updating. Obviously if you match using the entire row (which was the default in my setup) you'll never be able to update the row because it will always have changed and so woun't match (I'm still confussed as to why you'd even have such an option, but one day I might understand). If it is telling you that there is a lock on the table and that is why you can't update then I haven't had that happen but I'd suggest trying to update from another client interface and see if it complains about the table being locked (if you can try one that runs through odbc that might help determine where the problem orrigonates). good luck, cheers, noel On Monday, July 09, 2001 6:59 PM, Patrick Premartin [SMTP:[EMAIL PROTECTED]] wrote: I use Delphi 5 and MyODBC to access a MySQL database. In my program, I've sometimes a tables locked and I don't understand why ! I am the only user on this database and I change records correctly (as I do it for other programs on other databases). Does somebody have this problem ? Can you explain me how to unlock tables and records with MySQL ? Is it a bug in Borland Delphi ou BDE ? Is it a bug in MyODBC ? Is it a bug in MySQL ? Is it a bug in my program (I don't see where I could have make an error... but it's a possibility) ? You did not included enough information to solve your problem. But I can thing we can solve it easily if you give us output of mysqladmin processlist while the problem exists. I think we can read out the problem from there. Hi Only mine process appears in the list. I think the bug in inside the Borland Database Engine and its parameters. I'll try something and let you know. cu9 -- Patrick Premartin contacts perso: [EMAIL PROTECTED], http://www.pprem.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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Patrick Premartin contacts perso: [EMAIL PROTECTED], http://www.pprem.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 Solaris 8 Tuning
Hi! I am currently installing and testing the latest stable version of mysql with an sunblade 1000 workstations (2 cpu, 750 MHz, 1 GB RAM). Does anybody know some hints how to tune the OS (solaris performance tuning). Thanks in advance Wolf -- -- Dr. Wolf Dieter Brandt Tel.: +49-(0)40-251523-426 Systemberater Fax.: +49-(0)40-256811 Computer Systems Web: www.sun.de Sun Microsystems GmbH Email:[EMAIL PROTECTED] Eiffestrasse 80Mobile: +49-(0)172 813 66 42 D-20537 HamburgGERMANY -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Easiest way to create a duplicate of a db?
Cal Evans wrote: mysqldump products products.sql grep s/products/products1/ products.sql products1.sql mysql products1.sql Assuming that nothing else in the database is named products. (i.e. you don't have any fields or tables named products) If you did have fields or tables, you would most likely have to make the edits by hand to products.sql. or in keeping with my 'dangerous ideas' theme: mysqldump products | grep s/products/products1/ mysql (I am rusty on my regex so I'd check that s// expression before I used it) You'd want to use sed, not grep. -- Jack Challen Technical Consultant OCSL http://www.ocsl.co.uk/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 behaviour with multiple clients
Hi all, I begin to validate MySQL with InnoDB on our platform. I use a DBI perl test which manages a data pool reflecting exactly the rows stored in DB. This test internally builds some new data to insert and chooses rows to delete and update (the tables are chosen randomly). Then all these operations are executed in one transaction. If it fails, a rollback is executed in DB and in client memory. Client also check that all data in its pool are in the DB. That's my test... It works very well with one client, but with two... things become harder! clients received many 'Table handler error 100' and slow down terrifically. I try the same test with 3 clients on MyISAM tables and there is no noticeable problems. I have reduced number of queries per transaction. I have changed innodb_unix_file_flush_method to O_DSYNC. I have increased buffer pool size and log buffer size but I noticed onlky small improvements. I'm sure I forgot something, but I don't see what ! does somebody know ?? Denis -- Denis Pithon phone +33 (0) 1 41 40 02 13 Software Engineerfax+33 (0) 1 41 40 02 01 Lineo High Availability Groupmail [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: ERROR 2013: Lost connection to MySQL server during query
Hi, Here's a bit of a followup: I've narrowed my problem down to one of our servers, the one running mySQL 3.22.27. The server is listening to port 3306, but is taking a very long time to respond to requests sent to that port. It seems to hang but it eventually responds after a few minutes. Any ideas why it would be taking so long? This is on a RH 6.0 system. Thank you! Kurt Hansen [EMAIL PROTECTED] Subject: ERROR 2013: Lost connection to MySQL server during query Hello, I'm getting the error message above whenever I try to connect from a remote host to a MySQL server. I issue the following command: mysql --host=host_name -u user_name -ppass_word and get the ERROR 2013 back as a response. We have two servers, both running MySQL. I get the same message going both ways. I have all the privileges set up properly. When I don't, I just get the host_name not set up for access message. I've duplicated the setup on our local LAN, and I connect with no problem. It is only our Web servers that are having this problem. We are only having this problem after our ISP moved our servers to a new, better network and gave us new IPs. The servers have been talking to each other with no problems for almost 1.5 years, but have not been able to since the move. I've updated the privilege information, but it appears that the client is not getting a complete response from the server. Any ideas on what to do to fix this? Troubleshooting clues? The request from the remote server is not showing up in the log; anyway I could capture this? I can telnet between the systems so I'm pretty sure the TCP/IP is working. MySQL versions are 3.22.27 on Linux RH 6.0 and 3.22.21 on Linux RH 5.2. The mysqld variables are set to their default except for max_allowed_packet, which has been increased to 10048512 on the 3.22.21 system in a vain attempt to solve the error. Thanks! Kurt Hansen [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
LIMIT with mysql_num_rows
Hello, I want to know if there is some way to return the number of rows in a query, the complete query, while using a LIMIT $start, $end command. Unfortunately, so far, using $result = mysql_query($SELECT); $qct = mysql_num_rows($result); Results in $qct being equal to $end, which I already knew. Is it possible to get this figure without doing a separate query? Thanks for any help... Keith Spiller [EMAIL PROTECTED]
LIMIT with mysql_num_rows
Hello, I want to know if there is some way to return the number of rows in a query, the complete query, while using a LIMIT $start, $end command. Unfortunately, so far, using $result = mysql_query($SELECT); $qct = mysql_num_rows($result); Results in $qct being equal to $end, which I already knew. Is it possible to get this figure without doing a separate query? Thanks for any help... Keith Spiller [EMAIL PROTECTED]
Innodb does not work with NT Max 3.23.39
Hi! I wanted to use row level locking. I modified the my.ini as follows : #This File was made using the WinMySQLadmin 1.1 Tool #7/10/2001 10:59:39 AM [mysqld] basedir=C:/mysql datadir=C:/mysql/data innodb_data_file_path = ibdata1:2000M;ibdata2:2000M innodb_data_home_dir = e:\innodb\data set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = e:\innodb\logs 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 = e:\innodb\arch 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 [WinMySQLadmin] Server=C:/mysql/bin/mysqld-max-nt.exe user=system password=manager QueryInterval=10 --- But when I try to start the db with winmysqladmin, it does not start. No error is given. According innodb documentation starting the database should create innodb tablespaces, but nothing is created. Mysql gives this error message : ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) --- Please help. And please send the message also directly to me because I am not in the list. Leo _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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
FULLTEXT indexing versus '%text%'
I have been trying to implement FULLTEXT indexing in a very long table with varchars and text fields that require LIKE '%something%' a lot. I managed to index and change all queries to use AGAINST and etc. but the users didn't like it. They say they really need the functioning of '%text%'. Sending 'protect' from the app they want to receive: 1) 'the protection' 2) 'protecting the whales' 3) 'please protect me' and not: 1) 'please protect me' as happens with FULLTEXT indexing. Is there a way to index a '%text%' like string? Using fulltext? Something else? Couldn't find on the manual Thanks a lot, Tiago Luchini Diretor Técnico-Comercial Galluch Soluções Internet Telefax: 11 6912 3255 Celular: 11 3176 7740 http://www.galluch.com.br/
Re: Perl DBI to MySQL -- Passing info to query
r Seems that you are not taking advantage of Perl. This is what you can do: No, he is taking advantage of placeholders. It is much better to use placeholder for value substitution that substitute values directly into query with Perl because there is no need to escape values (do you know that $dbh-quote doesn't quote reliably?) and $sth can be reused for simular queries (which can give perfomance gain on some SQL databases). However usually placeholders can be used only for value substitutuion. 'DESC' cannot be substituted since it is a part of query. r $parentid = x; r $orderby = 'DESC'; rmy $sth = $dbh - prepare (qq{ r SELECT message.name, contents, user.name, message.id r FROM message, user r WHERE folder='N' and parentid=$parentid r GROUP BY message.id r ORDER BY time $orderby r }) || die $dbh-errstr; r You can put any variable inside the string... Note that I changed the q{ r ... } to qq{ ... } r $string = q{ string } is the same as $string = 'string'; r $string = qq{ string } is the same as $string = string; r Note that variables inside of strings enclosed by '' will not be translated, r only strings enclosed by (or qq{} =) ). -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- | Ilya Martynov (http://martynov.org/)| | GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB 323B DEE6 | | AGAVA Software Company (http://www.agava.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
Comress table
Hi, I want to compress my tables but I gets an error: C:\mysql-data\dtim9tmyisampack wi_abbreviation.MYI Compressing wi_abbreviation.MYD: (7221 records) - Calculating statistics - Compressing file myisampack: Error on delete of 'wi_abbreviation.MYD' (Errcode: 13) Aborting: wi_abbreviation.MYD is not compressed C:\mysql-data\dtim9t' How can I solve this? Best regards Joacim Jarkeborn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqld-nt.exe
Dear Support I notice that mysqld-nt.exe is running after I start my computer. Firstly, I can't seem to shut it down with ' bin\mysqladmin -u root shutdown'. Secondly, what do I do in order not to have 'mysqld-nt.exe' starting up every time I switch on? Thanking you. Regards. Russell H. Bernstein SAP MM Consultant Spiridon Global Training Team Office Tel: + 49 (0)89 636 47778 Office Fax: + 49 (0)89 636 33635 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
Recall: mysqld-nt.exe
Bernstein Russel (extern) would like to recall the message, mysqld-nt.exe. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqld-nt.exe
Dear Support Further to my earlier e-mail, please ignore my first request. Thanks. RHB I notice that mysqld-nt.exe is running after I start my computer. Firstly, I can't seem to shut it down with ' bin\mysqladmin -u root shutdown'. Secondly, what do I do in order not to have 'mysqld-nt.exe' starting up every time I switch on? Thanking you. Regards. Russell H. Bernstein SAP MM Consultant Spiridon Global Training Team Office Tel: + 49 (0)89 636 47778 Office Fax: + 49 (0)89 636 33635 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
Segmentation Fault - core dumped
hello I am trying to run a mysql data base on a sparc20 running solaris 2.6. The data base loads and works fine, but when I load Msql-Mysql-modules. I get a Segmentation Fault - core dumped . when I run a cgi script from the command line the data is obtained from the data base, but again I get the Segmentation Fault which causes an error in the apache web server. I have tried several versions of mysql, perl and modules with the same problem. Can anyone tell me what version to run or how to solve the seg problem. Thankyou bob - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Installinging MySQL on a virtual server
Thanx Tonu. I used the command ./configure --prefix=/usr/local/WWW/www.mydomain.com/mysql --with-unix-socket-path=prefix=/usr/local/WWW/www.mydomain.com/mysql/.mysql. sock The service works perfectly when started as bin/safe_mysqld --skip-locking --skip-networking I have entered the command in the .bootrc file in the root of my home directory to make sure it wille be restarted after a reboot. So you see, your tips were vaulable. Ton Geurts Hi, I wonder I someone can give me some advice about the following situation. I have to install MySQL to be used with a website on a virtual server. This gives the following restraints: * MySQL must be installed in my user directory /usr/local/WWW/www.mydomain.com/mysql * I am only allowed to use the TCP/IP ports on the virutal host www.mydomain.com, not on the actual host. * I have no root access and cannot edit the startup scripts. * My provider uses BSDI BSD 4.0.1 as operating system on the host. Who has any clues for me? No problem. You can change all related paths in your .my.cnf file. Even better if you can compile MySQL and give command configure with flag prefix=/usr/local/WWW/www.mydomain.com/mysql to it, then MySQL will use all directories relative to this point. Because there is a more MySQL-s mabye running on same server, you can start server using --skip-networking flag. Then you still can use MySQL over socket ni your home directory. Only thing you cannot do without root access is having MySQL started when machine get rebooted. -- 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Server configuration denies access to data source
hi. I had installed mysql on redhat-7.0 I have a java program that inserts, deletes from mysql. It used to work fine. I had to reinstall linux and hence mysql. Now the same program doesnt work. I get the error: Server configuration denies access to data source I can access the databases from the mysql prompt, but not from the java program. Also the db, columns_priv, tables_priv tables in mysql database are empty even though there are 3 users and 3 non empty databases. Is this normal? Please help. -sagar __ 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
HOW TO CONNECT COBOL TO MYSQL, BOTH ON LINUX?
Hi all, I am entering this forum for the first time. I have Cobol and MySQL on my Redhat Linux machine. What drivers- if any- do I use to connect my Cobol program with MySQL? I have heard of ACU4GL but I would like to confirm from someone here before I proceed. Sample code or URLs containing sample codes would be warmly appreciated. Regards. R.Srivatsan [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 behaviour with multiple clients
Hello Denis, Tuesday, July 10, 2001, 12:51:40 PM, you wrote: If I'm not mistaken the problem is - conflicting transactions which you have here. I'm really not shure INNODB dead lock detection is quite fine graned. Also it's shurely may roll back more long running transaction. But anyway you should be ableto handle this. DP Hi all, DP I begin to validate MySQL with InnoDB on our platform. I use a DBI perl DP test which manages a data pool reflecting exactly the rows stored in DB. DP This test internally builds some new data to insert and chooses rows to DP delete and update (the tables are chosen randomly). Then all these DP operations are executed in one transaction. If it fails, a rollback is DP executed in DB and in client memory. Client also check that all data in DP its pool are in the DB. That's my test... DP It works very well with one client, but with two... things become DP harder! clients received many 'Table handler error 100' and slow DP down terrifically. DP I try the same test with 3 clients on MyISAM tables and there is no DP noticeable problems. DP I have reduced number of queries per transaction. I have changed DP innodb_unix_file_flush_method to O_DSYNC. I have increased buffer pool DP size and log buffer size but I noticed onlky small improvements. I'm DP sure I forgot something, but I don't see what ! does somebody know ?? DP Denis -- 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: Trying to install GUI, flvw and fl_editor compile errors
Hi! Just download and use our static binary for Linux. -- 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
Join syntax
Is it possible to join two tables from different databases that are located on different hosts? Thanks, Rodney - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
String Size Limit?
I'm running into an odd string size limitation. I've traced it down as far as I can get, and I didn't run across anything in the docs or on any searches I've run so I figured I'd try here. The field in the database is a TEXT type column. I'm appending to the front of the text field each time using: UPDATE field SET notes=CONCAT(newtext,notes) WHERE ... However the field is cutting off after 4096 bytes. With a hunch that CONCAT may have been causing the limit, I switched to doing the concatenation inside of the application and setting the full field. The same cut-off occurs in storage, however the SQL executes correctly so it's not like the query is getting cut off and not seeing the WHERE clause. Seeing as this happens in CONCAT which should be server side I suspect I'm running into a server-side limitation. My app is PHP3 over IIS on NT4.0 using MyODBC 2.50.3300 to a Linux Server running MySQL 3.22.32 precompiled (when you get 100 day 24/7 uptime no problem you don't upgrade!). What incredibly obvious piece of documentation am I missing, is this a you need to upgrade thing, or what would be a reasonable work-around in this rather abstracted environment? Thanks, Sean - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Processes Sleeping for a long time
Please excuse if this is a FAQ or well known effect. I'm running mySql version 3.23.36 on a Winnt 4.0 Sp6a machine. It's connected to a jsp page (running on resin2..0.0) through mmsql JDBC drivers. Over a period fo days I'm seeing a build up of sleeping threads which will eventually meet the max_threads value.Now I hasten to add I am really only a beginer with mySql. Is there some way I can clear these sleeping threads and free up Id's? Is there a way to garbage collect threads that have been sleeping for maore than say 24 hours ? I've attached a potion of the Show Processlist output. Andy C Editor r2 project http://www.r2-dvd.org +--+---+-+-+-+-- --+---+--+ | Id | User | Host| db | Command | Time | State | Info | +--+---+-+-+-+-- --+---+--+ |1 | installer | localhost | Stories | Sleep | 247744 | | NULL | |2 | installer | localhost | Stories | Sleep | 247783 | | NULL | |3 | installer | localhost | Stories | Sleep | 247809 | | NULL | |4 | installer | localhost | Stories | Sleep | 247754 | | NULL | |5 | installer | localhost | Stories | Sleep | 247826 | | NULL | | 19 | installer | localhost | NULL| Sleep | 2 | | NULL | | 214 | installer | localhost | film| Sleep | 9749 | | NULL | | 405 | installer | localhost | Stories | Sleep | 247733 | | NULL | | 406 | installer | localhost | Stories | Sleep | 246930 | | NULL | | 417 | installer | localhost | Stories | Sleep | 246954 | | NULL | | 434 | installer | localhost | Stories | Sleep | 246900 | | NULL | | 435 | installer | localhost | Stories | Sleep | 246869 | | NULL | | 438 | installer | localhost | Stories | Sleep | 104816 | | NULL | | 439 | installer | localhost | Stories | Sleep | 183613 | | NULL | - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help!!!I can not make mysql on freebsd 4.3 ???
Description: I have tried many times to make mysql-3.23.39 on freebsd4.3.But it always stopped at the same point(see the below).And I even tried make it on different machines(Crixy MII¡¢PIII),it stopped at the same point.I even can not install it by use ports or packages-add.Whats the matter??Who can help me to resolved it???Thanks!! ck!' -e 's!@''IS_LINUX''@!false!' -e s!@CONF_COMMAND@!./configure ! -e 's!@''MYSQLD_USER''@!root!' -e 's!@''sysconfdir''@!/usr/local/etc!' -e 's!@''SHORT_MYSQL_INTRO''@!@SHORT_MYSQL_INTRO@!' -e 's!@''SHARED_LIB_VERSION''@!10:0:0!' -e 's!@''MYSQL_BASE_VERSION''@!3.23!' -e 's!@''MYSQL_NO_DASH_VERSION''@!3.23.39!' -e 's!@''MYSQL_TCP_PORT''@!3306!' -e 's!@''PERL_DBI_VERSION''@!@PERL_DBI_VERSION@!' -e 's!@''PERL_DBD_VERSION''@!@PERL_DBD_VERSION@!' -e 's!@''PERL_DATA_DUMPER''@!@PERL_DATA_DUMPER@!' mysql.spec.sh mysql.spec-t /bin/mv mysql.spec-t mysql.spec rm -f mysql-3.23.39.spec cp mysql.spec mysql-3.23.39.spec /bin/rm -f binary-configure binary-configure-t /usr/bin/sed -e 's!@''bindir''@!/usr/local/bin!g' -e 's!@''sbindir''@!/usr/local/sbin!g' -e 's!@''scriptdir''@!/usr/local/bin!g' -e 's!@''prefix''@!/usr/local!g' -e 's!@''datadir''@!/usr/local/share!g' -e 's!@''localstatedir''@!/usr/local/var!g' -e 's!@''libexecdir''@!/usr/local/libexec!g' -e 's!@''CC''@!gcc!' -e 's!@''CXX''@!c++!' -e 's!@''GXX''@!yes!' -e 's!@''PERL''@!/usr/bin/perl!' -e 's!@''CFLAGS''@!!' -e 's!@''CXXFLAGS''@!!' -e 's!@''LDFLAGS''@!!' -e 's!@''VERSION''@!3.23.39!' -e 's!@''MYSQL_SERVER_SUFFIX''@!!' -e 's!@''COMPILATION_COMMENT''@!Source distribution!' -e 's!@''MACHINE_TYPE''@!i386!' -e 's!@''HOSTNAME''@!/bin/hostname!' -e 's!@''SYSTEM_TYPE''@!unknown-freebsdelf4.3!' -e 's!@''CHECK_PID''@!/bin/kill -0 $PID /dev/null 2 /dev/null!' -e 's!@''FIND_PROC''@!/bin/ps p $PID | grep mysqld /dev/null!' -e 's!@''MYSQLD_DEFAULT_SWITCHES''@!!' -e 's!@''MYSQL_UNIX_ADDR''@!/tmp/mysql.sock!' -e 's!@''IS_LINUX''@!false!' -e s!@CONF_COMMAND@!./co! nfigure ! -e 's!@''MYSQLD_USER''@!root!' -e 's!@''sysconfdir''@!/usr/local/etc!' -e 's!@''SHORT_MYSQL_INTRO''@!@SHORT_MYSQL_INTRO@!' -e 's!@''SHARED_LIB_VERSION''@!10:0:0!' -e 's!@''MYSQL_BASE_VERSION''@!3.23!' -e 's!@''MYSQL_NO_DASH_VERSION''@!3.23.39!' -e 's!@''MYSQL_TCP_PORT''@!3306!' -e 's!@''PERL_DBI_VERSION''@!@PERL_DBI_VERSION@!' -e 's!@''PERL_DBD_VERSION''@!@PERL_DBD_VERSION@!' -e 's!@''PERL_DATA_DUMPER''@!@PERL_DATA_DUMPER@!' binary-configure.sh binary-configure-t /bin/mv binary-configure-t binary-configure How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:zosen Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: mysql can not build on freebsd 4.3 Severity: Priority: Category: mysql Class: Release: mysql-3.23.39 (Source distribution) Environment: System: FreeBSD DateTest 4.3-RELEASE FreeBSD 4.3-RELEASE #0: Sat Apr 21 10:54:49 GMT 2001 [EMAIL PROTECTED]:/usr/src/sys/compile/GENERIC i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.3 [FreeBSD] 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1174570 Apr 21 09:05 /usr/lib/libc.a lrwxrwxrwx 1 root wheel 9 Jul 10 13:08 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 561580 Apr 21 09:05 /usr/lib/libc.so.4 Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes --without-perl --enable-thread-safe-client --with-berkeley-db --with-innodb Perl: This is perl, version 5.005_03 built for i386-freebsd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Processes Sleeping for a long time
Well to clear threads just type KILL threadID. You get the thread ID from Show Processlist. If the threads are sleeping it the client software that is making this happen(JDBS) So there are several thing to do Change the length in MySQL that sleeping threads are closed (8h standard)... You should be able to set the number of threads form 200 up to 1000 with out any problems.. And the last and best thing to do is get your app to close the thread as soon as it has done a question Simon -Original Message- From: Andy C [mailto:[EMAIL PROTECTED]] Sent: 10 July 2001 13:55 To: [EMAIL PROTECTED] Subject: Processes Sleeping for a long time Please excuse if this is a FAQ or well known effect. I'm running mySql version 3.23.36 on a Winnt 4.0 Sp6a machine. It's connected to a jsp page (running on resin2..0.0) through mmsql JDBC drivers. Over a period fo days I'm seeing a build up of sleeping threads which will eventually meet the max_threads value.Now I hasten to add I am really only a beginer with mySql. Is there some way I can clear these sleeping threads and free up Id's? Is there a way to garbage collect threads that have been sleeping for maore than say 24 hours ? I've attached a potion of the Show Processlist output. Andy C Editor r2 project http://www.r2-dvd.org +--+---+-+-+-+-- --+---+--+ | Id | User | Host| db | Command | Time | State | Info | +--+---+-+-+-+-- --+---+--+ |1 | installer | localhost | Stories | Sleep | 247744 | | NULL | |2 | installer | localhost | Stories | Sleep | 247783 | | NULL | |3 | installer | localhost | Stories | Sleep | 247809 | | NULL | |4 | installer | localhost | Stories | Sleep | 247754 | | NULL | |5 | installer | localhost | Stories | Sleep | 247826 | | NULL | | 19 | installer | localhost | NULL| Sleep | 2 | | NULL | | 214 | installer | localhost | film| Sleep | 9749 | | NULL | | 405 | installer | localhost | Stories | Sleep | 247733 | | NULL | | 406 | installer | localhost | Stories | Sleep | 246930 | | NULL | | 417 | installer | localhost | Stories | Sleep | 246954 | | NULL | | 434 | installer | localhost | Stories | Sleep | 246900 | | NULL | | 435 | installer | localhost | Stories | Sleep | 246869 | | NULL | | 438 | installer | localhost | Stories | Sleep | 104816 | | NULL | | 439 | installer | localhost | Stories | Sleep | 183613 | | NULL | - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Insert text/string which is contain semicolon
I have a problem to insert string which is contain semicolon to mySQL Database. Try escaping ;, i.e. use \; instead. -- 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: Help!!!I can not make mysql on freebsd 4.3 ???
Hi Zosen, Looking at what you submitted, there does not seem to be an error, it looks good to me! Do you have anything in /usr/local/bin/mysql ? (hint: ls -l /usr/local/bin/mysql* ) Your problem description is a little vague. I have many servers running this version installed from ports and compiled from source. I think it is time for you to try initialising your databases if the mysql binaries have installed. Ken - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 4:54 PM Subject: Help!!!I can not make mysql on freebsd 4.3 ??? Description: I have tried many times to make mysql-3.23.39 on freebsd4.3.But it always stopped at the same point(see the below).And I even tried make it on different machines(Crixy MII¡¢PIII),it stopped at the same point.I even can not install it by use ports or packages-add.Whats the matter??Who can help me to resolved it???Thanks!! ck!' -e 's!@''IS_LINUX''@!false!' -e s!@CONF_COMMAND@!./configure ! -e s!@''MYSQLD_USER''@!root!' -e s!@''sysconfdir''@!/usr/local/etc!' -e 's!@''SHORT_MYSQL_INTRO''@!@SHORT_MYSQL_INTRO@!' -e 's!@''SHARED_LIB_VERSION''@!10:0:0!' -e 's!@''MYSQL_BASE_VERSION''@!3.23!' -e 's!@''MYSQL_NO_DASH_VERSION''@!3.23.39!' -e 's!@''MYSQL_TCP_PORT''@!3306!' -e 's!@''PERL_DBI_VERSION''@!@PERL_DBI_VERSION@!' -e 's!@''PERL_DBD_VERSION''@!@PERL_DBD_VERSION@!' -e 's!@''PERL_DATA_DUMPER''@!@PERL_DATA_DUMPER@!' mysql.spec.sh mysql.spec-t /bin/mv mysql.spec-t mysql.spec rm -f mysql-3.23.39.spec cp mysql.spec mysql-3.23.39.spec /bin/rm -f binary-configure binary-configure-t /usr/bin/sed -e 's!@''bindir''@!/usr/local/bin!g' -e 's!@''sbindir''@!/usr/local/sbin!g' -e 's!@''scriptdir''@!/usr/local/bin!g' -e s!@''prefix''@!/usr/local!g' -e s!@''datadir''@!/usr/local/share!g' -e 's!@''localstatedir''@!/usr/local/var!g' -e 's!@''libexecdir''@!/usr/local/libexec!g' -e 's!@''CC''@!gcc!' -e 's!@''CXX''@!c++!' -e 's!@''GXX''@!yes!' -e 's!@''PERL''@!/usr/bin/perl!' -e 's!@''CFLAGS''@!!' -e 's!@''CXXFLAGS''@!!' -e 's!@''LDFLAGS''@!!' -e 's!@''VERSION''@!3.23.39!' -e 's!@''MYSQL_SERVER_SUFFIX''@!!' -e 's!@''COMPILATION_COMMENT''@!Source distribution!' -e 's!@''MACHINE_TYPE''@!i386!' -e 's!@''HOSTNAME''@!/bin/hostname!' -e 's!@''SYSTEM_TYPE''@!unknown-freebsdelf4.3!' -e 's!@''CHECK_PID''@!/bin/kill -0 $PID /dev/null 2 /dev/null!' -e 's!@''FIND_PROC''@!/bin/ps p $PID | grep mysqld /dev/null!' -e 's!@''MYSQLD_DEFAULT_SWITCHES''@!!' -e 's!@''MYSQL_UNIX_ADDR''@!/tmp/mysql.sock!' -e 's!@''IS_LINUX''@!false!' -e s!@CONF_COMMAND@!./co! nfigure ! -e 's!@''MYSQLD_USER''@!root!' -e 's!@''sysconfdir''@!/usr/local/etc!' -e 's!@''SHORT_MYSQL_INTRO''@!@SHORT_MYSQL_INTRO@!' -e 's!@''SHARED_LIB_VERSION''@!10:0:0!' -e 's!@''MYSQL_BASE_VERSION''@!3.23!' -e 's!@''MYSQL_NO_DASH_VERSION''@!3.23.39!' -e 's!@''MYSQL_TCP_PORT''@!3306!' -e 's!@''PERL_DBI_VERSION''@!@PERL_DBI_VERSION@!' -e 's!@''PERL_DBD_VERSION''@!@PERL_DBD_VERSION@!' -e 's!@''PERL_DATA_DUMPER''@!@PERL_DATA_DUMPER@!' binary-configure.sh binary-configure-t /bin/mv binary-configure-t binary-configure How-To-Repeat: Fix: Submitter-Id: submitter ID Originator: zosen Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: mysql can not build on freebsd 4.3 Severity: Priority: Category: mysql Class: Release: mysql-3.23.39 (Source distribution) Environment: System: FreeBSD DateTest 4.3-RELEASE FreeBSD 4.3-RELEASE #0: Sat Apr 21 10:54:49 GMT 2001 [EMAIL PROTECTED]:/usr/src/sys/compile/GENERIC i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.3 [FreeBSD] 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1174570 Apr 21 09:05 /usr/lib/libc.a lrwxrwxrwx 1 root wheel 9 Jul 10 13:08 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 561580 Apr 21 09:05 /usr/lib/libc.so.4 Configure command: /configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-mem ory --with-mit-threads=yes --without-perl --enable-thread-safe-client --with-berkeley-db --with-innodb Perl: This is perl, version 5.005_03 built for i386-freebsd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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?
Re: Join syntax
As it seems, it is not possible. You would have to have a connection which talks to two databases at once, which may not be possible at all, at least create numerous problems. But I think it should be possible to create a temporary table in db 2 and copy the table from db1 into it, then do a join with that temporary table. Question is: what kind of an application do you have that you need such a thing? Is it possible to join two tables from different databases that are located on different hosts? -- 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: MySQL ISP
i like www.Missoulweb.com check em out.. Ken - Original Message - From: Ohannes Murat Berin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, July 09, 2001 5:12 PM Subject: MySQL ISP I am searching for an ISP which has MySQL, any suggestions? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Help!!!I can not make mysql on freebsd 4.3 ???
Hi!Ken Menzel I try to initialize my datebase.but it output as the below.What's the matter?? DateTest# ./mysql_install_db Sorry, the host 'DateTest' could not be looked up. Please configure the 'hostname' command to return a correct hostname. If you want to solve this at a later stage, restart this script with the --force option DateTest# - Original Message - From: Ken Menzel [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Sent: Tuesday, July 10, 2001 9:16 PM Subject: Re: Help!!!I can not make mysql on freebsd 4.3 ??? Hi Zosen, Looking at what you submitted, there does not seem to be an error, it looks good to me! Do you have anything in /usr/local/bin/mysql ? (hint: ls -l /usr/local/bin/mysql* ) Your problem description is a little vague. I have many servers running this version installed from ports and compiled from source. I think it is time for you to try initialising your databases if the mysql binaries have installed. Ken - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 4:54 PM Subject: Help!!!I can not make mysql on freebsd 4.3 ??? Description: I have tried many times to make mysql-3.23.39 on freebsd4.3.But it always stopped at the same point(see the below).And I even tried make it on different machines(Crixy MII¡¢PIII),it stopped at the same point.I even can not install it by use ports or packages-add.Whats the matter??Who can help me to resolved it???Thanks!! ck!' -e 's!@''IS_LINUX''@!false!' -e s!@CONF_COMMAND@!./configure ! -e s!@''MYSQLD_USER''@!root!' -e s!@''sysconfdir''@!/usr/local/etc!' -e 's!@''SHORT_MYSQL_INTRO''@!@SHORT_MYSQL_INTRO@!' -e 's!@''SHARED_LIB_VERSION''@!10:0:0!' -e 's!@''MYSQL_BASE_VERSION''@!3.23!' -e 's!@''MYSQL_NO_DASH_VERSION''@!3.23.39!' -e 's!@''MYSQL_TCP_PORT''@!3306!' -e 's!@''PERL_DBI_VERSION''@!@PERL_DBI_VERSION@!' -e 's!@''PERL_DBD_VERSION''@!@PERL_DBD_VERSION@!' -e 's!@''PERL_DATA_DUMPER''@!@PERL_DATA_DUMPER@!' mysql.spec.sh mysql.spec-t /bin/mv mysql.spec-t mysql.spec rm -f mysql-3.23.39.spec cp mysql.spec mysql-3.23.39.spec /bin/rm -f binary-configure binary-configure-t /usr/bin/sed -e 's!@''bindir''@!/usr/local/bin!g' -e 's!@''sbindir''@!/usr/local/sbin!g' -e 's!@''scriptdir''@!/usr/local/bin!g' -e s!@''prefix''@!/usr/local!g' -e s!@''datadir''@!/usr/local/share!g' -e 's!@''localstatedir''@!/usr/local/var!g' -e 's!@''libexecdir''@!/usr/local/libexec!g' -e 's!@''CC''@!gcc!' -e 's!@''CXX''@!c++!' -e 's!@''GXX''@!yes!' -e 's!@''PERL''@!/usr/bin/perl!' -e 's!@''CFLAGS''@!!' -e 's!@''CXXFLAGS''@!!' -e 's!@''LDFLAGS''@!!' -e 's!@''VERSION''@!3.23.39!' -e 's!@''MYSQL_SERVER_SUFFIX''@!!' -e 's!@''COMPILATION_COMMENT''@!Source distribution!' -e 's!@''MACHINE_TYPE''@!i386!' -e 's!@''HOSTNAME''@!/bin/hostname!' -e 's!@''SYSTEM_TYPE''@!unknown-freebsdelf4.3!' -e 's!@''CHECK_PID''@!/bin/kill -0 $PID /dev/null 2 /dev/null!' -e 's!@''FIND_PROC''@!/bin/ps p $PID | grep mysqld /dev/null!' -e 's!@''MYSQLD_DEFAULT_SWITCHES''@!!' -e 's!@''MYSQL_UNIX_ADDR''@!/tmp/mysql.sock!' -e 's!@''IS_LINUX''@!false!' -e s!@CONF_COMMAND@!./co! nfigure ! -e 's!@''MYSQLD_USER''@!root!' -e 's!@''sysconfdir''@!/usr/local/etc!' -e 's!@''SHORT_MYSQL_INTRO''@!@SHORT_MYSQL_INTRO@!' -e 's!@''SHARED_LIB_VERSION''@!10:0:0!' -e 's!@''MYSQL_BASE_VERSION''@!3.23!' -e 's!@''MYSQL_NO_DASH_VERSION''@!3.23.39!' -e 's!@''MYSQL_TCP_PORT''@!3306!' -e 's!@''PERL_DBI_VERSION''@!@PERL_DBI_VERSION@!' -e 's!@''PERL_DBD_VERSION''@!@PERL_DBD_VERSION@!' -e 's!@''PERL_DATA_DUMPER''@!@PERL_DATA_DUMPER@!' binary-configure.sh binary-configure-t /bin/mv binary-configure-t binary-configure How-To-Repeat: Fix: Submitter-Id: submitter ID Originator: zosen Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: mysql can not build on freebsd 4.3 Severity: Priority: Category: mysql Class: Release: mysql-3.23.39 (Source distribution) Environment: System: FreeBSD DateTest 4.3-RELEASE FreeBSD 4.3-RELEASE #0: Sat Apr 21 10:54:49 GMT 2001 [EMAIL PROTECTED]:/usr/src/sys/compile/GENERIC i386 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.3 [FreeBSD] 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1174570 Apr 21 09:05 /usr/lib/libc.a lrwxrwxrwx 1 root wheel 9 Jul 10 13:08 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 561580 Apr 21 09:05 /usr/lib/libc.so.4 Configure command: /configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-mem ory --with-mit-threads=yes --without-perl --enable-thread-safe-client --with-berkeley-db --with-innodb Perl: This is perl, version 5.005_03 built for i386-freebsd
Re: Help!!!I can not make mysql on freebsd 4.3 ???
What is in /etc/hosts file? My server named tuvok has this: bash-2.04$ cat /etc/hosts 127.0.0.1 localhost.icarz.com localhost 207.99.22.16tuvok.icarz.com tuvok 207.99.22.16tuvok.icarz.com. bash-2.04$ Your machine needs a name, there are examples in /etc/hosts. I would also recommend a good system administration book like: Unix System Administration Handbook from Prentice Hall, ISBN 0-13-020601-6 Ken - Original Message - From: zosen [EMAIL PROTECTED] To: Ken Menzel [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 9:30 AM Subject: Re: Help!!!I can not make mysql on freebsd 4.3 ??? Hi!Ken Menzel I try to initialize my datebase.but it output as the below.What's the matter?? DateTest# ./mysql_install_db Sorry, the host 'DateTest' could not be looked up. Please configure the 'hostname' command to return a correct hostname. If you want to solve this at a later stage, restart this script with the --force option DateTest# - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Win32 - replication - Error 1133
Hi everybody, I use Replication on a windows NT4 Server. There are 1 master and 2 slaves, all on the same machine. One slave is started with the option skip-name-resolve, not the other. For the 2 slaves : master-host=localhost When adding a user (MYSQL.User), the replication is OK but, when I use GRANT, I get a 1133 error. Let's have a look on a slave : MYSQL.User table : localhost | jkasas | 1896f443280395b3 And what I do and get : mysql GRANT SELECT ON MEMBERS.users TO jkasas@'localhost'; ERROR 1133: Can't find any matching row in the user table Personnally, I don't understand why. Does anyone understand ? Thx for the answers. -- Frederic BALU - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: String Size Limit?
I'm running into an odd string size limitation. I've traced it down as far as I can get, and I didn't run across anything in the docs or on any searches I've run so I figured I'd try here. The field in the database is a TEXT type column. I'm appending to the front of the text field each time using: Are you able to insert content at possible length? Are you able to update the same? You should be able to track it down. -- 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
Can't get keys for table poll (Lost connection to MySQL server during query)
I am getting an error when I try to use mysqldump on a database. /usr/local/mysql/bin/mysqldump: Can't get keys for table poll (Lost connection to MySQL server during query) When this happens, I get a message in the mysql error log saying the database has been restarted. mysqld restarted on Thu Jul 5 15:14:58 EDT 2001 /usr/local/mysql/libexec/mysqld: ready for connections A mysqld.core file is also created. I can connect to the database with the mysql client without any problems. I can also insert and update records using the mysql client. I am also getting an error when I try to connect to the database with MyODBC. [TCX][MyODBC]Lost connection to MySQL server during query (2013) Here is my version info. /usr/local/mysql/bin/mysql Ver 9.38 Distrib 3.22.32, for unknown-freebsdelf4.0 (i386) Edward Waldspurger CertifiChecks, Inc. - www.certifichecks.com
Re[4]: Where to find options / my.cnf documentation?
I'll give you an example: I start mysqld as such: mysqld -O max_allowed_packet=2M This set the option. You can do it also in my.cnf: [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=16M set-variable= max_allowed_packet=16M set-variable= thread_stack=128K Sie schrieben am Montag, 9. Juli 2001, 18:41:12: Ihre Nachricht vom Monday 09 July 2001 17:10: It's so easy, you won't think of it: start mysqld with parameter -h (=help): mysqld -h shows all parameters and current settings Alas, it does not. It shows a couple of variable settings, but not the syntax for tha various logging options and the like. So the question for a complete options syntax of my.cnf remains open. -- 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
Hellp with this error message. I am lost :(
While installing mysql in a linux box (mandarake) i had this error. Please, guys, help me out. I need to install this mysql in this box as soon as possible :( ERROR [root@cral mysql]# scripts/mysql_install_db scripts/mysql_install_db: ./bin/my_print_defaults: cannot execute binary file WARNING: The host 'cral.cel.cmich.edu' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL deamon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables scripts/mysql_install_db: ./bin/mysqld: cannot execute binary file Installation of grant tables failed! Examine the logs in ./data for more information. You can also try to start the mysqld daemon with: ./bin/mysqld --skip-grant You can use the command line tool ./bin/mysql to connect to the mysql database and look at the grant tables: shell ./bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in ./data that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the ./bin/mysqlbug script! [root@cral mysql]# mysqld --log bash: mysqld: command not found [root@cral mysql]# ls -l /ERROR Thank you - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Query
See my other post just a couple of minutes ago. Sie schrieben am Dienstag, 10. Juli 2001, 15:37:29: Hi! I am facing a problem .It is somewhat like that. I want to insert the 3mb data in the table column using MYSQL as my database. It shows the error which says that you have to increase the 'max_allowed_packet' packet size. I work on windows platform. i am unable to get the solution how i can configure the server variables like 'max_allowed_packet' and 'net_buffer_length'. If you have the solution for it .please send me as soon as possible. Please let me know how could i change the server variables. -- 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: Many Unauthenticatd Users
On 2001.07.10 05:46:25 -0200 Gerlinde Fischer wrote: Hi, maybe you should use when connecting to mysql with the webserver instead of pconnect connect. Pconnect is persistent and is staying as long as you have set the wait_timeout. It is set to 28800 sec by default. Regards Gerlinde At 15:17 09.07.01 -0200, you wrote: On 2001.07.09 11:04:35 -0200 Don Read wrote: Stop Apache (or whatever the source of your logins), shut down restart mysqld, then check/repair the tables in the mysql database; might want check any other high activity tables also. restart Apache. We already tried that. As long as we keep the webservers causing most of the traffic down everything works fine. When reactivating those servers the problem reappears. Maybe mysql has problems inserting data into a table while doing a huge delete-query on the same table? (Around 2am the server has to delete something between 60 and 90 entries while still inserting new data into the table). -- Mario Witte [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 BLITZ Internet Service GmbH Kronacher Strasse 41 D-96052 Bamberg, Germany Tel. +49/951/9685160, Fax +49/951/9685164 http://www.blitz.net Hello, meanwhile we found a solution to the problem. After updating all server and clients to the mysql 3.23.39 the server stopped spawning those dead threads and about an hour later all dead threads had timed out. We still don't know why the problem occured so suddenly (the system had worked for weeks without any interruption before), but it doesn't occur anymore. With regards, -- Mario Witte [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: Unable to install mysql version 3.23.39a (min) on a Win2000P work station.
At 14:54 09/07/2001 -0400, Khuon, Dave wrote: Hi, Please, read the Manual \mysql\docs\manual.html section 8.7.2 InnoDB startup options. Regards, Miguel I recently downloaded the latest MYSQL version 2.23.39a (from page http://www.mysql.com/downloads/mysql-3.23.39a.zip), and installed it as directed by the instructions: * install directory: c:/mysql, * datadir: c:/mysql/data, * and created the config file: c:/my.cnf (see below). When I typed to start mysql: mysqld --standalone, I got error (see below), and the DOS session hangs. My workstation is a Thinkpad 760ED, running Win2000 Professional, SP2. Please help. Error: Microsoft Windows 2000 [Version 5.00.2195] (C) Copyright 1985-2000 Microsoft Corp. U:\c: C:\cd mysql C:\mysqlcd bin C:\mysql\binmysqld --standalone Can't initialize InnoDB as 'innodb_data_file_path' is not set File: c:/my.cnf # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password password=my_password port=3306 #socket=MySQL socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 #socket=MySQL socket=MySQL skip-locking default-character-set=latin1 set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = flush_time=1800 # Uncomment the following row if you move the MySQL distribution to another # location #basedir = d:/mysql/ basedir=c:/mysql/ datadir=c:/mysql/data/ [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key=16M [client_fltk] help_file= c:\mysql\sql_client\MySQL.help client_file= c:\mysql\MySQL.options history_length=20 database = test queries_root= c:\mysql\queries last_database_file= c:\mysql\lastdb Bin Dir: Directory of C:\mysql\bin 07/09/2001 11:59a DIR . 07/09/2001 11:59a DIR .. 06/13/2001 07:40p 1,101,824 mysqld-opt.exe 06/13/2001 08:10p 1,880,064 mysqld-max.exe 06/13/2001 07:15p 1,880,064 mysqld-max-nt.exe 06/13/2001 06:40p 1,101,824 mysqld-nt.exe 06/13/2001 01:55p 2,756,653 mysqld.exe 06/13/2001 08:54p 262,144 isamchk.exe 06/13/2001 08:51p 323,584 myisamchk.exe 06/13/2001 08:55p 253,952 myisamlog.exe 06/13/2001 08:43p 249,856 myisampack.exe 06/13/2001 06:25p 266,289 mysql.exe 06/13/2001 06:25p 229,376 mysqladmin.exe 06/13/2001 08:50p 208,896 mysqlbinlog.exe 10/30/1998 02:06a 334,712 mysqlc.exe 05/12/2001 01:13a 221,184 mysqlcheck.exe 06/13/2001 06:25p 229,376 mysqldump.exe 06/13/2001 06:25p 217,088 mysqlimport.exe 06/13/2001 06:26p 512,000 MySqlManager.exe 06/13/2001 06:26p 221,184 mysqlshow.exe 06/13/2001 08:48p 28,672 mysqlshutdown.exe 06/13/2001 08:49p 32,768 mysqlwatch.exe 06/13/2001 08:56p 217,088 pack_isam.exe 06/13/2001 08:58p 139,264 perror.exe 06/13/2001 06:28p 159,744 replace.exe 06/19/2000 03:51a 818 winmysqladmin.cnt 04/18/2001 08:18p 1,168,896 winmysqladmin.exe 06/19/2000 03:52a 1,856,816 WINMYSQLADMIN.HLP 26 File(s) 15,854,136 bytes 2 Dir(s) 108,232,704 bytes free C:\mysql\bin Regards, Dave Khuon Electronic Data Systems E.Solution 1900 Springer Road Lombard, Illinois, 60148 * +1 (312) 419-7984 (8*539) Fax +1 (312) 345-5057 (8*539) * [EMAIL PROTECTED] ...OLE_Obj... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ 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
Help on cross table Query
Please help me here, and let me know if MySQL can do it or not. All people around me told it should work in SyBASE. Yan Zhang [EMAIL PROTECTED] I have two tables: mysql show tables; +--+ | Tables_in_vendor | +--+ | savedata | | tradeday | +--+ 5 rows in set (0.01 sec) mysql describe tradeday; +-+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-+---+ | tradedate | date | YES | | NULL| | | previousday | date | YES | | NULL| | +-+--+--+-+-+---+ 2 rows in set (0.00 sec) mysql describe savedata; ++---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++---+--+-+-+---+ | tradedate | date | YES | | NULL| | | sym| char(9) | | | | | | cusip | char(10) | YES | | NULL| | | closeprice | float | YES | | NULL| | | drm_share | float | YES | | NULL| | | indx | char(10) | YES | | NULL| | | weight | double(20,15) | YES | | NULL| | | closedate | date | YES | | NULL| | ++---+--+-+-+---+ 8 rows in set (0.00 sec) mysql select distinct tradedate from savedata ; ++ | tradedate | ++ | -00-00 | ++ 1 row in set (0.03 sec) mysql select * from savedata limit 2; ++--+---++---+---+-- -++ | tradedate | sym | cusip | closeprice | drm_share | indx | weight | closedate | ++--+---++---+---+-- -++ | -00-00 | ABT | 002824100 | 51.4 | 1546.59 | sp500 | 0.17239345228 | 2001-05-25 | | -00-00 | ADCT | 000886101 |8.6 |777.31 | sp500 | 0.08664448947 | 2001-05-25 | ++--+---++---+---+-- -++ 2 rows in set (0.01 sec) mysql select * from tradeday where previousday = '2001-05-25'; ++-+ | tradedate | previousday | ++-+ | 2001-05-29 | 2001-05-25 | ++-+ 1 row in set (0.03 sec) HERE ARE THE QUERY I TRIED: mysql update savedata SET tradedate='1' where savedata.closedate = tradeday.previousday; ERROR 1109: Unknown table 'tradeday' in where clause mysql update savedata SET tradedate='1' from tradeday, savedata where savedata.closedate = tradeday.previousday; ERROR 1064: You have an error in your SQL syntax near 'from tradeday, savedata where savedata.closedate = tradeday.previousday' at line 1 mysql update savedata SET tradedate='2001-01-01' from tradeday, savedata where savedata.closedate = tradeday.previousday; ERROR 1064: You have an error in your SQL syntax near 'from tradeday, savedata where savedata.closedate = tradeday.previousday' at line 1 mysql update savedata SET tradedate='2001-01-01' from tradeday a, savedata b where b.closedate = a.previousday; ERROR 1064: You have an error in your SQL syntax near 'from tradeday a, savedata b where b.closedate = a.previousday' at line 1 mysql update savedata SET tradedate='2001-01-01' from tradeday a, savedata b where a.previousday=b.closedate; ERROR 1064: You have an error in your SQL syntax near 'from tradeday a, savedata b where a.previousday=b.closedate' at line 1 mysql update savedata SET weight='1' from tradeday a, savedata b where a.previousday = b.closedate; ERROR 1064: You have an error in your SQL syntax near 'from tradeday a, savedata b where a.previousday = b.closedate' at line 1 mysql update savedata SET weight='1.0' from tradeday a, savedata b where a.previousday = b.closedate; ERROR 1064: You have an error in your SQL syntax near 'from tradeday a, savedata b where a.previousday = b.closedate' at line 1 mysql update savedata SET weight='1.0' where tradeday.previousday = savedata.closedate; ERROR 1109: Unknown table 'tradeday' in where clause mysql update savedata SET weight='1' where select tradeday.tradedate from tradeday,savedata where savedata.closedate = tradeday.previousday; ERROR 1064: You have an error in your SQL syntax near 'select tradeday.tradedate from tradeday,savedata where savedata.closedate = trad' at line 1 mysql update savedata SET weight='1' where savedata.closedate in (select tradeday.tradedate from tradeday,savedata where savedata.closedate = tradeday.previousday); ERROR 1064: You have an error in your SQL syntax near 'select tradeday.tradedate from tradeday,savedata where savedata.closedate = tra' at line 1 mysql update savedata SET weight='1' where savedata.closedate = (select max(
Re: Help!!!I can not make mysql on freebsd 4.3 ???
Hi!Ken Menzel I edit the file /etc/hosts,and make mysql-3.23.39.but it stopped at the below point !!help me ?!!Thanks!! - SQLD_NET_RETRY_COUNT=100 -c convert.cc c++ -DMYSQL_SERVER - DDEFAULT_MYSQL_HOME=\/usr/local/mysql\ - DDATADIR=\/date/mysql/date\- DSHAREDIR=\/usr/local/mysql/share/mysql\ - DHAVE_CONFIG_H -I./../include -I./../regex - I. -I../include -I.. -I.-O3 -DDBUG_OFF -fno-implicit-templates -fno- exceptions -fno-rtti -DMYSQLD_NET_RETRY_COUNT=100 -c sql_parse.cc In file included from mysql_priv.h:222, from sql_parse.cc:18: sql_class.h: In method `Key::Key(Key::Keytype, const char *, Listkey_part_spec )': sql_class.h:172: Internal compiler error. sql_class.h:172: Please submit a full bug report. sql_class.h:172: See URL:http://www.gnu.org/software/gcc/bugs.html for instructions. *** Error code 1 Stop in /date/home/zosen/mysql-3.23.39/sql. *** Error code 1 Stop in /date/home/zosen/mysql-3.23.39/sql. *** Error code 1 Stop in /date/home/zosen/mysql-3.23.39. *** Error code 1 Stop in /date/home/zosen/mysql-3.23.39. DateServer# DateServer# cat /etc/hosts # $FreeBSD: src/etc/hosts,v 1.11.2.1 2000/08/18 18:29:19 ume Exp $ # # Host Database # This file should contain the addresses and aliases # for local hosts that share this file. # In the presence of the domain name service or NIS, this file may # not be consulted at all; see /etc/host.conf for the resolution order. # # 192.168.0.123 DateServer ::1 localhost localhost.my.domain myname.my.domain 127.0.0.1 localhost localhost.my.domain myname.my.domain # # Imaginary network. #10.0.0.2 myname.my.domain myname #10.0.0.3 myfriend.my.domain myfriend # # According to RFC 1918, you can use the following IP networks for # private nets which will never be connected to the Internet: # # 10.0.0.0- 10.255.255.255 # 172.16.0.0 - 172.31.255.255 # 192.168.0.0 - 192.168.255.255 # # In case you want to be able to connect to the Internet, you need # real official assigned numbers. PLEASE PLEASE PLEASE do not try # to invent your own network numbers but instead get one from your # network provider (if any) or from the Internet Registry (ftp to # rs.internic.net, directory `/templates'). # DateTest# - Original Message - From: Ken Menzel [EMAIL PROTECTED] To: zosen [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 9:54 PM Subject: Re: Help!!!I can not make mysql on freebsd 4.3 ??? What is in /etc/hosts file? My server named tuvok has this: bash-2.04$ cat /etc/hosts 127.0.0.1 localhost.icarz.com localhost 207.99.22.16tuvok.icarz.com tuvok 207.99.22.16tuvok.icarz.com. bash-2.04$ Your machine needs a name, there are examples in /etc/hosts. I would also recommend a good system administration book like: Unix System Administration Handbook from Prentice Hall, ISBN 0-13-020601-6 Ken - Original Message - From: zosen [EMAIL PROTECTED] To: Ken Menzel [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 9:30 AM Subject: Re: Help!!!I can not make mysql on freebsd 4.3 ??? Hi!Ken Menzel I try to initialize my datebase.but it output as the below.What's the matter?? DateTest# ./mysql_install_db Sorry, the host 'DateTest' could not be looked up. Please configure the 'hostname' command to return a correct hostname. If you want to solve this at a later stage, restart this script with the --force option DateTest# - Before posting, please check: http://www.mysql.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- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php zosen --- ChinaNetCenter ShenZhen Tel:86755-5170776 Fax:86755-5161004 Email: [EMAIL PROTECTED] Http://www.chinanetcenter.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: Fwd: Join syntax
I think the solution would be to do the join at the application level rather than in the database. We frequently had to do this in msql because it did joins so badly. Basically you do the select in the first table including the linking field and then do selects against the second table (this is actually relatively fast using prepared queries if the linking field(s) in the second database is an index. On Mon, 9 Jul 2001, Rodney A. Ramos wrote: Date: Mon, 9 Jul 2001 21:38:44 -0300 From: Rodney A. Ramos [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Fwd: Join syntax Is it possible to join two tables from different databases that are located on different hosts? Thanks, Rodney - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: String Size Limit?
I hit up against something like this a while ago, but I didnt have time to debug so I used a quick hack to get by. Say you are storing a text article -- | ArticleID | INT | -- |ArticleName | TEXT | -- I just created a separate table to hold the text - Articleid | INT | - textid | INT | - text | TEXT | - When saving the text I split it up into small chuncks and then give each chuck an number in order. Each chunck gets stored in the second table and is identified by the articleid. To reassemble the text I read in all the chunks from teh second table. The my program works with the text When I need to save the edited text I drop all entries for that article from the second table , break the edited text into chunks again. And save. Its probably inefficent as hell, but for my purposes it worked. -Original Message- From: Dougherty, Sean [mailto:[EMAIL PROTECTED]] Sent: 10 July 2001 13:45 To: '[EMAIL PROTECTED]' Subject: String Size Limit? I'm running into an odd string size limitation. I've traced it down as far as I can get, and I didn't run across anything in the docs or on any searches I've run so I figured I'd try here. The field in the database is a TEXT type column. I'm appending to the front of the text field each time using: UPDATE field SET notes=CONCAT(newtext,notes) WHERE ... However the field is cutting off after 4096 bytes. With a hunch that CONCAT may have been causing the limit, I switched to doing the concatenation inside of the application and setting the full field. The same cut-off occurs in storage, however the SQL executes correctly so it's not like the query is getting cut off and not seeing the WHERE clause. Seeing as this happens in CONCAT which should be server side I suspect I'm running into a server-side limitation. My app is PHP3 over IIS on NT4.0 using MyODBC 2.50.3300 to a Linux Server running MySQL 3.22.32 precompiled (when you get 100 day 24/7 uptime no problem you don't upgrade!). What incredibly obvious piece of documentation am I missing, is this a you need to upgrade thing, or what would be a reasonable work-around in this rather abstracted environment? Thanks, Sean - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
backup/restore of mysql
Hi, I've posted this question before, and some were kind enough to respond with suggestions to my question [replication], but I'm looking for something more difinitave. Background: I'm running a production mysql database/php4/Apache on a NT4 IBM Netfinity server [3500 records, growing by 100 a day or so]. I do not have the option to go to lunux/unix [company's call not mine]. I am backing up the database twice a day, noon and 6 pm. Question: if a disk should crash, I can recover the database from the last tape backup, but not the transactions that took place in between. Is replacation of the database on another box my only option? Dosn't mysql support transaction logging like MSSQL or Oricle, or Postgres?. I don't wan't to switch to another database, but as this one grows, it's becoming incrisingly important to be able to do a complete database recovery in the event of a crash. Kindest thanks! 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
users in mysql
3.22.38 Hello guys I figured out how I can set up different user that are able to work on their own dbs. here is my command to add a db and a user; GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON bernddb.* TO bernduser@LOCALHOST IDENTIFIED BY '1234' But a questions: when I have added the user with root, log out and log in with the user bernduser, I am able to see all databases (just the names) is there a way to cut this? Of cource he is only able to work in his own, but I only want him to see his own db bernddb. Thanks Marco - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: phpmyadmin and mysql client conflict!! HOW?!
Here's a clearer indication of the problem I mentioned earlier: In the mysql client terminal output below, note how the column type of startDate does not show up as changed from timestamp to date (even though I had changed it earlier in phpmyadmin) until I run Repair Table on the table in PHPMYADMIN. Is the Repair Table command refreshing the table cache or something else that PHPMYADMIN is failing to do? mysql show columns from checklist; +-+---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +-+---+--+-+-+---+ | checklistID | int(11) | | PRI | 0 | | | eventID | int(11) | | | 0 | | | label | varchar(50) | | | | | | startDate | timestamp(14) | YES | | NULL| | | statusID| int(11) | | | 0 | | | version | int(11) | YES | | NULL| | +-+---+--+-+-+---+ 6 rows in set (0.00 sec) mysql exit Bye [localhost:Documents/somehost/credo] root# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 950 to server version: 3.23.38 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql use credo; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql show columns from checklist; +-+---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +-+---+--+-+-+---+ | checklistID | int(11) | | PRI | 0 | | | eventID | int(11) | | | 0 | | | label | varchar(50) | | | | | | startDate | timestamp(14) | YES | | NULL| | | statusID| int(11) | | | 0 | | | version | int(11) | YES | | NULL| | +-+---+--+-+-+---+ 6 rows in set (0.03 sec) mysql repair table checklist; +-++--+--+ | Table | Op | Msg_type | Msg_text | +-++--+--+ | credo.checklist | repair | status | OK | +-++--+--+ 1 row in set (0.04 sec) mysql show columns from checklist; +-+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+-+---+ | checklistID | int(11) | | PRI | 0 | | | eventID | int(11) | | | 0 | | | label | varchar(50) | | | | | | startDate | date| YES | | NULL| | | statusID| int(11) | | | 0 | | | version | int(11) | YES | | NULL| | +-+-+--+-+-+---+ 6 rows in set (0.01 sec) mysql On Tuesday, July 10, 2001, at 08:08 AM, Werner Stuerenburg wrote: I just changed a column type (timestamp -- date) in PHPmyadmin, but when I checked the table structure in the mysql client immediately afterwards, it showed up with the old column type!! Has anyone else had something like this happen? No. I just tested, everything ok. How can PHPmyadmin and the mysql client show different output?!! phpMyAdmin shows you the query. Check it for consistency. -- 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 mysql-unsubscribe- [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
Solaris
Like you have a RPM install for Linux is there something similar that I can use with Solaris to make the install simple with Mysql? Thanks Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help on cross table Query
No, MySQL does not support subquery so you need work around (not use) it, by creating temp tbl and/or join etc. Think it a diff. SQL style. Yan Zhang wrote: Please help me here, and let me know if MySQL can do it or not. All people around me told it should work in SyBASE. Yan Zhang [EMAIL PROTECTED] I have two tables: mysql show tables; +--+ | Tables_in_vendor | +--+ | savedata | | tradeday | +--+ 5 rows in set (0.01 sec) mysql describe tradeday; +-+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-+---+ | tradedate | date | YES | | NULL| | | previousday | date | YES | | NULL| | +-+--+--+-+-+---+ 2 rows in set (0.00 sec) mysql describe savedata; ++---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++---+--+-+-+---+ | tradedate | date | YES | | NULL| | | sym| char(9) | | | | | | cusip | char(10) | YES | | NULL| | | closeprice | float | YES | | NULL| | | drm_share | float | YES | | NULL| | | indx | char(10) | YES | | NULL| | | weight | double(20,15) | YES | | NULL| | | closedate | date | YES | | NULL| | ++---+--+-+-+---+ 8 rows in set (0.00 sec) mysql select distinct tradedate from savedata ; ++ | tradedate | ++ | -00-00 | ++ 1 row in set (0.03 sec) mysql select * from savedata limit 2; ++--+---++---+---+-- -++ | tradedate | sym | cusip | closeprice | drm_share | indx | weight | closedate | ++--+---++---+---+-- -++ | -00-00 | ABT | 002824100 | 51.4 | 1546.59 | sp500 | 0.17239345228 | 2001-05-25 | | -00-00 | ADCT | 000886101 |8.6 |777.31 | sp500 | 0.08664448947 | 2001-05-25 | ++--+---++---+---+-- -++ 2 rows in set (0.01 sec) mysql select * from tradeday where previousday = '2001-05-25'; ++-+ | tradedate | previousday | ++-+ | 2001-05-29 | 2001-05-25 | ++-+ 1 row in set (0.03 sec) HERE ARE THE QUERY I TRIED: mysql update savedata SET tradedate='1' where savedata.closedate = tradeday.previousday; ERROR 1109: Unknown table 'tradeday' in where clause mysql update savedata SET tradedate='1' from tradeday, savedata where savedata.closedate = tradeday.previousday; ERROR 1064: You have an error in your SQL syntax near 'from tradeday, savedata where savedata.closedate = tradeday.previousday' at line 1 mysql update savedata SET tradedate='2001-01-01' from tradeday, savedata where savedata.closedate = tradeday.previousday; ERROR 1064: You have an error in your SQL syntax near 'from tradeday, savedata where savedata.closedate = tradeday.previousday' at line 1 mysql update savedata SET tradedate='2001-01-01' from tradeday a, savedata b where b.closedate = a.previousday; ERROR 1064: You have an error in your SQL syntax near 'from tradeday a, savedata b where b.closedate = a.previousday' at line 1 mysql update savedata SET tradedate='2001-01-01' from tradeday a, savedata b where a.previousday=b.closedate; ERROR 1064: You have an error in your SQL syntax near 'from tradeday a, savedata b where a.previousday=b.closedate' at line 1 mysql update savedata SET weight='1' from tradeday a, savedata b where a.previousday = b.closedate; ERROR 1064: You have an error in your SQL syntax near 'from tradeday a, savedata b where a.previousday = b.closedate' at line 1 mysql update savedata SET weight='1.0' from tradeday a, savedata b where a.previousday = b.closedate; ERROR 1064: You have an error in your SQL syntax near 'from tradeday a, savedata b where a.previousday = b.closedate' at line 1 mysql update savedata SET weight='1.0' where tradeday.previousday = savedata.closedate; ERROR 1109: Unknown table 'tradeday' in where clause mysql update savedata SET weight='1' where select tradeday.tradedate from tradeday,savedata where savedata.closedate = tradeday.previousday; ERROR 1064: You have an error in your SQL syntax near 'select tradeday.tradedate from tradeday,savedata where savedata.closedate = trad' at line 1 mysql update savedata SET weight='1' where savedata.closedate in (select tradeday.tradedate from tradeday,savedata where
Re: Help!!!I can not make mysql on freebsd 4.3 ???
Try this assuming you are compiling from source (not ports) create a test file called makemysql.sh put this in it gmake -s clean rm config.cache CC=gcc CFLAGS=-O3 CXX=gcc \ CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \ ./configure $DEBUG --enable-large-files --with-berkeley-db --with-innodb gmake -s Then type: sh makemysql.sh Then to install it after build type: gmake -s install You MUST have gmake installed from /usr/ports/devel/gmake to build mysql. OR just cvsup latest ports then: cd /usr/ports/databases/mysql323-server make install Ken - Original Message - From: zosen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 10:41 AM Subject: Re: Help!!!I can not make mysql on freebsd 4.3 ??? Hi!Ken Menzel I edit the file /etc/hosts,and make mysql-3.23.39.but it stopped at the below point !!help me ?!!Thanks!! - SQLD_NET_RETRY_COUNT=100 -c convert.cc c++ -DMYSQL_SERVER - DDEFAULT_MYSQL_HOME=\/usr/local/mysql\ - DDATADIR=\/date/mysql/date\- DSHAREDIR=\/usr/local/mysql/share/mysql\ - ./include -I./../regex - I. -I../include -I.. -I.-O3 -DDBUG_OFF -fno-implicit-templates - fno- exceptions -fno-rtti -DMYSQLD_NET_RETRY_COUNT=100 -c sql_parse.cc In file included from mysql_priv.h:222, from sql_parse.cc:18: sql_class.h: In method `Key::Key(Key::Keytype, const char *, Listkey_part_spec )': sql_class.h:172: Internal compiler error. sql_class.h:172: Please submit a full bug report. sql_class.h:172: See URL:http://www.gnu.org/software/gcc/bugs.html for instructions. *** Error code 1 Stop in /date/home/zosen/mysql-3.23.39/sql. *** Error code 1 Stop in /date/home/zosen/mysql-3.23.39/sql. *** Error code 1 Stop in /date/home/zosen/mysql-3.23.39. *** Error code 1 Stop in /date/home/zosen/mysql-3.23.39. DateServer# DateServer# cat /etc/hosts # $FreeBSD: src/etc/hosts,v 1.11.2.1 2000/08/18 18:29:19 ume Exp $ # # Host Database # This file should contain the addresses and aliases # for local hosts that share this file. # In the presence of the domain name service or NIS, this file may # not be consulted at all; see /etc/host.conf for the resolution order. # # 192.168.0.123 DateServer ::1 localhost localhost.my.domain myname.my.domain 127.0.0.1 localhost localhost.my.domain myname.my.domain # # Imaginary network. #10.0.0.2 myname.my.domain myname #10.0.0.3 myfriend.my.domain myfriend # # According to RFC 1918, you can use the following IP networks for # private nets which will never be connected to the Internet: # # 10.0.0.0- 10.255.255.255 # 172.16.0.0 - 172.31.255.255 # 192.168.0.0 - 192.168.255.255 # # In case you want to be able to connect to the Internet, you need # real official assigned numbers. PLEASE PLEASE PLEASE do not try # to invent your own network numbers but instead get one from your # network provider (if any) or from the Internet Registry (ftp to # rs.internic.net, directory `/templates'). # DateTest# - Original Message - From: Ken Menzel [EMAIL PROTECTED] To: zosen [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 9:54 PM Subject: Re: Help!!!I can not make mysql on freebsd 4.3 ??? What is in /etc/hosts file? My server named tuvok has this: bash-2.04$ cat /etc/hosts 127.0.0.1 localhost.icarz.com localhost 207.99.22.16tuvok.icarz.com tuvok 207.99.22.16tuvok.icarz.com. bash-2.04$ Your machine needs a name, there are examples in /etc/hosts. I would also recommend a good system administration book like: Unix System Administration Handbook from Prentice Hall, ISBN 0-13-020601-6 Ken - Original Message - From: zosen [EMAIL PROTECTED] To: Ken Menzel [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 9:30 AM Subject: Re: Help!!!I can not make mysql on freebsd 4.3 ??? Hi!Ken Menzel I try to initialize my datebase.but it output as the below.What's the matter?? DateTest# ./mysql_install_db Sorry, the host 'DateTest' could not be looked up. Please configure the 'hostname' command to return a correct hostname. If you want to solve this at a later stage, restart this script with the --force option DateTest# - Before posting, please check: http://www.mysql.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- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: backup/restore of mysql
You can use update/bin_update logs. Run these logs from the time of the last backup and it should take you DB up to date till the time in went down Simon PS update logs have all the SQL statements in them so it should be very simple to recover! -Original Message- From: Pete Kuczynski [mailto:[EMAIL PROTECTED]] Sent: 10 July 2001 16:00 To: [EMAIL PROTECTED] Subject: backup/restore of mysql Hi, I've posted this question before, and some were kind enough to respond with suggestions to my question [replication], but I'm looking for something more difinitave. Background: I'm running a production mysql database/php4/Apache on a NT4 IBM Netfinity server [3500 records, growing by 100 a day or so]. I do not have the option to go to lunux/unix [company's call not mine]. I am backing up the database twice a day, noon and 6 pm. Question: if a disk should crash, I can recover the database from the last tape backup, but not the transactions that took place in between. Is replacation of the database on another box my only option? Dosn't mysql support transaction logging like MSSQL or Oricle, or Postgres?. I don't wan't to switch to another database, but as this one grows, it's becoming incrisingly important to be able to do a complete database recovery in the event of a crash. Kindest thanks! 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: Turning off logging for certain download queries
At 03:01 PM 7/9/2001 -0700, you wrote: On Mon, Jul 09, 2001 at 03:18:14PM -0600, Chris Bolt wrote: We do a few large daily and monthly downloads from an Oracle database server. Is there a way to exclude these specific queries from the update/binary log?? If the queries only affect one table or database, use the replication ignore options listed here: http://www.mysql.com/doc/R/e/Replication_Options.html Better yet, check this page: http://www.mysql.com/doc/R/e/Replication_SQL.html And look at SET SQL_LOG_BIN=0 Does this turn off logging for everything (all other connections) or only for the current connection?? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 23 days, processed 177,648,797 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: Solaris
I'd think that someone would have to had created a 'package' for Solaris installations, BUT, you'd have to identify which version of Solaris you were using, and whether you're running it on a SPARC or Intel based system I haven't seen them on the site (you could download the source file, compile it for your system, and create your own 'package'. Instructions are on the 'sunsolve' website) - Original Message - From: Mike Jimenez [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 8:22 AM Subject: Solaris Like you have a RPM install for Linux is there something similar that I can use with Solaris to make the install simple with Mysql? Thanks Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Solaris
Okay I can understand that I need to provide more info. Im using a Ultra sparc II server with Solaris 8 also can you please provide the exact link to the sunsolve website. Thanks Mike -Original Message- From: Steve Brazill [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 9:30 AM To: Mike Jimenez; Mysql Subject: Re: Solaris I'd think that someone would have to had created a 'package' for Solaris installations, BUT, you'd have to identify which version of Solaris you were using, and whether you're running it on a SPARC or Intel based system I haven't seen them on the site (you could download the source file, compile it for your system, and create your own 'package'. Instructions are on the 'sunsolve' website) - Original Message - From: Mike Jimenez [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 8:22 AM Subject: Solaris Like you have a RPM install for Linux is there something similar that I can use with Solaris to make the install simple with Mysql? Thanks Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Join syntax
I have two databases (db1 e db2) on different hosts (host1 e host2). I put them on different hosts to split the charge (they are very big databases). However, I have to make some selects on tables of db2 filtering with information that are on db1. If db1 and db2 were at the same machine, I wouldn't have problem, because the table_reference would be db1.table1 AS t1, db2.table2 AS t2. But as they are on different machines, I didn't know the syntax of the table_reference or even if it was possible. Thanks, Rodney Werner Stuerenburg [EMAIL PROTECTED] em 10/07/2001 10:51:39 Favor responder a Werner Stuerenburg [EMAIL PROTECTED] Para:RODNEY ANTONIO RAMOS RODNEYR/Embratel@Embratel cc: [EMAIL PROTECTED] Assunto: Re: Join syntax As it seems, it is not possible. You would have to have a connection which talks to two databases at once, which may not be possible at all, at least create numerous problems. But I think it should be possible to create a temporary table in db 2 and copy the table from db1 into it, then do a join with that temporary table. Question is: what kind of an application do you have that you need such a thing? Is it possible to join two tables from different databases that are located on different hosts? -- 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: backup/restore of mysql
Very cool. Thaks very much Simon! Pete Simon Green wrote: Hi Pete To emable loffing use the --log option eg --log-update when stating the server... Simon -Original Message- From: Pete Kuczynski [mailto:[EMAIL PROTECTED]] Sent: 10 July 2001 17:51 To: Simon Green Subject: Re: backup/restore of mysql Hi, do I need to generate these logs using the my.ini file on NT. Pete Simon Green wrote: You can use update/bin_update logs. Run these logs from the time of the last backup and it should take you DB up to date till the time in went down Simon PS update logs have all the SQL statements in them so it should be very simple to recover! -Original Message- From: Pete Kuczynski [mailto:[EMAIL PROTECTED]] Sent: 10 July 2001 16:00 To: [EMAIL PROTECTED] Subject: backup/restore of mysql Hi, I've posted this question before, and some were kind enough to respond with suggestions to my question [replication], but I'm looking for something more difinitave. Background: I'm running a production mysql database/php4/Apache on a NT4 IBM Netfinity server [3500 records, growing by 100 a day or so]. I do not have the option to go to lunux/unix [company's call not mine]. I am backing up the database twice a day, noon and 6 pm. Question: if a disk should crash, I can recover the database from the last tape backup, but not the transactions that took place in between. Is replacation of the database on another box my only option? Dosn't mysql support transaction logging like MSSQL or Oricle, or Postgres?. I don't wan't to switch to another database, but as this one grows, it's becoming incrisingly important to be able to do a complete database recovery in the event of a crash. Kindest thanks! Pete -- ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 -- ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 -- ___ 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: MySQL ISP
http://www.westhost.com offers a MySQL database for only $8.95 a month. -Kinney Baughman - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
./configure errorRe: Solaris
Please,help1 [sherzod@cral mysql-3.23.39]$ ./configure loading cache ./config.cache checking host system type... i586-pc-linux-gnu checking target system type... i586-pc-linux-gnu checking build system type... i586-pc-linux-gnu checking for a BSD compatible install... /usr/bin/install -c checking whether build environment is sane... yes checking whether make sets ${MAKE}... yes checking for working aclocal... missing checking for working autoconf... missing checking for working automake... missing checking for working autoheader... missing checking for working makeinfo... found checking whether to enable maintainer-specific portions of Makefiles... no checking whether build environment is sane... yes checking whether make sets ${MAKE}... (cached) yes checking for gawk... gawk checking for gcc... gcc checking whether the C compiler (gcc ) works... yes checking whether the C compiler (gcc ) is a cross-compiler... no checking whether we are using GNU C... yes checking whether gcc accepts -g... yes checking for c++... no checking for g++... no checking for gcc... gcc checking whether the C++ compiler (gcc ) works... no configure: error: installation or configuration problem: C++ compiler cannot create executables. [sherzod@cral mysql-3.23.39]$ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Solaris
Ooops, www.sunsolve.sun.com is for 'patches' for Solaris... I meant, docs.sun.com Here's the link to the Solaris 2.5 method of package creation (you can search further for the Solaris 8 method) http://docs.sun.com/ab2/@LegacySearchResults?toc=SUNWab_42_3%3A%2Fsafedir%2F space3%2Fcoll2%2FSUNWasup%2Ftoc%2FPACKINSTALL%3APACKINSTALL%3AcloseDwebQuer y=package+OR+creationoqt=package+creationscope=BOOKAb2Lang=CAb2Enc=iso-8 859-1 - Original Message - From: Mike Jimenez [EMAIL PROTECTED] To: Steve Brazill [EMAIL PROTECTED]; Mysql [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 9:43 AM Subject: RE: Solaris Okay I can understand that I need to provide more info. Im using a Ultra sparc II server with Solaris 8 also can you please provide the exact link to the sunsolve website. Thanks Mike -Original Message- From: Steve Brazill [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 9:30 AM To: Mike Jimenez; Mysql Subject: Re: Solaris I'd think that someone would have to had created a 'package' for Solaris installations, BUT, you'd have to identify which version of Solaris you were using, and whether you're running it on a SPARC or Intel based system I haven't seen them on the site (you could download the source file, compile it for your system, and create your own 'package'. Instructions are on the 'sunsolve' website) - Original Message - From: Mike Jimenez [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 8:22 AM Subject: Solaris Like you have a RPM install for Linux is there something similar that I can use with Solaris to make the install simple with Mysql? Thanks Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Solaris
hi. www.sunfreeware.com has a sun package that can be added via the pkgadd utility. hth. -ravi. -Original Message- From: Mike Jimenez [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 12:44 PM To: Steve Brazill; Mysql Subject: RE: Solaris Okay I can understand that I need to provide more info. Im using a Ultra sparc II server with Solaris 8 also can you please provide the exact link to the sunsolve website. Thanks Mike -Original Message- From: Steve Brazill [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 9:30 AM To: Mike Jimenez; Mysql Subject: Re: Solaris I'd think that someone would have to had created a 'package' for Solaris installations, BUT, you'd have to identify which version of Solaris you were using, and whether you're running it on a SPARC or Intel based system I haven't seen them on the site (you could download the source file, compile it for your system, and create your own 'package'. Instructions are on the 'sunsolve' website) - Original Message - From: Mike Jimenez [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 8:22 AM Subject: Solaris Like you have a RPM install for Linux is there something similar that I can use with Solaris to make the install simple with Mysql? Thanks Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: out of memory
On Mon, Jul 09, 2001 at 08:14:24PM -0600, David Keeney wrote: dies (during the execute statement) with the error : Out of Memory: Killed process 31666 (temp.pl). Killed Look for 'SQL_BIG_TABLES' in the Docs... `SQL_BIG_TABLES = 0 | 1' If set to `1', all temporary tables are stored on disk rather than in memory. This will be a little slower, but you will not get the error `The table tbl_name is full' for big `SELECT' operations that require a large temporary table. The default value for a new connection is `0' (i.e., use in-memory temporary tables). -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 on cross table Query
On 2001 Jul 10, Yan Zhang [EMAIL PROTECTED] wrote: Please help me here, and let me know if MySQL can do it or not. All people around me told it should work in SyBASE. Please don't spam! Use *one* e-mail address that is appropriate. This is on our list of things to do, probably in version 4.1. Tim -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Tim Smith [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-time Developer /_/ /_/\_, /___/\___\_\___/ Boone, NC USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Solaris
Just checked the site, and only see version 3.22.26a (very old) on the site... - Original Message - From: Ravi Raman [EMAIL PROTECTED] To: Mike Jimenez [EMAIL PROTECTED]; Steve Brazill [EMAIL PROTECTED]; Mysql [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 10:24 AM Subject: RE: Solaris hi. www.sunfreeware.com has a sun package that can be added via the pkgadd utility. hth. -ravi. -Original Message- From: Mike Jimenez [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 12:44 PM To: Steve Brazill; Mysql Subject: RE: Solaris Okay I can understand that I need to provide more info. Im using a Ultra sparc II server with Solaris 8 also can you please provide the exact link to the sunsolve website. Thanks Mike -Original Message- From: Steve Brazill [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 9:30 AM To: Mike Jimenez; Mysql Subject: Re: Solaris I'd think that someone would have to had created a 'package' for Solaris installations, BUT, you'd have to identify which version of Solaris you were using, and whether you're running it on a SPARC or Intel based system I haven't seen them on the site (you could download the source file, compile it for your system, and create your own 'package'. Instructions are on the 'sunsolve' website) - Original Message - From: Mike Jimenez [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 8:22 AM Subject: Solaris Like you have a RPM install for Linux is there something similar that I can use with Solaris to make the install simple with Mysql? Thanks Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Accesses
Just wondering how many accesses can MYSQL handle... let's say per hour. I have about 500 accesses per hour, 8 clicks per second... does anyone know about this issue? thanks _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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: Turning off logging for certain download queries
Jeremy, I did test it and couldn't get it to work one way or the otherHowever, as it turns out, the '--binlog-ignore-db' option will work for me. Thanks for all your help!! Phil At 11:03 AM 7/10/2001 -0700, you wrote: On Tue, Jul 10, 2001 at 09:20:35AM -0700, Philip Daggett wrote: At 03:01 PM 7/9/2001 -0700, you wrote: On Mon, Jul 09, 2001 at 03:18:14PM -0600, Chris Bolt wrote: We do a few large daily and monthly downloads from an Oracle database server. Is there a way to exclude these specific queries from the update/binary log?? If the queries only affect one table or database, use the replication ignore options listed here: http://www.mysql.com/doc/R/e/Replication_Options.html Better yet, check this page: http://www.mysql.com/doc/R/e/Replication_SQL.html And look at SET SQL_LOG_BIN=0 Does this turn off logging for everything (all other connections) or only for the current connection?? Hmm. Good point. I hadn't thought about that. And the manual doesn't say one way or the other, so I assume it's a global setting. This might not be what you want aferall. But it would be useful to be able to do this on a per connection basis. Perhaps some testing is in order. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 24 days, processed 183,699,039 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: Solaris
Yeah I seen that too. It would be nice if it was the latest version. Mike -Original Message- From: Steve Brazill [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 10:47 AM To: Ravi Raman; Mike Jimenez; Mysql Subject: Re: Solaris Just checked the site, and only see version 3.22.26a (very old) on the site... - Original Message - From: Ravi Raman [EMAIL PROTECTED] To: Mike Jimenez [EMAIL PROTECTED]; Steve Brazill [EMAIL PROTECTED]; Mysql [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 10:24 AM Subject: RE: Solaris hi. www.sunfreeware.com has a sun package that can be added via the pkgadd utility. hth. -ravi. -Original Message- From: Mike Jimenez [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 12:44 PM To: Steve Brazill; Mysql Subject: RE: Solaris Okay I can understand that I need to provide more info. Im using a Ultra sparc II server with Solaris 8 also can you please provide the exact link to the sunsolve website. Thanks Mike -Original Message- From: Steve Brazill [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 9:30 AM To: Mike Jimenez; Mysql Subject: Re: Solaris I'd think that someone would have to had created a 'package' for Solaris installations, BUT, you'd have to identify which version of Solaris you were using, and whether you're running it on a SPARC or Intel based system I haven't seen them on the site (you could download the source file, compile it for your system, and create your own 'package'. Instructions are on the 'sunsolve' website) - Original Message - From: Mike Jimenez [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 8:22 AM Subject: Solaris Like you have a RPM install for Linux is there something similar that I can use with Solaris to make the install simple with Mysql? Thanks Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Accesses
Just wondering how many accesses can MYSQL handle... let's say per hour. I have about 500 accesses per hour, 8 clicks per second... does anyone know about this issue? thanks I just did picard:/usr/local/mysql/bin# mysqladmin version -upferdezeitung -p Enter password: mysqladmin Ver 8.15 Distrib 3.23.33, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.33 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 5 days 8 hours 31 min 23 sec Threads: 23 Questions: 14877669 Slow queries: 793 Opens: 17632 Flush tables: 1 Open tables: 64 Queries per second avg: 32.155 -- 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: ./configure errorRe: Solaris
Make sure gcc is in your PATH, and make sure it's been installed properly. You might also want to try some test compilations. -- Alan W. Rateliff, II: YourVillage.com Assistant Systems Administrator : 2700 Apalachee Pkwy [EMAIL PROTECTED] : Tallahassee, FL 32301 (850) 942-7021--- [EMAIL PROTECTED] http://support.yourvillage.com - Original Message - From: sherzod ruzmetov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Mysql [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 1:17 PM Subject: ./configure errorRe: Solaris Please,help1 [sherzod@cral mysql-3.23.39]$ ./configure loading cache ./config.cache checking host system type... i586-pc-linux-gnu checking target system type... i586-pc-linux-gnu checking build system type... i586-pc-linux-gnu checking for a BSD compatible install... /usr/bin/install -c checking whether build environment is sane... yes checking whether make sets ${MAKE}... yes checking for working aclocal... missing checking for working autoconf... missing checking for working automake... missing checking for working autoheader... missing checking for working makeinfo... found checking whether to enable maintainer-specific portions of Makefiles... no checking whether build environment is sane... yes checking whether make sets ${MAKE}... (cached) yes checking for gawk... gawk checking for gcc... gcc checking whether the C compiler (gcc ) works... yes checking whether the C compiler (gcc ) is a cross-compiler... no checking whether we are using GNU C... yes checking whether gcc accepts -g... yes checking for c++... no checking for g++... no checking for gcc... gcc checking whether the C++ compiler (gcc ) works... no configure: error: installation or configuration problem: C++ compiler cannot create executables. [sherzod@cral mysql-3.23.39]$ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Security
Hi all, This may not directly related to the topic but I think people in this list may able to give me some ideas. I am not really kean of security issue and would like to ask the following questions: I have 2 win2k pcs one directly connected to internet (say PC A) and PC B is connected with PC A as localnet work. Then, I have webserver and DSN to MySQL on PC A and MySQL on PC B. 1) If MySQL is bind to localhost only ( i.e. default setup with root account and my new password ), then would it be secure enough since the only access point is from PC A??? 2) Any pre-caution I should take in order to prevent illegal access to MySQL through PC A ?? Thank you very much. Best regards, Michael
unix_timestamp doesn't understand year 2038
Description: unix_timestamp doesn't understand year 2038. How-To-Repeat: this works: select unix_timestamp(2037-12-31 23:59:59); this doesn't: select unix_timestamp(2038-01-01 00:00:00); Fix: unknown. everything through Jan 19 03:14:07 2038 GMT should be valid. Submitter-Id: submitter ID Originator:Theo Van Dinter Organization: Kluge.Net - WWW Access and Internet Education Network MySQL support: [none | licence | email support | extended email support ] Synopsis: unix_timestamp not handling year 2038 Severity: non-critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.39 (Official MySQL RPM) Environment: System: Linux eclectic 2.2.19 #1 Mon Apr 9 15:10:02 EDT 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='egcs' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='egcs' CXXFLAGS='-O6 -fno-omit-frame-pointer-felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Oct 6 2000 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x 1 root root 4101836 Jan 15 10:49 /lib/libc-2.1.3.so -rw-r--r-- 1 root root 20273324 Jan 15 10:49 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Jan 15 10:49 /usr/lib/libc.so lrwxrwxrwx 1 root root 10 Nov 17 2000 /usr/lib/libc-client.a - c-client.a Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --without-innodb --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' Perl: This is perl, version 5.005_03 built for i386-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: unix_timestamp doesn't understand year 2038
it not a bug, it is a feature, complain to Tomas Riche, 68 years (2038-1970) is all the seconds that fit in 2^31 or a signed long number, which is how the timestamp was defined a long time ago, it was always figured that some would change the base year sooner or later. Or the programmer view ;-) that I will be retired by then so it will be the next person problem, or better yet The software will last that long ha ha ha :-). I subspect someone with refine it to a 64 bit number one of these days. But this is not a bug. MJM - Original Message - From: Theo Van Dinter [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, July 10, 2001 3:59 PM Subject: unix_timestamp doesn't understand year 2038 Description: unix_timestamp doesn't understand year 2038. How-To-Repeat: this works: select unix_timestamp(2037-12-31 23:59:59); this doesn't: select unix_timestamp(2038-01-01 00:00:00); Fix: unknown. everything through Jan 19 03:14:07 2038 GMT should be valid. Submitter-Id: submitter ID Originator: Theo Van Dinter Organization: Kluge.Net - WWW Access and Internet Education Network MySQL support: [none | licence | email support | extended email support ] Synopsis: unix_timestamp not handling year 2038 Severity: non-critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.39 (Official MySQL RPM) Environment: System: Linux eclectic 2.2.19 #1 Mon Apr 9 15:10:02 EDT 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='egcs' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='egcs' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-ex ceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Oct 6 2000 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x 1 root root 4101836 Jan 15 10:49 /lib/libc-2.1.3.so -rw-r--r-- 1 root root 20273324 Jan 15 10:49 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Jan 15 10:49 /usr/lib/libc.so lrwxrwxrwx 1 root root 10 Nov 17 2000 /usr/lib/libc-client.a - c-client.a Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-clien t-ldflags=-all-static --without-berkeley-db --without-innodb --enable-assemb ler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.so ck --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir= /usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/my sql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' Perl: This is perl, version 5.005_03 built for i386-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
How Long is TEXT?
Hi, after reading the excellent docs, I was just a little confused as to the actual length of the TEXT datatypes. Are they really as long as you like? And does anyone have any tips for indexing (searching) them? Thanks, James Cox . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . James Cox :: Creative Director :: AWP imaJes t: +44 (0)7968 349990 | f: +44 (0)1992 300939 e: [EMAIL PROTECTED] w: http://www.awpimajes.com/ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Re: unix_timestamp doesn't understand year 2038
On Tue, Jul 10, 2001 at 04:15:03PM -0400, Michael Meltzer wrote: it not a bug, it is a feature, complain to Tomas Riche, 68 years (2038-1970) is all the seconds that fit in 2^31 or a signed long number, which is how the timestamp was defined a long time ago, it was always figured that some would change the base year sooner or later. Or the programmer view ;-) that I will be retired by then so it will be the next person problem, or better yet The software will last that long ha ha ha :-). I subspect someone with refine it to a 64 bit number one of these days. But this is not a bug. So it's not a bug that there are ~19 days in 2038 that MySQL (via unix_timestamp) can't handle? I understand that 2^31 seconds after 1970 runs out in 2038 -- that's actually how I found this bug. A countdown program I wrote determines how long until a given event. In real life, 2^31 (0x7fff) seconds is: January 19 2038 at 03:14:07 GMT Which means that (in GMT) there is 19 days, 3 hours, 14 minutes, and 8 seconds that MySQL can't deal with. By definition, that's a bug in MySQL, not the definition of time_t being a signed 32-bit value. -- Randomly Generated Tagline: To the engineer, the world is a toy box full of sub-optimized and feature-poor toys.- Scott Adams - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Many Databases with Few Tables or Few Databases with Many Tables???
You connect to a database and then issue your queries. So you should hold all tables within one database that will be addresses within one query. Besides this, it is a matter of taste. Think of it this way: will it affect performance if you put 1000 files in a directory or just two of them and allocate more directories instead? Personally, I don't see any reason to set up more than one database. I have some 100+ tables now. As long as I see what things are and mean, I have no problem. Sie schrieben am Dienstag, 10. Juli 2001, 22:07:25: Hey all, This seems like a silly, but rather fundamental question. Should I have many databases running inside one instance of Mysql with fewer tables in each, or should have only a few databases with many tables in each (one to many or many to one, more or less) Does is matter if the tables don't really relate in any way??? Since I've never quite had this perspective -- 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: String Size Limit?
Most likely your size limitation is comming from the data type used for 'notes'. Check out the documentation for the size of the text types, mediumtext may be more apropriate for you. ryan I'm running into an odd string size limitation. I've traced it down as far as I can get, and I didn't run across anything in the docs or on any searches I've run so I figured I'd try here. The field in the database is a TEXT type column. I'm appending to the front of the text field each time using: UPDATE field SET notes=CONCAT(newtext,notes) WHERE ... However the field is cutting off after 4096 bytes. With a hunch that CONCAT may have been causing the limit, I switched to doing the concatenation inside of the application and setting the full field. The same cut-off occurs in storage, however the SQL executes correctly so it's not like the query is getting cut off and not seeing the WHERE clause. Seeing as this happens in CONCAT which should be server side I suspect I'm running into a server-side limitation. My app is PHP3 over IIS on NT4.0 using MyODBC 2.50.3300 to a Linux Server running MySQL 3.22.32 precompiled (when you get 100 day 24/7 uptime no problem you don't upgrade!). What incredibly obvious piece of documentation am I missing, is this a you need to upgrade thing, or what would be a reasonable work-around in this rather abstracted environment? Thanks, Sean - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Perl DBI to MySQL -- Passing info to query
I was not aware of placeholders, and the benifits of using them instead of using $dbh-quote(). It doesnt make sence that the DBI version of quote isnt as thorough as having the code behind placeholding do it. But anyhow, I have a few questions as to how this works. Here is an example from the Perl DBH::mysql docs: my @names = ['Flaherty', 'Jones', 'Smith']; my $sth = $dbh-prepare(UPDATE contact SET phone = '555-1212' WHERE last_name = ?); $sth-execute(@names); $sth-finish; So most likely this query will return 3 rows, each corresponding to the last names contained in the array. Does this mean you can not use more than one place holder per query? What if the 'WHERE' statement was WHERE last_name = ? AND first_name = ?. So you do an execute like this: $sth-execute(@lnames,@fnames) ... This would not work because as far as the execute function is concerned, these two arrays are the same (if you want to pass them as seperate arguments you must pass references rather than the object itself). Anyhow one how placeholders for multiple variables can be used? Thanks. ryan r Seems that you are not taking advantage of Perl. This is what you can do: No, he is taking advantage of placeholders. It is much better to use placeholder for value substitution that substitute values directly into query with Perl because there is no need to escape values (do you know that $dbh-quote doesn't quote reliably?) and $sth can be reused for simular queries (which can give perfomance gain on some SQL databases). However usually placeholders can be used only for value substitutuion. 'DESC' cannot be substituted since it is a part of query. r $parentid = x; r $orderby = 'DESC'; rmy $sth = $dbh - prepare (qq{ r SELECT message.name, contents, user.name, message.id r FROM message, user r WHERE folder='N' and parentid=$parentid r GROUP BY message.id r ORDER BY time $orderby r }) || die $dbh-errstr; r You can put any variable inside the string... Note that I changed the q{ r ... } to qq{ ... } r $string = q{ string } is the same as $string = 'string'; r $string = qq{ string } is the same as $string = string; r Note that variables inside of strings enclosed by '' will not be translated, r only strings enclosed by (or qq{} =) ). -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- | Ilya Martynov (http://martynov.org/) | | GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB 323B DEE6 | | AGAVA Software Company (http://www.agava.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: How Long is TEXT?
after reading the excellent docs, I was just a little confused as to the actual length of the TEXT datatypes. Are they really as long as you like? See http://www.mysql.com/doc/n/o/node_180.html And does anyone have any tips for indexing (searching) them? What do you mean? Searching is something different than indexing. You may be interested in the FULLTEXT clause. See http://www.mysql.com/doc/F/u/Fulltext_Search.html and follwing for details. -- 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
data corruption
I was updating a database and my database got corrupted ( I'm not sure what coused this) but ever since then I have been having lots of mysql problems. The onl way I can stop mysql is by doing a kill, mysqld stop fails. I was able to restore to a backed up database but now I can not add new items. The way I restored the database was by coping over the MYD, frm and MYI files, not sure if that was the right way to do that. Does anyone know how I can fix this? I am not sure which version of mysql I'm running its the version that cam with redhat 7.1. Ransom #!/usr/bin/perl -w # 531-byte qrpff-fast, Keith Winstein and Marc Horowitz [EMAIL PROTECTED] # MPEG 2 PS VOB file on stdin - descrambled output on stdout # arguments: title key bytes in least to most-significant order $_='while(read+STDIN,$_,2048){$a=29;$b=73;$c=142;$t=255;@t=map{$_%16or$t^=$c^=( $m=(11,10,116,100,11,122,20,100)[$_/16%8])110;$t^=(72,@z=(64,72,$a^=12*($_%16 -2?0:$m17)),$b^=$_%64?12:0,@z)[$_%8]}(16..271);if((@a=unxC*,$_)[20]48){$h =5;$_=unxb24,join,@b=map{xB8,unxb8,chr($_^$a[--$h+84])}@ARGV;s/...$/1$/;$ d=unxV,xb25,$_;$e=256|(ord$b[4])9|ord$b[3];$d=$d8^($f=$t($d12^$d4^ $d^$d/8))17,$e=$e8^($t($g=($q=$e147^$e)^$q*8^$q6))9,$_=$t[$_]^ (($h=8)+=$f+(~$g$t))for@a[128..$#a]}print+xC*,@a}';s/x/pack+/g;eval - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Solaris
I understand completely and Mysql is not a database, Its a database server that I already have multiple servers running. I asked this question because I was curious to know if a package for Solaris exist like one Does for Linux. If you are just going to be sarcastic to people who ask questions on the list like they are suppose to then maybe you should un-subscribe. Mike -Original Message- From: Laurent Oget [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 10, 2001 1:38 PM To: Mike Jimenez Subject: Re: Solaris On Tue, Jul 10, 2001 at 08:22:53AM -0700, Mike Jimenez wrote: Like you have a RPM install for Linux is there something similar that I can use with Solaris to make the install simple with Mysql? Thanks Mike mysql is a database, not an end user desktop software. If you can not compile and install it, you will not be able to use it. there are many consultants who can do that for you in a couple of hours, and if you do not have the skills to install mysql you will need a consultant when/if you have to recover mysql from a hardware crash anyway. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Join syntax
This topic really interested me. Can an expert of the list explain a good approach handle distributed system with distributed databases? thanks siomara From: [EMAIL PROTECTED] To: Werner Stuerenburg [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Join syntax Date: Tue, 10 Jul 2001 13:57:37 -0300 I have two databases (db1 e db2) on different hosts (host1 e host2). I put them on different hosts to split the charge (they are very big databases). However, I have to make some selects on tables of db2 filtering with information that are on db1. If db1 and db2 were at the same machine, I wouldn't have problem, because the table_reference would be db1.table1 AS t1, db2.table2 AS t2. But as they are on different machines, I didn't know the syntax of the table_reference or even if it was possible. Thanks, Rodney Werner Stuerenburg [EMAIL PROTECTED] em 10/07/2001 10:51:39 Favor responder a Werner Stuerenburg [EMAIL PROTECTED] Para:RODNEY ANTONIO RAMOS RODNEYR/Embratel@Embratel cc: [EMAIL PROTECTED] Assunto: Re: Join syntax As it seems, it is not possible. You would have to have a connection which talks to two databases at once, which may not be possible at all, at least create numerous problems. But I think it should be possible to create a temporary table in db 2 and copy the table from db1 into it, then do a join with that temporary table. Question is: what kind of an application do you have that you need such a thing? Is it possible to join two tables from different databases that are located on different hosts? -- 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 _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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
Msql-Mysql-modules-1.2216 and gcc-2.95.3 and SCO OSR 5
To whom it may concern: Every thing makes, but when I do a make test I get ... $/usr/local/bin/make test install_driver(mysql) failed: Can't load '../blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql: dynamic linker: /usr/bin/perl: relocation error: symbol not found: __deregister_frame_info at /usr/lib/perl5/5.6.0/i486-pc-sco3.2v5.0/DynaLoader.pm line 200. at (eval 1) line 3 Compilation failed in require at (eval 1) line 3. Perhaps a required shared library or dll isn't installed where expected at t/00base.t line 38 Is there some flag I missed when using gcc that will give me the symbol __deregister_frame_info or remove it so I do not get the error? Thanks, -- 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
good backup and maintain scripts
Title: Blank Any body got any good through nightly maintenance and back-up scripts? Wyly Wade Forefront Inc 1413 S. Howard Ave Suite 104 Tampa Fl, 33606 813-253-2267
Re: good backup and maintain scripts
I'd like to see some that check current tables for corruption before exporting, and then naming the exports by date... On Tuesday, July 10, 2001, at 06:18 PM, Wyly Wade wrote: Any body got any good through nightly maintenance and back-up scripts? Wyly Wade Forefront Inc 1413 S. Howard Ave Suite 104 Tampa Fl, 33606 813-253-2267
MySQL for holding User opinions
Hi right now I am just developeing a complex listing for 500+ applications over 20 tables per catigory, that is going to be hosted on my site. besides having the normal info such as: size, file name, datep ublished, staff comments, program rateing I wanted to include user opinions of it too. My first quick thought was to continue adding fields in the table for the user opinion but then I realized what a massivly bad thing to search through 5-10 fields of about 50-300 charecters for all of the 500+ programs ouch. Then it occured to me just to make 20 new sepret table just for comments for all 20 catigorys. then when the user posted a comment, it would just be put into the comment table listed by the unique id given each application so all I would have to search for is the id and get all the comments. I was just woundering if there was a better way to do it then the thought I have above? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: indexing
I have seen a lot of question and issues around index size and time on this list lately. Well you should increase your Key Buffer but Roger your record size is about 12k per row Pawan your record size is an enormous 91k per row You have to remember that RDBMS(for transaction processing) work best when normalizing data down to allow for simple small per-row data transactions. So I would work on normalizing the data down into tables that average about 4 to 5k per row returned on a SELECT * at most 8k Never Index on text, blob, and if you can help it don't use var char in indexes. While I do agree with Jo and I think you should increase your Key Buffer that is just a temporay fix. I would improve the architecture of your database first. Also it is always best to create all the all the indexes that you think you might need on a table before you put the data in. It only takes a few seconds to drop an index if you realize you do not need it afterward. Wyly Wade Forefront Inc 1413 S. Howard Ave Suite 104 Tampa Fl, 33606 813-253-2267 -Original Message- From: Joseph Bueno [mailto:[EMAIL PROTECTED]] Sent: Friday, July 06, 2001 3:47 AM To: Roger Ramirez Cc: [EMAIL PROTECTED] Subject: Re: indexing Roger Ramirez wrote: Hi, I'm using MySQL 3.23.39 under Red Hat 7.1 on a Pentium III 600mhz with 640MB of Ram. I only 1 table in a database with 5.6 million records and I'm currently trying to index a varchar(100) field. I started the query alter table mytable add index myfield (myfield) at 10am EST this morning and 5:45 hours later its still running. If I look in my mysql/var directory I have the following. -rw-rw1 root root Jul 5 09:44 mytable.frm -rw-rw1 root root 689493112 Jul 5 09:58 mytable.MYD -rw-rw1 root root 114336768 Jul 5 09:58 mytable.MYI -rw-rw1 root root Jul 5 09:59 #sql-312_9.frm -rw-rw1 root root 616317108 Jul 5 11:21 #sql-312_9.MYD -rw-rw1 root root 136826880 Jul 5 14:30 #sql-312_9.MYI The very last file #sql-312_9.MYI has been growing at a rate of about 40-50MB/hour. Is there any way for me to tell how much longer this will go on? I did a couple of indexes on two other fields in this table the day before yesterday but I issued the commands and walked away from the computer. It was a rough day so i don't remember how long it took. The other two fields are varchar(5) and varchar(10) and I know for a fact that it didn't take more then 24 hours, and I'm pretty sure it was less than 6 hours. Thanks, Roger Ramirez - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Hi, Check your key_buffer_size parameter and try to make it as big as you can, for best performance it should be big enough to hold a copy of all your indexes. If your machine is dedicated to mysql, I would suggest key_buffer_size=256M. Regards -- Joseph Bueno NetClub/Trader.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: Altering tables
alter table hr-data set column Reason4leaving1 char(100) I thought I knew - but I wanted to play safe. So I went to http://mysql.com and entered alter table to the search box. From the results list I chose ALTER TABLE Syntax: http://www.mysql.com/doc/A/L/ALTER_TABLE.html Here I found what I remembered: If you want to change a column's type but not the name, CHANGE syntax still requires two column names even if they are the same. For example: mysql ALTER TABLE t1 CHANGE b b BIGINT NOT NULL; So: you have to repeat the column name! -- 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: MySQL for holding User opinions
What you described is the strategy to design good tables, called normalizing. You will find good articles on that subject and even whole books. There are several rules, but most only apply the first. The others are for the real masters or the real tough data models or performance questions. Sie schrieben am Mittwoch, 11. Juli 2001, 00:32:30: Hi right now I am just developeing a complex listing for 500+ applications over 20 tables per catigory, that is going to be hosted on my site. besides having the normal info such as: size, file name, datep ublished, staff comments, program rateing I wanted to include user opinions of it too. My first quick thought was to continue adding fields in the table for the user opinion but then I realized what a massivly bad thing to search through 5-10 fields of about 50-300 charecters for all of the 500+ programs ouch. Then it occured to me just to make 20 new sepret table just for comments for all 20 catigorys. then when the user posted a comment, it would just be put into the comment table listed by the unique id given each application so all I would have to search for is the id and get all the comments. I was just woundering if there was a better way to do it then the thought I have above? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- 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: Comress table
Hi, I want to compress my tables but I gets an error: C:\mysql-data\dtim9tmyisampack wi_abbreviation.MYI Compressing wi_abbreviation.MYD: (7221 records) - Calculating statistics - Compressing file myisampack: Error on delete of 'wi_abbreviation.MYD' (Errcode: 13) Aborting: wi_abbreviation.MYD is not compressed C:\mysql-data\dtim9t' How can I solve this? 13 is permission denied. In a command prompt, run net stop mysql before you use myisampack, then run net start mysql when you're done. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Accesses
Just wondering how many accesses can MYSQL handle... let's say per hour. I have about 500 accesses per hour, 8 clicks per second... does anyone know about this issue? thanks It really depends on what kind of queries you're running, your hardware, your configuration, your operating system, etc. The most I've seen so far is Jeremy's box which is doing 87 queries per second, and my busiest box is currently at 60 queries per second with a system load of 0.69 (and I can't see any queries in a processlist so they're all running quickly). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Accesses
On 10-Jul-01 Chris K wrote: Just wondering how many accesses can MYSQL handle... let's say per hour. I have about 500 accesses per hour, 8 clicks per second... does anyone know about this issue? thanks One of my advert sites runs about 12,000 hits in 10 minutes, each hit is 4 queries (2 select, + 2 insert). 12,000 x 4 x 6 = 288000/hour or 80/sec. MySQL 3.22.32, Linux 2.2.7 SMP 2x PII-750Mhz Dual SCSI-Wide 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
Php/MySQL Parse Error
Group; There is something missing in my understanding of the php mysql_connect statement because I am getting a parse error as follows: http://cxkop.com/Jobs/job_list.php Parse error: parse error in /home/virtual/cxkop1365/home/httpd/html/Jobs/job_list.php on line 31 The database exists and is populated. I am doing the Devshed tutorial jobs: http://www.devshed.com/Server_Side/MySQL/PerfectJob/page5.html The example code is thus: // $connection = mysql_connect($hostname, $user, $pass) or die (Unable to connect!); My attempts are: (this is line 31, line 30 is commented out above) $connection = mysql_connect($cxkop@localhost, $cxkop, $!@@!) or die (Unable to connect!); I have tried several different hostnames and tried the password with ' pw ' because it is encrypted in the GRANT tables. I have searched archives for a clue, but there are 1000's of parse error questions, mostly dealing with code typo's, the code I'm using is almost completely unmodified from the devshed example, save the hostname, username, and password. What is crazy is if I comment out my modified mysql_connect statement and use the example one, the page displays, and just says that it can't open the db, which is understandable because there is no username/password in the example code. Help, and thanks Joe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: good backup and maintain scripts
On 10-Jul-01 Jason Ziegler wrote: I'd like to see some that check current tables for corruption before exporting, and then naming the exports by date... DBS=genldgr ap ar corp misc DUMP=$HOME/archive/dump cd $DUMP DIR=`date | cut -d -f1` mkdir -p $DIR rm -f Today ln -sf $DIR Today cd $DIR for K in $DBS do TBLS=`mysql -N -e show tables $K` for I in $TBLS do mysql -e repair table $I $K mysqldump -q --add-drop-table $K $I $K.$I.dmp rm -rf $K.$I.dmp.gz gzip $K.$I.dmp done done 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: Php/MySQL Parse Error
Joe, Are you assigning your database variables within the config.php file or directly into the mysql_connet(...); config.php: // database parameters // alter this as per your configuration $database=database_name; $user = username; $pass = password; $hostname = localhost; On Tue, 10 Jul 2001 17:33:10 -0700, Joe Taraba [EMAIL PROTECTED] wrote: There is something missing in my understanding of the php mysql_connect statement because I am getting a parse error as follows: http://cxkop.com/Jobs/job_list.php Parse error: parse error in /home/virtual/cxkop1365/home/httpd/html/Jobs/job_list.php on line 31 The database exists and is populated. I am doing the Devshed tutorial jobs: http://www.devshed.com/Server_Side/MySQL/PerfectJob/page5.html The example code is thus: // $connection = mysql_connect($hostname, $user, $pass) or die (Unable to connect!); My attempts are: (this is line 31, line 30 is commented out above) $connection = mysql_connect($cxkop@localhost, $cxkop, $!@@!) or die Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Php/MySQL Parse Error
Group; There is something missing in my understanding of the php mysql_connect statement because I am getting a parse error as follows: http://cxkop.com/Jobs/job_list.php Parse error: parse error in /home/virtual/cxkop1365/home/httpd/html/Jobs/job_list.php on line 31 This is a php problem, not a mysql one. The database exists and is populated. I am doing the Devshed tutorial jobs: http://www.devshed.com/Server_Side/MySQL/PerfectJob/page5.html The example code is thus: // $connection = mysql_connect($hostname, $user, $pass) or die (Unable to connect!); My attempts are: (this is line 31, line 30 is commented out above) $connection = mysql_connect($cxkop@localhost, $cxkop, $!@@!) or die (Unable to connect!); The first parameter is a hostname, not a username@hostname; just use localhost. You must also quote localhost: $connection = mysql_connect(localhost, $cxkop, $!@@!) or die (Unable to connect!); - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Php/MySQL Parse Error
At 05:48 PM 07/10/2001 , you wrote: Joe, Are you assigning your database variables within the config.php file or directly into the mysql_connet(...); config.php: // database parameters // alter this as per your configuration $database=database_name; $user = username; $pass = password; $hostname = localhost; Thanks a MILLION!! That's the part I missed, the config.php. So that's what that file is for, and that's why the page displayed when I didn't fool around with the mysql_connect statement in job_list.php. Tutorials are great, but, sometimes they miss the finer points (or I can't read TF#@$#%$#) I know this wasn't a strictly MySQL question, but, for web hosting MySQL is kind'a useless without some kind of web interface, and there are a lot of Perl coding questions on this list. And thanks to Aaron, however, the server and MySQL logs didn't yield a clue--it's the config.php which apparently gets read first--if there is one, I guess?? Now one last question, the password is encrypted thru the GRANT statement in the MySQL database, does it need to be enclosed between double apostrophes inside the double quotes? I imagine, I'd eventually figure that out after some more trial and error--but hey, if you don't mind??? Joe On Tue, 10 Jul 2001 17:33:10 -0700, Joe Taraba [EMAIL PROTECTED] wrote: There is something missing in my understanding of the php mysql_connect statement because I am getting a parse error as follows: http://cxkop.com/Jobs/job_list.php Parse error: parse error in /home/virtual/cxkop1365/home/httpd/html/Jobs/job_list.php on line 31 The database exists and is populated. I am doing the Devshed tutorial jobs: http://www.devshed.com/Server_Side/MySQL/PerfectJob/page5.html The example code is thus: // $connection = mysql_connect($hostname, $user, $pass) or die (Unable to connect!); My attempts are: (this is line 31, line 30 is commented out above) $connection = mysql_connect($cxkop@localhost, $cxkop, $!@@!) or die Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Php/MySQL Parse Error
That's the way should be, never enter your database access info directly into any type of script, be it PHP or Perl or what ever, store it in a separate file, no accessible separate file, then have the related script(s) call up the variables thru the PHP's include, or Perl's 'require' or 'use' ... or something to that effect! :) At 05:48 PM 07/10/2001 , you wrote: Joe, Are you assigning your database variables within the config.php file or directly into the mysql_connet(...); config.php: // database parameters // alter this as per your configuration $database=database_name; $user = username; $pass = password; $hostname = localhost; Thanks a MILLION!! Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Referential Integrity
MySQL does not support RI, anyone has good suggestion that do this in the program ? As this would be a nightmare if I have 50 detail tables to update programmatically. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Perl DBI to MySQL -- Passing info to query
That would not be true. You'd receive a message stating that you had one placeholder, but you were passing 3 arugments, and it script would die on the error. havoc ryc wrote: I was not aware of placeholders, and the benifits of using them instead of using $dbh-quote(). It doesnt make sence that the DBI version of quote isnt as thorough as having the code behind placeholding do it. But anyhow, I have a few questions as to how this works. Here is an example from the Perl DBH::mysql docs: my @names = ['Flaherty', 'Jones', 'Smith']; my $sth = $dbh-prepare(UPDATE contact SET phone = '555-1212' WHERE last_name = ?); $sth-execute(@names); $sth-finish; So most likely this query will return 3 rows, each corresponding to the last names contained in the array. Does this mean you can not use more than one place holder per query? What if the 'WHERE' statement was WHERE last_name = ? AND first_name = ?. So you do an execute like this: $sth-execute(@lnames,@fnames) ... This would not work because as far as the execute function is concerned, these two arrays are the same (if you want to pass them as seperate arguments you must pass references rather than the object itself). Anyhow one how placeholders for multiple variables can be used? Thanks. ryan r Seems that you are not taking advantage of Perl. This is what you can do: No, he is taking advantage of placeholders. It is much better to use placeholder for value substitution that substitute values directly into query with Perl because there is no need to escape values (do you know that $dbh-quote doesn't quote reliably?) and $sth can be reused for simular queries (which can give perfomance gain on some SQL databases). However usually placeholders can be used only for value substitutuion. 'DESC' cannot be substituted since it is a part of query. r $parentid = x; r $orderby = 'DESC'; rmy $sth = $dbh - prepare (qq{ r SELECT message.name, contents, user.name, message.id r FROM message, user r WHERE folder='N' and parentid=$parentid r GROUP BY message.id r ORDER BY time $orderby r }) || die $dbh-errstr; r You can put any variable inside the string... Note that I changed the q{ r ... } to qq{ ... } r $string = q{ string } is the same as $string = 'string'; r $string = qq{ string } is the same as $string = string; r Note that variables inside of strings enclosed by '' will not be translated, r only strings enclosed by (or qq{} =) ). -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- | Ilya Martynov (http://martynov.org/) | | GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB 323B DEE6 | | AGAVA Software Company (http://www.agava.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 -- *===| http://bigpig.org/ *===| *===| It's about Freedom! | - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Delete ... where col not in (select...)
Is there a way to build a similar SQL that would work on mySql (I use this on Oracle): delete from TABLE_NAME where COL1 not in ( select distinct COL1 from TABLE_NAME where COL2 ='SOMETHING') - Regards, Rod~ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php