Create a Mysql Database
$ mysql -u adminusername -p
mysql> CREATE DATABASE db_name;
mysql> mysql> GRANT ALL PRIVILEGES ON db_name.* TO “db_user”@”localhost” IDENTIFIED BY “passsword”;
mysql> FLUSH PRIVILEGES;
mysql> EXIT
Backup a Mysql Database
mysqldump -u db_user -p db_name > dumped_db.sql
Restore a Mysql Database
mysql -p -u db_user db_name < dumped_db.sql