Mysql Console Commands

1) Create a new Database.
create database mydb;

2) List of all databases;
show databases;

3)Create Backup of all Database.
mysqldump -u username -p password –all-databases > dump.sql

4) Create Backup of database.

mysqldump -u username -p password mydb > dump.sql

4) Create Backup of database structure only.

mysqldump -u username -p password -no-data mydb > dump.sql

5) Import Database ;

mysq -u username -p password mydb < dump.sql