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
- To begin, log into your cPanel.
- Next, from the main cPanel screen, enter the File Manager section.
- 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)
- Once you are in the root folder for your store, click on the includes folder.
- You will see many files here. Highlight the configure.php file and click on the Edit button.
- 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:
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).
- 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.