How to Backup and Restore the MySQL database or its tables.

backup-restore-mysql-database.sh

# BACKUP
## Backup all tables of a specific database:
mysqldump -h {HOST} -P{PORT} -u{USER} -p{DB} > {DB}.dump.sql
## Backup a specific table:
mysqldump -h {HOST} -P{PORT} -u{USER} -p{DB} -t -c --skip-extended-insert {TABLE} > {DB}.{TABLE}.dump.sql

# RESTORE
## Restore all tables of a specific database from backuped file:
mysql -h {HOST} -P{PORT} -u{USER} -p{DB} < {DB}.dump.sql
## Restore a specific table from backuped file:
mysql -h {HOST} -P{PORT} -u{USER} -p{DB} < {DB}.{TABLE}.dump.sql


# Bonus: Get size of tables
SELECT 
  table_schema as `Database`, 
  table_name AS `Table`, 
  round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` 
FROM 
  information_schema.TABLES 
  -- WHERE table_schema = 'test' -- filtrated by database name if you want
ORDER BY
  (data_length + index_length) DESC;