On Mon, 1 Aug 2005, Heikki Tuuri wrote:
unfortunately, the bug fix was never made to 4.0. It is only in 4.1.12 and
later.
Hi Heikki,
Thanks for your response. The fix seems to consists only of a few lines:
http://mysql.bkbits.net:8080/mysql-4.1/[EMAIL PROTECTED]|[EMAIL PROTECTED]
It looks
Hello.
MySQL uses indexes in queries which are parts of UNION. See:
mysql explain (select * from t1 where a=5) union (select * from t1 where
a=3)\G;
*** 1. row ***
id: 1
select_type: PRIMARY
table: t1
type:
Hello.
It seems that your DBD::MySQL module doesn't read configuration file,
or [client] group. Use mysql_read_default_group and mysql_read_default_file
in your DSN:
$dbh = DBI-connect
(DBI:mysql:test:localhost;mysql_read_default_file=/etc/my.cnf;.
mysql_read_default_group=dbdmysql,
hi all,
is there a howto on this? or an application for this?
tia,
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Where do you see that?
I didn't type the command to execute the mysql client, and database is
not the password, is the default database of the session. So, in the command
mysql -u user -p database
the user is user, the password is prompted interactively, and the
default database is
Hi!
Gregory Machin wrote:
Hi all.
Please could you advise.
I would like to know if one could do a recursive search through a data
base and get a result of wich column and field is holding the string ?
SQL (the language) always requires the table and column name to be given
as constant text
Hi,
Is not the first time when i read this this page.
So, the conclusion is that until MySQL version 5.0.3 the empty spaces are
remove if i wish to store the binary data in a table.
Is not any other solutions?Because for the moment i convert the binary data
into ASCII(printing ASCII) string,i
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
I installed mysql-standard-4.1.11-pc-linux-gnu-i686] in my system.
There is no file in '/var/lib/mysql/mysql.sock'.
Thanks.
--
MySQL General Mailing List
For list archives:
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
I have installed mysql-standard-4.1.11-pc-linux-gnu-i686 .
Please reply .
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Usually those kind of errors mean that the MySQL server program is not
running -- there is nothing to connect to. The socket file is used for when
you connect to MySQL from the server that is running it.
Make sure that the server is up and running before connecting. Look for it
in the process
First check whether MySQL server is running on your machine or not.
You can use 'ps -aux | grep mysql' for checking this.
sujay
-Original Message-
From: Kumar Gaurav [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 02, 2005 10:31 AM
To: mysql@lists.mysql.com
Subject: Please Give me
I used command: c:\mysql\bin\mysqladmin -u root shutdown
and I got error :
mysqladmin: connect to sever at 'localhost' fail
error 'Access denied for user 'root'@ 'localhost' (using password: NO)
Does anyone know why? Please share with us.
Thankyou..Phong
--
MySQL General Mailing List
For
If you got password set for root, try c:\mysql\bin\mysqladmin -u root -p
it should prompt for password.
On 8/2/05, Nguyen, Phong [EMAIL PROTECTED] wrote:
I used command: c:\mysql\bin\mysqladmin -u root shutdown
and I got error :
mysqladmin: connect to sever at 'localhost' fail
error
Hi all
I've created a table in mysql 4.1.12 and 5.0.9-beta-standard as follow
| manager_new | CREATE TABLE `manager_new` (
`id` bigint(20) NOT NULL auto_increment,
`id_from_hits` bigint(20) default NULL,
`from_ip` varchar(15) default NULL,
`pool` char(1) NOT NULL default 'n',
`to_ip`
Hi all
I've created a table in mysql 4.1.12 and 5.0.9-beta-standard as follow
| manager_new | CREATE TABLE `manager_new` (
`id` bigint(20) NOT NULL auto_increment,
`id_from_hits` bigint(20) default NULL,
`from_ip` varchar(15) default NULL,
`pool` char(1) NOT NULL default 'n',
`to_ip`
Peter Brawley [EMAIL PROTECTED] writes:
Scott,
Is there any database file similiar to M$'s Northwind that I can use to play
with? It would be nice if there is one inside MySQL by default for newbies
to start out with.
For our chapters on Connector/ODBC and dotNet, Arthur I wrote scripts to
Do you have any root password set? If so, you should mention -p option in
the command. The command should be of the following :
c:\mysql\bin\mysqladmin -u root shutdown -p
Which will ask you to enter the root password, else you can type your
password along with the -p option as follows :
Alvaro Cobo [EMAIL PROTECTED] writes:
Hi guys:
I have the following problem:
In the organization I work for, we have several standard formats which
we have to write for each project we manage (for example:
reports). These are MS-Word documents, for which I have created a
database and
Hello.
See:
http://dev.mysql.com/doc/mysql/en/access-denied.html
Nguyen, Phong [EMAIL PROTECTED] wrote:
I used command: c:\mysql\bin\mysqladmin -u root shutdown
and I got error :
mysqladmin: connect to sever at 'localhost' fail
error 'Access denied for user 'root'@ 'localhost'
Hello.
Have a look here:
http://solutions.mysql.com/technology/technology/?item=425
SQLPorter supports Postgres according to this page.
JM [EMAIL PROTECTED] wrote:
hi all,
is there a howto on this? or an application for this?
tia,
--
For technical support
Hello.
See:
http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html
Kumar Gaurav [EMAIL PROTECTED] wrote:
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
I installed mysql-standard-4.1.11-pc-linux-gnu-i686] in my system.
Thankyou. But, when I startup I got error like
Innodb: error: log file .\ib_logfile (0,1) is different size
Innodb: than specifiled in the .cnf file
050729: {eror} can't init database
050729:{error} aborting
Could you please tell me why?
Thank you
-Original Message-
From: Scott Hamm
Following query is taking a long time (upto 10 secs) to return the resultset.
Would greatly appreciate if someone could help me understand why.
I have run 'analyze table tablename' on all the three tables involved. The
EXPLAIN output, record count and table description is also included.
SELECT
After installing mySQL along with a program called articlebot, I tried to
run the application and I keep getting this message:
An unhandled exception has occurred in a component in your application.
Click continue and application will ignore this error and attempt to
continue.
ERROR
enrique...
i wasn't looking for away around the behavior... i was simply posting this
as a potential bug.
my version of mySQL (1.4.12) gives me the error that i described.. i'd be
willing to bet other versions act in a similar manner...
-bruce
-Original Message-
From: Enrique Sanchez
I'm used with MS SQL and could not understand MySQL's document. I'm trying
to create something like the simple example
DECLARE @title varchar(255)
SET @title='%Unconditional%'
SELECT @title;
How do I get around to it in MySQL?
--
Power to people, Linux is here.
CREATE PROCEDURE title()
BEGIN
DECLARE title VARCHAR(255);
SET title = '%Unconditional%';
SELECT title;
END;
//
mysql CALL title()//
+-+
| title |
+-+
| %Unconditional% |
+-+
1 row in set (0.01 sec)
HTH
Mark
Mark Leith
Cool-Tools UK
Scott Hamm [EMAIL PROTECTED] wrote on 08/02/2005 10:12:01 AM:
I'm used with MS SQL and could not understand MySQL's document. I'm
trying
to create something like the simple example
DECLARE @title varchar(255)
SET @title='%Unconditional%'
SELECT @title;
How do I get around to it in
On 8/2/05, Mark Leith [EMAIL PROTECTED] wrote:
CREATE PROCEDURE title()
BEGIN
DECLARE title VARCHAR(255);
SET title = '%Unconditional%';
SELECT title;
END;
//
mysql CALL title()//
+-+
| title |
+-+
| %Unconditional% |
+-+
1 row in
MySQL 5.0.9 Beta :)
On 8/2/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Scott Hamm [EMAIL PROTECTED] wrote on 08/02/2005 10:12:01 AM:
I'm used with MS SQL and could not understand MySQL's document. I'm
trying
to create something like the simple example
DECLARE @title
-Original Message-
From: Scott Hamm [mailto:[EMAIL PROTECTED]
Sent: 02 August 2005 15:38
To: [EMAIL PROTECTED]
Cc: Mysql
Subject: Re: STORED PROCEDURE
On 8/2/05, Mark Leith [EMAIL PROTECTED] wrote:
CREATE PROCEDURE title()
BEGIN
DECLARE title VARCHAR(255);
SET title =
-Original Message-
From: Mark Leith [mailto:[EMAIL PROTECTED]
Sent: 02 August 2005 15:56
To: mysql@lists.mysql.com
Subject: RE: STORED PROCEDURE
-Original Message-
From: Scott Hamm [mailto:[EMAIL PROTECTED]
Sent: 02 August 2005 15:38
To: [EMAIL PROTECTED]
Cc:
Hmm nice screwed formatting, but anyway.. ;)
Please guys - the overquoting!!
Thank you.
--
Martijn
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Your second statement hit the spot. :) Thanks!
On 8/2/05, Mark Leith [EMAIL PROTECTED] wrote:
-Original Message-
From: Scott Hamm [mailto:[EMAIL PROTECTED]
Sent: 02 August 2005 15:38
To: [EMAIL PROTECTED]
Cc: Mysql
Subject: Re: STORED PROCEDURE
On 8/2/05, Mark Leith
when I startup I got error like
Innodb: error: log file .\ib_logfile (0,1) is different size
Innodb: than specifiled in the .cnf file
050729: {eror} can't init database
050729:{error} aborting .
Could you please tell me why?
Thank youNguyen
--
MySQL General Mailing List
For list
Hi,
I think that I have seen many times the advice not to store the images in
MySQL, but to store them on the hard disk while putting the path to them in
the database.
They could be accessed much faster this way.
Teddy
- Original Message -
From: Gelu Gogancea [EMAIL PROTECTED]
To: Jay
In my data structure I have many BLOBs which are not images - so I am hoping
that MySQL can indeed deal with BLOBs ok ?
Andy
On 8/2/05 12:14 PM, Octavian Rasnita [EMAIL PROTECTED] wrote:
Hi,
I think that I have seen many times the advice not to store the images in
MySQL, but to store them
Hi,
I think I'd like to store these values as strings
instead of [?]int or time types.
Is this string arithmetic? Can/should I do this?
(I see the second one won't work without single-quotes.)
mysql select '3' - '1';
+---+
| '3' - '1' |
+---+
| 2 |
+---+
1 row
Can you also sent it to me.
Thanks!
Nesto r:-)
-Original Message-
From: J. David Boyd [EMAIL PROTECTED]
Sent: Aug 2, 2005 8:20 AM
To: mysql@lists.mysql.com
Subject: Re: Database equivalent to NorthWind for M$ SQL
Peter Brawley [EMAIL PROTECTED] writes:
Scott,
Is there any
My RaQ4 is throwing the Too many connections error. Now, it is
getting hit pretty hard by traffic, but I wonder if my coding might
be exacerbating this error.
Due to my relatively lazy structure of includes and functions, my
pages might have half a dozen or so of these (most are to the
I have never had a problem storing BLOBs in MySQL or any other DB for that
fact.
I have on many occasions forgot to use the proper methods for send a BLOB
to the db. That means proper escaping, etc.
On Tue, 2 Aug 2005, Andy Hilton wrote:
In my data structure I have many BLOBs which are
But then replication would not work.
On Tue, 2 Aug 2005, Octavian Rasnita wrote:
Hi,
I think that I have seen many times the advice not to store the images in
MySQL, but to store them on the hard disk while putting the path to them in
the database.
They could be accessed much faster this way.
Hello.
Have you changed InnoDB log file sizes? See:
http://dev.mysql.com/doc/mysql/en/adding-and-removing.html
Manual says that you have to stop mysql, then change the parameter in my.cnf,
then I moved to another directory the log file just to be cautious, and then
restarted
Hello.
It works for me on MySQL 5.0.10:
mysql CREATE TABLE `manager_new` (
- `id` bigint(20) NOT NULL auto_increment,
- `id_from_hits` bigint(20) default NULL,
- `from_ip` varchar(15) default NULL,
- `pool` char(1) NOT NULL default 'n',
- `to_ip` varchar(15)
Hello.
I don't know the relationships between program articlebot and MySQL.
But error message tells me to ask you to check if you have MyODBC
properly configured and whether your MySQL server is running. See:
http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html
There is
why does this list not have the reply to header set?
-jason pyeron
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- -
- Jason Pyeron PD Inc. http://www.pdinc.us -
- Partner Sr. Manager
On Tue, Aug 02, 2005 at 02:38:01PM -0400, Jason Pyeron wrote:
why does this list not have the reply to header set?
This is covered in the mailing list FAQ at
http://lists.mysql.com/faq.php
Jim Winstead
MySQL Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
In one case I do need to jump back and forth between databases that
are on different physical servers. What's the most efficient way to
handle this?
On Aug 2, 2005, at 11:14 AM, Devananda wrote:
Brian Dunning wrote:
My RaQ4 is throwing the Too many connections error. Now, it is
Just wondering if someone would be kind enough to take a look at it - Nishi
-Original Message-
Following query is taking a long time (upto 10 secs) to
return the resultset. Would greatly appreciate if someone
could help me understand why.
I have run 'analyze table tablename' on
I was storing some 8 bit information in a varchar binary field (encrypted
stuff) and I think its getting corrupted. I thought they were (except for
size) interchangable? I'm running debian GNU Linux and haven't moved to
sarge so I'm still on 3.23.x but will be moving shortly.
---
William R.
At 01:58 PM 8/2/2005, you wrote:
Just wondering if someone would be kind enough to take a look at it - Nishi
Nishi,
What did EXPLAIN show? Also what happens if you have just one
Match? Is it faster? If so, why not run 2 queries and build a temporary
table from the results. Using OR
Brian Dunning wrote:
In one case I do need to jump back and forth between databases that are
on different physical servers. What's the most efficient way to handle
this?
On Aug 2, 2005, at 11:14 AM, Devananda wrote:
Brian Dunning wrote:
My RaQ4 is throwing the Too many connections
Kapoor, Nishikant [EMAIL PROTECTED] wrote on
08/02/2005 02:58:08 PM:
Just wondering if someone would be kind enough to take a look at it -
Nishi
-Original Message-
Following query is taking a long time (upto 10 secs) to
return the resultset. Would greatly appreciate if someone
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 02, 2005 3:14 PM
To: Kapoor, Nishikant
Cc: mysql@lists.mysql.com
Subject: RE: SQL query taking a long time...please
Kapoor, Nishikant [EMAIL PROTECTED] wrote on 08/02/2005 02:58:08 PM:
Just
Hello.
In my opinion, one of the causes of the problem can be the processing
of trailing spaces in varbinary fields. See:
http://dev.mysql.com/doc/mysql/en/binary-varbinary.html
William R. Mussatto [EMAIL PROTECTED] wrote:
I was storing some 8 bit information in a varchar binary
Hello For All
I need a pratic examples of Triggers in Mysql 5.x
Regards For all
Carlos Souza
From Brazil
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Gleb Paharenko said:
Hello.
In my opinion, one of the causes of the problem can be the processing of
trailing spaces in varbinary fields. See:
http://dev.mysql.com/doc/mysql/en/binary-varbinary.html
Thanks, you may be right since the results are too short.
William R. Mussatto [EMAIL
Hi, im kind of new using mysql, i used to have it
installed on my Mandrake 9 using rpm, but i m testing
the source installation, the thing is that i´ve
succesfully compiled mysqld and it works, but now im
trying to use a php page, and im asked to install :
PHP needs a set of MySQL functions
I see these really need to be int or time types.
Is there no way they can default to NULL or blank?
Hi,
I think I'd like to store these values as strings
instead of [?]int or time types.
mysql select '3' - '1';
+---+
| '3' - '1' |
+---+
| 2 |
+---+
1 row in
Hello
CJS I need a pratic examples of Triggers in Mysql 5.x
Chapter 20. Triggers
http://dev.mysql.com/doc/mysql/en/triggers.html
Sincerely,
Michael,
http://xoib.com/ http://3d2f.com/
http://qaix.com/ http://ryxi.com/
http://gyxe.com/ http://gyxu.com/
http://xywe.com/ http://xyqe.com/
May be you should consider building an ontology with your data base. This links
will provides ideas to explore this avenue:
http://www.ksl.stanford.edu/people/dlm/papers/ontology-tutorial-noy-mcguinness-abstract.html
Raoul
David Blomstrom [EMAIL PROTECTED] wrote:
I've been gathering data for
Carlos,
I need a pratic examples of Triggers in Mysql 5.x
There are examples at
http://dev.mysql.com/doc/mysql/en/create-trigger.html and
http://dev.mysql.com/doc/mysql/en/using-triggers.html.
PB
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 /
62 matches
Mail list logo