Hi Johan,
I am Sorry. If I have complicated the senerio But, this still not fix my
purpose.
What I want is - From your example :-
/data/disk1/mysql/db1 (directory)
/db2 (directory)
/db3 (directory)
/db4 (symlink to /data/disk2/mysql/db4)
/db5 (symlink to /data/disk2/mysql/db5)
/db6 (symlink to /data/disk2/mysql/db6)
I dont want to create these directories here (/data/disk1/mysql/d4
/d5
/d6). Also is it somthing that in disk1/mysql it will not create physical
folder of it.
/disk2/mysql/db4 (directory)
/db5 (directory)
/db6 (directory)
--
Thanks and Regards,
Manasi Save
Artificial Machines Pvt Ltd.
> You don't need to move any databases. Look at this structure:
>
> /data/disk1/mysql/db1 (directory)
> /db2 (directory)
> /db3 (directory)
> /db4 (symlink to /data/disk2/mysql/db4)
> /db5 (symlink to /data/disk2/mysql/db5)
> /db6 (symlink to /data/disk2/mysql/db6)
> /disk2/mysql/db4 (directory)
> /db5 (directory)
> /db6 (directory)
>
>
> If your mysql data directory is set to /data/disk1/mysql, the server will
> pick up the symlinks there and use them as if they were just ordinary
> directories.
>
>
> On Wed, Nov 25, 2009 at 10:48 AM, Manasi Save <
> manasi.s...@artificialmachines.com> wrote:
>
>> 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.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).
>> >
>>
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql?unsub=vegiv...@tuxera.be
>>
>>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
