waiting for mysql query to terminate in bash script

Question

I am trying to write a bash script that iterates through a series of mysql queries in text files. I tried using the following script

#!/bin/bash
# Process files

for x in {1...8}
do
    nohup mysql < coauthorquery$x.txt &
    mv nohup.out coauthor$x.csv
done

But it fails because nohup.out isn't present until the completion of the query in the text file. Selecting a fixed duration for a pause is not feasible because length of the query is variable. How do I pause the script until the query is complete?

Don't put it in the background, then. eliminate the &.

Marc B
– Marc B

2014-01-17 04:29:35 +00:00
Commented Jan 17, 2014 at 4:29 — Marc B
– Marc B, Commented Jan 17, 2014 at 4:29

Elliott Frisch · Accepted Answer · 2014-01-17 04:31:04Z

2

Use the wait command

nohup mysql < coauthorquery$x.txt &
wait
mv nohup.out coauthor$x.csv

Or, don't run the command in the background

nohup mysql < coauthorquery$x.txt
mv nohup.out coauthor$x.csv

answered Jan 17, 2014 at 4:31

Elliott Frisch

202k20 gold badges166 silver badges265 bronze badges

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

Collectives™ on Stack Overflow

waiting for mysql query to terminate in bash script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related