[Discuss] mysql issue

[Derek Atkins]

https://stackoverflow.com/questions/11484471/cant-find-the-file-created-by-outfile-in-mysql

Seems to imply it's in the MySql data directory (like /var/lib/mysql)

-derek

On Thu, February 13, 2025 3:20 pm, dan moylan wrote:
>
> i'm wondering exactly where mysql writes exported files.
>
> MariaDB [moylanus_dat]> select * from cal where cnm = 'calsch'
>                         and ca0 = 'fix' into outfile 'fixit';
> Query OK, 961 rows affected, 1 warning (0.019 sec)
>
> MariaDB [moylanus_dat]> select * from cal where cnm = 'calsch'
>                         and ca0 = 'fix' into outfile 'fixit';
> ERROR 1086 (HY000): File 'fixit' already exists
> MariaDB [moylanus_dat]>
>
> moylan 2025[1092] find / -name fixit 2> /dev/null
> moylan 2025[1093]
>
> ??
>
> tia,
> ole dan
>
> j. daniel moylan
> 84 harvard ave
> brookline, ma 02446-6202
> 617-777-0207 (cel)
> jdm at moylan.us
> www.moylan.us
> [BLM]
> _______________________________________________
> Discuss mailing list
> Discuss at lists.blu.org
> https://lists.blu.org/mailman/listinfo/discuss
>


-- 
       Derek Atkins                 617-623-3745
       derek at ihtfp.com             www.ihtfp.com
       Computer and Internet Security Consultant