db_prefix

Locked

Views: 6,589

Results 1 to 6 of 6
This thread is locked. New replies are disabled.
25 Oct 2007, 12:17 AM
#1
tat2nu avatar

tat2nu

Zen Follower

Join Date:
Jan 2005
Posts:
178
Plugin Contributions:
0

db_prefix

I am getting ready to set up my new store with a new host but I do not remember the db_prefix I originally set up my Zen Cart with. Where can I find this information?

Thanks,
Marc

25 Oct 2007, 12:20 AM
#2
chuck avatar

chuck

Totally Zenned

Join Date:
Jul 2005
Posts:
255
Plugin Contributions:
0

Re: db_prefix

/includes/configure.php

25 Oct 2007, 2:59 AM
#3
tat2nu avatar

tat2nu

Zen Follower

Join Date:
Jan 2005
Posts:
178
Plugin Contributions:
0

Re: db_prefix

Thanks. It appears that I did not set a prefix. [define('DB_PREFIX', '');]. Will this be a problem in upgrading and moving to another hoting company? What is the reason behind a prefix?

Thanks again,
Marc

25 Oct 2007, 4:00 AM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: db_prefix

I, personally, have never needed a prefix on my table names ...

This is usually for when a person gets a domain and host some where that they are only given 1 or a limited number of database tables so the prefix helps to group the table names ...

So if the table names were normally:
admin
address_book
products
products_description
etc.

You would have with the prefix of fred_:
**fred_**admin
**fred_**address_book
**fred_**products
**fred_**products_description
etc.

as your table names ...

At the rates of hosting these days, such as our Certified Hosting sites in the link at the top of your screen, it is rare to run into this circumstance any more ...

Should you ... perhaps it is time to find a Zen Cart Certified Hosting site for your domain ...

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

29 Oct 2007, 10:49 PM
#5
hyperlite635 avatar

hyperlite635

New Zenner

Join Date:
Jun 2007
Posts:
46
Plugin Contributions:
0

Re: db_prefix

Its pretty easy to fix. I signed up with HostMonster and they add a zen_ prefix to the tables also. You just go into your config file and remove the prefix and it should work fine.

Electronic-Pulse.com
Discount consumer electronics

EPNFragrances.com
Wholesale fragrances for men and women

30 Oct 2007, 3:53 PM
#6
tat2nu avatar

tat2nu

Zen Follower

Join Date:
Jan 2005
Posts:
178
Plugin Contributions:
0

Re: db_prefix

Thanks for the explanation guys. I plan on moving to Camelot here in the next few weeks. I just got my "BOOK" so I will be bugging you a little less often... hopefully.

Marc