How to import large dataset into a MySQL database

Run mysql as a standalone process with extra parameters

sudo -u mysql /usr/sbin/mysqld --pid-file=/var/run/mysqld/mysqld.pid --skip-innodb-doublewrite --innodb-flush-method=fsync

In another terminal, run import

sudo mysql large_data_table < large_data_backup.sql