Re: Win and Linux ?

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? THANKS!! :) jimmy From: Jeremy Zawodny [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Jimmy Fernandez [EMAIL PROTECTED] CC: [EMAIL

Re: Very basic bug: Respecting NOT NULL?

On Friday, 19. July 2002 01:57, Bradley Plies wrote: Hi Bradley, mysql select * from pfpbaserequest; ++--++-+--+ | id | trx_type | tender | req_date| amt | ++--++-+--+ | 1 | |

Re: Installation Problem

Georg, Here is the content of the config.log file.. config.log This file contains any messages produced by compilers while running configure, to aid debugging if configure makes a mistake. It was created by configure, which was generated by GNU Autoconf 2.52. Invocation command line was $

RE: OpenBSD source build, server client not talking

Is there any reason you are opting for static linking ? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 19, 2002 11:11 AM To: [EMAIL PROTECTED] Subject: OpenBSD source build, server client not talking Description: I have just built MySQL on an

Foreign key definitions

Hi, I just would like to ask that what are the following foreign key definition extensions good for exactly? I mean how does these SQL syntaxes work? MATCH FULL | MATCH PARTIAL ON DELETE/UPDATE RISTRICT/CASCADE/SET NULL/NO ACTION/SET DEFAULT Thx, Daniel

Re: OpenBSD source build, server client not talking

[EMAIL PROTECTED] wrote: The port and socket information all appears to be correct on both sides. the daemon must be hearing the initial connection, as it builds a thread. Should I rebuild with MIT p-threads? Or without libwrap? The version string of mysqld is mysqld Ver

Re: Innodb and unbuffered raw io on linux?

Christian, the patch below may fix the problem if it is in the initialization of the raw device to zero. InnoDB does all normal i/o to/from the data files to memory addresses aligned by UNIV_PAGE_SIZE. This is because earlier versions used the Windows native AIO and that requires aligned memory

Re: shell script to backup

En réponse à Ilyas Keser [EMAIL PROTECTED]: Hi you can use mysqldump et a crontab to save all databases in a text file. Regards Julien Sobrier Hi all... I am a new Linux user. Does any one have a shell script to backup all Mysql databases? Thanks ilyas...

InnoDB free space

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

Re: MySQL: Problem Installing on RH 7.3

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

Question about datadir redirection for MYSQL

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

Re: Win and Linux ?

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. --

Going to the Open Source Convention?

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:

mysql_query() oddities if remote database becomes available

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

Re: InnoDB free space

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.com/

Re: Table types in replication

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, processed

Performance / Stresstest of MySQL

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

Re: Installation Problem

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 #include

RE: Tee Shirt

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

RE: Performance / Stresstest of MySQL

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 be

Create DataBase tabe for a user

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.

./configure failure when building from source

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

RE: Question about datadir redirection for MYSQL

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

RE: Tee Shirt

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. Dit houdt

RE: Tee Shirt

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

./configure failure when building from source

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...

Create DataBase tabe for a user

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.

Re: Re: Table types in replication

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

InnoDB

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

RE: Create DataBase tabe for a user

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

installer doesn't expand @MYSQL_UNIX_ADDR@

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:

Replication in MySQL of InnoDb Tables

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

Re: Create DataBase tabe for a user

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 ? Maybe stupid

Re: Create DataBase tabe for a user

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... I

Re: Merge records from multiple tables???

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 good

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

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/mysql

error setting up mysql

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 @