Re: Mysql - Upgrading from 3.23.53 to 3.23.54
Hi. You need automake ver. 1.5 don't use 1.5d (i did it and spent couple of hours to discover, why source rpm 3.23.54a don't rebuild ) autoconf is 2.52 libtool is 1.4.3 Regards. - Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, December 17, 2002 2:02 PM Subject: re: Mysql - Upgrading from 3.23.53 to 3.23.54 > On Monday 16 December 2002 16:24, Santiago Alba wrote: > > > I have installed MySQL 2.23.53 release and I want to upgrade to MySQL > > 2.23.54... how can > > I do this? Have i got to reinstall? Is there any script? > > As usual ;) > > Seriously speaking - depends on the way have you installed it. > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [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 > --r-e-k-l-a-m-a- Masz dosc placenia prowizji bankowi ? mBank - zaloz konto http://epieniadze.onet.pl/mbank - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 about 3.23.53a max for windows ?
Oh, it's my "little" mistake. By the way, when version *.53 for windowze users ? Regards I. piasecki - Original Message - From: "Ireneusz Piasecki" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 17, 2002 12:23 PM Subject: What about 3.23.53a max for windows ? > Hi. > > When will version 3.23.53a for windows users ? > I downloaded version 3.23.53 but in zip package were mysql version 3.23.52. > (innodb not working in this wersion on win98). What about this ?? > Little mistake ? > > I. Piasecki > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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
What about 3.23.53a max for windows ?
Hi. When will version 3.23.53a for windows users ? I downloaded version 3.23.53 but in zip package were mysql version 3.23.52. (innodb not working in this wersion on win98). What about this ?? Little mistake ? I. Piasecki - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
win98+mysql3.23.52+innodb (upgrade from 3.23.51)
Hi. I have problem. I would like to upgrad from 3.23.51 on my win98 to 3.23.52 but with innodb tables 3.23.52 hang on starting. and my win98 goes slowly and slowly. ctrl-alt-del helps :) In log i see: 010820 20:20:13 C:\MYSQL\BIN\MYSQLD.EXE: Got signal 2. Aborting! 010820 20:20:13 Aborting 010820 20:20:16 InnoDB: Warning: shutting down a not properly started InnoDB: or created database! I made downgrading to 3.23.51 all is allright. Server is going. Any idea ? P.s. I have frontpage 2002 instaled on my win98 box, during instalation some files were changed by frontpage 2002 instalator. regards, Irek - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Win98, mysql 3.23.52 (problems) and 3.23.51 (is ok) with innodb
Hi. I have problem. I would like to upgrad from 3.23.51 on my win98 to 3.23.52 but with innodb tables 3.23.52 hang on starting. and my win98 goes slowly and slowly. ctrl-alt-del helps :) In log i see: 010820 20:20:13 C:\MYSQL\BIN\MYSQLD.EXE: Got signal 2. Aborting! 010820 20:20:13 Aborting 010820 20:20:16 InnoDB: Warning: shutting down a not properly started InnoDB: or created database! I made downgrading to 3.23.51 all is allright. Server is going. Any idea ? P.s. I have frontpage 2002 instaled on my win98 box, during instalation some files were changed by frontpage 2002 instalator. regards, Irek - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Win98 +upgrade to MySQL 3.23.52 hangs with innodb tables.
Hi. I have problem. I would like to upgrad from 3.23.51 on my win98 to 3.23.52 but with innodb tables 3.23.52 hang on starting. and my win98 goes slowly and slowly. ctrl-alt-del helps :) In log i see: 010820 20:20:13 C:\MYSQL\BIN\MYSQLD.EXE: Got signal 2. Aborting! 010820 20:20:13 Aborting 010820 20:20:16 InnoDB: Warning: shutting down a not properly started InnoDB: or created database! I made downgrading to 3.23.51 all is allright. Server is going. Any idea ? P.s. I have frontpage 2002 instaled on my win98 box, during instalation some files were changed by frontpage 2002 instalator. regards, Irek - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Re:Serwer MySQL 3.23.51 sometime acts as zombie on my linux 6.2 machine
Hi. No, the log serwer.err is clear. No errors. mysql serwer is running from may 2002 , before i have mysql 3.23.49. Sometimes he also was as zombie process. Now a have 3.23.51. The problem still exists, system working, so i don't know, it is dangerous sytuation ? regards, Irek. - Original Message - From: "Oliver Six" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> Sent: Monday, July 08, 2002 11:38 AM Subject: Re:Serwer MySQL 3.23.51 sometime acts as zombie on my linux 6.2 machine > "Ireneusz Piasecki" <[EMAIL PROTECTED]> wrote on 08.07.2002 11:22:23: > > > > >Hi friends. > > > > I have build mysq from source rpm with gcc 2.95-2 on my linux 6.2 box, > > kernel 2.2.19. > > > > When i do ps -ax on shell, i see below > > > > 5807 ?Z 0:00 [mysqld ] > > > > this happens somtimes, but table are'nt coruppted. I have checked it. > > > > It is dangerous for my system, that server MySQL is sometimes defunct > > (zombie). I noticed, he is selfrepaired, sencond time when i make ps -ax, > > all is allright. server is running as usual (no zombie). > > > > Regards > > Irek. > > > Hi Irek, > > do you have something in the logs (i.e. /var/lib/mysql/.log) when > this happens? > > Bye Oliver > -- > Good programming is 40% experience, 30% skill, 20% RTFM, 10% caffeine, and 5% > attention to detail. > > Oliver Six, CEO > CAHOS GmbH, Cimbernstr. 51, Germany 81377 Muenchen > Phone +49 89 71 01 93 41, Fax +49 89 71 01 93 42 > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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
Serwer MySQL 3.23.51 sometime acts as zombie on my linux 6.2 machine
Hi friends. I have build mysq from source rpm with gcc 2.95-2 on my linux 6.2 box, kernel 2.2.19. When i do ps -ax on shell, i see below 5807 ?Z 0:00 [mysqld ] this happens somtimes, but table are'nt coruppted. I have checked it. It is dangerous for my system, that server MySQL is sometimes defunct (zombie). I noticed, he is selfrepaired, sencond time when i make ps -ax, all is allright. server is running as usual (no zombie). Regards Irek. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
serwer MySQL 3.23.51 sometime acts as zombie on my linux 6.2 machine
Hi friends. I have build mysq from source rpm with gcc 2.95-2 on my linux 6.2 box, kernel 2.2.19. When i do ps -ax on shell, i see below 5807 ?Z 0:00 [mysqld ] this happens somtimes, but table are'nt coruppted. I have checked it. It is dangerous for my system, that server MySQL is sometimes defunct (zombie). I noticed, he is selfrepaired, sencond time when i make ps -ax, all is allright. server is running as usual (no zombie). Regards Irek. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Pre-release of MySQL 3.23.50
Hi. I'm running on linux box 6.2 with glibc 2.1 and i compiled from src.rpm mysql. The compiler is gcc 2.95.2. So, the new version of mysql 3.23.50 can i complie with it (2.95.2) or i must upgrade to gcc 3.0.4 ??? Regards, irek. - Original Message - From: "Michael Widenius" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, April 23, 2002 9:26 AM Subject: Pre-release of MySQL 3.23.50 > > Hi! > > 3.23.50 is basicly just a bug fix release compare do 3.23.49a > > There is however two things one should be aware of regarding 3.23.50 > (both only affecting our Linux x86 binaries (normal and RPM's): > > - We have switched to a new updated glib library, because we found a > critical memory corruption bug (introduced by us) in the old glibc > library that we used to compile 3.23.49. > (older MySQL binaries are not affected by this problem) > - We have changed compiler to gcc 3.0.4 (because the old gcc compiler > we used couldn't compile with an alternative glibc library). > > > As 3.23 is a stable release version, we don't want to release 3.23.50 > to the general public right away, as we want to be sure that the new > gcc version works in practice as good as it has worked on our > internal machines. > > You can now find 3.23.50 at the following link: > > http://www.mysql.com/downloads/mysql-3.23-pre.html > > If we don't get any fatal bug reports by the end of the week for this > version, we will then move it to our standard download page. > > If you find anything wrong/strange with this release compared to > older 3.23 releases, please send a full bug report to > [EMAIL PROTECTED] and we will fix it ASAP! > > Changes in release 3.23.50 > -- > >* Fixed problem with `crash-me' and gcc 3.0.4. > >* Fixed that `@@unknown_variable' doesn't hang server. > >* Added `@@VERSION' as a synonym for `VERSION()'. > >* `SHOW VARIABLES LIKE 'xxx'' is now case insensitive. > >* Fixed timeout for `GET_LOCK()' on HPUX with DCE threads. > >* Fixed memory allocation bug in the glibc library used to build > Linux binaries, which caused mysqld to die in 'free()'. > >* Fixed `SIGINT' and `SIGQUIT' problems in `mysql'. > >* Fixed bug in character table converts when used with big ( > 64K) > strings. > >* `InnoDB' now retains foreign key constraints through `ALTER TABLE' > and `CREATE/DROP INDEX'. > >* `InnoDB' now allows foreign key constraints to be added through the > `ALTER TABLE' syntax. > >* `InnoDB' tables can now be set to automatically grow in size > (autoextend). >* Fixed some buffer overflow problems when reading startup > parameters. > >* Because of problems on shutdown we have now disabled named pipes on > windows by default. One can enable named pipes by starting mysqld > with `--enable-named-pipe'. > >* Fixed bug when using `WHERE key_column = 'J' or key_column='j''. > >* Fixed core-dump bug when using `--log-bin' with `LOAD DATA INFILE' > without an active database. > >* Fixed bug in `RENAME TABLE' when used with > `lower_case_table_names=1' (default on Windows). > >* Fixed unlikely core-dump bug when using `DROP TABLE' on a table > that was in use by a thread that also used queries on only > temporary tables. > >* Fixed problem with `SHOW CREATE TABLE' and `PRIMARY KEY' when using > 32 indexes. > >* Fixed that one can use `SET PASSWORD' for the anonymous user. > >* Fixed core-dump bug when reading client groups from option files > using `mysql_options()'. > >* Memory leak (16 bytes per every *corrupted* table) closed. > >* Fixed binary builds to use `--enable-local-infile'. > >* Update source to work with new `bison' version. > >* Updated shell scripts to new agree with new POSIX standard. > >* Fixed bug where `DATE_FORMAT()' returned empty string when used > with `GROUP BY'. > > > Regards, > Monty > CTO of MySQL AB > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > -- Encyklopedia multimedialna w prezencie! http://www.e-mail.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
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
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 + rpm --rebuild + 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 -- Określ 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
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.
Re: Which Linux version to download (all?)
sorry. I made mistake. Cite should be like this: " The MySQL RPMs are currently being built on a RedHat Version 6.2 system but should work on other versions of Linux that support rpm and use glibc." - from http://www.mysql.com/doc/L/i/Linux-RPM.html I. Piasecki. - Original Message ----- From: "Ireneusz Piasecki" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "Egor Egorov" <[EMAIL PROTECTED]> Sent: Wednesday, March 06, 2002 4:15 PM Subject: Re: Which Linux version to download (all?) > Hi. > > Yopu wrote. > >You can find info about MySQL installation on Linux if you check > > the following links: > > http://www.mysql.com/doc/L/i/Linux-RPM.html > > http://www.mysql.com/doc/L/i/Linux.html > > > > The section: linux-rpm.html it seems to bee out of date: > > " The MySQL RPMs are currently being built on a RedHat Version 6.2 system > but should work on other versions of Linux that support rpm and use glibc. > But "a kuku". On RH 6.2 with glibc 2.1 that isn't work." - from this > section. > > I find, that all user of 6.2 if they want to run mysql from RPM 2.32.49 or > above must have glibc 2.2, so must upgrade system to RH 7.0 or above. > > I give up. I will upgrade my RH.6.2 to 7.2 to have the newest mysql 3.23.49. > AMEN. > > Bye. > I. Piasecki. > > - Original Message - > From: "Egor Egorov" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, March 06, 2002 3:48 PM > Subject: Which Linux version to download (all?) > > > > Elissa, > > > > Wednesday, March 06, 2002, 6:44:26 AM, you wrote: > > > > E> I'm a newie to SQL, and to Linux, so please forgive my blaring > blunders... > > > > E> I know I have an x86 Linux machine, running Redhat 7.2, and I know that > I > > E> like RPMs better than binary installations > > > > E> When I get to the Stable Version/Linux/RPMs download area, the > following > > E> options are available: > > > > E> MySQL 3.23.49a Server (i386) (14M) > > > > E> MySQL 3.23.49a Benchmark/test suites (i386) (690K) > > > > E> MySQL 3.23.49a Client programs (i386) (5.2M) > > > > E> MySQL 3.23.49a Libraries and Header files for development (i386) > (1.2M) > > > > E> MySQL 3.23.49a Client shared libraries (i386) (231K) > > > > E> My question is: do I have to install ALL these files? I'm just a little > > E> end-user, who wants to make my own database for academic sources, > notes, > > E> maybe my own addressbook (I like custom-configured stuff, I used to do > a lot > > E> of it with Filemaker Pro). I'm never going to use this on a server or > do > > E> development stuff with it. Which of the above RPMs do I download and > > E> install? I thought I'd find out for sure before I downloaded all this > stuff > > E> (not with a high-speed modem...). I'm planning on using a MySQL gui > that > > E> works well in Gnome or KDE. > > > > For minimal installation you should install MySQL server and MySQL > > client. > > You can find info about MySQL installation on Linux if you check > > the following links: > > http://www.mysql.com/doc/L/i/Linux-RPM.html > > http://www.mysql.com/doc/L/i/Linux.html > > > > E> Elissa Teeple > > > > > > > > > > > > -- > > For technical support contracts, goto https://order.mysql.com/ > > This email is sponsored by Ensita.net http://www.ensita.net/ > >__ ___ ___ __ > > / |/ /_ __/ __/ __ \/ /Egor Egorov > > / /|_/ / // /\ \/ /_/ / /__ [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 > > > > > > -- > > 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 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: Which Linux version to download (all?)
Hi. Yopu wrote. >You can find info about MySQL installation on Linux if you check > the following links: > http://www.mysql.com/doc/L/i/Linux-RPM.html > http://www.mysql.com/doc/L/i/Linux.html > The section: linux-rpm.html it seems to bee out of date: " The MySQL RPMs are currently being built on a RedHat Version 6.2 system but should work on other versions of Linux that support rpm and use glibc. But "a kuku". On RH 6.2 with glibc 2.1 that isn't work." - from this section. I find, that all user of 6.2 if they want to run mysql from RPM 2.32.49 or above must have glibc 2.2, so must upgrade system to RH 7.0 or above. I give up. I will upgrade my RH.6.2 to 7.2 to have the newest mysql 3.23.49. AMEN. Bye. I. Piasecki. - Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 06, 2002 3:48 PM Subject: Which Linux version to download (all?) > Elissa, > > Wednesday, March 06, 2002, 6:44:26 AM, you wrote: > > E> I'm a newie to SQL, and to Linux, so please forgive my blaring blunders... > > E> I know I have an x86 Linux machine, running Redhat 7.2, and I know that I > E> like RPMs better than binary installations > > E> When I get to the Stable Version/Linux/RPMs download area, the following > E> options are available: > > E> MySQL 3.23.49a Server (i386) (14M) > > E> MySQL 3.23.49a Benchmark/test suites (i386) (690K) > > E> MySQL 3.23.49a Client programs (i386) (5.2M) > > E> MySQL 3.23.49a Libraries and Header files for development (i386) (1.2M) > > E> MySQL 3.23.49a Client shared libraries (i386) (231K) > > E> My question is: do I have to install ALL these files? I'm just a little > E> end-user, who wants to make my own database for academic sources, notes, > E> maybe my own addressbook (I like custom-configured stuff, I used to do a lot > E> of it with Filemaker Pro). I'm never going to use this on a server or do > E> development stuff with it. Which of the above RPMs do I download and > E> install? I thought I'd find out for sure before I downloaded all this stuff > E> (not with a high-speed modem...). I'm planning on using a MySQL gui that > E> works well in Gnome or KDE. > > For minimal installation you should install MySQL server and MySQL > client. > You can find info about MySQL installation on Linux if you check > the following links: > http://www.mysql.com/doc/L/i/Linux-RPM.html > http://www.mysql.com/doc/L/i/Linux.html > > E> Elissa Teeple > > > > > > -- > For technical support contracts, goto https://order.mysql.com/ > This email is sponsored by Ensita.net http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [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 > -- 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 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 ?????
Do you mean: You can forget upgrading on RH6.2 the glibc 2.1 to 2.2. Maybe one did it succesful, so now he has RH.6.2 with glibc 2.2. I still waiting for these persons. P.S: I don't understand word: cos. Is it: Computer Operating System ? regards. - Original Message - From: "Ben Edwards" <[EMAIL PROTECTED]> To: "Ireneusz Piasecki" <[EMAIL PROTECTED]> Sent: Wednesday, March 06, 2002 12:44 PM Subject: Re: Why v3.23.49 does not build on RedHat 6.2 ? Cos redhat is at least at 7, you have an old version. At 08:33 06/03/2002, you wrote: >Hi. >I have following rpm packages from redhat.com: >glibc-2.2.2-10.i386.rpm >glibc-2.2.2-10.i686.rpm >compat-glibc-6.2-2.1.3.2.i386.rpm >glibc-common-2.2.2-10.i386.rpm >glibc-devel-2.2.2-10.i386.rpm > >I get this packet to upgrade my glibc 2.1 running on my RH 6.2 system, but >it fails. >Do i have missed some rpm packages ? >When yes, where can i it found ? >Maybe it is impossible to upgrade glibc2.1 to 2.2 on RH 6.2 ? >I don't would like to change to RH 7.2 >I use rpm 4.0.2. >regrads >I. Piasecki. > >- Original Message - >From: "Trond Eivind Glomsrød" <[EMAIL PROTECTED]> >To: "Dr. Michael Wittmann" <[EMAIL PROTECTED]> >Cc: "Gabriele Carioli" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> >Sent: Wednesday, March 06, 2002 1:32 AM >Subject: Re: Why v3.23.49 does not build on RedHat 6.2 ? > > > > "Dr. Michael Wittmann" <[EMAIL PROTECTED]> writes: > > > > > one solution could be to install a more recent compiler version and try > > > to recompile again. be aware that actual rpm's will be created by rpm > > > version 4, whereas redhat 6.2 has rpm version 3 installed which possibly > > > cannot handle version-4-rpm's > > > > Everyone on RHL 6.2 should be running rpm v4 - if not, they are > > extremely likely to have plenty of unpatched security holes. > > > > > besides that, there may be glibc issues. redhat 6.2 has glibc 2.1.3 > > > installed. i don't know if actual gcc or mysql versions work ok if > > > compiled against this 'old' glibc. afaik, redhat does _not_ recommend to > > > update the glibc version installed... > > > > I would definitely recommend against a major upgrade, e.g. to > > 2.2. Sizes and interfaces change, so that while old binaries will > > continue working, anything compiled afterwards will get in a world of > > pain. > > > > -- > > 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 > > > > > >-- > >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 * Ben Edwards +44 (0)117 9400 636 * * Critical Site Builderhttp://www.criticaldistribution.com * * online collaborative web authoring content management system * * i-Contact Progressive Video http://www.videonetwork.org * * Smashing the Corporate image http://www.subvertise.org * * Bristol Indymedia http://bristol.indymedia.org * * Bristol's radical news http://www.bristle.org.uk * * PGP : F0CA 42B8 D56F 28AD 169B 49F3 3056 C6DB 8538 EEF8 * -- 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 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 following rpm packages from redhat.com: glibc-2.2.2-10.i386.rpm glibc-2.2.2-10.i686.rpm compat-glibc-6.2-2.1.3.2.i386.rpm glibc-common-2.2.2-10.i386.rpm glibc-devel-2.2.2-10.i386.rpm I get this packet to upgrade my glibc 2.1 running on my RH 6.2 system, but it fails. Do i have missed some rpm packages ? When yes, where can i it found ? Maybe it is impossible to upgrade glibc2.1 to 2.2 on RH 6.2 ? I don't would like to change to RH 7.2 I use rpm 4.0.2. regrads I. Piasecki. - Original Message - From: "Trond Eivind Glomsrød" <[EMAIL PROTECTED]> To: "Dr. Michael Wittmann" <[EMAIL PROTECTED]> Cc: "Gabriele Carioli" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, March 06, 2002 1:32 AM Subject: Re: Why v3.23.49 does not build on RedHat 6.2 ? > "Dr. Michael Wittmann" <[EMAIL PROTECTED]> writes: > > > one solution could be to install a more recent compiler version and try > > to recompile again. be aware that actual rpm's will be created by rpm > > version 4, whereas redhat 6.2 has rpm version 3 installed which possibly > > cannot handle version-4-rpm's > > Everyone on RHL 6.2 should be running rpm v4 - if not, they are > extremely likely to have plenty of unpatched security holes. > > > besides that, there may be glibc issues. redhat 6.2 has glibc 2.1.3 > > installed. i don't know if actual gcc or mysql versions work ok if > > compiled against this 'old' glibc. afaik, redhat does _not_ recommend to > > update the glibc version installed... > > I would definitely recommend against a major upgrade, e.g. to > 2.2. Sizes and interfaces change, so that while old binaries will > continue working, anything compiled afterwards will get in a world of > pain. > > -- > 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 > -- 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
Re: Do i need licence for using mysql in my project ?
Hi, again. Hmm. 1) Lets supose, i have ISP that supports mysql+apache+PHP. My php+mysql+apache based system is located on the ISP server. When i sell this PHP application to my client (any Company), this company works with my system over Internet on ISP. Anybody need licence ? I, the Client or my ISP ?? I would get the money for my job (system). 2) Supose, i give my system free for that Company, but all rights belong to me. Do i need licence for mysql ? 3) Supose, one men, works in this company, hi made system based on PHP+mysql+apache. He bought computer, installed linux,apache,php and mysql. Does his Company need buy a Licence for mysql server. They are using it internal in Company, as intranet system. Regards. P.S. can i buy in Poland mysql commercial license or i must do that only by Internet ? I. Piasecki. - Original Message - From: "Benjamin Pflugmann" <[EMAIL PROTECTED]> To: "Ireneusz Piasecki" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, February 25, 2002 8:57 PM Subject: Re: Do i need licence for using mysql in my project ? > Hi. > > On Mon, Feb 25, 2002 at 04:08:56PM +0100, [EMAIL PROTECTED] wrote: > > Hi guys. > > I made system. it is based on php+apache+mysql. > > This system i would like to sell a Company. > > Must i or this Company buy any licence from mySQL AB to legally use mysql > > with apache+PHP in this system ? > > This is answered under > http://www.mysql.com/doc/U/s/Using_the_MySQL_server_under_a_commercial_licen se.html > > This page answers your question with "yes", if your program cannot run > without MySQL. This is a topic under discussion sometimes. The > official GPL FAQ says the following about this: > http://www.gnu.org/copyleft/gpl-faq.html#GPLInProprietarySystem > > If you want to be on the safe side or be fair (i.e. pay something back > for what you got), purchasing a license is the thing to do. > > > I need quickly an answer. > > Then you should have written to [EMAIL PROTECTED], which is the right > address for such concerns (as explained in the manual). :-) > > Bye, > > Benjamin. > > -- > [EMAIL PROTECTED] -- 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
Do i need licence for using mysql in my project ?
Hi guys. I made system. it is based on php+apache+mysql. This system i would like to sell a Company. Must i or this Company buy any licence from mySQL AB to legally use mysql with apache+PHP in this system ? I need quickly an answer. Regards. I. Piasecki -- 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 unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with mysql 3.23.49 rpm install
Hi. I want upgrade mysql from 3.23.48 to 3.23.49 but i see that. first. shared ># /usr/lib/mc/extfs/rpm run /home/httpd/MySQL-shared-3.23.49-1.i386.rpm UPGRADE Upgrading "/home/httpd/MySQL-shared-3.23.49-1.i386.rpm" error: failed dependencies: libc.so.6(GLIBC_2.2) is needed by MySQL-shared-3.23.49-1 libpthread.so.0(GLIBC_2.2) is needed by MySQL-shared-3.23.49-1 Press any key to continue... second. mysql server but ocurrs some strange errors. My system is RH 6.2 regards, i. Piasecki. -- 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 unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL/InnoDB-3.23.49 is released
Hi. Thanks for this version. Thanks. This wersion not work on my linux RH 6.2 zoot. Version 3.23.48 runs fine, but with wersion 2.23.49 not (this version is bigger than previous server's version). Why ? I make upgrade from MC on my linux box and i cannot start mysql server. What a chek. So for who is this version ?? I see, not for me. What should i do ? Mysql server from rpm -> 3.23.49-1.i386.rpm don't go. I have some errors. Agrrh. Regrads. I. Piasecki. - Original Message - From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, February 18, 2002 12:25 PM Subject: MySQL/InnoDB-3.23.49 is released > Hi! > > InnoDB is a MySQL table type which adds transactions, row level locking, and > foreign key constraints to MySQL. > > InnoDB is included in the MySQL-Max-3.23, MySQL-4.0, and MySQL-Max-4.0 > distributions of MySQL. These can be downloaded from http://www.mysql.com. > For more information about InnoDB see the online refererence manual at > http://www.innodb.com. > > MySQL AB decided to release 3.23.49 so quickly after .48 because the Linux > binary of .48 was linked against a wrong glibc, and it did not work properly > in some computers. > > There are the following bug fixes in InnoDB: > > * Fixed a bug: if you called DROP DATABASE for a database on which there > simultaneously were running queries, the MySQL server could crash or hang. > Crashes fixed, but a full fix has to wait some changes in the MySQL layer of > code. > > * Fixed a bug: on Windows one had to put the database name in lower case for > DROP DATABASE to work. Fixed in 3.23.49: case no longer matters on Windows. > On Unix the database name remains case-sensitive. > > * Fixed a bug: if one defined a non-latin1 character set as the default > character set, then definition of foreign key constraints could fail in an > assertion failure in dict0crea.c, reporting an internal error 17. > > In the MySQL part of code the changelog is the following: > > http://www.mysql.com/doc/N/e/News-3.23.49.html : > > * Don't give warning for statement that is only a comment; This is needed > for mysqldump --disable-keys to work. > > * Fixed unlikely caching bug when doing a join without keys. In this case > the last used field for a table always returned NULL. > > * Added options to make LOAD DATA LOCAL INFILE more secure. > > * MySQL binary release 3.23.48 for Linux contained a new glibc library, > which has serious problems under high load and RedHat 7.2. The 3.23.49 > binary release doesn't have this problem. > > Best regards, > > Heikki Tuuri > Innobase Oy > --- > InnoDB - transactions, row level locking, and foreign key support for MySQL > See http://www.innodb.com, download MySQL-Max from http://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 > -- 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 unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql from localhost vs. remote
Hi I see: local-system> mysql -h 66.70.34.150 -O 3307 -u xyz00 -p hmm. I always use: >mysql -u xyz -p -h ... -P 3306 Is the -O option in the right place. Maybe it sould be -P like PORT. Isn't ?? Regards. I. Piasecki - webmaster www.b-c.pl - Original Message - From: "Michael Hoennig" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, February 15, 2002 3:37 PM Subject: Re: mysql from localhost vs. remote > Hi Dimitry, > > > > But we can NOT connect locally by host:port: > > > > > local-system> mysql -h 66.70.34.150 -O 3307 -u xyz00 -p > > > => ERROR 1045: Access denied for user: 'xyz00@localhost' (Using > > > password: YES) > > > > > On a mysqld which is accessible only locally the both INSERT > > > statements above would have "localhost" instead of "%". Why does > > > "localhost" not qualify for "%"? > > > > Probably because you already have entry for 'localhost','%' or something > > to that effect. > > nope, there is not such an entry. But IF we add it, we can login. This > just means that we have to insert two entries (% and localhost) each. It > looks clumsy to me. > > Michael > > -- > Hostsharing eG / c/o Michael Hönnig / Boytinstr. 10 / D-22143 Hamburg > phone:+49/40/67581419 / mobile:+49/177/3787491 / fax:++49/40/67581426 > http://www.hostsharing.net ---> Webhosting Spielregeln selbst gemacht > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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 unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
upgrading mysql-3.23.48 and rpm package.
Hi all. I would upgrade my mysql serever from RPM: rpm -i MySQL-3.23.48-1.i386.rpm only packages with major numbers <= 3 are supported by this version of RPM error: MySQL-3.23.48-1.i386.rpm cannot be installed What can i solve this problem. I use Red Hat 6.2 Where can i find the RPM engine to install mysql 3.23.48 ? With mysql 3.23.47 was no problem Pleas help. Regards I. Piasecki -- 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 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: upgrading mysql-3.23.48 and rpm package.
HI. No i get twice the .rpm of mysql-3.23.48. It is'nt corrupted. I could'nt install it. I have rpm 3.0.4. on my RH 6.2 (Zoot) box. Is there on the NET, rpm package of mysql-3.23.48, which can i install with rpm 3.0.4 ? - Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, February 11, 2002 4:46 PM Subject: upgrading mysql-3.23.48 and rpm package. > Ireneusz, > > Monday, February 11, 2002, 5:16:53 PM, you wrote: > > IP> Hi all. > IP> I would upgrade my mysql serever from RPM: > > IP> rpm -i MySQL-3.23.48-1.i386.rpm > IP> only packages with major numbers <= 3 are supported by this version of RPM > IP> error: MySQL-3.23.48-1.i386.rpm cannot be installed > > IP> What can i solve this problem. I use Red Hat 6.2 > IP> Where can i find the RPM engine to install mysql 3.23.48 ? > > IP> With mysql 3.23.47 was no problem > > May be you have a corrupted installation package. Try to download the > MySQL 3.23.48 (rpm) again from: > http://www.mysql.com/downloads/mysql-3.23.html > > IP> Pleas help. > > IP> Regards > IP> I. Piasecki > > > > > > -- > For technical support contracts, goto https://order.mysql.com/ > This email is sponsored by Ensita.net http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [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 > -- 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
Re: Is my table good indexed ?
Hi folks. I have table: mysql> describe gosc; +-+-+--+-+-+ ---+ | Field | Type| Null | Key | Default | Extra | +-+-+--+-+-+ ---+ | sesja | varchar(32) binary | | PRI | | | | host| varchar(80) | YES | MUL | NULL| | | data_wej| datetime| | MUL | -00-00 00:00:00 | | | browser | varchar(100)| YES | | NULL| | | last_action | datetime| | MUL | -00-00 00:00:00 | | | id_pory1| int(3) unsigned | YES | | NULL| | | id_pory2| int(3) unsigned | YES | | NULL| | | nr_ip | varchar(15) | YES | | NULL| | | id_user | bigint(12) unsigned | | MUL | 0 | | | user_log| varchar(150)| | | 0- | | +-+-+--+-+-+ ---+ 10 rows in set (1.39 sec) I made: mysql> explain select sesja,data_wej,id_user,user_log,nr_ip from gosc where date_add(last_action, interval 5 minute) > now(); +---+--+---+--+-+--+---+ + | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+--+---+--+-+--+---+ + | gosc | ALL | NULL | NULL |NULL | NULL | 37803 | where used | +---+--+---+--+-+--+---+ + Is my table good indexed ?? Or maybe this query above can be faster ?? Regards Ireneusz Piasecki -- 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 unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: are my table good optimized (using of indexs)
Hi I have this query on ma table: explain select count(przetargi_zaw.id_kat),przetargi_typy.nazwa as typy from przetargi_typy left join przetargi_zaw on przetargi_zaw.id_kat = przetargi_typy.id group by typy; i see: +---+---+---++---+-- -++---+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+---+---++---+-- -++---+ | przetargi_typy | ALL | NULL | NULL |NULL | NULL |7 | Using temporary | | przetargi_zaw | ref | id_kat | id_kat | 4 | przetargi_typy.id | 14 | Using index | +---+---+---+-+--+-- -++---+ 2 rows in set (0.00 sec) Are my table good optimized ?? (i use index right way ?) Oops, my table: +-++--+-+-++ | Field | Type | Null | Key | Default | Extra | +-++--++-+-- --+ | id | int(7) unsigned | | PRI| NULL| auto_increment | | id_kat | int(5) unsigned | | MUL | 0 | | | krotko | varchar(255) | YES | | NULL| | | nazwa_pliku | varchar(60) | | | | | +-++--++-+-- --+ +---+-+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-++ | id | int(5) unsigned | | PRI | NULL| auto_increment | | nazwa | char(50) | | | - || +---+-+--+-+-++ regards Ireneusz Piasecki KomNet s.c. -- 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 unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Auto_increment
Hi. The behaviour of auto_increment is strange or it's a bug. All is, what are you described above. delete from t1; this command deletes all records and auto_increment will be 1, but if i use mysql-max (3.23.43 with innoDB - all in my.ini is set to handle innoDB) delete from t1; leaves auto_increment statement in older position (don't set it to 1), even t1 is myisam table. I must disable innoDB feature, then auto_increment field works ok after delete from t1; the auto_increment field is 1. it's o.k or it's a bug in mysql-max with innoDB ?? regards I. Piasecki. - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Ireneusz Piasecki" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, November 01, 2001 12:42 AM Subject: Re: Auto_increment > At 2:03 PM +0100 10/31/01, Ireneusz Piasecki wrote: > >HI everybody. > > > >I saw, when i delete all records from the table where id > >is primary key and auto_increment, the first number for id is'nt 1 but next > >in a row (the last was 5 the next will be 6). > > > >Can i change this behavior ? Mybe in file my.ini ? > >The goal is, that when i delete all records from the table the id field > >begin with 1, when i insert a record. > > > >I use 3.23.43-max on win98, the table is myisam type. > > > >regards. I. Piasecki. > > What you observe is what will happen if you delete records using > DELETE statements that have a WHERE clause. > > If you empty the entire table at once like this: > > DELETE FROM tbl_name > > then the AUTO_INCREMENT value will reset to 1. > > This is true for MyISAM tables, not necessarily for other table types. > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Auto_increment
HI everybody. I saw, when i delete all records from the table where id is primary key and auto_increment, the first number for id is'nt 1 but next in a row (the last was 5 the next will be 6). Can i change this behavior ? Mybe in file my.ini ? The goal is, that when i delete all records from the table the id field begin with 1, when i insert a record. I use 3.23.43-max on win98, the table is myisam type. regards. I. Piasecki. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: three tables and count() - Urgent i need it to my job !!
Original Message - From: "Robert Vetter" <[EMAIL PROTECTED]> To: "Ireneusz Piasecki" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, July 05, 2001 4:26 PM Subject: Re: three tables and count() - Urgent i need it to my job !! > > > Ireneusz Piasecki wrote: > > > > Hi my friends !! > > > > Some few days i have problems with count(). > > i have 3 tables: > > > > t1 holds: > > +++ > > | id | number | > > +++ > > | 1 | one| > > | 2 | two| > > | 3 | three | > > | 4 | four | > > | 5 | five | > > | 6 | sixs | > > +++ > > > > t2 holds: > > > > ++---+-+ > > | id | id_t1 | t | > > ++---+-+ > > | 1 | 1| 2001-07-03 15:03:34 | > > | 2 | 1| 2001-07-03 15:03:34 | > > | 3 | 1| 2001-07-03 15:03:34 | > > | 4 | 2| 2001-07-03 15:03:34 | > > | 5 | 3| 2001-07-04 12:00:00 | > > | 6 | 3| 2001-07-04 12:00:00 | > > | 7 | 4| 2001-07-04 13:11:00 | > > ++---+-+ > > > > t3 have it: > > ++---+-+ > > | id | id_t1| t| > > ++---+-+ > > | 1 | 1| 2001-07-04 13:11:00 | > > | 2 | 2| 2001-07-04 13:11:00 | > > | 3 | 3| 2001-07-04 13:11:00 | > > | 4 | 1| 2001-07-04 13:11:00 | > > | 5 | 4| 2001-07-04 13:11:00 | > > | 6 | 4| 2001-07-04 13:11:00 | > > | 7 | 4| 2001-07-04 13:11:00 | > > ++--+--+ > > > > so, my target is: how many rows there are in table t2 and t3 coresponding to t1. > > Column id_t1 in t2 and t3 are values that are present in t1.id. It is important, it must be one query to database. > > > > I make this query: > > > > select t1.id,number,count(t2.id_t1),count(t3.id_t1) from t1 > > left join t2 on t2.id_t1=t1.id > > left join t3 on t3.id_t1=t1.id > > group by number order by number desc > > Hello, > > I don't know what exactly you want to count, but one thing seems to be > obviously to me: You can't make a left join between t2 and t3 on > t3.id_t1=t1.id (line 3 of the query). > > Pozdrowienia do Polski, > > Robert Vetter > Hi, it's me again. select t1.id,number,count(t2.id_t1),count(t3.id_t1) from t1 left join t2 on t2.id_t1=t1.id left join t3 on t3.id_t1=t1.id group by number order by number desc I would like to have this result from above query: this result is correct (i hope) id | number | count(t2_id1) | count(t3_id1)| 1 | one | 3 | 2 | 2 | two | 1 | 1 | 3 | three| 2 | 1 | 4 | four | 1 | 3 | 5 | five | 0 |0 | 6 | six| 0 |0 | With above result i now how many records is in t2 for every records from t1 and how many is in t3 for every records from t1. But, i don't konw, how can i bulid this correct query, to have correct result. Thansk Regards Ireneusz Piasecki - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
three tables and count() - Urgent i need it to my job !!
Hi my friends !! Some few days i have problems with count(). i have 3 tables: t1 holds: +++ | id | number | +++ | 1 | one| | 2 | two| | 3 | three | | 4 | four | | 5 | five | | 6 | sixs | +++ t2 holds: ++---+-+ | id | id_t1 | t | ++---+-+ | 1 | 1| 2001-07-03 15:03:34 | | 2 | 1| 2001-07-03 15:03:34 | | 3 | 1| 2001-07-03 15:03:34 | | 4 | 2| 2001-07-03 15:03:34 | | 5 | 3| 2001-07-04 12:00:00 | | 6 | 3| 2001-07-04 12:00:00 | | 7 | 4| 2001-07-04 13:11:00 | ++---+-+ t3 have it: ++---+-+ | id | id_t1| t| ++---+-+ | 1 | 1| 2001-07-04 13:11:00 | | 2 | 2| 2001-07-04 13:11:00 | | 3 | 3| 2001-07-04 13:11:00 | | 4 | 1| 2001-07-04 13:11:00 | | 5 | 4| 2001-07-04 13:11:00 | | 6 | 4| 2001-07-04 13:11:00 | | 7 | 4| 2001-07-04 13:11:00 | ++--+--+ so, my target is: how many rows there are in table t2 and t3 coresponding to t1. Column id_t1 in t2 and t3 are values that are present in t1.id. It is important, it must be one query to database. I make this query: select t1.id,number,count(t2.id_t1),count(t3.id_t1) from t1 left join t2 on t2.id_t1=t1.id left join t3 on t3.id_t1=t1.id group by number order by number desc But the result is not correct. What shuld to be a query to get right result ??? i would like to have this (it is correct): id | number | count(t2_id1) | count(t3_id1)| 1 | one | 3 | 2 | 2 | two | 1 | 1 | 3 | three| 2 | 1 | 4 | four | 1 | 3 | 5 | five | 0 |0 | 6 | six| 0 |0 | Does anybody help me p.s; mayby that is impossible ?? Ireneusz Piasecki webmaster www.b-c.pl KomNet s.c [EMAIL PROTECTED] tel: 0 606 356 235 [EMAIL PROTECTED]
Problem with count() - URGENT
I have 2 tables: 1) t1 mysql> describe t1; ++-+--+-+-++ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-++ | id | int(3) | | PRI | NULL| auto_increment | | number | varchar(10) | YES | | NULL|| ++-+--+-+-++ 2 rows in set (0.19 sec) mysql> select * from t1; +++ | id | number | +++ | 1 | one| | 2 | two| | 3 | three | | 4 | four | +++ 4 rows in set (0.20 sec) 2) t2 mysql> describe t1; ++-+--+-+-++ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-++ | id | int(3) | | PRI | NULL| auto_increment | | number | varchar(10) | YES | | NULL|| ++-+--+-+-++ 2 rows in set (0.19 sec) mysql> select * from t2; ++---+-+ | id | id_t1 | t | ++---+-+ | 1 | 1 | 2001-07-03 15:03:34 | | 2 | 1 | 2001-07-03 15:03:34 | | 3 | 1 | 2001-07-03 15:03:34 | | 4 | 2 | 2001-07-03 15:03:34 | | 5 | 3 | 2001-07-03 15:03:34 | | 6 | 3 | 2001-07-03 15:03:34 | ++---+-+ 6 rows in set (0.31 sec) I make the folowing query: select t1.number,count(t2.id_t1) from t1 left join t2 on t1.id=t2.id_t1 where t2.t='01-07-03 15:03:34' group by t1.number; I see: ++-+ | number | count(t2.id_t1) | ++-+ | one| 3 | | three | 2 | | two| 1 | ++-+ What happend with column number and value "four" What is correct query to have result below, but where clausule must stay: ++-+ | number | count(t2.id_t1) | ++-+ | one| 3 | | three | 2 | | two| 1 | | four| 0 | ++-+ PLEASE HELP. Regards: Ireneusz Piasecki webmaster www.b-c.pl KomNet s.c [EMAIL PROTECTED] tel: 0 606 356 235 [EMAIL PROTECTED]
count() problem - URGENT !!
I have 2 tables: 1) t1 mysql> describe t1; ++-+--+-+-++ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-++ | id | int(3) | | PRI | NULL| auto_increment | | number | varchar(10) | YES | | NULL|| ++-+--+-+-++ 2 rows in set (0.19 sec) mysql> select * from t1; +++ | id | number | +++ | 1 | one| | 2 | two| | 3 | three | | 4 | four | +++ 4 rows in set (0.20 sec) 2) t2 mysql> describe t1; ++-+--+-+-++ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-++ | id | int(3) | | PRI | NULL| auto_increment | | number | varchar(10) | YES | | NULL|| ++-+--+-+-++ 2 rows in set (0.19 sec) mysql> select * from t2; ++---+-+ | id | id_t1 | t | ++---+-+ | 1 | 1 | 2001-07-03 15:03:34 | | 2 | 1 | 2001-07-03 15:03:34 | | 3 | 1 | 2001-07-03 15:03:34 | | 4 | 2 | 2001-07-03 15:03:34 | | 5 | 3 | 2001-07-03 15:03:34 | | 6 | 3 | 2001-07-03 15:03:34 | ++---+-+ 6 rows in set (0.31 sec) I make the folowing query: select t1.number,count(t2.id_t1) from t1 left join t2 on t1.id=t2.id_t1 where t2.t='01-07-03 15:03:34' group by t1.number; I see: ++-+ | number | count(t2.id_t1) | ++-+ | one| 3 | | three | 2 | | two| 1 | ++-+ What happend with column number and value "four" What is correct query to have result below, but where clausule must stay: ++-+ | number | count(t2.id_t1) | ++-+ | one| 3 | | three | 2 | | two| 1 | | four| 0 | ++-+ PLEASE HELP. Regards: Ireneusz Piasecki webmaster www.b-c.pl KomNet s.c [EMAIL PROTECTED] tel: 0 606 356 235 [EMAIL PROTECTED]
Problem with count() with left join
HI guys ! I have some problem. Let's go ! I have 3 tables. Fields are describe below: 1) table1 | id (int 3) | comment (text) | t (timestamp 14) | she holds: | 1 | there is my comment1 | 200010606123456 | | 2 | there is my comment2 | 200010606123456 | | 3 | there is my comment3 | 200010606123456 | | 4 | there is my comment4 | 200010606123456 | 2) table2 | id (int 3) | id_tab1 (int 3) | img_path (varchar 10) | t (timestamp 14) | she holds: | 1 | 1 | /tmp/1.jpg | 200010606123456 | | 2 | 1 | /tmp/12jpg | 200010606123456 | | 3 | 1 | /tmp/21.jpg | 200010606123456 | | 4 | 2 | /tmp/4.jpg | 200010606123456 | | 5 | 2 | /tmp/45.jpg | 200010606123456 | | 6 | 3 | /tmp/6.jpg | 200010606123456 | | 7 | 3 | /tmp/7.jpg | 200010606123456 | 3) table3 | id (int 3) | id_tab1 (int 3) | story (text) | t (timestamp 14) | she holds: | 1 | 1 | ble ble ble | 200010606123456 | | 2 | 1 | ble ble ble| 200010606123456 | | 3 | 1 | ble ble ble | 200010606123456 | | 4 | 1 | ble ble ble| 200010606123456 | | 5 | 2 | ble ble ble | 200010606123456 | | 6 | 3 | ble ble ble | 200010606123456 | | 7 | 4 | ble ble ble | 200010606123456 | I would like to count, how many rows in table2 and table3 coresponding to table1 and i made this query: select table1.id,count(table2.id_tab1),count(table3.id_tab1) from table1 left join table2 on table2.id_tab1=table1.id left join table3 on table3.id_tab1=table1.id group by table1.id order by table1.id; But i wonder, the results in count columns aren't truth. So, what is the correct query Please, any answer could you send me at email below too. Regards. Ireneusz Piasecki webmaster www.b-c.pl KomNet s.c [EMAIL PROTECTED] tel: 0 606 356 235 [EMAIL PROTECTED] [EMAIL PROTECTED]
transaction
Hi ! I have simply question. When do i have use transaction in mysql ?? I have mysql 3.23.37 from RPM for Redhat Linux. do i have to compile from source when i want transaction with BDB tables ?? Or i simply type type=bdb when i create table and it'all. Now my table uses transaction ?? Regards Ireneusz Piasecki [EMAIL PROTECTED] [EMAIL PROTECTED]
Re: Bug in Documentation ?
- Original Message - From: "Yusuf Incekara" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 17, 2001 9:09 AM Subject: Bug in Documentation ? in Mysql documents section 4.16.5 Options files it is documented as : MySQL reads default options from the following files on Windows: Filename Purpose windows-system-directory\my.ini Global options C:\my.cnf Global options C:\mysql\data\my.cnf Server-specific options windows-system-directory\my.ini Global options line is incorrect it must be corrected as : windows-directory\my.ini ? Cause when i try to use my.ini option file which is located in c:\windows\system directory it doesn't works. But when i put it into a c:\windows directory it works fine. Regards. Yusuf INCEKARA Avukatpro Limited Sirketi Hi ! You do not have right. windows-system-directory means:-> c:\windows. That is windows system location.and don't c:\windows\system And there isn't bug in documentation. I see that way. Regards Ireneusz Piasecki [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: PHP and MySQL
- Original Message - From: "Ben Kennish" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, March 01, 2001 11:55 AM Subject: PHP and MySQL > Who would've thought it would take 3 days to install MySQL, PHP and get > them talking???!! > > I've installed PHP 4.0.4pl1 using an RPM from www.redhat.com > > I've also installed MySQL (latest ver) server and client versions from > www.mysql.com using RPMs. > > Now MySQL seems to be up and working (using 'mysql' and 'mysqladmin' > gives me no trouble) and PHP seems to work fine . > > I've installed the PHP-MySQL module from redhat.com (a single file - > mysql.so) and uncommented the "extension=mysql.so" line in /etc/php.ini > > But when I type ... > > mysql_connect('localhost', 'root', 'b'); This can be that: mysql_connect('serwer_name','root','b' ); where serwer_name is serwer, that serve mysql databases or you can chmod file mysql.sock than other can it write (it could help) > into a PHP file, (I set b as my root SQL pwd) I get the following > error... > > "Warning: MySQL Connection Failed: Can't connect to local MySQL server > through socket '/var/lib/mysql/mysql.sock' (111) in > /var/www/html/index.php on line 5" > > There seems to be nothing in the MySQL error log. > > Please help! Thanks, > > -- > Ben Kennish > > Software Developer > Fubra Limited > > web | www.fubra.net > email | [EMAIL PROTECTED] > phone | +44 (0)870 1222 600 > fax | +44 (0)870 1222 699 > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > 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