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