Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Can I restore a mysql database faster?

Tags:

mysql

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?

like image 486
Jihath Avatar asked Jul 05 '11 16:07

Jihath


1 Answers

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.

like image 60
zw324 Avatar answered Oct 21 '22 23:10

zw324