I am trying to restore a large dump (~300GB MyISAM) into a Mysql server version
5.6.48, but if using:
mysql < file.sql
mysql> source file.sql
In both cases, after starting the process all memory RAM/SWAP gets used, looks like the memory is not released, or is trying to read all input into memory.
Any idea of how to import/restore the file without consuming all system memory?
What currently I am doing as an ugly solution, is to import by chunks but restarting the server to free memory after every import, something like:
for t in chunks_* mysql db_name < $t && service mysql-server restart && sleep 2