I am trying to import a series of .SQL files which map one file per DB object into mysql without calling mysql 50 times, something like:
mysql -u root < cat schema/db1/*.sql
This isn't working as "cat" is not a directory -- how would I accomplish this -- and why isn't what I have working? What am I not understanding about linux command piping???
EDIT | The database is created by the SQL file so this doesn't work either:
cat bridge_access/*.sql | mysql -u root bridge_access