Split huge mysql insert into multiple files suggestions

Question

I have a Huge mysql dump I need to import, I managed to split the 3gig file by table insert, one of the table inserts is 600MBs, I want to split it into 100 MB files. So my question is: is there a script or easy way to split a 600MB INSERT statement into multiple 100MB inserts without having to open the file (as this kills my pc).

I tried SQLDumpSplitter but this does not help.

here is the reason I cannot just run the 600MB file:

MYSQL import response 'killed'

Please help

Check this solution for Windows/linux: http://stackoverflow.com/questions/132902/how-do-i-split-the-output-from-mysqldump-into-smaller-files/30988416#30988416 — Alisa, Jun 22 '15 at 22:03

score 2 · Answer 1 · answered Nov 28 '12 at 07:02

2

On Linux, easiest way to split files is split -l N - split to pieces N lines each.

On Windows, I've had pretty good luck with HxD - it works well with huge files.

answered Nov 28 '12 at 07:02

mvp

111,019
13
122
148

score 1 · Accepted Answer · answered Nov 28 '12 at 06:46

1

You can easily open a file of 1GB on Textpad software. User this software to open the file and split your queries as what you want.

Link for downloading TextPad software TextPad

answered Nov 28 '12 at 06:46

Saharsh Shah

28,687
8
48
83

This is the solution I used – David Dec 03 '12 at 12:27

Split huge mysql insert into multiple files suggestions

2 Answers2

Linked