Hi, I need a version of mysql that is 3.22 or higher for solaris 2.6. On
your download site, you only have support for solaris 2.5, 2.7, and 2.8.
Can you help me out? Thanks.
-
Before posting, please check:
Brian French wrote:
hey, i'm having trouble installing MySQL-3.23.45-1.i386.rpm
already installed
MySQL-client-3.23.45-1.i386.rpm
MySQL-devel-3.23.45-1.i386.rpm
when i try to install MySQL-3.23.45-1.i386.rpm i get the following:
[root@localhost rpms]#rpm -U --force --replacefiles
Before I start, I know that HANDLER (ie, HANDLER table OPEN, HANDLER table
READ, etc) are low level and the use is pretty hairy!
However, the following is a fairly basic problem, and if it cannot be
overcome, one would question the validity of having HANDLER at all. (read
that with a smile
please, if somebody knows about this problem, help me
regards
alemo
- Original Message -
Hello,
I've updated my mySQL from version 3.21 to 3.23, and (after this change)
all
of my perl programs which use mysql, prints to STDERR, a debug (?) message
like this:
SV = RV(0x84ec388) at
I've set up a database with a text feild and want to call that
information with html code embeded into the text( eg. br). Do I need
to change the type of field ?. At the moment the html code is being
returned as plain text.
Hi!
On Nov 30, Ian Collins wrote:
Before I start, I know that HANDLER (ie, HANDLER table OPEN, HANDLER table
READ, etc) are low level and the use is pretty hairy!
However, the following is a fairly basic problem, and if it cannot be
overcome, one would question the validity of having
No, you don't have to change the type of field. If you want more HTML
embedded, you could save those HTMLs together w/ the text in your
database, or... if you just want the br / tags, then, assuming your
text has a new line character (\n), you have to do some sort of substitution.
Forexample, in
Hi!
I have a problem! Too many connections error in myODBC.
I am wondering now how to optimize the code...
What is better, to make 14 open.comm and close.conn on a web page or to open
once and close once?
Asked differently, is it better to connect to database one and be connected
until all
So what was the problem?
Weaver, Walt wrote:
WW: Okay, I know you guys have been wracking your brains for the last two days
WW: trying to solve my problem of mysqldump running out of memory while dumping
WW: a large table.
WW:
WW: I figured it out, so you can all go on
Webmaster writes:
I've set up a database with a text feild and want to call that
information with html code embeded into the text( eg. br). Do I need
to change the type of field ?. At the moment the html code is being
returned as plain text.
An HTML document is just a sequence of bytes,
Every connection will carry some overhead cost. So you'll have to
connect as few times as possible.
Jerry wrote:
J: Hi!
J:
J: I have a problem! Too many connections error in myODBC.
J:
J: I am wondering now how to optimize the code...
J:
J: What is better, to make
On Thu, 29 Nov 2001, nut sss wrote:
can i do this?
content in field=aaa,bbb,ccc,hhh
new content=aaa,bbb,ccc,hhh,fff
can i append new word fff into the old field .by
use update command in 1 query :)
it's like
UPDATE persondata SET age=age+1
but i want to append new value
sherzodR writes:
No, you don't have to change the type of field. If you want more HTML
embedded, you could save those HTMLs together w/ the text in your
database, or... if you just want the br / tags, then, assuming your
text has a new line character (\n), you have to do some sort of
Sorry should of given more infromation. I'm using Roxen 2.1 as my web
server and am using the roxen emit tag to call the information.
-Original Message-
From: Carl Troein [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Fri, 30 Nov 2001 10:22:34 GMT
Subject: Re: html ina text feild
Brian French wrote:
hey, i'm having trouble installing MySQL-3.23.45-1.i386.rpm
already installed
MySQL-client-3.23.45-1.i386.rpm
MySQL-devel-3.23.45-1.i386.rpm
when i try to install MySQL-3.23.45-1.i386.rpm i get the following:
[root@localhost rpms]#rpm -U --force --replacefiles
UPDATE your_table SET your_col = CONCAT(your_col, fff);
nut sss wrote:
ns: can i do this?
ns:content in field=aaa,bbb,ccc,hhh
ns:new content=aaa,bbb,ccc,hhh,fff
ns:can i append new word fff into the old field .by
ns: use update command in 1 query :)
Hi everybody:
Can anybody tellme how can y get the id asigned to a record in the moment i
insert data in the database?
I need to storage transaction requests, the mysql database assigns an unique
id (auto increment) to that record, and i need it to continue saving data in
another table.
Is
I am not quite sure, but the only I could think of is the table locking.
Just lock those two tables at the time of transaction, and release the lock
as soon as you're done. I am sure people out here might have more
sophisticated solutions... in which case i'd like to be aware of that too
( I
Can someone perhaps tell me why the following pseudo-code blocks at time 4,
when transaction isolation is set to READ_COMMITTED. Table A is a BDB table,
records 1 and 400 both exist. To me it seems that both updates don't have
anything to do with eachother. Does this perhaps has anything to do
Okay, second time of asking, does anyone know why InnoDB inserts are an order of
magnitude slower than BDB inserts?
Is this true only for me? If so, what am I doing wrong?
Is it a FAQ? If so, where can I find the answer?
Are InnoDB tables supposed to behave like this? If so, why?
I know I'm
Hi!
Chang-Ping == Chang-Ping Hsiao [EMAIL PROTECTED] writes:
The problem with gcc 3.0.x, as I have understood it, is that for this
to work you must also have libstdc++v3 installed.
I have now updated our documentation about this.
Chang-Ping According to the web page
Chang-Ping
Hi ... I am need the following query to work :
SELECT
min(my_colum) as MINIMAL_VALUE
WHERE
MINIMAL_VALUE 10
The query is not EXACTLY as this one, but i think it is enough to get you
the idea of my problem...
Thnx for any help !
[]~S
julio
Hi Chris,
Welcome to the MySQL list;^) good to see you here...
Any way I found a link which might explain why your InnoDB inserts take
longer, perhaps this may be the reason...
http://www.mysql.com/doc/S/E/SEC418.html
In inserts InnoDB uses the insert buffer to merge secondary index records
to
A quick search on Google gives some places here is the search URL:
http://www.google.com/search?hl=enq=libodbcinst.so.1spell=1
HTH
At 01:46 PM 11/30/2001 +1300, Quentin Bennett wrote:
Hi,
Can anyone point me, a humble C programmer, to a tutorial for setting up and
using JDBC and MySQL.
We
Hi try http://www.devshed.com/Server_Side/PHP/SoothinglySeamless/page1.html
for good tutorials on PHP and MySQL, although biased toward Unix, I suppose
it should work in a similar way on IIS. Maybe wrong?!
snip
?
$dbuser = 'root';
$dbhost = 'localhost';
$dbpass
Try to use HAVING instead of WHERE. I hope that will help.
Julio Faerman wrote:
JF: Hi ... I am need the following query to work :
JF: SELECT
JF: min(my_colum) as MINIMAL_VALUE
JF: WHERE
JF: MINIMAL_VALUE 10
JF:
JF: The query is not EXACTLY as this one,
Norman Khine wrote:
Welcome to the MySQL list;^) good to see you here...
*grinz* It's weird being a newbie again :-P
In inserts InnoDB uses the insert buffer to merge secondary index records
to indexes in batches. That saves a lot of disk i/o. In rollback no such
mechanism is used, and
It won't work this way.
SELECT min(my_column) as MINIMAL_VALUE
will give you ONE record only. Therefore, an additional condition (which
you can get with HAVING, not WHERE) will be meaningless.
e.g:
SELECT min(my_column) as MINIMAL_VALUE
FROM mytable
HAVING MINIMAL_VALUE 10
will return an
A good book is JSP, Servlets, and mySQL by David Harms.
-- original Message-
From: Quentin Bennett [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 6:47 PM
To: MySQL (E-mail); '[EMAIL PROTECTED]'
Subject: Solaris, JDBC and MySQL
Hi,
Can anyone point me, a humble C
Just For My Info: does it take long for one insert. if so, what does
the insert statement look like. the reason i ask is becuase i use
InnoDB and inserted a few records and it was pretty quick. but maybe
thats becuase my statement was:
insert into table (user,email,firstname,lastname)
At 15.40 29/11/01 -0500, Raymond Abel wrote:
At 16:44 2001-11-29 +, you wrote:
On Thursday 29 Nov 2001 16:18, Fabien R. wrote:
I saw somewhere that this comparaison existed but I can't remember
where.
Does it talk to anyone ?
i used interbase to develop an application with delphi.
This didn't seem to make it to the list the first time so let's try again. BTW is
anybody else receiving each mail twice from
the list?
I am getting the same error message configure: error: cannot run test program while
cross compiling. I think this a simple
PATH issue where basic functions
Joe Ellis wrote:
Just For My Info: does it take long for one insert. if so, what does
the insert statement look like. the reason i ask is becuase i use
InnoDB and inserted a few records and it was pretty quick. but maybe
thats becuase my statement was:
insert into table
Hello,
I've got a bunch of tables from MS Excel that I've exported to tab delimited
files that I'm trying to load into mySQL. I'm having problems getting the
data in properly though.
For instance, I have set up the ids so that they are incremented
automatically. I have the initial records in
Hi!
I'll be happy if I know that when Stable version 4.0 will be released.
Thanks!
Homepage = http://www.nnr.or.kr/inos/
ICQ # = 123534385
Member of DSN(database.sarang.net), NNR(nnr.or.kr)
--MIME Multi-part separator--
Hello,
I have 2 application running in a master/slave mode.
- Application A linked to a database D
- Application A' linked to a database D'
While A is master, A' is in standby mode and D' replicates D.
If a problem occurs on A, A' becomes master and D must replicate D'.
1) Is it possible for
MySQL 3.23.39
RH6.2
Apache 1.3.12
2 weeks ago mysql stopped with the following example error.(repeated on
other sites that use mysql on my server)
Warning: Host 'localhost' is blocked because of many connection errors.
Unblock with 'mysqladmin flush-hosts' in
I'm running MySQL on Windows2k. The service is installed and I can start it
with the WinMySQLAdmin Tool, but I have trouble to shutdown the server on a
DOScommand window with 'mysqladmin shutdown'. I also can't connect to the
server at localhost, and I can't start MySQL as a service with 'mysqld
Hi.
This didn't seem to make it to the list the first time so let's try
again. BTW is anybody else
receiving each mail twice from the list?
It did, it's just that no one answered it. :]
Not me, the last time I thought that was happening, it had to do with my
mail sorting rules in Outlook.
If you are using the MySQL RPMS for RedHat, They install in the /usr directory.
(Redhat dows things differently)
So it would be
./configure --with-mysql=/usr for PHP compilation.
as far as upgrading... I have used RedHat for a long time, and have found that in
their newest distos, it is
Support wrote:
MySQL 3.23.39
RH6.2
Apache 1.3.12
2 weeks ago mysql stopped with the following example error.(repeated on
other sites that use mysql on my server)
Warning: Host 'localhost' is blocked because of many connection errors.
Unblock with 'mysqladmin flush-hosts' in
I'm using a table joiner tabel with a auto-incrementing key field, and I
would like to empty the table, and start fresh from key 1 (as compared to
the next auto-incremented key). Can anyone tell me how to do this (in mysql
or in php)?
Steve Osborne
Database Programmer
Chinook Multimedia Inc.
On 30-Nov-01, Ravi Raman said something totally profound about RE: compile problems on
Solaris8 that made me ponder...
RR It's been a while since I tried to compile mysql on a Solaris box, but
RR that error most like likely indicates a compiler-related issue...I don't
RR know how much help I
Brian P. Austin wrote:
If you are using the MySQL RPMS for RedHat, They install in the /usr directory.
(Redhat dows things differently)
So it would be
./configure --with-mysql=/usr for PHP compilation.
as far as upgrading... I have used RedHat for a long time, and have found that in
Hi
i have php4.0.6
Can't see why i should change apache as i don't see that as the problem.
is it a know issue in MySQL that 3.23.45 fixes? if not i don't upgrade
everytime there is a new release.
The server has been up since april this year and this is first time the
error has happened.
It is
Hi Johnathon,
There are several problems with threads and the C++ compiler on
FreeBSD 4.2. If you can please update to FreeBSD 4.4, or for
performance enhancements go to 4.4-stable. If you have to stay on
4.2 I can send you a patch that should work on 4.2, but you will have
to recompile
If the MySQL server is unable to create the mysql.log log file, then the
server hangs in an undeterminate state. No children are forked, and clients
can connect, however are not serviced at all.
I know there is an error in the log , or when mysqld is ran with STDERR
logging, however in my humble
I'm using roxen 2.1 as my web server and have set up a form page which
querys the database and returns the stories to a new page. How do I set
up a counter to record how many times that story has been read.All
stories are loaded into the database and the new page is the results of
the query.
Is there a utility that will allow me to view a mysql database that is
similar to an Access 2000 relationship diagram?
Steve Osborne
Database Programmer
Chinook Multimedia Inc.
-
Before posting, please check:
David,
I currently run a system with Raid 5. I have had one disk drop, however,
no data was lost. That is one of the beauties of RAID 5, you have a
spare disk that takes over.
I too had heard originally that running MySQL on a RAID 5 was a bad idea
(this, after I already had it running...),
B: querys the database and returns the stories to a new page. How do I set
B: up a counter to record how many times that story has been read.All
B: stories are loaded into the database and the new page is the results of
B: the query.
B:
First off, what programming API are u
Also, although the standard groupadd command doesn't work for adding
groups, you can use NetInfo Manager to add a group. This gives you a
GUI interface to managing your groups and users. If you don't like GUI,
use the command line tool niutil, which has its own man page.
You would probably
We use this:
http://www.datanamic.com/dezign/
Try the demo before buying it, it's not quite as good as it looks
(unfortunately).
Along with the ImportER MySQL you can just set it loose on your DDLs and
it will generate a semi-complete ER diagram of your database.
It helps if your foreign keys
Roxen 2.1 uses pike
-Original Message-
From: sherzodR [EMAIL PROTECTED]
To: B.J.Rumsey [EMAIL PROTECTED]
Date: Fri, 30 Nov 2001 10:36:47 -0600 (CST)
Subject: Re: Title counter
B: querys the database and returns the stories to a new page. How
do I set
B: up a counter to record
I use visio professional...
But it's home made, not auto made like with an access DB.
Plus since there are not a lot of types from visio, I prefered to make
my own drawing, using cool functions like the snapping (so when I move
tables they stay linked). Plus the relationship from visio are
This keeps coming up. So far (in my reading of this list since spring,
and searches on Google),
* everyone who has reported this was using the precompiled binary of gcc
(either 2.95.2 or 2.95.3) from Sunfreeware to build MySQL for Solaris 8
sparc.
* No one has spoken up to report
On Fri, Nov 30, 2001 at 11:56:05AM -0500, Michael Stassen wrote:
:
: This keeps coming up. So far (in my reading of this list since spring,
: and searches on Google),
:
: * everyone who has reported this was using the precompiled binary of gcc
: (either 2.95.2 or 2.95.3) from Sunfreeware
make fails with mksh: Fatal error in reader: = missing from replacement
macro reference
Current working directory
/opt/perlModules/MyODBC-2.50.37
I have ODBC working for SQL Server.
If I do a make -V is leads me to a bad set of lines in Makefile:
DEPS_MAGIC :=
Hello,
I'm designing a database, and of course I have no formal training in
this area (I'm learning from DuBois's book). It's designed to keep
track of files. In my organization, we have a small design studio, and
the designers save their image files to CD-ROMs. As you can imagine,
the
Hi,
I am planning an authentication system that is structured much like the
system Windows uses:
I have users and groups. Groups can either contain users directly or can
contain other groups (which can again contain groups etc).
Now I am thinking on how to store and efficiently read those
Hi,
I have been working with mySQL and Apache for years on linux servers. But
recently I purchased Solaris machine, and I am have problems compiling
mySQL on it.
I have
- SunOS machine1 5.8 Generic_108528-10 sun4u sparc SUNW,Sun-Blade-100
- with gcc 2.95.3 20010315
And I am getting the following
I don't think the manual page at http://www.mysql.com/doc/S/o/Solaris.html
is much help here. It mentions setting
ac_cv_sys_restartable_syscalls=${ac_cv_sys_restartable_syscalls='no'}
in your config.cache in case of a particular error, not the one reported
here. I think I remember reading
On Friday 30 Nov 2001 16:33, Jason Burfield wrote:
First of all, the idea of data loss because one disk has gone bad on RAID-5
is not possible. RAID-5 specifically allows you to loose up to 1 disk at any
one time, and stay active.
The reason why RAID-5 is not recommended for MySQL is speed.
I appreciate all the help that you all have provided I've got another
one for you all.
I am receiving the following error when I try to restore a database backup
from an .sql file:
ERROR 1064 at line 12: You have an error in your SQL syntax near
'PACK_KEYS=1' at line 11
Code used:
DROP
Anyone know a good ERD program that will also interact with MySQL to write
the CREATE scripts? As usual open source would be nice, also running on a
win2k workstation.
I used to use PowerDesigner. Nice software but too expensive.
Won
=
Not being a materialist in the U.S.
Well, this changes things (in my mind, anyway). Now that we know it can
be done, the likely explanation is that something is wrong with the gcc
installation for people who report this. It's strange though, since a few
people who've reported this have claimed to be able to successfully build
On Fri, Nov 30, 2001 at 12:15:26PM -0500, Won Lee wrote:
Anyone know a good ERD program that will also interact with MySQL to write
the CREATE scripts? As usual open source would be nice, also running on a
win2k workstation.
I used to use PowerDesigner. Nice software but too expensive.
I've not used it yet, but I saw this on freshmeat:
Data Architect from the Kompany
http://www.thekompany.com/products/dataarchitect/
Won Lee wrote:
Anyone know a good ERD program that will also interact with MySQL to write
the CREATE scripts? As usual open source would be nice, also
Ady,
what version of MySQL you are running? In 3.23.44 there was a bug which
could cause an assertion failure in trx0trx.c, line 178.
Please test with 3.23.45 or .46.
Regards,
Heikki
http://www.innodb.com
--
Order commercial MySQL/InnoDB support at https://order.mysql.com/
After having
Hi Erik,
In the files table, each row corresponds to a separate file. There's
all sorts of additional criteria, but the only one that matters to my
question is the column called div_id. That's right, the number in
That's exactly what I would recommend you to do. As you wrote, you can
Chris,
what is your my.cnf or my.ini like? Do you have a big enough
innodb_buffer_pool_size?
Regards,
Heikki
http://www.innodb.com
--
Order commercial MySQL/InnoDB support at https://order.mysql.com/
[EMAIL PROTECTED] wrote:
Your message cannot be posted because it appears to be either
Anyone know a good ERD program that will also interact with MySQL to write
the CREATE scripts? As usual open source would be nice, also running on a
win2k workstation.
I used to use PowerDesigner. Nice software but too expensive.
I have used PowerDesigner for years and have found it to
Sorry for the repost of this problem, but I can't find the answer anywhere,
and I'm stuck here until I solve this.
I am receiving the following error when I try to restore a database backup
from an .sql file:
ERROR 1064 at line 12: You have an error in your SQL syntax near
'PACK_KEYS=1' at line
Heikki Tuuri wrote:
Chris,
what is your my.cnf or my.ini like? Do you have a big enough
innodb_buffer_pool_size?
set-variable = innodb_buffer_pool_size=300M
big enough?
Chris
database, sql, query, table (just to keep the stoopid list software from
whinging..)
Jens,
That is great news! You've made my day -- that means that the rest of
my tables should work with JOIN queries, as I am building them along the
same model -- using ID numbers instead of actual names to connect to the
main files table. Thanks for clearing that up for me.
And also for
OK I managed to get passed the cross compiler error. Thanks for the links Ravi and
Alan. I included /usr/local/lib in my
LD_LIBRARY_PATH and that seemed to do the trick and allowed configure to finish
however I am still concerned about certain
things not being found among others:
checking
yeah, but the http://www.thekompany.com/products/dataarchitect/ link to buy
the dl version just shows that you have nothing in your cart, and doesn't
give you dl options. I recommend not using that site.
I wonder how many more errors are in their software, if they cannot even
make an html link
I'm having difficulty doing a LEFT OUTER JOIN, and was hoping someone could
shed a little light on what I'm doing:
Table A has one column, val, that's an integer. There are 90 records, with
values of val from 1-90.
Looks like this:
val
---
1
2
.
.
.
90
Table B is more sparse, with 2 columns:
I knew it. Nobody bothered to read my post.
The original problem involved running a lightweight version of mysqldump in
a simulated nanokernel environment with reduced power resources. The
ultimate result, we hope, is to use it to record Quidditch matches being
played in Afghanistan.
Thanks,
Are there anyone from Auckland , New Zealand that can tell me where I can
get a good book on mysql?
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi,
I've got a *BIG* problem here...
I have a mysql database with some big tables (50,000 - 80,000 records and
above)
running on a netbsd machine.
Users run queries from their windoze machines through a delphi program via
myodbc. I didn't write that application so I can only guess the queries
On Saturday 01 December 2001 01:49, Heikki Tuuri wrote:
Ady,
what version of MySQL you are running? In 3.23.44 there was a bug which
could cause an assertion failure in trx0trx.c, line 178.
I use MySQL 3.23.44, i try to download mysql 3.23.45 from Mysql.com but it
always fail, any mirror
Harlan Feinstein [EMAIL PROTECTED] wrote:
I've joined them an SQL statement that looks like this:
select val, status
from A
left outer join B on val=id;
What I'd LIKE is a 90-row result set, with the status field from table B
when there was data available. What I'm getting is essentially
the problem John is experiencing is because he didn't actually select a
product to purchase. It is hard to add nothing to your shopping cart,
so that is exactly what we do. There are two purchase options, one is
CD and one is Download, and you must choose one before you add it to
your
database,sql,query,table
yeah, but the http://www.thekompany.com/products/dataarchitect/ link to
buy the dl version just shows that you have nothing in your cart, and
doesn't give you dl options. I recommend not using that site.
I have forwarded your comments to the CEO of theKompany. I am
Thanks Peter,
I have already addressed the issue with sales/webmaster, and they are
updating the page. Now, that's a Kompany.
-Original Message-
From: Peter Harvey [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 30, 2001 3:25 PM
To: john; Won Lee; mysqlList
Subject: Re: ERD
I have a query. It (should) return one row. It normally does, except when I
do something like this:
(query)
(loop through results)
(update table that was in the first query)
When I do this logic in Perl/DBI, it seems to restart the loop, returning the
same row, over and over again. Can
On Fri, 30 Nov 2001 15:25:18 -0700, Ken Kinder [EMAIL PROTECTED] wrote:
I have a query. It (should) return one row. It normally does, except when I
do something like this:
(query)
(loop through results)
(update table that was in the first query)
When I do this logic in Perl/DBI, it seems
Please show us your Perl code and then we can have a look and try to find
what is wrong,
Cheers Karl.
- Original Message -
From: Ken Kinder [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, November 30, 2001 10:25 PM
Subject: Running queries while queries are still running
I have
I created the file with ver 3.23.43, tried to recreate database on 3.22.32.
I administer 2 other databases the same commands and they work fine. I
looked at the difference in the sql files, and those ones don't contain the
PACK_KEYS statement...just TYPE=myISAM. The command used to create the
Hi
While tuning the system to minimize locking, I added SQL_BUFFER_RESULT to
some
of my select statements. Since then have been seeing a lot of
created_tmp_disk_tables
e.g. below is what I see after restarting the system for less than an hour.
| Created_tmp_disk_tables | 515 |
|
Why doesn't MySQL support descending keys in indexes?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
allrighty, for you perl/mysql folks here is the trouble I'm having.
I'm tyring to do a transaction in mysql/innodb in perl with the following
basic flow
eval{
Insert my first record
get the insert_id
(using $sth-{mysql_insert_id})
now perform other
In the last episode (Nov 30), Steve Osborne said:
I created the file with ver 3.23.43, tried to recreate database on
3.22.32. I administer 2 other databases the same commands and they
work fine. I looked at the difference in the sql files, and those
ones don't contain the PACK_KEYS
Hi,
As always, the best version of MySQL to work with is the latest stable
release 3.23.46 :)
Regards,
Jorge
--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/
Try giving a range in the where clause, I have the latest source
(from bit keeper and it seems to alway use the index here) there is
lots of good things coming in 4.0.1.
Here I've provide some examples from my test system. Using a date
field. Forcing both a sorted response and an unsorted
DBD::mysql::st execute failed: The table 'ip_src' is full at
/usr/local/lib/perl5/site_perl/5.005/i386-freebsd/Mysql.pm line 172.
I get this error when running a query on my database. According to the
documentation, in later versions of mysql this problem should be bypassed
due to the automatic
trying to compile mysql-3.23.46, getting this error. Can't find any
reference to it anywhere.
Please help;
kgcc -O3 -DDBUG_OFF -O9 -rdynamic -o isamchk isamchk.o sort.o libnisam.a
../mysys/libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a -lpthread
-lz -lcrypt -lnsl -lm -lpthread
OK, so I'm on a slightly older version for this experiment (3.23.36)..
I tried restarting mysqld with the line
set=lower_case_table_names=1
in my my.cnf (on RedHat 7.1), and have a table called ipaddr in my
database (the files are ipaddr.frm, ipaddr.MYD and ipaddr.MYI). (I have
verified
Support wrote:
Hi
i have php4.0.6
Can't see why i should change apache as i don't see that as the problem.
is it a know issue in MySQL that 3.23.45 fixes? if not i don't upgrade
everytime there is a new release.
The server has been up since april this year and this is first time the
1 - 100 of 103 matches
Mail list logo