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

RE: Problems with compilation

2001-10-04 Thread Daniel Ouellet
> > - Original Message - > From: Daniel Ouellet <[EMAIL PROTECTED]> > To: [AFQ]T1T4N <[EMAIL PROTECTED]> > Cc: MySQL <[EMAIL PROTECTED]> > Sent: Friday, October 05, 2001 1:57 AM > Subject: RE: Problems with compilation > > > > >

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: erro

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

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

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

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: 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: 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: OpenBS

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 tha

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]] > Se

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 c

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

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 MyS

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 con

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 sta

RE: Powered by MySQL?

2001-09-29 Thread Daniel Ouellet
hout limitation) Sections > 3(D) and 4. > > > But, what the heck, I'll try to email [EMAIL PROTECTED] Maybe someone > actually reads that mailbox ... > > - > Tom Haapanen > [EMAIL PROTECTED] > > > -Original Message- > From: Daniel Ouellet [mailt

RE: Powered by MySQL?

2001-09-29 Thread Daniel Ouellet
on. > > - > Tom Haapanen > [EMAIL PROTECTED] > > -Original Message- > From: Daniel Ouellet [mailto:[EMAIL PROTECTED]] > Sent: 28 September 2001 23:01 > To: [EMAIL PROTECTED] > Cc: Haapanen, Tom > Subject: RE: Powered by MySQL? > > > You probably will

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 d

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