On Wed, Nov 25, 2009 at 12:53 AM, Manasi Save <
> 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).