Select data from another Mysql Server?

I have two Mysql servers and I want to Read data from one Mysql server to another using stored procedure.

Re: Install problem: log file issue

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 so

Re: Install problem: log file issue

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 h

Re: How can avoid 2 selects and 2 while?

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: " . $row['

Re: Install problem: log file issue

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 (permiss

RE: How can avoid 2 selects and 2 while? SOLVED

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 attachm

Re: Install problem: log file issue

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" : That is intentional. I want to write the log to a non-standard location. --

Re: Install problem: log file issue

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 > дµ

Re: Install problem: log file issue

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 L

Install problem: log file issue

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: /v

Re: How can avoid 2 selects and 2 while? SOLVED

- Original Message - From: "Brent Baisley" To: "Jose Julian Buda" 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 wrote: table_1: product_id features . 1

How can avoid 2 selects and 2 while?

table_1: product_id features . 1aaa 2bbb 3ccc table_2 : product_idname sizeprice 1 111 111 1 12 2 221 1 133