Q:

How to import multiple database at once through SSH?

I am attempting to restore my mysql database to my website, and all of the tables in my database get dropped into individual files, so I am trying to figure out how can I restore all of the database .sql files through SSH with a single (or easy command) instead of restoring all 100 tables individually.

A:

cat *.sql > data.sql
mysql -u <username> -p < data.sql

