Question

3

find .sql and .sql.gz files using find command

rated 0 times [ 3] [ 0] / answers: 1 / hits: 1602 / 1 Year ago, mon, april 24, 2023, 12:43:48

I have a shell script code which find .sql.gz files and moves them:

find $Dir -type f -mtime $Time -name *sql.gz | while read file

do

    echo "Earlier $file will be moved to different folder." >> $Path_Log_File

    mv -f $file $Path_Folder

done

Now I have few more files with the extension .sql so how can I modify my above code so it includes this file extension as well. Thanks.

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

uestred

Add To Favorites

Follow

Total Points: 464

Total Questions: 104

Total Answers: 112

Location: Israel

Member since Wed, Apr 14, 2021

3 Years ago

uestred questions

1 SDDM error - Cannot assign to non-existent property "actionItemsVisible"

Mon, Sep 27, 21, 03:43, 3 Years ago

1 Linux Kernel update error causing package management to grind to a halt!

Sat, Mar 11, 23, 04:28, 1 Year ago

1 What does dev mean in linux commands?

Wed, Mar 2, 22, 04:04, 2 Years ago

1 Bluetooth audio problems on 21.04

Wed, Jan 5, 22, 05:57, 2 Years ago

1 Ubuntu Landscape - update_security_db.sh failure on fresh quickstart deployment

Sun, Apr 30, 23, 12:47, 1 Year ago

View All

answered 1 Year ago tatoethin · Accepted Answer

find offers an "or" (-o) operator:

find $Path_Backup_Dir -type f -mtime $Time ( -name *sql.gz -o -name *.sql )

The default operator between expressions is "and" (-a). Since "and" has higher priority than "or", we need to use parens to group the two "-name" expressions together to get the right logic. Because shells typically treat parens specially, I have escaped them with a backslash to protect them.

Alternatively, you can use a regular expression:

find $Path_Backup_Dir -type f -mtime $Time -regex '.*.(sql|sql.gz)'

You should also note that your find/read command pipeline won't respond well to files with special names (leading space trailing spaces, newlines, etc.). See, for example, this wiki for ways to hand that issue.