GregGallant/SQL out to file from cmdline

Created September 24, 2014 21:10

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/GregGallant/f2492695522890e9c2a1.js"></script>
Save GregGallant/f2492695522890e9c2a1 to your computer and use it in GitHub Desktop.

Download ZIP

Suck my Outfile permissions MySQL

Raw

SQL out to file from cmdline

echo "select * FROM awesome" | mysql -u <user> -p <password> -h <host> <database> > /tmp/awesome.sql

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment