A simple script to create a MySQL db and table

gistfile1.txt

MAKE SURE ALL FILES ARE IN THE SAME FOLDER

in a file named lab.sh:

#!/bin/bash
mysql < mysql.sql
mysqldump FastFood > station12.sql
rsync -P station12.sql [email protected]:~/

in a file named mysql.sql:

DROP DATABASE IF EXISTS FastFood;
CREATE DATABASE FastFood;
USE FastFood;
CREATE TABLE McD (
  id INT UNSIGNED NOT NULL, 
  type VARCHAR(30)
  ); 
CREATE TABLE Wendys (
  id INT UNSIGNED NOT NULL, 
  type VARCHAR(30)
  ); 

make lab.sh executable and run with ./lab.sh