On Wed, Nov 25, 2009 at 12:53 AM, Manasi Save < manasi.s...@artificialmachines.com> wrote:
> Thanks Waynn, > > I could not get your point of using symlinks. Because as per my knowledge > symlink will store same data which is there in original directory. > and What do you mean by "The limit for files is significantly higher than > > directories." > > Can you elaborate it more. > > Thanks in advance. > > So assuming /var/lib/mysql/data/ is your mysql data directory, you could create a new directory called /var/lib/mysql/data/data1, then move all the directories from /var/lib/mysql/data/* into data1. Then you could create a symlink in /var/lib/mysql/data/ pointing to /var/lib/mysql/data/data1/<dir name>. When mysql tries to load the data directory, it follows the symlink to the underlying directory (in /var/lib/mysql/data/data1).