Re: Multiple instances howto

In addition, can you run multiple instances of mysqld simultaneous? toutiao wrote: > > > Dear Friends, > > I'm learning to create multiple mysqld instances on Linux, where one > instance of mysql is already running. > > While creating a new my.cnf file, I noticed that I need to assign a s

Multiple instances howto

Dear Friends, I'm learning to create multiple mysqld instances on Linux, where one instance of mysql is already running. While creating a new my.cnf file, I noticed that I need to assign a socket file to it. Can you pls. tell me how to create / test this socket file? Thanks, Jing Zhang --

Re: Completeness rate of records

Olaf Stein <[EMAIL PROTECTED]> wrote on 03/27/2008 01:16:43 PM: > Hey all, > > I have a table with 40 columns. If for a record a value is not available the > column is set to NULL. Is there a quick way of finding out how many records > have a value (NOT NULL) for 90% (or lets say 35 columns) o

Re: Completeness rate of records

Thanks. But that means I have to type all 40 column names, which I what IU was trying to avoid Olaf On 3/27/08 1:34 PM, "Rob Wultsch" <[EMAIL PROTECTED]> wrote: > On Thu, Mar 27, 2008 at 10:16 AM, Olaf Stein > <[EMAIL PROTECTED]> wrote: >> I have a table with 40 columns. If for a record a value

Re: Completeness rate of records

On Thu, Mar 27, 2008 at 10:16 AM, Olaf Stein < [EMAIL PROTECTED]> wrote: > I have a table with 40 columns. If for a record a value is not available > the > column is set to NULL. Is there a quick way of finding out how many > records > have a value (NOT NULL) for 90% (or lets say 35 columns) of th

Completeness rate of records

Hey all, I have a table with 40 columns. If for a record a value is not available the column is set to NULL. Is there a quick way of finding out how many records have a value (NOT NULL) for 90% (or lets say 35 columns) of the columns. Thanks Olaf - Confide

Group by function and avg on char

Hi all, got a simple problem I'm trying to solve without success. Given the following table CREATE TABLE `scores` ( `proj` char(3) NOT NULL default '', `id` int(11) NOT NULL default '0', `score` double default NULL, `cpid` char(32) default NULL, `team` char(20) default NULL, PRIMARY

rsync errors

Hi I am running the command on Gentoo OS /usr/bin/rsync -avO /var/lib/mysql [EMAIL PROTECTED]:/var/lib/ > /tmp/rsync-${TIMESTAMP}.log 2>&1 I am getting the below error in the log file mysql/ rsync: failed to set permissions on "/var/lib/mysql": Operation not permitted (1) rsync: failed to open

Re: [PHP] How to install PHP 5.x on Windows Server 2000 with IIS 5 and MySQL 5.x

[EMAIL PROTECTED] wrote: > Hello to All, > > Would you mind to help as the title of mail ? > > Thanks ! > > Edward. > What problems are you having? Have you read the Manual yet? I'd suggest going with a real operating system (linux) which keeps patches updated quicker... Wolf -- My

Cisco Access Registrar & MySQL Cluster

Cisco's Access Registrar supports MySQL 4.x. Does anyone have any experience trying to make it work with MySQL Cluster? Ben Wiechman Network Admin Wisper High Speed Internet [EMAIL PROTECTED]

R: version mimatch

First, I don't know if there is a way to make binlogs compatible, it seems SQL syntax incompatibility. You should look for single errors and correct it by hand or, if your target is to import data from a MySQL 4.x server to a MySQL 3.x server you could import the binlogs into a MySQL 4.x server, d

R: SqlState error code 42S22 driving me insane

Hi Mike, could you please be more precise? What platform, language, versions are you using for the client application? What o.s. and version are you using for mysql server? Which is the code giving you problems? The more information you give, the easier is to answer. Aloha! Claudio Nanni ---