Backing Up or Saving a MySQL Datatabase

This page shows you how to export a MySQL database to a file, which can then be imported ("restored"). The process is separated into three steps below.

1) Open MySQL Workbench, connect to database

 or 

2) Select Local Instance, click OK (after 1st time, it will default to this selection)

3) Select Data Export, check one "schema" (database), choose "Export to self-contained file," choose a file name, click "Start Export." This will export to the file.