On Fri, Apr 26, 2002 at 01:28:59PM -0600, Sasha Pachev wrote:
[snip]
Sasha, here's an update with some context preserved for your
sanity. :-)
> > I recently wiped my 4.0.2 slave clean and installed the latest
> > 4.0.2, built from the BK tree. Then I synced it up with a nearby
> > slave runnin
Hi!
- Original Message -
From: "Balteo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, April 29, 2002 8:58 AM
Subject: InnoDB's inner workings + checkpoints
> Hello Heikki,
>
> I have read up on checkpoint activity and innodb and there are still a
> few p
On Tue, Apr 30, 2002 at 12:15:03PM +0530, yash wrote:
> hi,
Hi Yash. :-)
>i just installed the mysql 4.0.1 max for freebsd.
>
> -rw-r--r-- 1 root users 6085585 Dec 24 02:44
> mysql-max-4.0.1-alpha-unknown-freebsdelf4.4-i386.tar.gz
>
> and followed steps for the binary install and star
hi,
i just installed the mysql 4.0.1 max for freebsd.
-rw-r--r-- 1 root users 6085585 Dec 24 02:44
mysql-max-4.0.1-alpha-unknown-freebsdelf4.4-i386.tar.gz
and followed steps for the binary install and started the Post installation
steps.
http://www.mysql.com/documentation/mysql/bychapt
Victoria Reznichenko wrote:
>
> Do-Risika,
> Monday, April 29, 2002, 7:54:51 AM, you wrote:
>
> DRR> Can someone tell me what this error mean ?
>
> DRR> myisamchk: MyISAM file /var/lib/mysql/radius/radacct.MYI
> DRR> myisamchk: warning: 1 clients is using or hasn't closed the table
> DRR> prope
If you have a primary key which is an autoincrement field then the
following works.
CREATE TABLE `tab1`
(
Key1 smallint(5) unsigned NOT NULL auto_increment,
ColA float default NULL,
PRIMARY KEY (`Key1`)
)
TYPE=MyISAM;
insert into tab1 values (1, 3.4), (2,4.6), (3, 3.1), (4,8.2),
I am still having problems with the time zone within Mysql. I change the
value of the TZ environment variable, and that change will show up in the
SHOW VARIABLES; query within mysql, but the actual time that is being
provided by the select now(); is still not showing up correctly.
Please Help!!!
Questions:
- Do I use root account to install the software?
Yes to compile the source or do an RPM as seen below.
See http://www.mysql.com/doc/L/i/Linux-RPM.html
- What account do I use to create Innodb?
Same - I am guessing here but I do all installs as root then give the needed
permissions to
I am an Oracle DBA and need to create a MYSQL database on Thursday.
Can you answer my questions? (I have not had chance to read the manual yet.
Just a quick search, I can not find my answer.)
I plan to use InnoDB and I find it is quite similar to Oracle. However, in
Oracle we install the softwa
Greetings,
I'm new to the list and apologize if this question has already been
answered.
I'm trying to figure out how to make a thread die. From the processlist
command of mysqladmin I get back a listing of unauthenticated user that
I want to drop from their connection status.
I issue the
has anyone experienced this strange behaviour
of mysql (3.23.49, Win2000, binary distribution)
when using UPPER() and LOWER() functions
with accentuated letters?
i tried to get the lower case of Á (A acute) (ISO 8859-1 code: 193)
and the upper case of á (a acute) (ISO 8859-1 code: 225)
and i got
Alex,
I am not really understanding what exactly you are trying to do as far as
"relevance" goes. First of all, The example I gave you was based on
baselining . Depending on the common values most search return, you can
choose another value.
When you do a fulltextsearch, it returns a result
Hi Andrew,
If you carefully looked at that page, you'd see that MySQL doesn't support
nested queries with a couple exceptions and that the query you are trying to
run wouldn't work in MySQL. The bottom half of the page is dedicated for the
workarounds for your problem.
Gurhan
-Original Messa
Victoria, et. al,
Thank you very much for the leads. I looked at the section in the manual
and still have a few questions (I have added some more info which might
help).
As a reminder my problem was ...
> AW> I have a DELETE statement:
> AW> delete bond_master,bond_data from bond_data where
hi,
when using "--with-pthreads" on standard OSX 10.1.4, or pointing at
"--named-threads-libs=-lpth" (for a gnu pth install), "configure" stops at:
checking need of special linking flags... none
checking for working const... yes
checking for inline... inline
checking for off_t... yes
checking f
hi all,
i've built mysql-3.23.49 on MacOSX Server 10.1.4, as well as Sleepycat's
BerkeleyDB 4.0.14.
i note the "--with-berkeley-db" options in configure, but am stumped as to
if/how to allow support for the bdb 4.0.14 version. mysql (in configure,
acinclude.m4 & aclocal.m4) seems to limit to bd
On 29 Apr 2002, at 21:45, Mouratidis wrote:
> Problem is, relevance can be anything. It could be 3.6 for example, and
> multiplying that with a 100 will give me a number > 100. The way I had done
> it was to divide all results with the highest value of relevance and get
> something that was a per
Hello.
If you have some unique identifier, you can simply use
REPLACE INTO Table_B SELECT FROM Table_A;
But be sure to read and _understand_ the manual section about REPLACE
beforehand! Else, if you have not the required unique indexes, the
result will not be what you want.
INSERT INGORE would
At 17:36 -0300 4/29/02, Oswaldo Castro wrote:
>Hi List
>
>I have two tables inside a MySQL DB. The first one has 30 Millions records
>(30.000.000) say it Table-A . The second one has 500 Thousands Records
>(500.000) say it Table_B. I need that all the records from Table-B to be
>inserted in Table-
At 20:44 +0100 4/29/02, Mouratidis wrote:
>Actually, that is exactly what I wanted to do! A bar graph for showing the
>relevance between the term I am searching for and the results I get from
>Mysql for a library system. I just don't know how to draw the bar (which is
>going to be a table cell in
Problem is, relevance can be anything. It could be 3.6 for example, and
multiplying that with a 100 will give me a number > 100. The way I had done
it was to divide all results with the highest value of relevance and get
something that was a percentage. But, if you do that, then if you have for
ex
Hi,
You can take 1.00 as baseline for 100%. Just multiply the relevance number
by 100.. For the relevance that are greater than 1.00 you will have a
number greater than zero and for everything else it will be smaller than or
equal to 100.
In your code, do something accomplish:
if relevance
Hi.
Run EXPLAIN for both queries and see if it explains the difference (my
first guess is be that the indexes support the one query, but not the
other).
Also, what does "never finishes" mean? Please list the processlist
(using SHOW or mysqladmin) and have a look at the state of the query.
Bye,
Hi List
I have two tables inside a MySQL DB. The first one has 30 Millions records
(30.000.000) say it Table-A . The second one has 500 Thousands Records
(500.000) say it Table_B. I need that all the records from Table-B to be
inserted in Table-A. Because an operator error many of the records fro
Hello list users,
We use the PHPLib classes for our website.
( http://phplib.sourceforge.net/ )
Now we have a lot of lost connection problems when we use 2 or 3 different
db queries with different db tables !
.
$db = new newsDB();
$db->query("SELECT * FROM news ORDER BY HitsOut DESC limit
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Well, you could just base the 100% off the highest returned value.
eg, if 3.95 is the highest return, then, that's your 100%, the others are just
percentages of that.
Jayce^
On Monday 29 April 2002 01:44 pm, Mouratidis wrote:
> Actually, that is
Hi,
I think it's a not bad idea if you "look" at :
http://www.mysql.com/doc/S/t/String_functions.html
http://www.mysql.com/doc/S/t/String_comparison_functions.html
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTE
Thanx for your answer.
I don't know how much I understand the way to follow because of my poor
english that will ever be a french one.
I think I have found a good solution in downloading a SQL compatible frontal
program that allowes me to work with a graphical interface very helpul for
starters li
Cool :) works like a charm!!
Thanks.
On 4/29/02 1:54 PM, "Paul DuBois" <[EMAIL PROTECTED]> wrote:
> At 13:27 -0400 4/29/02, [EMAIL PROTECTED] wrote:
>> I am getting this error when I try to run safe_mysqld
>>
>> /usr/local/mysql/bin/safe_mysqld --user=mysql &
>>
>>
>> 020429 12:42:46 mysqld
Actually, that is exactly what I wanted to do! A bar graph for showing the
relevance between the term I am searching for and the results I get from
Mysql for a library system. I just don't know how to draw the bar (which is
going to be a table cell in a table) if I cannot have something to compare
Thanks everybody.
> Filter : sql
--
João Paulo Vasconcellos
Gerente de Tecnologia - NetCard
Tel. 21 3852-9008 Ramal 31
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
ht
Hi.
Well, a perfect example of misunderstanding due to lack of
information. I interpreted your former description in a way that your
applications simply hangs.
Had you quoted the error message you got (or even told that you got
one), it would have been more obvious that you meant a rollback due
Cindy writes:
>
>OK, it seems like every time I install mysql, I run smack dab into
>some type of access problem -- if it isn't a password hangup, it's a
>mysql.sock problem or (at the moment) a refusal to allow me to create
>databases. I've puzzled through most of it for now, but this one
Hi
>>
Can anyone explain me what is an Aborted Client ? I begin to wonder about
this because this number was about 20 or 30 last week, and now suddenly it
got above 200 ! I have no idea of what it means, so any help would be
appreciated.
<<
This is incremented if one of the following has happene
If the final goal of this is a visual display, maybe it would make more sense
to display relevance as a horizontal bar graph that is longer or shorter
based on the relevance number. There is no reason to get hung up on
percentages.
On Monday 29 April 2002 02:21 pm, Paul DuBois wrote:
> At 17:5
Hello,
I am afraid to ask some questions. They seem a little
bit long. please forgive me.thanks in advanced first.
I am working an application which is help user to
create questions for exams. I have finish this part
but I think i should modify it. I use mysql as the
backend and java servlet to
Hi
>>We say MySQL is open source database, so it can easily be adjusted to your
requirements. But I wonder how many administrators have actually gone into
the source code and made any modifications to match their specific needs, if
any. <<
The point is you "can" make modifications if you want to
Hello,
I'm trying to use the DELAYED keyword with an INSERT ... SELECT
statement but it seems to ignore the DELAYED. Does anyone know if this
is or is not supposed to work? Exmple:
session 1 session 2
--- --
cr
Hey Cindy,
Usually you can get a better idea of the real problem by looking in the
hostname.err (where hostname is the hostname of your machine) file in
whatever directory you are storing your logs in. Is there any info in
that file that you can post?
You can check to make sure another mysql.so
On Mon, Apr 29, 2002 at 12:52:23PM +0100, Steve Hay wrote:
> Hi,
>
> In addition to the deadlock problems that I'm having, as described
> in previous e-mails (still not solved...), it appears that the
> transaction_isolation level setting is not being honoured, at least
> when using BDB tables.
yep, that's the problem. But MySQL wouldn't do anything else, just a bit
faster because there are no queries to "compile". The only problem is, i
don't know how to split this field into single values. If this would be
possible, you could fill another table3 w/ these values enclosed by % % as
patte
On Mon, Apr 29, 2002 at 02:52:16PM -0300, João Paulo Vasconcellos wrote:
> Hello Everybody,
>
> can anyone explain me what is an Aborted Client ? I begin to
> wonder about this because this number was about 20 or 30 last week,
> and now suddenly it got above 200 ! I have no idea of what it mean
Cindy writes:
>
>OK, it seems like every time I install mysql, I run smack dab into
>some type of access problem -- if it isn't a password hangup, it's a
>mysql.sock problem or (at the moment) a refusal to allow me to create
>databases. I've puzzled through most of it for now, but this one
At 17:50 +0100 4/29/02, Mouratidis wrote:
>Doing that will not give back a percentage or anything that can be used to
>calculate one (right?). I meant if there was a way to actually get a result
>that could be interpreted into a percentage somehow.
No. The values returned by a FULLTEXT search ar
At 17:45 +0100 4/29/02, Mouratidis wrote:
>Sorry about sending it four times, but I keep getting an error that the
>message was not sent because the mailbox is full???.
That's because someone who is subscribed to the list has a full
mailbox. When you get a message like that, just delete it and
i
>Hello Everybody,
>
> can anyone explain me what is an Aborted Client ? I begin to wonder about
>this because this number was about 20 or 30 last week, and now suddenly it
>got above 200 ! I have no idea of what it means, so any help would be
>appreciated.
The number of connections closed by th
I can't change the lower_case_file_names variables using the -O
lower_case_file_names=1 parameter to either the mysqld or the
/etc/rc.d/init.d/mysql script. Neither mysqld -O lower_case_file_names=1 or
/etc/rc.d/init.d/mysql -O lower_case_file_names=1 works.
Is this a bug or am I missing som
Hmm. How about:
SELECT *
FROM tablename
WHERE LENGTH(somecolumn) > 0 AND ISNULL(othercolumn) != 1
Michael
On Mon, 29 Apr 2002, Andrew Kuebler wrote:
> I want to query records that do not contain empty strings and null
> values through a SELECT statement.
>
> IS NOT NULL works for the
Paul DuBois wrote:
> At 13:51 -0300 4/29/02, Luciano Barcaro wrote:
>
>> Hi,
>>
>> I downloaded the latest source from mysql.com with
>> bk clone bk://work.mysql.com:7001 mysql-4.0
>>
>> and after compile/install, it installs the 3.23.50 version.
>> Is this correct? Seems very strange to me.
>
>
You can write a program to do this.. Just query the table one , and tokenize
the string returned and query the second table for each token with LIKE
clauses and wildcards in a loop.
Gurhan
-Original Message-
From: Javier [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 29, 2002 12:53 PM
To
At 13:27 -0400 4/29/02, [EMAIL PROTECTED] wrote:
>I am getting this error when I try to run safe_mysqld
>
>/usr/local/mysql/bin/safe_mysqld --user=mysql &
>
>
>020429 12:42:46 mysqld started
>020429 12:42:46 /usr/local/mysql/libexec/mysqld: Table 'mysql.host' doesn't
>exist
>020429 12:42:46 mys
Doing that will not give back a percentage or anything that can be used to
calculate one (right?). I meant if there was a way to actually get a result
that could be interpreted into a percentage somehow.
- Original Message -
From: "Gurhan Ozen" <[EMAIL PROTECTED]>
To: "Mouratidis" <[EMAI
Sorry about sending it four times, but I keep getting an error that the
message was not sent because the mailbox is full???.
Again, my apologies.
- Original Message -
From: "Benjamin Pflugmann" <[EMAIL PROTECTED]>
To: "Mouratidis" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday,
Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
> [EMAIL PROTECTED] writes:
> > >Description:
> > mysql client from 3.23.50 won't connect to older servers running on remote hosts
>unless you specify the host as an IP address:
> >
> > ERROR 2005: Unknown MySQL Server Host 'xxx' (2)
> >
> > >Sub
Hello Everybody,
can anyone explain me what is an Aborted Client ? I begin to wonder about
this because this number was about 20 or 30 last week, and now suddenly it
got above 200 ! I have no idea of what it means, so any help would be
appreciated.
Filter : sql
--
João Paulo Vasconcellos
"Shaun Bramley" <[EMAIL PROTECTED]> writes:
> Ladies and Gentleman of the list,
>
> I have been a member of the list for about two weeks now and I must say that
> I have learned a lot. Needless to say I am relatively new to the whole db
> scene.
>
> My question is that I installed mySQL onto m
The var dir is usually where the databases and logs go. At least, from
the sources I've compiled, thats where it always gets stored.
On Mon, 2002-04-29 at 10:03, Cindy wrote:
>
> OK, it seems like every time I install mysql, I run smack dab into
> some type of access problem -- if it isn't a pa
>I want to query records that do not contain empty strings and null
>values through a SELECT statement.
>
>IS NOT NULL works for the nulls, but how I select non-empty strings
>("")? I tried everything I can think of and even some non-published
>statements like name IS NOT '' . I just can't fi
At 13:51 -0300 4/29/02, Luciano Barcaro wrote:
>Hi,
>
>I downloaded the latest source from mysql.com with
>bk clone bk://work.mysql.com:7001 mysql-4.0
>
>and after compile/install, it installs the 3.23.50 version.
>Is this correct? Seems very strange to me.
That is odd. I just tried it and got 4
I am getting this error when I try to run safe_mysqld
/usr/local/mysql/bin/safe_mysqld --user=mysql &
020429 12:42:46 mysqld started
020429 12:42:46 /usr/local/mysql/libexec/mysqld: Table 'mysql.host' doesn't
exist
020429 12:42:46 mysqld ended
Where is the mysql.host located?
How can I cre
Have you tried "... WHERE columnname=''; "??
Gurhan
-Original Message-
From: Andrew Kuebler [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 29, 2002 12:55 PM
To: [EMAIL PROTECTED]
Subject: Not secting empty strings
I want to query records that do not contain empty strings and null
value
I want to query records that do not contain empty strings and null
values through a SELECT statement.
IS NOT NULL works for the nulls, but how I select non-empty strings
("")? I tried everything I can think of and even some non-published
statements like name IS NOT '' . I just can't figure i
Hi,
I downloaded the latest source from mysql.com with
bk clone bk://work.mysql.com:7001 mysql-4.0
and after compile/install, it installs the 3.23.50 version.
Is this correct? Seems very strange to me.
so, I tried to download the source of 3.23 with the command
bk clone bk://work.mysql.com:7001
OK, it seems like every time I install mysql, I run smack dab into
some type of access problem -- if it isn't a password hangup, it's a
mysql.sock problem or (at the moment) a refusal to allow me to create
databases. I've puzzled through most of it for now, but this one
has me stumped.
It's giv
Hi,
Hope you don't mind me hassling you about this yet again.
>> ... So you would need to run two queries, a LEFT JOIN and a
>> RIGHT JOIN (or a LEFT JOIN with tables swapped) to get all
>> results.
> ... ... which is what I did in the end.
except that on further checking it doesn't work!
T
I want to query records that do not contain empty strings and null
values through a SELECT statement.
IS NOT NULL works for the nulls, but how I select non-empty strings
("")? I tried everything I can think of and even some non-published
statements like name IS NOT '' . I just can't figure i
Hi everybody,
I need do the following:
I have two MySQL tables,
Table1
.
.
field-n
.
.
Table2
.
.
field-m
.
.
and are both varchar(100) containing words separated by
space. I need to find out if any of the words in also are in
.
Is it possible to do th
Hi,
I downloaded the latest source from mysql.com with
bk clone bk://work.mysql.com:7001 mysql-4.0
and after compile/install, it installs the 3.23.50 version.
Is this correct? Seems very strange to me.
so, I tried to download the source of 3.23 with the command
bk clone bk://work.mysql.com:7001
Hello,
I am afraid to ask some questions. They seem a little
bit long. please forgive me.thanks in advanced first.
I am working an application which is help user to
create questions for exams. I have finish this part
but I think i should modify it. I use mysql as the
backend and java servlet to
Hello,
I am afraid to ask some questions. They seem a little
bit long. please forgive me.thanks in advanced first.
I am working an application which is help user to
create questions for exams. I have finish this part
but I think i should modify it. I use mysql as the
backend and java servlet to
Benjamin Pflugmann wrote:
>On Mon, Apr 29, 2002 at 08:41:16AM +0100, [EMAIL PROTECTED] wrote:
>
>>Can anybody help with the problem that I posted last week (26/04/2002
>>11:31) regarding deadlock errors via the Perl DBD::mysql module?
>>
>>To summarize, the following ridiculously simple program
ok,
here is an example query
"SELECT IDArticle, MATCH (ArticleTitle, ArticleContent, Keywords) AGAINST
('$keyword') AS relevance FROM article WHERE MATCH (ArticleTitle,
ArticleContent, Keywords) AGAINST ('$keyword')"
basicly you have to select the match statement too;
this will not return a pe
On Friday 26 April 2002 08:19 pm, [EMAIL PROTECTED] wrote:
> >Description:
> After installing MySQL on my RedHat Linux 7.2 server with
MySQL-3.23.49a-1.i386.rpm I can't run mysqladmin. mysqladmin with any
parameter results in a segmentation fault and core dump. I can run mysql and
connect to th
Greetings:
My company migrated to MySQL a few months ago from Sybase Adaptive
Server Anywhere. Where I'm very impressed with the performance and the
simplicity of management I find its very difficult, however, to run
regular updates or deletes because joins are not supported on delete and
update
Hi.
On Mon, Apr 29, 2002 at 07:58:57AM -0500, [EMAIL PROTECTED] wrote:
> Hi Guru's,
>
> We say MySQL is open source database, so it can easily be adjusted to your
> requirements. But I wonder how many administrators have actually gone into
> the source code and made any modifications to match th
On Monday 29 April 2002 04:39 am, David Harper wrote:
> >Description:
> I'm running the pre-compiled Compaq Alpha (OSF1) version of MySQL 3.23.49
> with master/slave replication.
>
> The master mysqld is running on one machine, the slave on another.
> Everything works fine
hi every body
i have installed mysql++ for linux. when i try to compile examples , i
get this message:
gcc custom1.cc
i obtain
...
/usr/local/include/mysql.h :no file or directory with
this name.
should i put some option or what??
help me please
Hi.
Could you please stop asking the same question again and again?
Meanwhile, you sent it at least four times within half a day. If
somebody knows an answer, one post is usually enough.
Bye,
Benjamin.
On Mon, Apr 29, 2002 at 11:38:14AM +0100, [EMAIL PROTECTED] wrote:
> Anybody knows
On Monday 29 April 2002 07:36 am, Wouter de Jong wrote:
> > In addition, here the resolved stack-trace:
> >
> > 0x806cb54 handle_segfault__Fi + 428
> > 0x8116c2a pthread_sighandler + 158
> > 0x80e715e mi_lock_database + 14
> > 0x80b5de8 external_lock__9ha_myisamP3THDi + 28
> > 0x8069d75 lock_exte
Hi.
On Mon, Apr 29, 2002 at 10:00:07AM +, [EMAIL PROTECTED] wrote:
>
> hi everybody,
>
> I have problem with inserting data into table.
> MY table is:-
> Name type
> IDint(9)autoincrement
> Total int(9)
>
> while i insert the data,i want the total(ID+2).Its mean the record should
> b
Hi.
Could it be that your MySQL server was upgraded to a version compiled
without InnoDB support?
If you used InnoDB it should have never complained about MYD files, as
they belong to MyISAM table format.
Bye,
Benjamin.
On Mon, Apr 29, 2002 at 01:54:28AM -0700, [EMAIL PROTECTED] wrot
hello,
where I can find a kit source of mysql for alpha true64 4.0d.
Thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request t
I removed the semicolon from the end of the query string, and I still get the
same syntax error:
You have an error in your SQL syntax near ''.1' at line 10
This is what the query looks like:
INSERT INTO micromodels
(name, revision, dynamic, m_class, novars, equation, min_0, min_1,
min_2, min_3
Hi.
On Mon, Apr 29, 2002 at 10:40:15AM +0200, [EMAIL PROTECTED] wrote:
>
> As I see after the installation mysql server user can
> login because it has bash shell in passwd file;
>
> mysql:x:100:101:MySQL server:/var/lib/mysql:/bin/bash
>
> Can I change it to /sbin/nologin without so much
> a
On Mon, Apr 29, 2002 at 01:06:02PM +0100, David Hanney wrote:
> I've got a nice fat varchar(255) primary key who's content is
> duplicated (as a foreign key) in many other tables. I hope MySQL
> optimizes away that duplication internally.
Not as much as you're probably hoping for. Consider mak
Hi.
Please start a new thread next time, instead of replying to an
existing one with a different topic.
On Mon, Apr 29, 2002 at 08:47:22AM +0100, [EMAIL PROTECTED] wrote:
> Hi List,
>
> If I run the sql query SHOW STATUS how can I tell how many queries
> required sorting?
I don't think there i
Hi.
On Mon, Apr 29, 2002 at 08:41:16AM +0100, [EMAIL PROTECTED] wrote:
> Hi,
>
> Can anybody help with the problem that I posted last week (26/04/2002
> 11:31) regarding deadlock errors via the Perl DBD::mysql module?
>
> To summarize, the following ridiculously simple program works fine when
I'm trying to set up the database link between apache+php and
mysql. The error messages that I get have suggested the user
'httpd' does not have sufficient privileges to access the
test data bases. I've tried various ways to 'grant' access,
but none seem to have any effect.
I've looked at the man
I've been looking to no avail for a day or two for MySQL 3.23.39. The ad
serving software we're running requires this version, and I've seen no
downloads for it other than
MySQL-3.23.39-1.i386.rpm offf rpmfind.net. But I stillc an't fine the
client, shared, devel or bench rpm's. Can anyone point m
Hi,
You can just do
SELECT MATCH(column name) AGAINST ('searchstring') AS relevance FROM
tablename;
There is an example at: http://www.mysql.com/doc/F/u/Fulltext_Search.html
Gurhan
-Original Message-
From: Mouratidis [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 29, 2002 6:38 AM
To: [E
At 8:37 -0600 4/29/02, Anna Fowles-Winkler wrote:
>Gerald Clark wrote:
>
>> The semicolon does not belong there.
>
>Where? At the end of the query or in the string?
>
>--Anna
At the end. Semicolons are perfectly legal in data values (which is
why this whole episode seems odd), but you don't pu
Gerald Clark wrote:
> The semicolon does not belong there.
Where? At the end of the query or in the string?
--Anna
>
>
> Anna Fowles-Winkler wrote:
>
> >Anna Fowles-Winkler wrote:
> >
> >>Paul DuBois wrote:
> >>
> Paul DuBois wrote:
>
> > At 14:37 -0600 4/26/02, Anna Fowles-Winkl
Subject: Re: Performance problems...
From: Vic Cekvenich <[EMAIL PROTECTED]>
===
DB's are IO bound. Get more cache in Raid? So 2 CPU should not help.
Conisder PostgreSQL.
Wouter de Jong wrote:
> Hi :)
>
> We're running 3 MySQL-servers for our customers databases
> (hosting-provider), and once
Wouter,
Monday, April 29, 2002, 1:42:36 PM, you wrote:
[]
WdJ> Trying to get some variables.
WdJ> Some pointers may be invalid and cause the dump to abort...
wd1> thd->query at 0x610a9940 is invalid pointer
wd1> thd->thread_id=868173
And that's why it's better to use MySQL precompiled binary!
tim,
Monday, April 29, 2002, 3:23:43 PM, you wrote:
t>Description:
t> Following installation I am unable to run the my_install_db script.
t>How-To-Repeat:
t> Follow steps for binary install, tarball untarred, symbolic link mysql
t> created, run the my_install_db script and it crashes
Michael,
Sunday, April 28, 2002, 10:45:46 PM, you wrote:
MF> If you install mysql-3.23.49 using a source tarball and compile it with gcc,
MF> the package contains documentation directories and manual directories.
MF> If you install mysql-3.23.49a using an rpm then there don't seem to be doc
MF
João,
Saturday, April 27, 2002, 5:29:54 PM, you wrote:
JPS> Some time ago I have installed MySQL and after a
JPS> short period of time I uninstalled it.
JPS> Now when I try to install it again the installshield
JPS> makes a sound (like a warning) show a message box to
JPS> quickly (it disappea
Timothy,
Sunday, April 28, 2002, 6:18:12 PM, you wrote:
TK> 1. Windows is giving me the 1067 error, which states
TK> that the MySQL server is terminating unexpectedly. I
TK> guess I'm going to have to reinstall it, unless
TK> there's some way to troubleshoot what's wrong and then
TK> fix the pro
Jan,
Saturday, April 27, 2002, 7:00:13 PM, you wrote:
JP> Is there any ability to put tables dynamic in a query?
JP> I have to do a select * for many tables and it would be cool if I just do
JP> something like this
JP> select * from (select t from mytables).
JP> Thanks a lot,
You can't do this w
Rw,
Sunday, April 28, 2002, 8:52:47 PM, you wrote:
>> How to enable the table for read write again ?
I gave not enough info :(
Did you get error "table is read only" or what?
R> Ridwan
R> Goldbase Technology
--
For technical support contracts, goto https://order.mysql.com/
This email is sp
1 - 100 of 137 matches
Mail list logo
