not sure what's up with the dump/import route, but using 'select into outfile' and 'load data infile' seems to work exactly as I'd expect it to. thanks joel