How to install a database from EasyDbs

Overview

Your database download will come in many formats so you will be up and running within minutes. After you've unzipped the file, follow the instructions based on what database application you have. If it's not listed here, try using the CSV format.

MySQL

phpMyAdmin - If you have phpMyAdmin installed on your server (you probably do, most hosts supply it), this will be a cinch. First login and then choose the desired database from the left frame. In the right frame click the Import tab. Choose the SQL file you just downloaded. Under 'Format of imported file' confirm SQL is selected. Now hit Go! After a few minutes you will be able to see the new table in the left pane. If the upload times out, try the command line option below.

Command line - Upload the SQL file to your server via FTP/SSH. Login to your server via a terminal (SSH, Putty, etc) and browse to the directory where you uploaded the file. Run the following command, substituting the words in CAPS with your specific values: "mysql -u USERNAME -p DATABASENAME < FILE.SQL" You will be asked for your password. After you enter it the database will import automatically.

Microsft SQL Server

Open up Microsoft SQL Server Management Studio. Connect to the desired database using your credentials. From the File Menu, choose 'Open -> File...'. Browse to the location of the .sql file and open it. Click your cursor inside the window of the newly opened sql file. In the database selector window, choose the database you want this table to be a part of. Then click the Execute (red exclaimation mark) button. After a few minutes the query will have executed and you will see a green success message. To see the new table, in the Object Explorer browse to the database you had selected, click Tables, and see the new table. Right click on it and choose 'Select top 1000 rows' to see some data.

Oracle

Open SQL Developer (or SQL Plus). Choose File->Open... Browse to the .sql file and click Open. Within the SQL worksheet, click the 'Run Script' button, or hit F5. Choose the connection you want to run this on and then the database will start to import. When done, hit the 'Commit' button, or F11. Now click through the connections tree to Tables and then find the new table. Right click and select 'Open' to see the data.

Microsoft Excel

The database comes included with a .xls file which can be opened in all versions of MS Excel from 1997-2012. Simply double click the file to open it up. The first row contains the column names.

Microsoft Access

The database comes included with a .mdb file which can be opened in all versions of MS Access from 2000-2012. Simply double click the file to open it up.

CSV Format

The CSV (comma seperated values) format is the universal data standard. If your database system does not accept the above formats, consult its instructions on how to import data via CSV. The first row contains the column names.