Import folder of .sql files into a single database

Question

I want to import a number (over 100) .sql files into a single database. I can do this for one

mysql -u root -p db_name < /tmp/export/data.sql

But I have a lot, so I tried this but it fails stating "ambiguous redirect"

mysql -u root -p db_name < /tmp/export/*

Is there another approach I can use from the command line to do this?

Answer 1

Try:

find . -name '*.sql' | awk '{ print "source",$0 }' | mysql --batch -u root -p db_name

Answer 2

I would try something like

cat * | mysql -u root -p db_name

Answer 3

Maybe trying

mysql -u root -p db_name < /tmp/export/*.sql

would be an effective alternative.