Skip to content
Snippets Groups Projects
Normal view Permalink
setup_db.sh 277 B
Newer Older
Riccardo Boero's avatar
Making scripts DB server independent.  
Riccardo Boero committed
1 2 3 4 5 6 7 
#!/bin/bash

# Assign parameters to variables
HOST=$1
USER=$2
PASSWORD=$3
Riccardo Boero's avatar
First file structure and loading EU pop grid
Riccardo Boero committed
8 
echo "*** Create database:"
Riccardo Boero's avatar
Making scripts DB server independent.  
Riccardo Boero committed
9 
mariadb -h "$HOST" -u "$USER" -p"$PASSWORD"  < inputs/sql/create_db.sql
Riccardo Boero's avatar
Completed loading US blocks 2020 data.  
Riccardo Boero committed
10 
echo "*** Create tables:"
Riccardo Boero's avatar
Making scripts DB server independent.  
Riccardo Boero committed
11 
mariadb -h "$HOST" -u "$USER" -p"$PASSWORD"  < inputs/sql/create_tables.sql