Linux commands to Backup and Restore MySQL database -

It's always a good idea to take frequent backups of your MySQL or MariaDB databases. They can potentially contain thousands of lines of irreplaceable data. Many users may be confused on how to back up their databases at first, as the process differs quite a bit from backing up ordinary files. The process of restoring a backup must also be known, as there's no point in having a backup if the user cannot reliably restore it.

This is a companion discussion topic for the original entry at