Hi
We run MySQL on a 2xP3 1Ghz (Coppermine), 1 GB RAM, 1 software RAID1 (2 x
SCSI), Linux 2.4.9-31 (RedHat patched kernel). We have run a older version
of MySQL (we run only binary releases) for a long time (6 months) with
great success. We had uptimes like 100 days and almost 200 queries /
MR We run MySQL on a 2xP3 1Ghz (Coppermine), 1 GB RAM, 1 software RAID1 (2
x
MR SCSI), Linux 2.4.9-31 (RedHat patched kernel). We have run a older
version
MR of MySQL (we run only binary releases) for a long time (6 months) with
MR great success. We had uptimes like 100 days and almost 200
Even I have tried, SQLyog and MyCC both.
MyCC has some interesting features like Blob Editing
and Editing Table
Properties etc. but SQLyog has some very good features
like Multiple Query
Execution and Multiple ResultSet in different tabs,
which I find usefule
manytimes.
If you are heavy
On Thu, 2002-09-26 at 00:35, Ed Carp wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
The change is made to avoid lots of discussions about when the GPL
is effective. Basically we follow the same rules as we always have
about when we want people to pay us for a commercial license
Hi people,
Why such a message appears at random times when connecting to mysql:
ERROR 1135: Can't create a new thread (errno 35). If you are not out of
available memory, you can consult the manual for a possible OS-dependent
bug
The system is FreeBSD 4.5 with mysql 4.0.2, and there is a lot of
On Thu, 2002-09-26 at 01:05, Ken Menzel wrote:
Does this also apply to non-open-source but free applications? For
example, we give away Escapade for free - always have, always will,
at least for the minimal version of the product. If we develop a
non-free version of Escapade that uses
Hi!
On Oct 01, Grzegorz Paszka wrote:
Hi.
I've such problem.
Is ORDER BY works with MATCH AGAINST ?
i.e.
create table test ( id_test int11, message text);
SELECT id_test, message FROM test WHERE WHERE MATCH (message) AGAINST
('example' IN BOOLEAN MODE) ORDER BY id_test
For me in
Hi,
You forgot : FLUSH PRIVILEGES;
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: luoya li [EMAIL PROTECTED]
luoya,
Wednesday, October 02, 2002, 8:32:21 AM, you wrote:
ll I have Mysql 3.23.52-max-nt on Win2K. I¡¯d like to set a password for root
ll so I use the following commands:
ll mysql use mysql
ll Database changed
ll mysql update user set password=password('l05m')
ll - where
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `' and `').
SEND-PR:
From: root
To: [EMAIL PROTECTED]
Subject: wrong format in safe_mysqld
Description: format string in echo/date line include normal
Sets number of connectons per user/host
set-variable= max_user_connections = 100
Sets total number of connections.
set-variable= max_connections = 500
Also see number of threads for FreeBSD at www.FreeBSD.org
Also in MySQL log on and do a show processlist and see how many
connocetons
I have several database tables which regularly near the operating system 4GB
file limit. Until now I have been using mysqldump/'delete from
tablename'/'optimise table tablename' to backup a large chunk of the oldest
data and remove it from the table. I have been doing this every couple of
Dear people,
I have a problem with getting InnoDB and BDB to work. I use
mySQL Max 4.0. I have even made sure that the skip-BDB and
skip-InnoDB
lines in the configuration .xml file are commented out. But still
the 'variables' list in the winmysqladmin shows haveInnoDB and
haveBDB as
Hello,
Is it possible to install MySQL binary distribution on Solaris into a
directory of my chosing without the need to access /usr/local?
Paul Hunter
* [EMAIL PROTECTED]
* 01473 605476
-
Before posting, please check:
Hi!
InnoDB is a table type which provides transactions, row level locking,
foreign key constraints, and a non-free hot backup tool to MySQL.
InnoDB is included in both downloadable versions of MySQL-4.0: MySQL-Pro and
MySQL-Max.
Release 4.0.4-beta is mainly a bug fix release.
The changelog:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
MySQL 4.0.4-beta, the world's most popular Open Source Database, has been
released and is now available in source and binary form for a number of
platforms from our download pages at http://www.mysql.com/downloads/ and
mirror sites.
This is
Hi,
I have been wondering if there is a schedule when MySQL 4.x is not
considered beta/developement anymore - www.mysql.com recommend MySQL 4.x
for testing only, and has done for some time now.
Thanks and best regards
Peter
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
I went to the download site to get 4.04. I noticed that there is a pro
version now. What is the difference between MySQL, MySQL Pro, and MySQL
Max? I looked at the products page on the website, but I am just not clear.
I do understand that MySQL does not have transactions and the other two do,
Paul,
- Original Message -
From: Paul Varkey [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, October 02, 2002 1:41 PM
Subject: Can't stratup InnoDB and BDB for Max 4.0
Dear people,
I have a problem with getting InnoDB and BDB to work. I use
mySQL Max 4.0. I
Peter,
- Original Message -
From: Peter [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, October 02, 2002 2:44 PM
Subject: Re: MySQL/InnoDB-4.0.4 is released
Hi,
I have been wondering if there is a schedule when MySQL 4.x is not
considered beta/developement
Neat thing on the MySQL front page... it's called news. It lists that there
are new 'price points' (versions) for people. The only differnce between
MySQL Classic and MySQL Pro is Innodb, IIRC.
Matt
- Original Message -
From: Hathaway, Scott L [EMAIL PROTECTED]
To: Mysql (E-mail)
Scott,
- Original Message -
From: Hathaway, Scott L [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, October 02, 2002 2:56 PM
Subject: pro vs max
I went to the download site to get 4.04. I noticed that there is a pro
version now. What is the difference between
Matt Hargraves wrote:
Neat thing on the MySQL front page... it's called news. It lists that there
are new 'price points' (versions) for people. The only differnce between
MySQL Classic and MySQL Pro is Innodb, IIRC.
If I may be so bold as to point out that the description for the
On Wed, Oct 02, 2002 at 02:12:23PM +0300, Heikki Tuuri wrote:
: Hi!
:
: InnoDB is a table type which provides transactions, row level locking,
: foreign key constraints, and a non-free hot backup tool to MySQL.
:
: InnoDB is included in both downloadable versions of MySQL-4.0: MySQL-Pro and
:
Alec,
Tuesday, October 01, 2002, 6:50:31 PM, you wrote:
AdCaQdC What privileges do I need for creating a TEMPORARY table? I seem to have
AdCaQdC locked myself out of this - and yet I can create permanent tables, which
AdCaQdC seems the wrong way round.
AdCaQdC N:\mysql -ualec
AdCaQdC Welcome to
Philip,
Tuesday, October 01, 2002, 5:49:47 PM, you wrote:
PD I have a table which was accessible for the last couple years but is now
PD inaccessible after performing a simple alter table command.
PD There are approx. 10 tables in this database on which the same alter table
PD command was
Graphfixz,
Tuesday, October 01, 2002, 5:14:13 PM, you wrote:
G I am getting the following error:
G [TCX][MyODBC] Lost Connection to MySQL Server During Query
G My code is simply dumping an IP Address to the database... at the most 10
G lines of code. Any ideas what is causing this error? I
Hi Simon,
here are the current values (from 'show variables'):
max_connections: 5000
max_user_connections: 0
And looking at 'show extended-status':
Max_used_connections: 945
Concerning freebsd threads mechanism, I'm using linux threads, and the
maximum number of existing thread processes went
Hi! I found a security bug on mysqlgui-win32-static-1.7.5-2. When I install
it on my desktop (win2k), I setup a password for the database. However, if I
install the mysqlgui on any machine in the local network, I could access the
database on my desktop (from any machine on the local network)
Chris Couture wrote:
Thanks for the info. Let me see if I have this right.
(I am asking these question on behalf of my UNIX programmer who will be
doing all of the programming so sorry if I am asking simple questions.)
To make this simple, let's label the computers. The MySQL database
Hello everybody
I hope u can help me with this. I want to export tables from excel to
mysql and i saved the file as .csv then clicked on browse to get Location
of the textfile. But it doesnt work.
I get for expl:
SQL-query :
3,Technical
4,Technical
7,Technical
15,Technical
20,Technical
Downloaded Win32 static binary of MySQLGUI 1.7.5-2 , but it would not
unzip.
Error message Cannot open file: it does not appear to be a valid
archive. If you downloaded this file, try downloading the file again.
I tried and the same thing happened.
Norm Jetta
Hi,
My company runs a moderately large and loaded MySQL replication network
across four Solaris machines. While upgrading from a fairly old 3.23.4x
installation to 3.23.52 we've encountered a problem with replication and
binlog rotation.
One of the machines is simultaneously slave to one server
This version is avalaible also for WINDOWS 98 ? Because from 3.23.52 (and
4.03) the version are wrong for W98. The program MYSQLQ.exe hang without
error message.
Tks
-
Massimo Petrini
c/o Omt spa
Via Ferrero 67/a
10090 Cascine Vica (TO)
Tel.
If i use GRANT and REVOKE to change user privileges, it is my understanding
that i don't have
to issue a FLUSH PRIVILEGES statement.
Is this correct?
Our sysadmin rebooted the MySQL server this morning, and there were some
privilege problems
afterward. I had to reset the privileges for some
Hello.
On Wed 2002-10-02 at 09:49:30 -0400, [EMAIL PROTECTED] wrote:
Hi! I found a security bug on mysqlgui-win32-static-1.7.5-2. When I
install it on my desktop (win2k), I setup a password for the
database.
What does setup a password for the database mean? Passwords are not
per-database
Hello,
I'm having a problem connecting to a remote MySQL database and was
hoping someone could give me a pointer on where to look. Both machines
are running Red Hat Linux 7.2 and MySQL version 3.23.52. I have it
compiled and running succesfully on each machine as long as I log in to
the database
Philip,
- Original Message -
From: Philip Molter [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, October 02, 2002 4:16 PM
Subject: Re: MySQL/InnoDB-4.0.4 is released
On Wed, Oct 02, 2002 at 02:12:23PM
I have a table with fields ip_addr char(18), mtime timestamp(14) and I
want to create a UNIQUE index on ip_addr without losing the current ip
list. I want to just keep the newest entry for each ip_addr based on
timestamp; is there a way to do this, or should I create a new table
with a SQL
Perhaps those posting obnoxious RTFM responses to Scott's question
should actually take a look at the Versions box at the side of the
MySQL front page and see that there's no longer any mention of MySQL
Classic. Where previously there was a choice between MySQL Classic
and MySQL Pro
I've had some brief discussion about this with other people on other lists
and have decided to move the conversation here, since there are far wiser
MySQL gurus here than I. Here's the scenario:
I want to have two (or more, but for now let's say two) db servers
running. These servers will have
What is the maximum for max_connections when I have:
MySQL database server 4.0.3-beta
HP NetServer LC2000 running RedHat Linux 7.3
Dual Pentium III 800mhz
1GB Ram
Raid5
Regards, Jacob
-
Before posting, please check:
Hi, I woud like to ask for help with sql select.
I have table - visitor, arrival, departure. (Time is in timestamp
in sec. from 1970) I need select top of concurrently present
visitors, between 00.00 and 29.59. So my boss want know when was
shop most full and how many wisitors was there. May be
Hello, List,
About two months ago, I created a script to take a Dia ER diagram and
automatically create SQL DDL for the database. At first, this supported
only PostgreSQL, Oracle, Sybase, and IBM DB2. However, a stated goal of
the project was to support other databases. This script has created
sql,query
Ok, this is a little weird.
From system A I can access the Database on System B via the mysql
command line with the -h option. I can insert into a table, create a
table, and drop tables. But! Through the JDBC interface using the same
user/pass, I get an access denied message.
I
At 16:24 +0300 10/2/02, Victoria Reznichenko wrote:
Alec,
Tuesday, October 01, 2002, 6:50:31 PM, you wrote:
AdCaQdC What privileges do I need for creating a TEMPORARY table? I
seem to have
AdCaQdC locked myself out of this - and yet I can create permanent
tables, which
AdCaQdC seems the wrong
Hi,
Yes, you're right. GRANT and REVOKE do not need FLUSH PRIVILEGES afterwards.
Flushing is only needed when manually updating the grant tables via normal
INSERT/UPDATE/DELETE commands.
Regards,
Iikka
On Wed, 2 Oct 2002 [EMAIL PROTECTED] wrote:
If i use GRANT and REVOKE to change user
Hi !!!
hey guys
i got a scenario here i need to extract some CDR records from
a Mssql database into a mysql database and have them
available on a website. I have not really configured odbc
before, so i am having some problems, i am running SuSE 7.2
on my linux box, i got the the
Yes, I should apologize... no offense intended... I hate RTFM responses
myself. I just thought that maybe he could have done a little more research
before asking the question. It was kinda like asking what the features of
InnoDB were, when you could just do 3 minutes worth of research to find
Thanks to those on the list that looked into it. Apparently the
developer was trying to do an insert on a read only connection.
Damn.
Thanks again!
-James
On Wed, 2002-10-02 at 11:26, James Kelty wrote:
sql,query
Ok, this is a little weird.
From system A I can access the Database on
James Kelty wrote:
sql,query
Ok, this is a little weird.
From system A I can access the Database on System B via the mysql
command line with the -h option. I can insert into a table, create a
table, and drop tables. But! Through the JDBC interface using the same
user/pass, I get an access
On 2 Oct 2002, at 16:50, Matt Hargraves wrote:
Yes, I should apologize... no offense intended... I hate RTFM responses
myself. I just thought that maybe he could have done a little more research
before asking the question. It was kinda like asking what the features of
InnoDB were, when you
[FILTER:sql, query, database, MySQL]
- Original Message -
From: William Martell [EMAIL PROTECTED]
To: win32 MySQL List [EMAIL PROTECTED]
Sent: Tuesday, October 02, 2001 1:27 AM
Subject: Rename Database
Hello All,
I am curious how to rename a database in MySQL 4.0 running on win2k
hey guys
i got a scenario here i need to extract some CDR records from a Mssql
database into a mysql database and have them available on a website. I have
not really configured odbc before, so i am having some problems, i am
running SuSE 7.2 on my linux box, i got the the source (myodbc) from
Has anyone been successful in getting 4.0.3 or 4.0.4 to run on SCO
5.0.6?
Both seem to configure, compile and install. my_install_db completes
successfully and mysqld_safe loads successfully.
Win32 clients on the network and the native command line tools (mysql
and mysqladmin via either unix
I hoped that you will solve the MySQL consuming all computer's
resources in 4.0.4, but nope, the problem is still there. I'm trying
to run MySQL on Win ME and when started normally it consumes
all resources of my computer. When I start it with --skip-innodb
it works just fine. Why ?
At least I
I am currently having difficulties tracking down a problem. We have two
servers, one of which has mySQL installed (3.23.40). Domains on either
server can opt to have a mySQL database, and there are a number of Dbs set
up. We have a relatively low number of maximum connections allowed, and some
HI all
I'm trying to do the following
---
# want to select (just preparing) every thing from the table PERSON
where i don't know the deptID yet.
$per =
Just built a fresh RedHat 8.0 Server and tried to install the latest
MySQL from source.
gunzip -dc source/mysql-3.23.52.tar.gz|tar xvf -
mv mysql-3.23.52 mysql
cd mysql
./configure --prefix=/usr/local/mysql \
Hi, I have just started out using MySQL and have had no end of trouble
getting it started. I am running Redhat 7.2 and MySQL 3.23. I found that I
had to modify my.cnf to point to the path /var/lib/mysql/mysql instead of
just /var/lib/mysql. It still does not start however. The log file
Thanks again for the help! I tried this on my local machine and it
worked like a champ. Here is the question that my unix software
programmer has:
I believe the client end would be a unix ODBC, which mysql has an SCO
version, but it says you need iODBC (or uODBC - I can't remember which),
but
Hi,
I'm also using RedHast 7.2 and yesterday when I tried to start the MySQL
server that came installed with the operating system I had no success.
This morning I downloaded MySQL-3.23.52-1.i386.rpm and
MySQL-client-3.23.52-1.i386.rpm and installed them then the server came
up without any
Query ( that gets past the anti spam )
Question is..
I have a select where I want to get ID 15 id 25
Can I do something like WHERE ID = 15,25
Or do I have to do WHERE ID = 15 ID = 25
-
Chris Kay
Techex Communications
Website:
Has anyone tried to incorporate the Transaction
Support of InnoDB Databases in MySQL to the
setcomplete and setabort commands of Microsoft
Transaction Server? Is it possible to do this? Thank
you for your support.
=
Regor Vincent M. Nono
Junior Programmer
Content Sciences, Inc.
SPI Bldg.
At 12:00 +1000 10/3/02, Chris Kay wrote:
Query ( that gets past the anti spam )
Question is..
I have a select where I want to get ID 15 id 25
Can I do something like WHERE ID = 15,25
Or do I have to do WHERE ID = 15 ID = 25
... WHERE ID IN (15,25)
Thx those who answered, what I was looking for is the IN statement
Thanks again
-
Chris Kay
Techex Communications
Website: www.techex.com.au Email: [EMAIL PROTECTED]
Telephone: 1300 88 111 2 - Fax: (02) 9970 5788
Chris Kay wrote:
Query ( that gets past the anti spam )
Question is..
I have a select where I want to get ID 15 id 25
Can I do something like WHERE ID = 15,25
I don't think this will work,
In SQL you can do WHERE id IN (15, 25)
This IN() function doesn't seems working in MYSQL
For science fair I'm doing a project on MySQL. For my introduction, I
need some articles, benchmarks, or anything else credible that I can put
in the bibliography. If anyone can help me out, I'd be extremely
appreciative! Thanks.
HI all'
mysql select userGroup from machineGroup_userGroups where hostname=mulga;
+---+
| userGroup |
+---+
| staff |
| tech |
+---+
2 rows in set (0.01 sec)
mysql select username from account where loginGroup=staff OR
loginGroup=tech;
+--+
| username |
Hi Ladies Gents,
Does new MYSQL v4.0.4 support Unicode ?
I know that version 4.0 can store Unicode, but it cannot order, unless
we have to write extra codes for it. Unless I am wrong !
Thanks in advance !
/Khanh
-
Before
At 09:40 PM 10/2/2002, you wrote:
For science fair I'm doing a project on MySQL. For my introduction, I
need some articles, benchmarks, or anything else credible that I can put
in the bibliography. If anyone can help me out, I'd be extremely
appreciative! Thanks.
SS,
Benchmarks are no
Hello everyone,
Can someone please help with this. I'm porting my work from Mssql to
MySQL I need some syntax help. My query takes fields from three tables
but it also needs an INNER JOIN between two tables. I have the following :
Table 1:
Mysql select * from table_1;
Enjoy.
Joel can I get a copy of that hex convert utility too? I am working on a
Korean version of mysql yet I currently speak only english. That utility
would help me gobbs.
-Original Message-
From: Joel Rees [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 29, 2002 8:24 PM
I am currently having difficulties tracking down a problem. We have two
servers, one of which has mySQL installed (3.23.40). Domains on either
server can opt to have a mySQL database, and there are a number of Dbs set
up. We have a relatively low number of maximum connections allowed, and some
Hi,
I just install mysql 3.23.52-max-nt on two computers. One is Win2K and
another is winXP. It seems all right. I use the following commands on
both.
C:\mysql\binmysql ¨Chlocalhost ¨Curoot ¨Cp
Mysql prompt:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id
I'm having problems with vb.net and MySQL, only on reading records returned
with requests for functions, i.e., such as the following
SELECT max(field1) AS MaxValue FROM Table1
or
SELECT concat( field1, ' ', field2) as FullName FROM Table1
The queries work fine when executed directly
76 matches
Mail list logo