FULLTEXT search and InnoDB tables

I've searched carefully the online manual before I decide to write this, however, there's always a change that I have missed something along the way ... Is there any problem in using FULLTEXT indexes with InnoDB tables? Check this out: (MySQL 3.23.43 compiled with CXXFLAGS=-DDONT_USE_DEFAULT_FI

Mysql as a backend to openldap

I want to set up a openldap server that should import data from some tables on my mysql server. There are different strategies. 1. Use the perl scripting APIs in OpenLdap 2. Go by way of BerkleyDB files 3. Some way of direct (odbc?) communication. Does anyone have any experience with this? --

RE: does lmysqlclient.so exist in 3.23.44 ?

Hi again. Why were you compiling php against the mysql source rather than using the built-in mysql support in php? >From what I've read, it's probably more trouble than it's worth on OSX... -ravi. -Original Message- From: Erik Price [mailto:[EMAIL PROTECTED]] Sent: November 23, 2001 10:

does lmysqlclient.so exist in 3.23.44 ?

Well, I asked a lengthy question earlier with all kinds of extraneous information pertaining to my problem. Allow me to re-ask in a more simple fashion -- does a file called 'lmysqlclient.so' exist in MySQL 3.23.44 ? I built this distribution from source and cannot find it anywhere. I need it

Re: MYSQL 4.0 in production?

johnlucas-Arluna writes: > Hi folks > > I really need to use some of the new features of version 4, particularly the > UNION joins. > > Has anyone had any experience with using the UNION, does it work ok and > fast? > > Also, could you indicate your confidence level with regard to running ver >

RE: MySQL performance on different OS-es

Ales It would be a good start to look at the OS on its own. Latest Linux versions are fast. Solaris is not the fastest but is rock solid. Win...well is windows. So this info will reflect on what you run. But how fast a system do you need? MySQL is very fast and so even on a low spec system you

MySQL Field Names

Can I assume that you can't have a field in a table which is named 'Integer' or 'Datetime' or 'Byte' Any input? I've had a quick look but I can't see much Thanks lots David Ayliffe - Before posting, please check: http://ww

Question on auto_increment

I knew that if record at the Largest number of index being delete, the number will be reused, but i have a question: what happen if i delete the record which the index number is between the largest and the smallest, let say "i have 3 records within my table, by some reason, i got to delete the re

RE: Question on auto_increment

If the colum is set to unique, it will fill in 2. If not, it'll automatically goto 4 (or vice versa if I'm mistaken). > -Original Message- > From: Jack [mailto:[EMAIL PROTECTED]] > Sent: November 23, 2001 7:46 AM > To: Mysql List > Subject: Question on auto_increment > > > I knew that if

Re: MySql on redhat 6.x and above

aravind gorthy wrote: > Hi, > I have some doubts regarding MySql on Linux > environment. > I'd like to install MySql on linux -redhat 6.x and > above. > Could you please guide me how to proceed. > I did not find a specific document on redhat 6.x and > above in the documentations provided in the s

Re: Question on auto_increment

Alex Dowgailenko writes: > If the colum is set to unique, it will fill in 2. If not, it'll > automatically goto 4 (or vice versa if I'm mistaken). > > > I knew that if record at the Largest number of index being delete, the > > number will be reused, but i have a question: > > what happen if i

Re: MySQL Field Names

David Ayliffe writes: > Can I assume that you can't have a field in a table which is named > 'Integer' or 'Datetime' or 'Byte' > > Any input? > I've had a quick look but I can't see much > > Thanks lots > David Ayliffe Hi! BYTE should be quite possible. -- Regards, __ ___ ___ _

MySQL performance on different OS-es

Hello, list! Has anyone made a test to find out under which OS MySQL performs best given the same hardware? How much is the difference? I am a new user and I have to choose a system. I am looking at Linux, Solaris or Win on x86. Thanks, Ales. --

Re: InnoDB Compiler error (as well)

Ashley, On Thu, 22 Nov 2001, Ashley M. Kirchner wrote: > And while I'm sure someone is bound to tell me to stop using > RedHat's GCC 2.96 because of "bad code", I'm sorry. Everything else > that I need/use compiles just fine and I never have problems with them, > except MySQL. I would stron

Access denied for user: 'myuser@localhost'

I'm a complete newbie in mysql, so I've got a very simple question (I hope so): I've installed MySQL 3.23.44 on my Windows 2000Pro / IIS-5 /w PHP4 support. I followed the installation instructions on Win2000, made the databse to run, I managed to set the root password as it was said in the manua

MYSQL 4.0 in production?

Hi folks I really need to use some of the new features of version 4, particularly the UNION joins. Has anyone had any experience with using the UNION, does it work ok and fast? Also, could you indicate your confidence level with regard to running ver 4.0 in production even though it's only beta

Problem in Transaction handling

Hi, We are using MySQL database for our project, first time. We are facing some problem. Which are described below. * How to handle the transaction in MySQL. Presently when we are passing the autocommit as false, it gives error saying it is not allowed, in MySQL. We are not able to understa

Re: C API problem, CREATE TABLE SELECT & SELECT

| query_len = sprintf(query, "CREATE TEMPORARY TABLE temp SELECT "); try it out with asprintf(). but you have to define at compile time the following -D_GNU_SOURCE maybe you allocates not enough place for query. asprintf do it for you. char *query; int query_len; query_len=asprintf(&query

UNION/INTERSECT

Hey there, first of all please CC my email address as I'm no longer a member of this list. Recieving too much stuff already (1000+ mails a day) Anyways I found a general SQL manual which uses oracle to show it's demos. So I tried some of the examples in there some work but don't do the expecte

more commands that don't work (yet)

please CC [EMAIL PROTECTED] as i'm not a member in addition to my earlier email this doesn't work either regards INPUT: SQL> SELECT * FROM SOFTBALL 2 MINUS 3 SELECT * FROM FOOTBALL; OUTPUT: NAME BAKER DEAN FALCONER ---

Re: MySql on redhat 6.x and above

On Friday 23 Nov 2001 11:27, you wrote: > Hi, > I have some doubts regarding MySql on Linux > environment. > I'd like to install MySql on linux -redhat 6.x and > above. > Could you please guide me how to proceed. > I did not find a specific document on redhat 6.x and > above in the documentations

Error List

Hello Everyone , Some error mostly comes in MySQL; Code Description 1 Operation not permitted 2 No such file or directory 3 No such process 4 Interrupted function call 5 Input/output error 6 No such device or address 7 Arg list too long 8 Exec format error 9 Bad file descriptor 10 No c

MySql on redhat 6.x and above

Hi, I have some doubts regarding MySql on Linux environment. I'd like to install MySql on linux -redhat 6.x and above. Could you please guide me how to proceed. I did not find a specific document on redhat 6.x and above in the documentations provided in the site. Thanks in advance. Regards Aravind

C API problem, CREATE TABLE SELECT & SELECT

Hello, I seem to have a problem with the C API, briefly I try to select something into a temporary table and then do three selects, two of which are from the temporary table created. Program segfaults. When I comment all but temp table creation, program works, and same happens for a non-temp tab

[BUG: mysqldump incorrectly generates INSERTs for AUTO_INCREMENT columns]

>Description: Say we have column named id int NOT NULL AUTO_INCREMENT Say we have record, where id=0 (why not?) Say we used mysqldump to backup our table. One day we tryied to restore our table, but we will never get record where id=0 back, becouse rule for AUTO_INCREMENT rows will apply. So

Re: How do I count using two tables

Karl > I've got two tables one is News items > > News_IDNewsetc... > 1Today in .etc > 2Hello world .etc > 3Blar di blaretc > 4And now time for something else > . > . > 100The last thing > > and the oth

Re: Mysql installation problem on NT

Hi Joachim I tried to install mySQL on Windows NT (Service Pack 6). That means: Unzipping, installing, then starting mySQL as a service with : mysqld-nt --install. Until now everything worked fine and we saw the service in the NT's Service list. But we could not start the service. Neither with NT

Re: Mysql & Win200 problem (telnet localhost)

Sandeep, 1 virus check 2 check .ini files 3 check PATH 4 check DNS 5 give more specific information, read the manual (again), ie help yourself before making complaints that you get no answers =dn - Original Message - From: "Sandeep Murthy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent

Re: problem running mysql from the command line

> I hope I'm not being really stupid, but this does not seem to work: > > mysql -h localhost -u xxx -p > > I get the command line usage error. It appears I can't use any other option > if I use the -h. This works fine > > mysql -u xxx -p > > I'm running mysql version 3.23.43-nt Glenn, Is th

RE: HOW TO : Run wave files stored in BLOB field ???

I try what Venu suggests and it is working fine ... Send it to you to know about it , may be you need it in future thanks venu. Abdulrahman. --- Venu <[EMAIL PROTECTED]> wrote: > Hi, > > > -Original Message- > > From: Delphi Guy's > [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, N

SV: Is there any alternative to MEMO field in MYSQL database?

TEXT and BLOB types. http://www.mysql.com/doc/B/L/BLOB.html > -Ursprungligt meddelande- > Fran: Hamzat kamal [mailto:[EMAIL PROTECTED]] > Skickat: den 23 november 2001 09:56 > Till: [EMAIL PROTECTED] > Amne: Is there any alternative to MEMO field in MYSQL database? > > > Hi, > > I nee

MERGE tables and INSERT_METHOD

Hi! > "Chris" == Chris Cooper <[EMAIL PROTECTED]> writes: Chris> Has anyone else tried to set the INSERT_METHOD for MERGE tables? It Chris> keeps throwing a syntax error for me. Chris> Following the docs verbatim (http://www.mysql.com/doc/M/E/MERGE.html), Chris> here's what I get: Chri

Bug report

Hello. We use MySQL 3.23.38 with our website http://www.rlsnet.ru. This new MySQL version is much better than the previous one (sorry, can't get the exact version number), but I noticed one strange thing which I wanna write about. When I make select TN0MNN.torgn_id, Rlsprepr.prepr_id, Rlsbopis.o

Is there any alternative to MEMO field in MYSQL database?

Hi, I need to store a string variable which is more than 255 character that varchar field in mysql can contain. I have check the available docs with me I can see anything referring to this. Any support will be highly appreciated. Thanks Kamal. ---

mysql problem

Dear support officer, The followings are generated by the mysqlbug script: SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: From: yuzh To: [EMAIL PROTECTED] Subject: [50 char

Re: corrUPted tabLE questions...

Jim Ray, @WD writes: > > I have a tabel that seems to be corrupted. Is there a way to fix it? It is > running on a Lynx box. Atari Lynx? Does MySQL really run on that? Or did you mean Linux? Hmm... Anyway, look in the manual. REPAIR TABLE is good place to start, as is myisamchk. And make sure

Re: How do I count using two tables

Hi, > I've got two tables one is News items > News_IDNewsetc... > 1 Today in .etc > 2 Hello world .etc > 3 Blar di blaretc > 4 And now time for something else > . > . > 100The last thing > and the other is comments on the news

Re: InnoDB Compiler error (as well)

Ashley, >Okay, so seeing Gemini failing, it was InnoDB's turn: >gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include >-DDBUG_OFF -O3 -DDBUG_OFF-DDEBUG_OFF -DUNIV_INTEL_X86 -c sync0sync.c >sync0sync.c: In function `sync_gnuc_intelx86_test_and_set': >sync0sync.c:187: impossible reg

RE: Migrating...

Thanks! I used the file transfer; I don't think the grants/revokes completely transferred, but that's easy enough to fix. :) Benjamen R. Meyer > Hi. > > I had the same problem awhile back. > > What i did was just copy the db files to the linux server > provided the mysql versions are exactly the