Move and compact mysql database
The database for the Firewall analyzer is currently 24 GB. I would like to move the DB to a second drive on the same system and compact it, if possible.
What is the best way to move, or relocate, the DB?
Any way to compact the DB?
Thanks!
Chris