I was moving wordpress based blog from one server to another. Among all things I wanted to move the stats from one of my plugins which were in mysql.
In phpmyadmin I went to export on a database level, selected tables and exported them into one file.
On import I always received a complaint 1062.
I ended up going into each table separately and selecting export from there which worked fine.
I'll probably be doing more than once and I wonder if it's possible to select more than one table and export records only like when you do it for each table separately.