smallcompany - 1:11 pm on Jun 20, 2011 (gmt 0)

OK. Thanks.

The question is why you'd need to do it on selected tables.

I knew there was more than one way of transferring WP blog onto another server (same domain).

I opted for export from within WP, and installed plugins manually.

The only leftover was data from statistics plugin. It was few more tables within existing WP database.
That was what I ended up exporting each table record separately, and wondered why MySQL would complain when I tried to import (and overwrite) whole tables.