On 9 Nov, 14:40, zoot <a...@swing.be> wrote:
> 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

Look at the parameters for mysqldump. You can offer it a query