RE: Not working mysql in win2000 Prof.
The message you are getting indicates that it cannot find the executable file. You are getting this because you are not putting a space between the executable name mysqld and your command-line option --standalone. Unless you have some reason to not want to run mysql as a service, I reccommend using the mysqladmin program. -Original Message- From: umesh kumar chaudhary [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 23, 2001 12:58 AM To: [EMAIL PROTECTED] Subject: Not working mysql in win2000 Prof. Dear Sir, I have window 2000 Professional Operating System. Ihad installed PHP, Apache Web Server and MySql.PHP worksvery good with apache. MySql is installed in by deafaul directory that is c:\mysql but MySql does not work.I aslso create the file c:\MY.CNF with document of My-example.cnf. When I give the command in command prompt like: C:\mysql\bin\mysqld--standalone it gives the message: 'mysqld' is not recognized as an internal or external command. so, Please help me sir to solve tis type of problems. Thank U umesh __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySql Fulltext match problem
Is there anybody willing to help me? I have mysql v3.23.39, and i'm trying to use the mysql-fulltext engine, looks like it's not funcitonal very well(maybe my mistake). I had created example database for fulltext as written in manual, inserted about 10Megs of text files. When I try to do match "select * from t_full where match(title,body) against('alebo');" The result: first file has let's say 4 occurences of this word, and the other one(I know about for sure) with about 150 occurences is somewhere in the end, there is some special mysql ranking for fulltext as i know, but what does this mean, how can be a file with less occurences before the file with more occurences...? Thanks, cajo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Fulltext match problem
Hi! On Sep 23, cajmilfo wrote: Is there anybody willing to help me? I have mysql v3.23.39, and i'm trying to use the mysql-fulltext engine, looks like it's not funcitonal very well(maybe my mistake). I had created example database for fulltext as written in manual, inserted about 10Megs of text files. When I try to do match select * from t_full where match(title,body) against('alebo'); The result: first file has let's say 4 occurences of this word, and the other one(I know about for sure) with about 150 occurences is somewhere in the end, there is some special mysql ranking for fulltext as i know, but what does this mean, how can be a file with less occurences before the file with more occurences...? I don't know exactly what's in your case, but e.g. a document with 4 occurences of the word in question and 4 other words (50% coverage) will be rated higher then the document with 150 occurences in 15 words total (0.1% coverage). Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: user creation in mysql
Here a good place to go through this step by step. Good luck and happy MySQL'ing M;) -Original Message- From: Kamesh P S [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 23, 2001 6:40 AM To: [EMAIL PROTECTED] Subject: user creation in mysql me too facing the problem in creating users and granting permission please help me Hi, We are facing problem with mysql on linux. We are unable to give the password for admin user. Can you please give all the list for installation and user creation as well as for uninstalling? Thanks, Kamesh __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Newbie - PWS SQL. Some VSQs (Very Silly Questions)
. Dear List-Members, As I am EXTREMELY new to mysql and my connection to my ISP is a pay-per-minute one, doing the endless testing (koff, kofff Ok, farffing around, getting lost, tired and emotional) with mysql can cost some dosh over time. I've only recently arrived at this work-station machine and found that the previous operator has Microsoft's Personal Web Server and mysql on it. She doesn't seem to have *done* anything with them, but recent magazine articles on mysql have whetted my interest. So. Is there a step-by-step guide to installing/linking mysql - or whatever it is I have to do - onto the PWS to allow me to experiment locally? I date from the days of CP/M and DOS 3.2 and command lines, but have no experience of Linux/Unix. On the strength of various recommendations I read, I bought Mr duBois' book; I commend its jargon-free approach but it doesn't seem to mention PWS. After reading bits of http://www.mysql.com/articles/ddws/3.html I looked in my c:\mysql\bin and there are an *awful* lot of .exe files. When I go to my hosting site http://www.pay-as-you-host.com/help/howto/sql and load the tbl_FILENAMES.php files I've ftp-ed up to it from this machine, mysql seems to run all right - it certainly invites me to try all things. As there are three hard discs on this machine, Be there dragons? on operating across them - there seem to be some fairly heavy warnings everywhere on running mysql from anything other than its installed c:\ drive. Round about here is where I run out of intelligent questions (that is, if the above were intelligent). In the usual way of things, after a couple of weeks' use and experimenting, I expect I'll cringe at the naive content of this message. Yors, Iain Lang. To Keep Well, You Must Sleep Well! http://www.divinebedding.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
Creating Tables with MySQLGUI 1.7.5-2
Hi, I've been checking out MySQLGUI 1.7.5-2 for win 32. I've been able to create a database, but, I can't seem to get it to create a table using Commands/Tables/Create tables. Is it safe to assume that this is a know issue? Thanks, Steve. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: user creation in mysql--Oppps
http://www.devshed.com/Server_Side/MySQL/Access/page2.html -Original Message- From: Mike [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 23, 2001 9:31 AM To: Kamesh P S; [EMAIL PROTECTED] Subject: RE: user creation in mysql Here a good place to go through this step by step. Good luck and happy MySQL'ing M;) -Original Message- From: Kamesh P S [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 23, 2001 6:40 AM To: [EMAIL PROTECTED] Subject: user creation in mysql me too facing the problem in creating users and granting permission please help me Hi, We are facing problem with mysql on linux. We are unable to give the password for admin user. Can you please give all the list for installation and user creation as well as for uninstalling? Thanks, Kamesh __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Newbie - PWS SQL. Some VSQs (Very Silly Questions)
I suggest downloading/installing the MySql ADO library (available from a link off mysql.com downloads). Then you can write ASP pages (using ado objects) to interact with your mysql database. Before my suggestion catches the ire of all the php/linux snobs, I must point out that our friend wants to use PWS (i.e. IIS-Lite). I say when in Redmond do as the Redmondites do... and our friend is definitely in Redmond! I must also point out that since you don't seem to have much invested in PWS, perhaps you might consider whether another web server would better suite your needs. You could, for instance, download Apache and PHP and take a different road altogether. One advantage to this would be that you will certainly find more examples of people using these technologies with mysql than you will ado/asp. In either event, you should definitely look for a less restrictive hosting arrangement. Good luck. Will French -Original Message- From: Iain Lang [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 23, 2001 12:34 PM To: [EMAIL PROTECTED] Subject: Newbie - PWS SQL. Some VSQs (Very Silly Questions) . Dear List-Members, As I am EXTREMELY new to mysql and my connection to my ISP is a pay-per-minute one, doing the endless testing (koff, kofff Ok, farffing around, getting lost, tired and emotional) with mysql can cost some dosh over time. I've only recently arrived at this work-station machine and found that the previous operator has Microsoft's Personal Web Server and mysql on it. She doesn't seem to have *done* anything with them, but recent magazine articles on mysql have whetted my interest. So. Is there a step-by-step guide to installing/linking mysql - or whatever it is I have to do - onto the PWS to allow me to experiment locally? I date from the days of CP/M and DOS 3.2 and command lines, but have no experience of Linux/Unix. On the strength of various recommendations I read, I bought Mr duBois' book; I commend its jargon-free approach but it doesn't seem to mention PWS. After reading bits of http://www.mysql.com/articles/ddws/3.html I looked in my c:\mysql\bin and there are an *awful* lot of .exe files. When I go to my hosting site http://www.pay-as-you-host.com/help/howto/sql and load the tbl_FILENAMES.php files I've ftp-ed up to it from this machine, mysql seems to run all right - it certainly invites me to try all things. As there are three hard discs on this machine, Be there dragons? on operating across them - there seem to be some fairly heavy warnings everywhere on running mysql from anything other than its installed c:\ drive. Round about here is where I run out of intelligent questions (that is, if the above were intelligent). In the usual way of things, after a couple of weeks' use and experimenting, I expect I'll cringe at the naive content of this message. Yors, Iain Lang. To Keep Well, You Must Sleep Well! http://www.divinebedding.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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: user creation in mysql
Hi Take a look at the following links, which guides you step by step in managing the user accounts: http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm inistration.html#User_Account_Management Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu mailto:[EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com -Original Message- From: Kamesh P S [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 23, 2001 5:40 AM To: [EMAIL PROTECTED] Subject: user creation in mysql me too facing the problem in creating users and granting permission please help me Hi, We are facing problem with mysql on linux. We are unable to give the password for admin user. Can you please give all the list for installation and user creation as well as for uninstalling? Thanks, Kamesh __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Compiled v. 3.23.40 and 3.23.42 to12 test Failures
R Talbot wrote: R Talbot wrote: Michael Widenius wrote: The problem is probably that your tar program doesn't use user-names but user-ids, in which case the files may be owned by 'anyone. What output do you get for: ldd bin/mysqld [root@thinkpad]# ls -l /bin/mysqld -rwxr-xr-x 1 root root 1832912 Sep 21 20:59 /bin/mysqld [root@thinkpad]# ldd /bin/mysqld statically linked (ELF) [root@thinkpad]# bin/mysqld --help To see what values a running MySQL server is using, type 'mysqladmin variables' instead of 'mysqld --help'. The default values (after parsing the command line arguments) are: basedir: /usr/local/mysql/ datadir: /usr/local/mysql/var/ tmpdir: /tmp/ language:/usr/local/mysql/share/mysql/english/ pid file:/usr/local/mysql/var/thinkpad.pid TCP port:3306 Unix socket: /tmp/mysql.sock system locking is not in use max_user_connections current value: 0 max_write_lock_count current value: 4294967295 myisam_sort_buffer_size current value: 8388608 myisam_max_extra_sort_file_size current value: 256 myisam_max_sort_file_size current value: 2047 net_buffer_length current value: 16384 net_retry_count current value: 10 net_read_timeout current value: 30 net_write_timeout current value: 60 open_files_limit current value: 0 query_buffer_size current value: 0 record_buffer current value: 131072 record_rnd_buffer current value: 0 slave_net_timeout current value: 3600 slow_launch_time current value: 2 sort_buffer current value: 2097144 table_cache current value: 64 thread_concurrencycurrent value: 10 thread_cache_size current value: 0 tmp_table_sizecurrent value: 33554432 thread_stack current value: 131072 wait_timeout current value: 28800 delayed_insert_timeout current value: 300 delayed_insert_limit current value: 100 delayed_queue_sizecurrent value: 1000 flush_timecurrent value: 0 interactive_timeout current value: 28800 join_buffer_size current value: 131072 key_buffer_size current value: 16773120 long_query_time current value: 10 lower_case_table_names current value: 0 max_allowed_packetcurrent value: 1047552 max_binlog_cache_size current value: 4294967295 max_binlog_size current value: 1073741824 max_connections current value: 100 max_connect_errorscurrent value: 10 max_delayed_threads current value: 20 max_heap_table_size current value: 16777216 max_join_size current value: 4294967295 max_sort_length current value: 1024 max_tmp_tablescurrent value: 32 max_user_connections current value: 0 max_write_lock_count current value: 4294967295 myisam_sort_buffer_size current value: 8388608 myisam_max_extra_sort_file_size current value: 256 myisam_max_sort_file_size current value: 2047 net_buffer_length current value: 16384 net_retry_count current value: 10 net_read_timeout current value: 30 net_write_timeout current value: 60 open_files_limit current value: 0 query_buffer_size current value: 0 record_buffer current value: 131072 record_rnd_buffer current value: 0 slave_net_timeout current value: 3600 slow_launch_time current value: 2 sort_buffer current value: 2097144 table_cache current value: 64 thread_concurrencycurrent value: 10 thread_cache_size current value: 0 tmp_table_sizecurrent value: 33554432 thread_stack current value: 131072 wait_timeout current value: 28800 Thank you Bob T - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql connection prob on a raq4i
Hello, Can someone who has successfully created a MySQL database for a virtual hosting account show me how to connect! I can always connect as root ... but when I try to connect as the user its get a permission error. I went to the database and gave the user of that virtual account all premisions in the USER table in the MYSQL database. But that did not help. Here is the error I get: mysql use bcwdb; ERROR 1044: Access denied for user: '@localhost' to database 'bcwdb' I tried two ways. by the shell. This is what I get: [lindab lindab]$ mysql -u lindab -p Enter password: ERROR 1045: Access denied for user: 'lindab@localhost' (Using password: YES) and via my VBB install script .. which gives the same type error I looked in the Mysql database and I think I have each required record ie user table | localhost | lindab | host table | localhost | bcwdb | Y | Y | Y | Y ... db table | localhost | bcwdb | lindab | Y ... and the above does not seem to work I am loosing my mind thanks David -- Systematic Software [EMAIL PROTECTED] (513) 241 3331 ext. 9 http://www.systware.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
EXPLAIN problem
Hi all, I'm having a problem where the optimiser seems to take a *very* long time to work out which indexes to use. Although I'm using a lot of joins, it takes around 10 minutes to give an EXPLAIN of the query shown below. The actual query takes only a second or two (or so it appears). linklist is a table which contains 5.5 million rows. Position only contains 95,000. Anyone have any ideas ? The query is as simple as it can be, and speed is very important, as it returns immediate data to users. Apologies for the size of the SQL, I can't see any way to reduce it. select DISTINCT position.id as total from position, linklist , linklist as linklist2, linklist as linklist3, linklist as linklist4, linklist as linklist5, linklist as linklist6, linklist as linklist7, linklist as linklist8, linklist as linklist9, linklist as linklist10, linklist as linklist11, linklist as linklist12, linklist as linklist13 where position.id = linklist.position_id and linklist.position_id = linklist2.position_id and linklist.position_id = linklist3.position_id and linklist.position_id = linklist4.position_id and linklist.position_id = linklist5.position_id and linklist.position_id = linklist6.position_id and linklist.position_id = linklist7.position_id and linklist.position_id = linklist8.position_id and linklist.position_id = linklist9.position_id and linklist.position_id = linklist10.position_id and linklist.position_id = linklist11.position_id and linklist.position_id = linklist12.position_id and linklist.position_id = linklist13.position_id and (linklist.id = '705' and linklist2.id = '125' and linklist3.id = '1244' and linklist4.id = '4246' and linklist5.id = '803' and linklist6.id = '1247' and linklist7.id = '1904' and linklist8.id = '3509' and linklist9.id = '69' and linklist10.id = '952' and linklist11.id = '5' and linklist12.id = '3071' ) and (position.dater = 968) and (linklist13.id = '4' ) Many thanks, Russ. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Alphabetical AUTO_INCREMENT?
How do I convert (or create from scratch) a table who's AUTO_INCREMENT column would be a, b, c, d, e and so forth up to z? At the moment I am using an INT column 1, 2, 3, 4, etc, but I would really be able to make good use in my queries if this column was alphabetical instead. Thanks. Neil Silvester P.S. database, mysql _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem installing MySQL
Hi, I am trying to install MySQL in my own account on Sun Sparc solaris2.7. I am an EE student trying to finish a project. Here is my problem: I downloaded source MySQL file to my home directory. As I am not root user, I failed to run groupadd mysql and useradd -g mysql mysql. After I gtar-ed the MySQL .gz file, but failed to run ./configure --prefix=/usr/local/mysql. The error message I got was checking return type of sprintf... configure: error: can not run test program while cross compiling. I succeeded loading binary version of MySQL to my account. However, when I tried to install sipconf, I got error message Could not find MySQL Client library. I thought the C API library might not be in the binary version, so I tried to download the source and worked on it. Could you please give me some help? Your earliest reply would be greatly appreciated. Thank you very much in advance! Best regards, Huai Liu /home/hliu/mysql hliu@bronto ./configure --prefix=/home/hliu/mysql creating cache ./config.cache checking host system type... sparc-sun-solaris2.7 checking target system type... sparc-sun-solaris2.7 checking build system type... sparc-sun-solaris2.7 checking for a BSD compatible install... ./install-sh -c checking whether build environment is sane... yes checking whether make sets ${MAKE}... yes checking for working aclocal... found checking for working autoconf... found checking for working automake... found checking for working autoheader... found 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++... c++ checking whether the C++ compiler (c++ ) works... yes checking whether the C++ compiler (c++ ) is a cross-compiler... yes checking whether we are using GNU C++... yes checking whether c++ accepts -g... yes checking how to run the C preprocessor... gcc -E checking for ranlib... ranlib checking for ld used by GCC... /usr/ccs/bin/ld checking if the linker (/usr/ccs/bin/ld) is GNU ld... no checking for BSD-compatible nm... /usr/ccs/bin/nm -p checking whether ln -s works... yes updating cache ./config.cache loading cache ./config.cache within ltconfig checking for object suffix... o checking for executable suffix... no checking for gcc option to produce PIC... -fPIC checking if gcc PIC flag -fPIC works... yes checking if gcc supports -c -o file.o... yes checking if gcc supports -c -o file.lo... yes checking if gcc supports -fno-rtti -fno-exceptions ... yes checking if gcc static flag -static works... -static checking if the linker (/usr/ccs/bin/ld) is GNU ld... no checking whether the linker (/usr/ccs/bin/ld) supports shared libraries... yes checking command to parse /usr/ccs/bin/nm -p output... ok checking how to hardcode library paths into programs... immediate checking for /usr/ccs/bin/ld option to reload object files... -r checking dynamic linker characteristics... solaris2.7 ld.so checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... yes checking for objdir... .libs creating libtool updating cache ./config.cache loading cache ./config.cache checking for a BSD compatible install... ./install-sh -c checking for bison... bison -y checking for pdftex... manual.pdf checking return type of sprintf... configure: error: can not run test program while cross compiling hliu@bronto scripts/mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables 010923 17:29:17 ./bin/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/mysqladmin -u root -p password 'new-password' ./bin/mysqladmin -u root -h bronto.sce.carleton.ca -p password 'new-password' See the manual for more instructions. You can start the MySQL daemon with: cd . ; ./bin/safe_mysqld You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To
Re: Alphabetical AUTO_INCREMENT?
Neil Silvester writes: How do I convert (or create from scratch) a table who's AUTO_INCREMENT column would be a, b, c, d, e and so forth up to z? At the moment I am using an INT column 1, 2, 3, 4, etc, but I would really be able to make good use in my queries if this column was alphabetical instead. I'd be surprised if there's a way to do it. But what is stopping you from converting numbers to char codes? Look at the string functions in the manual. //C mysql, database, bullshitfilterthatdoesn'twork -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem installing MySQL
Hi, I attached a wrong file in my last email. I should have sent you config.log file. Here it is. Sorry for the mistake. Thanks again. Huai Liu This file contains any messages produced by compilers while running configure, to aid debugging if configure makes a mistake. configure:813: checking host system type configure:834: checking target system type configure:852: checking build system type configure:887: checking for a BSD compatible install configure:940: checking whether build environment is sane configure:975: checking whether make sets ${MAKE} configure:1021: checking for working aclocal configure:1034: checking for working autoconf configure:1047: checking for working automake configure:1060: checking for working autoheader configure:1073: checking for working makeinfo configure:1175: checking whether to enable maintainer-specific portions of Makefiles configure:1217: checking whether build environment is sane configure:1234: checking whether make sets ${MAKE} configure:1302: checking for gawk configure:1334: checking for gcc configure:1447: checking whether the C compiler (gcc ) works configure:1463: gcc -o conftest conftest.c 15 configure:1489: checking whether the C compiler (gcc ) is a cross-compiler configure:1494: checking whether we are using GNU C configure:1503: gcc -E conftest.c configure:1522: checking whether gcc accepts -g configure:1558: checking for c++ configure:1590: checking whether the C++ compiler (c++ ) works configure:1606: c++ -o conftest conftest.C 15 configure:1632: checking whether the C++ compiler (c++ ) is a cross-compiler configure:1637: checking whether we are using GNU C++ configure:1646: c++ -E conftest.C configure:1665: checking whether c++ accepts -g configure:1697: checking how to run the C preprocessor configure:1718: gcc -E conftest.c /dev/null 2conftest.out configure:1833: checking for ranlib configure:1943: checking for ld used by GCC configure:2005: checking if the linker (/usr/ccs/bin/ld) is GNU ld configure:2021: checking for BSD-compatible nm configure:2057: checking whether ln -s works ltconfig:603: checking for object suffix ltconfig:604: gcc -cconftest.c 15 ltconfig:629: checking for executable suffix ltconfig:630: gcc -o conftest conftest.c 15 ltconfig:776: checking if gcc PIC flag -fPIC works ltconfig:777: gcc -c -fPIC -DPIC conftest.c 15 ltconfig:829: checking if gcc supports -c -o file.o ltconfig:830: gcc -c -o out/conftest2.o conftest.c 15 ltconfig:862: checking if gcc supports -c -o file.lo ltconfig:863: gcc -c -c -o conftest.lo conftest.c 15 ltconfig:914: checking if gcc supports -fno-rtti -fno-exceptions ltconfig:915: gcc -c -fno-rtti -fno-exceptions -c conftest.c conftest.c 15 ltconfig:958: checking if gcc static flag -static works ltconfig:959: gcc -o conftest -static conftest.c 15 ltconfig:1653: checking if global_symbol_pipe works ltconfig:1654: gcc -cconftest.c 15 ltconfig:1657: eval /usr/ccs/bin/nm -p conftest.o | sed -n -e 's/^.*[ ]\([BDT]\)[ ][ ]*\(\)\([_A-Za-z][_A-Za-z0-9]*\)$/\1 \2\3 \3/p' conftest.nm ltconfig:1709: gcc -o conftest -fno-builtin -fno-rtti -fno-exceptions conftest.c conftstm.o 15 configure:2257: checking for a BSD compatible install configure:2315: checking for bison configure:2348: checking for pdftex configure:2376: checking return type of sprintf - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Alphabetical AUTO_INCREMENT?
On 23-Sep-2001 Neil Silvester wrote: How do I convert (or create from scratch) a table who's AUTO_INCREMENT column would be a, b, c, d, e and so forth up to z? At the moment I am using an INT column 1, 2, 3, 4, etc, but I would really be able to make good use in my queries if this column was alphabetical instead. Thanks. select char(id + 96) as alphaid ... 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. (53kr33t w0rdz: sql table query) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Last Modified function?
I know you can set a column in each table that will update itself with the current ctime every time that row is modified, but I haven't found a per db, or per table variable yet. (I believe mSQL has something like this, but not mysql. --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED] --- Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. -- Albert Einstein [1879-1955] -Original Message- From: Camilo Rostoker [mailto:[EMAIL PROTECTED]] Sent: Friday, September 21, 2001 9:41 PM To: [EMAIL PROTECTED] Subject: Last Modified function? Hi. I was wondering if there was a way to find out when the last time the database was modified? (like a last modified function for a webpage?). Thanks for the help. Regards, Camilo Rostoker -- +=+ Camilo Rostoker [EMAIL PROTECTED] http://www.rostoker.com/ The 2 most important things in life: 1. never tell anyone everything you know about something 2. ... +=+ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Queries
Setup : MySQL 3.23.42 Perl 5.6.0 DBI 10.32 I’m trying to do a few different queries where the table name needs to be dynamic. I’ve tried the following : $dbquery = $dbhandler-prepare_cached(“SELECT id, target FROM ? where somedata=?”); $dbquery-execute($tablename,$somedata); But I keep getting an error…. The error looks something like this : DBD::mysql::st execute failed: You have an error in your SQL syntax near ''mod1' where id='test.1'' at line 1 at ClassMRTGDB.pm line 73. DBD::mysql::st fetchrow_array failed: fetch() without execute() at ClassMRTGDB.pm line 75. Anyone know why this isn’t working? Do I have to specify the table name in the actual prepare statement every time? Also, assuming I only run execute’s after I first define $dbquery, is $dbquery guaranteed to be there until the program exits? (I’m not redefining $dbquery at any time…) I’m pretty sure it is, so I’m just checking.. Otherwise I need to write code to check on it.. ☺ Thanks, --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED] --- So Long and Thanks for all the Fish -- Douglas Adams [1952-2001] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
strange InnoDB errors in err log
Hello, I checked my .err file today and found these: - InnoDB: error in sec index entry update in InnoDB: index UNQ_USER_NAME table rateGenius/USER_USER InnoDB: tuple 0: len 7; hex 616d626a6f7267; asc ambjorg;; 1: len 8; hex 1d1b; asc ;; InnoDB: record RECORD: info bits 0 0: len 11; hex 616d6265725f6a6f6e6573; asc amber_jones;; 1: len 8 ; hex 1180; asc ;; InnoDB: Make a detailed bug report and send it InnoDB: to [EMAIL PROTECTED] InnoDB: error in sec index entry update in InnoDB: index UNQ_USER_NAME table rateGenius/USER_USER InnoDB: tuple 0: len 7; hex 416d626a6f7267; asc Ambjorg;; 1: len 8; hex 1d1b; asc ;; InnoDB: record RECORD: info bits 0 0: len 11; hex 616d6265725f6a6f6e6573; asc amber_jones;; 1: len 8 ; hex 1180; asc ;; InnoDB: Make a detailed bug report and send it InnoDB: to [EMAIL PROTECTED] InnoDB: error in sec index entry update in InnoDB: index UNQ_USER_NAME table rateGenius/USER_USER InnoDB: tuple 0: len 7; hex 414d424a4f5247; asc AMBJORG;; 1: len 8; hex 1d1b; asc ;; InnoDB: record RECORD: info bits 0 0: len 11; hex 616d6265725f6a6f6e6573; asc amber_jones;; 1: len 8 ; hex 1180; asc ;; InnoDB: Make a detailed bug report and send it InnoDB: to [EMAIL PROTECTED] InnoDB: error in sec index entry update in InnoDB: index UNQ_USER_NAME table rateGenius/USER_USER InnoDB: tuple 0: len 7; hex 416d626a6f7267; asc Ambjorg;; 1: len 8; hex 1d1b; asc ;; InnoDB: record RECORD: info bits 0 0: len 11; hex 616d6265725f6a6f6e6573; asc amber_jones;; 1: len 8 ; hex 1180; asc ;; InnoDB: Make a detailed bug report and send it InnoDB: to [EMAIL PROTECTED] - I do not know what to make of them, except that they do not make me comfortable! I cannot tell you when they occured or what was happening, as there are no timestamps. My system is a single cpu linux machine running kernel 2.4.9, glibc-2.2.4, binutils-2.10.2, gcc-2.95.3 and mysql-2.23.42. MySQL was build as follows: CFLAGS=-O3 -march=i686 -mcpu=i686 CXX=gcc CXXFLAGS=-O3 -march=i686 \ -mcpu=i686 -felide-constructors -fno-exceptions -fno-rtti ./configure \ --prefix=/home/mysql --enable-assembler --with-mysqld-ldflags=-all-static \ --with-innodb --without-docs --without-bench --with-gnu-ld Thanks, robert -- robert cope \ I'm like a bad penny. I always turn up. [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
build problems on powerpc with 3.23.42
Hello I have problems building the mysql package for the Debian distribution on powerpc. More infos below. Feel free to contact me for further details. bye, -christian- make[3]: Entering directory `/home/ch/debian/mysql-3.23.42/sql' g++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr\ -DDATADIR=\/var/lib/mysql\ -DSHAREDIR=\/usr/share/mysql\ -DHAVE_CONFIG_H -I../innobase/include -I./../include -I./../regex-I. -I../include -I.. -I.-O3 -DDBUG_OFF -O2 -g -felide-constructors -fno-rtti -fno-implicit-templates -fno-exceptions -fno-rtti -c mysqld.cc In file included from mysqld.cc:80: /usr/include/tcpd.h:39: invalid exception specifications /usr/include/tcpd.h:40: invalid exception specifications /usr/include/tcpd.h:41: invalid exception specifications /usr/include/tcpd.h:42: invalid exception specifications make[3]: *** [mysqld.o] Error 1 make[3]: Leaving directory `/home/ch/debian/mysql-3.23.42/sql' make[2]: *** [all-recursive] Error 1 the relevant lines in tcpd.h are *sink to *cleanup: struct request_info { int fd; /* socket handle */ charuser[STRING_LENGTH];/* access via eval_user(request) */ chardaemon[STRING_LENGTH]; /* access via eval_daemon(request) */ charpid[10];/* access via eval_pid(request) */ struct host_info client[1]; /* client endpoint info */ struct host_info server[1]; /* server endpoint info */ void (*sink) __P((int)); /* datagram sink function or 0 */ void (*hostname) __P((struct host_info *)); /* address to printable hostname */ void (*hostaddr) __P((struct host_info *)); /* address to printable address */ void (*cleanup) __P((struct request_info *)); /* cleanup function or 0 */ struct netconfig *config; /* netdir handle */ }; I'm using: ii libwrap0-dev 7.6-8.2Wietse Venema's TCP wrappers library, ii libc6-dev 2.2.4-1GNU C Library: Development Libraries ii gcc2.95.4-6 The GNU C compiler. ii g++2.95.4-6 The GNU C++ compiler. ii libstdc++2.10 2.95.2-13 The GNU stdc++ library ch@voltaire:~/debian/mysql-3.23.42$ cat /proc/cpuinfo processor : 0 cpu : 7400 (G4, altivec supported) clock : 500MHz revision: 2.9 (pvr 000c 0209) bogomips: 992.87 processor : 1 cpu : 7400 (G4, altivec supported) clock : 500MHz revision: 2.9 (pvr 000c 0209) bogomips: 992.87 total bogomips : 1985.74 zero pages : total: 0 (0Kb) current: 0 (0Kb) hits: 0/0 (0%) machine : PowerMac3,3 motherboard : PowerMac3,3 MacRISC Power Macintosh L2 cache: 1024K unified memory : 320MB pmac-generation : NewWorld -- Rome did not create a great empire by having meetings, they did it by killing all those who opposed them. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
update to strange InnoDB errors
Er, a little embarassed that I did not check the bugfixes page before reporting that. Anyhow, here is the check table to go with that report: +--+---+--+--+ | Table| Op| Msg_type | Msg_text | +--+---+--+--+ | rateGenius.USER_USER | check | status | OK | +--+---+--+--+ robert -- robert cope \ Water? No thank you, fish make love in it. [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
MySQL 4.0
Sooo, when does this highly anticipated version of mysql get released? Supposed to have union tables :). - Deryck H - http://www.comp-u-exchange.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
Creating Databases
Does mySQL not support this syntax? CREATE DATABASE newDB ON ( NAME = 'newDB', FILENAME = '~/newDB.mdf', SIZE = 10MB, MAXSIZE = 20MB, FILEGROWTH = 1MB ) -- Sincerely, Rosyna Keller Technical Support/Holy Knight/Always needs a hug Unsanity: Unsane Tools for Insane People - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Expect Script accessing MySQL
Hi, Just a quick query. I haven't been able to locate any documentation on it, but has anyone ever used an expect script to connect to a MySQL database and pull out a bunch of data for use further in the expect script ? Any directions would be appreciated. Cheers Chris -- Chris Aitken - Administration/Database Designer - IDEAL Internet email: [EMAIL PROTECTED] phone: +61 2 4628 fax: +61 2 4628 8890 __-__ *** Big Brother *** It just shows that the dull will rule the world. And we will be watching 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
Select statement problem
As I am still a newbie to mysql I am sure that some of the problems that I am coming accross are created by myself, and others are probably so simple that they are staring me in the face. I do, however, seem to be having some problems with the below statement. I would like the result of the query to only display one entry per company no matter how many products they have. $result = mysql_query(SELECT competitor.ID, Competitor.CompetitorName FROM competitor, competitorproducts, productcategory WHERE competitorproducts.CompID=competitor.ID and competitorproducts.CatID=productcategory.ID and productcategory.ID like \$cat%\ and competitor.CompetitorName like \$CompName%\ and competitorproducts.ProductName like \$CompProd%\ order by CompetitorName ); I am using PHP as a front end. TIA. Neil Silvester P.S. database, mysql _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Select dates from Table 1 not in Table 2
At 11:55 23/09/01 +1000, you wrote: Thanks Will for the suggestion, however as per my private email to you, it didn't work successfully to any degree. Actually it knocked out ONE date from the same group and that was one of the Available dates. I'll take my foot out of my mouth now and try and look at what I'm doing! Thanks Will, you were spot on. The sql example you provided did exactly what it was suppose to, I just didn't add all the extra grouping and so when I looked, only one date showed as valid in the table. Which, ungrouped is correct :) Thanks also Will, for all the extra bits you added, I'll go over those now and start to build a slightly more complex processing list now incorporating all the locations, cast, crew and other resources needed and of course, now the dates will show up by group :) /me pulls foot out of mouth and looks at ALL data, rather than an assumed snapshot :) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Creating Databases
rtfm. Excerpt from mySQL manual. = 6.5.1 CREATE DATABASE Syntax CREATE DATABASE [IF NOT EXISTS] db_name CREATE DATABASE creates a database with the given name. Rules for allowable database names are given in Section 6.1.2 [Legal names], page 358. An error occurs if the database already exists and you didn't specify IF NOT EXISTS. Databases in MySQL are implemented as directories containing files that correspond to tables in the database. Because there are no tables in a database when it is initially created, the CREATE DATABASE statement only creates a directory under the MySQL data directory. You can also create databases with mysqladmin. See Section 4.8 [Client-Side Scripts], page 279. = -Original Message- From: Rosyna [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 23, 2001 8:55 PM To: [EMAIL PROTECTED] Subject: Creating Databases Does mySQL not support this syntax? CREATE DATABASE newDB ON ( NAME = 'newDB', FILENAME = '~/newDB.mdf', SIZE = 10MB, MAXSIZE = 20MB, FILEGROWTH = 1MB ) -- Sincerely, Rosyna Keller Technical Support/Holy Knight/Always needs a hug Unsanity: Unsane Tools for Insane People - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Expect Script accessing MySQL
It is possible and not very hard at all. But why would you need expect? Why not just use a shell script? Neil On Mon, 24 Sep 2001, Chris Aitken wrote: Hi, Just a quick query. I haven't been able to locate any documentation on it, but has anyone ever used an expect script to connect to a MySQL database and pull out a bunch of data for use further in the expect script ? Any directions would be appreciated. Cheers Chris -- Chris Aitken - Administration/Database Designer - IDEAL Internet email: [EMAIL PROTECTED] phone: +61 2 4628 fax: +61 2 4628 8890 __-__ *** Big Brother *** It just shows that the dull will rule the world. And we will be watching 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Compiled v. 3.23.40 and 3.23.42 to12 test Failures
R Talbot wrote: R Talbot wrote: R Talbot wrote: Michael Widenius wrote: The problem is probably that your tar program doesn't use user-names but user-ids, in which case the files may be owned by 'anyone. What output do you get for: ldd bin/mysqld [root@thinkpad]# ls -l /bin/mysqld -rwxr-xr-x 1 root root 1832912 Sep 21 20:59 /bin/mysqld [root@thinkpad]# ldd /bin/mysqld statically linked (ELF) [root@thinkpad]# bin/mysqld --help To see what values a running MySQL server is using, type 'mysqladmin variables' instead of 'mysqld --help'. The default values (after parsing the command line arguments) are: basedir: /usr/local/mysql/ datadir: /usr/local/mysql/var/ tmpdir: /tmp/ language:/usr/local/mysql/share/mysql/english/ pid file:/usr/local/mysql/var/thinkpad.pid TCP port:3306 Unix socket: /tmp/mysql.sock system locking is not in use max_user_connections current value: 0 max_write_lock_count current value: 4294967295 myisam_sort_buffer_size current value: 8388608 myisam_max_extra_sort_file_size current value: 256 myisam_max_sort_file_size current value: 2047 net_buffer_length current value: 16384 net_retry_count current value: 10 net_read_timeout current value: 30 net_write_timeout current value: 60 open_files_limit current value: 0 query_buffer_size current value: 0 record_buffer current value: 131072 record_rnd_buffer current value: 0 slave_net_timeout current value: 3600 slow_launch_time current value: 2 sort_buffer current value: 2097144 table_cache current value: 64 thread_concurrencycurrent value: 10 thread_cache_size current value: 0 tmp_table_sizecurrent value: 33554432 thread_stack current value: 131072 wait_timeout current value: 28800 delayed_insert_timeout current value: 300 delayed_insert_limit current value: 100 delayed_queue_sizecurrent value: 1000 flush_timecurrent value: 0 interactive_timeout current value: 28800 join_buffer_size current value: 131072 key_buffer_size current value: 16773120 long_query_time current value: 10 lower_case_table_names current value: 0 max_allowed_packetcurrent value: 1047552 max_binlog_cache_size current value: 4294967295 max_binlog_size current value: 1073741824 max_connections current value: 100 max_connect_errorscurrent value: 10 max_delayed_threads current value: 20 max_heap_table_size current value: 16777216 max_join_size current value: 4294967295 max_sort_length current value: 1024 max_tmp_tablescurrent value: 32 max_user_connections current value: 0 max_write_lock_count current value: 4294967295 myisam_sort_buffer_size current value: 8388608 myisam_max_extra_sort_file_size current value: 256 myisam_max_sort_file_size current value: 2047 net_buffer_length current value: 16384 net_retry_count current value: 10 net_read_timeout current value: 30 net_write_timeout current value: 60 open_files_limit current value: 0 query_buffer_size current value: 0 record_buffer current value: 131072 record_rnd_buffer current value: 0 slave_net_timeout current value: 3600 slow_launch_time current value: 2 sort_buffer current value: 2097144 table_cache current value: 64 thread_concurrencycurrent value: 10 thread_cache_size current value: 0 tmp_table_sizecurrent value: 33554432 thread_stack current value: 131072 wait_timeout current value: 28800 Thank you Bob T - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Update problem
I am having problems getting an update to work correctly. Assume that I have two tables, employee and office. Employee has two fields, employee_id and employee_name, and office has three fields, office_id, office_number, employee_id. I have been using inner join to link the tables together when pulling information out of the database, but I can't get join to work with update. Say I want to update the office_number for a particular employee. I would have to get the employee_id from the employee table by referencing the employee_name in order to update the row with the corresponding employee_id in the office table. Thus far I have been trying statements like this: update office inner join employee using (employee_id) set office_number=XXX where employee_name=XX; I know that I could work around this via Perl, but I would rather have mysql do the work. Any help would be appreciated, Thanks, Phil Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 4.0
On Sun, Sep 23, 2001 at 07:54:59PM -0500, Deryck Henson wrote: Sooo, when does this highly anticipated version of mysql get released? Supposed to have union tables :). In about a week or too, based on what Monty said earlier today. :-) Jeremy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Creating Databases
I guess thats a no. I wasn't sure if it was hidden in some other documentation file. Is there a page that details things that can be done in MS SQL Server and not mySQL? Ack, at 9/23/01, Will French said: rtfm. Excerpt from mySQL manual. -- Sincerely, Rosyna Keller Technical Support/Holy Knight/Always needs a hug Unsanity: Unsane Tools for Insane People - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Select statement problem
I am assuming from your email that the field ID allows duplicates. In that case, use the SELECT DISTINCT syntax ... that will get you back the 1 row you are looking for. However, if the (ID,CompetitorName) tuple is unique, SELECT DISTINCT will NOT help. Hope this helps Raj At 06:12 PM 9/23/2001, Neil Silvester wrote: As I am still a newbie to mysql I am sure that some of the problems that I am coming accross are created by myself, and others are probably so simple that they are staring me in the face. I do, however, seem to be having some problems with the below statement. I would like the result of the query to only display one entry per company no matter how many products they have. $result = mysql_query(SELECT competitor.ID, Competitor.CompetitorName FROM competitor, competitorproducts, productcategory WHERE competitorproducts.CompID=competitor.ID and competitorproducts.CatID=productcategory.ID and productcategory.ID like \$cat%\ and competitor.CompetitorName like \$CompName%\ and competitorproducts.ProductName like \$CompProd%\ order by CompetitorName ); I am using PHP as a front end. TIA. Neil Silvester P.S. database, mysql _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Thanks Raj Datta Professional Services Direct : 408-530-4932 CrossAccess CorpCell : 408-316-5473 2900 Gordon Ave #100 Fax : 408-735-0328 Santa Clara CA 95051 Email : [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Update problem
In answer to your question - your statement does not work becuase mysql does not allow joins in update statements. imho, the fact that mysql does not support joins in UPDATE and DELETE statements is by far its greatest weakness. I have posted a couple of messages to this group to see what creative work-arounds others have used to fill this gaping hole in functionality. Alas, no one has felt like sharing their thoughts on this subject. -Original Message- From: Philip Montgomery [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 23, 2001 10:35 PM To: [EMAIL PROTECTED] Subject: Update problem I am having problems getting an update to work correctly. Assume that I have two tables, employee and office. Employee has two fields, employee_id and employee_name, and office has three fields, office_id, office_number, employee_id. I have been using inner join to link the tables together when pulling information out of the database, but I can't get join to work with update. Say I want to update the office_number for a particular employee. I would have to get the employee_id from the employee table by referencing the employee_name in order to update the row with the corresponding employee_id in the office table. Thus far I have been trying statements like this: update office inner join employee using (employee_id) set office_number=XXX where employee_name=XX; I know that I could work around this via Perl, but I would rather have mysql do the work. Any help would be appreciated, Thanks, Phil Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Expect Script accessing MySQL
At 11:36 PM 23/09/2001, Neil Zanella wrote: It is possible and not very hard at all. But why would you need expect? Why not just use a shell script? Because the task I need the script to do is best done using Expect (its interfacing with a serial port doing things with some data pulled out of a database). A psuedo flow of what it does is - * Fire off the expect script * The expect script grabs fields of data from mysql * The expect script uses that data and interfaces with a device hanging off a serial port. * The script ends with the result based on whether the interaction with the serial device succeeds or not. Thats why Im wanting to use expect... and thats why I am trying to find a way to get mysql data into an expect script. Chris -- Chris Aitken - Administration/Database Designer - IDEAL Internet email: [EMAIL PROTECTED] phone: +61 2 4628 fax: +61 2 4628 8890 __-__ *** Big Brother *** It just shows that the dull will rule the world. And we will be watching 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
mysql and ADO
hello all, I use ADO to connect to mysql database. I get an ADO recordset to show datas and update the modified records with SQL statement. So I shall resync the recordset and the database myself. But when I call the method Resync I get an error which code is 80004005 and the meaning is such as don't support this interface. I set properties of the ADO recordset like that: CursorLocation = adUseClient; CursorType = adOpenStatic; LockType = adLockBatchOptimistic; Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Use of MySQL with large tables
Hi Stephen, - Original Message - From: Stephen Faustino [EMAIL PROTECTED] We are encountering two issues when using MySQL with large tables (by large, we're talking 1 million rows). Our application is written in Java and we are using the mm.mysql JDBC driver. We run our applications using both Oracle and MySQL. Below are issues that we have experienced. I'll leave the Java API interface issues to the techies, but there are some things you can do that should always be beneficial in these kinds of situations: [...] Unfortunately, each LIMIT query takes longer and longer to return results, which means the overall select proceeds in exponential time. As an example, we tried to query all of the rows for a table containing 18 columns with 1.8 million rows (on a PII 450 w/ 128M Additional RAM on the server is always good for performance. 128MB isn't very much, and given the cost of RAM these days, it's a cheap path In this particular case, the MySQL server may not be able to keep the entire result set in memory, so it will have to be swapped to disk. I would guess this is at least in part responsible for the slower response times on the later LIMIT statements, since the way you have set it up, the server has to put together the result set first (including any ordering), swapping parts to disk (also during ordering), and then has to pick a chunk of rows from the middle, involving yet more swapping. Depending on the size of your rows, adding more RAM may allow the server to do the whole operation in memory. Of course you will want to look at mysqld options like record_buffer, sort_buffer and temp_table_size, as well as key_buffer size for the indexes. See the manual for information on these and other options. Another thing you might want to consider is first storing the large 1.8 million row result set (ordered and all) in a temporary table (if you do this with INSERT SELECT or CREATE TABLE ... SELECT it can be done without any data transfer between server and client). Then you will be able to do very fast simple SELECT ... LIMIT queries, particularly if you add a good (primary) index to allow the server to process the LIMIT clause even faster. From a programmer's perspective, you may want to wrap all this in a simple class that uses a select statement to create the temporary table and allow you to pick (sets of) rows at will. FYI, optimization techniques are an important part of MySQL training courses (http://www.mysql.com/training/). Regards, Arjen. -- Get Official MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Is MySQL 3.23.27 compatible with AFS 3.5 3.46?
Hi, We have MySQL 3.23.27 stalled and running on a Solaris 2.7 machine. We are planning to move our server to AFS school system (OS version is Solaris 2.7 (Sparc)). The AFS version is 3.5 or 3.46. Is anybody know whether MySQL 3.23.27 is compatible with AFS 3.5 3.46? Can we do the moving. I so appreciate for your reply. Regards, Suping - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: update to strange InnoDB errors
Robert, you are a genius in finding bugs :). The bug has been reported by two users before you. Since CHECK TABLE says ok, the table is probably ok now. The bug may be in purge in multiversioning: it removes a secondary index record too early. Or it may the in a lock wait. Can you describe what operations could cause the secondary index entry to change: - Do you delete rows from USER_USER? - Do you update the column containing 'Ambjorg'? - Do you use REPLACE to update the column containing 'Ambjorg'? What is the create table statement for USER_USER? What is the content of row number 7451 in the table presently, or does it exist at all? By the way, why there seem to be tuples for 'ambjorg', 'Ambjorg', and 'AMBJORG'? Regards, Heikki Er, a little embarassed that I did not check the bugfixes page before reporting that. Anyhow, here is the check table to go with that report: +--+---+--+--+ | Table| Op| Msg_type | Msg_text | +--+---+--+--+ | rateGenius.USER_USER | check | status | OK | +--+---+--+--+ robert -- robert cope \ Water? No thank you, fish make love in it. [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: Faliue: Write huge binary data to blob Field of mysql use jdbc
Thanks for your reply. Use database to restore file is the requrement of our project ,So I must find the way of problem. As you said ,I trust the problem is beacuse of mysql protocol that is the filed must be send as a single packet. I have same test in postgresql ,In postgresql the blob type is big object,with the same paramete (16 megs stack size)of jvm ,I can send 50 megs file to database! I think the mysql may be improve on this point. From: Mark Matthews [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: RE: Faliue: Write huge binary data to blob Field of mysql use jdbc Date: Fri, 21 Sep 2001 08:14:45 -0500 Hi, I'm the author of the JDBC driver. I'm not sure what the problem is, but I am going to try and talk you out of storing multi-megabytes as blobs. Here's whyIn most cases it is more overhead than it is worth. If you're going to be serving the data from these blobs from some other type of server (HTTP/NFS, etc), then you've more than doubled your overhead with the over-the-wire costs. RDBMS systems are not optimized for storing and retrieving large binary data, filesystems are. What you probably want to do is generate some unique identifier for the file and store it on a filesystem that the software you are writing has access to. Use MySQL to store metadata about these files (their identifier, author, revision history, etc), and then use standard ways of providing the file (http/nfs/smb, etc). You will find this much more performant. If you still want to store large files in BLOBs, I would look at increasing your JVM heap size (by default it's around 16megs, the VM won't allocate more memory than that), using the -Xmx switch (see your JDK documentation). Because of the way the MySQL protocol works, the entire BLOB must be created in memory as a single packet to be sent to the server, so the driver needs at least the amount of memory as the size of your BLOB, plus some overhead for escaping binary characters, plus overhead for the driver itself. -Mark We are making a project about document manage ,I use org.gjt.mm.mysql as jdbc to communicate with mysql. I can succeed in writing the binary data (the size about 14M) to database ,but when I write the binary data that's size exceed 20M I get a Exception. Please help me! Thanks! _ Äú¿ÉÒÔÔÚ MSN Hotmail Õ¾µã http://www.hotmail.com/cn Ãâ·ÑÊÕ·¢µç×ÓÓʼþ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: Fw: mySQL
- Original Message - From: [EMAIL PROTECTED] To: Jason Parker [EMAIL PROTECTED] Sent: Monday, September 24, 2001 2:19 PM Subject: Re: Fw: mySQL Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: dear sir, Could you please explain what ROLLBACK is? this information is would be most appreciated. regards, Jason Parker Draughtsman Technical Assistant Powerdown Australia Pty Ltd [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php