Skip to content

Instantly share code, notes, and snippets.

@enriquez
Created June 14, 2009 22:48
Show Gist options
  • Save enriquez/129851 to your computer and use it in GitHub Desktop.
Save enriquez/129851 to your computer and use it in GitHub Desktop.
MySQL commands
mysql> create database [database_name];
mysql> show databases;
CREATE BACKUP
mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql
RESTORE BACKUP
mysql -u root -p[root_password] [database_name] < dumpfilename.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment