Here’s a little tip of how I backup my mr-php MySQL database
This command will prompt for the MySQL root password and generate a compressed backup of the database in your home folder.
For restoring it, this command will uncompress it and restored to the munkireport database.
These are just two examples. You can use any user account that has access to the database and your database might not be called