Split large SQL dump file into smaller SQL files

by

Posted on by

Want to split large SQL dump file into small SQL files?

Using SQL Dump Splitter, a native GUI software, a SQL dump splitter for Windows, Linux, and macOS, 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 and privately, avoid uploading LARGE SQL file(s) to online services.

Download SQLDumpSplitter Download SQLDumpSplitter

Split big SQL dump file into smaller SQL files

An example SQL dump file, nearly 40 GB. View this large file in BigTextFileViewer .

View the source SQL dump file

Run SQLDumpSplitter, click “New Task” at “Start”.

split large ${file_type_label} file - new task

then show the splitting form, choose the SQL dump file to split.

You can:

  • Split this large SQL dump file to smaller SQL files by tables.Split large SQL dump file to smaller files by tables
  • Or split this large SQL dump file to smaller SQL files by file size.Split large SQL dump file to smaller files by file size

Split large SQL dump file in command line

Save “Split SQL” session, then you can:

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.

FAQ

More about SQLDumpSplitter – SQL dump splitter