nsantorello · February 8, 2017 22:15
diff --git a/DeleteTables.sql b/DeleteTables.sql
 delete from MyTable;
diff --git a/MyTable.sql b/MyTable.sql
 insert into MyTable (id, name) values (1, "some name");
 ... etc...
diff --git a/ScriptOrder.txt b/ScriptOrder.txt
 DeleteTables.sql
 MyTable.sql
diff --git a/seed-db.sh b/seed-db.sh
 MYSQL_USERNAME="your username here!"
 MYSQL_DATABASE="your database here!"

 cat ScriptOrder.txt | awk '{ print "source",$0 }' | mysql --batch --default-character-set=utf8mb4 --one-database -u $MYSQL_USERNAME -p $MYSQL_DATABASE
	insert into MyTable (id, name) values (1, "some name");
	... etc...
	MYSQL_USERNAME="your username here!"
	MYSQL_DATABASE="your database here!"

	cat ScriptOrder.txt \| awk '{ print "source",$0 }' \| mysql --batch --default-character-set=utf8mb4 --one-database -u $MYSQL_USERNAME -p $MYSQL_DATABASE