Migrating your MySql db to EC2

First, backup your MySQL database on ix.cs.uoregon.edu

1. Start MySQL Query Server and login to ix.cs.uoregon.edu.
   
   Host: ix.cs.uoregon.edu
   Port: 3171
   User name: enter your WebDav user name.
   Password: enter your WebDav password.
   
   You are now connected to MySQL on ix.cs.uoregon.edu.
   
   
2. Select Tools > MySQL Administrator.
   
   (If you are using OS X: Start MySQL Administrator.)
   
   
3. In the Administrator view, select Backup.
   
   Click New Project (at the bottom of the Backup dialog).
   Project Name: enter a name for your backup.
   Select your database in the left pane, and click the ">" button.
   Click "Execute Backup Now"
   In the Save As.. dialog that appears, choose the folder for your backup file; click Save.
   
   The Backup will complete and report success.
   
   
4. Exit MySQL Query Browser.
   
   

Next, Restore the Backup file on your EC2 AMI Instance

1. Start MySQL Query Browser, and login to your EC2 machine.
   
   Substitute the URL for your instance in the example shown here:
   
   Host: ec2-67-202-31-249.compute-1.amazonaws.com
   Port: 3306
   User name: enter the MySQL user name you created previously.
   Password: enter the MySQL password you created previously.
   
   You are now connected to MySQL on your EC2 machine.
   
   
2. Select Tools > MySQL Administrator.
   
   
3. In the Administrator view, select Restore.
   
   Click "Open Backup File" (at the bottom of the dialog)
   In the Open dialog that appears, move to your backup file on the local host; click Open.
   Click "Start Restore"
   
   The Restore will complete and report success.