Skip to main content
Alexander Mikhailian

Alexander Mikhailian

Faster Mysql dump and restore

It's surprising how many people do not know that their mysql dumps and restores can be faster if they disable autocommits.

Dump

mysqldump mydb --single-transaction >mydb.sql

Restore

(echo "SET autocommit=0; cat  mydb.sql; echo "COMMIT;") | mysql mydb
Tags: 
MySQL
gnu screen design patterns microsoft translation networking legal silent majority ruby LaTeX bricolage proxy tall ships race 2010 linguistics singapore security virtualization piracy flemish vandalism bsd git apple misc google computational linguistics flashmob newspeak ipfilter rails autoquotes software programming design journalism cinema wget vocal minority sysml belarus management programming xslt work antwerp gay version control refactoring debian idiots everywhere omg drupalplanet business space exploration corporate russian software php java project management community management gmail papers essay webdesign hardware apache smtp business idea philosophy tomcat adaptive delivery active record Word belgium R data mining metro htc popularity udp hall of shame photosight windows lexicology OLAP 6910p 2FA regress BI code snippets encryption sysadmin economics patents freedom olpc ESA cluster evil kiss SEO netbsd perl ukraine jobs MySQL politics bash EU standards android science drupal Strategic Autonomy struts docker mp3 curl royal fuck-up statistics copyright ICT conferences tcp ddos linux configuration files ETL dictatorship mac oper.ru