Digital Marketing

Load big data to MySQL by chunks

pt-fifo-split --lines 1000000 your-huge-file &
while [ -e /tmp/pt-fifo-split ]; do mysql --login-path=your-login --local-infile=1  -e "LOAD DATA LOCAL INFILE '/tmp/pt-fifo-split' INTO TABLE your-table" your-database; done


Comments

Popular posts from this blog

Fixed WSL sshd: no hostkeys available -- exiting

PowerMTA pmta command

How to fix: mv: failed to preserve ownership