Installation ERRORS MySql 3.23.51

2003-12-05 Thread bxk
I came across the following errors after install I am not able to start server from terminal (only progress i made was running as root NOT user) 1. ERROR: 1062 Duplicate entry 'localhost-root' for key 1 ERROR: 1062 Duplicate entry 'localhost-root' for key 1 2. WARNING: The host 'localhost' could

Re: MySQL 3.23.51 Reference Manual needed:K@N@!:

2003-07-28 Thread Venelin Arnaoudov
e the HTML format document there. Hope this helps, Ken - Original Message - From: "Venelin Arnaoudov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July 25, 2003 6:41 AM Subject: MySQL 3.23.51 Reference Manual needed Hi, I am looking for the Referen

Re: MySQL 3.23.51 Reference Manual needed

2003-07-25 Thread Venelin Arnaoudov
e the HTML format document there. Hope this helps, Ken - Original Message - From: "Venelin Arnaoudov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July 25, 2003 6:41 AM Subject: MySQL 3.23.51 Reference Manual needed Hi, I am looking for the Referen

Re: MySQL 3.23.51 Reference Manual needed

2003-07-25 Thread David Precious
> I am looking for the Reference Manual for MySQL 3.23.51 (or the latest of > the prior ones). Can anyone help me? You should find the manuals etc at: http://www.mysql.com/documentation/index.html HTH! David P -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: MySQL 3.23.51 Reference Manual needed

2003-07-25 Thread Ken Menzel
Message - From: "Venelin Arnaoudov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July 25, 2003 6:41 AM Subject: MySQL 3.23.51 Reference Manual needed > > Hi, > > I am looking for the Reference Manual for MySQL 3.23.51 (or the latest of t

MySQL 3.23.51 Reference Manual needed

2003-07-25 Thread Venelin Arnaoudov
Hi, I am looking for the Reference Manual for MySQL 3.23.51 (or the latest of the prior ones). Can anyone help me? Kindest regards, Venelin Arnaoudov -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error compile mysql-3.23.51

2003-07-10 Thread Egor Egorov
[EMAIL PROTECTED] wrote: > Hi All, > I success ./configure my "mysql-3.23.51", after type make I got this > error > - > libmysql.c: In function `mysql_real_connect': > libmysql.c:1325: warning:

Error compile mysql-3.23.51

2003-07-09 Thread rosli
Hi All, I success ./configure my "mysql-3.23.51", after type make I got this error - libmysql.c: In function `mysql_real_connect': libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r' from incom

MySQL 3.23.51 compilation problem (Mandrake 9.0).

2003-01-16 Thread Rob Nikada
warning: passing arg 5 of `gethostbyname_r' from incompatible pointer type libmysql.c:1325: too few arguments to function `gethostbyname_r' libmysql.c:1325: warning: assignment makes pointer from integer without a cast make[1]: *** [libmysql.lo] Erreur 1 make[1]: Quitte le répertoire `/v

AW: Strange behavior of MySQL 3.23.51

2002-10-21 Thread mysql
ht- > Von: Mikhail Entaltsev [mailto:mike_lynx@;smtp.ru] > Gesendet: Montag, 21. Oktober 2002 18:01 > An: [EMAIL PROTECTED]; [MYSQL] > Betreff: Re: Strange behavior of MySQL 3.23.51 > > > Stephan, > > > SELECT MAX( value ) > > FROM masterTABLE AS m > > LEFT

Strange behaviour of MySQL-3.23.51

2002-10-21 Thread stephan.skusa
I have a database structure as follows (simplyfied) : CREATE TABLE masterTABLE ( pid int(11) unsigned NOT NULL default '0', c1id int(11) unsigned default NULL, c2id int(11) unsigned default NULL, value int(11) unsigned NOT NULL default '0', UNIQUE KEY pid2 (pid,c1id,c2id), UNIQUE KEY

AW: Strange behavior of MySQL 3.23.51

2002-10-21 Thread stephan.skusa
[EMAIL PROTECTED]; [MYSQL] > Cc: [EMAIL PROTECTED] > Betreff: Re: Strange behavior of MySQL 3.23.51 > > > > http://www.mysql.com/doc/en/Group_by_functions.html > > "...If you use a group function in a statement containing no GROUP BY > clause, it is equivalent to gr

Re: Strange behavior of MySQL 3.23.51

2002-10-21 Thread Benjamin Pflugmann
in. PS: People, please trim the quotes in your replies. It really does not make any sense to quote the list footer several times. [...] > > > - Original Message - > > > From: <[EMAIL PROTECTED]> > > > To: "[MYSQL]" <[EMAIL PROTECTED]> &

a problem about mysql-3.23.51

2002-08-27 Thread chensong
I compile the source code of mysql-3.23.51 on a system of solaris 8. The following error information was produced: make[2]: Entering directory `/user1/mals/chensong/share/mysql-3.23.51/libmysql' /bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -DHAVE_CURSES_H -I/

error building mysql-3.23.51 on Solaris 9

2002-08-21 Thread Russell Premont
[-z textwarn] warn if there are relocations against text [-z verbose]generate warnings for suspicious processings collect2: ld returned 1 exit status make[2]: *** [mysql] Error 1 make[2]: Leaving directory `/www/mysql-3.23.51/client' make[1]: *** [all-recursive] Error 1

Error compiling mysql-3.23.51 on Solaris 9 sparc

2002-08-20 Thread Russell Premont
[-z textwarn] warn if there are relocations against text [-z verbose]generate warnings for suspicious processings collect2: ld returned 1 exit status make[2]: *** [mysql] Error 1 make[2]: Leaving directory `/www/mysql-3.23.51/client' make[1]: *** [all-recursive] Error 1

Re: upgrading from MySQL 3.21.33 to MySQL 3.23.51

2002-08-13 Thread Dan Nelson
In the last episode (Aug 13), Don said: > Thanks for the links to the manual. > I still have a couple more specific questions... > > Should I use a source or binary install? Whichever you used to install 3.21 would be preferable. That way they install in the same place. > Can I simply stop my

RE: upgrading from MySQL 3.21.33 to MySQL 3.23.51

2002-08-13 Thread Don
13, 2002 4:04 PM +To: Don +Cc: [EMAIL PROTECTED] +Subject: Re: upgrading from MySQL 3.21.33 to MySQL 3.23.51 + + +In the last episode (Aug 13), Don said: +> Due to some recent headaches I have decided to come out of the dark +> ages and upgrade from MySQL 3.21.33 to MySQL 3.23.51.

Re: upgrading from MySQL 3.21.33 to MySQL 3.23.51

2002-08-13 Thread Dan Nelson
In the last episode (Aug 13), Don said: > Due to some recent headaches I have decided to come out of the dark > ages and upgrade from MySQL 3.21.33 to MySQL 3.23.51. I was > wondering if anyone had any upgrade tips and/or precautions to > recommend before I start. Definitely re

upgrading from MySQL 3.21.33 to MySQL 3.23.51

2002-08-13 Thread Don
Hello, Due to some recent headaches I have decided to come out of the dark ages and upgrade from MySQL 3.21.33 to MySQL 3.23.51. I was wondering if anyone had any upgrade tips and/or precautions to recommend before I start. Thanks, Don [EMAIL PROTECTED

Re: MySQL 3.23.51 install on OS X

2002-08-10 Thread trogers
try using "localhost". you have to set the hostname in the install script. on 8/10/02 1:08 PM, Alex Pilson, typed: > I am installing a new MySQL installation on a new Xserve and I am > getting this message; > > [xserve:/usr/local/mysql] admin% sudo ./scripts/mysql_install_db > Sorry, the host

MySQL 3.23.51 install on OS X

2002-08-10 Thread Alex Pilson
I am installing a new MySQL installation on a new Xserve and I am getting this message; [xserve:/usr/local/mysql] admin% sudo ./scripts/mysql_install_db Sorry, the host 'xserve' could not be looked up. Please configure the 'hostname' command to return a correct hostname. If you want to solve thi

Re: MySQL 3.23.51 compile problems with SuSE 8.0

2002-08-01 Thread A.J.Dawson
Blast! I _did_ ask Yast to install the file - for some reason it didnt go on during the installation. Ah well, you learn something new every day... Many thanks for your time in helping me solve this one. Regards Andy On Thu, 1 Aug 2002, Lenz Grimmer wrote: > -BEGIN PGP SIGNED MESSAGE

Re: MySQL 3.23.51 compile problems with SuSE 8.0

2002-08-01 Thread A.J.Dawson
I get a slightly different result in my config.h file: $ grep GETHOSTBY config.h /* #undef HAVE_GETHOSTBYNAME_R_GLIBC2_STYLE */ /* #undef HAVE_GETHOSTBYNAME_R_RETURN_INT */ #define HAVE_GETHOSTBYADDR_R 1 #define HAVE_GETHOSTBYNAME_R 1 Sorry to say that I have no real idea what this means! I ha

AW: Installing MySQL 3.23.51 on AIX 4.3.3

2002-08-01 Thread R . Sommer
error when running mysql_install_db and when trying to start the database. Note: I am using AIX 4.3.3 and MySQL 3.23.51. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Installing MySQL 3.23.51 on AIX 4.3.3

2002-07-31 Thread Scott Pippin
en running mysql_install_db and when trying to start the database. Note: I am using AIX 4.3.3 and MySQL 3.23.51. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the li

MySQL 3.23.51 compile problems with SuSE 8.0 (fwd)

2002-07-30 Thread A.J.Dawson
I posted a message last Wednesday about compile problems I was having with MySQL 3.23.51 and SuSE 8.0 (copied below). I notice that there is another user (Dennis Daupert) having the same problem as I am. Does anyone have a solution, or know where I might be able to find more information that

Multi-Table Delete with MySQL 3.23.51

2002-07-30 Thread Sridhar Peddireddy
Guys, I know that version 3.23.51 of MySQL does not handle deleting data from multiple tables directly. I am in a situation where i have to delete millions of records from a dozen tables. The delete logic is not simple, i have to check a number of tables before i can actually delete a row from a

Re: Multi-Table Referential Delete Clarification with MySQL 3.23.51

2002-07-29 Thread Sridhar Peddireddy
Forgot to mention that all of my tables are of TYPE: MyISAM Thanks Sri [EMAIL PROTECTED] wrote: > > Guys, > > I know that version 3.23.51 of MySQL does not handle deleting data from > multiple tables directly. I am in a situation where i have to delete > millions of records from a dozen table

Multi-Table Referential Delete Clarification with MySQL 3.23.51

2002-07-29 Thread Sridhar Peddireddy
Guys, I know that version 3.23.51 of MySQL does not handle deleting data from multiple tables directly. I am in a situation where i have to delete millions of records from a dozen tables. The delete logic is not simple, i have to check a number of tables before i can actually delete a row from a

mysql 3.23.51 problems ? (with snortreport)

2002-07-27 Thread Bart Burkhardt
Hi, I have installed apache-mysql-php with the apachetoolbox.com script. (www.apachetoolbox.com) I have first installed everything with keeping mysql 3.23.49(rpm), everything was fine then, now i have used apachetoolbox to install mysql 3.23.51 and now i have a problem. I use Snort-Mysql to

Configure/Make problem, SuSE 8.0, mysql-3.23.51

2002-07-24 Thread Dennis Daupert
makes pointer from integer without a cast make[2]: *** [libmysql.lo] Error 1 make[2]: Leaving directory `/home/perl/downloads/db/mysql-3.23.51/libmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/perl/downloads/db/mysql-3.23.51' make: *** [all-recursive

MySQL 3.23.51 compile problems with SuSE 8.0

2002-07-24 Thread A.J.Dawson
I have come across a problem compiling MySQL 3.23.51 on a SuSE 8.0 computer. I have tried compiling the same source code on a SuSE 7.3 computer with no apparent problems. Note that I have not actually used the version compiled on the 7.3 machine - I simply wanted to make sure it would compile

Re: Mysql 3.23.51 on Solaris

2002-07-16 Thread Roland Schmid
> Connection Failed > 2003 - Cannot Connect to MySQL server on 10.1.1.95 (10061) Hi, it seems that the MySQL Server is not running. Try to start the server. Best regards, Roland -- [EMAIL PROTECTED] - Before posting, plea

Mysql 3.23.51 on Solaris

2002-07-16 Thread Arul
Hi All I had installed MYSQL 3.23.51 on Solaris Sparc 2.8 The Login name i used to loginto Solaris is MySQL.I didnt use the root account to install MySQL When i try to connect to that MySQL Database from a Windows Machine using MySql Front Client , it says that Connection Failed 2003 - Cannot

Re: serwer MySQL 3.23.51 sometime acts as zombie on my linux 6.2 machine

2002-07-08 Thread Michael Bacarella
On Mon, Jul 08, 2002 at 09:46:08AM +0200, Ireneusz Piasecki wrote: > 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.

RE: Serwer MySQL 3.23.51 sometime acts as zombie on my linux 6.2 machine

2002-07-08 Thread Terry
Hi, > > 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. I think this is normal. When child process exits, parent process has to 'clean that up'. It takes some time if parent is doing some

Re:Re: Re:Serwer MySQL 3.23.51 sometime acts as zombie on my linux 6.2 machine

2002-07-08 Thread Oliver Six
oblem 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

Re: Re:Serwer MySQL 3.23.51 sometime acts as zombie on my linux 6.2 machine

2002-07-08 Thread Ireneusz Piasecki
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 Piaseck

Re:Serwer MySQL 3.23.51 sometime acts as zombie on my linux 6.2 machine

2002-07-08 Thread Oliver Six
"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 ta

Serwer MySQL 3.23.51 sometime acts as zombie on my linux 6.2 machine

2002-07-08 Thread Ireneusz Piasecki
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 se

serwer MySQL 3.23.51 sometime acts as zombie on my linux 6.2 machine

2002-07-08 Thread Ireneusz Piasecki
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 i

Re: bad source files of mysql-3.23.51

2002-07-05 Thread Victoria Reznichenko
n.001, so I renamed the file, but G> it doesn't work. linux-bin.001 is a log file: http://www.mysql.com/doc/B/i/Binary_log.html G> I'm a Linux SuSE 7.1 user. Can you send me a patch for mysql-3.23.51.tar.gz G> please? Why don't you use the .tar.bz2 form

Re: mysql-3.23.51

2002-06-26 Thread Egor Egorov
LTrain1007, Wednesday, June 26, 2002, 1:51:17 AM, you wrote: L> I downloaded this version, and unzipped it using winrar. I have all the L> files in a directory but i dont know how to use or install mysql? any help? Have you downloaded binary or source distribution? If you downloaded binary dis

Building MySQL 3.23.51 on AIX using VisualAge compiler rev 5020

2002-06-23 Thread Rick Flower
I'm trying in vain to build the latest version of MySQL 3.23.51 (downloaded today) on a new AIX box we've recently setup. It has the latest IBM patches for the VisualAge C++ compiler v5, bringing it up to rev 5020. When building, there are two problems.. One is that the config

Re: Migration of a database from mSQL 2.x to MySQL 3.23.51

2002-06-21 Thread Joseph Bueno
Hi, Mark Hennessy wrote: > I have decided to use MAX(tablename_index)+1 in advance of inserting the > record, as I want to use as little dbms-specific magic as possible and > this matches as close as I can figure the behavior of _seq in mSQL. > > I would be doing the following in the same thread

Re: Migration of a database from mSQL 2.x to MySQL 3.23.51

2002-06-21 Thread Mark Hennessy
: Mark Hennessy <[EMAIL PROTECTED]> > To: Gerald Clark <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Subject: Re: Migration of a database from mSQL 2.x to MySQL 3.23.51 > > I don't see how AUTO_INCREMENT preserves its value in the output of a &

Re: MySQL 3.23.51+ for AIX

2002-06-18 Thread Egor Egorov
Morris, Tuesday, June 18, 2002, 5:13:41 PM, you wrote: MF> Any word on when to expect a working binary MF> release of mysql for AIX 4.3.3? Our developers are working on this issue. MF> Morris Ford -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This em

MySQL 3.23.51+ for AIX

2002-06-18 Thread Morris Ford
Any word on when to expect a working binary release of mysql for AIX 4.3.3? Morris Ford __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com --

MySQL 3.23.51 is released

2002-06-12 Thread Lenz Grimmer
new releases in the past few weeks - apart from the change of command we also switched to a new Linux build host and it took me a while to get familiar with the whole building procedure in general. MySQL 3.23.51 is now released. This version fixes several bugs and compile issues - see the changelog