...
C:\>"C:\Program Files\MySQL\MySQL Server 5.5\bin\mysql" --user=root --password= < C:\matlab\spm8\toolbox\CSPM\database\DBbackup_14-Feb-12.sql
MySQL
...
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
MySQL Administrator
Backing up (MySQL Administrator)
...