Faster way to export products with SQL?

[EvanGR]

The goal:
Export products from selected categories, in SQL format.
We want all the related tables that describe those products, and only containing the wanted products.

How I would do it (the hard way):
Perform a SELECT statement on each table, to gather the wanted products, and export the results. One table at a time.

Is there a better way?

Thank you

PS. Yes, it has to be SQL data. For the fastest transfers between development-->production sites.

Thanks

[pinochico]

For the fastest transfers between development-->production sites.

We use

1. component Jmigrator
or
2. own script for transfer increments only

Is there a better way?

No, use custom mysql scripts or custom php scripts only for increments from old production to develop version and then new production.

If we create update eshop from VM2, then sure use JMigrator.
After first migration we can connect to production mysql again (in mysql are history for imports) and import only increments.