Zen Cart Logo
Forums / General Questions / Which tables do I need to backup

Which tables do I need to backup

Views: 624

Results 1 to 4 of 4
2 Dec 2014, 4:10 AM
#1
su35 avatar

su35

Zen Follower

Join Date:
Oct 2011
Posts:
168
Plugin Contributions:
0

Which tables do I need to backup

I need transfer the customer, order and product data from a v151 site to a fresh installed v153 site. I plan backup the address_book, customers, customers_xxx, order, order_xxx, products and products_xxx tables. And then, import those tables in new site DB. I am not sure if I will get the whole data or I miss some table?

2 Dec 2014, 4:33 AM
#2
bislewl avatar

bislewl

Totally Zenned

Join Date:
Dec 2011
Location:
Wisconsin, USA
Posts:
674
Plugin Contributions:
12

Re: Which tables do I need to backup

A fairly inclusive list.
address_book
categories*
customers*
manufacturers*
meta_tags*
orders*
paypal
paypal_payment_status_history
product*
products*
record*
reviews*
salemaker_sales
specials
tax*
zones*

2 Dec 2014, 1:44 PM
#4
su35 avatar

su35

Zen Follower

Join Date:
Oct 2011
Posts:
168
Plugin Contributions:
0

Re: Which tables do I need to backup

Thanks for bislewl and mc12345678. I got it.