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) j...@moylan.us www.moylan.us [BLM] _______________________________________________ Discuss mailing list Discuss@lists.blu.org https://lists.blu.org/mailman/listinfo/discuss
