No it says that the ip 10.0.0.220 does not have the right privileges to
connect to your mysql server.
This can be solved if you connect through command line to mysql and give
grant all privileges on *.* to [EMAIL PROTECTED] identified by
'paswdyouwant';
This will give the basic privileges to
Hi!
In MySQL 4.0, query cache hits are counted in Qcache_hits, but not in
Com_select. The documentation for Com_select implies that they should be
there. Is this the intended behavior, or is it a bug?
- JD
It is intended behaviour.
Com_select is incremented each time SELECT query is
On Tue, 2003-03-11 at 07:33, Richard Taubo wrote:
When using the Union statement in MySQL, is it possible to retrieve the
corresponding table name for a given row? The reason I need to know
this is that I present info from different tables in their own way. I
know I can create a column in
Does anybody (on this list) know anything about threaded embedded server?
Where can I get info about this problem?
I've been using mysql embedded server in my online game
project. The game server receive client requests,
and create a new thread for every request.
I made some tests with a single
hello, Jeff.
you wrote 10 ìàðòà 2003 ã., 5:18:23:
JK From you're info below, mysql *shouldn't* be turning on the binary log. An
JK easy way to test is just to run the 'ps' command and see if '--log-bin' is
JK being added to the command line. If you have a long command line for the
JK mysql
* Phillip S. Baker
How do I write a SQL call to take the results of a select statement and
plug them into a new table in the DB?
If the new table exist, use INSERT ... SELECT:
URL: http://www.mysql.com/doc/en/INSERT_SELECT.html
If the new table does not exist, use CREATE TABLE ... SELECT
Hi!
I have a query that returns a resultset of 70 mb. I'd somehow would like
J/Connector to fetch only small pieces using Statement.setFetchSize but it
still get the whole ResultSet at once and then I get an OutOfMemoryError.
Is it a bug in setFetchSize? Does J/Connector ignore it? Have I totally
On Tue, 2003-03-11 at 04:15, Scott Haneda wrote:
I have run into a problem where data is truncated when sending to MySql via
a SSL connection, I can not determine whether this is my server or just the
protocol, I hope the later, as I know web* 4, which is what I am using will
never get it
On Mon, 2003-03-10 at 22:01, Pete Harlan wrote:
On Mon, Mar 10, 2003 at 11:32:06AM -0600, Paul DuBois wrote:
Whether it's a feature or not, it's not always so easy to figure out
what to do. If you specify -h localhost, it can be argued that you
really want the socket even if you specify
I have a query that returns a resultset of 70 mb. I'd somehow would like
J/Connector to fetch only small pieces using Statement.setFetchSize but
it
still get the whole ResultSet at once and then I get an OutOfMemoryError.
Is it a bug in setFetchSize? Does J/Connector ignore it? Have I
Hello,
it seems as if all links on
http://www.mysql.com/Downloads/mysqlgui/
are broken.
Many thanks for a hint,
regards,
Helmut Jarausch
Lehrstuhl fuer Numerische Mathematik
RWTH - Aachen University
D 52056 Aachen, Germany
-
Hi,
why don't you try to solve the problem with ordinary sql-selects.
You can take select . limit
regards
Reiner
-Ursprüngliche Nachricht-
Von: Roland Carlsson [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 11. März 2003 12:54
An: [EMAIL PROTECTED]
Betreff: Large resultset
Very informative MySQL list. Good Job People!
Query Question..
Two tables
1. Clients
ClientID (Primary Key, Unsigned int , Auto_Increment)
Vehicle typeChar(200)
Vehicle Color CHAR(200)
2. Service
ServiceID (Primary Key, Unsigned int ,
Hello and thanks for the answer!
I use the following code to create the statement and resultset:
java.sql.PreparedStatement stat = conn.prepareStatement(sqlQ,
java.sql.ResultSet.CONCUR_READ_ONLY);
stat.setFetchSize(5);
java.sql.ResultSet res = stat.executeQuery();
So I don't think there is
Hello and thanks for your answer!
If I have understood correctly LIMIT will only return as many row as the
limit. I need all rows, but I can't handle them all at once. In JDBC there
are a method to stream the resultset into small portions and when the end
of the portion is reached it
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Roland Carlsson wrote:
Hi!
I have a query that returns a resultset of 70 mb. I'd somehow would like
J/Connector to fetch only small pieces using Statement.setFetchSize but it
still get the whole ResultSet at once and then I get an OutOfMemoryError.
Is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Sat, 5 Apr 2003 [EMAIL PROTECTED] wrote:
Description:
With a stale login (idle for some time), I've experienced a
repeated ability to cause a seg-fault by attempting to get the
status (\s). I have not tested this
* [EMAIL PROTECTED]
Two tables
1. Clients
ClientID (Primary Key, Unsigned int , Auto_Increment)
Vehicle typeChar(200)
Vehicle Color CHAR(200)
2. Service
ServiceID (Primary Key, Unsigned int , Auto_Increment)
ClientID
Hi All,
I am new to this list, so appologies if I sound like a newbie.
I am trying to check a table to see if a value doesnt exist, and I
would prefer to use the NOT IN syntax, but that doesnt work for mysql.
I've been trying to construct a similar statement in MySQL, but I'm
coming up cold.
t1
Hallo,
what I have is this:
/usr/sbin/mysqld-max --version
/usr/sbin/mysqld-max Ver 4.0.11-gamma-Max for pc-linux on i686
Downloaded and installed:
MySQL-client-4.0.11-0
MySQL-shared-4.0.11-0
MySQL-Max-4.0.11-0
MySQL-devel-4.0.11-0
MySQL-server-4.0.11-0
MySQL-bench-4.0.11-0
...started, loaded,
It doesn't explain the problem at all, since you didn't say what the
problem was..
I would have expected an error message because:
You can't join USING (player) because 'Players' has no 'player', and if
it did, the WHERE
clause would be redundant. The WHERE clause also references the
Hi, everyone.
I use blob to store image data in mysql. I use mysql_real_query to store it, but did
not use mysql_real_escape_string to process it before hand.
Then I saw in the document that this is needed. But I am testing the data stored by
reading them out to do some processing, there seems
I am trying to check a table to see if a value doesnt exist, and I
would prefer to use the NOT IN syntax, but that doesnt work for mysql.
I've been trying to construct a similar statement in MySQL, but I'm
coming up cold.
t1
't1id'
'1'
'18'
'19'
t2
't2id','t2gid'
'19','194'
At 23:05 + 3/11/03, Lai Liu-yuan wrote:
Hi, everyone.
I use blob to store image data in mysql. I use mysql_real_query to
store it, but did not use mysql_real_escape_string to process it
before hand.
Then I saw in the document that this is needed. But I am testing the
data stored by
Thanks for your reply.
But, what then is the role of mysql_real_query? In document, it says You must use
mqsql_real_query for queries that contain binary data?
-
Before posting, please check:
http://www.mysql.com/manual.php
At 0:07 + 3/12/03, Lai Liu-yuan wrote:
Thanks for your reply.
But, what then is the role of mysql_real_query? In document, it says
You must use mqsql_real_query for queries that contain binary data?
That doesn't mean the data values don't need to be properly escaped.
What if you put a binary
I have set up replication and have it working properly for the most part.
If I update the master the slave follows suit. But my slave is a laptop,
that I use for testing but would like that data to stay up to date withthe
master. Overnight if 'live changes take place on the Master, while the
At 11:48 -0500 3/11/03, Daniel Negron/KBE wrote:
I have set up replication and have it working properly for the most part.
If I update the master the slave follows suit. But my slave is a laptop,
that I use for testing but would like that data to stay up to date withthe
master. Overnight if
It is automatic.
Next time you connect your laptop to the network,
and start mysqld on your laptop, it will catch up to the master
provided the bin logs are still on the master.
Daniel Negron/KBE wrote:
I have set up replication and have it working properly for the most part.
If I update the
../Luc Bui
---
+46(0) 11 24 70 86
+46(0) 70 68 17 111
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: den 11 mars 2003 17:58
To: Luc Bui (PAC)
Subject: Re: mySQL 4.1
Your message cannot be posted because it appears to be either spam or
It is automatic.
Next time you connect your laptop to the network,
and start mysqld on your laptop, it will catch up to the master
provided the bin logs are still on the master.
The reason i am asking is because it is not updating a couple of records.
But if I create a new db with some contents
Quoting Bruce Feist [EMAIL PROTECTED]:
Phil Dowson wrote:
Looks like a syntax error to me. There is no t1id in t2. Also, the OR
is redundant; if no t2 row was found, both t2id and t2gid will be NULL,
so checking one of them suffices. Try
SELECT t1.t1id
FROM t1 LEFT JOIN t2 ON
I need help!
I'm making some testing with innodb tables and there're some issues I
don't understand.
I created a small tablespace of 10M:
innodb_data_file_path = ibdata1:10M;
Then I created this simple database:
CREATE DATABASE trace_db;
use trace_db;
CREATE TABLE chromatogram (
Salom Sherzod.
Bu men Jizzaxdan Uzbdan Husniddinman. Chatda kup gaplashgandik agar
eslasez.
Man internetda sizni SQLda ishlashizni bilib qoldim. Shunga sizdan
bitta narsani suramoqchi edim. Siz qattasiz Toshkentdami? Manga
Microsoft SQL 2000 kerak bulib qoluvdi. hech topomadim. qattan topsa
Scott Wong writes:
Version: Mysql 4.0.10-gamma
Description: Mysql hangs and possibly can not recover from a query on an innodb
table.
How to Repeat :
drop table if exists parent;
drop table if exists child;
CREATE TABLE parent(id INT NOT NULL,
PRIMARY KEY (id))
ASP.NET
2.5GChinaNET,
ASP ASPaccess
SQL Server2000SQL Server2000
C
ASP ASP.NET CGI Active Perl Front Page 2000
ACCESS SQLSERVER 2000MS SQL
3G3G
2GPOP WEBMAIL
WINDOWS2000
4000/
C
ASP ASP.NET CGI Active Perl Front Page 2000
ACCESS SQLSERVER 2000MS SQL
300M50M
800mPOP WEBMAIL
Hi All,
I am trying to set up a replication ignoring a given database, but
unfortunatly it doesn't works (for me).
In my.cnf of my master I have at the end :
log-bin
server-id= 1
binlog-ignore-db=access
The line: binlog-ignore-db=access is supposed to make the master not
to log
Hi all,
I've got a mysql application that tracks golf events where players pick
winners. Each event is associated by date with a pick period (ie a
month).
I'm trying to get a COUNT() function to count all the picks by pick
period for a given player (in this case id = 1). The following SQL:
Quoting Bruce Feist [EMAIL PROTECTED]:
Phil Dowson wrote:
SELECT t1.t1id
FROM t1
LEFT JOIN t2 ON t1.t1id = t2.t2id
WHERE t2.t2gid 192 //an example of a gid I am using//
This is close, it shows all the id's that exist in the t2 table without a
t2.t2gid of 192, but I also need to
My apologies if this is covered somewhere, but is there a web interface to
change mailing list options such as MIME/Plaintext digest options ? The
EZMLM respone page from mysql-help does not reference a web interface or
other commands for controlling list options.
Hi all,
I've got a mysql application that tracks golf events where players pick
winners. Each event is associated by date with a pick period (ie a
month).
I'm trying to get a COUNT() function to count all the picks by pick
period for a given player (in this case id = 1). The following SQL:
I know that the file size limit for mySQL tables is
limited by the operating system. I want to confirm
that this is not a database size limit. Pardon my
being a novice, but I just want to be sure.
Thanks for the help, Joe
__
Do you Yahoo!?
Yahoo!
Phil Dowson wrote:
Literally in MSSQL server you would have (but I cant use subselects)
SELECT t1id FROM t1 WHERE t1id NOT IN (SELECT t2id FROM t2 WHERE t2gid = 192)
SELECT t1id FROM t1 left join t2 ON t1.t1id =t2. t2id AND
t2.t2gid = 192 WHERE t2.t2id IS NULL
Pardon me,
It should have read Player not Name in table 1. I don't get an error I get
ID | Name | Player | goals | assists | shutouts | points
--
1 rob J.Doe 2 3
I need to look in several different tables/columns in a database for a
particular value. If I find it, I need to update it. Is there any way to
search/update every table/column in one query in a particular database?
--
Keith Roberts
IT Manager - Laptops For Less
2995 White Star
Anaheim, CA
Hi,
I am having major problems with persistant database connections on a
resident process in java.
My database connection url looks like this:
jdbc:mysql://balti/log?autoReconnect=trueuser=rootpassword=pineapple
But it does not appear to be reconnecting because if I go into
/etc/my.cnf and
mysqldump dbname | grep 'text'
Keith Roberts wrote:
I need to look in several different tables/columns in a database for a
particular value. If I find it, I need to update it. Is there any way to
search/update every table/column in one query in a particular database?
--
Keith Roberts
IT
After trying to compile MySQL for several hours yesterday I finally found a
combination that works... under Solaris v2.9, using GCC 2.95.2, and MySQL
v3.23.54a I had a successful compile. Any upgrading of GCC or MySQL causes a
failure in the compilation of sql_lex.cc:85 - Has anyone encountered
What does the error mean ? - message from server: Not unique
table/alias: 'USER_ROLE'
This happens when I try to use the java code:
PreparedStatement pstmt = con.prepareStatement(Select * From
USER_ROLE, ROLE +
WHERE USER_ROLE.USERID = ? And USER_ROLE.ROLEID = ROLE.ID);
pstmt.setInt(1,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Emma Wansbrough wrote:
Hi,
I am having major problems with persistant database connections on a
resident process in java.
My database connection url looks like this:
jdbc:mysql://balti/log?autoReconnect=trueuser=rootpassword=pineapple
But it does
Ok, in regards to my previous dilemma, I've gotten it to:
SELECT
golf_pick_periods.id,
golf_pick_periods.period_name,
golf_pick_periods.period_start_date,
golf_pick_periods.period_end_date,
COUNT(DISTINCT golf_events.id) AS num_events,
Greetings.
I've been challenged with an assignment in which my client will feed me a 9000-record
SQL Server database every night, and I in turn will need to import the data into
mySQL, replacing the mySQL database from the night before ...
Given that scenario, and the fact that I obviously
CSV would be the easiest way.
-Shamit Verma
(http://vshamit.com)
- Original Message -
From: kenn murrah [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 1:54 AM
Subject: what's the best format option for importing SQL Server databases?
Greetings.
I've been
At 12:50 +0530 3/11/03, Mufaddal Khumri wrote:
What does the error mean ? - message from server: Not unique
table/alias: 'USER_ROLE'
This happens when I try to use the java code:
PreparedStatement pstmt = con.prepareStatement(Select * From
USER_ROLE, ROLE +
WHERE USER_ROLE.USERID = ? And
At 14:24 -0600 3/11/03, kenn murrah wrote:
Greetings.
I've been challenged with an assignment in which my client will feed
me a 9000-record SQL Server database every night, and I in turn
will need to import the data into mySQL, replacing the mySQL
database from the night before ...
Given
At 11:01 -0800 3/11/03, Keith Roberts wrote:
I need to look in several different tables/columns in a database for a
particular value. If I find it, I need to update it. Is there any way to
search/update every table/column in one query in a particular database?
No.
--
Keith Roberts
IT Manager -
on 3/10/03 1:55 PM, Pete Harlan at [EMAIL PROTECTED] wrote:
So your db is on foo.bar.com, and that's the machine you're sshing
into? If so, then you might try
ssh -n -N -L 3307:127.0.0.1:3306 foo.bar.com
Since, once on the new host, it's the localhost's IP address you want
to connect
A request such as this make me think the database is not properly normalized.
If there is one value that can be in several columns, it is very likely
those columns need to be broken into their own table, so that they can be
queried with a SELECT statement that has only one column in its WHERE
Hello,
I have RH 6.1.
I have mysql 3.22.25 version binary installation
databases are in /var/lib/mysql
binaries in /usr/bin/mysql etc
/var/lib/mysql/mysql.pid
/var/lib/mysql/=mysql.sock
and rpm packages:
perl-DBI-1.13-1,
perl-DBD-mysql-mysql-1.22.10-1
perl-5-5.0050
and binary
On Mon, 2003-03-10 at 09:40, Naumann, Frank wrote:
Hi all,
Hi !!
I found a problem (bug?) when updating a blob column via MyODBC. The
statement i run is like that:
UPDATE blob_table SET blob_col = ? where id = ?
when i do NOT bind the restriction as input parameter, but write it
hi,
m$office (office 2000 - win xp) can not handle the time correct.
openoffice (win-xp or redhat-phoebe3) has no problems.
what´s wrong?
MyODBC-windows 3.51
$ rpm -q MyODBC
MyODBC-2.50.39-11
$ rpm -q mysql-server
mysql-server-3.23.54a-4
mysql describe stunden;
Is it possible to place MySQL data directories on a Linux ramdisk mount?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
Greetings,
I am new to this list so I don't know if this topic
has been pounced around or not. DOES MYSQL WORK ON
REDHAT? I got Redhat 7.3 and MySQL 3.23.55
I tried binary installations. I tried installing from
source too. When I finally run the
/usr/local/mysql/bin/safe_mysqld --user=mysql
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Paul DuBois wrote:
At 12:50 +0530 3/11/03, Mufaddal Khumri wrote:
What does the error mean ? - message from server: Not unique
table/alias: 'USER_ROLE'
This happens when I try to use the java code:
PreparedStatement pstmt =
Hi,
Is it possible to place MySQL data directories on a Linux ramdisk mount?
Oh yes. No fragmentation aftertaste.
Regards,
Gabriel
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Yeah, I notice this too, especially after upgrading to MAX. I really find it
annoying.
My guess is that the RPM is slightly different than the God given RH
version, so there are TWO KXXmysqld in /etc/rc.d/init.d or in one of the
rc.3 or rc.5 or something and so one shuts it down, then the other
Reznichenko, Thank you for your answer!
What do you mean could not execute a query on those tables?
Could you be more detailed?
Ok. let me explain.
When I was using MySQL 4.0.10,
After I add columns with ALTER TABLE on foreign key referencing table so many
times,
when I execute SELECT * FROM
MATCH / AGAINST fatal bug
MySQL version: 4.0.11-gamma
OS : Windows 2000 SP3
RAM: 1GB Apacer
Free Disk Space: 32GB
HD Write Back Cache: Disabled
Under some circumstances the following query does never terminate. The
win32 service cannot be stopped either = FATAL.
Check the log for error messages, it's in the data directory...
/usr/local/mysql/data/
- Original Message -
From: b b [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 6:27 AM
Subject: MySQL and Redhat 7.3
Greetings,
I am new to this list so I don't know if this
Hi, I'm a MySQL newbie - Is there a MySQL Web Server
product ? Oracle has their OWS (Oracle Web Server)
for example.
Can anyone reccomend a *very* lightweight web server
with enough scripting ability to talk to MySQL -
preferably for RedHat?
Thx!
The one and only Apache web serverG
Hi, I'm a MySQL newbie - Is there a MySQL Web Server
product ? Oracle has their OWS (Oracle Web Server)
for example.
Can anyone reccomend a *very* lightweight web server
with enough scripting ability to talk to MySQL -
preferably for RedHat?
Thx!
hi guys , i have posted here a few times already and i have trawled the list
archives and tried every tutorial on the topic without any luk , i am still
getting this error, why cant it read the master log saying it isnt open ?
the user i have used has ALL permissions, if i set log-bin in the slave
Thanks, that solved the problem. I thought that I could have my own
fetch-size but I has now understood that Integer.MIN_VALUE is the only size
that is accepted.
Regards
Roland Carlsson
- Original Message -
From: Mark Matthews [EMAIL PROTECTED]
To: Roland Carlsson [EMAIL PROTECTED]
Cc:
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: mysqlcc - release 0.8.10-beta - show create
Description:
If there are more than one database (database1, database2, database3)
connected by MySQLCC, and you will start the function show create
for one of the tables of
74 matches
Mail list logo