Magento MySQL database backup through terminal

If you don’t have phpMyAdmin installed but you have shell access you can use mysqldump tool. The syntax is as follow

mysqldump -h HOST -u USER -p DATABASENAME > FILENAME.sql

Where:
HOST -> is the database server hostname.

USER -> user with full privileges to the Magento database.

DATABASENAME - is the full name of the database which Magento is running.

FILENAME - can be anything you find suitable for the backup file.