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
All the best,