Re: How can run Mysql program from different user (NOT only root) ?
Thanks Jaime to reply me message so fast ! I would like to set 2 different user to maintance MySQL machine. 1st user can maintance the Unix box and MYSQL program 2nd user ONLY can maintance the MySQL program Kevin, this should be solved at the MySQL user permissions level, not at the UNIX user permissions level, I think. The person who administers MySQL is not necessarily the person who ran the server. Mysqld (the server daemon) should be run by root, when the machine is started, using a startup script. You may also run it manually as root. Then you may create a MySQL admin userid within MySQL, with full admin permissions. Give that name and password to your 2 admin people. Either of them can then, from their own unix account, type: mysql -uadmin -p Password: *** and now they can admin MySQL. For more information read http://www.mysql.com/doc/U/s/User_names.html and http://www.mysql.com/doc/G/R/GRANT.html Good luck, 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
mysql_real_connect crash
When I try to run mysql_real_connect my program crashes. If anyone could help me understand why I would be eternally grateful. I've tried looking at all the documentation regarding this situation and tried many different things, but I am still stumped with the same crash. I've tried this on current builds of redhat linux and freebsd. This is my code, with a backtrace at the end: { MYSQL mysql; mysql_init( mysql ); mysql_real_connect( mysql, localhost, user, pass, db, 0, NULL, 0 ); mysql_close( mysql ); } (gdb) bt #0 0x40072d41 in __kill () from /lib/libc.so.6 #1 0x400729b6 in raise (sig=6) at ../sysdeps/posix/raise.c:27 #2 0x400740d8 in abort () at ../sysdeps/generic/abort.c:88 #3 0x809e820 in sig_handler (sig=11) at comm.c:3936 #4 0x40072c68 in __restore () at ../sysdeps/unix/sysv/linux/i386/sigaction.c:127 #5 0x812bbab in net_write_buff () #6 0x812bac4 in my_net_write () #7 0x812965e in mysql_real_connect () #8 0x80908f6 in do_save_object (ch=0x83cd6c8, argument=0xb813 ) at build.c:9074 #9 0x80c7dd6 in interpret (ch=0x83cd6c8, argument=0xb813 ) at interp.c:740 #10 0x80985e1 in game_loop () at comm.c:620 #11 0x8097f90 in main (argc=1, argv=0xbcf4) at comm.c:273 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: question on selects in multiple tables
Hi, I faced the same problem, but the solution to this is you is you add as many qualifiers as you can (i'm sure there are more elegant ways to do it but it works for me:-))specfiy the qualifiers FOR BOTH the tables you are picking data from in the where clause : For Example : as you said lets consider two tables (made up the fields) : Table 1 : Inventory Fields are :Sno, PurchasedBy, Stock, Quantity Date Table2 :Customer Fields are : ID, Customer_Ref, Address, Phone,Name Here i assume PurchasedBy and Customer_Ref reflect the same data. So now the query to pick values would be like: Mysqlselect Inventory.*,Customer.Name from Inventory,Customer where Inventory.PurchasedBy=Customer.ID and Customer.ID='yourID'; The should work if you still find it all messed up..add one more qualifier like this : Mysqlselect Inventory.*,Customer.Name from Inventory,Customer where Inventory.PurchasedBy=Customer.ID and Customer.ID='yourID' and Inventory.PurchasedBy='youID'; I know it doesnt make a lot of sense to add another redundant Inventory.PurchasedBy since we've already said Inventory.PurchasedBy=Customer.ID but it does the job. Sundru, megasoft Ltd, Chennai, India. - Original Message - From: Cindy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 02, 2002 12:42 PM Subject: question on selects in multiple tables OK... let's say I have two tables. Let's say one is an inventory table, a bunch of items. One of the fields is for the inventory items that have been sold, and are keys to the second table, which is a list of customers; names addresses. So let's say I want to pull out all inventory items acquired in a particular month. Some of them have been sold, some have not. I want to list them all, and if they've been sold, the names of the purchasers, if not, then just blank. Problem is, of course, when I construct something like SELECT Inventory.*, Customer.Name WHERE Inventory.PurchasedBy = Customer.ID (etc) I get an ungodly mess for those items with no Customer.Name becasue of the way the query is joined(I think that's the right terminology) across the tables. Is there a way around that? This has got to be a pretty common scenario. I've tried WHERE Inventory.PurchasedBy = Customer.ID OR Inventory.PurchasedBy = 0, but that does not help. Thanks... --Cindy -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How can run Mysql program from different user (NOT only root) ?
Dear Steve and all, Thanks Steve ! Yes Steve, I have no problem to run MySQL with user - 'kevin' when I use root telnet to server and the example as below: # pwd /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin # # ./mysql -h192.10.0.113 -ukevin -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 40 to server version: 3.23.46 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql But I got an error message when I use kevin's account telent to server and try to run MySQL with user - 'kevin' and the example as below: bash-2.03$ pwd /usr/local/mysql/bin bash-2.03$ ./mysql -h192.10.0.113 -ukevin -p bash: ./mysql: Permission denied The directory of /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin and /usr/local/mysql/bin are the same : # ls -l /usr/local lrwxrwxrwx 1 root other 34 Dec 5 16:32 mysql - mysql-3.23.46-sun-solaris2.8-sparc drwxr-xr-x 13 root mysql512 Dec 5 16:30 mysql-3.23.46-sun-solaris2.8-sparc Please teach me what is the problem cause the error message Permission denied when not using root to run the MySQL program? Thanks ! Thanks again, Kevin Chan Steve Rapaport Wrote Thanks Jaime to reply me message so fast ! I would like to set 2 different user to maintance MySQL machine. 1st user can maintance the Unix box and MYSQL program 2nd user ONLY can maintance the MySQL program Kevin, this should be solved at the MySQL user permissions level, not at the UNIX user permissions level, I think. The person who administers MySQL is not necessarily the person who ran the server. Mysqld (the server daemon) should be run by root, when the machine is started, using a startup script. You may also run it manually as root. Then you may create a MySQL admin userid within MySQL, with full admin permissions. Give that name and password to your 2 admin people. Either of them can then, from their own unix account, type: mysql -uadmin -p Password: *** and now they can admin MySQL. For more information read http://www.mysql.com/doc/U/s/User_names.html and http://www.mysql.com/doc/G/R/GRANT.html Good luck, 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: How can run Mysql program from different user (NOT only root) ? (Solved !)
Dear Luke and all, Thanks Luke... my problem was solved ! Also, I would like to say thanks for all of you who try to help me before ! THANKS A LOT ! Thanks again! Best regards, Kevin Chan Luke Wrote Sounds like you don't have permission to execute the file mysql in /usr/local/mysql/bin. Try chmod a+x /usr/local/mysql/bin/mysql while root. Dear Steve and all, Thanks Steve ! Yes Steve, I have no problem to run MySQL with user - 'kevin' when I use root telnet to server and the example as below: # pwd /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin # # ./mysql -h192.10.0.113 -ukevin -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 40 to server version: 3.23.46 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql But I got an error message when I use kevin's account telent to server and try to run MySQL with user - 'kevin' and the example as below: bash-2.03$ pwd /usr/local/mysql/bin bash-2.03$ ./mysql -h192.10.0.113 -ukevin -p bash: ./mysql: Permission denied The directory of /usr/local/mysql-3.23.46-sun-solaris2.8-sparc/bin and /usr/local/mysql/bin are the same : # ls -l /usr/local lrwxrwxrwx 1 root other 34 Dec 5 16:32 mysql - mysql-3.23.46-sun-solaris2.8-sparc drwxr-xr-x 13 root mysql512 Dec 5 16:30 mysql-3.23.46-sun-solaris2.8-sparc Please teach me what is the problem cause the error message Permission denied when not using root to run the MySQL program? Thanks ! Thanks again, Kevin Chan Steve Rapaport Wrote Thanks Jaime to reply me message so fast ! I would like to set 2 different user to maintance MySQL machine. 1st user can maintance the Unix box and MYSQL program 2nd user ONLY can maintance the MySQL program Kevin, this should be solved at the MySQL user permissions level, not at the UNIX user permissions level, I think. The person who administers MySQL is not necessarily the person who ran the server. Mysqld (the server daemon) should be run by root, when the machine is started, using a startup script. You may also run it manually as root. Then you may create a MySQL admin userid within MySQL, with full admin permissions. Give that name and password to your 2 admin people. Either of them can then, from their own unix account, type: mysql -uadmin -p Password: *** and now they can admin MySQL. For more information read http://www.mysql.com/doc/U/s/User_names.html and http://www.mysql.com/doc/G/R/GRANT.html Good luck, 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[Start mysql problem (v. mysql-3.23.47-hp-hpux10.20-hppa1.1)]
Description: # ./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 ./scripts/mysql_install_db[292]: 16797 Memory fault(coredump) 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: How-To-Repeat: Fix: Submitter-Id: [EMAIL PROTECTED] Originator: Organization: IEI-CNR MySQL support: [none | licence |] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.47 (Official MySQL binary) Environment: System: HP-UX leonardo B.10.20 A 9000/871 2014209786 two-user license Some paths: /usr/bin/perl /usr/bin/make /usr/bin/cc Compilation info: CC='gcc' CFLAGS='-DHPUX -I/opt/dce/include -O3' CXX='gcc' CXXFLAGS='-DHPUX -I/opt/dce/include -felide-constructors -fno-exceptions -fno-rtti -O3 ' LDFLAGS='' LIBC: -r-xr-xr-x 1 binbin1863680 Nov 10 1999 /lib/libc.1 -r--r--r-- 1 binbin2456532 Nov 10 1999 /lib/libc.a lrwxr-xr-x 1 root sys 15 Jun 10 1996 /lib/libc.sl - /usr/lib/libc.1 -r-xr-xr-x 1 binbin1863680 Nov 10 1999 /usr/lib/libc.1 -r--r--r-- 1 binbin2456532 Nov 10 1999 /usr/lib/libc.a lrwxr-xr-x 1 root sys 15 Jun 10 1996 /usr/lib/libc.sl - /usr/lib/libc.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-thread-safe-client --with-pthread --with-named-thread-libs=-ldce --with-lib-ccflags=-fpic --disable-shared - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: question on selects in multiple tables
Hi Cindy, SELECT Inventory.*, Customer.Name from Inventory Left Join Customer on Inventory.PurchasedBy = Customer.ID where Inventory.PurchasedBy = Custormer.ID; Your query is an equi-join query, which means that there should be data for only those rows for which the equality in the where clause hold. So it will not show any row in the result if there is no a corresponding ID in Customer table for the PurchasedBy column of the Inventory Table. Left Join clause forces the query to return a row even if there is no value in the second table. More information can be had from the fine manual or any book on sql. Anvar. At 11:12 PM 01/01/2002 -0800, you wrote: OK... let's say I have two tables. Let's say one is an inventory table, a bunch of items. One of the fields is for the inventory items that have been sold, and are keys to the second table, which is a list of customers; names addresses. So let's say I want to pull out all inventory items acquired in a particular month. Some of them have been sold, some have not. I want to list them all, and if they've been sold, the names of the purchasers, if not, then just blank. Problem is, of course, when I construct something like SELECT Inventory.*, Customer.Name WHERE Inventory.PurchasedBy = Customer.ID (etc) I get an ungodly mess for those items with no Customer.Name becasue of the way the query is joined(I think that's the right terminology) across the tables. Is there a way around that? This has got to be a pretty common scenario. I've tried WHERE Inventory.PurchasedBy = Customer.ID OR Inventory.PurchasedBy = 0, but that does not help. Thanks... --Cindy -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Do not understand a method without sub-selects
How about something like this ? SELECT * FROM log_data_sig AS l1 LEFT JOIN log_data_sig AS l2 ON l1.user = l2.user WHERE l1.type=join AND l1.user=EXTERNAL_USER_ID AND l2.type = sign AND l1.timestamp l2.timestamp ORDER BY l1.timestamp DESC LIMIT 1; Terje K -Original Message- From: PPSlim [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 4:52 AM To: [EMAIL PROTECTED] Subject: Do not understand a method without sub-selects I have one single table, logging site activity as a security precaution. I want to generate a report, including items of a certain type, but only if a seperate type has not taken place after the timestamp within the first type. log_data_sig ++-+---++- -+ | eid| timestamp | type | user | extra | ++-+---++- -+ | 36625 | 2002-01-02 02:14:02 | join | 2875 | cloak.sli?data:a | | 36626 | 2002-01-02 02:14:07 | sign | 2875 | /data:a:cloak | ++-+---++- -+ The select should only select whole rows, where type is equal to join, but a type sign, on the same value of user, has not occured after the last timestamp of open. sub-select imprementation used to be SELECT * FROM log_data_sig WHERE type=join AND user=EXTERNAL_USER_ID AND timestamp (SELECT timestamp FROM log_data_sig WHERE type=sign AND user=EXTERNAL_USER_ID ORDER BY timestamp DESC LIMIT 1) ORDER BY timestamp DESC LIMIT 1 I only need to go back as far as the last time the type join was used by EXTERNAL_USER_ID, but he failed to use the type sign after. Idea being, that a user can't perform a join again, until he has perfored a sign. If any1 can help me perform this within a single SELECT statment, it would help. Thanks in advance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Counting up numerical values in a table
I am trying to add floating point numbers, and also plain numerical values, - I have looked on mysql.com but I only seem to find stuff that relate to counting rows of a certain defined value - like count where something = something, but I want to say give me a numerical total value for a column (that contains numerical values) where the id = 123456. Then it must count up the numerical values in that column where all the id's are equal to 123456 (or whatever value the id is) - I dont want to get a count of the rows that relates to the id - I want the value. Does this make sense Regards and thanks in advance Anton - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Counting up numerical values in a table
I am trying to add floating point numbers, and also plain numerical values, - I have looked on mysql.com but I only seem to find stuff that relate to counting rows of a certain defined value - like count where something = something, but I want to say give me a numerical total value for a column (that contains numerical values) where the id = 123456. Then it must count up the numerical values in that column where all the id's are equal to 123456 (or whatever value the id is) - I dont want to get a count of the rows that relates to the id - I want the value. You can use SUM function like this: SELECT SUM(some_numerical_field) as how_much FROM table_name WHERE some_id_field=some_value - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
THNKS FOR HELP: Counting up numerical values in a table
Thanks for all the help with counting up numer. values. Thanks also to Richard, and Eskom for providing us the power to drive not only our PC's but also powering solutions to our DB problems ! ;-) Regards Anton (JHB, RSA) Richard Ellerbrock writes: select sum(colnam) as x from table where id=123; Anton wrote: I am trying to add floating point numbers, and also plain numerical values, - I have looked on mysql.com but I only seem to find stuff that relate to counting rows of a certain defined value - like count where something = something, but I want to say give me a numerical total value for a column (that contains numerical values) where the id = 123456. Then it must count up the numerical values in that column where all the id's are equal to 123456 (or whatever value the id is) - I dont want to get a count of the rows that relates to the id - I want the value. Does this make sense Regards and thanks in advance Anton - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
ANNOUNCE: moodss-15.4
### CHANGES ### --- version 15.4 --- The sensors module for hardware monitoring (requires lm_sensors) and interrupts Linux module were added. Thresholds are now internally ordered when checked to allow color gradient effects. The modules management dialog boxes were redesigned for easier use. The interface to Perl and Python modules was optimized. The moomps daemon now automatically checks configuration files and reloads an updated file. Look for other and smaller improvements and quite many bug fixes in the CHANGES file. ### README ### This is moodss (Modular Object Oriented Dynamic SpreadSheet) version 15.4. Moodss won in the Best System Admin Technology category (Tcl Tips and Tricks, Valuable Real World Programming Examples) at the O'Reilly Tcl/Tk 1999 Conference. Linux Magazine calls it a lifesaver. Tucows gives it 5 stars (cows or penguins :-). Moodss is a modular application. It displays data described and updated in one or more modules, which can be specified in the command line or dynamically loaded or unloaded while the application is running. Data is originally displayed in tables. Graphical views (graph, bar, 3D pie charts, ...), summary tables (with current, average, minimum and maximum values) and free text viewers can be created from any number of table cells, originating from any of the displayed viewers. Thresholds can be set on any number of cells. Moomps (shipped with moodss) is a monitoring daemon which works using configuration files created by moodss. Thresholds, when crossed, create messages in the system log, and eventually trigger the sending of email alert messages. Specific modules can easily be developed in the Tcl, Perl and Python scripting languages or in C. A thorough and intuitive drag'n'drop scheme is used for most viewer editing tasks: creation, modification, type mutation, destruction, ... and thresholds creation. Table rows can be sorted in increasing or decreasing order by clicking on column titles. The current configuration (modules, tables and viewers geometry, ...) can be saved in a file at any time, and later reused through a command line switch, thus achieving a dashboard functionality. The module code is the link between the moodss core and the data to be displayed. All the specific code is kept in the module package. Since module data access is entirely customizable (through C code, Tcl, Perl, Python, HTTP, ...) and since several modules can be loaded at once, applications for moodss become limitless. For example, thoroughly monitor a dynamic web server on a single dashboard with graphs, using the Apache, MySQL, ODBC, cpustats, memstats, ... modules. If you have replicated servers, dynamically add them to your view, even load the snmp module on the fly and let your imagination take over... Along with a core trace module, arp, cpustats, diskstats, interrupts, kernmods, memstats, minimal, mounts, netdev, pci, ps, random, route, sensors, system modules for Linux, MySQL (myprocs, myquery, mystatus, myvars), odbcquery, ping, snmp, snmptrap for UNIX, apache and apachex, Minimal and Random Perl modules, minipy and randpy Python modules are included. Running wish moodss ps cpustats memstats mimics the top application with a graphic edge and remote monitoring capability. Thorough help is provided through menus, widget tips, a message area, a module help window and a global help window with a complete HTML documentation. Moodss is multi-langual thanks to Tcl internationalization capabilities. So far only English and partially French are supported. Help with other languages will be very warmly welcomed. Development of moodss is continuing and as more features are added in future versions, backward module code compatibility will be maintained. I cannot thank the authors of the tkTable, BLT, MIME/SMTP and the HTML libraries enough for their great work. In order to run moodss, you need to install the following packages (unless you can use the rpm utility, see below): Tcl/Tk 8.3.1 or above, at (or at a mirror near you) http://dev.scriptics.com/ or ftp://ftp.scriptics.com/ the latest tkTable widget library at: http://tktable.sourceforge.net/ the latest BLT library at: ftp://tcltk.sourceforge.net/pub/tcltk/blt/ eventually the latest tclperl library for writing modules in Perl, or the latest tclpython library for writing modules in Python at: http://jfontain.free.fr/ (see the INSTALL file for complete instructions, for UNIX and also Windows platforms). You also have the option of using the moodss rpm file (also in my homepage), if you are using a Redhat Linux system (6.0 or above). You can find the required tcl, tk, tktable, blt, tcpperl and other rpms at: http://jfontain.free.fr/ Whether you like it (or hate it), please let me know. I would like to hear about bugs and improvements you would like to see. I will correct the bugs quickly, especially if you send me a test script (module code with a data trace would be best). ### you may
Re: Mysql crashing.
[EMAIL PROTECTED] writes: Description: See earlier emails from me. Same problem. How-To-Repeat: Fix: Submitter-Id: [EMAIL PROTECTED] Originator: [EMAIL PROTECTED] Organization: Auctionwatch.com MySQL support: login Synopsis:Mysql crashing. Severity:critical Priority:high Category:mysql Class: sw-bug Release: mysql-3.23.43 (Official MySQL binary) Environment: System: Linux dbrspare-red.auctionwatch.com 2.4.17-rc2 #1 SMP Thu Dec 20 19:05:16 PST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20010703 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='-O3 -mpentium ' CXX='gcc' CXXFLAGS='-O3 -mpentium -felide-constructors' LDFLAGS='-static' LIBC: lrwxrwxrwx1 root root 13 Dec 14 11:06 /lib/libc.so.6 - libc-2.2.3.so -rwxr-xr-x1 root root 1155720 Jul 27 13:42 /lib/libc-2.2.3.so -rw-r--r--1 root root 2579358 Jul 25 08:15 /usr/lib/libc.a -rw-r--r--1 root root 178 Jul 25 08:15 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared Here is the stack dump: 0x807b75f handle_segfault__Fi + 383 0x812bcaa pthread_sighandler + 154 0x815059c chunk_free + 596 0x8152573 free + 155 0x811579c my_no_flags_free + 16 0x80764d5 _._5ilink + 61 0x807b48d end_thread__FP3THDb + 53 0x80809cc handle_one_connection__FPv + 996 Hi! The above looks like memory corruption. Can you please take a look at the log file and see if there are any messsages there ?? Beside that, send us also login info at the ususal SupportWizard interface at http://support.mysql.com -- 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
Error while executing a MySQL command from C API
Hi, I have the following error while excuting a sql INSERT query: Commands out of sync; you can't run this command now. What king of error is this? -- Ir Pascal Francq Researcher Université Libre de Bruxelles CAD/CAM Department Avenue F.D. Roosevelt, 50 CP 165/14 B-1050 Brussels BELGIUM Tel. +32-2-650 47 65 Fax +32-2-650 47 24 ICQ: 91206668 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
pam_mysql
Hello, anybody tryed %subj% ??? I have problem - module doesn't work. I must recompile mysql with some directive like --lpam or --enable-pam ?? Michal table, query, sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
STDDEV_POP
I noticed that STD() returns the sample standard deviation, which is the sensible thing for it to do. However, when working with data points sampled from a larger population (or a distribution), it's a bit of a hassle to type STD(x)*COUNT(x)/(COUNT(x)-1), and I noticed that Oracle has a function STDDEV_POP() which returns the population standard deviation, so I thought that maybe it'd be a good idea to implement this in MySQL as well. What do you think? //C -- 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
SubSelect Workaround help
How would one load the results of the following query into a one line comma separated list so that it could be then included with an IN expr to get around the lack of subselect in MySQL select distinct symbol from portfolio where type='401k' AND owner='jim' select distinct p.symbol, i.name from portfolio p, stockinfo i where p.symbol = i.symbol and p.symbol in (string name) order by symbol Thanks. Happy New Year Paul _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: SubSelect Workaround help
Is this too simple? select distinct p.symbol, i.name from portfolio p, stockinfo i where p.symbol = i.symbol and p.type = '401k' and p.owner='jim' order by p.symbol - Tom Haapanen -- Software Metrics/Equitrac Corp. Advanced Printing Solutions -- http://www.metrics.com/ -Original Message- From: Mr. psm996 [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 02 January, 2002 09:30 To: [EMAIL PROTECTED] Subject: SubSelect Workaround help How would one load the results of the following query into a one line comma separated list so that it could be then included with an IN expr to get around the lack of subselect in MySQL select distinct symbol from portfolio where type='401k' AND owner='jim' select distinct p.symbol, i.name from portfolio p, stockinfo i where p.symbol = i.symbol and p.symbol in (string name) order by symbol Thanks. Happy New Year Paul _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
2 queries in one?
I've looked through the docs and I couldn't find out how to do this. If you can point me to the right place in the documentation so I can read how, that would be great. If you could give me a little sample query to start from, that would be great as well. I've 2 columns in a table. Status and Date. I want to select all rows regardless of the values in either. However, if the status is closed, I only want those closed records that are less than 2 weeks old. Can this be done in one query? If so, how? And where can I read how to do this in the docs? thnx, Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 reconnect hang
Peter Zaitsev writes: Hello mysql, I've found the following problem often happens to me: Then mysqld restarted unclear (sigsegv or server reset) the mysql client library may hang during the automatic reconnect. The backtrace is similar to this and does not changes other time (at least 2 hours is not enough for it) Does anyone have any ideas about this ? It's quite annoying to check and restart all applications connected after single mysql restart. [skip] -- Best regards, Peter mailto:[EMAIL PROTECTED] Hi! The above happens when there is one thread left hanging when mysqld crashes for some reason. If you kill that thread a client will exit. -- 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
4.0.1 Linux binary won't launch
Hi all, Downloaded the binary distribution of 4.0.1 for Linux, and am attempting to launch on an HP laptop with RedHat 7.0. This will replace my already functional installation of 3.23.46. When I go to launch, it gives me the Starting mysqld daemon with databases... etc. message. It then fails immediately with the message mysqld ended. Here's the content of the error file in the data directory: 011230 12:14:48 mysqld started /usr/local/mysql/bin/mysqld: Fatal error: Can't find messagefile '/usr/local/mysql-4.0.1-alpha-pc-linux-gnu-i686/mysql-4.0.1-alpha-pc-linux-gnu-i686/share/mysql/english/errmsg.sys' 011230 12:14:48 Aborting 011230 12:14:48 mysqld ended So, the error is pretty obvious -- the mysql directory is named twice in the path. My question: where do I go to change this? Any other suggestions? Thanks all, /Rob -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Multi-table updates
Hello: I am testing a new product with MySQL, and so far have been very pleased, especially with the performance. One enhancement that I was looking forward to in 4.0 is described below: Updates that run over multiple tables is harder to do in MySQL. This will, however, be fixed in MySQL 4.0 with multi-table UPDATE and in MySQL 4.1 with subselects. In MySQL 4.0 one can use multi-table deletes to delete from many tables at the same time. See section 6.4.6 DELETE Syntax However, it appears the syntax for multi-table update has not been included in the version I just downloaded, 4.0.0a. Please advise as to when this will be available. I have several UPDATE queries that depend on multiple tables. Since you also do not yet support subselects, with the multi-table update I know of no way to port these queries to MySQL. Let me know if you have a suggestion to do this. Thanks for a great product, I look forward to using it exclusively in our new package. Mike Frederick WayCool Software, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Multi-table updates
Mike Frederick writes: Hello: I am testing a new product with MySQL, and so far have been very pleased, especially with the performance. One enhancement that I was looking forward to in 4.0 is described below: Updates that run over multiple tables is harder to do in MySQL. This will, however, be fixed in MySQL 4.0 with multi-table UPDATE and in MySQL 4.1 with subselects. In MySQL 4.0 one can use multi-table deletes to delete from many tables at the same time. See section 6.4.6 DELETE Syntax However, it appears the syntax for multi-table update has not been included in the version I just downloaded, 4.0.0a. Please advise as to when this will be available. I have several UPDATE queries that depend on multiple tables. Since you also do not yet support subselects, with the multi-table update I know of no way to port these queries to MySQL. Let me know if you have a suggestion to do this. Thanks for a great product, I look forward to using it exclusively in our new package. Mike Frederick WayCool Software, Inc. Hi! Multi-table updates are comming in 4.0.2. Syntax will be described in a manual when the above version is released. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: 2 queries in one?
SELECT * FROM table WHERE (Status != closed) OR ((Status = closed) AND (Date Now - # of seconds in 2 weeks)) That should work if your Date field is just a regular timestamp. It all depends on how you're storing the date... - Jonathan -Original Message- From: Chris Boget [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 7:11 AM To: [EMAIL PROTECTED] Subject: 2 queries in one? I've looked through the docs and I couldn't find out how to do this. If you can point me to the right place in the documentation so I can read how, that would be great. If you could give me a little sample query to start from, that would be great as well. I've 2 columns in a table. Status and Date. I want to select all rows regardless of the values in either. However, if the status is closed, I only want those closed records that are less than 2 weeks old. Can this be done in one query? If so, how? And where can I read how to do this in the docs? thnx, Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: where
use a REGEXP: http://www.mysql.com/doc/R/e/Regexp.html - Jonathan -Original Message- From: julian haffegee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 01, 2002 2:11 PM To: [EMAIL PROTECTED] Subject: where Hi, I have recently gained access to mysql (new isp), and am converting my old text databases to sql ones. I had a text database with a field 'keywords'. I have entered them as one field, What I want to do is submit a query where I can ask if this field CONTAINS rather than equals a string. Can you use regular expressions in this way? I want to have something like $result = mysql_query (SELECT title, keywords, description FROM documents WHERE keywords='$word'); but with keywords 'contains' '$word' a bit like keywords =~ m/$word/g in perl How would you all go about this? should I set my database up differently? Thanks very much! Jules - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 2 queries in one?
Should be something like Select Status, Date from Table where Status closed or Date now() - 14 (This is from memory so please dont rely on the syntax ;-) HTH, Chris -- Christian Pfeiffer Smart-Link Gesellschaft für EDV-Systemlösungen mbH Herforder Str. 5-7 www.smart-link.de 33602 Bielefeld Fon 0521-9623716 [EMAIL PROTECTED] Fax 0521-9623721 I've looked through the docs and I couldn't find out how to do this. If you can point me to the right place in the documentation so I can read how, that would be great. If you could give me a little sample query to start from, that would be great as well. I've 2 columns in a table. Status and Date. I want to select all rows regardless of the values in either. However, if the status is closed, I only want those closed records that are less than 2 weeks old. Can this be done in one query? If so, how? And where can I read how to do this in the docs? thnx, Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlshow expands my argument
I'm trying to use mysqlshow to display the tables of a database on a remote host. I enter the command: localhost:/usr/local/mysql$ ./bin/mysqlshow -h 555.55.5.5 -p samp_db Enter password: Wildcard: samp_db +-+ | Databases | +-+ | samp_db | +-+ localhost:/usr/local/mysql$ I'm curious as to why mysqlshow does not display the contents of the database samp_db -- both the man page for mysqlshow and the book I'm reading suggest that if I supply a database name as an argument, the tables of that database are shown. Why is mysqlshow treating my argument as a wildcard for filename expansion? Thanks for any help. Erik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Implement a menu structure using an relative database
Hi! I'm currently working on a menu system for web pages, but I've run into some problems... What I'ld like to create is a menu which can host an infinite number of submenus. Further more, every menu should also be able to link to a specific file, though not always used. I would like to be able to get the entire menu in one sql-line, that is, I would like to be able to get the following in one line: - menu1 - menu2 - menu1 - menu2 - menu1 - menu2 * some text * some more text - menu3 - menu3 - menu3 I'm doing my scripting in PHP, but I want as much as possible of the menu structure to be only mySQL-specific. But having to use some loops to be able to create the sql-line is no problem. I desperately need help on this one, I've put down much energy and time to solve it but... Sincerely Victor Spång Arthursson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
bind-address argument
I have two NIC's with two different IP addresses on the machine that has the mysql server running on it. When I set up the bind-address argument(using winmysqladmin ver.1.1) under the my.ini tab to bind to specifically one of the NIC's, it appears to have registered that it is a valid argument. However, I can still connect to the database coming from the other IP network through the other NIC. Is there something I'm missing? Kevin Ailes Administrator OTTO Engineering - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Implement a menu structure using an relative database
This might help: http://php.sitecreative.com/faq.php#3 - Jonathan -Original Message- From: Victor Spång Arthursson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 8:59 AM To: [EMAIL PROTECTED] Subject: Implement a menu structure using an relative database Hi! I'm currently working on a menu system for web pages, but I've run into some problems... What I'ld like to create is a menu which can host an infinite number of submenus. Further more, every menu should also be able to link to a specific file, though not always used. I would like to be able to get the entire menu in one sql-line, that is, I would like to be able to get the following in one line: - menu1 - menu2 - menu1 - menu2 - menu1 - menu2 * some text * some more text - menu3 - menu3 - menu3 I'm doing my scripting in PHP, but I want as much as possible of the menu structure to be only mySQL-specific. But having to use some loops to be able to create the sql-line is no problem. I desperately need help on this one, I've put down much energy and time to solve it but... Sincerely Victor Spång Arthursson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Required files for Deployment
Hi: Do you have any documentation for the required files, registry changes, etc. for deploying MySQL with an executable developed in Delphi? Thanks, Mike Frederick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Implement a menu structure using an relative database
non data driven menus not an option? I have buit java-script menus that are pretty cool - Original Message - From: Jonathan Hilgeman [EMAIL PROTECTED] To: 'Victor Spång Arthursson' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 02, 2002 11:02 AM Subject: RE: Implement a menu structure using an relative database This might help: http://php.sitecreative.com/faq.php#3 - Jonathan -Original Message- From: Victor Spång Arthursson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 8:59 AM To: [EMAIL PROTECTED] Subject: Implement a menu structure using an relative database Hi! I'm currently working on a menu system for web pages, but I've run into some problems... What I'ld like to create is a menu which can host an infinite number of submenus. Further more, every menu should also be able to link to a specific file, though not always used. I would like to be able to get the entire menu in one sql-line, that is, I would like to be able to get the following in one line: - menu1 - menu2 - menu1 - menu2 - menu1 - menu2 * some text * some more text - menu3 - menu3 - menu3 I'm doing my scripting in PHP, but I want as much as possible of the menu structure to be only mySQL-specific. But having to use some loops to be able to create the sql-line is no problem. I desperately need help on this one, I've put down much energy and time to solve it but... Sincerely Victor Spång Arthursson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: bind-address argument
Ailes, Kevin a écrit : I have two NIC's with two different IP addresses on the machine that has the mysql server running on it. When I set up the bind-address argument(using winmysqladmin ver.1.1) under the my.ini tab to bind to specifically one of the NIC's, it appears to have registered that it is a valid argument. However, I can still connect to the database coming from the other IP network through the other NIC. Is there something I'm missing? Kevin Ailes Administrator OTTO Engineering Hello, Is routing enabled on your machine ? You should disable it. Hope this helps -- 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
Will this make a mess
In my program i first make a lot of REPLACEs (1 and even more) and immediately after that i make a SELECT on the same table. Is it posible that MySQL messes up and makes the SELECT before the last REPLACE is done? Thanks Goran - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Will this make a mess
Goran Krajacic writes: In my program i first make a lot of REPLACEs (1 and even more) and immediately after that i make a SELECT on the same table. Is it posible that MySQL messes up and makes the SELECT before the last REPLACE is done? Thanks Goran No , it is not possible, unless you use HIGH / LOW PRIORITY clauses. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 4.0.1 Linux binary won't launch
On 2002-01-02, Robert Alexander [EMAIL PROTECTED] wrote: When I go to launch, it gives me the Starting mysqld daemon with databases... etc. message. It then fails immediately with the message mysqld ended. Here's the content of the error file in the data directory: /usr/local/mysql/bin/mysqld: Fatal error: Can't find messagefile '/usr/local/mysql-4.0.1-alpha-pc-linux-gnu-i686/mysql-4.0.1-alpha-pc-lin ux-gnu-i686/share/mysql/english/errmsg.sys' Possible stupid workaround: create a symlink in /usr/local/mysql-4.0.1-alpha-pc-linux-gnu-i686/ called mysql-4.0.1-alpha-pc-linux-gnu-i686 pointing to . This way attempts to look up paths with extra mysql-4... elements will loop back to the toplevel install dir and find what they think they want. -- Hank Leininger [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
Could you look at this PHP/MySQL Code?
Hi, This is generating an error: Warning: Wrong parameter count for mysql_result() in /usr/local/www/html/matt/add.php on line 27 I can't figure out what the problem is, here is the code in question, it is part of an HTML form: --Snip connect etc.. -- // process form $sql = INSERT INTO members (first,last,position,organization,address,postal_code,county,phone,fax,e mail,website,member_type,on_directory,on_website,description,active,expi re_date) VALUES ('$first','$last','$position','$organization','$address','$postal_code', '$county','$phone','$fax','$email','$website', '$member_type','$on_directory','$on_website','$description','$active','$ expire_date'); $result = mysql_query($sql); echo Member Added\n; $sql2 = select max(member_id) from members; $member_id = mysql_query($sql2); echo $member_id; $sql3 = INSERT INTO skills (member_id, name, schooling, certifications, description) VALUES ('$member_id','$skill_name','$schooling','$certifications','$skill_descr iption'); $result = mysql_result($sql3); echo $result; ? Thanks very much Matt Rudderham Bonum volens duceris in Tartarum - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 memory problem
Hi everyone, when we execute queries through MySQL using PHP, a significant amount of memory is being used in the process. We have noticed that the memory is not being released again for several hours. Despite attempts to force it to release memory in the code, the problem is still occuring. Does anyone know anything about why this behavior may be occuring and any solutions we could try? Is this a PHP problem or a MySQL problem? Using pconnect versus connect does not appear to be the problem. Dan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Could you look at this PHP/MySQL Code?
On Wed, 2 Jan 2002 15:30:51 -0400, Matt Rudderham [EMAIL PROTECTED] wrote: | Hi, | This is generating an error: | | Warning: Wrong parameter count for mysql_result() in | /usr/local/www/html/matt/add.php on line 27 | | I can't figure out what the problem is, here is the code in question, it | is part of an HTML form: | | --Snip connect etc.. -- | // process form | | $sql = INSERT INTO members | (first,last,position,organization,address,postal_code,county,phone,fax,e | mail,website,member_type,on_directory,on_website,description,active,expi | re_date) VALUES | ('$first','$last','$position','$organization','$address','$postal_code', | '$county','$phone','$fax','$email','$website', | '$member_type','$on_directory','$on_website','$description','$active','$ | expire_date'); | $result = mysql_query($sql); | echo Member Added\n; | $sql2 = select max(member_id) from members; | $member_id = mysql_query($sql2); | echo $member_id; | $sql3 = INSERT INTO skills (member_id, name, schooling, | certifications, description) VALUES | ('$member_id','$skill_name','$schooling','$certifications','$skill_descr | iption'); | $result = mysql_result($sql3); | echo $result; | ? http://www.php.net/manual/en/function.mysql-result.php mixed mysql_result (resource result, int row, mixed [field]) Requires at least 2 arguments. Thanks, Michael -- Michael Brunson 504.473.6643 [EMAIL PROTECTED] ICQ: 83163789 --- Intercosmos Media Group, Inc. --- www.intercosmos.comwww.directnic.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: Could you look at this PHP/MySQL Code?
D'oh. Meant to call mysql_query! Thanks! - Matt Bonum volens duceris in Tartarum -Original Message- From: Michael Brunson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 3:36 PM To: Matt Rudderham Cc: [EMAIL PROTECTED] Subject: Re: Could you look at this PHP/MySQL Code? On Wed, 2 Jan 2002 15:30:51 -0400, Matt Rudderham [EMAIL PROTECTED] wrote: | Hi, | This is generating an error: | | Warning: Wrong parameter count for mysql_result() in | /usr/local/www/html/matt/add.php on line 27 | | I can't figure out what the problem is, here is the code in question, | it is part of an HTML form: | | --Snip connect etc.. -- | // process form | | $sql = INSERT INTO members | (first,last,position,organization,address,postal_code,county,phone,fax | ,e | mail,website,member_type,on_directory,on_website,description,a ctive,expi | re_date) VALUES | ('$first','$last','$position','$organization','$address','$pos tal_code', | '$county','$phone','$fax','$email','$website', | '$member_type','$on_directory','$on_website','$description','$ active','$ | expire_date'); | $result = mysql_query($sql); | echo Member Added\n; | $sql2 = select max(member_id) from members; | $member_id = mysql_query($sql2); | echo $member_id; | $sql3 = INSERT INTO skills (member_id, name, schooling, | certifications, description) VALUES | ('$member_id','$skill_name','$schooling','$certifications','$s kill_descr | iption'); | $result = mysql_result($sql3); | echo $result; | ? http://www.php.net/manual/en/function.mysql-result.php mixed mysql_result (resource result, int row, mixed [field]) Requires at least 2 arguments. Thanks, Michael -- Michael Brunson 504.473.6643 [EMAIL PROTECTED] ICQ: 83163789 --- Intercosmos Media Group, Inc. --- www.intercosmos.comwww.directnic.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
Replication errors
Anyone have any ideas as to how I should handle a case of the following error? 020102 13:27:28 Slave: Failed reading log event, reconnecting to retry, log 'db1-bin.008' position 1064155638 020102 13:27:28 Slave: connected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'db1-bin.008' at position 1064155638 020102 13:27:28 Error reading packet from server: binlog truncated in the middle of event (read_errno 0,server_errno=65535) Replication seems to have stopped at that point and the slave keeps trying to connect and dies at with that error. // database,sql,query,table Thanks, Michael -- Michael Brunson 504.473.6643 [EMAIL PROTECTED] ICQ: 83163789 --- Intercosmos Media Group, Inc. --- www.intercosmos.comwww.directnic.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: Could you look at this PHP/MySQL Code?
It's mysql_query($sql3) not mysql_result($sql3) - Jonathan -Original Message- From: Matt Rudderham [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 11:31 AM To: [EMAIL PROTECTED] Subject: Could you look at this PHP/MySQL Code? Hi, This is generating an error: Warning: Wrong parameter count for mysql_result() in /usr/local/www/html/matt/add.php on line 27 I can't figure out what the problem is, here is the code in question, it is part of an HTML form: --Snip connect etc.. -- // process form $sql = INSERT INTO members (first,last,position,organization,address,postal_code,county,phone,fax,e mail,website,member_type,on_directory,on_website,description,active,expi re_date) VALUES ('$first','$last','$position','$organization','$address','$postal_code', '$county','$phone','$fax','$email','$website', '$member_type','$on_directory','$on_website','$description','$active','$ expire_date'); $result = mysql_query($sql); echo Member Added\n; $sql2 = select max(member_id) from members; $member_id = mysql_query($sql2); echo $member_id; $sql3 = INSERT INTO skills (member_id, name, schooling, certifications, description) VALUES ('$member_id','$skill_name','$schooling','$certifications','$skill_descr iption'); $result = mysql_result($sql3); echo $result; ? Thanks very much Matt Rudderham Bonum volens duceris in Tartarum - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: PHP memory problem
This sounds like it could be a caching issue. Are you running a Windows or UNIX-based machine? Each should have methods to track what processes are using memory and how much memory they are using. - Jonathan -Original Message- From: Dan Liu [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 11:33 AM To: Subject: PHP memory problem Hi everyone, when we execute queries through MySQL using PHP, a significant amount of memory is being used in the process. We have noticed that the memory is not being released again for several hours. Despite attempts to force it to release memory in the code, the problem is still occuring. Does anyone know anything about why this behavior may be occuring and any solutions we could try? Is this a PHP problem or a MySQL problem? Using pconnect versus connect does not appear to be the problem. Dan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Could you look at this PHP/MySQL Code?
You could just do this: $result = ($sql3); echo $result; - Original Message - From: Michael Brunson [EMAIL PROTECTED] To: Matt Rudderham [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, January 02, 2002 1:35 PM Subject: Re: Could you look at this PHP/MySQL Code? On Wed, 2 Jan 2002 15:30:51 -0400, Matt Rudderham [EMAIL PROTECTED] wrote: | Hi, | This is generating an error: | | Warning: Wrong parameter count for mysql_result() in | /usr/local/www/html/matt/add.php on line 27 | | I can't figure out what the problem is, here is the code in question, it | is part of an HTML form: | | --Snip connect etc.. -- | // process form | | $sql = INSERT INTO members | (first,last,position,organization,address,postal_code,county,phone,fax,e | mail,website,member_type,on_directory,on_website,description,active,expi | re_date) VALUES | ('$first','$last','$position','$organization','$address','$postal_code', | '$county','$phone','$fax','$email','$website', | '$member_type','$on_directory','$on_website','$description','$active','$ | expire_date'); | $result = mysql_query($sql); | echo Member Added\n; | $sql2 = select max(member_id) from members; | $member_id = mysql_query($sql2); | echo $member_id; | $sql3 = INSERT INTO skills (member_id, name, schooling, | certifications, description) VALUES | ('$member_id','$skill_name','$schooling','$certifications','$skill_descr | iption'); | $result = mysql_result($sql3); | echo $result; | ? http://www.php.net/manual/en/function.mysql-result.php mixed mysql_result (resource result, int row, mixed [field]) Requires at least 2 arguments. Thanks, Michael -- Michael Brunson 504.473.6643 [EMAIL PROTECTED] ICQ: 83163789 --- Intercosmos Media Group, Inc. --- www.intercosmos.comwww.directnic.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
ODBC for newbie
Are there any odbc how-to's, tutorials, samples and/or resources I could look at? I'm new to mySQL. -Lew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Summary: bind-address argument
It helps if you restart the mysql service after you make a change! Sorry for the spam. Kevin Ailes Administrator OTTO Engineering -Original Message- From: Ailes, Kevin Sent: Wednesday, January 02, 2002 11:02 AM To: '[EMAIL PROTECTED]' Subject: bind-address argument I have two NIC's with two different IP addresses on the machine that has the mysql server running on it. When I set up the bind-address argument(using winmysqladmin ver.1.1) under the my.ini tab to bind to specifically one of the NIC's, it appears to have registered that it is a valid argument. However, I can still connect to the database coming from the other IP network through the other NIC. Is there something I'm missing? Kevin Ailes Administrator OTTO Engineering - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 memory problem
There are a couple of potential things you could change. Dan, 1. On the MySQL end, there is a configuration value or two for timing out sleeping MySQL queries - by default the timeouts are set to be 8 hours. You can make the timeouts less in my.cnf - However, be careful. You may have connections that NEED to be open that long. Think about whether you need to have persistent connections to the database. If not, then set the values lower for the following: # 14400 seconds is 4 hours, (default is 8 hours or 28800 seconds) # if you don't have the need for persistent db connections, you can set these much lower - ie. 10 minutes say, or an hour set-variable = interactive_timeout=14400 set-variable = wait_timeout=14400 2. On The Apache/PHP end - if someone presses the 'stop' button in the browser, your script won't necessary complete, which means it may hold a db connection, which means Apache/PHP won't kill the process holding the db connection. This can cause the process to hold the memory. A good way to test this is to check the number of sleeping connections (ps auwx | grep mysqld | wc -l will give you the number) and then restart your web server, and run the same command again to check the number of mysqld's. You can also run mysqladmin processlist to check this stuff. You should also make sure that in your code you are definitely closing your database connections (even if an error occurs) John Dan Liu wrote: Hi everyone, when we execute queries through MySQL using PHP, a significant amount of memory is being used in the process. We have noticed that the memory is not being released again for several hours. Despite attempts to force it to release memory in the code, the problem is still occuring. Does anyone know anything about why this behavior may be occuring and any solutions we could try? Is this a PHP problem or a MySQL problem? Using pconnect versus connect does not appear to be the problem. Dan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 4.0.1 Linux binary won't launch
Hey Hank, guess what? G It worked. Thanks for the nudge. Adding the symlink did exactly the expected things, and 4.0.1 is now launched. Now I wonder what the actual *cause* of the problem is... Thanks, buddy, all the best, /Rob At 14:27 -0500 2002/01/02, Hank Leininger wrote: On 2002-01-02, Robert Alexander [EMAIL PROTECTED] wrote: When I go to launch, it gives me the Starting mysqld daemon with databases... etc. message. It then fails immediately with the message mysqld ended. Here's the content of the error file in the data directory: /usr/local/mysql/bin/mysqld: Fatal error: Can't find messagefile '/usr/local/mysql-4.0.1-alpha-pc-linux-gnu-i686/mysql-4.0.1-alpha-pc-lin ux-gnu-i686/share/mysql/english/errmsg.sys' Possible stupid workaround: create a symlink in /usr/local/mysql-4.0.1-alpha-pc-linux-gnu-i686/ called mysql-4.0.1-alpha-pc-linux-gnu-i686 pointing to . This way attempts to look up paths with extra mysql-4... elements will loop back to the toplevel install dir and find what they think they want. -- Hank Leininger [EMAIL PROTECTED] -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ODBC for newbie
Hi, -Original Message- From: Lew Schwartz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 11:58 AM To: [EMAIL PROTECTED] Subject: ODBC for newbie Are there any odbc how-to's, tutorials, samples and/or resources I could look at? I'm new to mySQL. -Lew MyODBC Downloads: www.mysql.com/downloads/api-myodbc.html MyODBC Online Document: http://www.mysql.com/doc/O/D/ODBC.html ODBC : www.microsoft.com/data/odbc ODBC Programmer's Guide : http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbca bout_this_manual.asp Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, 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: unique problem?
[EMAIL PROTECTED] wrote: UPDATE shpr_rcvr SET directions = 'No. ' where directions = '#'; That should do it :) Thanks for the responce however it does not work. Nothing gets change probably becasue no directions columns are ='#' there are just a lot of them with '#' in the field among many characters. If it did change something I fear it would change all of the text in the columns to 'No.' which would send me into a rage. If I am missing something please let me know. And if anyone else might know how I can solve this dilema, I would appreciate the input. Richard Reina writes: I have a table shpr_rcvr that stores info about locations where things are shipped to and from. Each record has a text field called DIRECTIONS that contains directions on how to get to the location. Often in the directions column the # sign is used to help describe and exit number off the highway. For example Take I-55 south to exit # 269. When I put text with # sign in into a latex document, latex rejects it ( won't format it ). I cannot find a work around in latex so I was wondering if someone can recommend a query that will search each directions column in the table and replace # with No.. Can anyone help? Richard --- Message sent via mail archive tracking system located at http://www.mysqldeveloper.com/lists/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Code 13 when using ALTER TABLE
I'd suggest checking to see if you (or the user MySQL is running as) have the necessary permissions to alter or rename a file in that directory. /Rob At 12:16 -0800 2002/01/02, Fletcher Sandbeck wrote: This is with MySQL 3.23.42-nt on Windows 2000. I am issuing the following SQL statement and getting back an error message. ALTER TABLE Database.Table ADD COLUMN Field VARCHAR(255) error: 7, Error on rename of '.\Database\Table.MYI' to '.\Database\#sql2-538-1.MYI' (Errcode: 13) A CHECK TABLE of the table says that it is OK, but a REPAIR TABLE reports an error '13 when fixing table' and 'Operation Failed' as the final status. Any ideas of what is going wrong? [fletcher] -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Code 13 when using ALTER TABLE
I have been getting this same error. I am not able to Alter or Drop Tables. I am definately sure that I have the necessary permissions. This has happened on all of my recent installs of MySQL on windows XP and 2000 advanced server. I would appreciate any knowlege on this matter. Getting tired of shutting down the server and deleting the tables just to alter a feild. Thanks, Stephen Rainey -Original Message- From: Robert Alexander [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 12:33 PM To: Fletcher Sandbeck Cc: [EMAIL PROTECTED] Subject: Re: Error Code 13 when using ALTER TABLE I'd suggest checking to see if you (or the user MySQL is running as) have the necessary permissions to alter or rename a file in that directory. /Rob At 12:16 -0800 2002/01/02, Fletcher Sandbeck wrote: This is with MySQL 3.23.42-nt on Windows 2000. I am issuing the following SQL statement and getting back an error message. ALTER TABLE Database.Table ADD COLUMN Field VARCHAR(255) error: 7, Error on rename of '.\Database\Table.MYI' to '.\Database\#sql2-538-1.MYI' (Errcode: 13) A CHECK TABLE of the table says that it is OK, but a REPAIR TABLE reports an error '13 when fixing table' and 'Operation Failed' as the final status. Any ideas of what is going wrong? [fletcher] -- Robert Alexander ([EMAIL PROTECTED]) 416-823-6599 http://www.workmate.ca WWW Database Applications and Web Hosting Searchable MySQL List Archive: http://archive.workmate.ca/myarchive - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MyISAM/InnoDB/Oracle comparison, and a InnoDB table locking question
On Wed, Dec 26, 2001 at 04:23:46PM -0600, Philip Molter wrote: Are there guides out there for configuring these things? What is a big enough log file? Honestly, on a lot of stuff, I'm just guessing, but it takes a lot of time to fiddle with values, clean out the database, and then shove in 1 million rows to see the results. I haven't found any really good guidelines but I'm told if you pay for support then the developpers would be more than glad to work out some optimal values for your data set. -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) http://www.fibrespeed.net/~mbabcock/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 in MySQL-4.0.1
On Thu, Dec 27, 2001 at 06:56:03PM +0200, Heikki Tuuri wrote: * Recovery has been made more resilient to corruption of log files. Can I ask what you mean here? If the log files are corrupt, is recovery still possible then? Or are the log files themselves less likely to get corrupted? I'm assuming the former, but I'm curious. -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) http://www.fibrespeed.net/~mbabcock/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Code 13 when using ALTER TABLE
On 1/2/02 at 3:32 PM, Robert Alexander wrote: I'd suggest checking to see if you (or the user MySQL is running as) have the necessary permissions to alter or rename a file in that directory. Some additional details. I can usually perform at least one ADD COLUMN successfully before I start getting this error. I also seem to be able to create databases and tables without a problem. This leads me to believe that th permissions are set properly. Once I get the error, I can't perform any more ALTER TABLE commands, but I am still able to search the database without any problems. CHECK TABLE reports that the table is OK until I perform a REPAIR TABLE command, after that CHECK TABLE reports that the last REPAIR TABLE failed. Restarting the MySQL service seems to correct whatever is wrong with the table and I am then able to do ADD COLUMN again (usually one successful call, then errors on subsequent calls). [fletcher] Original Message At 12:16 -0800 2002/01/02, Fletcher Sandbeck wrote: This is with MySQL 3.23.42-nt on Windows 2000. I am issuing the following SQL statement and getting back an error message. ALTER TABLE Database.Table ADD COLUMN Field VARCHAR(255) error: 7, Error on rename of '.\Database\Table.MYI' to '.\Database\#sql2-538-1.MYI' (Errcode: 13) A CHECK TABLE of the table says that it is OK, but a REPAIR TABLE reports an error '13 when fixing table' and 'Operation Failed' as the final status. Any ideas of what is going wrong? [fletcher] -- Fletcher Sandbeck [EMAIL PROTECTED] Lasso Product Specialist [EMAIL PROTECTED] Blue World Communications, Inc. http://www.blueworld.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: unique problem?
I think this is more what you are looking for UPDATE shpr_rcvr SET directions = REPLACE(directions,'#','No. ' where directions = '#'; -Original Message- From: Richard Reina [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 5:26 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: unique problem? [EMAIL PROTECTED] wrote: UPDATE shpr_rcvr SET directions = 'No. ' where directions = '#'; That should do it :) Thanks for the responce however it does not work. Nothing gets change probably becasue no directions columns are ='#' there are just a lot of them with '#' in the field among many characters. If it did change something I fear it would change all of the text in the columns to 'No.' which would send me into a rage. If I am missing something please let me know. And if anyone else might know how I can solve this dilema, I would appreciate the input. Richard Reina writes: I have a table shpr_rcvr that stores info about locations where things are shipped to and from. Each record has a text field called DIRECTIONS that contains directions on how to get to the location. Often in the directions column the # sign is used to help describe and exit number off the highway. For example Take I-55 south to exit # 269. When I put text with # sign in into a latex document, latex rejects it ( won't format it ). I cannot find a work around in latex so I was wondering if someone can recommend a query that will search each directions column in the table and replace # with No.. Can anyone help? Richard --- Message sent via mail archive tracking system located at http://www.mysqldeveloper.com/lists/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Automated Failover
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi! I'm currently in the preliminary planning phases of a content delivery system. We will be generating pdfs on the fly containing our member's statements. The system will be accessible both from our internal systems and through our web-banking portal. As we hope to eventually migrate a large percentage of our membership away from paper statements entirely (with their permission of course:) it is of paramount importance that the system be available 24/7 with as little downtime as possible (I personally am shooting for 99.99% uptime, but I've only told management we can do 97-99%:) due to regulatory snd disclosure issues. Due to budget restraints (and the fact that I'm sick of every system here being a proprietary, closed source system that I can't even configure without the vendor holding my hand because they refuse to document anything) I've decided to implement the system using Linux and mySQL. For the most part, the design is looking good... We'll be replicating the statements database among several slaves, and there are several front-end machines serving up the pdfs. I think I've eliminated almost all the single points of failure I feasibly can... except for the database master. It's important that I can eliminate this as a point of failure, because for auditing purposes every access must be logged, and to make it easier to produce activity reports and the like, I'd like to store it in the database. Unfortunately, this means there has to be a write every time a member or staff look at a statement. I've been playing with some ideas on how to have the slaves arbitrate amongst themselves and take over as master in case the master does go down. I've also heard that automated failover is supposed to be in 4.x at some point as well. I was wondering if anyone else had any example scripts/code/software, etc to do this that they'd be willing to share. Or should I wait for it to get into 4.x (my launch deadline is 6/30/02)? Sorry about the long-winded post, but any help would be greatly appreciated. *** Gregory M. Symons Systems Analyst Research Federal Credit Union [EMAIL PROTECTED] 1-800-967-7929, ext 1234 -BEGIN PGP SIGNATURE- Version: PGP 7.1 iQA/AwUBPDN6DeK6A2HNDZlBEQJ8KQCg4TNrvPiBehQfsDOSaMOzcbBiRRoAmwch 6/QmTDL+sbj1FxwFB7iIjeEu =7+IY -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql
mysql database - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
mysql database - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Largeest System
Hi, Simple question. What is the largest hardware implementation that is know for mysql to run on? How well does mysql scale on large platform systems such as Sun E10k, HP Superdome as an example. -- *** Phillip B. Bruce *** *** http://pbbruce.home.mindspring.com *** *** [EMAIL PROTECTED] *** *** *** *** Have you ever noticed? Anybody going slower than*** *** you is an idiot, and anyone going faster than you*** *** is a maniac. - George Carlin*** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
minimum requirements for this situation
I am developing a web-based mysql platform on Red Hat linux 7.2. The server will host apache as well, but it is only for development purposes, and I am the sole developer. Mysql and apache will be the only services running besides minimum OS requirements. What can I get away with while not having to bite my nails and rail at how slow the server is? I have a 233mhz system lying around, but I can probably slap together a 400mhz with some spare parts. Kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Largest System
Phillip B. Bruce writes: Simple question. What is the largest hardware implementation that is know for mysql to run on? How well does mysql scale on large platform systems such as Sun E10k, HP Superdome as an example. I would suppose that the number of possible file descriptors and table locking would prevent MyISAM from scaling well with the number of tables (given that you have a fairly constant [number of table and amount of data] per CPU.) InnoDB ought to fare better. This is just speculation, but I, too, would be interested in seeing some real-life examples of MySQL running on high-end machines. //C -- 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
configure problems on Solaris 2.6
configure:1592: checking whether the C++ compiler (c++ ) works configure:1608: c++ -o conftest conftest.C 15 ld: fatal: library -lstdc++: not found ld: fatal: File processing errors. No output written to conftest {root}blinky:~ ls -l /usr/local/lib/libstdc++.a.2.10.0 -rw-r--r-- 1 root root 2153936 Dec 30 16:57 /usr/local/lib/libstdc++.a.2.10.0 {root}blinky:~ {root}blinky:/usr/local/src/mysql-3.23.47 export | grep LD declare -x LD_LIBRARY_PATH=/usr/local/lib:/usr/lib {root}blinky:/usr/local/src/mysql-3.23.47 What am I missing? __ fil krohnengold network systems administrator american museum of natural history [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
3.23.47 compile problems with sun's forte compiler
I just downloaded the 3.23.47 source for mysql, and I tried to compile it using Sun's Forte Compiler (6.2) however when trying to build libmysql/hash.c I got the following error. /opt/SUNWspro/bin/cc -DDEFAULT_CHARSET_HOME=\/opt/mysql/3.23.44\ -DDATADIR=\/opt/mysql/3.23.44/var\ -DSHAREDIR=\/opt/mysql/3.23.44/share/mysql\ -DUNDEF_THREADS_HACK -DDONT_USE_RAID -I./../include -I../include -I./.. -I.. -I.. -O -DDBUG_OFF -Xa -dalign -fns -fsimple=2 -fsingle -ftrap=%none -nofstore -xbuiltin=%all -xlibmil -xO5 -xO4 -xtarget=ultra2 -xstrconst -mt -DHAVE_CURSES_H -I/opt/tmp/mysql-3.23.47/include -DHAVE_RWLOCK_T -c hash.c -KPIC -DPIC -o hash.o hash.c, line 189: reference to static variable hash_key in inline extern function hash.c, line 229: cannot recover from previous errors cc: acomp failed for hash.c *** Error code 1 I took a look at the file and noticed the inline byte* line. I compared that with the hash.c from the 3.23.44 build and noticed that the .44 build didn't have the inline there, so I took it out and it's gotten past that part. Not sure if this is a bug in configure, compile, code, or what. Anyone know if this was the right thing to do, or if there is a fix for it. --shak -- Shakeel Sorathia Systems Administrator (626) 660-3502 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 in MySQL-4.0.1
Hi! On Thu, Dec 27, 2001 at 06:56:03PM +0200, Heikki Tuuri wrote: * Recovery has been made more resilient to corruption of log files. Can I ask what you mean here? If the log files are corrupt, is recovery still possible then? Or are the log files themselves less likely to get corrupted? I'm assuming the former, but I'm curious. A good question. InnoDB cannot repair a corrupt log file because I have not activated log mirroring. But the problem was that in two cases people reported an assertion failing in roll-forward of the log. I have added two things alleviate the problem: * There are now assertions which check that the data is ok when a log record is written to the log buffer of InnoDB. These assertions eliminate the possibility that the corruption of log files actually is caused by some bug in InnoDB, or some random memory corruption. * Roll-forward does not assert any more, but prints a warning message, and ends the log scan. Even if there is log corruption, if you are lucky you can get a consistent version of the database, or maybe you need dump and reimport some tables. I do not know what caused the log corruption. In one case it may have been the buggy I/O system of Linux 2.5.1. After reboot the database recovered ok. This suggests the Linux file cache was corrupt, but the data on disk was ok. Generally, corrupt log files, like corrupt data files, require recovery from a backup to restore the database. -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) http://www.fibrespeed.net/~mbabcock/ Regards, Heikki Innobase Oy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Full Search
I have a mySQL table which has about 15 fields. Is it possible using a standard SQL statement to do a full text search on all fields ?? Please advise Thanks, Neil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FOREIGN KEYs and ALTER TABLE
With InnoDB tables under 3.23.4x, if you perform an ALTER TABLE on a table, any foreign key declarations that point to that table fail to work (they always return a failure). Is this a known bug? I don't see it on the InnoDB todo or bug list, but I seem to remember hearing about it already. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [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
Question about Fulltext searches/GWS_IDF
I checked the archives for this list and saw that in 2000 Sergei recommended changing GWS_IN_USE to GWS_IDF to disable the 50% weighting mechanism. The MySQL manual, however says to change it from GWS_PROB to GWS_FREQ. I'm inclined to go with the developer instead of documentation ;), but I'm wondering why the discrepancy? -- Shane Allen [EMAIL PROTECTED] sell.com : Buy Sell Anything http://www.sell.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: configure problems on Solaris 2.6
A link from .a.2.10.0 to just '.a'? so that e.g. {root}blinky:~ ls -l /usr/local/lib/libstdc++.a -rw-r--r-- 1 root root 2153936 Dec 30 16:57 /usr/local/lib/libstdc++.a - libstdc++.a.2.10.0{root}blinky:~ ls -l /usr/local/lib/libstdc++.a.2.10.0 -rw-r--r-- 1 root root 2153936 Dec 30 16:57 /usr/local/lib/libstdc++.a.2.10.0 -Original Message- From: Fil Krohnengold [mailto:[EMAIL PROTECTED]] Sent: Thursday, 3 January 2002 11:17 a.m. To: [EMAIL PROTECTED] Subject: configure problems on Solaris 2.6 configure:1592: checking whether the C++ compiler (c++ ) works configure:1608: c++ -o conftest conftest.C 15 ld: fatal: library -lstdc++: not found ld: fatal: File processing errors. No output written to conftest {root}blinky:~ ls -l /usr/local/lib/libstdc++.a.2.10.0 -rw-r--r-- 1 root root 2153936 Dec 30 16:57 /usr/local/lib/libstdc++.a.2.10.0 {root}blinky:~ {root}blinky:/usr/local/src/mysql-3.23.47 export | grep LD declare -x LD_LIBRARY_PATH=/usr/local/lib:/usr/lib {root}blinky:/usr/local/src/mysql-3.23.47 What am I missing? __ fil krohnengold network systems administrator american museum of natural history [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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
backup table required permissions
Hello, I've searched both the documentation and the mailing list archives but can't find the answer to this question (although several people seem to have asked it). Here goes: What permission grants are required to allow use of the backup table tablename to 'path' command? I can execute the command as root, but never as a non-root user, even when that user has grant all on db.* to username@localhost, and show grants verifies those permissions. I can successfully execute mysqlhotcopy as that non-root user, but have never gotten backup table to work. Any information would be appreciated. I would much prefer to use backup table so that I can execute the sql from within my existing application w/o requiring that perl be installed. Regards, Rob __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.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
Patch for mysql_hotcopy
I'd like to submit small a patch for mysql_hotcopy. I don't know where to go with it. I'm assuming if it's worth anything, it'll get picked up from here and stuffed in. I'm sure others have so many tables that would max out cp's argument list :) 422a423,430 # the array size block below helps eliminate Argument list too long if ($#files 127) { my @this; while ($#files 127) { @this = splice(@files, 0, 127); eval { copy_files($opt{method}, \@this, $rdb-{target} ); }; }; } I've also added a tar method to mysqlhotcopy. I can submit a patch for that if it is appropriate. Thanks, -Troy Bowman, ArosNet Systems Administration - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
an example INSERT statement
Hello, I'm having some trouble constructing my first INSERT statement into multiple tables. I'm using PHP4. I have written the following INSERT statement with no problems: $sql = INSERT INTO main (name, ext, stor_pre, stor_base, width, height, file_size, proj_id, date_cre, cre_by, division) VALUES ('$name', '$ext', '$stor_pre', '$stor_base', '$width', '$height', '$file_size', '$proj_id', '$date_cre', '$cre_by', '$division'); This inserts the variables as values into the designated columns of the table main. But I have expanded my database, restructuring it so that it no longer uses one table (main). These various columns are now distributed across five different tables. If I were to SELECT data from these tables, I would use a join statement. How would I go about writing an INSERT statement that joins several different tables together? Even a pointer to where I can find this info would be helpful. The INSERT syntax page in the official documentation (http://www.mysql.com/doc/I/N/INSERT.html) doesn't address this specific circumstance, or if it does then I'm too dense to figure it out. Thanks! Erik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
wierd compile loop - 3.23.47 on solaris 2.6 - gcc 2.95.3
My compile seems to have stuck itself in a loop - just wondering if this is normal - it's been over 90 minutes on: make[2]: Entering directory `/local/src/mysql-3.23.47/libmysql' /bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -DHAVE_RWLOCK_T -o libmysqlclient.la -rpath /usr/local/lib/mysql -version-info 10:0:0 [...] All the gcc process seems to be doing is creating and deleting files in /tmp with this as their contents: int main() { return 0; } I tried killing the compile and restarting it - it reached this point and started looping again. This is a fresh solaris 2.6 install with gcc2.95.3 compiled from a binary gcc2.95.2 - no options passed to configure. What could I have broken? -fil -- fil krohnengold network systems administrator american museum of natural history [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: SubSelect Workaround help
Hi Paul, There is no direct way to make a string by concatinating strings of different columns. But your problem can be solved in a different way. select distinct p.symbol, i.name from portfolio p, portfolio pp, stockinfo i where pp.type = '401k' AND pp.owner = 'jim' and p.symbol = i.symbol and p.symbol = pp.symbol order by p.symbol; Hope it works for you Anvar At 02:29 PM 02/01/2002 +, you wrote: How would one load the results of the following query into a one line comma separated list so that it could be then included with an IN expr to get around the lack of subselect in MySQL select distinct symbol from portfolio where type='401k' AND owner='jim' select distinct p.symbol, i.name from portfolio p, stockinfo i where p.symbol = i.symbol and p.symbol in (string name) order by symbol Thanks. Happy New Year Paul _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ORDER BY total of multiple columns?
Hi, I have a mysql table with columns pts_t2, pts_ext and pts_other which hold each player's point total for that category. I have it displaying player's ranks by ordering by each of those points. However, I would like to have an overall ranking (all categories combined), and I don't want to add another column to just hold a total of these 3 columns. How can I order my select statement to list the players by order of their total points? Thanks --- Andrew Culver Level 2 DCI Judge Comp Sci 2 at UWO The frontline is everywhere. --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
database,
database,sql,query,table I am new to phpmyadmin, I need to make a db for a online job resume service site. This site is like hotjobs but people can also attach photos. I need some direction on where to start on this project. Thanks __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: database,
On Wed, 2 Jan 2002 21:00:59 -0800 (PST), help used a few recycled electrons to form: | database,sql,query,table | | | | | I am new to phpmyadmin, I need to make a db for a | online job resume service site. This site is like | hotjobs but people can also attach photos. I need some | direction on where to start on this project. http://www.mysql.com/training/index.html :-) Jeremy would love to see you there! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Limit
I'm new to mysql/sql thing thus mysql can efficiently handles a database even it has a hundred tables thanks in advance Arvin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Query problem
Y send a mysql request : INSERT INTO akoview_info (FALL_NR,PAT_NR,NAME,VORNAME,GEB_DAT,DIAG_ART,BEFUND_NAME,UNTERSUCH_DAT,WR_I D,WR_YEAR,WRIDX_ID,WR_QUART,BEHAND_MED,P_UID,S_UID)VALUES('01213658','546456 897','X','Aaaa','1953-12-10','5','F:\devkunde\SENDTNER\BD\20013\1\010027 92.001','2001-11-29','124501','2001','12345698741','214','Dr. med. Prout','0','0') but the field BEFUND_NAME isn't good. When y read the field it contains :F:devkundeSENDTNERBD200131 Please help me y don't understand !!! Thank Thomas Wolff - Akosystem Am Tiefen Weg 17b 76547 Sinzheim Email: mailto:[EMAIL PROTECTED] Telefon: +49 (0) 7221 / 98 78 40 Fax: +49 (0) 72 21/98 78 42 Handy France : +33 (0)6 84 20 50 86 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 problem
The following should work. INSERT INTO akoview_info (FALL_NR,PAT_NR,NAME,VORNAME,GEB_DAT,DIAG_ART,BEFUND_NAME,UNTERSUCH_DAT,WR_I D,WR_YEAR,WRIDX_ID,WR_QUART,BEHAND_MED,P_UID,S_UID)VALUES('01213658','546456 897','X','Aaaa','1953-12-10','5','F:\\devkunde\\SENDTNER\\BD\\20013\\1\\010027 92.001','2001-11-29','124501','2001','12345698741','214','Dr. med. Prout','0','0') --- thomas WOLFF [EMAIL PROTECTED] wrote: Y send a mysql request : INSERT INTO akoview_info (FALL_NR,PAT_NR,NAME,VORNAME,GEB_DAT,DIAG_ART,BEFUND_NAME,UNTERSUCH_DAT,WR_I D,WR_YEAR,WRIDX_ID,WR_QUART,BEHAND_MED,P_UID,S_UID)VALUES('01213658','546456 897','X','Aaaa','1953-12-10','5','F:\devkunde\SENDTNER\BD\20013\1\010027 92.001','2001-11-29','124501','2001','12345698741','214','Dr. med. Prout','0','0') but the field BEFUND_NAME isn't good. When y read the field it contains :F:devkundeSENDTNERBD200131 Please help me y don't understand !!! Thank Thomas Wolff - Akosystem Am Tiefen Weg 17b 76547 Sinzheim Email: mailto:[EMAIL PROTECTED] Telefon: +49 (0) 7221 / 98 78 40 Fax: +49 (0) 72 21/98 78 42 Handy France : +33 (0)6 84 20 50 86 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php = Aravind Gorthy, VisualSoft Technologies. Download Logos, Picture Messages Ringtones for your mobile phone Visit http://mobile.yahoo.co.in - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MyODBC leaking handles...
Hi again, From what I can see, when the driver is unloaded (I guess when my application is shut down) it releases all handles again. But the init shouldn't take 800.000 handles over time right? :) / Jens -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: den 19 december 2001 20:01 To: Jens Collin; [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 3:05 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi again, Some more information; OS: Windows 2000 Professional, SP2a + all patches mySQL 3.32.46 (windows version) myODBC 2.50.37 I open then database, do a select, close the recordset and finally close the database. This results in 2 handles increase. (Notised in windows task manager) If I loop this test, the handles counter just goes through the roof. over 800.000 handles over one night! I have done the exact same test with MS SQL Server 7.0 and 2000, no missing handles. This works for oracle's drivers as well. I guess that a trace can be useful? However, I should upload it to your FTP right? (If I read the manual right :)) I'll be happy to assist you with any data needed, just let me know what to send. Thanks for the feedback. I will look into it immediately. When I tested with PURIFY, I couldn't find any leaks. Let me do a cross check again. Another small note, might be useful. There are some open resources allocated for the driver during the initialization, and will be freed only upon termination or unloading of driver from memory. So, does this happen even after terminating the application in the proper sequence of calls ? No need of any trace right now, if needed I will ask you. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: den 18 december 2001 19:38 To: Jens Collin; [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 4:22 AM To: '[EMAIL PROTECTED]' Subject: MyODBC leaking handles... Hi all, This is my first post in this forum. I've tried to find something in the documentation but failed. I cannot find out why the ODBC driver is leaking 1 handle for each request that I do! It doesn't matter if I close it or whatever I do. Anyone that knows what to do? Any hints or tips? Recently we found the leaks in the initialization towards UNIX, and fixed them from driver and server, but we didn't find any thing from Windows (The Unix fixes will be there for 2.50.40 and 3.51.01) Windows 2000 Professional MySQL 3.23 MyODBC 2.50.39 Can you be more specific on this, please ? If you can send the leaks statistics, it will be a great help. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com Regards, ___ Jens A. Collin Envox Technical System Developer Envox Group Söder Mälarstrand 43 118 25 Stockholm Sweden Office: +46 (0)8 56 256 000 Fax : +46 (0)8 56 256 050 [EMAIL PROTECTED] http://www.envox.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: Query Problem.
Why don't you try like this. F:\\devkunde\\SENDTNER\\ '\' is escape character. so you must use '\\' to insert '\'. Homepage = http://www.nnr.or.kr/inos/ ICQ # = 123534385 Member of DSN(database.sarang.net), NNR(nnr.or.kr) --MIME Multi-part separator-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php