MySQL query results copied to new table? or download..

[thenetbox]

SELECT * FROM `post` WHERE username="nickname"

okay.. that brings up all the posts ever by a user..

how can I save these to my HD? or atleast copy them to a new table so I can download that..

or move all the results to a file..

I tried lots of variations of INSERT but I failed.. I need some help..

ahem.. help!!

[Scott MacVicar]

i find it best to do a complete database dump using phpmyadmin for specific tables or shell for bigger tables.