Within your osCommerce application, you are able to handle most features and settings from within the admin dash panel. You may have occasion to change data directly from the database, most often when troubleshooting. Many accounts have multiple databases in them and guessing which database to use can cause disasterous results. Below is a quick guide to help you identify the exact database name your osCommerce program is using.

How to find your osCommerce database name

  1. To begin, log into your cPanel.
  2. Next, from the main cPanel screen, enter the File Manager section.
  3. Once you are in the File Manager, move through the folders to the root folder for your osCommerce store. If your main domain is the store, for example, you would navigate to the public_html folder. If you have the program running from a folder in your domain (example.com/store) then it would be under a folder with that name (public_html/store)
  4. Once you are in the root folder for your store, click on the includes folder.
  5. You will see many files here. Highlight the configure.php file and click on the Edit button.
  6. When the editor opens, you will see a lot of different settings. Find the line of code with the DB_DATABASE setting. This is the line of code with the database name at the end. For example, you will see a line of code like the one below:
    define('DB_DATABASE', 'userna5_osco111');

    The end of the line of code contains the database name> It has two parts, the first part (userna5) is the cpanel username, followed by the actual database naem (_osco111).
  7. Be sure to note the database name for later use. This now allows you to be able to locate the correct database when working with phpMyAdmin or other database management tools.
Did you find this article helpful?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve this article:
Email Address
Name

new! - Enter your name and email address above and we will post your feedback in the comments on this page!

Did you find this article helpful?

Post a Comment

Name:
Email Address:
Phone Number:
Comment:
Submit

Please note: Your name and comment will be displayed, but we will not show your email address.

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!
Need More Help?

Help Center Search

Current Customers

Email: support@WebHostingHub.com Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.
}