Home / ubuntu / Questions / 86807
In Process
Blankman
Asked: 2011-12-11 15:35:44 +0800 CST

Search for all files with a .sql extension in folders and sub folders

  • 772

I want to search for all files with the .sql extension in folders and sub-folders (recursive).

How can I do this?

files

4 Answers

  1. Or...

    find $directory_name -name \*.sql

    For example

    find / -name \*.sql

    Or

    find ~ \*.sql

    (where ~ equates to /home/your_username/), or... 

    find /usr/local/share/ \*.sql

    and so forth.

    • 36

  2. Run this in the command line:

    cd / && find | grep '\.sql$'

    Change '/' to the directory you want to search.

    The find command is able to accomplish the task without grep (using extra options), but I find the above usage more convenient.

    In order, the above command:

    1. Changes the current directory to the root directory (cd /)
    2. Lists all files and directories at and below the current directory (find)
    3. Filters the files and directories for anything that ends with '.sql' (| grep '\.sql$')
    • 3

  3. I know that this is an old post, but i am pretty new at this and i've found an easy way to find all files of a certain extension in a directory and its children subdirectories. Well you first navigate to the parent Directory then find . -name '*.sql' and that will find you all files with .sql extension in the directories and its subdirectories.

    In my case i wanted to delete all .xml files in the directory and its subdirectories, so what i did more is that i added remove as in here find . -name '*.xml' | xargs rm

    Hope this help someone :)

    • 1 
  4. locate -br \\.sql$ | egrep '^/folder/path/'

    If it is not installed, then previously install it with:

    sudo apt install mlocate
    • 0