MySQL Workbench
Backing Up
- Start MySQL Workbench (Start Menu ->All Programs->MySQL->MySQL Workbench)
- Under Server Administration, select the server instance named something like "mysqld@localhost" (otherwise see Installing MySQL).
- Click "Manage Import/Export"
Restoring
- On a new computer, install MySQL (see Installing MySQL).
- Start MySQL Workbench (Start Menu ->All Programs->MySQL->MySQL Workbench)
- Under Server Administration, select the server instance named something like "mysqld@localhost" (otherwise see Installing MySQL).
- Click "Manage Import/Export"
- Click "Data Import/Restore" in the left plane
- Select file, then "Start Import" - there may be some messages that look like errors.
- To get back, go View => Home
- To verify import, from home page under "SQL Development," select "Edit Table Data"
- Select a stored connection (localhost is fine), click next
- Under Schema, select "sidata"
- Under Table, select a table you are familiar with (e.g., subject).
- Click Finish, and the table will open up for you to browse
Add Comment