1) SQLyog does not import XML yet, that is right
2) CSV: try to read: http://www.webyog.com/faq/28_73_en.html. Could be a problem with escaping! Or that the table that you import to does not have the right structure (sttructure must be defined in advance, at a CSV has no such inforamtion in it). It is not possible to anyone to help more here without a small set of data that generates this. + create statement for the table + a screendump of the settings.
3) Another way is to create a new table with a subset of data using this SQL
Code:
Create table my_table select my_column1,my_column2 ect from… where .. limit etc.
It creates a new table named my_table (in the same database) with the (subset of) data that the select finds. That new my_table can then be exported/imported (to CSV or SQL), 'copied to other host', or sync'ed.
4) Copy complete table and thereafter drop irrelevant columns
I might have forgot something!
