To make MySQL database backup using MySQL, first we need to install MySQL Workbench. Follow the below link to install MySQL workbench.
After installing successfully, we need to open MySQL Workbench. Choose the option “Data Export”. Here is the snapshot.
Select the database you want to export. You can also set the path here where you want to save the database.
After successful completion, you can see the following screenshot.
You have successfully created a backup of the above database. The following message is now visible.
Export of E:\BackupDatabase has finished