Restoring a mysql database in windows 10 I am trying to restore a mysql database in windows 10 using the command below.

mysql -u root mydatabase &lt; mydatabase. 

My computer is quite fast but this is using about 99% of my disk space when I looked through my task manager. Sometime it takes about 2 hours to restore a database.

What can I do to make this faster?
Mysqldump is single threaded so you’re bound by the speed that 1 core can run at to play all your SQL commands in serialised fashion. There are some config variables that can be changed to reduce the amount of disk flushes needed and permit larger memory buffers for speed. 

Innodb (if that’s what engine you use) variables (plus others)


innodb_buffer_pool_size
Innodb_log_file_size
innodb_flush_log_at_transaction_commit
Sync_binlog


Should get your research and tuning off to a start to make things faster.