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

Make online money from the Internet