Forums / General Questions / Transferred database to new site, forgot to upload address_book table.

Transferred database to new site, forgot to upload address_book table.

Started by joecooper on 2 Jun 2015, 9:46 PM · Views: 432

Results 1 to 3 of 3
2 Jun 2015, 9:46 PM
#1
joecooper avatar

joecooper

Zen Follower

Join Date:
Aug 2011
Posts:
122
Plugin Contributions:
0

Transferred database to new site, forgot to upload address_book table.

I transferred all the old customers etc, but I missed out the address_book table.

There have been 449 new addresses in the empty table now, but I would like to add the other 5500+ from the old database.

Would it work if I just add 5500 to all of the ID's in the new database table, then copy the old ones across? Would this cause more problems?

Many thanks,

Joe

2 Jun 2015, 11:27 PM
#2
kobra avatar

kobra

Black Belt

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

Re: Transferred database to new site, forgot to upload address_book table.

Follow the steps here and DO NOT upload only those tables you think you want

Upload a complete database and if upgrading re-run zc_install and select upgrade database only

https://www.zen-cart.com/content.php?140-how-do-i-upgrade-my-site

Zen-Venom Get Bitten

3 Jun 2015, 8:26 AM
#3
joecooper avatar

joecooper

Zen Follower

Join Date:
Aug 2011
Posts:
122
Plugin Contributions:
0

Re: Transferred database to new site, forgot to upload address_book table.

Thank you for the hindsight. This was in January, and the sites been fine since then. Except for that one table.

So what happens now is that with existing customers, their customer address is showing blank. Orders still go through though.