Database's Tables to import to my new site version

[LauraPresta]

Hello guys,

 

I have a working eshop on server A, 

I duplicated server A on a server B , to upgrade prestashop and improve the theme on this test server ( B ),

So now, later, database of server A is still up to date with new clients, messages, orders etc... but server test ( B ) is not.

 

Regarding this new customers/order/messages etc...  , what are the database's tables i have to import from server A to server B ?

 

I tried to make my question clear

Edited August 20, 2016 by LauraPresta (see edit history)

[vekia]

there are a lot of dependencies in database, moreover, there is a chance that structure of tables will be different (new columns).

you say:
 

 

 

Regarding this new customers/order/messages etc.

so etc. means that you will have to re-import almost whole database, because:

- if someone order stuff - quantity of products Is decreased in db

- if products are changed - you will have to re-import ps_product tables

- forbidden carts of customers (ps_cart tables)

- orders (ps_orders tables and sales stats)
- customer accounts (ps_customer tables and ps_address tables)

- and so on ...

 

it will be much easier to say what to not re-import instead

[LauraPresta]

For those who still dont know yet, Vekia is the man !

 

 

I took time to think about your answer. So yes, it is easier to do this way || thinking about what not to keep instead of what to keep. But still it seems not clear enough for me now.

 

So from server A to B i have to :

- not keep module table (except forum ones)

- not keep the table of prestashop core that have been changed by the upgrade from 1.6.0.6 to 1.6.1.6

 

How could i know which upgrade tables will be changed for prestashop core during the upgrade ?

 

I dont find a lot of forum subject about my enquiry, but i guess it should be a common one.

 

 

(Thank you vekia ! im the personn who asked you the extra textbox on home product pro module ; )

[LauraPresta]

ho damn this site got 250 tables 

[vekia]

 

(Thank you vekia ! im the personn who asked you the extra textbox on home product pro module ; )

woooo, it was long time ago

[LauraPresta]

Because to you 3 months is like 3 years

 

So at the end of my research here is what ill do : forget my original idea, and make all the upgrade, theme, and debug in one night. I did it yesterday as a practice, this is crazy work but managing table change from 1.6.0.6 to 1.6.1.6 is way more harder.

 

Thank you again and have a good night !