[MySQL Cheatsheet] commands #mysql #cheatsheet

mysql_commands.sh

# Create a new db
mysqladmin -u root -p create some_db.test

# Create a dump from a local DB
mysqldump -u some_user -p some_db.test > some_db.test.dump.sql

# Create a dump from a remote host (like an RDS snapshot)
mysqldump -u some_user -p -h my-db-1234.somehash.us-north-1.rds.amazonaws.com some_db.test > some_db.test.dump.sql

# Populate a db using a dump
mysql -u root -p some_db.test < some_db.test.dump.sql