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