Writing Sourcec0de — Medium

Collection edited by James R. Qualls

Faster remote mysqldump

I am always looking for a faster way to export data from production to seed my development box. I try to keep my development cycle slim so…I can iterate quickly. This little trick isn’t anything fancy but I felt it was clever enough to write about. Create a file named `remote.sh`. # this will be executed on the remote machine # but exists on your local machine mysqldump -h db.url -uUSERNAME -pPASSWORD | gzip -9 Run the next command in your terminal. ssh user@host sh -s < remote.sh > FILE.sql.gz So lets talk about what is going on here.

James R. Qualls2 min read