How to execute a .sql script from bash
Basically, I need to setup a database from a bash script. I have a script db.sql that does all this. Now how do I run this script from bash?
Database system is mysql
Solution 1:
You simply need to start mysql and feed it with the content of db.sql:
mysql -u user -p < db.sql
Solution 2:
If you want to run a script to a database:
mysql -u user -p data_base_name_here < db.sql