On Monday 07 October 2002 11:32, Robert H.R. Restad wrote:
Thanks for doing the test :)
Don't forget that MySQL is the fastest thing on the planet for your (and mine)
kind of simple query and insert/updates. We measured 12 times faster
performance in MySQL than Oracle in one part of our
win2k sometime can't know what is localhost,you can use 127.0.0.0 instead of
localhost,I think it should be worked.
=== 2002-09-25 17:05:00 ===
i've installed ver 3.23.47 sa win2k pero di ko sya
mstart as service..
if i type this==mysqladmin create database01
On Monday 07 October 2002 12:04, Edwin Raj wrote:
When I type mysql in the command prompt it is giving the error ERROR
2002: Can't connect to local MySql server through socket
'/var/lib/mysql/mysql.sock' (111)
There is no file mysql.sock at that location???
Exactly.
What is the problem amd
One other thing..
If something goes wrong or some costumers complain about being charged
without their request etc. the credit card companies can come after you. And
if they are able to prove that you have not done everything you should to
keep the CC information secure and that your routines
there is an error in your sql statement :
your origin sql is:SELECT COUNT (*) FROM test;
you should delete the space between 'count' and '(*)'.
the correct sql is :SELECT COUNT(*) FROM test;
=== £º===
Hello All,
I seem to be running into a very strange problem.
In the
On Monday 07 October 2002 12:04, Edwin Raj wrote:
When I type mysql in the command prompt it is giving the error ERROR
2002: Can't connect to local MySql server through socket
'/var/lib/mysql/mysql.sock' (111)
There is no file mysql.sock at that location???
Exactly.
What is the
Don't forget that MySQL is the fastest thing on the planet for your (and mine)
kind of simple query and insert/updates. We measured 12 times faster
performance in MySQL than Oracle in one part of our application, and I
strongly believe that in the MySQL case the Java program overhead became
Dear Ladies and Gentleman,
we are very interested in using MySQL with our machines, but we need a full
Unicode-support with the database.
Can you give us information's about the time, when MySQL will com with a
full Unicode Support?
Mit freundlichen Grüßen / Gest Regards
Manfred Schmid
According to the website, it'll be in version 4.1.
You can already use Unicode now, though, you just can't sort on it or
stuff like that...
Dean Harding.
-Original Message-
From: Schmid Manfred [mailto:[EMAIL PROTECTED]]
Sent: Monday, 7 October 2002 5:24 pm
To: [EMAIL PROTECTED]
On Monday 07 October 2002 15:53, David Lloyd wrote:
Please let me know the name of a book(s) that teaches how these complex
select statements work.
How about the MySQL reference manual???
Keep on listening to the statements made here, especially the ones you
don't understand. And try
I'm working on an application that uses the MySQL full-text search to search
for words in pre-existing content. This content can and does contain HTML
entities like ouml;.
At least in my setup, if I place words like mouml;gliche in an AGAINST()
clause, incorrect results are returned. For
Dear all,
I am not sure why mysql thinks char(192) = char(194) = char(193) =
char(195)?
mysql select char(192)=char(193);
+-+
| char(192)=char(193) |
+-+
| 1 |
+-+
1 row in set (0.00 sec)
mysql select
Hello everybody,
I have a next problem to get a query working.
I have some tables. A User has Phone numbers and Calls associated with
each phone.
# Example: All the calls of the user number 1
SELECT
Call.*
FROM
User, Phone, Call
WHERE
Phone.User=1 AND
Am Montag, 7. Oktober 2002 13:07 schrieben Sie:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query
If you just reply to this message, and include
Ed Carp wrote:
On Monday 07 October 2002 12:04, Edwin Raj wrote:
When I type mysql in the command prompt it is giving the error ERROR
2002: Can't connect to local MySql server through socket
'/var/lib/mysql/mysql.sock' (111)
There is no file mysql.sock at that location???
Exactly.
What is the
Hi!
I'm trying to install MySQL as it's needed for a guestbook (PHP+MySQL) but I
just can't get it to work. I've downloaded both 3.23 and 4.0 and used the
installed, then installed them as services.
Whenever I try to start the service I get a 1067 error and it terminates,
seem to be no way I
Well, it depends on what exactly you mean by 'checking' Bfn1, Bfn2
and Bfn3, but you should be able to do something like this (assuming
for this example that you want only want to return results where
Bfn1/Bfn2/Bfn3 is equal to 99):
select *
from table_a as A, table_b as B
where
Hi,
My opinion:
You must be sure that my.cnf is on c:\ or if you use my.ini configuration
files, that file is on c:\windows
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
html
head
titleÖйúÕÐÉÌÒý×ÊÍøΪÄúÀ©´óÕÐÉÌ£¡/title
meta http-equiv=Content-Type content=text/html; charset=gb2312
style type=text/css
!--
.dahei { font-size: 16px; font-weight: bold; color: #FF; text-decoration: none;
line-height: 22px}
.hei { font-size: 12px; line-height: 20px;
Hello,
May name is Andrej and I'm from Slovenia. I downloaded and tried mysqlGui
program. I have one question. Tell me please how to create a new table in this
program. I select Create table in menu, but the program do nothing. Maybe I do
something wrong.
Thank you in advance,
Andrej
Hi,
Any anyone have recommendations on MySql books currently in print. What's the best or
is the online manual all that's needed !
Thomas
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
For now, Joe Celko, SQL for Smarties.
But stay tuned :-).
-
- Original Message -
From: Curley, Thomas [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, October 07, 2002 5:28 AM
Subject: Recommended Books
Hi,
Any anyone have recommendations on MySql books currently in print.
hi!
i am a trainee at westlb-systems in duesseldorf, germany and it's my task
to evaluate different dbms' like Postgre SQL, MySQL, MS Access ´97 ;), SAP
DB and Oracle
well i searched the web and various documentations but i'm not really sure
if all of this is still correct or if i may have
what is the major secure mode to use innodb ? ( min time to write data
in disk )
innodb_flush_log_at_trx_commit=0 ?
or
innodb_flush_log_at_trx_commit=1 ?
or
innodb_flush_log_at_trx_commit=2 ?
My System is MySQL/InnoDB 3.23.52 running in windows 2000 Server and
linux 2.4 ( with ReiserFS ) :D
I need use MySql to Linux ( Connectiva 7 )and Kylux.
What version of the MySQL?
Do I need MyODBC?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
This occured while using phpmyadmin 2.3.0-rc4:
You seem to have found a bug in the SQL parser.
Please submit a bug report with the data chunk below:
--BEGIN CUT--
JElkOiBzcWxwYXJzZXIubGliLnBocCx2IDEuMTUgMjAwMi8wNy8yNiAxODozMDo1OSBsZW05
IEV4
I am writing a serverside application in Java which needs to query/search
200 000 rows and update affected records once every 2 minutes.
As performance/speed is of importance here - and this Table only contains
5-10 Columns of Integer numbers, I figured that using a HEAP type of table
How do I initially connect to mysql on linux. I've successfully installed
from the rpm and the daemon is up and running. If I try to connect to root
without a password, I get the following message:
error: 'Access denied for user: root@localhost (Using password: NO)'
Is there a password for
Hack Hawk wrote:
This implies hard-coding a private key and password somewhere on your
system. This type of system (IMO) should NEVER be connected to the
Internet.
Agreed and doubly agreed. In fact, I'd say you should never save a CC #
in your database _ever_ unless you're doing
Quasimodo wrote:
This occured while using phpmyadmin 2.3.0-rc4:
You seem to have found a bug in the SQL parser.
Please submit a bug report with the data chunk below:
--BEGIN CUT--
JElkOiBzcWxwYXJzZXIubGliLnBocCx2IDEuMTUgMjAwMi8wNy8yNiAxODozMDo1OSBsZW05
[snip]
This is reporting a bug in
Actually, I'd suggest the New Riders Book by Paul DuBois, Mysql...what
was it you wanted to achieve with your book:
* do you want a reference
* a tutorial
...?
mysql,query
DSL
-
Before posting, please check:
Howdy,
There has been some interest lately in HA of MySQL services both in my
company and on the list. A few of us here sat down on Friday (at 5PM no
less) and started hashing out the details of providing such a service.
Following several possible approaches, we ran into major stumbling
blocks
The file must reside on the SERVER in a directory accessible to the
user 'mysql'.
Oswaldo Castro wrote:
Hi List,
I am new to mysql so I ask for your patience...
1 - I am trying to load a text file (with mysql-front) to a table that
contains a TEXTdata type field. Despite of the documentation
Nevermind. I just had to use root's OS password.
-Original Message-
From: Cohan, Sean [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 10:14 AM
To: MySql (E-mail)
Subject: Initial Connection
How do I initially connect to mysql on linux. I've successfully installed
from the
Check youry my.cnf file.
You have the temp directory set to /root/tmp instead of /tmp.
If this is not the case, add an entry to redefine the temp directory.
Bob Nelson wrote:
I'm encountering a situation with MySQL that's really driving me crazy and I
have been unable to locate a solution.
You almost got it. Your syntax will be something like this:
UPDATE Table SET address=REPLACE(address,'#','Number') WHERE column
like%#%
When I am trying to figure out the syntax for something, I always add a
LIMIT 1 at the end so that only one record gets changed.
On Saturday, October 5,
I'm working on an application that uses the MySQL full-text search to search
for words in pre-existing content. This content can and does contain HTML
entities like ouml;.
At least in my setup, if I place words like mouml;gliche in an AGAINST()
clause, incorrect results are returned. For
Hi,
I was just wondering. Is it a common issue to have problems with INSERTS or
UPDATES that have not been commited stick(not commit ) even though the
connection gets killed? The thing is autocommit is on. But I still am
getting this kind of behavior from scripts that are not persistent.
I
You don't give operating system versions for the two machines.
James Riordon wrote:
Hi,
I have two servers.
Server A:
Dual 1GHz processors
1GB of RAM
MySQL-Max 3.23.49a
PHP 4.2.1
Server B:
Single 1.7GHz processors
1.5GB of
Fabiana,
Monday, October 07, 2002, 1:51:06 AM, you wrote:
FMPdA I'm trying to insert some data into a MySQL table and I'm just not getting
FMPdA it to work. It's not a problem with the connection with the database because
FMPdA I get to SELECT and show the data, but when I try to INSERT or
Kip,
Monday, October 07, 2002, 4:03:05 AM, you wrote:
KK Is it possible to do a show tables similar to a select statement
KK where ...
KK similar to: select field where anotherfield like ABC% gives matches
KK for all field which begins with ABC
KK I'd like to say
KK show tables like ABC%
KK
Andrej,
Monday, October 07, 2002, 2:51:29 PM, you wrote:
AF May name is Andrej and I'm from Slovenia. I downloaded and tried mysqlGui
AF program. I have one question. Tell me please how to create a new table in this
AF program. I select Create table in menu, but the program do nothing. Maybe I
Cohan,
Monday, October 07, 2002, 5:13:39 PM, you wrote:
CS How do I initially connect to mysql on linux. I've successfully installed
CS from the rpm and the daemon is up and running. If I try to connect to root
CS without a password, I get the following message:
CS error: 'Access denied for
junhuazhu,
Monday, October 07, 2002, 4:54:35 AM, you wrote:
ja3dn After I used the comment mysqld,I used the mysqladmin ping comment,then the
following infomations appeard(c:\mysql):
ja3dn mysqladmin: connect to server at 'localhost' failed
ja3dn error: 'Can't connect to MySQL server on
Edwin,
Monday, October 07, 2002, 1:09:37 PM, you wrote:
On Monday 07 October 2002 12:04, Edwin Raj wrote:
When I type mysql in the command prompt it is giving the error ERROR
2002: Can't connect to local MySql server through socket
'/var/lib/mysql/mysql.sock' (111)
There is no file mysql.sock
Schmid,
Monday, October 07, 2002, 10:23:52 AM, you wrote:
SM we are very interested in using MySQL with our machines, but we need a full
SM Unicode-support with the database.
SM Can you give us information's about the time, when MySQL will com with a
SM full Unicode Support?
Unicode support
Kip,
Sunday, October 06, 2002, 11:20:25 PM, you wrote:
KK Mysql - how many tables will it handle?
KK I currently have no access to docs, so forgive me as I'm sure it is
KK documented.
The only limitation is how many files can be stored in the directory.
--
For technical support contracts,
Sorin,
Saturday, October 05, 2002, 8:33:23 AM, you wrote:
SC 1)Is it possible to enable LOAD DATA LOCAL INFILE from the configuration
SC file?
SC My.ini file is below:
SC [mysqld]
SC basedir=C:/mysql
SC datadir=C:/mysql/data
SC enable-local-infile
SC local_infile=1
SC When I perform the LOAD
Dimo,
Friday, October 04, 2002, 6:26:16 PM, you wrote:
Description:
DV I have a table with columns containing
DV keywords in cyrillic. If I write i.e.
DV select * from imgs where kw_1 like '%xx%'
DV (xx are two cyrillic letters and kw_1 is the first
DV keyword-column. The table contains
Scott,
Saturday, October 05, 2002, 7:45:16 AM, you wrote:
SJ I have a db with slightly over 614,000 records of names and addresses. In
SJ the address column, there are quite a few records like
SJ 123 any rd # 2
SJ 319 w. 1st st # B
SJ 4321 test blvd # 42
SJ etc
SJ I want to replace all the
Marc,
Saturday, October 05, 2002, 9:59:57 PM, you wrote:
It seems that ORDER BY interferes with DISTINCT when
I
use the 2 in the same statement. When I append order
by to the end of a MySQL statement, I get all the
matches instead of the distinct ones. Is this normal
behavior?
Could you
Hello,
i have a problem with the mysql database. mysql seems not able
to created ne threads sometimes. the system is running several deamons,
like a webserver and a ftpserver. RAM was short so i added more. now there
are 2 GB RAM available. first, here is the error message:
Can't create a new
Hello everyone,
Can someone please tell me how I can do the following:
From the query below, I want to get the details of the header of the message
and display them on a page, one per line.
If I just query the Header field, it displays them in one long line.
What can I do to display the them one
I thought I'd cross post this thread here. Maybe someone with MySQL API
experience can assist.
Is there a way to reset a connection? That is, send one command that can
keep a connection open, but reset all the variables and rollback
unfinished transactions? I don't use transactions, but I can
sql,query
Hi,
I am trying to run this update statement, but I got an error syntax...near
offsetCould You please point out what is wrong?
Update TIMEZONE_INFO set ABBREVIATION = 'GMT' || to_char(OFFSET) where
ABBREVIATION is null;
Thank You,
Best Regards,
Madalin.
Greetings,
We're experiencing some severe problems with MySQL and I'm at a loss as
to what to look at ... It seems we've encountered some sort of a loop
but I'm not sure what's causing it. The system will run fine for a
while and then begin using 100% cpu on both processors in the
Matthew,
Wednesday, October 02, 2002, 5:29:38 PM, you wrote:
MJF My company runs a moderately large and loaded MySQL replication network
MJF across four Solaris machines. While upgrading from a fairly old 3.23.4x
MJF installation to 3.23.52 we've encountered a problem with replication and
MJF
On Mon, 2002-10-07 at 10:30, Jeremy Tinley wrote:
Howdy,
There has been some interest lately in HA of MySQL services both in my
company and on the list. A few of us here sat down on Friday (at 5PM no
less) and started hashing out the details of providing such a service.
Following several
Hello Heikki !
what is the best secure mode to use innodb ? ( min time to write data
in disk )
innodb_flush_log_at_trx_commit=0 ?
or
innodb_flush_log_at_trx_commit=1 ?
or
innodb_flush_log_at_trx_commit=2 ?
My System is MySQL/InnoDB 3.23.52 running in windows 2000 Server and
linux 2.4 (
We am having a problem with the encode() and decode() functions. When
the second argument to the functions is a quoted string, the functions
return values as expected. When the second argument to the functions is
another function call, i.e. the char() function, encode() and decode()
return SQL
Hello,
When I do ps aux, mysql shows a lot of child processes. Why doesn't it close
them down? The load is low, at 12.00 I performed some heavy stuff, but
that's almost 6 hours ago for me.
Can anyone tell me?
mysql24020 0.0 11.8 78972 61368 ? SOct04 0:28
On Sun, 6 Oct 2002, David Gerler wrote:
Date: Sun, 6 Oct 2002 14:21:11 -0400
From: David Gerler [EMAIL PROTECTED]
To: Mysql [EMAIL PROTECTED]
Subject: protecting CC numbers
Hi,
I am working on an application that will need to store users CC
numbers so that they can be charge once
Hello,
I am working on a J2EE app and I really would love to take
advantage of jdbc 2.0's RowSet functionality.
Is Connector J (2 or 3) compliant
with this part of the standard?
Thank You
sql,query
--
Vincent Stoessel
Linux Systems Developer
vincent xaymaca.com
Michael,
Thanks for the input. Feel confident that you are in good company
with your recommendations. After many replies to my original post and
some discussion, I have decided that I will encrypt the card numbers
using command line PGP before sending the using sendmail to myself.
Only a
I have a table with two column; the first column contain unix timestamp(of
type double ) which is the primary key. I would like to round the time.
could I do :
mysql insert into mytbl(time) values(round(time));
should this work?
Thanks
Nissim
On Mon, Oct 07, 2002 at 01:53:25PM -0300, Dyego Souza do Carmo wrote:
Hello Heikki !
what is the best secure mode to use innodb ? ( min time to write data
in disk )
You're confusing two ideas. The most secure (reliable) is 1. The
fastest is 0. You can't have both.
Jeremy
--
Jeremy D.
I seem to have run into a rather peculiar problem. I was attempting to load
data into a table from a file. I checked with the online documentation and
found the following syntax:
LOAD DATA LOCAL INFILE pet.txt INTO TABLE pet;
I used this format exactly (with my own file and table names of
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query
If you just reply to this message, and include the entire text of it in the
reply, your reply will go
I have found to do a LOAD DATA LOCAL INFILE is no longer possible
using perl-DBI, even though local-infile=1 is in the [mysql], [mysqld],
and [client] sections of my.cnf.
I am not sure what prompted the engineering powers-that-be to
change the default for this version, 3.23.49, of mysql, but it
Greetings,
I have an application that creates an SQL file from the data it
produces, but in some of that data, there might be a , or ' which
mysqlimport does not like. I need to use the mysqlimport utility, and I am
wondering if there is a way around this. I admit I have not tried yet,
Vincent Stoessel wrote:
Hello,
I am working on a J2EE app and I really would love to take
advantage of jdbc 2.0's RowSet functionality.
Is Connector J (2 or 3) compliant
with this part of the standard?
No. There hasn't been a large demand for support of that API, and it's
not required to
Hi!
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Dyego Souza do Carmo [EMAIL PROTECTED]
Cc: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, October 07, 2002 10:10 PM
Subject: Re: The secure mode in InnoDB
On Mon, Oct 07, 2002 at 01:53:25PM -0300,
Yeah, I was thinking about doing the scrolling results thing
using a pure java solution. I will look into the CachedRowset
from Sun, thanks for that info. I still believe the mysql driver
is cool. What's up with the docs, though?
Mark Matthews wrote:
Vincent Stoessel wrote:
Hello,
I am
The problem isn't so much with the failover. It's with data integrity.
Binlogs control replication. You can place a failover master in between
the master and slaves. In the event of a master failure, you eliminate
the loss of writes by directing them to the failover. If you lose your
People,
I have a linux web server running apache 1.3.26 and php(IP= 10.1.1.3)
I have a W2K Database server running MySQL 3.23.52(IP= 10.1.1.2)
My connecting string is
mysql_connect(10.1.1.2:3306, $dbuser, $db_pwd);
And I ge the error:
Warning: Can't connect to MySQL server on
Vincent Stoessel wrote:
Yeah, I was thinking about doing the scrolling results thing
using a pure java solution. I will look into the CachedRowset
from Sun, thanks for that info. I still believe the mysql driver
is cool. What's up with the docs, though?
JDBC-2.0 result sets are fully scrollable
People,
I have a linux web server running apache 1.3.26 and php(IP= 10.1.1.3)
I have a W2K Database server running MySQL 3.23.52(IP= 10.1.1.2)
My connecting string is
mysql_connect(10.1.1.2:3306, $dbuser, $db_pwd);
And I ge the error:
Warning: Can't connect to MySQL server on '10.1.1.3'
I messed up in the ip addressing sorry!
--
People,
I have a linux web server running apache 1.3.26 and php(IP= 10.1.1.3)
I have a W2K Database server running MySQL 3.23.52(IP= 10.1.1.2)
My connecting string is
mysql_connect(10.1.1.2:3306, $dbuser, $db_pwd);
And I ge the error:
OK now I am getting this error:
Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in
/usr/local/httpd/htdocs/mbn.com/confirmation.php on line 36
Warning: MySQL Connection Failed: Access denied for user: '[EMAIL PROTECTED]'
(Using password: YES) in
I have a small PHP website that gets a fair amount of traffic. It's a
simple layout with two tables. I average about 50 concurrently open
apache sessions and 40 open mysql connections. I am calling for
persistent connections from the mySQL/PHP API.
But here is the kicker. Each mySQL thread
(Perl Script mysqlbug not used as Perl is not installed)
SUBJECT:Table locking under ISAM can fail
ORGANIZATION: Owens Services B.O.P. Ltd, New Zealand
LICENCE:None (expired support license)
SYNOPSIS: User can cause table locking to fail by USE'ing the same database
but
Hi everybody...
Does anybody knoy what is equivalent stmt in MySQL? select * from table1
where col1 in (select col1 from table2)
thanks in advance.
David.
-
Before posting, please check:
http://www.mysql.com/manual.php
Hm... No offense, but I believe the [EMAIL PROTECTED] just spammed
itself... As it clearly says 'if you just reply to this message, and include
the entire text...'
I also believe JK did just as instructed by the list itself, which resulted
in spam... or what :)
Hmz
Cheers
Rob.
-Mensagem
I have been trying to install the
mysql-3.23.52-pc-linux-gnu-i686.tar.gz on my SUSE Linux 7.3 machine.
Everything seems to be going smoothly until I entered the command
./scripts/mysql_install_db
I got this output which i believe is ok;
cords-orj86jfje:/usr/local/mysql/mysql #
Hi,
I am connecting to MySql 3.23(innodb) with mysql-connector-java-2.0.14-bin.jar. I set
the global transaction isolation level to READ COMMITTED. However, I still couldn't
see the committed changes through JDBC client. Does anyone know about this issue?
Thanks,
Jianliang
On Mon, Oct 07, 2002 at 05:30:57PM -0700, Jianliang Zhao wrote:
Hi,
I am connecting to MySql 3.23(innodb) with
mysql-connector-java-2.0.14-bin.jar. I set the global transaction
isolation level to READ COMMITTED. However, I still couldn't see the
committed changes through JDBC client. Does
Hi,
Like a number of other people on the list, I've been having considerable
difficulty getting MySQL (i've tried both 3.23.51 and 3.23.52) to work on
RH8.0
Initially, I ran ./configure with --localstatedir=/server/local/mysql
(among a number of other directives - note that I install the
Thanks Jeremy. It turns out the JDBC SQL query tool(ViennaSQL) I am trying is causing
the problem. I couldn't reproduce the problem by writing a test case.
Thanks,
Jianliang
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: 2002?10?7? 17:36
To: Jianliang Zhao
Hi again,
Just did a stack trace, as the error log advised, and can't make heads or
tails of it.
The error was brought about by me typing mysql -u root -p mysql at the
command line, and hitting enter (and entering root's password):
0x808476a _Z15handle_segfaulti + 398
0x813152c
Hi,
When i try to query ... load data infile ...
i am getting the following error ...
ERROR 13: Can't get stat of 'upload_fct_HQ_CA001S.txt' (Errcode: 2)
The above mentioned same query i have used in many other modules, but i
never get the error. The file from which i am trying to load the
Jianliang Zhao wrote:
Thanks Jeremy. It turns out the JDBC SQL query tool(ViennaSQL) I am trying is causing
the problem. I couldn't reproduce the problem by writing a test case.
Thanks,
Jianliang
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: 2002?10?7?
In the last episode (Oct 07), Jon Shoberg said:
I have a small PHP website that gets a fair amount of traffic. It's
a simple layout with two tables. I average about 50 concurrently open
apache sessions and 40 open mysql connections. I am calling for
persistent connections from the mySQL/PHP
Ok,
So how do I optimize memory usage? Where to start ?
-Jon
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 9:16 PM
To: Jon Shoberg
Cc: [EMAIL PROTECTED]
Subject: Re: .Optimize mySQL memory usage ? 41MB threads ??
In the last
On Mon, 2002-10-07 at 19:18, Daniel Miller wrote:
I have been trying to install the
mysql-3.23.52-pc-linux-gnu-i686.tar.gz on my SUSE Linux 7.3 machine.
Everything seems to be going smoothly until I entered the command
./scripts/mysql_install_db
I got this output which i believe is
Hi,
I am running MySQL 3.23 on Redhat 8.0. I can connect to MySQL from the local
machine without any problem and I created a user with remote login
privileges. Trying to connect to it from another machine (on the same
network as well as the same subnet) gives ERROR: 10061 Connection to mysql
Dear Sir or Madam:
I have installed MySQL database to Sun Enterperise 250 with Solaris 8
OS.
I can run database server and query but I can't create database.
Please tell me know how can I correct it ?
Thank in advance.
Phu
-
I just tried the following and got
ysql load data local infile /home/repett0/contact.data into table
CONTACT;
ERROR 1148: The used command is not allowed with this MySQL version
mysql
I too use perl and dbi
What is going on?
Thanks
Ron
In the last episode (Oct 07), Jon Shoberg said:
From: Dan Nelson [mailto:[EMAIL PROTECTED]]
In the last episode (Oct 07), Jon Shoberg said:
I have a small PHP website that gets a fair amount of traffic.
It's a simple layout with two tables. I average about 50
concurrently open
On Mon, 7 Oct 2002, Jon Shoberg wrote:
Ok,
So how do I optimize memory usage? Where to start ?
-Jon
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 9:16 PM
To: Jon Shoberg
Cc: [EMAIL PROTECTED]
Subject: Re: .Optimize
I have the exact same problem. Nothing has changed other than I upgraded
from RH7.3 to RH8.0. I've tried at least five (5) different mySQL
windows clients and all refuse to connect. However I can use phpMyAdmin
locally (via web) and also all my web based database pages work fine
too. I've tried
1 - 100 of 107 matches
Mail list logo
