i hate rpm's source code gcc all the way !
-Original Message-
From: Roger Davis [mailto:[EMAIL PROTECTED]]
Sent: Saturday, November 16, 2002 10:17 AM
To: [EMAIL PROTECTED]
Subject: RE: redhat 8.0
Redhat 8.0 includes mysql. Although it is not a part of the default
install, you can instal
On Fri, 15 Nov 2002, Joseph D. Wagner wrote:
> OK OK! You've proved me wrong IN THIS PARTICULAR EXAMPLE. The fact
> remains that plenty other examples exist where MySQL could benefit from
> the .NET Framework.
>
> WILL MYSQL BE USING THE MICROSOFT .NET FRAMEWORK IN FUTURE DEVELOPMENT
> OF THE WIN
OK OK! You've proved me wrong IN THIS PARTICULAR EXAMPLE. The fact
remains that plenty other examples exist where MySQL could benefit from
the .NET Framework.
WILL MYSQL BE USING THE MICROSOFT .NET FRAMEWORK IN FUTURE DEVELOPMENT
OF THE WIN32 PORT?
Joseph Wagner
-Original Message-
From:
Redhat 8.0 includes mysql. Although it is not a part of the default
install, you can install it by choosing the option to select which packages
will be installed. Or if you already have redhat 8.0 installed, the mysql
rpms are on the CD's (number 3 I think).
Also, make sure that you update your
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 15, 2002 4:51 PM
Subject: mysql process keeps references to files after conn.close()
> Hi.
>
> I am doing a simple programmatic task. I am opening a connection to a
> database using
>
> co
will redhat 8.0 support mysql (kernal 2.4.18-14)??
thank you
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
Matt,
since you are using InnoDB, you cannot call server_end() and server_init()
again during the lifetime of the process. InnoDB does not clean up its
internal data structures in server_end().
Is there some special reason you would need to shut down the server and
open it again?
Regards,
Heikki
I
Hi.
I am doing a simple programmatic task. I am opening a connection to a
database using
connn = DriverManager.getConnection("jdbc:mysql://localhost/dbname")
I then do some stuff, and execute a conn.close().
I then try and delete the database files, and I get an error that they are
in use
Jeremy Zawodny wrote:
The good news is that they seem to get it (or some of it), and the
fact that Giga is interested means their clients want to know.
Is there a regularly updated 'success stories' section to the MySQL site
yet that I just haven't come across?
--
Michael T. Babcock
C.T.O.,
On Fri, Nov 15, 2002 at 05:25:32PM -0500, Michael T. Babcock wrote:
> For what its worth, I got a call from Informix (now part of IBM)
> yesterday doing a survey on customer opinion of their products vs. IBM's
> own DB2 product, Microsoft's SQL Server and Oracle 9i in terms of
> knowledge of the
For what its worth, I got a call from Informix (now part of IBM)
yesterday doing a survey on customer opinion of their products vs. IBM's
own DB2 product, Microsoft's SQL Server and Oracle 9i in terms of
knowledge of the products, possibility of using them in the future,
success in the past, an
Dean Harding wrote:
Like I said, the ROWID in Oracle is the *physical address* of the row.
It's made up of three parts: datafile, block and offset. If you say:
select * from some_table where rowid='RRRBBFFF';
In that case, I'm more confused about why anyone would want to specify
"ORDER
>Description:
I downloaded and installed the RPM from mysql.org (the uu.net mirror
in the USA). The transcript told me to set a root password using
/usr/bin/mysqladmin, but that program doesn't exist. I also am missing
other programs referred to in the documentation, such as /u
> >In Oracle, because the ROWID is the actual physical address of the
row,
> >it provides O(1) access to a row, as opposed to O(log(n)) that an
index
> >provides. That's a pretty good benefit if you ask me.
> >
>
> I'd love to see the math on that proven; I'm running it through my
head
> now and
- Original Message -
From: "K-Tech S.r.l." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, November 15, 2002 3:33 AM
Subject: Info about XA support
> I'm trying to configure a XA datasource on Bea WebLogic 6.1, i'm using the
Connector/J.
> If i use two different database in an
Hi,
Does anyone know how to retrieve the affected-rows messages from the
command-line? My interactive sessions prints them out but I can't
get them from the command-line. For example:
mysql < file.script > results.out
using mysql .0.4-beta on a solaris 2.7 machine generates an empty
results.out
How do I go about installing mysqlGUI? I have downloaded all of the
files.
Please help.
Thanks.
Craig
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Hello,
I am trying to create a shopping cart for my company and have hit a
snag.
I have created a database in MySQL that has several tables. How would I
go about displaying the fields from one table based on the fields in the
other?
Let me explain. I have a table called forder_details which
Use the LIMIT clause on your select statement
Limit 0,10 will get first 10, then use limit 10,10 for the next 10, etc.
see http://www.mysql.com/doc/en/SELECT.html for details
-Original Message-
From: Jason Frisvold [mailto:friz@;corp.ptd.net]
Sent: Friday, November 15, 2002 11:02 AM
To:
===
Bug report -- MySQL v4.04b, source distribution
===
Machine specs (build machine and test machine are same machine):
I want to select a large amount of data from the database, but I can't
use it all at once. Is there a way to "pick up where I left off" and
get another X rows of data?
For instance, suppose I have the following table in a database :
CREATE TABLE namelist (nameid INTUNSIGNEDNOT NULL
That was meant to read 'the slave position has NOT updated since the last
upgrade.' Sorry =/
Quoting [EMAIL PROTECTED]:
> Hello,
>
> A while back I upgraded our slave mysql database from 3.23 to 4.04, it
> accepted replication coming from a 3.23 machine fine for several weeks. Last
>
> night
Hello,
A while back I upgraded our slave mysql database from 3.23 to 4.04, it
accepted replication coming from a 3.23 machine fine for several weeks. Last
night I upgraded the master from 3.23 to 4.04 and now there is a problem with
replication.
Below is the output from show master/slave statu
David Lubowa wrote:
i thought the main reason was that he did not want to use a firewall ( for
some reason , only he knows why :) )
As someone who enables full iptables firewalling on every Linux machine
on my networks, I never see 'not using a firewall' as plausible, even if
I'm told its t
Assume I have a mysql table (myisam most likely) with a few hundred
thousand rows in it. One of the columns indicates success or failure.
99.9% of the rows will have "0" in that column. But a small number will
have 1. I need to be able to fetch those rows quickly, without slowing
everything else do
Hi List
Is there a special function to change all content of the mysql database to
utf8?
Or is there a possibility to change it with a perl or php script?
Any idee?
Macloy
-
Before posting, please check:
http://www.mysql
Hello,
Turns out that it is an issue that Red Hat has bugzilla 75128. I included
my remote windows 2k into the etc/hosts of the red hat 8.0 and all is
working now.
Thanks,
Tom Morgan
-Original Message-
From: Michael T. Babcock [mailto:mbabcock@;fibrespeed.net]
Sent: Friday, November 15,
Dean Harding wrote:
still taking up a few bytes per row of memory, like it or not.
Some logic ... statement 1:
The ROWID isn't stored by Oracle (except in your indexes).
... does not coincide with statement 2:
It's "stored" in the same space that MySQL would allocate for
... these
i thought the main reason was that he did not want to use a firewall ( for
some reason , only he knows why :) )
cheers
David Ziggy Lubowa
Network Engineer
One2net (U)
web: www.one2net.co.ug
Tel: +256 41 345466
-Original Message-
From: Michael T. Babcock [mailto:mbabcock@;fibrespeed.net]
Joseph Bueno wrote something about SQL:
You can also restrict port 3306 to localhost with :
bind-address = 127.0.0.1
in /etc/my.cnf
Or even:
iptables -A INPUT -s 127.0.0.1 --dport 3306 -j ACCEPT
iptables -A INPUT --dport 3306 -j DROP
--
Michael T. Babcock
C.T.O., FibreSpeed Ltd.
http://www.f
How do I report bugs in MySQL CC? I have seen a consistent bug in 85 and
86. Would like to report but not sure how??
Passion and Presence
Allan Hardy
-
Before posting, please check:
http://www.mysql.com/manual.php (the ma
CoastResearch,
Thursday, November 14, 2002, 9:34:14 PM, you wrote:
Caadc> if ANYONE has any suggestions for this I would greatly appreciate
Caadc> it :) I just dont know where else to turn for help ...
Caadc> If I launch MySQL 3.23.38, everything is fine. If I open tables,
Caadc> creat db,
Bungarz,
Thursday, November 14, 2002, 9:32:43 AM, you wrote:
BK> We are using mysql, version 4.0.4 beta on windows 2000 Server.
BK> I tried to put data und index on different drives, usind the DATA and
BK> INDEX directory option of the "create table" statement.
BK> But both was created in the defa
Hello Kai,
Friday, November 15, 2002, 1:27:01 PM, you wrote:
BK> Hi!
BK> Thank you for your answer!
BK> Index was used befor, but i didn't run "myisamchk -rq".
BK> Is it necessary?
Yes, you must re-create indexes:
http://www.mysql.com/doc/en/myisampack.html
--
For technical support cont
Mark,
Thursday, November 14, 2002, 4:34:19 PM, you wrote:
MI> On Thu, 14 Nov 2002, Victoria Reznichenko wrote:
>> MI> I am having a problem with replication. When I create a new database on
>> MI> the master, the CREATE DATABASE command is not shipped to the slave.
>> MI> Subsequent table creation
Eric,
Friday, November 15, 2002, 1:36:54 AM, you wrote:
EA> Assume two tables:
EA> CREATE TABLE block_ip (
EA> datestamp int(11) NOT NULL default '0',
EA> remote_addr char(15) NOT NULL default '',
EA> PRIMARY KEY (remote_addr),
EA> KEY datestamp (datestamp)
EA> ) TYPE=MyISAM;
EA> CREATE
Bruce,
Friday, November 15, 2002, 5:35:21 AM, you wrote:
BL> I have a problem about foreign key in using MySQL.com manual. According to
BL> the example in MySQL.com manual, one foreign key is ok. However, I have 3
BL> tables (ie. 2 for parent tables and 1 for child table). When I use 2 or more
Rick,
Thursday, November 14, 2002, 9:26:01 PM, you wrote:
RR> What is the mysql.db table for?
Entries in the table 'db' determine database level privileges.
RR> It looks like it contains user and database permissions of some kind..
RR> but.. many of the rows in the "db" table refer to databases
> On Tuesday 05 November 2002 08:26, [EMAIL PROTECTED] wrote:
>
[.]
>
> MIT pthreads is no longer part of the source distribution. If you
> want to compile with "--with-mit-threads", you first need to download
> and extract them into the mysql source directory.
> You can obtain the package f
by now, i hope, you've gotten answers from the
sql gurus on the list, so i won't clutter with my
humble attempts.
your comment about problems with joins indicates
that corereader might be of some help to you if
you have a windows box for a front end. it will
let you do quick point-and-click
Hi,
It's possible if you use DATE_FORMAT().
E.g.
SELECT DATE_FORMAT('1997-11-15', '%d-%b-%Y')
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- O
Hi,
I try to compile mysql-3.23.53 on my GNU/Linux system with gcc-3.2
there was no problem with the configure, but for the make I got this :
[...]
Making all in client
gmake[2]: Entering directory `/tmp/mysql-3.23.53/client'
g++ -s -DUNDEF_THREADS_HACK -I./../include
-I../include -I./.. -I
Use the same query except replace
nvl((c.sr_num),0))
with
count(*)
John
Lance Prais wrote:
I have a question about using count in an Intersect Statement. I want to
get the total count of the following SQL Statement: How would I do this?
SELECT
nvl((c.sr_num),0)),
FROM
s_evt_act a,
s_srv_
I want to import a text file into a table that has a date type column with
mysqlimport.
In the text file the date column is in the DD-MMM-YY format (ie 25-JUL-02); so
when I import it, I get -00-00 in the table's date column.
Is there a way to do this correctly ?
My version is 3.23.52.
Thank y
I am looking for a way to include MySQL installation as part of another
installation using InstallShield.
Do you have or do you know where to find InstallShield merge
modules for MySQL and MySQL ODBC-driver?
Regards and thanks,
Petter Ulltveit-Moe
---
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
Is table_cache parameter still important when using innodb table types?
I thought it's not, because there is no separate files for each table in
InnoDB
But now I see a lot of queries in "opening tables" and "closing tables" state.
Does increasing table_cache parameter may help?
Rafal
P.S. sql, q
>Description:
The distribution RPMs does not close the RPM file after install before
starting MySQL.
[roott@godzilla ~]# rpm -Uvh /mnt/autofs/mirror/MySQL/MySQL-3.23.53a-1.i386.rpm
[..output removed...]
[roott@godzilla ~]# lsof | grep -i i386.rpm
safe_mysq
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
where can i find the free Solaris for intel they only have a free sparc
version :|
-Original Message-
From: [EMAIL PROTECTED] [mailto:jpw@;Qenesis.com]
Sent: Friday, November 15, 2002 3:16 PM
To: [EMAIL PROTECTED]
Subject: Solutions to Solaris 8 Intel compile problems
>Description:
Vince LaMonica wrote:
On Fri, 15 Nov 2002, Edwin Raj wrote:
} [root@edwinraj bin]# /usr/local/mysql/bin/mysqladmin -u root password
} 'simple'
} /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
} error: 'Can't connect to local MySQL server through socket
} '/tmp/mysql
You can also restrict port 3306 to localhost with :
bind-address = 127.0.0.1
in /etc/my.cnf
Hope this helps
--
Joseph Bueno
David Lubowa wrote:
> port 3306 is the default port for mysql , if you do "grep -i 3306
> /etc/services " you will see what service runs on that port. As for
> restricting
I'm trying to configure a XA datasource on Bea WebLogic 6.1, i'm using the Connector/J.
If i use two different database in an atomic transaction i'm not able to commit and i
receive a rollback signal.
I have reade in a generic forum that actually MySql does not support XA is it true?
Thanks
Fabr
port 3306 is the default port for mysql , if you do "grep -i 3306
/etc/services " you will see what service runs on that port. As for
restricting access to it without a firewall i guess you would have to set up
specific users who can access it and throw out the rest. Have a look at the
mysql docs
Hello,
In Case 1, you need to change:
"index i_Tb (customerId, carId)" => "index i_Tb (carId,
customerId)" or add "index i_carId (carId)"
In Case 2, you need :
"foreign key (customerId) references customerTb (customerId)" =>
"foreign key (customerId) references customerTb (cust
Dear,
I'm so sorry that nobody didn't answer for my question, which asked
about the condition
relay log files are deleted in replication slave server.
Anyway. Although somebody said that the files will be deleted
automatically, it seems
NOT. It keeps growing over several hundreds MB and are
On Fri, 15 Nov 2002 [EMAIL PROTECTED] wrote:
} P.S. I have to take this decision very fast.
} Because I don't have time to search the mail list for this decision I need
} quick and short well explanation.
You might want to check the MySQL documentation on transactions:
http://www.mysql.com/doc/e
On Fri, 15 Nov 2002, Admin-Stress wrote:
> I tried --skip-networking, but then mysqld could not be started. I got this from
>google.com. Is it
> the correct way?
It's correct. Put this in your /etc/my.cnf and restart mysql.
[mysqld]
skip-networking
/Lars
---
Hi,
After I installed mysql, I noticed there is an open port now, port 3306.
Can I restrict this so only from localhost can connect? I meant to close port 3306.
But without using firewall :( I dont have knowledge about this.
If there is no way to do this without firewall, then I will learn it.
I
Hi all,
I'm working on design step for a new application and I'm interested about
fulltext indexes. I need a safe transaction tables also.
Does Mysql support this or is a feature?
In need a SOLUTION for a fulltext search on the InnoDB table.
Advices or alternative solutions on this topic are
60 matches
Mail list logo