I feel like I've run commands like the following in the past, but I'm getting an error trying it right now. Maybe I'm just having a brainfart, and my syntax is off.

mysql -u root -p db_name < *.sql

What I expect this to do is run all the SQL files in the folder ordered alphanumerically. However, I'm getting this error:

-bash: *.sql: ambiguous redirect

1 Answer 1


Try this instead:

cat *.sql | mysql -u root -p db_name

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .