From: Manasi Save Date: November 25 2009 9:48am Subject: Re: question regarding mysql database location List-Archive: http://lists.mysql.com/mysql/219497 Message-Id: <10978.123.252.210.243.1259142508.squirrel@webmail.artificialmachines.com> MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit Well Waynn, In this case I need to move all the existing databases to new location right. Which I don't want to do. Is it possible that I create sym link between two and use both. -- Thanks and Regards, Manasi Save Artificial Machines Pvt Ltd. > On Wed, Nov 25, 2009 at 12:53 AM, Manasi Save < > manasi.save@stripped> 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/ name>. When mysql tries to load the data directory, it follows the > symlink > to the underlying directory (in /var/lib/mysql/data/data1). >