I repost some of my blog posts made @ liip. Please see here for the original post and comments: http://blog.liip.ch/archive/2011/04/04/beyond-mysqldump.html
There are several ways to transfer data from one mysql server to an other. Dumping a full table and re-importing it is rather simple, but sometimes you only want to transfer a selection of data. I will quickly explain the most common ones and then explain how i solved my way out of having neither phpmyadmin nor the privileges of SELECT...INTO OUTFILE.
I repost some of my blog posts made @ liip. Please see here for the original post and comments:
blog.liip.ch/archive/2009/06/18/import-serendipity-entries-into-drupal.html