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
Written by Ezequiel Kupelian
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best