How to take a backup of SQL database using MySQL Workbench
follow the below steps
Open MySQL Workbench and add the DB server with administrator privileges
Now click the added DB and log in to the DB
Now click on the export data option on the lift side option
Now select the schema and click start export
It will export the data in the mentioned file path