Copying products using mySQL

[petenaylor]

Hi all

Is there a way of copying the mySQL tables from one Prestashop database to another?

I need to copy all of the categories and products over.

If so, which tables need copying?

Many thanks

Pete

[rocky]

The categories are in all the tables starting with ps_category, except ps_category_product, which links the products to the categories. The products are in all the tables starting with ps_product. If you have attachments, you'll need to copy the tables starting with ps_attachment and if you have attributes, you'll need to copy the tables starting with ps_attribute.