Hot answers tagged import
You are redirecting the wrong way. Your command, as written, writes stdout of the mysql process to your .sql file. Give that angle brace a 180 degree spin and give 'er another try.
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
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 ...
Only top voted, non community-wiki answers of a minimum length are eligible