MySQL - keshavbaweja-git/guides GitHub Wiki

Load archive into DB

aws s3 cp s3://aws-data-analytics-workshops/lake-formation-workshop/sampledata/tpc.backup /tmp/

gunzip < /tmp/tpc.backup \
| mysql -h ********.rds.amazonaws.com -P 3306 -u tpcadmin -p tpc

### Connect
mysql -h ********.us-east-1.rds.amazonaws.com -P 3306 -u admin -p

show databases;

### clear screen
\! clear