MySQL: Import multiple sql files into specific database

[vst]

Hi there,

I run into the problem while exporting data into a project folder using MySQL Workbench. Next I tried to import those files into my local development machine but got an "no database selected" error. This .sql files didn't have the "use database;" and MySQL WB unfortunately don't import into the selected database. So I had to import the files using the commandline tools.

Code: Select all

$ cd [project folder]
$ find . -name '*.sql' | awk '{ print "source",$0 }' | mysql -u [username] -p [database] --batch

You are welcome.


All the best,