Inserting multiple files to mysql on command line

Question

I am using ubuntu and mysql. I have a list of many .sql files, like 1.sql, 2.sql, 3.sql ... 100000.sql

I need to insert them into the database

    mysql mydb < *.sql

Gives me:

    -bash: *.sql: ambiguous redirect

Any idea how can i do it from command line. (I know i can write a pyhton script to do it with no probelm)

Thanks.

Answer 1

I have no MySQL available but I believe cat *.sql | mysql mydb should work.

Answer 2

If Nifle's answer doesn't work, then try:

for f in *.sql
do
    mysql mydb < "$f"
done