Move MySQL database while instance is online
- by Mike Scott
I have a MySQL instance containing a number of databases, one of which is an archive database (although using the INNODB rather than ARCHIVE storage engine) that is not queried or written to in normal operation.
The data filesystem is filling up and I'd like to move the archive database's data directory to a different filesystem (and then symlink…