Store files in directory into array, then loop through that array

Question

I have a folder called 'sql' that contains .sql files. I want to write a script that searches for all .sql files, puts the filename into an array, and then kicks off each file.

ie:

 #!/bin/bash

 # Options
 DBHOST=MySQL-hostname
 DBNAME=MySQL-database
 DBUSER=MySQL-username
 DBPASS=MySQL-password

 # Find .sql Files
 ???

 # Create MySQL Tables
 for i in "${TBNAME[@]}"; do
   mysql -h "$DBHOST" -u "$DBUSER" -p"$DBPASS" "$DBNAME" < $TBNAME[$i]
 done

How can I search for .sql files within a specified folder?

A.E · Accepted Answer · 2014-10-06 15:34:52Z

1

for sqlfile in sql/*.sql ; do
    # do things to $sqlfile
done

For example you can save the full pathnames in a table by using echo "$PWD/$sqlfile"

answered Oct 6, 2014 at 15:34

A.E

2602 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mark Over a year ago

Even easier! Thanks so much for your help!

clt60 · Accepted Answer · 2014-10-06 16:07:51Z

0

Late aswer (after accepted one) but for the record:

printf "source %s\n" sql/**/*.sql | mysql --batch

for this you need to have in the ~/.bash_profile line:

shopt -s globstar #or put this before the above line

How it works:

printf "source %s\n" sql/**/*.sql

produces lines like

source sql/some/file.sql
source sql/other/file2.sql
#and such...

recursively for all found *.sql files, and the

mysql --batch .... other arguments

will read the "source filename" lines - and executes the sql commands in the files, all in one execution, not need start (run) multiple times the mysql command...

edited Oct 6, 2014 at 16:07

answered Oct 6, 2014 at 15:59

clt60

64.3k17 gold badges114 silver badges206 bronze badges

Collectives™ on Stack Overflow

Store files in directory into array, then loop through that array

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related