How to backup data in MySQL workbench ?

The following steps can be applied to backup data in MySQL using workbench :

1. Open workbench and connect to your database using your username and password.
2. Click on "Data Export" option under "Management" at the left side of the screen.

3. You will find a list of schema from where you can select which of the schema's table do you want to backup. If you want to backup all the tables of particular table then simply click on that schema but if you want to backup only few tables of a particular schema then double click on that schema and you can see the list of tables present in the selected schema on the right side of the screen where you can unselect the table you don't want to backup.

4. Select the folder where you want the backup file to be created.

5. Finally, click on the button "start export" and wait for the operations to complete.

6. You are done. Check your specified folder to get the backup file. You can again import/restore the data whenever needed.

The above process will backup each tables separately. If you desire to backup all the tables in a single file then after step 3 in above process, click on "Export to self-contained file" radio button and also tick the option "create dump in a single transaction" and select the folder where you want to save the file. Then click on export button.