Last Updated: February 25, 2016
·
1.209K
· ekupelian

Load SQL scripts into MySQL

Want to load all the SQL scripts from a particular directory into MySQL from the bash shell ?

cat *.sql | mysql -u mysql_user -p -D mysql_database
  • Remember: replace mysqluser; mysqldatabase accordingly