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

[joecooper]

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

[kobra]

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...pgrade-my-site

[joecooper]

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.