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
link|improve this question

feedback

1 Answer

up vote 1 down vote accepted

Try this instead:

cat *.sql | mysql -u root -p db_name
link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.