SQL for moving products from 1 store to another?

I need to move products that i've entered from one store to another ( DB1 to DB2)
which tables would i need to Export / Import

or i can remove all products and just insert all products from DB1 into DB2
my products have attributes too...
(the categories/ attributes etc. are the same in DB 1 and 2)

DB1 is ZC1.3.6
DB2 is ZC1.3.7

Upgrade DB1 to 1.3.7 (the install script allows you to run just the DB updates), then pull over all the tables with a prefix of "product_" or "products_".

This assumes you will overwrite the same tables in DB2. This also will only pull in the products, not any of the orders for said products.

Thanks!

product_ to products_ should include everything i need right ?
makes sense, if i need the product info i should look into products :sleepy:
just wanted to make sure.

That won't bring any attribute definition data over.

Database schema reference:
http://www.zen-cart.com/wiki/index.php/Developers_-_Database_Schema#Table_List_Ordered_by_Data

You're right, he is still missing some of the extras (I use "extras" loosely), but the core stuff for products, including attributes, are all indeed in the product* tables.

• products_options
• products_options_types
• products_options_values
• products_options_values_to_products_options