Combining Multiple SQL Files in MacOS

The Sequel Pro app only allows a single .sql or a compressed .sql.gz file to be imported, but what if you have hundreds of .sql files to import from your Drupal or WordPress backup?

The solution is to combine the .sql file into one using the cat command.

1. Open the Terminal app and change directories to the where the SQL files are located.

cd ~/Download/drupal-bak

2. Run the cat (short for "concatenate") command to read all of the SQL files and produce a single SQL file.

cat *.sql > ~/Downloads/drupal-bak.sql

3. Import the single SQL file into a MySQL database with your Sequel Pro app.