Where are files located/found

[PeteAp Kirkham]

I'm new to the shell interface but not to Mysql.

I'm using mysql 8.0.23 and mysql shell 8.0.22

I'm having problems understanding where the export commands store files and where the import commands expect to find them.

I have used export_table to export a table and I'm told its been stored in /tmp/xxxx.json

I can import the table using that address file:///tmp/xxxx.json

tmpdir points to /tmp so I expect to find the file there but I can't find it with locate for instance (having updated the db of course)

In the other direction I'm trying to import a JSON file from my home directory and I've set the permissions to 755 but I'm getting a 'Permission denied (error code 13)' error. I have tried copying the file to /tmp and changing the path in the command but it doesn't change anything which doesn't surprise me since the /tmp referred to by the shell doesn't seem to be the system /tmp

Can someone point me in the right direction please?
Best regards,
Pete