Hi,

bash-3.00$ ls -ltr
total 8471258
-rw-r--r--   1 mysql    mysql       1227 Jul  7 22:33 information_schema.sql
-rw-r--r--   1 mysql    mysql     479762 Jul  7 22:49 mysql.sql
-rw-r--r--   1 mysql    mysql    1974789 Jul  7 22:50 youconnect.sql
-rw-r--r--   1 mysql    mysql       1355 Jul 10 16:22 crms.sql
-rw-r--r--   1 mysql    mysql        531 Jul 11 11:43 prakash
-rw-r--r--   1 mysql    mysql    2163607718 Jul 12 23:40 12-07-09.sql
-rw-r--r--   1 mysql    mysql    2169037247 Jul 13 23:40 13-07-09.sql



bash-3.00$ find /mysql1/mysqlbackup/ -type f -mtime +1 -exec ls -l {} \;
-rw-r--r--   1 mysql    mysql       1227 Jul  7 22:33 /mysql1/mysqlbackup/information_schema.sql
-rw-r--r--   1 mysql    mysql       1355 Jul 10 16:22 /mysql1/mysqlbackup/crms.sql
-rw-r--r--   1 mysql    mysql     479762 Jul  7 22:49 /mysql1/mysqlbackup/mysql.sql
-rw-r--r--   1 mysql    mysql    1974789 Jul  7 22:50 /mysql1/mysqlbackup/youconnect.sql
-rw-r--r--   1 mysql    mysql        531 Jul 11 11:43 /mysql1/mysqlbackup/prakash
bash-3.00$ date
Tue Jul 14 15:03:15 IST 2009
bash-3.00$ uname -a
SunOS webcast 5.10 Generic_127127-11 sun4v sparc SUNW,SPARC-Enterprise-T5120

This is from my man page for find.

Hi,

Thx for your reply.

I backup these files on regularly basis (that is *.sql) and won't be modified and my requirement is check file in /mysql1/mysqlbackup/ directory if any files are more than 2 day it should delete.

How can i achive this.

Thanks

Prakash GR

Try:

find /mysql1/mysqlbackup/  -name "*.sql" -type f -mtime +2 -exec rm -f {} \;