Mysql Adding date/time stamp to file produced, or other method of automated file naming to keep resulting files unique
You may need to use shell script for this.
First write a script to do so.. a sample is as below
!/bin/bash

dto=date +%d'_'%b'_'%Y'_'%H_%M_%S
mysql -uroot -p dbname -e &quot; select * from table_name into outfile 'file1_$dto' &quot;

This will always give you unique names against your files.
Hope it helps.