I want to import a number (over 100) .sql files into a single database. I can do this for one <pre class="prettyprint"><code>mysql -u root -p db_name < /tmp/export/data.sql </code></pre> But I have a lot, so I tried this but it fails stating "ambiguous redirect" <pre class="prettyprint"><code>mysql -u root -p db_name < /tmp/export/* </code></pre> Is there another approach I can use from the command line to do this?

Try: <pre class="prettyprint"><code>find . -name '*.sql' | awk '{ print "source",$0 }' | mysql --batch -u root -p db_name </code></pre>

I would try something like <pre class="prettyprint"><code>cat * | mysql -u root -p db_name </code></pre>

Maybe trying <pre class="prettyprint"><code>mysql -u root -p db_name < /tmp/export/*.sql </code></pre> would be an effective alternative.

Import folder of .sql files into a single database

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?

How do I import multiple SQL files?

Select File, then Import, then File. Click Multiple Files. Select the files you want to import. Browse for the first file.

Try:

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

I would try something like

cat * | mysql -u root -p db_name

Maybe trying

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

would be an effective alternative.