Forums / General Questions / Configuring SQL Database for test site

Configuring SQL Database for test site

Views: 1,596

Results 1 to 2 of 2
10 Mar 2014, 18:50
#1
narata avatar

narata

New Zenner

Join Date:
Mar 2014
Location:
Florida
Posts:
6
Plugin Contributions:
0

Configuring SQL Database for test site

Hi,

I am new to development and looking for some help integrating zencart and my sql database.

I currently have a live website that uses zencart and a database to complete orders. I recently created a new subdomain and copied all of my files over in order to use it as a development test site. So I can test new code and design without the fear of messing up my existing site.

However, I need to configure a new database (which I just copied from my existing site) but I need to configure it to my new test development site so it does not interact with my live site.

Any help would be greatly appreciated. I know I need to find where zencart configures to the database, but I cannot find it.

Thanks,

10 Mar 2014, 21:10
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
174

Re: Configuring SQL Database for test site

  1. Create your new test database and a username+password for it.
  2. Edit the 2 configure.php files in Zen Cart to point to the new database and user+pwd details
  3. Import the data from the live server to the new test database

The process you're following is almost the same as: http://www.zen-cart.com/content.php?142-i-want-to-move-my-zen-cart-installation-to-another-host-or-a-different-server