It's a mysql instance that I expect to run for the next week or so
chewing on a huge dataset. I'd rather not kill the process. I don't
mind stopping it for a short period of time (^Z) if that will help.
Oh dear.
I suspect you are cattled.
I know of no way personally.
Perhaps someone else does.
You're cattled. You might try to plug in another USB device and rsync
or 'cp -a' the contents of your first device to the second device,
then remove that.
Yup.
Is it a cheap USB stick? Get another, pop it in, use cpio or tar to
copy the contents of the stuck one, remove the new one. The same
process works for an expensive drive but costs more dollars.
The OP stated they didn't need the data on the mounted directory, so
everyone's mention that they are screwed until they copy data is
probably not correct. Anyway, if a forced umount doesn't do the trick,
as others have mentioned, you need to put in a new USB stick and then
umount it. Then restart MySQL.
--
Not really a wanna-be, but I don't know everything.