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