Hi,
I'm still a newbie in mysql and also sql statements.
I
was wondering if some one can help me with this
problem.
I'm trying to select 5 of the highest values from a
table. But i can't seem to find any help from the
manual and also some other books. In the manual,
there
is only a
Hi,
...
I'm still a newbie in mysql and also sql statements.
I was wondering if some one can help me with this problem.
I'm trying to select 5 of the highest values from a
table. But i can't seem to find any help from the
manual and also some other books. In the manual,
there is
Hi,
I've created a database whith one table.
This table has 3 columns and use an index.
I would like to move the file that stands for the index on another
partition.
What file does store the indexes ?
Does a symbolincd link be enough to move the index on another disk ?
Thanks
--
Pascal
In order to choose a DBMS, i've to check to MySQL is able to support our
requirements.
I've got to manage one database.
This database is made of one table.
This table will grow very quickly (we evaluate that we'll have to make
arround 1.000.000.000 inserts per day).
I want to be sure that
Dear Sir,
We are trying to install and configure mysql version .23.32 on Linux Red
Hat 7.
Usinf the configure option
./configure --prefix=/usr/local --localstatedir=/usr/local/mysql/data
--with-unix-socket-path=/usr.local/mysql/tmp/mysql.sock
the make and make install.
we have tried several
First try to find out where you socket is located:
# lsof -p {$PID_OF_MYSQL] |grep unix
mysqld 1277 root 4u unix 0xcb596580 1712 /var/lib/mysql/mysql.sock
And then point to this file in mysql conf file:
# more /etc/my.cnf
[client]
socket=/var/lib/mysql/mysql.sock
[mysqld]
Hi,
I'm trying to run mysqlgui 1.7.4 (both static and semi-static versions) and
I'm running into a problem when I try to open the Grant/Revoke dialog. Only
the title bar appears on GNOME and only the title bar and the username
textbox appears on KDE 2.
It works just fine on kde 1.2. Is there
S Lemmon writes:
Sinisa Milivojevic wrote:
Hi!
With :
select * from table;
queries MySQL returns results immediately.
Any problem that you experience might come only from poor build, some
OS bug or some wrong settings.
Thanks for the reply! That's good
I have to check to MySQL is able to support our requirements and I would
like to view a return of n columns like only one register, thats is posible
with MySQL?
For example i have 2 tables , 1 table have products and this table habe 3
colums ID , name, Id_price and the other table
Petter Larsson writes:
Hi,
I recantly upgraded from 3.22.32 to 3.23.35 using an rpm from
www.mysql.com.
My platform: Redhat Linux 2.2.14 i686
The problem is now that UPDATE do not always succed. I get a query OK
but no
update is done unless the same query is issued once
Hi!
Has anyone a nice example of a timer that will run on a Win OS? It is to
be a timed display in which a record is retrieved from a MySql database
table and after 15 seconds the next record comes up for display. Since the
application has to be responsive to user input during the "show" of
well, i think you'll have to work with frames. 1 php script shows your
refreshing data, 1 script allows the user to enter data (this could be a
single script called with different parameters as well).
then in the refreshing script you put something like this before sending any
other data:
header
Gustavo Gibson da Silva writes:
Hi,
I'm trying to run mysqlgui 1.7.4 (both static and semi-static versions) and
I'm running into a problem when I try to open the Grant/Revoke dialog. Only
the title bar appears on GNOME and only the title bar and the username
textbox appears on KDE
Not without some procedural code in a different language or creating temp
tables. (Both are bad ideas.) Using straight SQL, the best you can get it
3 records, each with all the info from table 1 and a different row from
table 2.
HTH,
Cal
http://www.calevans.com
-Original Message-
I was able to build the mysql gui on Solaris 2.8, but it core dumps every
time on the following line in connection.cc
if (mysql_real_connect(mysql,host,user,passwd,db,
port,socket_name,client_flag))
called from either:
1232
How does PostreSQL compair to MySQL ?
I'm sure each has it's own advantages disadvantages.
What are some of the major ones?
Which would be more capible in a large web base
database where the database was very large and the hit
rate very high?
Thanks - tmb
Hi!
"BAUMEISTER" == BAUMEISTER Alexandre [EMAIL PROTECTED] writes:
BAUMEISTER Sinisa,
BAUMEISTER This time I compiled with :
BAUMEISTER CFLAGS=-DSOLARIS CXXFLAGS="-DSOLARIS -felide-constructors
-fno-exceptions -fno-rtti" ./configure
BAUMEISTER --prefix=/usr/local/mysql --without-bench
Hi
I've recently installed MySQL onto suse linux 7.1 pro using the YaST2 installation
program. When my system restarts a mesage saying that mysql has failed in runlevel 5
appears, however the database does appear to be running as I can connect to it via the
mysql client and view databases
deCarmo, Linden writes:
I was able to build the mysql gui on Solaris 2.8, but it core dumps every
time on the following line in connection.cc
if (mysql_real_connect(mysql,host,user,passwd,db,
port,socket_name,client_flag))
called from either:
1232
I have to check to MySQL is able to support our requirements
and I would
like to view a return of n columns like only one register, thats is posible
with MySQL?
For example i have 2 tables , 1 table have products and this
table habe 3
colums ID , name, Id_price and the other table
We pay for support here.
In the last two years, I have only needed tor resort to it once, because
the mailing list is very effective.
When I needed to resort to my support contract, it was a real problem
that the list would not have been able to solve. The problem was
resolved
within 24 hours.
Rajeev Ramanujan wrote:
Hai,
I am using Red Hat Linux 7. From where can I get example programmes of
connectiong to MYSQL using PERL under Linux.
Thankyou
Rajeev Ramanujan
Look at any of the perl based packages or utilities listed in the
contributed section
at mysql.com.
One of
How about mysql.com, http://cpan.org/modules/by-module/DBI/
MySQL.com has numerous links to help documents and code samples.
--
===
"If you put three drops of poison into a 100 percent pure Java, you get - Windows. If
Buy the MySQL book from New Riders. You won't be disappointed.
--
===
"If you put three drops of poison into a 100 percent pure Java, you get - Windows. If
you put a few drops of Java into Windows, you still have Windows."
Voytek Lapinski wrote:
Ok... I've posted briefly regarding this, but heres a complete bug report.
Yeah I know its kinda long, but I thought it better to include more rather
than less.
We are seeing a problem which results in mysqld dying with a SIGSEGV. The
problem has been confirmed on
Apparently you have not even looked at the manual.
Depending on table type, the index will end in .MYI or .IDX.
Symbolic links are discussed in the manual.
Pascal THIVENT wrote:
Hi,
I've created a database whith one table.
This table has 3 columns and use an index.
I would like to move
Did you follow the rest of the instructions?
Did you create the mysql user?
Did you run mysql_install_db --user=mysql ?
Did you start the server ?
"Foresight Systems Ltd." wrote:
Dear Sir,
We are trying to install and configure mysql version .23.32 on Linux Red
Hat 7.
Usinf the
Hi there,
When I use C API ,mysql_query.
I got an error :
Commands out of sync; You can't run this command now
what this mean and what should I do?
You are probobly sending a query to the DB thats generates a raply, like
select for example.
What you need to do is to cath the reply with
Hello,
First of all, i'm proud to announce the first Port of MySql to
AmigaOs... you know this old gaming computer based on 68000 motorola
chip... you don't know it ??
never mind ..
I had several probleme when compiling. First of all, configure could
not find PS file for Pid, I simply disabled
Hi All,
Our MySQL database server is in a Linux box. But my users in our LAN are using
windows. I am planning to write a client program for my window users that will
interact with my database server in Lunix for daily database tasks. Our daily
database tasks include search for a record,
"t" == topmailbox tmb writes:
t How does PostreSQL compair to MySQL ?
Did you read what it has to say about this in the manual?
t I'm sure each has it's own advantages disadvantages.
Yes.
t What are some of the major ones?
Depends on what your needs are. One person's advantage is
http://www.mysql.com/support/arrangements/policy.html
Cal
http://www.calevans.com
-Original Message-
From: Ing. Gabriel Ayala [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 23, 2001 9:00 AM
To: [EMAIL PROTECTED]
Subject: License Information !!!
Hi, I would like to know what is the
Hello,
I did something dumb: ran myisamchk while mysqld was up and running and, being
on a linux system, I run the deamon with --skip-locking. This is what I guess made one
of my tables appear to be empty. According to the manual if you run myisamchk while
someone else is doing an
Well make sure you have gcc 2.95.2 and a recent version of make (the manual
suggests a version). Also, when I said "Lib paths" I meant look at the -I
options for your configs. But rereading your info, it looks like a problem
with the actual object file (or lack of one).
I hate to say this but
Sinisa Milivojevic explained me that :
"Unfortunately you can not build static programs on Solaris, as Sun has
not provided static versions for many of it's libraries."
Regards,
--
Pascal Thivent
-Message d'origine-
De: Johan Andersson [mailto:[EMAIL PROTECTED]]
Date: vendredi 23
Hello,
when I install the MySQL RPM package (the newest on you site) as root, I am
able to connect to the server through mysql.sock... but when I reboot the
system the mysql.sock seems to be gone, and therefor I can not connect to
the server. Do you have reports on that? This happens with SuSE
I'm running into the same exact problem. Apache will not start until
Mysql has been started (even if mysql is stopped prior to starting httpd),
and gives that same message. If you start mysql first it should run fine.
Being relatively new to this type of thing I'm making some blind stabs,
but
Also with regard to the lost 32 recs, the error log mentioned:
010323 5:41:50 read_const: Got error 127 when reading table ./eval/reviewer
Where perror gives:
127 = Record-file is crashed
And Mysql version: 3.23.30-gamma-log
regards,
thalis
Hello,
when I install the MySQL RPM package (the newest on you site) as root, I am
able to connect to the server through mysql.sock... but when I logout as
root and login again, the mysql.sock seems to be gone, and therefor I can
not connect to the server. Do you have reports on that? This
1:
print 'a
href="mailto:'.$row["email_player"].'"'$row["email_player"].'/a';
2:
$row is the name of the array you have defined to hold the current row form
the resultset your created with the SELECT statement. each time you do $row
= mysql_fetch_array($result) it takes the next row from $result
Sinisa,
SM No, nothing, No need to test further.
SM Try those Solaris patches, re-install gcc and build from the fresh
SM tarball without debug and with all the options like the last time.
Fresh tarball.
Latest Solaris 2.8 patch applied !
But :
010323 17:38:04 mysqld started
I am not sure if i should post it here but please do help my if you can.
Probably one of the PHP lists would be a better place ;-)
Check out http://www.php.net/support.php for a full run-down.
The script is as follows:
snip
I basically have two questions.
If i want to make a "mailto"
I am installing Msql-Mysql-modules-1.2215 on Solaris 2.7. After running make,
error returns,
dbdimp.c:116: `SQL_TIMESTAMP' undeclared here (not in a function)
dbdimp.c:116: initializer element is not constant
dbdimp.c:116: (near initialization for `SQL_GET_TYPE_INFO_values[7].data_type')
On Fri, 23 Mar 2001, Johan Vikerskog (ECS) wrote:
I am not sure if i should post it here but please do help my if you can.
The script is as follows:
html
body
?php
mysql_connect (localhost, username,
Hello
I tried upgrading from MySQL-3.21.33 to 3.23.35 on an old linux host. It
worked but the new mysql version was *horrible* slow. E.g. under exactly
same situations I came to ca. 300 inserts/second with the old and 20 with
the new version making it absolutely unusable :-(
The only
On Fri, 23 Mar 2001, Markus Siagian wrote:
Hi,
I'm still a newbie in mysql and also sql statements.
I
was wondering if some one can help me with this
problem.
I'm trying to select 5 of the highest values from a
table. But i can't seem to find any help from the
manual and also
Hi,
Anyone got a small script to store a file in a BLOB.
Nothing fancy, just so that I dont need to think that much today.
/roger
Hi again,
Ehh the script in my prev mesg,
language: C
Forgot that.
Files that will be stored is: gifs jpegs html pages etc.
/roger
I am trying to install mysql-3.23.32-bsdi4.2 . My system is bsdi/os 4.0.
When i try to run the script/mysql_install_db i received the error "can't load library
libz.so". Then, i tried to use ./configure --disabled-shared, but i still have the
same problem.
Please could you let me know what i am
tmb wrote:
How does PostreSQL compair to MySQL ?
I'm sure each has it's own advantages disadvantages.
What are some of the major ones?
Both are very good databases with free type licenses. There are
advantages. dot.
--
MySQL Development Team
__ ___ ___ __
/ |/ /_
Dear Sir,
I am looking for documentation for installation of Win32 static binary of
MySQLGUI 1.7.4-2. Thank you PM
---
Pat
Gerald Clark wrote:
Voytek Lapinski wrote:
[...]
I have been following the SIG 11 threads that have appeared lately.
It seems to me all reporters have been running SMP kernels.
What happens if you bring the machine up single CPU?
I am still getting occasional signal 11 crashes
Since you updated both mysql and php you presumably should recompile apache as
well. A quickdirty solution though could be to just create a link:
libmysqlclient.so.6.0-libmysqlclient.so.10.0 and see what happens from there :-)
regards,
thalis
On Fri, 23 Mar 2001, Colonel
Colonel Panic wrote:
Hi
I've installed MySQL (mysql-3.23.33-pth) and PHP (php4-4.0.3pl1-mysql) from OpenBSD
ports...
... but this has broken apache. Restarts/configtests now trigger:-
/usr/libexec/ld.so: httpd: libmysqlclient.so.6.0: No such file or directory
I've added
hey,
i've been observing a similar kind of a problem
with mysql 3.23.32 on a Linux 2.4.2 kernel. The
backtrace that i'm getting is different, but even that
fails a sanity check. When i resolved the incomplete
backtrace, it showed me thread creation functions and
something of that sort. The
Hi,
I`m having trouble backing up MySQL on my Cobalt RAQ4r server, I have tried
all the methods I can find in the manual but all it ever seems to do is print
out some instructions which leads me to beleive I`m doing something wrong,
can anyone help?
I basically want to backup all of my
- Original Message -
I'm running into the same exact problem. Apache will not start until
Mysql has been started (even if mysql is stopped prior to starting httpd),
and gives that same message. If you start mysql first it should run fine.
In my case I hit the same error if msqld is
Thalis A. Kalfigopoulos [EMAIL PROTECTED] wrote:
Since you updated both mysql and php you presumably
should recompile apache as well. A quickdirty solution
though could be to just create a link: libmysqlclient.so.6.0-
libmysqlclient.so.10.0 and see what happens from there :-)
Nope,
*This message was transferred with a trial version of CommuniGate(tm) Pro*
Hi,
I would need some reasons for choosing MySQL instead of Microsoft SQL.
(beside the fact that MySQL is free). (not for me but for my boss).
It may sound silly but trust me I really need these reasons. So please help
We have a table where we register the data of all the modem connections
of the users of a small ISP.
The table contains 2 million records and has the following structure:
+-+--+--+-+-+---+
| Field | Type | Null | Key | Default |
All you need is a single SQL function - have a look in the docs.
On Fri, 23
Mar 2001, roger westin wrote:
Hi,
Anyone got a small script to store a file in a BLOB.
Nothing fancy, just so that I dont need to think that much today.
/roger
On Fri, Mar 23, 2001 at 11:05:09AM -0800, Mike Roberts wrote:
My name is Mike Roberts, I have been working with php and MySQL
since the end of December. I think I am doing pretty good. But what
I really want is for you people out there to send me to a website
that you have built. I'm
On Fri, Mar 23, 2001 at 01:09:47PM -0500, Ciprian I. Acatrinei wrote:
*This message was transferred with a trial version of CommuniGate(tm) Pro*
Hi,
I would need some reasons for choosing MySQL instead of Microsoft
SQL. (beside the fact that MySQL is free). (not for me but for my
boss).
Is there something that you can do with MS SQL and you can not do with MySQL?
At 04:01 PM 3/23/2001, Jeremy D . Zawodny wrote:
*This message was transferred with a trial version of CommuniGate(tm) Pro*
On Fri, Mar 23, 2001 at 01:09:47PM -0500, Ciprian I. Acatrinei wrote:
*This message was
On Wed, Mar 21, 2001 at 10:01:23PM +0100, Ren Tegel wrote:
the email list seems to be very slow now and them... wouldn't it be
an option to make a web-based list ?
In addition to the e-mail version, or instead of it?
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Can anyone tell me how to fix this error:
ERROR 1016: Can't open file: 'message.MYD'. (errno: 126)
Please help!!!
- Dan Adams
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
platform independency, reasonable portability, performance(!), optimal
load/performance ratio, loads of access methods including odbc and web based
scripts like php,asp, active development, integration with apache
authentication, very very good personal online help (this mailing list :),
low
Hi!
It is from the bug in MySQL++.
I am sending you a patch in direct mail.
Regards,
Sinisa
Thanks for the patch. It solved the core dump, but now mysql_real_connect()
is failing rather than core dumping.
connection.cc then throws an exception, but the exception catching code in
When was the last time you got to ask a question directly to one of the
developers of MS SQL?
When was the last time you found a bug in MS SQL and one of the developers
told you it would be fixed tonight and to go grab the source tomorrow and
recompile?
When was the last time you could buy
Can someone please tell me what the problem is below. All I am trying to
do is pipe a backup created with mysqldump into mysql and it gives me
this error:
ERROR 1071 at line 1291: Specified key was too long. Max key length is
500
Here is the query where the error is:
CREATE TABLE list (
I apologize because I know I've seen this somewhere on the list before
(should have saved it). I'm trying to insert some data into CHAR fields
that have trailing Ascii 0 characters, but get a syntax error.
The data would like this:
23302220202X
Where "X" represents
Peter,
satire
I would love to see this list split into 2 lists. MySQL-Newbies and
MySQL-non-newbies. Non-newbies would be either an invitation-only list or
you have to pass a test to get in. (The test would contain questions that
are all in the manual, we don't care if you know, we care if you
Start with the speed
checkout: http://www.mysql.com/information/benchmarks.html
there you'l find som arguments...
/roger
*This message was transferred with a trial version of CommuniGate(tm) Pro*
Hi,
I would need some reasons for choosing MySQL instead of Microsoft SQL.
(beside the
Hi there
I'm sure that the solution to my problem will be easy but can you help. The
following is a copy of my dos window having tried all of the ways to get
mysqld to start running in the background. What am I doing wrong. I am using
windows ME. Could this be the problem?
Bad command or file
A whole TODO list of things. One should really evaluate the pros and
cons of both databases to make an educated decision on which system
would better suit ones needs.
"Ciprian I. Acatrinei" wrote:
Is there something that you can do with MS SQL and you can not do with MySQL?
At 04:01 PM
On Fri, Mar 23, 2001 at 09:16:48PM +, Daniel Adams wrote:
Can anyone tell me how to fix this error:
ERROR 1016: Can't open file: 'message.MYD'. (errno: 126)
Fix the file permissions so that mysql can read the file.
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
For what it's worth, here's my $0.02...
-- Is there something that you can do with MS SQL and you can not do with
MySQL?
MSSQL - has support for triggers, stored procedures, views, XML, and
transactions. I would
mention subqueries, but subqueries are on the way with mySQL.
MySQL -
"Ciprian A." wrote:
I would need some reasons for choosing MySQL instead of Microsoft SQL.
(beside the fact that MySQL is free). (not for me but for my boss).
It may sound silly but trust me I really need these reasons. So please help
me with this.
The biggest reason to avoid Microsoft
I'm going to try an Un-Install, then Re-Install Mysql.
How do I Un-Install??
Thanks,
Chris B
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
On Fri, 23 Mar 2001, Daniel Adams wrote:
Can someone please tell me what the problem is below. All I am trying to
do is pipe a backup created with mysqldump into mysql and it gives me
this error:
ERROR 1071 at line 1291: Specified key was too long. Max key length is
500
It is excactly
At 5:30 PM -0500 3/23/01, Lee Jenkins wrote:
I apologize because I know I've seen this somewhere on the list before
(should have saved it). I'm trying to insert some data into CHAR fields
that have trailing Ascii 0 characters, but get a syntax error.
The data would like this:
Hi, I've just installed Apache, MySQL and PHP on RedHat 7.0 and I can't connect to
MySQL through PHP. I get an error saying that it can't connect to MySQL using socket
/var/lib/mysql/mysql.sock. When I connect to the MySQL server through the mysql client
program, I can see that that is the
Yeah, I tried running myisamchk on it but it said it couldn't open the
file. I'm going to try to restore the database from backup and update
logs.
Original Message
On 3/23/01, 7:04:51 PM, "Thalis A. Kalfigopoulos" [EMAIL PROTECTED]
wrote regarding Re: HELP!!!:
Guessing:
the error
At 22:32 2001-03-23, G r e g L a w r i e wrote:
Hmmm, I am not sure whether there are issues with this particular version of
MySQL or not, but I would start looking at NT and the various bits and
pieces that it installs for memory leaks rather than MySQL.
I have an NT server (same versions as
Hi, I have a newbie question. Is "autocommit == innobase_flush_log_at_trx_commit" ?
Thanks.
Ryu
Hi,
On Fri, Mar 23, 2001 at 07:46:48PM +0100, Federico Giannici wrote:
We have a table where we register the data of all the modem connections
of the users of a small ISP.
The table contains 2 million records and has the following structure:
...
What indexes does the table have? Looking
Hi, I have a newbie question. Is "autocommit == innobase_flush_log_at_trx_commit" ?
Thanks.
Ryu
87 matches
Mail list logo