is MySQL relational?
Is MySQL a relational database? If yes, how is implemented a one to one and one to many relation? Makis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
pls. help me?
hi pls. help me , how to update 2 tables like this sql update table1 set table1.fld2 = table1.fld2 where table1.fld1 = table2.fld1 senthil.r _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
Hi If I'd like to upgrade LH 6.2 to LH 7.0+. Would my old data (LH setting, MySQL db) lost? No, but it is mandatory to make a backup (you should do on a regular basis even for a normal use, and obviously you MUST do it before a major upgrade - dump your databases and tar your /etc dir, al least). Many things are going to change, however. First of all, inetd is abandoned in favour of xinetd which is easier to configure but different. Also, many more packages are now compiled with the hosts.allow/hosts.deny support (don't spend too much time asking yourself why sendmail refuses connections, as I did). When you're upgrading choose to customize the packets you have to upgrade and unckeck MySQL. You will upgrade it yourself manually with a fresh version from the MySQL site (RedHat wants to replace your binaries with its ones, which are packaged differently) Don't install anything earlier tha version 7.2. Also, DON'T forget to patch your distribution with anything you can find from the RedHat support site. I would also suggest to download and install the latest kernel. I could easily upgrade my local system, but with a remote one i choosed to wait. If you don't want to upgrade now a (temporary?) solution is to upgrade just your gcc compiler (and NOT glibc) and rebuild the rpms from MySQL sources. This is a hint received from James C. McDonald (thanks a lot James!!): -- 1. downloaded the gcc-2.95.2-1i.src.rpm from http://rpmfind.net/linux/RPM/ (yes I know it's from a PPC distribution, but Yellow Dog is based on RedHat) [*] 2. built i386 rpms for gcc-2.95-2 by # rpm --rebuild gcc-2.95.2-1i.src.rpm on a RH 6.2 box [**] 3. on a test RH 6.2 system I removed egcs and installed the gcc-2.95-2 rpms I just built (or at least a subset of them (you need to install gperf-2.7-6.i386.rpm if it is not already installed) # rpm -e egcs-c++-1.1.2-30 # rpm -e egcs-objc-1.1.2-30 # rpm -e egcs-1.1.2-30 # rpm -e cpp-1.1.2-30 # rpm -ivh cpp-2.95.2-1i.i386.rpm # rpm -ivh gcc-2.95.2-1i.i386.rpm # rpm -ivh libstdc++-2.10.0-1i.i386.rpm # rpm -ivh gcc-c++-2.95.2-1i.i386.rpm # rpm -ivh gperf-2.7-6.i386.rpm you should now have gcc 2.95.2 installed # gcc -v Reading specs from /usr/lib/gcc-lib/i386-pc-linux/2.95.2/specs gcc version 2.95.2 19991024 (release/franzo) At this point, if you want, you can also --rebuild gcc 2.96, which requires binutils-2.11 (have to --rebuild this, also). 4. Now try to build the MySQL rpm's # rpm --rebuild MySQL-3.23.49-1.src.rpm now completes successfully giving ... -rw-r--r--1 root root 6288340 Mar 5 12:59 MySQL-3.23.49-1.i386.rpm -rw-r--r--1 root root 1397099 Mar 5 12:59 MySQL-Max-3.23.49-1.i386.rpm -rw-r--r--1 root root 690350 Mar 5 12:59 MySQL-bench-3.23.49-1.i386.rpm -rw-r--r--1 root root 1766978 Mar 5 12:59 MySQL-client-3.23.49-1.i386.rpm -rw-r--r--1 root root 622278 Mar 5 12:59 MySQL-devel-3.23.49-1.i386.rpm -rw-r--r--1 root root 234505 Mar 5 12:59 MySQL-shared-3.23.49-1.i386.rpm I haven't tested the functionality of the build yet, but at least it builds without error. [***] -- [*] You'll have to look directly into the Yellow Dog ftp site since rpmfind links are broken. [**] You need to have texinfo installed to build gcc (this package is on your RedHat CD) [***] I've tested it just a little but it really looks like it's working pretty well!!! My mysql binaries have been built with gcc 2.96 (but with gcc 2.95 it should work the same). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Changing Default for Not Null to NOTHING
David, Thursday, March 07, 2002, 7:22:49 PM, you wrote: DMP Is there a way for me to NOT have a default value for a column in a table DMP that I define as NOT NULL? DMP EXAMPLE SQL: DMP mysql CREATE TABLE FOO (foo1 int NOT NULL); DMP Query OK, 0 rows affected (0.05 sec) DMP mysql DESCRIBE FOO; DMP +---+-+--+-+-+---+ DMP | Field | Type| Null | Key | Default | Extra | DMP +---+-+--+-+-+---+ DMP | foo1 | int(11) | | | 0 | | DMP +---+-+--+-+-+---+ DMP 1 row in set (0.00 sec) DMP mysql DMP I don't want the default to be 0 (zero) Any ideas? Specify another default value in CREATE TABLE. foo1 INT NOT NULL DEFAULT 1; -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
is MySQL relational?
savaidis, Friday, March 08, 2002, 4:21:09 AM, you wrote: s Is MySQL a relational database? s If yes, how is implemented a one to one and one to many relation? To define the relation between tables use foreign keys: http://www.mysql.com/doc/A/N/ANSI_diff_Foreign_Keys.html http://www.mysql.com/doc/e/x/example-Foreign_keys.html http://www.mysql.com/doc/S/E/SEC445.html s Makis -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
Reset the root Password in MySQL
Alex, Thursday, March 07, 2002, 7:18:13 PM, you wrote: AL I have just installed MySQL recently. I already set the root password and AL some databases testing and everything worked fine. However, I accidentally AL changed the root to anonymous yesterday. After that, I couldn't add new AL users and do some administration tasks even change password myself. AL In the website: http://www.bitbybit.dk/mysqlfaq/faq.html , I found FAQ to AL try to solve my problem. AL I quote the instruction as follows:- AL AL reset the root password? AL The following procedure will help you reset the root password. Note that AL while you are doing this, the server is totally open and gives everybody AL full access to all databases. AL Stop the server AL Restart the server with the command-line option -Sg or --skip-grant-tables AL You can now log in to the server without a password. So can anyone else! AL Reset the root password with the command AL mysql - GRANT ALL PRIVILEGES ON *.* TO root@localhost AL - IDENTIFIED BY the_new_password AL Exit the client AL Immediately thereafter, shut down and restart the server as usual. AL AL However, I tried many times. I found only if I restart the server AL with --skip-grant-tables option, the server will promt out ERROR 1047: AL Unknown Command when I type GRANT ALL PRIVILEGES ON *.* TO AL root@localhost IDENTIFIED BY the_new_password; If you start mysqld with --skip-grant-tables option you should execute FLUSH PRIVILEGES command _before_ using GRANT statement. It is covered in the manual, look at: http://www.mysql.com/doc/R/e/Resetting_permissions.html -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
New to mysql .. how to start it
amol, Friday, March 08, 2002, 9:53:04 AM, you wrote: as I am very much new to mysql. We have installed it in machine but I as don't know how to start it and what's it's default user to connect. I as am still stuck at $ prompt..entering command It is covered in the manual, please check the following links. What is your OS? Windows: http://www.mysql.com/doc/W/i/Windows_server_first_start.html http://www.mysql.com/doc/W/i/Windows.html *nix: http://www.mysql.com/doc/P/o/Post-installation.html http://www.mysql.com/doc/C/o/Connecting-disconnecting.html The default user is 'mysql' with no password. I suggest you to change password. How to change password for 'root' and add new user you can find at: http://www.mysql.com/doc/U/s/User_Account_Management.html as Amol -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
pls. help me?
senthil, Friday, March 08, 2002, 10:51:51 AM, you wrote: s pls. help me , how to update 2 tables like this sql s update table1 set table1.fld2 = table1.fld2 where table1.fld1 = table2.fld1 MySQL doesn't currently support multi-table UPDATE statement. It is in our plans to support this in future: http://office.ensita.net/mysql/doc/N/u/Nutshell_4.1_development_release.html s senthil.r -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: MySQL Server uptime.
Neil Silvester wrote: The server is a lightning fast Pentium Pro 90 with 32 MB EDO RAM and RedHat 7.0. So anyone who still says that the MySQL database can't cut the mustard, obviously hasn't tried. Mysql 3.23.43 Up 212 days, Processed 199,654 queries (average = 0.01/sec) For comparison: Pentium II/233, 96MB RAM, RedHat 6.2 MySQL 3.23.41 (replicating to an identical system for resiliancy). Uptime: 7 days 21 hours 17 min 3 sec Threads: 3 Questions: 897638362 Slow queries: 2 Opens: 16 Flush tables: 1 Open tables: 9 Queries per second avg: 1317.300 imho MySQL definitely *can* cut the mustard. My client decided to do a stability test on the above system, so he set it processing, then just pulled the plug out. The system needed some serious fsck-ing when he reapplied the power, but MySQL restarted automatically - and processing continued more-or-less exactly from where it left off! Recently, they had a power outage during the weekend. It wasn't until Monday afternoon that anyone noticed that the MySQL host had been down, and then only because Apache had failed to restart. Now *that's* impressive!! I just love software that just works, and works, and works (takes a licking and keeps on ticking, etc). Thanks MySQL AB! :-) Regards Bob Cross. database, sql, table, query, * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It is not an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability is accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses. You should check for viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability is accepted in relation to those sites. This Company randomly monitors its e-mail system (including incoming e-mails) for operational purposes. Scottish Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: Any news on embedded feature for MySql Windows version ?
Month ago I posted question about embedded database feature missing from MySql 4.0.1 Windows build. It seems that the feature is still not out there. Are there any news regarding this? Regards, Miroslav Rajcic - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Why v3.23.49 does not build on RedHat 6.2 ?????
Hi. I have question. U have RH6.2 Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) can i build mysql 3.23.49 from src.rpm with this gcc ? Or i must it do with 2.96 ? Thanks a lot. I. Piasecki. - Original Message - From: Gabriele Carioli [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Friday, March 08, 2002 10:06 AM Subject: Re: Why v3.23.49 does not build on RedHat 6.2 ? Hi If I'd like to upgrade LH 6.2 to LH 7.0+. Would my old data (LH setting, MySQL db) lost? No, but it is mandatory to make a backup (you should do on a regular basis even for a normal use, and obviously you MUST do it before a major upgrade - dump your databases and tar your /etc dir, al least). Many things are going to change, however. First of all, inetd is abandoned in favour of xinetd which is easier to configure but different. Also, many more packages are now compiled with the hosts.allow/hosts.deny support (don't spend too much time asking yourself why sendmail refuses connections, as I did). When you're upgrading choose to customize the packets you have to upgrade and unckeck MySQL. You will upgrade it yourself manually with a fresh version from the MySQL site (RedHat wants to replace your binaries with its ones, which are packaged differently) Don't install anything earlier tha version 7.2. Also, DON'T forget to patch your distribution with anything you can find from the RedHat support site. I would also suggest to download and install the latest kernel. I could easily upgrade my local system, but with a remote one i choosed to wait. If you don't want to upgrade now a (temporary?) solution is to upgrade just your gcc compiler (and NOT glibc) and rebuild the rpms from MySQL sources. This is a hint received from James C. McDonald (thanks a lot James!!): -- 1. downloaded the gcc-2.95.2-1i.src.rpm from http://rpmfind.net/linux/RPM/ (yes I know it's from a PPC distribution, but Yellow Dog is based on RedHat) [*] 2. built i386 rpms for gcc-2.95-2 by # rpm --rebuild gcc-2.95.2-1i.src.rpm on a RH 6.2 box [**] 3. on a test RH 6.2 system I removed egcs and installed the gcc-2.95-2 rpms I just built (or at least a subset of them (you need to install gperf-2.7-6.i386.rpm if it is not already installed) # rpm -e egcs-c++-1.1.2-30 # rpm -e egcs-objc-1.1.2-30 # rpm -e egcs-1.1.2-30 # rpm -e cpp-1.1.2-30 # rpm -ivh cpp-2.95.2-1i.i386.rpm # rpm -ivh gcc-2.95.2-1i.i386.rpm # rpm -ivh libstdc++-2.10.0-1i.i386.rpm # rpm -ivh gcc-c++-2.95.2-1i.i386.rpm # rpm -ivh gperf-2.7-6.i386.rpm you should now have gcc 2.95.2 installed # gcc -v Reading specs from /usr/lib/gcc-lib/i386-pc-linux/2.95.2/specs gcc version 2.95.2 19991024 (release/franzo) At this point, if you want, you can also --rebuild gcc 2.96, which requires binutils-2.11 (have to --rebuild this, also). 4. Now try to build the MySQL rpm's # rpm --rebuild MySQL-3.23.49-1.src.rpm now completes successfully giving ... -rw-r--r--1 root root 6288340 Mar 5 12:59 MySQL-3.23.49-1.i386.rpm -rw-r--r--1 root root 1397099 Mar 5 12:59 MySQL-Max-3.23.49-1.i386.rpm -rw-r--r--1 root root 690350 Mar 5 12:59 MySQL-bench-3.23.49-1.i386.rpm -rw-r--r--1 root root 1766978 Mar 5 12:59 MySQL-client-3.23.49-1.i386.rpm -rw-r--r--1 root root 622278 Mar 5 12:59 MySQL-devel-3.23.49-1.i386.rpm -rw-r--r--1 root root 234505 Mar 5 12:59 MySQL-shared-3.23.49-1.i386.rpm I haven't tested the functionality of the build yet, but at least it builds without error. [***] -- [*] You'll have to look directly into the Yellow Dog ftp site since rpmfind links are broken. [**] You need to have texinfo installed to build gcc (this package is on your RedHat CD) [***] I've tested it just a little but it really looks like it's working pretty well!!! My mysql binaries have been built with gcc 2.96 (but with gcc 2.95 it should work the same). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Okresl Swoje potrzeby - my znajdziemy oferte za Ciebie! [ http://oferty.onet.pl ] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To
Mysql and Sun reference implementation J2EE
Hi, I'm trying Mysql with various Java application Server. I've started with Sun Refernce implementation. What are the params to set in resourse config file? and what type of jdbc drivers can i use? Thank. Luca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
BETWEEN function
Hello everybody, I could not find any documentation about the BETWEEN function. Am I just blind? Please point me to it. Or is it not stable yet? How does it perform in comparison to field1 = x AND field1 = y? Thanks, Felix sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql 3.23.49-1.src.rpm and RPM 4.0.2 on RH 6.2
Hi everybody. I want rebuild source rpm: MySQL-3.23.49-1.src.rpm with rpm 4.0.2 But it fails. I type: rpm --rebuild MySQL-3.23.49-1.src.rpm and i see: all options for RPM. What is wrong ?? In MAN for RPM is: REBUILD AND RECOMPILE OPTIONS There are two other ways to invoke building with rpm: rpm --recompile source_package_file+ rpm --rebuild source_package_file+ When invoked this way, rpm installs the named source package, and does a prep, compile and install. In addi tion, --rebuild builds a new binary package. When the build has completed, the build directory is removed (as in --clean) and the the sources and spec file for the package are removed. It doesn't work. Plese, help. Regards. Ireneusz Piasecki -- Okrel Swoje potrzeby - my znajdziemy ofert za Ciebie! [ http://oferty.onet.pl ] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Segmentation violation in mysql client under AIX
Description: Core dump of mysql client program with segmentation violation. Recently when upgrading php I had to have our sysadmin apply a patch to fix problems with weak symbols in gcc-3. Secifically, they related to problems with the variables _S_max_size and one other variable defined in g++-v3/bits/basic_string.h I also upgraded to gcc-3.0.4. When tried to upgrade to mysql-3.23.49 I ran into trouble. I managed to get mysqld compiled in a functional form. However, I have been unable to produce a functional version of the mysql client. I downgraded to gcc-3.0.3 and I tried mysql-3.23.48 to no avail. The symptoms are the following: When a command without a semicolon, such as use mysql is used it works. However, when I use a command that ends in a semicolon such as use mysql; I get a segmentation violation. To compile I had to do the following. After configuring I have to undefine HAVE_ALLOCA - I had to do this in previous (fully functional compiles as well. Also, in clients and sql I had to add libsup++.a to LIBS in the Makefiles to get the programs to link. Otherwise the symbol __cxa_pure_virtual was undefined. How-To-Repeat: use mysql; Fix: None known However, I suspect the problem somehow is caused by the patch to the assembler. Submitter-Id: submitter ID Originator:Bernt Guldbrandtsen Organization: Danish Institute of Agricultural Sciences -- Bernt Guldbrandtsen [EMAIL PROTECTED] http://genetics.agrsci.dk/~bg MySQL support: none Synopsis: Segmentation violation in mysql client under AIX Severity: serious Priority: Category: mysql Class: sw-bug Release: mysql-3.23.48 (Source distribution) Server: mysqladmin Ver 8.23 Distrib 3.23.48, for ibm-aix4.3.3.0 on rs6000 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.49 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 2 days 4 hours 9 min 55 sec Threads: 1 Questions: 57 Slow queries: 0 Opens: 10 Flush tables: 1 Open tables: 4 Queries per second avg: 0.000 Environment: System: AIX node02 3 4 82718100 Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/rs6000-ibm-aix4.3.3.0/3.0.3/specs Configured with: ../gcc-3.0.3/configure --disable-multilib --enable-threads=posix Thread model: single gcc version 3.0.3 Compilation info: CC='gcc -pipe -mcpu=power2 -Wa,-many' CFLAGS='' CXX='gcc -pipe -mcpu=power2 -Wa,-many' CXXFLAGS='-felide-constructors -fno-exceptions -fno-rtti ' LDFLAGS='' LIBC: lrwxrwxrwx1 bin bin19 Oct 26 13:33 /lib/libc.a - /usr/ccs/lib/libc.a lrwxrwxrwx1 bin bin19 Oct 26 13:33 /usr/lib/libc.a - /usr/ccs/lib/libc.a Configure command: ./configure --prefix=/usr/local/mysql --enable-thread-safe-client --enable-large-files --with-berkeley-db - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Datawarehousing
Anybody out there using Mysql as a Datawarehouse? _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql 3.23.49-1.src.rpm and RPM 4.0.2 on RH 6.2
I want rebuild source rpm: MySQL-3.23.49-1.src.rpm with rpm 4.0.2 But it fails. You need the rpm-build-4.0.2-6x.i386.rpm package to use the --rebuild option. You need gcc = 2.95 to build MySQL (look at the Why v3.23.49 does not build on RedHat 6.2 ? thread) --- Gabriele Carioli Management Innovative Tools S.p.A. Via Giuditta Tavani Arquati, 6 47100 Forlì (FC) - ITALY (EU) tel. 0039.0543.21834 fax. 0039.0543.379215 http://www.mit.it/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
query string limit
[MySQL 3.22 / MySQL 3.23] Does anyone know what the maximum length for a query string is? I've searched the docs/archives, but could not find an answer. I'm also using PHP4, so if there is a different limt in that respect I would like any help there also. 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
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
Hi. Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) can i build mysql 3.23.49 from src.rpm with this gcc ? No, definitely Or i must it do with 2.96 You need at least gcc 2.95. Follow the instructions posted on my previous message and you'll succeed - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with object Query under mysql++-1.7.9
Dear Sinisa, I have this error compiling code that uses the mysql++-1.7.9 I am using gcc-3.0 mysql-3.23.48 mysql++-1.7.9 with patch for compiling with gcc-3.0 under Tru64 Unix v.4.0f thanks in advance payment for the aid. Erminio Riezzo. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Datawarehousing
Yes - Original Message - From: Oscar Colino [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 08, 2002 11:52 AM Subject: Datawarehousing Anybody out there using Mysql as a Datawarehouse? _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Datawarehousing
what is the size of the warehouse? how do you handle partitioning logic on the database? From: Gelu [EMAIL PROTECTED] To: Oscar Colino [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Datawarehousing Date: Fri, 8 Mar 2002 14:04:29 +0200 Yes - Original Message - From: Oscar Colino [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 08, 2002 11:52 AM Subject: Datawarehousing Anybody out there using Mysql as a Datawarehouse? _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Send and receive Hotmail on your mobile device: http://mobile.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: [ANN] Blue World ...
Okay, I'm a Lasso person who has been lurking on this list for some months now because I'm learning MySQL. I'm learning it because Blue World was cool enough to adopt MySQL in their latest version of Lasso Professional 5 (LP5). This is a great list and I'm learning a ton of stuff here without ever needing to ask a question. It seems whenever I have a question, it seems to have been covered in the past week or so and I simply go through my old emails from the list to find the answer. Reading this thread, it seems clear that the PHP people on this list feel that this list should only discuss things related to MySQL and PHP. I thought this was a MySQL list, not PHP. There is going to be a lot more Lasso people on this list as more and more of us switch to LP5. This list better start adjusting to the idea or MySQL will start losing a whole new group of MySQL converts. The really cool thing about all this is that MySQL is being adopted by more and more complimenting technologies. That's a good thing for the MySQL community. It's only natural that people are going to want comparisons of competing technologies as long as they can continue to use MySQL. Right? That's what I would want to see. sql, query - Lasso Summit 2002 - EuropeApril 15-16, 2002 in London, UK - Jim Van Heule The Data Web Center VH Publications, Inc. www.DataWebCenter.com www.VHPublications.com[EMAIL PROTECTED] [EMAIL PROTECTED] direct: 616.844.0066 - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with object Query under mysql++-1.7.9
Erminio Efisio Riezzo writes: Dear Sinisa, I have this error compiling code that uses the mysql++-1.7.9 I am using gcc-3.0 mysql-3.23.48 mysql++-1.7.9 with patch for compiling with gcc-3.0 under Tru64 Unix v.4.0f thanks in advance payment for the aid. Erminio Riezzo. Hi! If I understand you correctly, you have applied a patch for GNU 3.* to mysql++ and you still have problems ?? What problems ??? And what payment ?? -- 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: Why v3.23.49 does not build on RedHat 6.2 ?????
On Fri, 8 Mar 2002, Sommai Fongnamthip wrote: If I'd like to upgrade LH 6.2 to LH 7.0+. Would my old data (LH setting, MySQL db) lost? Sommai No, they should be fine. -- Trond Eivind Glomsrød Red Hat, 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
BETWEEN: So, what happens here?
Hello everybody, there is a table containing a date field named datum. I want to find out the rows containing a date BETWEEN two given dates. And I do: SELECT * FROM table1 WHERE datum BETWEEN '-00-00' AND '2002-03-10'; This one does what it's supposed to do. But now I need to add one day to the start date on SQL level. So I do: SELECT * FROM table1 WHERE datum BETWEEN ('-00-00' + INTERVAL 1 DAY) AND '2002-03-10'; MySQL returns an empty result set, but it shouldn't (the table contains dates year 2000 and up. EXPLAIN SELECT * FROM table1 WHERE datum BETWEEN ('-00-00' + INTERVAL 1 DAY) AND '2002-03-10'; - +-+ | Comment | +-+ | Impossible WHERE noticed after reading const tables | +-+ ?? Thanks for any advice, Felix - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Anyone get MySQL and RH7.2 to work?
Install your ncurses rpm. Paul Warren wrote: I've been frustrated with this for the past I-donno-how-many days. Has anyone been able to get MySQL to work on Red Hat 7.2? I've been getting multiple errors. The First was the resolveIP() right from the beginning. I follwed what the mysql website said and got glibc version 2.95 and that error dissappeared but I got a new one. my latest error was can't find tgetent in either curces or termcap. I don't think I have either of the later installed. I don't know where I can get them. I'm using the source code and compiling it. With the RPM, I still get errors but it has installed somewhat. I'd like a clean install. Basically, I would like to know if anyone has got it to install sans errors and how did they do that. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Can not connect (again)
The client has to be able to search var/lib/mysql and read and write the var/lib/mysql/mysql.socket. It is probably not able to do one of the above due to imprpoer privileges at the filesystem level. Doug Thompson wrote: Egor: Yesterday, I wrote and described that my fix for a single cpu, non-RAID environment was installing a new version. What I didn't say at the time is that the mysql.sock file was present exactly where it was supposed to be and at exactly the location the error message said it couldn't find it: var/lib/mysql/mysql.socket. Go figure. There is obviously something else going on, but I am ill-equipped to say what it is. The point I am trying to make, however, is that the procedures in the manual and all the stock answers are failing to provide a correction in many cases. I'm happy to have 3.23.49a functioning and now want to get to work with it. However, if there are data to be collected that would be helpful, I suppose I can revert to the RPM that came with RH7.1 and see if I can re-create the failure. Doug Bot Bottleneck Botulin - query On Thu, 7 Mar 2002 17:18:01 +0200, Egor Egorov wrote: d Somewhere in setting the permissions and using safe_mysql I messed something d up. I am now getting an Error 2002 can't connect to local Mysql through d socket var/lib/mysql/mysql.socket. I don't know much about the socket file, d so if that has something to do with the problem, I'll need a brief d explanation. Can someone PLEASE HELP because I'm desperate to get this d fixed yesterday. If your MySQL server is running then you should check location of the socket file and check the socket path in your my.cnf file. Check your privileges on the socket file and on the dir that contains socket file. You can find the description of this error at: http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
startup error
I just installed mysql-3.23.43-sun-solaris2.7-sparc, but I can not get it to start up. Here's the error I'm getting: ./bin/safe_mysqld --log --log-update Starting mysqld daemon with databases from /koz/mysql-3.23.43-sun-solaris2.7-sparc/data ./bin/safe_mysqld: /koz/mysql-3.23.43-sun-solaris2.7-sparc/data/devnfs.err: cannot create Any help you could give me would be great! Thanks, Cstyle - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Datawarehousing
Hi, regarding the size, I would be more interested on the space in Gbytes I am use to work with Oracle,Teradata, DB2 ... and they all handle partitioning in different ways, when it comes to a big datawarehouse ( and I am talking about Terabytes), there are two key features that need to be handle by the RDBMS system: 1. Paritioning of data 2. Parallelism (being able to split the workload of a query between several processes , all accessing at the same time different blocks of data of the same table located in the same hard-disk or not), this feature can make a full table scan of a terabyte talbe to be procesed pretty quick), otherwise it would not be realistic Regarding partitioning below there is an example of what I mean (this is basically the way Oracle works in 8.1.x) extracted from a previous email: ... if I use the MERGE thing, will the sql parser be able to access only the right partition(table) ie: Imagine we partition by month a fact table containing data for two months so we end up with 2 tables : fact_april and fact_may and then we merge them into on fact table called fact_merge this is the squema design: lu_month(month_id) lu_day(day_id,month_id) fact_may2001(day_id,sales) fact_april2001(day_id,sales) fact_merge (day_id,sales) // this one is the result of mergin fact_may and fact_april now if I run the following query: select sum(sales) from fact_merge where day_id='05/05/2001' or select sum(sales) from fact_merge where day_id between '05/05/2001' and '06/05/2001' or select sum(sales) from fact_merge where day_id in (select day_id from lu_month where month_id=200105) will this queries be redirected by the MySql parser to the fact_may2001 table or will MySql scan the full fact_merge table (basically all partitions) This is the way most of the RDBMS systems supporting partitioning work, otherwise you would have to set the partitioning logic on the application side. thanks. From: Gelu [EMAIL PROTECTED] To: Oscar Colino [EMAIL PROTECTED] Subject: Re: Datawarehousing Date: Fri, 8 Mar 2002 15:48:16 +0200 Hi, what is the size of the warehouse? The size of the Finish Goods Warehouse are : 40 types and manage cca. 300.000 pieces. how do you handle partitioning logic on the database? ...IT'S MADNESS. From what point of view are you interested ? - Original Message - From: Oscar Colino [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, March 08, 2002 12:37 PM Subject: Re: Datawarehousing what is the size of the warehouse? how do you handle partitioning logic on the database? From: Gelu [EMAIL PROTECTED] To: Oscar Colino [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: Datawarehousing Date: Fri, 8 Mar 2002 14:04:29 +0200 Yes - Original Message - From: Oscar Colino [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 08, 2002 11:52 AM Subject: Datawarehousing Anybody out there using Mysql as a Datawarehouse? _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Send and receive Hotmail on your mobile device: http://mobile.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 _ Send and receive Hotmail on your mobile device: http://mobile.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]
problem of installing mysql
I installed the binary version of mysql on my linux system. After i started the server, It seems the sysem get stuck. I can see the command line sign and the cursor. When I open another console I can find out that the server in running by using the command bin/mysqladmin version. Why? Any suggestions appreciated. Jianping Zhu Department of Computer Science Univerity of Georgia Athens, GA 30602 Tel 706 5423900 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: BETWEEN: So, what happens here?
So I do: SELECT * FROM table1 WHERE datum BETWEEN ('-00-00' + INTERVAL 1 DAY) AND '2002-03-10'; MySQL returns an empty result set, but it shouldn't (the table contains dates year 2000 and up. MySQL refers to the date -00-00 as null. Null+1 is null. Why don't you rewrite the query as SELECT * FROM table1 WHERE datum = '2002-03-10' ? If you can't do that, using a valid date like '1900-01-01' instead of '-00-00' should work. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
sql query doesn't work
The following queries worked with the 3.22.32 version and not with the 3.23.47 and 3.23.49a versions. select field1,field2,locate(ifnull(field3,'N'),'N') from mytable where field3 not in ('N') order by 3, field1 select field1,field2,locate(ifnull(field3,'N'),'N') from mytable where field3 not in ('Y',' ') order by 3, field1 (before launching the 2nd query I changed all NULL values by the space character ' ') the type of field3 is char(1). field3 values are 'Y','N',NULL the same problem occurs when values are 'Y','N',' ' the in (Value1,Value2,...,Valuen) syntax seems not work correctly. I used the binary distribution for intel-libc6-linux systems. Maybe a bug or a compilation problem specific to the intel libraries. If any more information is needed please mail me at [EMAIL PROTECTED] Yan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Dropdown lists
Josiah.. I think you are asking the wrong mailing list for this... I am assuming you are using PHP correct? Your explanation isn't all that clear, but I can guess what you are trying to do. You want to have a drop down list, but don't know what data type.. You can use VarChar or text for this. Varchar means you other characters besides text in the fields. Like numbers !@#$%^*( etc. So you can do Create table State varchar(25); If you need more help, let me know, don't ask the mysql list unless its mysql related! -Original Message- From: Josiah Wallingford [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 12:30 AM To: MySql Subject: Dropdown lists I need to create a dropdown list in my script I am writing but don't know how to set it up in mysql. I have Mysql create table tablename - (now here is what I don¹t know what to put) state varchar(100); Do I use varchar for drop down 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
How to add date/time to reports?
I was just wondering that how to add date/time to every report run in MySql. I've got a database that contains everything about my home-made beers. I run a select-query sometimes and I want to include the time when it was run in it. So, any ideas? Thanks! _ 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: Why v3.23.49 does not build on RedHat 6.2 ?????
Ireneusz Piasecki [EMAIL PROTECTED] writes: Hi. I have question. U have RH6.2 Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) can i build mysql 3.23.49 from src.rpm with this gcc ? Or i must it do with 2.96 ? I would definitely recommend 2.96RH, as it has fixed many bugs from egcs. It also has far better C++ standards compliance, but that's not an issue here. It's probably still the most stable gcc available at this point... -- Trond Eivind Glomsrød Red Hat, 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
Mysql/Solaris: can't run configure or mysql_install_db
Hi. We have Solaris 2.8 and just got Mysql 3.23. We installed the files and are now trying to run the mysql/configure or mysql/scripts/mysql_install_db scripts but I get an error Command not found. I logged in as chuck, then did su and logged in as superuser before running this command. I also logged in as root and used this command. All the files in mysql/ are owned by root and have a group of 'mysql'. Anyone know what I can try to run the install script? Thanks. p.s. We also made a user 'mysql' and a group 'mysql'. The computer is a SPARC server and we have the appropriate mysql binary. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Creating user and group mysql on Solaris
We have Solaris 2.8 and here is what we did to create the mysql user and group: - First add the group: groupadd mysql - Next add the user: useradd mysql -g mysql This also adds the user to the group mysql. - Put the user root in the mysql group: usermod -G mysql root - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Running MySQL as Service on 2000 Server
Hi, I am also facing the same problem...in Win2K When i try to run in from the service, it says some error so i referred to some sites...and just using the command line as standalone Also i acould not run apache as a service... I could not see it under services... Any way to start these under service... Shankar --- [EMAIL PROTECTED] wrote: Hi, Anybody running MySQL on Win 2000 server here? I just installed MySQL 3.23.49-MAX (w/ InnoDB) on a 2000 Server (Dual 1.1 GHz - 1GB RAM - 15GB HD space) and I can run it without any problem from the command line as a standalone. However I couldn't run it as a service even though I already did 'mysqld-max-nt --install' the first time I ran it. Is there anything wrong with MySQL or is it more of permission issue on NT/2000 server. I also attached the my.ini file if it would help. Thanks. Regards, Martin [mysqld] basedir=G:/MySQL datadir=G:/MySQL/data #bind-address= log-slow-queries=h:/slowquery/slowquery.log set-variable=key_buffer=20M innodb_data_home_dir = g:/ibdata innodb_data_file_path = ibdata:2000M;ibdata2:2000M set-variable = innodb_buffer_pool_size=200M set-variable = innodb_additional_mem_pool_size=30M innodb_log_group_home_dir = h:/iblogs innodb_log_arch_dir = h:/iblogs innodb_log_archive=0 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=30M set-variable = innodb_log_buffer_size=24M innodb_flush_log_at_trx_commit=1 set-variable = innodb_file_io_threads=10 set-variable = innodb_lock_wait_timeout=50 [WinMySQLAdmin] Server=G:/MySQL/bin/mysqld-max-nt.exe **Disclaimer** This Memo and any attachments, may be confidential and legally privileged. If you are not the intended recipient and have received this in error, kindly destroy this message and notify the sender. Thank you for your assistance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
Hi, It is very interesting, what are you wwriting, but: To determine if you should be concerned about this compiler issue, execute gcc -v from the command prompt on your system. If the compiler reports version 2.96, then there is a problem (this is the case, for example on RH 7.x series or Mandrake 8.x). In this case, you should not try to compile your own binary before downgrading to one of the compilers mentioned above. You should also NOT use the MySQL server provided with your distribution -- as this copy of MySQL was compiled with the same ill-advised compiler version. this is from http://www.mysql.com/downloads/mysql-3.23.html I understud, don't compile mysql with 2.96 of gcc. I'm confiused. The query is: Compile server mysql with 2.96 or not ? Regards. I. Piasecki. - Original Message - From: Trond Eivind Glomsrød [EMAIL PROTECTED] To: Ireneusz Piasecki [EMAIL PROTECTED] Cc: Gabriele Carioli [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Sent: Friday, March 08, 2002 4:51 PM Subject: Re: Why v3.23.49 does not build on RedHat 6.2 ? Ireneusz Piasecki [EMAIL PROTECTED] writes: Hi. I have question. U have RH6.2 Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) can i build mysql 3.23.49 from src.rpm with this gcc ? Or i must it do with 2.96 ? I would definitely recommend 2.96RH, as it has fixed many bugs from egcs. It also has far better C++ standards compliance, but that's not an issue here. It's probably still the most stable gcc available at this point... -- Trond Eivind Glomsrød Red Hat, Inc. -- Tego nie znajdziesz w zadnym sklepie! [ http://oferty.onet.pl ] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Digest messages coming as attachments
I use Outlook 2000 to read my email. I subscribed to the Mysql digest list. Each message is attached to the digest as a separate message, the subjects unsorted. Is there a way to sort the subjects so I can find the right message number associated with the message in the table of contents in the email body? Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
On Fri, 8 Mar 2002, Ireneusz Piasecki wrote: Hi, It is very interesting, what are you wwriting, but: To determine if you should be concerned about this compiler issue, execute gcc -v from the command prompt on your system. If the compiler reports version 2.96, then there is a problem (this is the case, for example on RH 7.x series or Mandrake 8.x). In this case, you should not try to compile your own binary before downgrading to one of the compilers mentioned above. You should also NOT use the MySQL server provided with your distribution -- as this copy of MySQL was compiled with the same ill-advised compiler version. this is from http://www.mysql.com/downloads/mysql-3.23.html I understud, don't compile mysql with 2.96 of gcc. I'm confiused. The query is: Compile server mysql with 2.96 or not ? 2.96RH. It's more widely used than gcc3 (which has had grave problems, but have been stabilizing) and gcc 2.95 (which is also rather bad...)[1] would definitely be the one I recommend. We trust it enough that when we upgrade the compiler to gcc 3.1 someday in the future, the kernel will probably stay with gcc 2.96RH. [1] It's the standard compiler for both RHL and Mandrake -- Trond Eivind Glomsrød Red Hat, 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: How to add date/time to reports?
* Jarkko Toivonen I was just wondering that how to add date/time to every report run in MySql. I've got a database that contains everything about my home-made beers. I run a select-query sometimes and I want to include the time when it was run in it. Add now() as report_time to your field list: SELECT *,now() as report_time FROM table WHERE field='A'; The timestamp will be available as a field named 'report_time'. Put this in the header (or footer) of your report. -- Roger query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Simultaneous SELECT and UPDATE on the same table
Hi there, I have a medium-size table (3 million rows) with several pieces of data including an ID and a number (called id and num below). I have a program which builds a hash in perl from a data file of the 'new' numbers for each id, only some of which have changed (5-10%). To update the table I tried using the following code (paraphrased): -- $sth = $dbh-prepare(SELECT id,num FROM table, { 'mysql_use_result' = 1 }); $sth-execute; $sth-bind_columns(\$id, \$num); while ($sth-fetch) { $new_num = $hash{$id}; $dbh-do(UPDATE table SET num = $new_num WHERE id = $id) if $num != $new_num; } $sth-finish; -- This works for a varying number of rows (usually 5,000 to 10,000) before it silently exits the loop. I'm using MySQL 3.23.49a I was wondering if there is a problem with doing this in MySQL. Because of the size of the table and my script's already gargantuan memory footprint (it tops out 600 MB by the time it gets to this stage) I need to avoid storing the entire result in DBI, hence mysql_use_result. As an alternative I could mark all the id's that have changed and then perform the updates after I have closed the table, but I expected this way of doing it to work fine. I have run it through numerous times, and it always drops out of the loop at the same sort of interval (but often differs from run to run). Should this be working or should I find another way? If it is a bug then I will of course try to produce more information, but I just want to check I'm doing the right thing first. Many Thanks, Corin /+-\ | Corin Hartland-Swann |Tel: +44 (0) 20 7491 2000| | Commerce Internet Ltd |Fax: +44 (0) 20 7491 2010| | 22 Cavendish Buildings | Mobile: +44 (0) 79 5854 0027| | Gilbert Street | | | Mayfair|Web: http://www.commerce.uk.net/ | | London W1K 5HJ | E-Mail: [EMAIL PROTECTED]| \+-/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Some PHP - mySQL help please ... new to both
I am very new to both PHP and mySQL. Any help would be greatly appreciated. While running this code I get following fatal error. PHP is installed and running correctly on the server. mySQL I THINK is running properly. I created a table and this code is from a tutorial I am trying to run through for discussion threads. No matter what I make the connection as (admin or nobody) I still get the same result, which leads me to believe that there is something wrong with the coding. I am too new to this to debug. Line 5 of the dbconnect.php file is where the script stops. again any help would be greatly appreciated. ? LINE 5 if (!($mylink = mysql_connect (localhost,administrator,))) { print h3could not connect to database/h3\n; exit; } mysql_select_db(mytest); ? RESULT while trying to run script. Fatal error: Maximum execution time of 60 seconds exceeded in dbconnect.php on line 5 Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.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: Some PHP - mySQL help please ... new to both
Daniel, Usually in PHP there are some sort of syntax error before the line that says failed. -Original Message- From: Daniel Negron/KBE [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 11:05 AM To: [EMAIL PROTECTED] Subject: Some PHP - mySQL help please ... new to both I am very new to both PHP and mySQL. Any help would be greatly appreciated. While running this code I get following fatal error. PHP is installed and running correctly on the server. mySQL I THINK is running properly. I created a table and this code is from a tutorial I am trying to run through for discussion threads. No matter what I make the connection as (admin or nobody) I still get the same result, which leads me to believe that there is something wrong with the coding. I am too new to this to debug. Line 5 of the dbconnect.php file is where the script stops. again any help would be greatly appreciated. ? LINE 5 if (!($mylink = mysql_connect (localhost,administrator,))) { print h3could not connect to database/h3\n; exit; } mysql_select_db(mytest); ? RESULT while trying to run script. Fatal error: Maximum execution time of 60 seconds exceeded in dbconnect.php on line 5 Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Some PHP - mySQL help please ... new to both
Is the syntax of the statement correct ? ? LINE 5 if (!($mylink = mysql_connect (localhost,administrator,))) { print h3could not connect to database/h3\n; exit; } mysql_select_db(mytest); ? Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com |+ || Todd | || Williamsen | || todd@williams| || en.net | ||| || 03/08/02 12:32| || PM| ||| |+ -| | | | To: 'Daniel Negron/KBE' [EMAIL PROTECTED], [EMAIL PROTECTED]| | cc: | | Subject: RE: Some PHP - mySQL help please ... new to both | -| Daniel, Usually in PHP there are some sort of syntax error before the line that says failed. -Original Message- From: Daniel Negron/KBE [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 11:05 AM To: [EMAIL PROTECTED] Subject: Some PHP - mySQL help please ... new to both I am very new to both PHP and mySQL. Any help would be greatly appreciated. While running this code I get following fatal error. PHP is installed and running correctly on the server. mySQL I THINK is running properly. I created a table and this code is from a tutorial I am trying to run through for discussion threads. No matter what I make the connection as (admin or nobody) I still get the same result, which leads me to believe that there is something wrong with the coding. I am too new to this to debug. Line 5 of the dbconnect.php file is where the script stops. again any help would be greatly appreciated. ? LINE 5 if (!($mylink = mysql_connect (localhost,administrator,))) { print h3could not connect to database/h3\n; exit; } mysql_select_db(mytest); ? RESULT while trying to run script. Fatal error: Maximum execution time of 60 seconds exceeded in dbconnect.php on line 5 Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 4.0.x Replication Just Dumped Core...
On Thursday 07 March 2002 11:39 pm, Jeremy Zawodny wrote: 020307 21:39:03 ?Error in Log_event::read_log_event(): 'read error', data_len=193,event_type=2 020307 21:39:03 ?Slave SQL thread: I/O error reading event(errno=-1,cur_log-error=57) assertion mi-io_thd == thd failed: file slave.cc, line 610 Jeremy: Looks like we've got several things cooking. Somehow the read by the SQL thread from the relay log was incomplete ( possibly some I/O issues in the kernel?), and at the same time apparently some buffer overrun took place. Can you upload the core file + the binary to our secret locatioin? -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Why v3.23.49 does not build on RedHat 6.2 ?????
On Fri, 8 Mar 2002, Trond Eivind Glomsrød wrote: On Fri, 8 Mar 2002, Ireneusz Piasecki wrote: Hi, It is very interesting, what are you wwriting, but: To determine if you should be concerned about this compiler issue, execute gcc -v from the command prompt on your system. If the compiler reports version 2.96, then there is a problem (this is the case, for example on RH 7.x series or Mandrake 8.x). In this case, you should not try to compile your own binary before downgrading to one of the compilers mentioned above. You should also NOT use the MySQL server provided with your distribution -- as this copy of MySQL was compiled with the same ill-advised compiler version. this is from http://www.mysql.com/downloads/mysql-3.23.html I understud, don't compile mysql with 2.96 of gcc. I'm confiused. The query is: Compile server mysql with 2.96 or not ? 2.96RH. It's more widely used than gcc3 (which has had grave problems, but have been stabilizing) and gcc 2.95 (which is also rather bad...)[1] would definitely be the one I recommend. We trust it enough that when we upgrade the compiler to gcc 3.1 someday in the future, the kernel will probably stay with gcc 2.96RH. [1] It's the standard compiler for both RHL and Mandrake -- Trond Eivind Glomsrød Red Hat, Inc. I find this rather unhelpful, as it really doesn't answer the question. I understand that as a RH representative, you stand by the decision to use gcc 2.96, but no matter how wonderful you think it is, the MySQL directions explicitly state not to use it, because Several of our users have reported random crashes and table corruption with MySQL binaries compiled with gcc 2.96 on the x86 Linux platform. Has this issue been resolved? If so, the directions should be updated. If not, I question the helpfulness of advising people to ignore the directions. I have no interest in the arguments over whether 2.96 was a good idea or not, and I take you at your word when you tout the merits of 2.96, but that's not the question here. The question is which compiler to use for *mysql*. The list of people with stable copies of mysql compiled with gcc 2.95.3 is long, and it includes people who had problems with copies compiled with 2.96. Personally, I have no idea whether that's because of a flaw in gcc 2.96 or in mysql, but it's a moot point until it's found and fixed. Has it been? Michael Stassen University Information Technology Services Indiana University Bloomington [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: Some PHP - mySQL help please ... new to both
Did you check the mysql db, host, and user tables to make sure that 'localhost' and 'administrator' have appropriate permissions to use your desired database? This issue caused me much frustration until I had things set right. You should see something like the following. I'm assuming that your PHP application and your mysql db live on the same box. If it's a PHP issue, then I don't know what to advise you since I don't know PHP. mysql use mysql; mysql select * from user; +-+--+--+-+- +-+-+-+---+- +---+--+---++--- --+++ | Host| User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +-+--+--+-+- +-+-+-+---+- +---+--+---++--- --+++ | localhost | administrator | | Y | Y | Y | Y | Y | Y | Y | Y | Y| Y | Y | Y | Y | Y | mysql select * from host; +-+---+-+-+- +-+-+---++-- ---+++ | Host| Db| Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +-+---+-+-+- +-+-+---++-- ---+++ | localhost | your_db_name | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | mysql select * from db; +-+-+--+-+-- ---+-+-+-+---++- +++ | Host| Db | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +-+-+--+-+-- ---+-+-+-+---++- +++ | localhost (you could try % if the box isn't visible to anyone but you) | your_db_name | administrator | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | -Original Message- From: Daniel Negron/KBE [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 9:05 AM To: [EMAIL PROTECTED] Subject: Some PHP - mySQL help please ... new to both I am very new to both PHP and mySQL. Any help would be greatly appreciated. While running this code I get following fatal error. PHP is installed and running correctly on the server. mySQL I THINK is running properly. I created a table and this code is from a tutorial I am trying to run through for discussion threads. No matter what I make the connection as (admin or nobody) I still get the same result, which leads me to believe that there is something wrong with the coding. I am too new to this to debug. Line 5 of the dbconnect.php file is where the script stops. again any help would be greatly appreciated. ? LINE 5 if (!($mylink = mysql_connect (localhost,administrator,))) { print h3could not connect to database/h3\n; exit; } mysql_select_db(mytest); ? RESULT while trying to run script. Fatal error: Maximum execution time of 60 seconds exceeded in dbconnect.php on line 5 Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.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?
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
Michael Stassen [EMAIL PROTECTED] writes: On Fri, 8 Mar 2002, Trond Eivind Glomsrød wrote: On Fri, 8 Mar 2002, Ireneusz Piasecki wrote: Hi, It is very interesting, what are you wwriting, but: To determine if you should be concerned about this compiler issue, execute gcc -v from the command prompt on your system. If the compiler reports version 2.96, then there is a problem (this is the case, for example on RH 7.x series or Mandrake 8.x). In this case, you should not try to compile your own binary before downgrading to one of the compilers mentioned above. You should also NOT use the MySQL server provided with your distribution -- as this copy of MySQL was compiled with the same ill-advised compiler version. this is from http://www.mysql.com/downloads/mysql-3.23.html I understud, don't compile mysql with 2.96 of gcc. I'm confiused. The query is: Compile server mysql with 2.96 or not ? 2.96RH. It's more widely used than gcc3 (which has had grave problems, but have been stabilizing) and gcc 2.95 (which is also rather bad...)[1] would definitely be the one I recommend. We trust it enough that when we upgrade the compiler to gcc 3.1 someday in the future, the kernel will probably stay with gcc 2.96RH. [1] It's the standard compiler for both RHL and Mandrake I find this rather unhelpful, as it really doesn't answer the question. I understand that as a RH representative, you stand by the decision to use gcc 2.96, but no matter how wonderful you think it is, the MySQL directions explicitly state not to use it, because Several of our users have reported random crashes and table corruption with MySQL binaries compiled with gcc 2.96 on the x86 Linux platform. None of these have been brought to our attention or documented. Note that the official ones use a different, statically linked version of glibc as well as a very old compiler. Has this issue been resolved? If so, the directions should be updated. If not, I question the helpfulness of advising people to ignore the directions. I have no interest in the arguments over whether 2.96 was a good idea or not, and I take you at your word when you tout the merits of 2.96, but that's not the question here. The question is which compiler to use for *mysql*. The list of people with stable copies of mysql compiled with gcc 2.95.3 is long, and it includes people who had problems with copies compiled with 2.96. Personally, I have no idea whether that's because of a flaw in gcc 2.96 or in mysql, but it's a moot point until it's found and fixed. Has it been? No issues in interaction between gcc 2.96RH and MySQL has been identified since just after the release of Red Hat Linux 7 a year and a half ago (we submitted fixes for these to the MySQL team, and they have been included since the 3.23.midtwenties or so). A generic issue with MySQL is that MySQL seems more stable when compiled with -fno-rtti -fno-exceptions regardless of the compiler version. The newest rpms at http://people.redhat.com/teg/mysql/ are compiled that way, older ones aren't. Still haven't heard of any issues or experience any myself. FWIW, I've ran quite a few tests (the regression tests, the benchmarks etc) with no stability problems whatsoever. -- Trond Eivind Glomsrød Red Hat, 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: Why v3.23.49 does not build on RedHat 6.2 ?????
On Fri, 2002-03-08 at 10:02, Ireneusz Piasecki wrote: Hi, It is very interesting, what are you wwriting, but: To determine if you should be concerned about this compiler issue, execute gcc -v from the command prompt on your system. If the compiler reports version 2.96, then there is a problem (this is the case, for example on RH 7.x series or Mandrake 8.x). In this case, you should not try to compile your own binary before downgrading to one of the compilers mentioned above. You should also NOT use the MySQL server provided with your distribution -- as this copy of MySQL was compiled with the same ill-advised compiler version. this is from http://www.mysql.com/downloads/mysql-3.23.html I understud, don't compile mysql with 2.96 of gcc. I'm confiused. The query is: Compile server mysql with 2.96 or not ? Ireneusz, Our (MySQL AB) recommendation is to NOT compile *mysql* with RedHat's 2.96 compiler. Instead, in the case of RedHat, you should use 2.91 EGCS or 2.95 GCC compilers. If you do choose to compile with 2.96RH, then you are most likely going to run into problems in a production system. We definitely have a difference of opinion with Trond here. The bottom line is that if you want a stable MySQL server, then you should compile with GCC 2.91 or 2.95. These are the compilers for which our extensive testing has shown MySQL to be stable with. In any large and complicated project there are going to be dependencies on the compiler that the software was written for. Please note that the reason (atleast one of the reasons) RedHat includes 2.91 EGCS in their distribution is to compile the Linux kernel correctly. The Linux kernel -- another large and complicated project -- requires 2.91 EGCS. Read the kernel documentation for more information (README file included in every stock kernel tarball). This is absolutely normal and acceptable for large, complex softwares. Software simply cannot be changed everytime a software vendor (RH in this case) decides to fork their own version of something as fundamental as a compiler. MySQL in particular is a software product that gives your system a real work-out. We have discovered many critical bugs in the libc's, kernels and compilers of various systems -- for instance Glibc, the Linux kernel, and RedHat's forked 2.96 compiler. You will find the same is true of projects like ReiserFS (who do not recommend 2.96 either). While RedHat's 2.96 compiler may indeed work fine for relatively lightweight software that is most likely not going to be used in a high-performance production environment. We (MySQL AB) have determined -- through many investigations of MySQL under high-load compiled with 2.96RH -- that this compiler is not good for MySQL. Now that GCC 3.x has been released, we will be looking at making MySQL 4.x series (and higher) work well with it. GCC 3.x is looking very promising. Regards, Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Coordinator of Development /_/ /_/\_, /___/\___\_\___/ Hopkins, Minnesota 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
Some PHP - mySQL help please ... new to both (Along same lines)
Along the same lines, I have run some scripts that give a similar error that time out is there something in php.ini or mysql that will alow the timing to not stop after 60seconds or 30seconds or something. Had a script to run and pull keywords from a massive db, and it kept timing out. Hope that make since, thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Some PHP - mySQL help please ... new to both
If you're going to post this much information please use: mysql SELECT * FROM user \G so that this is actually readable. Thanks # Nathan - Original Message - From: Brian Warn [EMAIL PROTECTED] To: 'Daniel Negron/KBE' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, March 08, 2002 10:51 AM Subject: RE: Some PHP - mySQL help please ... new to both Did you check the mysql db, host, and user tables to make sure that 'localhost' and 'administrator' have appropriate permissions to use your desired database? This issue caused me much frustration until I had things set right. You should see something like the following. I'm assuming that your PHP application and your mysql db live on the same box. If it's a PHP issue, then I don't know what to advise you since I don't know PHP. mysql use mysql; mysql select * from user; +-+--+--+-+- +-+-+-+---+- +---+--+---++--- --+++ | Host| User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +-+--+--+-+- +-+-+-+---+- +---+--+---++--- --+++ | localhost | administrator | | Y | Y | Y | Y | Y | Y | Y | Y | Y| Y | Y | Y | Y | Y | mysql select * from host; +-+---+-+-+- +-+-+---++-- ---+++ | Host| Db| Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +-+---+-+-+- +-+-+---++-- ---+++ | localhost | your_db_name | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | mysql select * from db; +-+-+--+-+-- ---+-+-+-+---++- +++ | Host| Db | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +-+-+--+-+-- ---+-+-+-+---++- +++ | localhost (you could try % if the box isn't visible to anyone but you) | your_db_name | administrator | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | -Original Message- From: Daniel Negron/KBE [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 9:05 AM To: [EMAIL PROTECTED] Subject: Some PHP - mySQL help please ... new to both I am very new to both PHP and mySQL. Any help would be greatly appreciated. While running this code I get following fatal error. PHP is installed and running correctly on the server. mySQL I THINK is running properly. I created a table and this code is from a tutorial I am trying to run through for discussion threads. No matter what I make the connection as (admin or nobody) I still get the same result, which leads me to believe that there is something wrong with the coding. I am too new to this to debug. Line 5 of the dbconnect.php file is where the script stops. again any help would be greatly appreciated. ? LINE 5 if (!($mylink = mysql_connect (localhost,administrator,))) { print h3could not connect to database/h3\n; exit; } mysql_select_db(mytest); ? RESULT while trying to run script. Fatal error: Maximum execution time of 60 seconds exceeded in dbconnect.php on line 5 Thank You Daniel Negrón Lotus Notes Administrator / Developer KB Electronics, Inc. 954.346.4900x122 http://www.kbelectronics.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:
What is the best way to archive rows from one table to another? ##
I have 2 tables, table1 and table1_archive. The archive table has identical columns as table1 except it has a few extra columns like a log_date, user_id. I would like to copy the corresponding columns from table1 to table1_archive. Sounds simple, right? Example: insert into table1_archive select * from table1 BY NAME where But this doesn't of course update the additional columns in the archive table so I would have to run a separate UPDATE statement after it to update those fields. But the insert into won't work since the 2 tables aren't exactly identical. The archive table has a couple of extra columns. I'm using PHP so the only solution I've come up with is to go through table1 and insert the rows into table1_archive row by row. I'm wondering if there isn't an easier way to do this, using preferably only 1 or 2 sql statements. I really wish there was a BY NAME clause so only the corresponding columns would be inserted from the other table. I suppose I could break the table1_archive up into 2 tables: table1_archive (identical columns to table1) and table1_archive_log that has the extra columns. But how do I link the 2 archive tables? Is there an easier way to do this rather than going row by row? TIA Brent _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: STD()
[EMAIL PROTECTED] wrote: Is this correct?...how MySQL calculate this?... Yes. Std. Dev = Math.sqrt(sum((val[i]-avg)**2) / count(i)); Verified with a trivial program. mysql select * from temp; +--+ | cal | +--+ | 00029.98 | | 00029.95 | | 00029.89 | | 00029.84 | | 00029.78 | | 00029.81 | | 00029.84 | | 00029.28 | +--+ 8 rows in set (0.00 sec) mysql mysql select std(cal) from temp; +--+ | std(cal) | +--+ | 0.205240 | +--+ 1 row in set (0.06 sec) mysql R.B.Roa Traffic Management Engineer PhilCom Corporation Tel.No. (088) 858-1028 Mobile No. (0919) 30856267 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: What is the best way to archive rows from one table to another? ##
You can include constants and functions on your select e.g. insert into table1_archive select *,now(),'thisuser' from table1 Of course, if you are using something like php or perl, then 'thisuser' could just as easily be HTTP_AUTH_USER etc. BD wrote: I have 2 tables, table1 and table1_archive. The archive table has identical columns as table1 except it has a few extra columns like a log_date, user_id. I would like to copy the corresponding columns from table1 to table1_archive. Sounds simple, right? Example: insert into table1_archive select * from table1 BY NAME where But this doesn't of course update the additional columns in the archive table so I would have to run a separate UPDATE statement after it to update those fields. But the insert into won't work since the 2 tables aren't exactly identical. The archive table has a couple of extra columns. I'm using PHP so the only solution I've come up with is to go through table1 and insert the rows into table1_archive row by row. I'm wondering if there isn't an easier way to do this, using preferably only 1 or 2 sql statements. I really wish there was a BY NAME clause so only the corresponding columns would be inserted from the other table. I suppose I could break the table1_archive up into 2 tables: table1_archive (identical columns to table1) and table1_archive_log that has the extra columns. But how do I link the 2 archive tables? Is there an easier way to do this rather than going row by row? TIA Brent _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Why v3.23.49 does not build on RedHat 6.2 ?????
Hi! Our (MySQL AB) recommendation is to NOT compile *mysql* with RedHat's 2.96 compiler. Instead, in the case of RedHat, you should use 2.91 EGCS or 2.95 GCC compilers. Your (MySQL AB) source rpm does not build at all with the egcs/gcc 2.91 compiler. In fact, it gives this error: [..snip...] creating libmysqlclient.la (cd .libs rm -f libmysqlclient.la ln -s ../libmysqlclient.la libmysqlclient.la) make[2]: Leaving directory `/usr/src/redhat/BUILD/mysql-3.23.49/libmysql' Making all in client make[2]: Entering directory `/usr/src/redhat/BUILD/mysql-3.23.49/client' gcc -DUNDEF_THREADS_HACK -I./../include -I.. /include -I./.. -I.. -I..-O3 -DDBUG_OFF -O3 -felide-const ructors -fno-exceptions -fno-rtti -fno-implicit-templates -fno-exception s -fno-rtti -fpermissive -I/usr/local/mysql-glibc/include -c mysql.cc In file included from mysql.cc:48: /usr/include/curses.h:195: warning: `ERR' redefined /usr/include/sys/ucontext.h:74: warning: this is the location of the previous definition cc1plus: Invalid option `-fpermissive' In file included from client_priv.h:19, from mysql.cc:28: ../include/global.h:685: abstract declarator used as declaration make[2]: *** [mysql.o] Error 1 make[2]: Leaving directory `/usr/src/redhat/BUILD/mysql-3.23.49/client' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/src/redhat/BUILD/mysql-3.23.49' make: *** [all-recursive-am] Error 2 error: Bad exit status from /var/tmp/rpm-tmp.61911 (%build) RPM build errors: Bad exit status from /var/tmp/rpm-tmp.61911 (%build) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 4.0.x Replication Just Dumped Core...
On Fri, Mar 08, 2002 at 10:41:32AM -0700, Sasha Pachev wrote: On Thursday 07 March 2002 11:39 pm, Jeremy Zawodny wrote: 020307 21:39:03 ?Error in Log_event::read_log_event(): 'read error', data_len=193,event_type=2 020307 21:39:03 ?Slave SQL thread: I/O error reading event(errno=-1,cur_log-error=57) assertion mi-io_thd == thd failed: file slave.cc, line 610 Jeremy: Looks like we've got several things cooking. Somehow the read by the SQL thread from the relay log was incomplete ( possibly some I/O issues in the kernel?), and at the same time apparently some buffer overrun took place. Can you upload the core file + the binary to our secret locatioin? Sasha, For some reason I can't get your FTP server to like me. Does it not like passive connections or something? Anyway, can you download the mysqld.gz and mysqld.core.1.gz from here? http://db3.finance.dcx.yahoo.com/tmp/ They compressed pretty well. Oh, this is a 4.3 FreeBSD system. Thanks, Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 29 days, processed 1,011,945,786 queries (400/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: is MySQL relational?
On Fri, Mar 08, 2002 at 04:21:09AM +0200, savaidis wrote: Is MySQL a relational database? If yes, how is implemented a one to one and one to many relation? Sir, there is no such thing as a one-to-one or one-to-many relation. Those are joins, and they are implemented in queries, as is the case with all relational database management systems; e.g. Oracle, Sybase, Informix. Bob Hall -- And Pharaoh spake unto Moses 'Database, table, and query.' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RPM installation fails on RH7.2
On RedHat try with GnoRPM or the rpm command line. Philippe Olav Drageset wrote: Hi I have installed RedHat 7.2 . with Apache and DNS as default. When trying to install MySQL with kpaackage manager I get rpmdepCheck() fialed. I cannot see any required modules missing. Can anyone tel me what is wrong? Olav - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: is MySQL relational?
On Fri, Mar 08, 2002 at 02:35:59PM -0500, Bob Hall wrote: On Fri, Mar 08, 2002 at 04:21:09AM +0200, savaidis wrote: Is MySQL a relational database? If yes, how is implemented a one to one and one to many relation? Sir, there is no such thing as a one-to-one or one-to-many relation. Those are joins, and they are implemented in queries, as is the case with all relational database management systems; e.g. Oracle, Sybase, Informix. Yikes! I messed up that one. There are, of course, one-to-one and one-to-many relationships, but not relations. A relation is something different. Relationships are typically implemented as joins in queries. Most RDBMSs allow you to define primary-key/foreign-key relationships, and enforce them with varying levels of integrity constraints. They often use the PK/FK definitions to automate joins. MySQL follows the standard syntax for MAKE TABLE statements, but doesn't do anything with the FK clause. That means that there's no integrity constraint to enforce relational integrity on the PK/FK relationship. I think I did a little better the second time around. Bob Hall -- And Moses spake unto Pharaoh Database, table, and query? Codd of our fathers, what are you talking about!' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Simultaneous SELECT and UPDATE on the same table
At 17:00 + 3/8/02, Corin Hartland-Swann wrote: Hi there, I have a medium-size table (3 million rows) with several pieces of data including an ID and a number (called id and num below). I have a program which builds a hash in perl from a data file of the 'new' numbers for each id, only some of which have changed (5-10%). To update the table I tried using the following code (paraphrased): -- $sth = $dbh-prepare(SELECT id,num FROM table, { 'mysql_use_result' = 1 }); $sth-execute; $sth-bind_columns(\$id, \$num); while ($sth-fetch) { $new_num = $hash{$id}; $dbh-do(UPDATE table SET num = $new_num WHERE id = $id) if $num != $new_num; } $sth-finish; -- This works for a varying number of rows (usually 5,000 to 10,000) before it silently exits the loop. I'm using MySQL 3.23.49a I was wondering if there is a problem with doing this in MySQL. Because of the size of the table and my script's already gargantuan memory footprint (it tops out 600 MB by the time it gets to this stage) I need to avoid storing the entire result in DBI, hence mysql_use_result. That's also your problem. With mysql_use_result, it's *required* that you completely finish the query before issuing another one. I suppose you could write the IDs to a file, then read them back in and use them to issue the UPDATE statements. As an alternative I could mark all the id's that have changed and then perform the updates after I have closed the table, but I expected this way of doing it to work fine. I have run it through numerous times, and it always drops out of the loop at the same sort of interval (but often differs from run to run). Should this be working or should I find another way? If it is a bug then I will of course try to produce more information, but I just want to check I'm doing the right thing first. Many Thanks, Corin /+-\ | Corin Hartland-Swann |Tel: +44 (0) 20 7491 2000| | Commerce Internet Ltd |Fax: +44 (0) 20 7491 2010| | 22 Cavendish Buildings | Mobile: +44 (0) 79 5854 0027| | Gilbert Street | | | Mayfair|Web: http://www.commerce.uk.net/ | | London W1K 5HJ | E-Mail: [EMAIL PROTECTED]| \+-/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Web hosting scalability?
Sounds like a transaction server to me. Curtis John Masterson said: Situation: mass virtual website hosting, with php/perl/python. One master mysql server, one or more replicated slaves. Question: would it be possible/feasible to write a daemon that accepts connections on behalf of mysqld, and depending on what type of query it is (updating or selecting) farm the query out to the appropriate database server? Perhaps it could do some connection pooling as well. The reason: we'd like to keep telling our users to connect to the database server, instead of hoping that they will always write correct code and connect to the appropriate servers, which of course they won't. Any feedback (such as, that's the stupidest idea I've ever heard, why don't you just do _) would be appreciated :) John Masterson Modwest Powerful, Affordable Web Hosting http://www.modwest.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Simultaneous SELECT and UPDATE on the same table
* Paul DuBois At 17:00 + 3/8/02, Corin Hartland-Swann wrote: [...] This works for a varying number of rows (usually 5,000 to 10,000) before it silently exits the loop. I'm using MySQL 3.23.49a [...] That's also your problem. With mysql_use_result, it's *required* that you completely finish the query before issuing another one. I suppose you could write the IDs to a file, then read them back in and use them to issue the UPDATE statements. Why not make two connections, SELECT from one and UPDATE through the other? -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ETA for MySql having sub queries capabilities
Does anyone know the ETA for MySql having sub queries capabilities? Rolando - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem running MySql on Solaris 8?
Every time I run safe_mysqld, I get the following error message: # ./safe_mysqld chown: unknown user id mysql Starting mysqld daemon with databases from /usr/local/mysql/var Killed 020308 22:12:04 mysqld ended # How do I handle this? __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Perl version of phpinfo()
Is there a Perl function similar to php's phpinfo() that echos or returns a complete synopsis of the Perl configuration core? We are trying to determine whether the MySQL DBI/DBD module is accessible to Perl on a Linux server. Will appreciate any help on this. -- Margie New = Margie New 5503 Lands End Austin, Texas 78734 (512) 266-3947 e-mail: [EMAIL PROTECTED] __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: using LOAD DATA INFILE with dbexport from informix
On Fri, 2002-03-08 at 14:19, [EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: I've noticed the hard way that there is more to loading data exported from informix than just: LOAD DATA LOCAL INFILE speci02695.unl INTO TABLE specimens FIELDS TERMINATED BY '|'; I have all of the columns that are INTEGER that were NULL in informix, now have the value 0. I have several export files that are over a gig. I do not want to preparse the file with perl to make all of the NULL values \N, so what can I do? Thanks. I really think that you need to check the spam-o-meter for this kind of query. -- Brian Millett Enterprise Consulting Group Shifts in paradigms (314) 205-9030 often cause nose bleeds. [EMAIL PROTECTED] Greg Glenn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Perl version of phpinfo()
for $key (sort keys %ENV) { print $key = $ENV{$key}\n; } Page 155 of learning perl 1st (purple) edition. Curtis Margie New said: Is there a Perl function similar to php's phpinfo() that echos or returns a complete synopsis of the Perl configuration core? We are trying to determine whether the MySQL DBI/DBD module is accessible to Perl on a Linux server. Will appreciate any help on this. -- Margie New = Margie New 5503 Lands End Austin, Texas 78734 (512) 266-3947 e-mail: [EMAIL PROTECTED] __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Perl version of phpinfo()
On Fri, 8 Mar 2002 12:33:24 -0800 (PST), Margie New [EMAIL PROTECTED] wrote: Is there a Perl function similar to php's phpinfo() that echos or returns a complete synopsis of the Perl configuration core? We are trying to determine whether the MySQL DBI/DBD module is accessible to Perl on a Linux server. Will appreciate any help on this. -- Margie New at the command line: perl -V or perl -v sql database mysql Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql and power builder
Hi! Thanks for your help!!! OS: W2K nt Server: MySQL 4.0.1 Max nt Mysql ODBC driver 3.51 Power Builder 8.0.1. I have 2 main problems: 1. I have a datawindow with 2 arguments, in preview mode works just fine...but inside a window it doesn't retrieve data atall...even if I put values instead of variables... this is my scrip in the constructor event of my window long tmp DatawindowChild dw_child If GetChild('periodo',dw_child) = -1 Then essageBox( error,dwchild error ) If dw_child.SetTransObject(SQLCA) = -1 Then essageBox( error,dwchild settransobject ) tmp=dw_child.Retrieve(st_login.empresa, st_login.ejercicio) /***tmp=dw_child.Retrieve(1, 2001) ***Even if I put this values it doesn't work, no data is returned***/ insertrow(0) SetItem(1,'periodo',st_login.periodo) But if I use only one argument it works fine!!!?? 2. In another datawindow i'm using a SQL scrip that retrieve information for two big tables (40,000 rows each), when i proved my datawindow with almost empty tables (10 records) works finebut since I filled my tables with real data I can't hardly check my SQL scrip because it delay at least five minutes to show it and window send me a message your are running out of virtual memory or something like thatalso my pbtrace file says MySQL client runs out of memory... lost conection to mysql server during query In ini.cfg setup set-variable=key_buffer=16M set-variable=sort_buffer=1M i'm migrating my application from ORACLE to MySQL to provide an economical choice to my customers...i'm the only person using this application and have the server and client in the same machine(132 MB RAM) Hope somebody answer !!! thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Changing Default for Not Null to NOTHING
I just tried something and would a second opinion: I re-configured my MySQL server on my RH Linux machine using the following : CXXFLAGS=-DDONT_USE_DEFAULT_FIELDS ./configure and ran the following SQL: CREATE TABLE FOO (foo int NOT NULL DEFAULT 5, foo1 INT NULL); INSERT INTO FOO (foo1) VALUES (1); MySQL-Error: == 1048 - Column 'foo' cannot be null. So is it true that you either have an installation of MySQL that will have defaults for NOT NULL defined columns (explicity or implied) or you can have an installation that does not allow default values for NOT NULL defined columns? What I want is to be able to create a table that has columns defined as NOT NULL and if I don't assign a default to that column, I want an error if I don't give it a value on insert. What I DON'T want is to define a column as NOT NULL with NO EXPLICIT DEFAULT to get a value if it is left out of an insert statements list of column/value set. Does this make sense?? - Original Message - From: David M. Peak [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Thursday, March 07, 2002 9:22 AM Subject: Changing Default for Not Null to NOTHING Is there a way for me to NOT have a default value for a column in a table that I define as NOT NULL? EXAMPLE SQL: mysql CREATE TABLE FOO (foo1 int NOT NULL); Query OK, 0 rows affected (0.05 sec) mysql DESCRIBE FOO; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | foo1 | int(11) | | | 0 | | +---+-+--+-+-+---+ 1 row in set (0.00 sec) mysql I don't want the default to be 0 (zero) Any ideas? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
login and logout
Does anyone have a php sample code handling login and logout using cookie? I tried to use SESSION, but when I click back on the browswer, it lost all the data I previously entered in a form. I want to have a section on the website that is only used by registered users. The site developed using PHP with query mysql on the backend. Thanks, Siulun __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
which JDBC is better
mm.mysql.jdbc-1.2c.tar.gz mm.mysql-2.0.4-bin.jar Which of these two database driver for MySQL is better? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Perl version of phpinfo()
On Fri, 8 Mar 2002 12:33:24 -0800 (PST), Margie New [EMAIL PROTECTED] wrote: Is there a Perl function similar to php's phpinfo() that echos or returns a complete synopsis of the Perl configuration core? We are trying to determine whether the MySQL DBI/DBD module is accessible to Perl on a Linux server. Will appreciate any help on this. -- Margie New On Fri, 8 Mar 2002, Curtis Maurand wrote: for $key (sort keys %ENV) { print $key = $ENV{$key}\n; } Page 155 of learning perl 1st (purple) edition. Curtis This will print the environment variables. It won't tell you anything about how Perl is set up or which modules are installed. On Fri, 8 Mar 2002, Mike(mickalo)Blezien wrote: at the command line: perl -V or perl -v perl -v will tell you which version of Perl, perl -V will tell you the version, how it was compiled, and the library path (@INC) where Perl will look for modules. It will not tell you which modules are installed. -- At the command line, you could try `perldoc DBD::mysql`. If the mysql module is there, you should see the doumentation. In Perl, you could use the available_drivers DBI method, like this: #!/path/to/perl use DBI; $, = \n; print DBI-available_drivers; You should see mysql in the output if the DBD::mysql module is there. Michael Stassen University Information Technology Services Indiana University Bloomington [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
tinyint and NULL
I have some fields set up in my MySQL database table as tinyint(5) The problem is that it will not except a NULL unless I specifically tell it NULL. I have a form that allows for input. When submitted, it updates the database. If the field on the form is empty, it still puts a 0 (zero) into that field in the database. I thought that would only happen if it was set to NOT NULL. The only way that I can get around this, at the moment, is to set the field up as some char like varchar. I want it to me an int (tinyint) field and to be able to be empty if the form field is empty. Thank You for your response 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: MySQL 4.0.x Replication Just Dumped Core...
On Thursday 07 March 2002 10:48 pm, Jeremy Zawodny wrote: The 4.0.x slave I had just rebuilt the other day died about 40 minutes ago and produced a core file each time. ?It got caught in the cycle of core dump, restart, core dump, restart... Jeremy: I have tracked down and fixed the assertion failure issue. However, I am still not certail why the sql thread does partial reads. I have pushed my fix into the public tree, so let's have you pull it and try again. I am curious to see : a) if re-try after the failed read will actually do any good b) why the read is failing in the first place if a) does not do any good the daemon will be stuck trying to read the same event, but will not generate assertion failure. b) could be happening because of some system failure, or it could be a logic error. In any case, I would like to have a look at db3-relay-bin.005. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: login and logout
Matthew... Did you look into the session variables Session_start() Session_register() Mysql, query -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 4:49 PM To: [EMAIL PROTECTED]; mysql list; Siulun A Sze Subject: RE: login and logout The problem with that is, it doesn't allow logout. Siulun, if you /do/ find some good sample code, clue me in. I'm in the market myself. I'm using apache's basic auth right now, but I need to add logout support. Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 3:05 PM To: mysql list; Siulun A Sze Subject: Re: login and logout Don't know what web server your using, but I use apache's .htmaccess feature to control user access. Works good for me, and its pretty easy to setup. Mike - Original Message - From: Siulun A Sze [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 08, 2002 4:04 PM Subject: login and logout Does anyone have a php sample code handling login and logout using cookie? I tried to use SESSION, but when I click back on the browswer, it lost all the data I previously entered in a form. I want to have a section on the website that is only used by registered users. The site developed using PHP with query mysql on the backend. Thanks, Siulun __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.332 / Virus Database: 186 - Release Date: 3/6/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.332 / Virus Database: 186 - Release Date: 3/6/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: tinyint and NULL
On 8 Mar 2002, at 15:52, Steve Buehler wrote: I have some fields set up in my MySQL database table as tinyint(5) The problem is that it will not except a NULL unless I specifically tell it NULL. I have a form that allows for input. When submitted, it updates the database. If the field on the form is empty, it still puts a 0 (zero) into that field in the database. It sounds like you're just constructing the SQL to set the column to '', and the empty string (like any other nonnumeric string) gets converted to 0 when used for a numeric column. You're going to have to check in your form-handling program for the case where the value is the empty string and then either set that column to NULL in your SQL or omit the column from the SQL entirely (assuming the default is NULL). -- Keith C. Ivey [EMAIL PROTECTED] Washington, DC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: login and logout (OT)
I have, but I'd rather not reinvent the wheel if I don't have to, though I'm almost to the point where I'm going to need to. Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 3:51 PM To: Matthew Walker; [EMAIL PROTECTED]; 'mysql list'; 'Siulun A Sze' Subject: RE: login and logout Matthew... Did you look into the session variables Session_start() Session_register() Mysql, query -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 4:49 PM To: [EMAIL PROTECTED]; mysql list; Siulun A Sze Subject: RE: login and logout The problem with that is, it doesn't allow logout. Siulun, if you /do/ find some good sample code, clue me in. I'm in the market myself. I'm using apache's basic auth right now, but I need to add logout support. Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 3:05 PM To: mysql list; Siulun A Sze Subject: Re: login and logout Don't know what web server your using, but I use apache's .htmaccess feature to control user access. Works good for me, and its pretty easy to setup. Mike - Original Message - From: Siulun A Sze [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 08, 2002 4:04 PM Subject: login and logout Does anyone have a php sample code handling login and logout using cookie? I tried to use SESSION, but when I click back on the browswer, it lost all the data I previously entered in a form. I want to have a section on the website that is only used by registered users. The site developed using PHP with query mysql on the backend. Thanks, Siulun __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.332 / Virus Database: 186 - Release Date: 3/6/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.332 / Virus Database: 186 - Release Date: 3/6/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.332 / Virus Database: 186 - Release Date: 3/6/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.332 / Virus Database: 186 - Release Date: 3/6/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Simultaneous SELECT and UPDATE on the same table
At 21:14 +0100 3/8/02, Roger Baklund wrote: * Paul DuBois At 17:00 + 3/8/02, Corin Hartland-Swann wrote: [...] This works for a varying number of rows (usually 5,000 to 10,000) before it silently exits the loop. I'm using MySQL 3.23.49a [...] That's also your problem. With mysql_use_result, it's *required* that you completely finish the query before issuing another one. I suppose you could write the IDs to a file, then read them back in and use them to issue the UPDATE statements. Why not make two connections, SELECT from one and UPDATE through the other? I thought of that, too, but I don't think it would work. The SELECT locks the table until it's done. That will lock out the UPDATE, which needs a WRITE lock no matter which connection it's done over. Of course, if anyone tries it and find that it works, I'd be interested to know that. -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Some PHP - mySQL help please ... new to both
Dan, Have you taken a look at phpMyAdmin? This very good tool not only administers your MySQL databases, but their php code is a good teaching tool, as well. Simply drop the whole thing into an apache-served directory, and you're off to the races! It's on Sourceforge, and anyone on this list can benefit from it. http://sourceforge.net Let me know how this works out! Lou -Original Message- From: Daniel Negron/KBE [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 11:05 AM To: [EMAIL PROTECTED] Subject: Some PHP - mySQL help please ... new to both I am very new to both PHP and mySQL. Any help would be greatly appreciated. While running this code I get following fatal error. PHP is installed and running correctly on the server. mySQL I THINK is running properly. I created a table and this code is from a tutorial I am trying to run through for discussion threads. No matter what I make the connection as (admin or nobody) I still get the same result, which leads me to believe that there is something wrong with the coding. I am too new to this to debug. Line 5 of the dbconnect.php file is where the script stops. again any help would be greatly 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
RE: login and logout (OT)
I've been poking around some more online, and I've found a very nice session module, that can easily be expanded to handle user logins. Check it out at http://www.php.lt/sqlsession/ Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: Matthew Walker Sent: Friday, March 08, 2002 4:03 PM To: Todd Williamsen; mysql list Subject: RE: login and logout (OT) I have, but I'd rather not reinvent the wheel if I don't have to, though I'm almost to the point where I'm going to need to. Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 3:51 PM To: Matthew Walker; [EMAIL PROTECTED]; 'mysql list'; 'Siulun A Sze' Subject: RE: login and logout Matthew... Did you look into the session variables Session_start() Session_register() Mysql, query -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 4:49 PM To: [EMAIL PROTECTED]; mysql list; Siulun A Sze Subject: RE: login and logout The problem with that is, it doesn't allow logout. Siulun, if you /do/ find some good sample code, clue me in. I'm in the market myself. I'm using apache's basic auth right now, but I need to add logout support. Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, March 08, 2002 3:05 PM To: mysql list; Siulun A Sze Subject: Re: login and logout Don't know what web server your using, but I use apache's .htmaccess feature to control user access. Works good for me, and its pretty easy to setup. Mike - Original Message - From: Siulun A Sze [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 08, 2002 4:04 PM Subject: login and logout Does anyone have a php sample code handling login and logout using cookie? I tried to use SESSION, but when I click back on the browswer, it lost all the data I previously entered in a form. I want to have a section on the website that is only used by registered users. The site developed using PHP with query mysql on the backend. Thanks, Siulun __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.330 / Virus Database: 184 - Release Date: 2/28/02 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.332 / Virus Database: 186 - Release Date: 3/6/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.332 / Virus Database: 186 - Release Date: 3/6/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.332 / Virus Database: 186 - Release Date: 3/6/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.332 / Virus Database: 186 - Release Date: 3/6/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED]
Re: MySQL 4.0.x Replication Just Dumped Core...
On Fri, Mar 08, 2002 at 03:14:31PM -0700, Sasha Pachev wrote: On Thursday 07 March 2002 10:48 pm, Jeremy Zawodny wrote: The 4.0.x slave I had just rebuilt the other day died about 40 minutes ago and produced a core file each time. ?It got caught in the cycle of core dump, restart, core dump, restart... Jeremy: I have tracked down and fixed the assertion failure issue. However, I am still not certail why the sql thread does partial reads. I have pushed my fix into the public tree, so let's have you pull it and try again. Yeah, I just saw that. I'll rebuild and let it run. I am curious to see : a) if re-try after the failed read will actually do any good b) why the read is failing in the first place Right. if a) does not do any good the daemon will be stuck trying to read the same event, but will not generate assertion failure. b) could be happening because of some system failure, or it could be a logic error. In any case, I would like to have a look at db3-relay-bin.005. You'll find db3-relay-bin.005.gz uploaded in the secret directory on your support FTP server. Once completely uploaded, it's about 29MB in size. Thanks! Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 29 days, processed 1,015,158,099 queries (398/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Request-URI Too Large
Hi, I'm using php and mysql as my server, when I'm updating a large page on my database using a browser I get Request-URI Too Large the requested URL's length exceeds the capacity limit for this server. request failed: URI too long Why is this so? Do I need to adjust something on mysql or my phpscript? Please advice. Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Request-URI Too Large
I'm using php and mysql as my server, when I'm updating a large page on my database using a browser I get Request-URI Too Large the requested URL's length exceeds the capacity limit for this server. request failed: URI too long Why is this so? Do I need to adjust something on mysql or my phpscript? Try putting method=post in your form I.e: form action=foo.php method=post :wq //andreas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 4.0.x Replication Just Dumped Core...
On Fri, Mar 08, 2002 at 05:10:02PM -0800, Jeremy Zawodny wrote: I have tracked down and fixed the assertion failure issue. However, I am still not certail why the sql thread does partial reads. I have pushed my fix into the public tree, so let's have you pull it and try again. Yeah, I just saw that. I'll rebuild and let it run. The new code is up and running well. Interestingly, the very slow SHOW SLAVE STATUS problems seem to have diminished. The longest I've waited for one of those is about 4-5 seconds. That's down from 25-30 seconds with the previous version I had built. Don't know if you changes would have impacted that or not. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 29 days, processed 1,016,694,208 queries (397/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Simultaneous SELECT and UPDATE on the same table
Hi there, On Fri, 8 Mar 2002, Paul DuBois wrote: At 21:14 +0100 3/8/02, Roger Baklund wrote: * Paul DuBois At 17:00 + 3/8/02, Corin Hartland-Swann wrote: [...] This works for a varying number of rows (usually 5,000 to 10,000) before it silently exits the loop. I'm using MySQL 3.23.49a [...] That's also your problem. With mysql_use_result, it's *required* that you completely finish the query before issuing another one. I suppose you could write the IDs to a file, then read them back in and use them to issue the UPDATE statements. Why not make two connections, SELECT from one and UPDATE through the other? Roger/Paul - sorry - I was half asleep when I wrote the paraphrased code. It should have featured _two_ database handles, as suggested: -- $sth = $dbh1-prepare(SELECT id,num FROM table, { 'mysql_use_result' = 1 }); $sth-execute; $sth-bind_columns(\$id, \$num); while ($sth-fetch) { $new_num = $hash{$id}; $dbh2-do(UPDATE table SET num = $new_num WHERE id = $id) if $num != $new_num; } $sth-finish; -- I thought of that, too, but I don't think it would work. The SELECT locks the table until it's done. That will lock out the UPDATE, which needs a WRITE lock no matter which connection it's done over. Of course, if anyone tries it and find that it works, I'd be interested to know that. Well, as above, it works - but then it just stops after 5k-10k rows. I've checked the database log and the UPDATE queries do NOT stall waiting for the SELECT to complete - they appear in the log at a rate of about 300 per second. In checking the logs, I realised I should probably point out that although 5k-10k rows are /scanned/, only 600 or so rows are /updated/. This is weird, and I really can't work out what is going on. If someone conclusively tells me (Monty?) that things don't work this way then I'll do it another way (as discussed above) but otherwise I'd like to know what might be going wrong. For the record, I am not using UPDATE LOW_PRIORITY - just a normal one. Thanks again, Corin /+-\ | Corin Hartland-Swann |Tel: +44 (0) 20 7491 2000| | Commerce Internet Ltd |Fax: +44 (0) 20 7491 2010| | 22 Cavendish Buildings | Mobile: +44 (0) 79 5854 0027| | Gilbert Street | | | Mayfair|Web: http://www.commerce.uk.net/ | | London W1K 5HJ | E-Mail: [EMAIL PROTECTED]| \+-/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php