Unexpected end of file error shell script

Question

I have the following shell script with finds all the files and then should insert the filenames in to the database. The only problem I have is that I keep getting the error:

./testDBScript.sh: line 16: syntax error: unexpected end of file

I am trying to insert in to a mysql database from my script using the following code in a loop like:

for filename in `find . \! -name [*./]` 
do
    echo "$filename"
    insert_statement_for_db="insert into files(filename) VALUES(\"$filename\");"    
    mysql -h $db_host -u $db_user -D $db_database << finish
    $insert_statement_for_db
    finish
done

How else could I insert in to the database? As tutorials online lead me to that solution.

kev · Accepted Answer · 2012-02-25 14:08:31Z

3

The format of here-documents is:

<<finish
    here-document
finish

No indentation before finish.

answered Feb 25, 2012 at 14:08

kev

163k49 gold badges286 silver badges282 bronze badges

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

Comments

Michał Kosmulski · Accepted Answer · 2012-02-25 17:19:57Z

3

It may be due to missing semicolon after the list of values for should iterate over. Try replacing the corresponding line with

for filename in `find . \! -name [*./]`;

kev's note on here-documents is also right. You can either change indentation or use the alternative format:

<<-finish
    here-document
finish

In this case the final finish can be preceded by tabs (but spaces still won't work).

answered Feb 25, 2012 at 17:19

Michał Kosmulski

10.1k1 gold badge34 silver badges53 bronze badges

1 Comment

Alessandro Over a year ago

kev's answer didn't work for me, but using >>-finish worked. Thanks.

Collectives™ on Stack Overflow

Unexpected end of file error shell script

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related