If this is your first visit, check our documentation. To post, register or login.
Forums / Installing on a Linux/Unix Server / I want to use old database with new install

I want to use old database with new install

Started by geel on 26 Mar 2013, 1:10 PM · Views: 4,018

Results 1 to 8 of 8
26 Mar 2013, 1:10 PM
#1
geel avatar

geel

New Zenner

Join Date:
Nov 2009
Location:
Maldives
Posts:
22
Plugin Contributions:
0

I want to use old database with new install

I am trying to install a fresh install of zen-cart v150. After installing, I want to change the new database to my old database which has lots of products and customers and other data. When I import the old database to the new one, I cant see the data in old database in the new site. I dont know much about databases but I can see the database tables prefixes different, for e.g. new database table has "xyz_admin" while the old database table has zen_admin". Could it be the problem the site not showing old data once old copy is imported.
All I need is use the old database with the new install. Pls help.

TRYING to TRY the TRUTH... http://www.hadhiyaa.com/shop

26 Mar 2013, 1:27 PM
#2
rodg avatar

rodg

Deceased

Join Date:
Jan 2007
Location:
Australia
Posts:
6,263
Plugin Contributions:
4

Re: I want to use old database with new install

geel:

All I need is use the old database with the new install. Pls help.

I'd advice against going the export/import route.

When you have the new install all up and running you should be able to edit the two configure.php files to point to the old database, then just run the DB update scripts.

As usual, make a backup of your database(s) before making any changes.

Cheers
Rod

NOTE: We are sorry that Rod is no longer with us.
We are grateful for all his contributions to the Zen Cart community.

Ozpost - The Ultimate Shipping module for Australian Merchants. Click these links for its Homepage, or Download from Zen-Cart.com.

26 Mar 2013, 2:19 PM
#3
geel avatar

geel

New Zenner

Join Date:
Nov 2009
Location:
Maldives
Posts:
22
Plugin Contributions:
0

Re: I want to use old database with new install

thanks for the quick reply. I am trying as you suggested but I dont know how to run the database update script.

TRYING to TRY the TRUTH... http://www.hadhiyaa.com/shop

26 Mar 2013, 3:35 PM
#4
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: I want to use old database with new install

I dont know how to run the database update script
Run zc_install and you should be presented with "update database only"

Zen-Venom Get Bitten

27 Mar 2013, 8:59 AM
#5
geel avatar

geel

New Zenner

Join Date:
Nov 2009
Location:
Maldives
Posts:
22
Plugin Contributions:
0

Re: I want to use old database with new install

thanks for the reply.
I edited the configure file and then uploaded it. Now it seems the site is not connecting the database. Also, since I installed zencart through simple scripts, I cant see, run zen-cart option anywhere.

TRYING to TRY the TRUTH... http://www.hadhiyaa.com/shop

27 Mar 2013, 11:01 AM
#6
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: I want to use old database with new install

geel:

thanks for the reply.
I edited the configure file and then uploaded it. Now it seems the site is not connecting the database. Also, since I installed zencart through simple scripts, I cant see, run zen-cart option anywhere.

Using these "one-click install" processes is not advised. In your case the install will auto-create a dbase name, a dbase user and dbase user-password, and will append these to the configure.php files. (So at least you have a visible reference to what the auto-install has named these components.)

If you are "not connecting to the database" it can only be a case of:

  1. The NAME of the database in the configure.php files is not correct.

  2. The USERNAME for the database in the configure.php files is not correct.

  3. The USERNAME-PASSWORD for the database in the configure.php files is not correct.

If you have made a COPY of the database (with a different name) and are now trying to point the site to that new database, then the same "rules" apply.

The USER in the database must also have ALL PERMISSIONS to administer the database. This is a stage in the C-PANEL database creation function, and cannot be missed.

20 years a Zencart User

27 Mar 2013, 8:36 PM
#7
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: I want to use old database with new install

Also, since I installed zencart through simple scripts, I cant see, run zen-cart option anywhere.
Go to the home page here and download a fresh distribution of ZenCart 1.5.0
Expand it on your PC and FTP the zc_install folder to your server

Zen-Venom Get Bitten

27 Mar 2013, 9:13 PM
#8
schoolboy avatar

schoolboy

Totally Zenned

Join Date:
Jun 2005
Location:
Cumbria, UK
Posts:
10,327
Plugin Contributions:
0

Re: I want to use old database with new install

Hey Geel... howcome you get to live in paradise (Maldives)?

I am really envious of you !

20 years a Zencart User