Combining Multiple SQL Files in MacOS

MacOS Terminal

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?

Drupal sql file list

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.

Add new comment

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.