mysql database - full fledge tutorial

Login to database server

sudo mysql -u root -p

List the database

show databases;

Create Database

CREATE DATABASE ebb;

Select the database

use ebb; #here ebb is the name of a database server.

Delete the database

drop database ebb;

Backup the database

backup database ebb

to disk = 'file path'

or

mysqldump -u username -p database_name > backup_file.sql

mysqldump -u username -p --all-databases > all_databases_backup.sql

mysqldump -u username -p database_name | gzip > backup_file.sql.gz

or

you can use mysqlpump with same syntax

How to access database remotely on a network?