Installing the Database

Previous Top Next

---

We Now have an online Video Tutorial that covers this page at:

http://www.collectionsmax.com/installdbtutorial.html

You will need Microsoft Internet Explorer and a sound card to view it.

When you received Collections MAX Administrator there is a SQL file.  It is called BLANK DBASE.SQL and is located in the Database folder in collectionsmax.zip.

The easiest way to do this is to download the free GUI tools for MySQL.

You can find the GUI Tools at http://dev.mysql.com/downloads/gui-tools/5.0.html

After downloading and installing the tools on the Server, Open the MySQL Administrator

You will see a box popup like the one below.

Since you are connecting to MySQL on the same machine that the database is on you would type in localhost for the Server Host.  If you was connecting from a different machine on the network you would type in the ip address of the network card on the server (Example: 192.168.1.80)

Type in root for the username and then type in your root password.

Click the OK button

If all went OK you should see the following

You will then click on the Restore item on the left hand side.

Click the Open Backup File button and select the TEST DBASE.SQL file that you received when you downloaded Collections MAX Administrator.

Put a check mark in the box that says Create databases if the don't exist.

Now from the drop down combo box select New Schema... where it says Target Schema.

Type in the word collectionsmax  (all in lowercase)

THIS IS VERY IMPORTANT!  If you don't type in collectionsmax in this box your system will not work.

Click the OK Button

You should see collectionsmax in the Target Schema box

Now click the Start Restore button

After this finishes you should click the catalogs button on the left hand side.  If you see the database collectionsmax then congratulations!  You have successfully installed the database.