Replication - urgent

2007-11-05 Thread Ratheesh K J
Hello All, I need to add a couple of more tables to the list of tables to be replicated from a particular db in the salve my.cnf. Can this be done without restarting the mysql server on the slave? Thanks regards, Ratheesh

Is this kind of ORDER BY possible?

2007-11-05 Thread Christoph Boget
Let's say that I have the following dataset after an INNER JOIN query: UserName | InventoryItem | InventoryAmount | - | --- Joe | Hammer | 2 Joe | Nails | 7 Joe | Screws | 9 Bob | Hammer | 1 Bob |

Re: Is this kind of ORDER BY possible?

2007-11-05 Thread Olaf Stein
I don't think you can order on a certain condition within a query. You can do this with a stored procedure though ... Or, but that would require some logic in the app, with views Greets Olaf On 11/5/07 10:55 AM, Christoph Boget [EMAIL PROTECTED] wrote: Let's say that I have the following

Re: Is this kind of ORDER BY possible?

2007-11-05 Thread Baron Schwartz
Christoph, Christoph Boget wrote: Let's say that I have the following dataset after an INNER JOIN query: UserName | InventoryItem | InventoryAmount | - | --- Joe | Hammer | 2 Joe | Nails | 7 Joe | Screws | 9 Bob

Re: Errors management

2007-11-05 Thread Russell E Glaue
Does the client loose the MySQL connection completely? Or is there just an error in receiving the responding packet back? Here is an idea: You can do a ping to test the connection. Fist ping the connection to verify you can send and receive on that connection. Then send the SQL Command. If you

utf8 queries

2007-11-05 Thread Ovidiu Farauanu
Hello. I have a problem with queries on a utf8 table. For example when I send select SQL_CALC_FOUND_ROWS * from city where country_code = 'pl' and language_code = 'en' and ( city_name like 'A%' or city_name like 'A% ) order by city_name to MySQL, it returns to me not only cities that begin with

Replication - Master/Slave Issue...

2007-11-05 Thread bruce
Hi... I have a situation where I'm looking at multiple child servers, each of which has it's own mysql/DB/Tbls... I want to be able to have all the information that exists in these tbls, to be captured, and copied to a single parent TBL on a separate machine. So, I'm trying to figure out what's

Re: Replication - Master/Slave Issue...

2007-11-05 Thread Baron Schwartz
Hi, bruce wrote: Hi... I have a situation where I'm looking at multiple child servers, each of which has it's own mysql/DB/Tbls... I want to be able to have all the information that exists in these tbls, to be captured, and copied to a single parent TBL on a separate machine. So, I'm trying

RE: Replication - Master/Slave Issue...

2007-11-05 Thread bruce
hey baron... in thinking about this... i'm inclined to imagine some kind of process where the client communicates with the parent system, via a cron process. issues that have to be solved relate to ensuring that the client system is able to update the parent system at all times, even in the

Re: SOLVED: Problem with *very* slow replication, FreeBSD 6.2

2007-11-05 Thread Bob Bankay X-AST : 7731^29u18e3
Running on our systems, we have had the replica load data and then started. The longest delta was about 28 hours behind the master. The slave status faithfully reported how far behind the master it was, when the slave was started, even as it was loading its relay-logs from the master which

Need help creating query statement

2007-11-05 Thread Néstor
I can do simple select statements but I need your brains to create query statment. I am using mysql 4.0 in my 1and1 site. I have a table that has 8 fields, one is the agency field and the other 7 are *tip* values on saving water and the value of this field is either 0 or an amount.

Need help to create a query

2007-11-05 Thread Néstor
I have a table with about 9 fields, and record ID field an agency name field and the # of gallons that a erson pledges to save: -- |ID| agency| 5g | 8g | 10g | 12g | 15g | 18g | 20g |

Fwd: Re: Need help creating query statement

2007-11-05 Thread Enrique Sanchez Vela
--- Enrique Sanchez Vela [EMAIL PROTECTED] wrote: Date: Mon, 5 Nov 2007 15:01:59 -0800 (PST) From: Enrique Sanchez Vela [EMAIL PROTECTED] Subject: Re: Need help creating query statement To: Néstor [EMAIL PROTECTED] --- Néstor [EMAIL PROTECTED] wrote: I can do simple select

Re: Need help creating query statement

2007-11-05 Thread Néstor
Enrique that is pretty good and close to what I need. On top of what you have generously provide, I guess I can just put each gallon field into an array an then sort the array to display the first 5 gallon fields per agency. Is there an easier way? Thanks, Nestor :-) On 11/5/07, Enrique

Not showing repeating fields.

2007-11-05 Thread Jamessketch
Hello, I have a table that looks like this: vehicle | type| color car mercedes blue boat croater silver plane airbus red car volvogreen car BMW white and when I you the SELECT statement to write down just vehicles is shows

PEKRJAAN KOSONG

2007-11-05 Thread Wery Yukili
Kami dari pihak DataEntrySystem menawarkan pekerjaan part time ataupun full time kepada sesiapa yang berminat. Sila klik laman web di bawah untuk maklumat lanjut. http://dataentrysystem.gobigo.com/index.asp *Nota: Sekiranya link tersebut tidak berfungsi sila copy and paste ke

privileges headache

2007-11-05 Thread mysql
I rarely need to add users to a running setup but I always seem to run into the same sort of problem: I grant privs to a user but they refuse to show up. This user will be the one a web application goes through to access the DB. As the root user: GRANT SELECT, INSERT, UPDATE ON

Re: privileges headache

2007-11-05 Thread mysql
[EMAIL PROTECTED] wrote: I rarely need to add users to a running setup but I always seem to run into the same sort of problem: I grant privs to a user but they refuse to show up. This user will be the one a web application goes through to access the DB. As the root user: GRANT SELECT,

Re: Need help creating query statement

2007-11-05 Thread mysql
Néstor wrote: I can do simple select statements but I need your brains to create query statment. I am using mysql 4.0 in my 1and1 site. I have a table that has 8 fields, one is the agency field and the other 7 are *tip* values on saving water and the value of this field is either 0 or an

Re: Not showing repeating fields.

2007-11-05 Thread Ravi Kumar.
select distinct vehicle from table_name On 11/6/07, Jamessketch [EMAIL PROTECTED] wrote: Hello, I have a table that looks like this: vehicle | type| color car mercedes blue boat croater silver plane airbus red car volvogreen car