The original message was received at Tue, 16 Nov 2004 09:14:51 +0100 from
mysql.com [173.126.215.252]
- The following addresses had permanent fatal errors -
[EMAIL PROTECTED]
- Transcript of session follows -
... while talking to 92.153.98.85:
RCPT To:[EMAIL PROTECTED]
550
Hello.
Output of netstat shows that server is listening on all interfaces on 3306
port. Possible reason why you can't connect - the firewall protection. So at
first you may try to telnet to 3306 port on that host from your machine and
really check if tcp works.
I suddenly have lost the
Did the system just reject Monty Widenius' posting? That can't be
right.
On Tue, 2004-11-16 at 02:14, [EMAIL PROTECTED] wrote:
The original message was received at Tue, 16 Nov 2004 09:14:51 +0100 from
mysql.com [173.126.215.252]
- The following addresses had permanent fatal errors
-- Forwarded message --
From: litlpooh [EMAIL PROTECTED]
Date: Fri, 12 Nov 2004 16:46:02 +0900
Subject: Three Questions
To: [EMAIL PROTECTED]
I have three questions about mysql.
1.
mysql CREATE TABLE board (
- boardid char(6) binary NOT NULL,
- title varchar(128) binary NOT
Virus!
Monty's address was probably spoofed
Peter
-Original Message-
From: Spenser [mailto:[EMAIL PROTECTED]
Sent: 16 November 2004 08:32
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Returned mail: Data format error
Did the system just reject Monty Widenius'
Sorry form my english, I am Italian.
They are successful to install mysql-4.1.7 on o.s. solaris 8 thanks to the
suggestions of Gleb Paharenko.
Now I have this problem:
When start the command mysqld_safe mysql start and ended immediately. In
the log file I find this error:
041115
Hello, Mauricio.
I've found something in comments at:
http://dev.mysql.com/doc/mysql/en/Problems_with_alias.html
But I don't know if that will help you. Here it is:
Posted by Ravi Kumar on November 10 2004 9:21am
The above tip can be extended to have variables in column names.
Hello.
Look at output produced by:
show variables like '%char%';
and
show create table 'your_unicode_table';
If you use Unicode, the most obvious that all charsets should be the same.
But if you see something else, probably you should correct that.
More you may read at:
I have a query statement set up for record returns
based on various where statements. The select
statement consists of a number of joins. One of those
joins includes a field that is marked no null.
Recently I did a mass insertion into the table. Into
this particular no null field were place 0's
Hi,
We are pleased to announce the awaited DBManager Professional 3.0.
This version is a new GUI with lots of new features. DBManager is a client
application to manage your databases for Windows environments.
Some of the features in this version are
- Manage all objects in the database server:
ions?
Please see http://dev.mysql.com/doc/mysql/en/News-4.0.18.html :
INSERT DELAYED ... SELECT ... could cause table corruption because
tables were not locked properly. This is now fixed by ignoring DELAYED
in this context. (Bug #1983)
http://bugs.mysql.com/bug.php?id=1983
Obviously I
Hi.
I have a problem with the dump and character set - it would be great if someone
could help.
I have created a database and my tables a long time ago when the database was a
the 4.0 version. Yet some time ago, my server admin has upgraded the server to
version 4.1.2. I haven't noticed that
Can any one tell me where can I find the gramar defenition for sql
language used in mysql?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Quite possibly since 0 could also mean false depending on your
comparison operator. For instance, using a generic if statement, these
two would both evaluate to false:
if(0)
if(null)
You should be very specific when checking for NULL.
WHERE field IS NOT NULL
or
WHERE field IS NULL
Also, you may
Nice interface, but its crippleware. Anything that may be of use is locked
out from testing exactly what they would tell me. I tried to run reports.
Need to purchase. Tried to diagram but not sure what that did for me other
than tell me what tables I already had. could see some benefit for
On Mon, 15 Nov 2004, Patrick Galbraith wrote:
William,
I'm not sure about this, because it involves windows/active state, and
those ppm packages used for active state perl are pre-compiled to run.
I'll talk to the current maintainer about this and see if he knows
about how active state
--- Brent Baisley [EMAIL PROTECTED] wrote:
Quite possibly since 0 could also mean false
depending on your
comparison operator. For instance, using a generic
if statement, these
two would both evaluate to false:
if(0)
if(null)
You should be very specific when checking for NULL.
WHERE
In the last episode (Nov 16), matt_lists said:
Please see http://dev.mysql.com/doc/mysql/en/News-4.0.18.html :
INSERT DELAYED ... SELECT ... could cause table corruption because
tables were not locked properly. This is now fixed by ignoring
DELAYED in this context. (Bug #1983)
At 15:58 +0100 11/16/04, Mário Costa wrote:
Can any one tell me where can I find the gramar defenition for sql
language used in mysql?
Look in sql/sql_yacc.yy in a source distribution.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing
Dear list,
I'm hoping to move to MySQL from Access, mostly so I can use my Mac to
build databases. So far I've been able to set up MySQL, connect to it,
and create databases and tables. Getting to this point has required a
paradigm shift or two on my part (my first question after it was
Also consider buying MySQL support, which will give your requests a bit more
weight.
If that put select into table without locks back into mysql, I would
however, I dont think it will, I've got X dollars for hardware/software
on a given project, my only option is a different database for new
Hello, Alessio.
Check permissions on directories which should contain innodb data files.
User mysql should have write permissions on that directories.
You may use --user command line option to specify user you want. Also see:
http://dev.mysql.com/doc/mysql/en/File_permissions.html
Quoting Christian Kavanagh [EMAIL PROTECTED]:
Dear list,
I'm hoping to move to MySQL from Access, mostly so I can use my Mac to
build databases. So far I've been able to set up MySQL, connect to it,
and create databases and tables. Getting to this point has required a
paradigm shift or
I have table with 83,065 rows. Each time I go to MySQL Administrator and
look at the catalogs, the number of Rows reported by the administrator
changes. I can keep clicking refresh and the number of rows fluctuates
between roughly 81,000 and 86,000. I also see similar behavior when I
access the
Rudy Lippan wrote:
On Mon, 15 Nov 2004, Patrick Galbraith wrote:
William,
I'm not sure about this, because it involves windows/active state, and
those ppm packages used for active state perl are pre-compiled to run.
I'll talk to the current maintainer about this and see if he knows
about how
You've asked these before, and received answers. If you didn't find the
answers sufficient, you should reply to them with follow up questions,
rather than reposting your original email.
Michael
litlpooh wrote:
-- Forwarded message --
From: litlpooh [EMAIL PROTECTED]
Date: Fri,
Michael Stassen said:
Rudy Lippan wrote:
On Mon, 15 Nov 2004, Patrick Galbraith wrote:
William,
I'm not sure about this, because it involves windows/active state, and
those ppm packages used for active state perl are pre-compiled to
run. I'll talk to the current maintainer about this
It's because the table type is InnoDB. InnoDB tables can only give and
estimate of how many rows are in the table. That's just the way InnoDB
works.
From the manual:
SHOW TABLE STATUS does not give accurate statistics on InnoDB tables,
except for the physical size reserved by the table. The
The problem is, when I get the data from the database via a
webpage (php) everything works as expected. The problem is when I
try to get the results from the mysql client (ie. SELECT body FROM
thread WHERE tid=30) the national accented characters are shown as
?. I have browsed through the
Thanks Gleb, but I cant use that because the query is run directly from
within an aplication.
Of course there're should other ways to do that but I want to know if
it is posible from within MySql 4.1 gamma.
If someone does know the answer to this question please let me know
Just in case someone
Thanks. Makes sense ... but strange.
Jeff
Brent Baisley [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
It's because the table type is InnoDB. InnoDB tables can only give and
estimate of how many rows are in the table. That's just the way InnoDB
works.
From the manual:
SHOW
If what you are looking for is a way to say:
SET @columnName='mycolumn';
SELECT @columnName FROM mytable;
and have it be interpreted as the same query as:
SELECT mycolumn FROM mytable;
Then you are out of luck. However, nothing says you can't build a SQL
statement in your application
Actually, Mauricio is trying to concatenate the string 'October_' (or
whatever) to the *alias* of the column name, not to the column name itself.
I tried something like:
@set prefix = 'October_';
select totals as concat(prefix, totals)
from mytable
but it didn't work. Apparently, you can't use
Hello list,
It has been my understanding from reading this list for a few years that
Solaris doesn't match Linux on MySQL performance. I don't recall the
exact reasons (different threading code?). Anyway, I'm exploring the
latest Solaris 10. The virtualization features (Containers) are
Help! I can't figure out a way to stop my server from topping out at 1024
threads. This is a very strange behavoir. I have tons of legit use on my
database server but I don't think the threads are dying does anyone have any
suggestions for this?
Thanks,
Matt Babineau
Web Developer
Criticalcode -
The problem is, when I get the data from the database via a
webpage (php) everything works as expected. The problem is when I
try to get the results from the mysql client (ie. SELECT body FROM
thread WHERE tid=30) the national accented characters are shown as
?. I have browsed through the
That's exactly what I'm trying to do (use the contents of a variable as
an alias for the column)
Thanks
Mauricio
On Tue, 2004-11-16 at 16:09, Rhino wrote:
Actually, Mauricio is trying to concatenate the string 'October_' (or
whatever) to the *alias* of the column name, not to the column name
They are successful to install mysql-4.1.7 on o.s. solaris 8 thanks to the
suggestions
of Gleb Paharenko. Now when use webmin (last version 1.170) o phpmyadmin (last
version -2.6.0-pl2) I have this problem:
DBI connect failed : Client does not support authentication protocol requested
by
Jon Hancock wrote:
However, I can't consider using it unless MySQL performs well.
Any ideas or personal experience with MySQL 4.1.x on Solaris 10?
Well, for one thing, your workload is unique, so the only way you can
make your decision *is* for you to actually *consider* it.
Install Solaris 10,
They are successful to install mysql-4.1.7 on o.s. solaris 8 thanks to
the suggestions of Gleb Paharenko. Now when use webmin (last version
1.170) o phpmyadmin (last version -2.6.0-pl2) I have this problem:
DBI connect failed : Client does not support authentication protocol
requested by
On Tuesday 16 November 2004 02:15 pm, William R. Mussatto wrote:
I had a similar problem with DBI/DBD. The solution I used was to create
the passwords using OLD_PASSWORD('plaintextPassword') function
Look at http://dev.mysql.com/doc/mysql/en/Password_hashing.html for the
details as well as
You need to reinstall your mysql api library to talk to mysql-4.1.7: 4.1.7
has a different auth implementation that is more secure then the 3.23 mysql
protocol which your using. I suggest you link against the C-api that comes
with 4.1.7.
DVP
Dathan Vance Pattishall
Has anyone does any benchmarks with mysql, AMD and gcc 3.4? Gcc 3.4 is
suppose to support AMD specific instructions giving a boost in performance.
DVP
Dathan Vance Pattishall http://www.friendster.com
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
| Dear list,
|
| I'm hoping to move to MySQL from Access, mostly so I can use my Mac to build
databases. So far
I've been able to set up MySQL, connect to it, and create databases and tables.
Getting to this
point has required a paradigm shift or
Dathan Vance Pattishall wrote:
Has anyone does any benchmarks with mysql, AMD and gcc 3.4? Gcc 3.4 is
suppose to support AMD specific instructions giving a boost in performance.
I haven't done any benchmarking, no.
I have compiled MySQL with gcc-3.4.2 and gcc-3.4.3 on some desktop
machines
Hi:
When i tried to install Mysql using the rpm on a Fedora 2 .. i received this
error:
shellrpm -i MySQL-server-4.1.7-0.i386.rpm
warning: MySQL-server-4.1.7-0.i386.rpm: V3 DSA signature: NOKEY, key ID
5072e1f5error: Failed dependencies:
MySQL conflicts with mysql-3.23.58-9
I had the same problem. It just won't seem to upgrade. You need to
uninstall mysql-3.23.58-9 and mysql-server-3.23.58-9 first. Enter
something like this:
rpm -ev mysql-3.23.58-9 mysql-server-3.23.58-9
When it's done, then install version 4.x
On Tue, 2004-11-16 at 15:43, [EMAIL PROTECTED]
I'm not sure how best to proceed in dumping data from 1 database and getting
a copy of the export, in order to transfer it to another server. I usually
use phpmyadmin to do an export, which nicely creates a .zip file of
everything. I managed to get it connected with Mysql Control Center, but am
We recently migrated a medioum sized genetic laboratory database
from Access to MySQl. Of course, for the time being, we are stuck
with our Access front end, using Access linked tables to our MySQL
backend. Everything seems to be 'reasonalbly' okay after a month.
However, we occasionally get a
In the last episode (Nov 16), Titus said:
We recently migrated a medioum sized genetic laboratory database from
Access to MySQl. Of course, for the time being, we are stuck with
our Access front end, using Access linked tables to our MySQL
backend. Everything seems to be 'reasonalbly' okay
SELECT TYTUL FROM tKsidata
WHERE MATCH (TYTUL) AGAINST (space)
ORDER BY TYTUL
TYTUL
Shaping Space 2ed
National Air Space Museum
Light Space
Free Space Architecture
Does Economics Space Matter ?
Economies of Signs Space
Industry Space Competition Contribution of Economists of P
I've created and populated two simple tables:
create table a (id serial, d integer)
insert a (d) values (1)
insert a (d) values (2)
insert a (d) values (3)
insert a (d) values (4)
create table a (id serial, a integer)
insert b (a) values (1)
insert b (a) values (1)
insert b (a) values (4)
insert b
Titus wrote:
We recently migrated a medioum sized genetic laboratory database
from Access to MySQl. Of course, for the time being, we are stuck
with our Access front end, using Access linked tables to our MySQL
backend. Everything seems to be 'reasonalbly' okay after a month.
However, we
Eve,
From the command line you can use `mysql`, command line tool that ships with
MySQL. You would want to use the
SELECT ... INTO OUTFILE 'file.txt' FROM ...;
See the MySQL manual for more information on this:
- http://dev.mysql.com/doc/mysql/en/SELECT.html
You can use another MySQL
Brent B. Powers wrote:
I've created and populated two simple tables:
create table a (id serial, d integer)
insert a (d) values (1)
insert a (d) values (2)
insert a (d) values (3)
insert a (d) values (4)
create table a (id serial, a integer)
insert b (a) values (1)
insert b (a) values (1)
insert b
NaviCat search for it on google it will make your life much easier.
Thanks
Donny Lairson
President
http://www.gunmuse.com
469 228 2183
-Original Message-
From: Amer Neely [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 16, 2004 1:43 PM
To: MySQL
Cc: Christian Kavanagh
Subject: Re:
I have done some looking in the archive for this but can't seem to find
anything recent that seems to apply.
I have a brand new install of 4.1.7 on a Redhat 9 box. I compiled it with:
CFLAGS=-O3 -mcpu=pentiumpro CXX=gcc CXXFLAGS=-O3 -mpentiumpro
-felide-constructors -fno-exceptions -fno-rtti
When would a person want to use the archive storage engine?
Would it suitable for output an audit log to?
What happens if I insert into such a table in the middle of a transaction?
Thanks for the info.
- Garrett
--
MySQL General Mailing List
For list archives:
Everything was fine...I haven't installed anything lately, etc. I've
got a Fedora FC1 system running MySQL v4. I noticed my db exports
failing this morning. The db wasn't running and now won't startup. I'm
googling but... Here's what's in the log:
41116 17:17:09 mysqld started
041116
I have a web application using MySQL 3.2x server. In the application
theres an HTML form used for searching an ISAM table of about 500k
records. To populate select (drop down) fields in the form I do a couple
of SELECT DISTINCT queries against this table.
What's the best indexing strategy to
It is difficult to say without knowing more. It would be helpful if you'd
show us the queries, as well as what EXPLAIN
http://dev.mysql.com/doc/mysql/en/EXPLAIN.html has to say about them.
Your table structure may also help.
I will say that most queries I've seen posted here which used
Pretty straightforward. The other query is identical, except that the
column is of type INT. It executes a little faster, as would problably be
expected.
SELECT DISTINCT directory
FROM pagestats
ORDER BY directory
+---+---+---+---+-++
| table
Shankar Unni wrote:
Jon Hancock wrote:
However, I can't consider using it unless MySQL performs well.
Any ideas or personal experience with MySQL 4.1.x on Solaris 10?
Well, for one thing, your workload is unique, so the only way you can
make your decision *is* for you to actually *consider* it.
63 matches
Mail list logo