Backup/restore MySQL database----MySQL Workbench

1. Click on [Data Export] and the right side of the interface will show the Output window.

2. 2

   Click the [Refresh] button, refresh the database list (1), select the data table (2) to export, set the exported directory (3), click the [Start Export] button to start exporting, wait for the export Progress interface progress to complete.

   END

Iv. Restoring the Database

1. By clicking [Data Import/restore], the Data Import window will appear to the right of the interface.

2. Enter or select (1) The storage path of the database backup, click (2) [Load Folder Contents] to load the backup contents, select the database (3) and data table (4) To import, then click [Start Import] to start importing, wait for import Progress Interface progress is complete.

Backup/restore MySQL database----MySQL Workbench