Datatransfer Between Databases

If you have an database of your old store which holds lots of data you wish you use in your new store like

[list]

[]store wide discounts

[
]customer database

[]store pages

[
]products and product descriptions

[]custom shipping settings

[/list]

and so on…



And your new store starts out as a fresh database. Your old store was based on CSCart V4.2.4 and the new store is a V4.3.3



Now you already had the hassle before of importing / restoring a database which actually did more harm to your store and simply importing data. I figure a datatransfer with a tool like Navicat is much easier on the nerves but which tables should you exclude from the data transfer.



I can only come up with the following tables:

[list]

[
]cscart_settings

[]cscart_sessions

[
]cscart_logs

[]cscart_cache

[
]cscart_exim_layouts

[*]cscart_stored_sessions

[/list]

and all the tables related to previous installed (thirdparty) addons.



What tables did I exclude in this list but should be on this list ?

Do not touch the cscart_settings table. Other tables can be truncated

[quote name='eComLabs' timestamp='1437470925' post='223739']

Do not touch the cscart_settings table. Other tables can be truncated

[/quote]



You mean none of the cscart_settings_ tables should be touched as in do not transfer any data in these tables from one database to another ?



What about these tables I mentioned in original post:[list]

[]cscart_logs

[
]cscart_cache

[]cscart_exim_layouts

[
]cscart_stored_sessions

[/list]

There must be some other tables which I can ignore and not transfer from one database to another ??