Skip to content

Instantly share code, notes, and snippets.

@trey
Last active December 13, 2015 18:29
Show Gist options
  • Save trey/4956123 to your computer and use it in GitHub Desktop.
Save trey/4956123 to your computer and use it in GitHub Desktop.
Basic MySQL Commands

Basic MySQL Commands

Create a database.

$ mysqladmin -u[username] create [database name]

Dump a database.

$ mysqldump -u[username] [database name] > dump.sql 

Load a database dump.

$ mysql -u[username] [database name] < dump.sql
@trey
Copy link
Author

trey commented Feb 14, 2013

This is a Solutions Log post.

Original location: solutions.treypiepmeier.com/2008/01/mysql-commands-you-should-have-committed-to-memory-already/

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