When you download a backup from WP Umbrella, you’ll notice that you receive multiple smaller SQL files instead of a single SQL file. This method ensures that the backup doesn’t become too large and avoids issues with server configurations or tool limitations.
But if you prefer working with just one unified SQL file, no worries—this guide will show you how to easily merge them using your terminal on Linux or macOS.
Estimated Time to Complete: 5–10 minutes
Prerequisites:
Basic knowledge of terminal commands 
Access to a Linux or macOS system
A WP Umbrella backup containing multiple SQL files to merge
Launch the Terminal application on your Linux or macOS system to get started.
Use the cd command to move into the folder where your SQL files are stored. Replace /path/to/your/sql/files with the actual path to your files.
Run the following command to combine all SQL files in that directory into a single file named all_files.sql:
cat *.sql > all_files.sql
This command will take all .sql files and merge them in the order they are listed into one unified file.
1. What if the command doesn’t work?
Ensure you are in the correct directory where the .sql files are stored. You can check the files with ls. This will list all files in the current directory.
2. Can I do this on Windows?
This guide focuses on Linux and macOS. For Windows, you can use tools like Git Bash or PowerShell, but the command syntax might be slightly different. Feel free to contact our support for Windows-specific help.
3. Will the order of SQL files affect my database?
Yes! If your SQL files need to be imported in a specific order (for example, schema before data), make sure the filenames are numbered or ordered properly before merging.
4. How do I check if all files are merged correctly?
You can open all_files.sql in a text editor like VS Code or use less all_files.sql in the terminal to quickly review the combined file.
5. What should I do if I encounter errors when importing the merged SQL file?
Check for duplicate CREATE statements or conflicting data inside individual SQL files. You may need to review and clean them up before merging.
That’s it! You’ve successfully merged your SQL files into one file, making database restoration or migration much easier. If you hit any roadblocks along the way, our support team is just a message away. 
