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