Re: Merging deltas from one table to another?

I think mysqldump does not provide this option. You can extract the data into a file and use "load data infile 'file_name replace into table_name" or replace into table_name select * from old_table_name; For the above to work, there need to be primary key or unique index. If primary key or unique

Re: Merging deltas from one table to another?

On Mon, 8 Mar 2010 14:14:09 -0800 John Oliver said: > OK, a Drupal site I deal with has two copies... a production site and a > test site. After new changes are developed, they're put on the test > site. Once the test site is deemed to be OK, that entire site and > database will be copied over t

Re: Particular value or NULL

Maybe: WHERE coalesce(x, 17) = 17 [JS] Interesting suggestion, but us-gii >select benchmark(1000,(7=7 or null is null)); +---+ | benchmark(1000,(7=7 or null is null)) | +---+ |

Re: Particular value or NULL

Did you gave a try on using coalesce in your query? ""Jerry Schwartz"" escreveu na mensagem news:02a201cac083$e07a2330$a16e69...@com... > >-Original Message- >>From: João Cândido de Souza Neto [mailto:j...@consultorweb.cnt.br] >>Sent: Wednesday, March 10, 2010 10:55 AM >>To: mysql@list

RE: Particular value or NULL

>-Original Message- >From: João Cândido de Souza Neto [mailto:j...@consultorweb.cnt.br] >Sent: Wednesday, March 10, 2010 10:55 AM >To: mysql@lists.mysql.com >Subject: Re: Particular value or NULL > >Maybe: > >WHERE coalesce(x, 17) = 17 > > [JS] Interesting suggestion, but us-gii >select

Re: mysql & RAID

On Wed, March 10, 2010 09:04, Dan Nelson wrote: > In the last episode (Mar 10), John G. Heim said: >> I have read (and have been told) to stay away from RAID-5 for >> update-intensive systems. Are there performance concerns with RAID-10 >> as >> well? We will be buying from Dell (done deal for re

Re: mysql & RAID

In the last episode (Mar 10), John G. Heim said: > I have read (and have been told) to stay away from RAID-5 for > update-intensive systems. Are there performance concerns with RAID-10 as > well? We will be buying from Dell (done deal for reasons too complicated > to go into) and the disks they'r

mysql & RAID

Hi, I am working on configuring a new hardware database server. I'm a little confused as to what to do about disk. We have several mysql databases but by far the 2 most active are spamassassin bayesian rules and horde3/imp web mail. Both do a lot of updates. The bayesian rules are added to eac

Re: Corrupted table

That message usually means you ran out of space in your temp folder location. cheers, Walter Heck -- Engineer @ Open Query http://openquery.com | http://openquery.com/blog On Thu, Mar 11, 2010 at 02:16, Zakai Kinan wrote: > Is there a way to know exactly which table is corrupted with such an e

Corrupted table

Is there a way to know exactly which table is corrupted with such an error: [ERROR] /usr/local/mysql/bin/mysqld: Incorrect key file for table '/tmp/#sql_7885_0.MYI'; try to repair it. TIA, ZK -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscri

Re: Particular value or NULL

Maybe: WHERE coalesce(x, 17) = 17 ""Jerry Schwartz"" escreveu na mensagem news:023301cac069$366afa00$a340ee...@com... > Is there a better construct for the WHERE clause in a LEFT JOIN than > > > > WHERE (x = 17 OR x IS NULL) > > > > ? > > > > Regards, > > > > Jerry Schwartz > > The Infoshop by

Particular value or NULL

Is there a better construct for the WHERE clause in a LEFT JOIN than WHERE (x = 17 OR x IS NULL) ? Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341

Extended Capabilities for Query Design and Data Management for MySQL

Devart Email: i...@devart.com Web: http://www.devart.com FOR IMMEDIATE RELEASE CONTACT INFORMATION: Julia Samarska jul...@devart.com 10-Mar-10 Extended Capabilities for Query Design and Data Management for MySQL Devart announced the public availability of dbForge Query Builder 1.50, a tool