I would like to extract a list of entries from on table (t1 ) based on
a field TIMESTAMP to a file reayd to be loaded into another database.
Say something like
select * into dumpfile entries from t1 where date like
'2007-11-09%' ( so extract all from table t1 done today )

on the other database I would like to

mysql -p < entries ( maybe either edit the file to specify the
databae /table or maybe some options )

from select * into dumpfile I got an error 'multiple row '
If I do a select * into outfile I have a file with every needed
entries But the format doesn't allo a reload!
Any idea ?
Many thanks in advance for your time.
Zoot