Exporting Database Tables and Importing to Apollo1

Each Apollo1 account has three blank databases. Students have permission to create tables within these databases. New database may not be created and these cannot be renamed. The names of the databases are: sp##07, sp##07a, sp##07b.All assignments will be done using these file names not the ones shown in the text. 

The following videos may also be beneficial:
•	Exporting MySQL Tables and Databases with phpMyAdmin
http://www.apollohosting.com/support/tutorials/view_tutorial.bml?kbid=5926 
•	Importing MySQL Tables and Databases with phpMyAdmin
http://www.apollohosting.com/support/tutorials/view_tutorial.bml?kbid=5933

Export tables from Local Computer
Click on the Export button (Notice that we are exporting SampleTable )

Make the following selections. Be sure to check Save As File and click on Go

In FireFox, the following dialog will appear. Click on OK.

In the Save dialog box, create a new folder SQLExports so that the files will be easy to locate.

Import tables to Apollo1

To login to phpMyAdmin on Apollo1, go to http://apollo1.occc.edu and click on PHPMyAdmin

Use your Apollo1 login information.

From the Database Drop-down list, select the database to which the table will be added. 
(sp0107 in the example.)
Click on the Import button.

Use the Browse button to locate the SQL file for the table to be imported.  SampleTable.sql is used  in this example. Click on Go.

A confirmation message will indicate that the tables and their data have successfully been imported. Additional tables may be imported in a similar manner.

To view the contents of the Table, click on Structure. 
In the next screen, click on Browse. 
As with all software, there is more than one way of accomplishing this. 
You may find others you prefer.