importing databases

importing databases

# List of databases
# \ls -A | grep sql | sed 's/\.sql//g' | xargs | fold -w 80 -s | tr ' ' '|' | column -s'|' -t
dbs="admin_wp11        admin_music    admin_bestsat  admin_exot      admin_geek    admin_girl       
     admin_tabs        admin_birds    admin_frogs    admin_liveagle  admin_exampl  admin_practical  
     admin_productive  admin_reviews  admin_rich     admin_sites"

# Create databases and users
mysql<<<$(
    for db in ${dbs}; do
        echo CREATE DATABASE ${db}\;
        echo CREATE USER \'${db}\'\@\'localhost\' IDENTIFIED BY \'RqaGTWhQ8Zw0Gn5Jmc\'\;
        echo GRANT ALL PRIVILEGES ON \* \. \* TO \'${db}\'\@\'localhost\'\;
        echo FLUSH PRIVILEGES\;
    done
)

# Import databases
for db in ${dbs}; do
    mysql ${db} < ${db}.sql
done