
- Learn MySQL
- MySQL - Home
- MySQL - Introduction
- MySQL - Installation
- MySQL - Administration
- MySQL - PHP Syntax
- MySQL - Connection
- MySQL - Create Database
- MySQL - Drop Database
- MySQL - Select Database
- MySQL - Data Types
- MySQL - Create Tables
- MySQL - Drop Tables
- MySQL - Insert Query
- MySQL - Select Query
- MySQL - Where Clause
- MySQL - Update Query
- MySQL - Delete Query
- MySQL - Like Clause
- MySQL - Sorting Results
- MySQL - Using Join
- MySQL - NULL Values
- MySQL - Regexps
- MySQL - Transactions
- MySQL - Alter Command
- MySQL - Indexes
- MySQL - Temporary Tables
- MySQL - Clone Tables
- MySQL - Database Info
- MySQL - Using Sequences
- MySQL - Handling Duplicates
- MySQL - SQL Injection
- MySQL - Database Export
- MySQL - Database Import
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
- Related Articles
- How to take backup of a single table in a MySQL database?
- Create a new database with MySQL Workbench?
- mysqldump - A MySQL Database Backup Program
- mysqlpump - A MySQL Database Backup Program
- How to get ER model of database from server with MySQL Workbench?
- Create a stored Procedures using MySQL Workbench?
- How can we take a backup of the single database by using mysqldump client program?
- How to keep the connection alive in MySQL Workbench?
- How to apply NOW() to timestamps field in MySQL Workbench?
- How to take the backup of environment variables using PowerShell?
- Declare syntax error in MySQL Workbench?
- Performance Report Controls in Mysql Workbench
- How to Create a Backup of a SQLite Database Using Python?
- How to take Backup in SAP system.
- How can we take a backup of a particular table from a database by using mysqldump client program?

Advertisements