Installing all prepared tables
010423 11:09:07 Warning: setrlimit couldn't increase number of open files
to more than 200
010423 11:09:07 Warning: Changed limits: max_connections:
100 table_cache: 64
scripts/mysql_install_db[284]: 15102 Memory fault(coredump)
Installation of grant tables
Hi
SQL troubles:
I have a table containing 4 columns: name - string, distance-
double,
speed - time and id - AUTO_INCREMENT (Primery key)
I want a list of the fastest (speed) runner (name) of each distance and
the
speed.
I use:
select name, distance, min(speed) from table1 group by distance;
I
Barry,
I suspect you might have more luck sending your question to a
PowerBuilder list (what is it anyway ? A Borland product ?), althought
you might have some luck here...
regards,
P
On Tue, 24 Apr 2001, Barry Reynolds wrote:
I am having a problem with setting up a query in using MySql.
If there is a function to sum values, why there isn't one to sum strings
i.e. concat strings. Or how should i use it?
You use concat to put two strings together.
I know, i have read the manual. /concat('string1','string2')/, but it
doesn't works with group by.
I would like to get this:
1
Description:
We have a production server with mysql as db server. Currently we
are using 1 server for only processing a mysql queries and ther is
4 mysql servers running on it each using diiferent IP. When I try
to make 1 common mysql server it just recieving
My application is written in .asp and the database is mysql. do i need
myodbc to set the DSN/connection? (running in linux box)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
mysql use lum
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Didn't find any fields in table 'users'
Database changed
mysql select * from users;
ERROR 1017: Can't find file: './lum/users.frm' (errno: 13)
hi All,
I have in Tomcat JDBCRealms, A broken pipe SQLException, So I wonder
what is wrong in my code. This exception occur only after a long period of
time, while sessions should be dead long times ago. So I wonder if the
connection Pool I use ( org.ewin packadge ), released correctly the
Hi!
On Apr 24, Scott Vanderweyst wrote:
I know that the web-page says it may return bizzare results in small
cases, but I would have expected it to return consistant results though.
I came across this due to an inconsistancy that I ran across in an
application that I've been working on.
I have mysql installed on two linux boxes.
How can i access one system's mysql db from the other system
thanks
Harish
COME ON
This_is_not_a_MySQL_issue.. It has everything to do with PHP.. please keep
this discussion in the PHP lists..
By the way, crossposting isn't the way to make friends..
Looking for more info on PHP and MySQL go to some URL's mentions a
million times in several PHP lists.
Bye,
I have mysql installed on two linux boxes.
How can i access one system's mysql db from the other system
grant access to the user on the other system. COnnect to the remote system
just like you would on the local.
Bye,
B.
I'm probably out of my depth here, but please have a look at my forum at
http://forum.celinestar.org.uk. The error messages are like this:
Warning: 0 is not a MySQL result index in functions.php on line 16
Warning: 0 is not a MySQL result index in functions.php on line 21
Warning: Oops,
At 10:56 AM +0200 4/24/01, Sven Heising wrote:
Hi list
When posting help requests, it's always helpful to include the error
message you get. You can check quickly this via something like:
mysql_query(DELETE FROM $dtable where loginid = '$userto' )
or
mysql_error();
One possible
Hello,
I have a problem in writing a servlets which access to
mysql database, that can generate a french caracters
like é, à
Can some Help me.
___
Do You Yahoo!? -- Pour faire vos courses sur le Net,
Yahoo! Shopping :
James Bonham writes:
Help ! Does anyone have a clue ?
tried to run configure on Ultra SPARC/Solaris 2.7
GNU binutils and libtool latest version, gcc 2.95.2
environment variables:
CC=gcc
CFLAGS=-O6
CXX=gcc
CXXFLAGS=-O6 -felide -constructors -fno-exceptions -fno-rtti
at the
Michael Zielinski writes:
Hi,
I've tried to install MySQLGUI 1.7.5 on my system. I',ve followed the
instructions on the webpage and it seems to compile nicely, but when I try to
start it, I get the following error :
./mysqlgui: error while loading shared libraries: libsqlplus.so.1: cannot
Dear Sir/Madam and mysql users,
I have a mysql database which i can fill with phpadmin, everything is going fine, but
when I want to fill the database with php and a form. I got the following problem. I
don't know what to do anymore? Can anyone help me?
I have made a form, which visitors can
Steven P. Kerscher wrote:
I have installed mysql 3.23.36 for the first time ever
I did the test (ok)
I ran the bench mark and could not load DBI
I installed DBI 1.14
And Data Showtable 3.3
Then tried to install (Msql-Mysql-modules-1.2215)
Perl Makefile.pl worked fine
I run make and
jgw wrote:
I'm trying to compile a program using C API. I get the following errors:
/usr/lib/mysql/libmysqlclient.a(my_open.o): In function `my_open':
my_open.o(.text+0x14): undefined reference to `open64'
/usr/lib/mysql/libmysqlclient.a(mf_format.o): In function `fn_format':
I have a system built up with Debian potato and apache. I have to install
(to copy) a database from a Mandrake system - so I installed the php3
modules for apache (restarted the apache) and the Debian package of
mysql-server and mysql-client.
Can you help me, why I get the following error
Scott wrote:
I am running into a problem here with a general query that is essential
to the vitality of a website that I run. The problem is that every time
this query is executed, it is being copied to a temporary table on the
hard disk, causing an extreme slowdown. In some instances it
Once again.. a PHP issue..
You might want to try with PHP4.. latest release. If that doesn't help go
the archives @php.net..
Bye,
B.
mysql, query
At 15:16 24-4-01 +0200, [EMAIL PROTECTED] wrote:
I have a system built up with Debian potato and apache. I have to install
(to copy) a database
Dear Friends ,
One of our clients wants to port the Database which was originally in MS SQL , to MY
SQL . he main problem we are facing is that how to make previous stored procedures run
. There are a lot in the application . Front end was in VB .
We are now into feasibility study . Please
PJM == Patrick J Militzer [EMAIL PROTECTED] writes:
PJM I'm using mysql 3.22.27. How can I force mysql to use index's in
PJM my select statement?
You don't. SQL is a 4GL and you only describe what you want, and it
is up to the language interpreter and optimizer to do it efficiently.
--
This is probably something I'll smack my head about afterward, but here
goes: is it possible to execute multiple queries in the MySQL client GUI on
Win32? What's accepted on the command line or in a .sql script doesn't work
when pasted into it. Thanks in advance!
-Jason
Hello,
I set up a bi-directional binary replication with mysql. It is very
nice: some tables go one direction, some in the other direction.
Everything over a ssh tunnel (stunnel).
But:
It seems that the slave thread is pausing, without reason. SHOW SLAVE
STATUS shows normal: no error, slave is
I believe that stored procedures are still on the TODO list, but that might
not fit into your client's plans.
Recall that stored procedures are a form of compiled SQL code. Therefore,
if you want, you could take that SQL code, in the stored procedure, and put
it into your VB application and
Hi all,
I recently had cause to drop and re-create a merge table that maps 80 or so
tables (I'd added an index to all the tables whilst they were mapped, so
causing me to get incorrect results. Duh!).
However, upon re-creating it, I find that I'm now not getting any results
back (or only one or
It depends on the gui you're using. Get the one at my.anse.de
At 07:49 AM 4/24/2001 -0700, Jason Holliston wrote:
This is probably something I'll smack my head about afterward, but here
goes: is it possible to execute multiple queries in the MySQL client GUI on
Win32? What's accepted on the
I need help with this issue. We decompressed a mysql archive on a Solaris
box with gnu tar and tried to run this script ./configure
--prefix=/usr/local/mysql but was unsuccessful and received this error.
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Janos,
You need to install the php3-mysql package, which allows PHP3 to access
MySQL databases. Although, you should think about compiling PHP4 or
downloading the .debs for it. It's better than PHP3.
Oliver
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
Hi,
On Tue, Apr 24, 2001 at 10:44:59AM -0400, Vivek Khera wrote:
PJM == Patrick J Militzer [EMAIL PROTECTED] writes:
PJM I'm using mysql 3.22.27. How can I force mysql to use index's in
PJM my select statement?
You don't. SQL is a 4GL and you only describe what you want, and it
is up
I have several mysqld processes that have 'D' status as shown by ps aux.
From my limited understanding, that means they are waiting for disk and are
uninterruptible?
How do they get this way and what can I do to fix this?
Hunter
Yes, MySQLFront works much better with multiple queries at once. Nice,
quick, simple Win32 UI. I was originally using MySQL GUI that's
downloadable from http://www.mysql.com/. Oh, and for everyone's
information, http://my.anse.de/ does not appear to work, at least for this
morning.
Hi again,
I've sorted this problem out by rtfm.
Used 'REPAIR TABLE tablename' and got most of the records back.
regards,
Dave
database,sql,query
--
Don't hit me!! I'm in the Twilight Zone!!!
email: [EMAIL PROTECTED]
web: www.largesalad.co.uk/DJMsoft
Hi,
Ok, it is a little off the Mysql topic but I need to know something and I
know
someone out there can help. I need to do a search on a UNIX box using either
egrep or another command that will search for all occurances of a link. we
have updated part of our website and want to make sure there
How is disk space when this happens?
Hunter Hillegas wrote:
I have several mysqld processes that have 'D' status as shown by ps aux.
From my limited understanding, that means they are waiting for disk and are
uninterruptible?
How do they get this way and what can I do to fix this?
grep -ir href http_dir |grep -v # |grep -v good links
I use somthing like this.
Best Regards
On Tue, 24 Apr 2001, Alan Halls wrote:
Hi,
Ok, it is a little off the Mysql topic but I need to know something and I
know
someone out there can help. I need to do a search on a UNIX box using
First, make sure to follow the instructuctions in the manual on symbolic
resolve of the stack trace. Without it, numeric trace is not much help,
especially when you built your own binary and we do not have a symbol
table.
This is output of resolve_stack_dump
0x813744a
if you are using tcsh:
set docroot='path to your html root directory'
find $docroot -name *.html allhtml.list
foreach FILE (`cat allhtml.list`)
echo $FILE outhtml.list
grep 'link' $FILE outhtml.list
end
you can get more sophisticated than this, but this will work. then look
through
On Thursday 19 April 2001 21:54, Ken Menzel wrote:
cd /usr/ports/databases/mysql323-server
make
make install
reboot
this aint windows ya know
skip the reboot
/sbin/ldconfig -m /usr/local/lib/mysql
/usr/local/bin/safe_mysqld --user=mysql
I have a weird one here.
I have an application that inserts records into one of 2 different tables.
The other day, an insert attempt on one of the tables failed with a
duplicate key error on key 1, an autoincrement field. About a minute later,
an insert attempt on the other table failed
Thanks everyone for the help, you are an awesome crowd. We got it :)
Alan
-Original Message-
From: Peter Pentchev [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 24, 2001 10:19 AM
To: Alan Halls
Cc: [EMAIL PROTECTED]
Subject: Re: Can anyone help with a search?
On Tue, Apr 24, 2001 at
It depends on the gui you're using. Get the one at my.anse.de
At 07:49 AM 4/24/2001 -0700, Jason Holliston wrote:
This is probably something I'll smack my head about afterward, but here
goes: is it possible to execute multiple queries in the MySQL client GUI
on Win32? What's accepted on
MySQL 3.23.38 is already in the change log. Is there a proposed release
date? I don't want to install 3.23.37 just to have to install 3.23.38
tomorrow.
Thanks.
j-k -
--
Joshua Kugler
Associated Students of the University of Alaska Fairbanks
Information Services Director
[EMAIL
Hi - Im installing the MySQL-bench-3.23.37-1.i386.rpm, cant install because
of a MySQL-DBI-perl-bin dependency. Does anyone know what this is(RPM?or
Perl Mod?), and where i can find it?Ive been looking, but no luck yet.
Thanks!jason
What operating system are you running, and how big are these files and
indicies?
Is this a 2 Gig file size limit problem?
You are getting near the limit to the size of an unsigned mediumint.
Dan Shapella wrote:
I have a weird one here.
I have an application that inserts records into one
I am using 3.23.36 in conjunction with PHP 4.0.4pl1. When I compiled PHP, I
used --with-mysql and let it use it's own mySQL library, not compiling
against anything build under 3.23.36 (I tried the other way but the
configure failed, never finding mysqlclient libraries, even though they were
right
I am running MySQL 3.23.37 compiled by myself on Linux platform.
Here is a repeatable example:
mysql create table test (id int not null,
- KEY id (id)) type=InnoDB;
mysql SELECT id FROM test WHERE id1;
ERROR 1032: Can't find
Make sure you don't have concurrent accesses to the mysql.sock, for example the
apache authentication module (we had that). docs say you should build php with shared
mysql support, so i guess you'll still just have to do so...
On Tue, 24 Apr 2001 11:06:33 -0700
Hunter Hillegas [EMAIL
OS Is Linux.
The autoincrement key is defined as INT, so plenty of room there.
Table sizes are getting up there:
attempt.MYD 1,902,291,232inrec.MYD 1,979,795,600
attempt.MYI 280,733,696inrec.MYI 240,460,800
After doing a myisamchk -r on the attempt table, inserts appear to be
Hi,
Running 3.23.37 on freebsd
We are making about 200-250 requetes per second
on a server with 1Go RAM.
We have lot of problems with the requetes which use
order by, group by. It seems mysqld copies the data to
a tmp table to make sort. The problem is it takes a
while to be done. How to make
We encountered no real problems when converting a database from Interbase, with some
stored procedures and triggers as well, to mysql.
Most stored procedures were for things like generating a unique key, getting the
server date/time/year, etc.
Triggers are imho just application _unfriendly_,
does mySql support triggers or transactions
Matthew Hafner
Web Applications Engineer
The Ohana Foundation
1099 Alakea st
22nd floor
Honolulu, HI, 96813
1-877-61-ohana
[EMAIL PROTECTED]
-
Before posting, please check:
Matthew Hafner wrote:
does mySql support triggers or transactions
Matthew Hafner
Web Applications Engineer
The Ohana Foundation
1099 Alakea st
22nd floor
Honolulu, HI, 96813
1-877-61-ohana
[EMAIL PROTECTED]
RTFM
www.mysql.com
Hi all,
I'm looking for some pointers towards some good information on accessing and using
MySQL with Java/Javascript.
Can anyone point me towards a book you like, or some good web resources?
Thanks much,
/Rob
-
Before
MySQL supports transactions in beta form if you use a Berkley table. Check
the homepage for more information.
Triggers are in the todo pile though.
At 09:44 AM 4/24/2001 -1000, Matthew Hafner wrote:
does mySql support triggers or transactions
Matthew Hafner
Web Applications Engineer
The
Help me please !
installing MySQL 3.23.36 on Ultra SPARC/Solaris 2.7
GNU make 3.79.1, binutils, and libtool latest version, gcc 2.95.2
environment variables:
CC=gcc
CFLAGS=-O6
CXX=gcc
CXXFLAGS=-O6 -felide -constructors -fno-exceptions -fno-rtti
at the command line:
./configure
You might want to try downloading binutils from the GNU web site. It has a
modified version of the linker libraries (ld). I still wasn't able to get past
the yacc compile even with 512MB RAM. Let me know how you make out. I ended up
using the binary distribution.
James Bonham wrote:
Help me
Hi All - I just set up MySQL for the first time and cannot seem to change
the user 'root' password using mysqladmin. I must be geting the sytax wrong.
Im typing 'bin/mysqladmin -u root -p password', then it prompts me for a
password, i type one in, then it gives me an error as shown below:
COuld try a mysqldump to backup and restore the tables on the new/other
machine. This should get you past the problems you found earlier.
Remember to add the propriate users to the new machine..
Bye,
B.
mysql use lum
Reading table information for completion of table and column names
You
Hi:
I believe MySQL-bench uses Perl program to benchmark databases so that
it requires Perl-DBI. DBI is a Perl module that provides API for
database connection. I have never installed Perl modules in RPM format
but you should be able to find it on RedHat ftp server. And I think the
name
RTFM=Read The Fucking Manual
now you know.
On Tue, 24 Apr 2001 21:37:44 +0100 (BST)
Peter Skipworth [EMAIL PROTECTED] wrote:
I for one vote to not bother with abbreviations from now on - let's just
spell it out loud and clear ;) *grin*
P
On Tue, 24 Apr 2001, Steve Ruby
wrote:
Did you try to put (-1) in it?
Bye!
Facundo Batista
Gestión de Red
[EMAIL PROTECTED]
(5411) 4819-4358
#---Mensaje original-
#--De: Ashley M. Kirchner [mailto:[EMAIL PROTECTED]]
#--Enviado el: Viernes 20 de Abril de 2001 8:15 PM
#--Para: MySQL Mailing List
#--Asunto: largest
Professional JSP, by Wrox Press Ltd, is a quite good book.
Matt
- Original Message -
From: Robert Alexander [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 24, 2001 2:48 PM
Subject: Info on using MySQL with Java
Hi all,
I'm looking for some pointers towards some good
Now gentlemen please let's use appropriate language when posting to the
list, after all it is a public list and we don't want to offend anybody
At 22:04 24/04/2001 +0100, Peter Skipworth wrote:
Like duh! =)
On Tue, 24 Apr 2001, Rene Tegel wrote:
RTFM=Read The Fucking Manual
now you
Dear Jason -
Jason Feingold writes:
Hi - Im installing the MySQL-bench-3.23.37-1.i386.rpm, cant install
because of a MySQL-DBI-perl-bin dependency.
Using the RPM mechanism to install perl modules is fraught with
problems. Don't use it; you'll be sorry you did in the long run.
But, fear
That ORDER by a calculated_field DESC is killing you.
It needs to go to a temporary table for sorting.
The problem, though, is that even if I leave the ORDER clause out, or
ORDER BY any other field, the same thing happens. I initially thought
the same thing, but it happens with or without the
I don't think you can avoid having those temporary tables in executing
any kind of SELECT queries since the retrieved information should be
stored somewhere (whether you have ORDER BY or not). I would suggest
that if you have a large database, you should considering putting the
temporary space on
Hello,
I'm a newbie with MySQL, so don't apologize me when I post a stupid question.
Is it only possible to join tables 2 by 2 or is it possible to join 4 tables in
only one request?
Thanks
Marc Raeymaekers
Belgium
-
Before
Hi
I am using an application (excel) that sends sql requests and fills the
excel sheet.
When i issue an update statements, the update doesnt return data to my
program (*.vba) in excel, so it hangs.
To bypass the problem I was told to use the following ansi compliant sql
statement SET NOCOUNT ON
I'm having problems compiling mysql 3.23.37 on
Solaris 2.7. It gets to the final linking stage
and I get the following error:
/usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.1/libgcc.a: could not read symbols:
Bad value
Anyone have this happen to them before and/or
have a fix? I've also
Hi,
I tried to upgrade a 3.22.32 source install of MySQL to the
latest 3.23 source from the MySQL Web site on my RedHat 6.1 box and
ended up breaking Apache and PHP (which were also compiled by source).
Being relatively new to Linux and having gotten it working
originally via
Dear Sir,
My Linux is RedHat Linux 6.0
I follow the below step to install the mysql version 3.23.37 database :
1. tar ¡Vzxvf mysql-3.23.37.tar.gz
2. ./configure ¡Vprefix/usr/local/mysql
3. make
4. make install
5. echo ¡§/usr/local/mysql/lib/mysql¡¨ /etc/ld.so.conf
6.
Hi all,
I'm looking for some pointers towards some good information on accessing
and using MySQL with Java/Javascript.
Can anyone point me towards a book you like, or some good web resources?
Thanks much,
/Rob
You'll need a servlet and/or JSP engine such as
listed here
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 25 April 2001 2:31 PM
To: Howard Picken
Subject: Why MySQL db will only allow 127 records imported?
Your message cannot be posted because it appears to be either spam or
simply off topic to our
Marc Raeymaekers [EMAIL PROTECTED] wrote:
I'm a newbie with MySQL, so don't apologize me when I post a stupid
question.
Is it only possible to join tables 2 by 2 or is it possible to join 4
tables in
only one request?
Yes, you can join 4 tables in one SQL statement.
--
Steve Werby
Tinyint will only go up to 127 when it is signed. Try INT.
Also, please read the Docs section about data types and their sizes. It will
save you more embarassing questions like these. :)
j- k-
On Tuesday 24 April 2001 20:39, Howard Picken wrote:
-Original Message-
From:
I am having a problem with setting up a query in using MySql. The query uses a
user-defined parameter and searches the table against it. e.g.
int search//user peramater
select * from table
where member_id = :search;
When trying to run this query (using powerbuilder) it doesnt return the
Like duh! =)
On Tue, 24 Apr 2001, Rene Tegel wrote:
RTFM=Read The Fucking Manual
now you know.
On Tue, 24 Apr 2001 21:37:44 +0100 (BST)
Peter Skipworth [EMAIL PROTECTED] wrote:
I for one vote to not bother with abbreviations from now on - let's just
spell it out loud and clear
81 matches
Mail list logo