I recently changed to a per-table file for InnoDB.
The problem now is I’m left over with a 70Gb old table space file which used to singularly hold the entire database.
Is there a way of reducing the size without harming the data?
I’ve tried moving the log files and old table space so that MySQL recreates them, but then the individual tables are lost via this process so I must revert to the old files.
I guess a full backup and re-insert will rectify the problem but that’s a process that takes more time than I want.