RE: InnoDB Tables/Databases

2001-10-05 Thread Daniel Ouellet
Thanks you for the URL. (: I just added to my collections. Daniel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ilya Martynov Sent: Friday, October 05, 2001 04:06 To: Daniel Ouellet Cc: Deryck Henson; MySQL Subject: Re: InnoDB Tables

RE: Compile MySQL with GCC 2.95.3 optimise for I686

2001-10-04 Thread Daniel Ouellet
Hi Jani, Thanks for your answer. That is true that you guys are making some available. I sure don't deny that at all and it is very generous of you guys to spend the time doing it as well! One reason is that I wanted Apache with PHP and Static MySQL built in. So, I have to compile it anyway.

RE: InnoDB Tables/Databases

2001-10-04 Thread Daniel Ouellet
Here is two thing for you. First, GREAT source for search of pass problem on any thing really. http://marc.theaimsgroup.com/ Then, information on the InnoDB. Not hard to find really. http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#I nnoDB Have a good reading.

RE: InnoDB Tables/Databases

2001-10-04 Thread Daniel Ouellet
I love this one! (: That put a smile on a long night! Thanks! Daniel The original query is as follows: SELECT * FROM websites WHERE category LIKE '%search%' OR keywords LIKE '%search%' OR description LIKE '%search%' The search instances are from an ASP page. 'search' is a variable

RE: Problems with compilation

2001-10-04 Thread Daniel Ouellet
I have Debian the last release, and i want to compilate mysql and it had some errors here is a little text. checking for tgetent in -lncurses... no checking for tgetent in -lcurses... no checking for tgetent in -ltermcap... no checking for termcap functions library... configure: error: No

RE: Problems with compilation

2001-10-04 Thread Daniel Ouellet
You are welcome, and if that doesn't work for you. I am sure you will find the answer here: http://marc.theaimsgroup.com/?l=mysqlw=2r=1s=curses+termcapq=b Daniel i gonna check that... thanx for your super speed answer... i'm surprised - Original Message - From: Daniel

RE: Is it possible to Rename Database

2001-10-03 Thread Daniel Ouellet
Either way, DON'T FORGET to edit the table right if you use any, etc. Or you will not access it at all. Just a quick friendly reminder! -Original Message- From: Ravi Raman [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 18:04 To: Carsten H. Pedersen; Brandon Lewis;

RE: Subselects

2001-10-02 Thread Daniel Ouellet
As far as I know. There is no 3.24.xx coming out, but instead 4.0 in a few days or weeks according to various posting on this list. But I know be wrong! Hope this help Daniel -Original Message- From: John Seers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 11:44 To:

RE: How to Dump only Data

2001-10-02 Thread Daniel Ouellet
Here directly from Paul Dubois's book page 619-620 mysqldump --opt db_name backup_file So, it would be here: mysqldump --no-create-info db_name backup_file Or if you want the create statement as well, just do mysqldump db_name backup_file His book is a very good one and have all you can

RE: Error message

2001-10-02 Thread Daniel Ouellet
The error message you get is not related to PHP, but to the access right preset into MySQL. Basically, MySQL tell you that you can't connect to it with the user name testing. Check your right access in MySQL. Daniel -Original Message- From: Harpreet [mailto:[EMAIL PROTECTED]]

Compile MySQL with GCC 2.95.3 optimise for I686

2001-10-02 Thread Daniel Ouellet
Hi, I am looking into using optimization of the GCC 2.95.3 for I686 as -O3 -mpentiumpro to compile an optimize version of MySQL. But as I look around, I see that some user warned about using this as they said there is bug in GCC for I686 optimization. Any information you can pass to me on

RE: OpenBSD mysql_install_db

2001-10-02 Thread Daniel Ouellet
Are you sure you have space on /var/mysql/mysql and that mysql user have access to it. That's where it is by default on OpenBSD. Daniel -Original Message- From: David Reid [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 17:15 To: [EMAIL PROTECTED] Subject: OpenBSD

RE: mysql 4.0

2001-10-02 Thread Daniel Ouellet
It will be available just in a few days for what I have been told. Not yet there. Daniel by what i have seen there is a 4.0 version of MySQL. Where can I find more information about and even download a version of it ?!?!? Thanks.

RE: why would LOWER

2001-09-30 Thread Daniel Ouellet
One suggestion if I may. As this field is for email address and email are not case sensitive in the first place. Wouldn't it make sense to change the case of all the email in the database to be lower and also make sure that what even you use to enter new email address in the database actually

RE: How To call mysql_insert_id

2001-09-30 Thread Daniel Ouellet
You were close to it. But he way to get the last inserted item on AUTO_INCREMENT field is for example: id = mysql_insert_id(mysql); printf(The last insert is: %d\n, id); And mysql is what was return to you when you open your connection to the database. Daniel Hi, I am a newbie in MySQL.

RE: Repost - Subject - Backup/Recovery Strategies for MySQL

2001-09-29 Thread Daniel Ouellet
I am not sure it that would provide everything you want to know, but I was looking for the same thing last week and I setup this replication database and it work great and make it very easy. http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm inistration.html#Replication

RE: flush performance

2001-09-29 Thread Daniel Ouellet
Hi, This is a guess, but I would assume that would wouldn't get accurate result by using ODBC. If you write your test in C, you may as well use the C library available and not use ODBC. Just my 0.02$ worth. Daniel Hi. I believe you missed his point: He expected a time difference but did

RE: Powered by MySQL?

2001-09-29 Thread Daniel Ouellet
-- and got no response. For people who suggested just downloading the logo and using it -- I'd rather not do that without permission, since the mysql.com site explicitly says that you need to have permission. - Tom Haapanen [EMAIL PROTECTED] -Original Message- From: Daniel Ouellet

RE: Powered by MySQL?

2001-09-29 Thread Daniel Ouellet
Haapanen [EMAIL PROTECTED] -Original Message- From: Daniel Ouellet [mailto:[EMAIL PROTECTED]] Sent: 29 September 2001 21:31 To: [EMAIL PROTECTED] Cc: Haapanen, Tom Subject: RE: Powered by MySQL? True you did email, but look at the email address you send your request; Quote I have

RE: update support sub-queries?

2001-09-29 Thread Daniel Ouellet
At the moment, according to the doc: http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html# Missing_Sub-selects MySQL only support the insert select and Replace Select. I am not sure if that answer your question as I am not a big guru on it either, but it is a place to