How to take MySQL database backup using MySQL Workbench

Question

How to take database backup using MySQL Workbench? Can we take backup in the following ways-

1. Backup file(.sql) contains both Create Table statements and Insert into Table Statements
2. Backup file(.sql) contains only Create Table Statements, not Insert into Table statements for all tables
3. Backup file(.sql) contains only Insert into Table Statements, not Create Table statements for all tables

Answer 1

Hii,

You can export like this:

Hope this is helpful!!

Thank You!!