Jump to content

Need a list of essential database tables related to orders, products & customers.


Recommended Posts

I'm planning to move dev site to production and I need to update outdated database tables in the dev site. I'm gonna be importing tables one by one in order to avoid any errors instead of merging/moving the whole database. So I need a list of all the essential database tables for products, orders and customers. Does anyone have a comprehensive list for this?

Link to comment
Share on other sites

all the ones that start with, after the prefix:

 

address

attribute

category

customer

feature

order

product

 

Bear in mind images will not carry over. If you need them, copy the image_ ones too

 

Thanks Nemo! That's 68 tables in total (without image_x tables), hopefully that's all of 'em.

 

@musicmaster

 

I'm gonna take a look at the source code in yours as well and see what other potential tables I'm gonna need.

Edited by Masteries (see edit history)
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...