Published by Mijingo

movie icon image

EE Insider Blog

Spend your time learning and developing sites with ExpressionEngine and we'll use this blog to keep you informed of all the news related to ExpressionEngine and CodeIgniter.

» Read more in the Archives.

» Have a tip? Send us your EE news.

Learn ExpressionEngine Today

Over a series of 8 videos, watch and learn as Ryan builds an entire ExpressionEngine website from beginning to end. Get started now.

MAMP Database Dump Workflow

I’ve often talked about MAMP here and how you can use it to easily localhost your EE site while it is under development. For those of you on Macs and using MAMP, here’s a nice tool for you to try.

While browsing the MAMP.info website the other day, tucked down at the bottom of the page, I noticed a tool I had not seen before: MY MAMP DUMP. Despite the funny name, MY MAMP DUMP is a small set of Automator workflows that allow you to easily (it prompts you for the information it needs) import and export databases with MAMP.

Screenshot of MY MAMP DUMP workflow

Screenshot of MY MAMP DUMP workflow.

The download comes with two workflows (one for export, one for import) and two application versions of those workflows. If you already use Automator to, well, automate some of your processes while migrating EE sites, this might come in handy.

As an aside: if you haven’t tried Automator yet, I think you should. It’s an easy way to make some of your mundane tasks faster and more efficient. Just one example is how I use it to automatically resize images for this website by dropping them in a folder on my desktop. I could further extend that by having Automator upload them to my s3 account. With shell script, applescript, Finder and tons of application support, there’s a lot you can do with it.

Posted on Jan 25, 2011 by Ryan Irelan

Filed Under: Deployment, Development Tools

Jon20:11 on 01.25.2011

I quite like Sequel Pro (http://www.sequelpro.com/) for this kind of thing - saves having to deal with phpMyAdmin on your MAMP install entirely and lets you do a DB dump pretty quickly too.

Egor18:52 on 04.16.2011

Is it possible to run those workflows right before starting TimeMachine or at least periodically on, for example, daily basis to have “almost TimeMachine” backups?

andre03:41 on 02.18.2014

I like to use free MySQL-manager - Valentina Studio, check it out if you haven’t tried it yet: http://www.valentina-db.com/va…