Skip to content

Instantly share code, notes, and snippets.

View chrowe's full-sized avatar

Chris Rowe chrowe

View GitHub Profile
@chrowe
chrowe / manual_steps.md
Last active February 12, 2017 04:13
Pi Ansible
@michaelwills
michaelwills / Inno DB ibdata resizing
Last active August 29, 2015 14:04
Inno DB ibdata resizing to reclaim data
# Reducing InnoDB ibdata file, converting from monolithic file to individual files per database. See:
# http://dba.stackexchange.com/questions/8982/what-is-the-best-way-to-reduce-the-size-of-ibdata-in-mysql
# http://stackoverflow.com/questions/3456159/how-to-shrink-purge-ibdata1-file-in-mysql
# http://vitobotta.com/smarter-faster-backups-restores-mysql-databases-with-mysqldump/#sthash.VCU3nJHa.SldueNKm.dpbs
# user, password, host, port opts stored in ~/.my.cnf
# dump databases to one file, streamed compression
/Applications/MAMP/Library/bin/mysqldump --all-databases --routines --opt --verbose | gzip > backup.sql.gz
@chrowe
chrowe / drush dq.txt
Last active December 16, 2015 23:59
My drush qd template
drush qd mahr-content-import admin_menu module_filter devel fpa views views_bulk_operations ctools features strongarm diff date entity entityreference feeds feeds_tamper job_scheduler extlink --yes
drush en module_filter fpa views_ui devel_generate admin_menu_toolbar extlink feeds_tamper feeds_ui features strongarm date diff --yes
drush dis toolbar overlay --yes