|
DATABASE SETUP HELP
Note: Some web hosts will have already created a database and/or database user for you. If this is the case, skip
ahead to step 3 to add the tables to your database.
- Create the database
- Look in your web host's control panel for a "Database Manager" so that you can add a new
database.
- Select the button or link that lets you add a database, then enter the name that you want to use for your
database. Use a name that is less than 8 characters if possible. Once you have added the database, make a note as to what that database name is.
- Create a database user (optional)
- Some web hosts will give you a place to add or update database users. If your web host has this option, it's a
good idea to use it, to keep your server passwords safe. Look for an area in your control panel that allows you to add a database user. Enter the name that you
want to use for your database user, along with the password you want to use. Make a note of the user name and password.
- Associate the user with the database you just
created. This gives the user permission to use that database. Look for a link or button that lets you "Add a User to the Database". Then select the user
you created and the database you created, and select "Grant Permissions" or "Associate User with Database", etc. so that the two are linked
together.
-
Your database is now created, but we have to add the database tables. To do this, we'll need to access phpMyAdmin.
Look for a link on your web host's control panel to phpMyAdmin. It may be under "Databases". PhpMyAdmin has a green bar down the left side of the page and
the right part of the page is white.
- Find the database that you just created on the left side of the page. It may be just a simple
link to your database or it could be in a drop-down box.
- Look for the statements:
Run SQL query/queries on database mysite_catalog:
Or Location of the textfile:
You might have to click the SQL tab at the top of the page to find this area.
- Click the Browse button under "Or Location of the textfile".
- Locate the catalog.sql file on your computer (it's in "setup" folder, in the set of files you just
downloaded).
- Click Go to load that SQL file onto your computer.
- Having problems with this step? Another way to load the file is to open the catalog.sql file, copy everything within that
file, then paste it into your phpMyAdmin area, in the large text box under "Run SQL query/queries on database...".
|
|
Privacy Policy: We respect your privacy. We will never give your email to third party companies nor use it for sales purposes. Emails are used only for support purposes or to relay information to you about your OptionCart systems.
Copyright 2002-2006 Small Biz Community, LLC
|