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
#Mysql
Authors
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#