MySQL 8.4 Secure Export and Import

[Marion Terry]

What is your opinion or advice on secure file sharing? I am contracting a Database Developer [DD] from on-line freelancer in Pakistan. The DD will analyze MySQL 8 database design and determine if and where indexes are needed. The DD will write a statistical query to create new table view. My concern? I'm a novice when it comes to securing files [database schema, tables, data, etc.] and sharing with a stranger that may be benevolent. But whether the DD is good or evil, I need a basic protocol for file sharing to protect my PC from infection whether accidental or intentional. I only have one table with sensitive info that I will not share. CGPT had two recommendations using the following tools:

One - No Cost

MySQL Workbench 8.0 – Export/Import

7-Zip – AES-256 encryption

PowerShell – SHA-256 checksum

WinSCP/FileZilla – Secure file transfer

Windows Sandbox / Docker – Isolated testing

Two - Cloud Cost

MySQL Workbench 8.0 – Export/Import

Egnyte Secure File Sharing – Encrypted storage & transfer [Cost$$$]

PowerShell – SHA-256 checksum

Windows Sandbox / Docker – Isolated restore & validation