Re: A tool

Thanks, I will be waiting for your reply. On Wed, Nov 19, 2008 at 10:22 AM, lakshmi pathi <[EMAIL PROTECTED]>wrote: > Thanks for your comments :) > > > How can i customize, to make it work on debian OS. > > It should work for all ext3 Linux distros giis tested with Fedroa > ,Redhat and Ubun

Re: A tool

Thanks for your comments :) > How can i customize, to make it work on debian OS. It should work for all ext3 Linux distros giis tested with Fedroa ,Redhat and Ubuntu ... I haven't tried it with debianso right now,i don't how to customize it for debian...I'll try and check with debian an

Fatal error: Illegal or unknown default time zone 'UTC'

Hi All, Someone posted this on this list just a few days ago: Incorrect value for default-time-zone And I am now suddenly getting exactly the same issue. Nothing really changed in the mysql department, I did install the latest OS X updates, and needed to res

RE: Finding not quite duplicates

>-Original Message- >From: Bill newton [mailto:[EMAIL PROTECTED] >Sent: Tuesday, November 18, 2008 6:49 PM >To: Jerry Schwartz >Cc: 'mysql' >Subject: Re: Finding not quite duplicates > >I'm having a little trouble with your naming. I"m assuming the query you >listed should be: > >SELECT I

Re: Finding not quite duplicates

I'm having a little trouble with your naming. I"m assuming the query you listed should be: SELECT IF(a.prod_num IS NOT NULL,a.prod_num,"") as prod_num FROM b LEFT JOIN a ON b.prod_pub_prod_id = a.prod_pub_prod_id WHERE (a.prod_discont = 0 OR a.prod_discont IS NULL) ORDER BY b.prod_pub_prod_id;

Re: recurring corrupt table?

have you checked with myisamchk? On Thu, Nov 13, 2008 at 4:09 PM, Jed Reynolds <[EMAIL PROTECTED]> wrote: > Application in php 5.1.6.I'm running MySQL version 5.0.45 on CentOS5 using > a HP DL380 with 8G ram and 15krpm raid10 disks. Tables are myisam. > > I'm seeing errors in my application wher

Finding not quite duplicates

As usual, my head is twisted around something that I think should be easy. Suppose I have a table, `a`, that has three fields: prod_num prod_pub_prod_id prod_discont I have another table, `b`, with a list of products of interest: prod_pub_prod_id What I need to do is match `b`.`prod_pub_pro

Re: A tool

Hi, It's a nice tool. Working for fedora. But not for debian. How can i customize, to make it work on debian OS. On Mon, Nov 17, 2008 at 12:25 PM, lakshmi pathi <[EMAIL PROTECTED]>wrote: > Hi all, > If you are using mysql in linux with ext3 file system,then this might help. > I have written a