Creating MySQL database with variables

You could just take the CREATE DATABASE statement away from your SQL file and issue it from your shell script:

#!/bin/bashdbname='my_db'mysql -e "CREATE DATABASE $dbname"mysql $dbname < /path/to/file/CreateSkeleton.sql

CodeHunter