How to take MySQL database backup using MySQL Workbench?

MySQLMySQLi Database

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
raja
Published on 21-Dec-2018 09:47:39
Advertisements