MySQL University session on October 8: Building MySQL Releases on Unix

Building MySQL Releases on Unix http://forge.mysql.com/wiki/Building_MySQL_Releases_on_Unix This Thursday (October 8th, 13:00 UTC), Jörg Brühe will give a talk on Building MySQL Releases on Unix. Jörg will describe the tools used by the MySQL Build Team for release builds on Unix-style platforms,

How to REPLACE updating when it's a subset of the primary key what is duplicated or inserting otherwise?

Hello I have a table with a compound primary key (a1,a2) and I want to insert a record (b1,b2) in th cases where there's no a1 value matching b1, and if there's already a b1 value in the form (b1,c2) then just update it so that it turns into (b1,b2). So, If I want to insert-update the record

Re: How to REPLACE updating when it's a subset of the primary key what is duplicated or inserting otherwise?

Fernando, On Wed, Oct 7, 2009 at 5:08 PM, Fer C. ferk...@gmail.com wrote: Hello I have a table with a compound primary key (a1,a2) and I want to insert a record (b1,b2) in th cases where there's no a1 value matching b1, and if there's already a b1 value in the form (b1,c2) then just update

Dump / restore rows in table?

I did try to find out how to do this in the manual, but row and table occur so many times... I want to dump a certain number of rows from one table, and then restore them to another database. I'm guessing I'd try mysqldump -u root -pPASSWORD database_name table_name and then add something to

Re: Dump / restore rows in table?

In the last episode (Oct 07), John Oliver said: I did try to find out how to do this in the manual, but row and table occur so many times... I want to dump a certain number of rows from one table, and then restore them to another database. I'm guessing I'd try mysqldump -u root -pPASSWORD

Re: How to REPLACE updating when it's a subset of the primary key what is duplicated or inserting otherwise?

Thank you for your fast reply! On Wed, Oct 7, 2009 at 6:25 PM, ewen fortune ewen.fort...@gmail.com wrote: Why not use INSERT ON DUPLICATE KEY UPDATE. http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html So, If I want to insert-update the record (a1,b2),b3 the two cases would be:

Replication recovery

I have 2 - 5.0.51a mysql databases setup in a dual master scenario. A is master of B and vise versa... In Linux 2.6.26 (if that matters). Everything is great while all is running normally. But, when I am testing the system by creating disasterous scenarios, I find some challenges I hope to get

MyQuery 3.2.1

MyQuery 3.2.1 is now available for download from Sourceforge: https://sourceforge.net/project/myquery The highlights of this release is much enhanced keyboard navigation, including many more accelerators, main window Tab navigation and much more, so the Mouse isn't much needed if you don't

RE: Replication recovery

In the case that one machine has a power failure, then starts a new binlog, you just have to set the slave to start replicating from the beginning of that binlog. That's easy to detect and repair with a daemon script. Even if both machines die, it'll be a similar scenario. Regards, Gavin

Re: Replication recovery

When only one machine dies I do send the new master position info to the still running slave, and yes, it does the trick. My main challenge is when A dies and is dead for 24 hours and then B dies too. Now A is already out of synch with B and now B has a new log position... Doesnt this make A

RE: Dump / restore rows in table?

Are you just trying to copy a subset of one table into another? If so, simply do this: CREATE TABLE new_one SELECT * FROM old_one LIMIT 1000,5000; That will create a table with the same columns, but no keys or such. If you want to copy the key structure, it will take you two commands: CREATE

RE: Dump / restore rows in table?

-Original Message- From: Jerry Schwartz [mailto:jschwa...@the-infoshop.com] Sent: Wednesday, October 07, 2009 2:15 PM To: 'John Oliver'; mysql@lists.mysql.com Subject: RE: Dump / restore rows in table? [JS] I should have mentioned that you can do this even if you are creating a table in

MYSQL slow query log in table.

Hello All. I would like to implement MYSQL slow query log in table. Can someone kindly assist me with the table definition and implementation. Thanks so much in advance This message is intended only for the use of the Addressee and may contain

RE: Replication recovery

B should be the only one with a bad replication position, since it was replicating when A crashed. So just adjust B, and A should catch up as normal (provided you have the last 24 hours of binlogs on B for A to read ) Regards, Gavin Towey -Original Message- From: Bryan Cantwell

MyQuery 3.2.1 released - Bad link

The correct link is: http://sourceforge.net/projects/myquery/ And if you are asking why I did not try the link before posting (which is a valid question), well, Sourceforge is slow these days. vry slow. And I was lazy. Sorry 'bout that. For next release, I'll find somewhere else to host

Dear friend!

Hi, I bought a TV last week from a website:www.hkeles.com. I have received the product. The quality is very good. They also sell phones,motor,psp and so on. Because of the financial crisis, their products are very cheap. by the way, they only sell new and original products .If you need these

sorry for the spam

So it seems this account was cracked/hacked. Some of you may have received some bullshit email about buying a TV. Please ignore that message as it was sent from whoever hacked this account. It's already been rectified. I apologize for the inconvenience.. damn hackers. for those that care the