basics

mysql -h hostname -u root -p
 
create database [databasename];
 
show databases;
 
use [db name];
 
show tables;
 
describe [table name];
 
#dump to file
mysqldump –udatabaseusername –p databasename > databasename.sql
 
#import dump
mysql –unewdatabaseusername –p newdatabasename < olddatabasename.sql
 
#exlude table and show outout
mysqldump -v --ignore-table=breo_hybrid.visitorLog -u breo_shop -p breo_hybrid > test_hybrid.sql