Edit

MySQL Basics

Subject to

add export PATH=$PATH:/usr/local/mysql/bin to ~/.bash_profile or /etc/profile

Backup database to text file

mysqldump database_name > database_name.sql

Remove database

mysql> drop database database_name;

Create database

mysql> CREATE DATABASE database_name;