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