error setting up mysql

2002-07-19 Thread evanson ikua
Hi, I have downloaded mysql 3.23.5 and whenever I try to install it in my machine, I get a message that goes something like setup cannot find languageerror 105. Please help me and tell me what I am supposed to do with this one. I will appreciate your quick response. Evans, Get me @ http://n

Unknown suffix '.' used for variable 'bind-address' (4.0.2)

2002-07-19 Thread john
>Description: Unable to use dotted-quad IP address in bind-address in 4.0.2. >How-To-Repeat: $ cat /etc/my.cnf [mysqld] bind-address= 192.168.1.2 $ /etc/rc.d/init.d/mysq

Re: Merge records from multiple tables???

2002-07-19 Thread DL Neil
Ollie, Ahh, all this talk of "old-timers" writing merges to cut their teeth in the 'new' field of data processing... it brings on a wave of tender memories - however looking back, I find that even nostalgia ain't what it used to be! The earlier response works (assuming key behavior), and is a goo

Re: Create DataBase tabe for a user

2002-07-19 Thread Gerald R. Jensen
Did you first create a database named 'poll'? - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July 19, 2002 4:33 AM Subject: Create DataBase tabe for a user Hello, When I run "grant all on poll.* to edward@localhost identified by 'edward';" command.

Re: Create DataBase tabe for a user

2002-07-19 Thread Ralf Narozny
Hello! [EMAIL PROTECTED] wrote: >Hello, > >My system is Red Hat 6.2, My MySQL is 3.23.46 ( rpm package )... >Now, when I run "grant all on poll.* to edward@localhost identified by >'edward';" command... >I found there is no "poll" directory at /var/lib/mysql/poll ! >So, can you help me ? > >

Replication in MySQL of InnoDb Tables

2002-07-19 Thread Ritu Singla
Hello, when setting up replication in MySQL, do we need to take the tar of the data dir. of the master and save it onto the slave.or when the slave comes up for the first time, it automatically loads the specified databases and tables from the master.??? And for InnoDB tables, we convert the

installer doesn't expand @MYSQL_UNIX_ADDR@

2002-07-19 Thread levon
>Description: I was trying to install mysql-3.23.51 and got the following error. './configure', 'make' and 'make install' do everething fine, but when I'm trying to start mysqld I get the following error: 020719 16:23:51 mysqld started 020719 16:23:51 Can't start server : Bind on unix socket:

RE: Create DataBase tabe for a user

2002-07-19 Thread Barnali
You have to create the database (poll) before doing any operation on it. Use ~mysql/scripts/mysql_install_db.sh to create a database. There may be an SQL command also to create the database - just check the mysql command reference. Regards Barnali -Original Message- From: [EMAIL PROTECTE

InnoDB

2002-07-19 Thread Alexander Burbello
I intend to install innoDB tables in my MySQL Server. But where I make download of the InnoDB databases. And after, how do I install?? Greetings Alexander sql query ___ Yahoo! Encontros O lugar certo para encontrar a su

Re: Re: Table types in replication

2002-07-19 Thread Pete French
> Yeah, just go with InnoDB. :-) any good ? I took a look at the documentation, but it all seemed somewhat heavyweight for my liking... I have an application that runs very nicely at the moment - we have one minor problem which is that we have one insert into two tables which may not hapen prope

Create DataBase tabe for a user

2002-07-19 Thread EdwardSPL
Hello, My system is Red Hat 6.2, My MySQL is 3.23.46 ( rpm package )... Now, when I run "grant all on poll.* to edward@localhost identified by 'edward';" command... I found there is no "poll" directory at /var/lib/mysql/poll ! So, can you help me ? Thanks, Edward. ---

JBoss 3.0.1RC1 and MySQL

2002-07-19 Thread DOD
We have recently upgraded to JBoss 3.0.1RC1, and embedded MySQL as the default database. Though we found it a lot less problematic to do this than in earlier versions of JBoss, we have set up a step-by-step guide on the following page, should it be of use to anyone else. http://www.dodtechnolog

./configure failure when building from source

2002-07-19 Thread Lever, Andy
> Description: ./configure fails with the following:- > > checking for p2open... yes > checking for bind... yes > checking for crypt in -lcrypt... yes > checking for crypt... yes > checking if libz with compress... no > checking for int8... no > checking "LinuxThreads"... "Not found" > checking "

RE: Tee Shirt

2002-07-19 Thread Simon Green
I went on the Official training course near London (VERY good). But did not get a tee shirt :-( Simon -Original Message- From: Mike Jones [mailto:[EMAIL PROTECTED]] Sent: 19 July 2002 11:05 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Tee Shirt I got one whe

RE: Tee Shirt

2002-07-19 Thread Mike Jones
I got one when I went on an "Official" MySQL training course. There again it doesn't fit me so my wife is wears it. Cheers, Mike >>> "Wouter van Vliet" <[EMAIL PROTECTED]> 19/07/2002 09:47:00 >>> Yeah .. I want it too :) .. please tell us ! -- Alle door mij verzonden email is careware

RE: Question about datadir redirection for MYSQL

2002-07-19 Thread Barnali
Just check if you have the write permission on the mapped drive. Barnali -Original Message- From: Ashley Chew [mailto:[EMAIL PROTECTED]] Sent: Friday, July 19, 2002 12:05 PM To: [EMAIL PROTECTED] Subject: Question about datadir redirection for MYSQL Hi I was Wondering

./configure failure when building from source

2002-07-19 Thread Lever, Andy
>Description: ./configure fails with the following:- checking for p2open... yes checking for bind... yes checking for crypt in -lcrypt... yes checking for crypt... yes checking if libz with compress... no checking for int8... no checking "LinuxThreads"... "Not found" checking "DEC threads"... "no

Create DataBase tabe for a user

2002-07-19 Thread EdwardSPL
Hello, When I run "grant all on poll.* to edward@localhost identified by 'edward';" command... I found there is no "poll" directory at /var/lib/mysql/poll ! So, can you help me ? PS : My system is Linux RH 6.2 Thanks, Edward.

RE: Performance / Stresstest of MySQL

2002-07-19 Thread Barnali
We have already done performance benchmarking of mysql using "setquery" benchmark with 100% reproducible results. Our objective was to compare the code generated by gcc and icc (intel c++ compiler). Certain points to remember while selecting such a benchmark: 1. The benchmark should preferably b

RE: Tee Shirt

2002-07-19 Thread Wouter van Vliet
Yeah .. I want it too :) .. please tell us ! -- Alle door mij verzonden email is careware. Dit houdt in dat het alleen herlezen en bewaard mag worden als je goed omgaat met al het leven op aarde en daar buiten. Als je het hier niet mee eens bent dien je mijn mailtje binnen 24 uur terug t

Re: Installation Problem

2002-07-19 Thread Georg Richter
Hi Dexter, > configure:1948: checking for C compiler default output > configure:1951: gcc -03conftest.c >&5 > gcc: unrecognized option `-03' > cpp: Internal compiler error: program cpp got fatal signal 9 > configure:1954: $? = 1 > configure: failed program was: > #line 1932 "configure" > #in

Performance / Stresstest of MySQL

2002-07-19 Thread Lasse Laursen
Hi, We are doing some optimization of our MySQL databases (tweaking the my.cnf file) to try to get better performance. We run MySQL 3.23.49 on a FreeBSD 4.5 machine and we are looking for some programs that can stresstest the servers. I have had a look at http://osdb.sourceforge.net/ but it does

Re: Table types in replication

2002-07-19 Thread Jeremy Zawodny
On Thu, Jul 18, 2002 at 04:40:39PM +0100, Pete French wrote: > > Maybe BDB tables are not for me after all... Yeah, just go with InnoDB. :-) -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 50 days, proces

Re: InnoDB free space

2002-07-19 Thread Jeremy Zawodny
On Fri, Jul 19, 2002 at 08:16:06AM +0200, Daniel Kiss wrote: > Hi, > > How can I ask the MySQL server how much free space is in InnoDB tablespaces? SHOW TABLE STATUS will tell you -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.

mysql_query() oddities if remote database becomes available

2002-07-19 Thread equ
>Description: This is a resend or actually a reformatted bug report since the first one I sent out contained a error on my part (I incorrectly looked at the mysql_query() return code although I should be looking at mysql_errno(). Now that is fixed but the problem remains. If the remote database

Going to the Open Source Convention?

2002-07-19 Thread Jeremy Zawodny
If you're going to be at the Open Source Convention next week in San Diego, California, drop by and say "hi" at some point. I've met several folks from the mysql mailing lists in years past and would like to do so again this year. Just for the record, I have a few MySQL talks that I'll be giving

Re: Win and Linux ?

2002-07-19 Thread Jeremy Zawodny
On Fri, Jul 19, 2002 at 05:40:21AM +, Jimmy Fernandez wrote: > Hi jeremy Thanks for the quick response. > Appreciate it. > One more clarification though... > How about bringing the database from Unix/liux to > Windows. Still OK? Yes, all MyISAM tables are stored in a platfor-neurtal format. -

Question about datadir redirection for MYSQL

2002-07-19 Thread Ashley Chew
Hi I was Wondering if anyone had the same problem I am experiencing. MYSQL works nce and all when I set the datadir=E:/data/ etc or I can point to any local drives. But as soon I redirect the datadir to a network drive (Ie a mapped network drive). MYSQL fails to load

Re: MySQL: Problem Installing on RH 7.3

2002-07-19 Thread jusob
En réponse à Philip Molter <[EMAIL PROTECTED]>: Hi I am sure that tehre is a bug in RH 7.3 I've said it several times in this mailing list, but nobody wants to belive me! It's true that this information is difficult to find, but I've learned it on the documentation of www.mysql.org, the one with

InnoDB free space

2002-07-19 Thread Daniel Kiss
Hi, How can I ask the MySQL server how much free space is in InnoDB tablespaces? Thx, Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the l