MySQL - Transaction/Commit Question/Issue

Hi... I'm considering the following issue: need to copy in db1 tbl_1 -> tbl_2 and in db2 cat -> dog so i need to perform copies of both tbls in the two databases. and i need them to both succeed, or to both be rolled back. the copies are in two separate databases. any thoughts on this... t

RE: MySQL - Replication (Master/Slave) Question

From: Dan Rogart [mailto:[EMAIL PROTECTED] > On 11/14/07 4:01 PM, "Mike Johnson" > <[EMAIL PROTECTED]> wrote: > > > Correction to a couple of replies I've seen -- a slave > > server can have more than one master, but not to the same > > database. That is, Slave reads Database1 and Database3

Res: German collation for UTF8 missing

Hi Friend, Try this: CHARACTER SET: latin1 COLLATION: latin1_german2_ci Cya! Wagner Bianchi Diretor de Tecnologia - INFODBA Technologies & Consulting [EMAIL PROTECTED] - (31) 3272 - 0226 / 8427 - 8803 - Mensagem original De: Yves Goergen <[EMAIL PROTECTED]> Para: Marten Lehmann <

Re: MySQL - master/slave replation question

bruce wrote: Hi... If I have a master/slave setup, I can do a "mysql>show slave status\G" and get information on the overall status of the slave. Is there a way to break out this information without having to parse the output? In other words, are there other cmds that might provide the different

MySQL - master/slave replation question

Hi... If I have a master/slave setup, I can do a "mysql>show slave status\G" and get information on the overall status of the slave. Is there a way to break out this information without having to parse the output? In other words, are there other cmds that might provide the different pieces of info

Re: Transactions and locking

> Sequences, if I got that right, need the new value to be stored > immediately, i.e. outside of an active transaction. This requires a > second connection to the database which probably causes more > implementation work for my web application. You mean real sequences? As with Oracle? Then no, yo