Can I restore a mysql database faster?

Question

I'm quite new to MySQL and I was wondering: when dumping a mysql database it takes only a few seconds, but when loading it sometimes it takes a few minutes! Is there a reverse of mysqldump to load the database in a few seconds?

Answer 1

Some easy tuning here might help.

Also, there are techniques that can help in specific situations, such as using --disable-keys.

In addition, there is an older post. Be careful of the chosen answer though, the comment said it is dangerous, which is correct, and this tool is now officially deprecated.