Withdata Software

Split large SQL dump file into smaller SQL files

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.

Download SQLDumpSplitter Download SQLDumpSplitter
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit

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 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

How long does it take to split SQL dump file?
SQLDumpSplitter works fast. The example SQL dump file, nearly 40 GB, 1) split by tables: 30 minutes, 2) split by file size: 7 minutes.
Is it safe to split SQL dump file using SQLDumpSplitter?
Of course! SQLDumpSplitter split SQL dump file locally, absolutely safe.
Can I split SQL dump file on Linux, Mac OS?
Yes, you can. SQLDumpSplitter has Linux, Mac OS, and Windows version.
Can I split SQL dump file in command line?
Yes, you can. SQLDumpSplitter can running in command line, on Linux, Mac OS, and Windows.

More about SQLDumpSplitterSQL dump splitter

See videos:

Split large SQL dump file by tables
Split large SQL dump file by file size