Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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"


Uploaded Image

  • Click "Data Import/Restore" in the left plane
  • Select file, then "Start Import" - there may be some messages that look like errors.


Uploaded Image

  • 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).


Uploaded Image

  • Click Finish, and the table will open up for you to browse
  • No labels

0 Comments

You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account.