Moving only ONE MySQL database to a different folder, is it possible?
So my Mysql databases are all located in /var/lib/mysql which is located on /var (small partition of 11GB). Unfortunately one of the databases is getting wayyy bigger than I initially hoped for (8.5GB and growing) and as a result, /var is getting full and I am experiencing all kind of strange issues with my server (apache crashes, pages dont load, etc...).
I cleaned up /var a bit and freed about 200MB (deleted tons of logs) but this will buy me maybe a few weeks before the database grows even more and fill /var once again.
So my question: Can I safely move this huge database to a different location (drive or partition) of bigger capacity while keeping all other DB's where they are currently located? The reason being, the current location of /var is located on reliable hard drives mounted in a RAID1 array and automatically backed up to a third HDD. The other drive I would use to relocate the big DB would be a single drive not so reliable (for financial reasons, and eventually will get replaced or RAID'ed)..
I have found websites describing how to move the whole mysql DB repository (in my case /var/lib/mysql) but not how to move a single DB...
many thanks to all!!!