While most features of your PrestaShop are found in the Back Office administrative area, you may need to make adjustments outside of the interface under certain conditions. Perhaps you need to alter one or more columns in the database directly or in bulk, such as a mass price change. In cases such as this, you will need to know which database to connect your database management tool, such as phpMyAdmin, to. Below is a set of steps that will help you to determining which database your PrestaShop 1.5 store is running.

Finding the database name for your PrestaShop 1.5 store

  1. First, log into your cPanel dashboard.
  2. Once inside the cPanel, you will need to enter the File Manager.
  3. After entering the File Manager, navigate to the root folder for your PrestaShop store. In our example, the folder is named prestashop and is located under the public_html root folder.
  4. Under the root folder for your PrestaShop store, locate and enter the config folder.
  5. Now that you are in the config folder, you will need to open the settings.inc.php file. To open the file, highlight it and click on the Edit icon located in the toolbar across the top.

  6. Once opened you will see several lines of code for various settings. Look for the DB_NAME line of code. You will see the database name defined on the right side of the code line. In our example, the database name would be _pstest1. The database name will be preceded by your cPanel username (userna5). You can see a sample line of code below:
    define('_DB_NAME_', 'userna5_pstest1');
  7. Write down the database name so you can remember it. Now you can locate the particular database to use for editing no matter how many you have in your account.
Continued Education in Course Prestashop 1.5
You are viewing Section 26: 341: How to find your database name for PrestaShop 1.5
Section 25: 342: Restoring a database backup in PrestaShop 1.5
Section 27: 340: Making a mass price change for PrestaShop using phpMyAdmin
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

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

Support Center Login

Social Media Login

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!
Ask a Question

Post a Comment

Email Address:
Phone Number:

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

0 Questions & Comments

Post a comment

Back to first comment | top

Need more Help?


Ask the Community!

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

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!