1. Open MySQL administrator.
2. Enter the Server host name, username and password to login
3. Click on Backup
4. Click on New Project from Backup Project tab.
5. Select the database from the schemata list.
6. Press > button.
7. Check/Uncheck table names as per the requirements.
8. Click on advance options tab
9. Select Normal and complete backup
10. Click on Execute Backup now button
11. Select the path and filename for the backup file
12. Click on save button