MySQL Forums
Forum List  »  MySQL Shell

Where are files located/found
Posted by: PeteAp Kirkham
Date: February 27, 2021 05:38AM

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,

Options: ReplyQuote

Written By
Where are files located/found
February 27, 2021 05:38AM
February 27, 2021 10:54AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.