There was an excellent writeup posted here in the last few days for import and export to the databases that you may wish to read for ideas.
Update: here it is Loading, Manipulating, Recovering and Moving Long Term Statistics in Home Assistant
Want to move the csv file once? Install the Samba addon temporarily and do it graphically from your desktop may be an easier path than delving into Linux and yaml commands.
Watch your file/folder permissions are correct for read and write operations at the new location.
Consider if your integrations could be altered to write to a database rather than extending a csv text file. Do you have backup contingencies in place for your valuable historic data?