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 send

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 produ

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 My

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 [mailto

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 inf

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 tab

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 T

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 now

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 Towe

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 want

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

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 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: >> >> a) recor

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

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 t

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. 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 it so that it

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 "(a1,

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,