- \n
- Can run in GUI mode, Step by Step<\/a>, just a few mouse clicks.<\/li>\n
- Can run in Command line<\/a>, for Scheduled Tasks<\/a> and Streams.<\/li>\n
- Split SQL locally and privately<\/b>, avoid uploading LARGE SQL file(s) to online services.<\/li>\n<\/ul>\n
Download SQLDumpSplitter<\/a>
![\"Download](\"https:\/\/www.withdata.com\/images\/download_3.jpg\")
<\/a>
\nWindows 64 bit<\/a>
\nWindows 32 bit<\/a>
\nLinux .deb (For Debian, Ubuntu) 64 bit<\/a>
\nLinux .rpm (For Red Hat, Fedora, SUSE) 64 bit<\/a>
\nMacOS 64 bit<\/a>
\n<\/span><\/p>\nSplit big SQL dump file into smaller SQL files<\/h2>\n
An example SQL dump file, nearly 40 GB. View this large file in BigTextFileViewer <\/a>.<\/p>\n
![\"View](\"https:\/\/www.withdata.com\/images\/sqldumpsplitter\/view-source-sql-dump.png\")
<\/p>\nRun SQLDumpSplitter, click “New Task” at “Start”.<\/p>\n
![\"split](\"https:\/\/www.withdata.com\/images\/sqldumpsplitter\/new-task-windows.png\")
<\/p>\nthen show the splitting form, choose the SQL dump file to split.<\/p>\n
You can:<\/p>\n
- \n
- Split this large SQL dump file to smaller SQL files by tables.
![\"Split](\"https:\/\/www.withdata.com\/images\/sqldumpsplitter\/split-large-sql-dump-by-tables.png\")
<\/li>\n - Or split this large SQL dump file to smaller SQL files by file size.
![\"Split](\"https:\/\/www.withdata.com\/images\/sqldumpsplitter\/split-large-sql-dump-by-filesize.png\")
<\/li>\n - Or split this huge SQL dump file to smaller SQL files by row count.
![\"Split](\"https:\/\/www.withdata.com\/images\/sqldumpsplitter\/split-large-sql-dump-by-row-count.png\")
<\/li>\n<\/ul>\nSplit large SQL dump file in command line<\/h2>\n
Save “Split SQL” session<\/a>, then you can:<\/p>\n
- \n
- Split large SQL dump file in Windows command line.<\/a><\/li>\n
- Split large SQL dump file in Linux command line.<\/a><\/li>\n
- Split large SQL dump file in macOS command line.<\/a><\/li>\n<\/ul>\n
Set scheduled tasks for splitting SQL dump file<\/h2>\n
You can schedule and automate this SQL splitting task by:<\/p>\n
1) Save session and create .bat (Windows) or .sh (Linux\/macOS) file.<\/a><\/p>\n
2) Set scheduled task.<\/a><\/p>\n
FAQ<\/h2>\n
How long does it take to split SQL dump file?<\/a><\/div>\nSQLDumpSplitter works fast. The example SQL dump file, nearly 40 GB, 1) split by tables: 30 minutes, 2) split by file size: 7 minutes.<\/div>\nIs it safe to split SQL dump file using SQLDumpSplitter?<\/a><\/div>\nOf course! SQLDumpSplitter split SQL dump file locally, absolutely safe.<\/div>\nCan I split SQL dump file on Linux, Mac OS?<\/a><\/div>\nYes, you can. SQLDumpSplitter has Linux, Mac OS, and Windows version.<\/div>\nCan I split SQL dump file in command line?<\/a><\/div>\nYes, you can. SQLDumpSplitter can running in command line, on Linux, Mac OS, and Windows.<\/div>\n
\nMore about SQLDumpSplitter<\/a> – SQL dump splitter<\/a><\/p>\n
\nDownload SQLDumpSplitter
![\"Download](\"https:\/\/www.withdata.com\/images\/btn_download_green.png\")
<\/a>
\nWindows 64 bit<\/a>
\nWindows 32 bit<\/a>
\nLinux .deb (For Debian, Ubuntu) 64 bit<\/a>
\nLinux .rpm (For Red Hat, Fedora, SUSE) 64 bit<\/a>
\nMacOS 64 bit<\/a>
\n<\/span><\/p>\n<\/div>\nSee videos:<\/p>\n
Split large SQL dump file by tables<\/a>
\nSplit large SQL dump file by file size<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"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. […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4176],"tags":[3352,67,3351,4058],"class_list":["post-19853","post","type-post","status-publish","format-standard","hentry","category-sqldumpsplitter","tag-split-sql-dump-file","tag-sql","tag-sql-dump-file","tag-sql-dump-splitter"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/19853","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/comments?post=19853"}],"version-history":[{"count":15,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/19853\/revisions"}],"predecessor-version":[{"id":45482,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/19853\/revisions\/45482"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=19853"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=19853"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=19853"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- Split large SQL dump file in Linux command line.<\/a><\/li>\n
- Split large SQL dump file in Windows command line.<\/a><\/li>\n
- Can run in Command line<\/a>, for Scheduled Tasks<\/a> and Streams.<\/li>\n