Issue
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
You simply need to start mysql
and feed it with the content of db.sql
:
mysql -u user -p < db.sql
or if you want to select the database right from the command line
mysql -u user -p database_name < db.sql
Answered By - aioobe Answer Checked By - Gilberto Lyons (WPSolving Admin)