We've run out of space on our drive, and need to move a ibd file to a different drive.
This file is for a single table.
Looking in the documentation, it is unclear to me whether I should use RENAME, or ALTER TABLE, and exactly what the syntax should be to specify the new drive and directory.
The documentation also referred to the path being specified in a my.cnf file, but I can find no such file on our drives.
Any assistance in the best method of moving this file would be appreciated.