Skip to content

Instantly share code, notes, and snippets.

@daogurtsov
Created June 13, 2012 23:56
Show Gist options
  • Select an option

  • Save daogurtsov/2927213 to your computer and use it in GitHub Desktop.

Select an option

Save daogurtsov/2927213 to your computer and use it in GitHub Desktop.
shell sql query on list of database
#!/bin/sh
#Start vars declaration
dbList=domains.txt
logQuery=logquery.txt
query=query.txt
#End vars declaration
if [ -f "$dbList" ]; then
if [ -f "$logQuery" ]; then
rm "$logQuery"
fi
touch "$logQuery"
while read db_file_name db_name db_user db_pass db_host
do
mysql -h "$db_host" -u "$db_user" --password="$db_pass" "$db_name" < $query --verbose
date=`date`
echo "$db_file_name $date" >> "$logQuery"
done < "$dbList"
cat "$logQuery"
echo "==============="
wc -l "$logQuery"
else
echo "Check dblist file"
fi
echo "=============="
echo "QUERY FINISHED"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment