New answers tagged import
It doesn't just copy the data - the DBMS has to write the data into a table and maintain indexes. To avoid fragmenting the indexes and to increase overall throughput, it will add a whole load of records at a time and amend the indexes in chunks too - meaning that there will be periods when it's doing high volumes of writes the database file(s) and low ...
Simply invoke screen at a shell prompt. After it's started the shell inside screen, then run the mysql import command as normal. To detach from the screen session, type Ctrl-A, D. To reattach the session, type screen -r
Top 50 recent answers are included