table_1:
product_id features .
1aaa
2bbb
3ccc
table_2 :
product_idname sizeprice
1 111 111
1 12 2 221
1 13
- Original Message -
From: Brent Baisley brentt...@gmail.com
To: Jose Julian Buda jb...@noticiasargentinas.com
Sent: Thursday, February 12, 2009 1:21 PM
Subject: Re: How can avoid 2 selects and 2 while?
On Thu, Feb 12, 2009 at 10:43 AM, Jose Julian Buda
jb...@noticiasargentinas.com
In the process of installing MySQL 5.1.31, I receive the following error
when I attempt to start mysqld_safe:
090212 10:57:40 mysqld_safe Logging to '/var/log/mysqld.log'.
090212 10:57:40 mysqld_safe Starting mysqld daemon with databases from
/app/mysql/data
/app/mysql/bin/mysqld_safe: line 96:
Colin,
hi, so I think your mysql account doesn't have access /var/log/
directory Permission.
Yours,
fire9
在 2009-2-13,上午1:02, csego...@gmail.com 写道:
In the process of installing MySQL 5.1.31, I receive the following
error
when I attempt to start mysqld_safe:
090212 10:57:40 mysqld_safe
That is intentional. I want to write the log to a non-standard location.
Thanks!
C
fire9 wrote:
Colin,
hi, so I think your mysql account doesn't have access /var/log/
directory Permission.
Yours,
fire9
ÔÚ 2009-2-13£¬ÉÏÎç1:02£¬ csego...@gmail.com
mailto:csego...@gmail.com дµÀ£º
In
It could be that your my.cnf isn't being read (permissions or in the
wrong directory), or that you have multiple my.cnf files.
Quoting csego...@gmail.com csego...@gmail.com:
That is intentional. I want to write the log to a non-standard location.
Jose-
preface the product_id column with table ID e.g.
table_1.product_id
table_2.product_id
or use the alias assigned to tableName
Saludos Cordiales desde EEUU
Martin
__
Disclaimer and confidentiality note
Everything in this e-mail and any
Andy,
Thanks for the suggestion. my_print_defaults mysqld indicates that it
is reading my my.cnf. Furthermore, I have tried both the log and
log-output variables in my.cnf with no success. Any other ideas?
Thanks!
C
Andy Smith wrote:
It could be that your my.cnf isn't being read
I would do the following:
SELECT t1.features, t2.name, t2.size, t2.price
FROM table_2 as t2 LEFT JOIN table_1 as t1 ON t2.product_id = t1.product_id
Then in (psuedo) PHP:
$prev_features = ;
foreach($result as $row){
if ($row['features'] != $prev_features) {
echo ''Product features: .
I haven't looked into it in detail an don't have time right nw, but it
is also hardcoded in mysqld_safe. I have seen a case where it had to
be changed there to make it work. try that and please report back :)
Walter
OlinData: Professional services for MySQL
Support * Consulting * Administration
Andy, Michael, and Walter - thank you!
Adding a [mysqld_safe] group to my.cnf gets me further but the start
still fails. The good thing is that the failure is no longer due to the
inability to write the log file. The [mysqld_safe] section of my.cnf reads:
[mysqld_safe]
port= 3306
I have two Mysql servers and I want to Read data from one Mysql server to
another using stored procedure.
12 matches
Mail list logo