How to load all files from a folder in Mysql?

Question

MySQL

In general, there is a folder with sql files.
I want to load them all into the database:

ls * | mysql -u admin -pw12345678 -h 127.0.0.1 databasename <

but I get:
-bash: syntax error near unexpected token `newline
'

Answer 1

cat * | mysql -u admin -pw12345678 -h 127.0.0.1 databasename