[Discuss] mysql issue

[jdm at moylan.us (dan moylan)]

derek writes:
>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]
>>
>> ??

> 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)

sorry, my nephew explained why i couldn't find the file.  i
should have known better.

   find / -name fixit 2> /dev/null   (didn't find it)
   sudo find / -name fixit           (did)
      /root/fixit
      /var/lib/mysql/moylanus_dat/fixit

thanks for helping,
ole dan

j. daniel moylan
84 harvard ave
brookline, ma 02446-6202
617-777-0207 (cel)
jdm at moylan.us
www.moylan.us
[BLM]