John:

A couple of suggestions. First, a better way to identify duplicate files in to use MD5 sum - MySQL can compute it with MD5(LOAD_FILE(fname)) if the file is residing on the server. It would be a good idea to store the md5 sum in the table.

I think your problem can be solved with

CREATE TEMPORARY TABLE t1 (<put select fields here>,UNIQUE KEY(size))

then

INSERT IGNORE INTO t1 SELECT ... ORDER BY size,if(ServerName='primary_server',0,1)

and then

SELECT * FROM t1

DROP TABLE t1

A little convoluted, but nothing better really comes to my mind at this point.





--
Sasha Pachev
Create online surveys at http://www.surveyz.com/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to