Split large SQL dump file into smaller SQL files

by

Want to split large SQL dump file into multiple SQL files without programming?

Using DataFileSplitter, a SQL splitter, a native GUI software, you can split big SQL dump file into multiple SQL files easily and fast.

  • Can run in GUI mode, Step by Step, just a few mouse clicks.
  • Can run in Command line, for Scheduled Tasks and Streams.
  • Split SQL locally, Avoid uploading LARGE SQL file(s) to online services.
  • Support Windows, Linux, macOS.

Download DataFileSplitter Download DataFileSplitter

Split big SQL dump file into smaller SQL files

Choose source SQL dump file -> Set splitting SQL options -> Summary -> Split SQL

Click “New Task” at “Start”.

Split big SQL dump file into multiple SQL files - new task

Choose “SQL” file type.

Split big SQL dump file into multiple SQL files - select file type

1. Open SQL dump file as source.

Split big SQL dump file into multiple SQL files - open source SQL file

2. Config splitting to SQL file options.

Break big SQL dump file into multiple SQL files - config splitting options

3. Summary.

Break big SQL dump file into multiple SQL files - summary

4. Split SQL dump file into smaller files.

Split big SQL dump file into multiple SQL files - split

View a result SQL file.

Split big SQL dump file into multiple SQL files - view a result sql file

Split SQL dump file in command line

Save session, and then create .bat file for Windows command line, or .sh file for Linux / macOS.

Set scheduled tasks for splitting SQL dump file

You can schedule and automate this SQL splitting task by:

1) Save session and create .bat (Windows) or .sh (Linux/macOS) file.

2) Set scheduled task.


More about DataFileSplitter – SQL dump splitter

Download DataFileSplitter for 30-day free trialDownload DataFileSplitter