Re: Running out of disk space
From: J.O. Aho <user_at_example.net>
Date: Fri, 14 Oct 2016 23:18:09 +0200
Message-ID: <e6d0chF6crfU1_at_mid.individual.net>
Date: Fri, 14 Oct 2016 23:18:09 +0200
Message-ID: <e6d0chF6crfU1_at_mid.individual.net>
On 10/14/2016 10:07 PM, bit-naughty_at_hotmail.com wrote:
> If my server hard disk becomes full, is there a way to stretch out the MySQL DB over multiple hard drives? What needs to be done?
[Quoted] Sure, there are different ways, not all of them are good.
- Partitioning http://dev.mysql.com/doc/refman/5.5/en/partitioning.html
- Move databases to different location and symlink the database to the default place [Quoted]
- Move the whole mysql directory to the new device and update configuration so it uses the new location.
Up to you to pick what you want to use, I would at least avoid #2 unless there is no other way.
-- //AhoReceived on Fri Oct 14 2016 - 23:18:09 CEST