RedHat6.2 install (everything) out of box on Intel 1 proc server 256mb ram.
Downloaded 3.23.52-1 rpm & client rpm to /usr/loca/tmp - i created the tmp
folder as root and chmod 777
Followed the install instructions - which only included:
To perform a standard minimal installation, run:
shell>
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 from
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\bin>mysql ¨Chlocalhost ¨Curoot ¨Cp
Mysql prompt:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id
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
use
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
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;
===
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
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
-
Befor
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";
+--+
| use
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.
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
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
--
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)
>
>--
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. Pas
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:
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 probl
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),
bu
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 sho
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 \
--with-unix-socket-path=/usr/local/mysq
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 = $
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
use
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 saw
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 soc
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
m
[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
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
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 acc
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
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 wh
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 t
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 privi
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
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 beli
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 wh
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 o
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:
ht
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
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 (replac
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
then trunc
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
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
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
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 mysql
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.
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 a
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
--
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"
"2
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 databa
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) witho
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 e
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
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
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> Welco
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
: My
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
diff
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 b
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)"
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/develo
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 Ma
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,
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 PROTECTE
-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 a
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:
*
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:
http
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
"
I have several database tables which regularly near the operating system 4GB
file limit. Until now I have been using mysqldump/'delete from
'/'optimise table ' to backup a large chunk of the oldest
data and remove it from the table. I have been doing this every couple of
months.
Approximately 1
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 y
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 t
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 host='l
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 PROTECTE
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
>
>
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 t
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 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 li
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 queries,
75 matches
Mail list logo
