How to eliminate "Error 1086 Files already exists " in mysql

sanjay87 · 03-27-2012, 06:48 AM

Hi

i m trying to run these query in crontab but its delivering error 1086 file already exists when it runs second time,can anyone help me how can i replace the output file

cd /mysql/cron
vi crontab.sql

SELECT * FROM affiliate_supplier INTO OUTFILE '/tmp/affilaite.csv' FIELDS TERMINATED BY ','

mysql affliate -uroot -ppassword < /mysql/cron/crontab.sql

ERROR 1086 (HY000): File 'affilaite.csv' already exists

acid_kewpie · 03-27-2012, 07:43 AM

The docs say there is no way, and that is by design for security. Just delete the file first by some wrapper script.

sanjay87 · 03-28-2012, 03:56 AM

mysql -udbuser -ppassword dbname -B -e "" | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > filename.csv

I think these could help some one