How to take MySQL database backup using MySQL Workbench?


To make MySQL database backup using MySQL, first we need to install MySQL Workbench. Follow the below link to install MySQL workbench.

https://dev.mysql.com/downloads/windows/installer/8.0.html

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

Updated on: 30-Jul-2019

383 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements