At a time mysql can point to one data directory. For your task you can have
n number of mysql installation with different data directory. After that you
can use federated storage engine to perform your task.
Krishna Ch. Prajapati
On Wed, Nov 25, 2009 at 12:19 PM, Manasi Save <
> Hi All,
> I have asked this question before But, I think I am not able to describe
> it better.
> Sorry for asking it again.
> I have multiple databases but there is a limit on the folders getting
> created in one folder.
> I have mysql default directory set as /var/lib/mysql/data.
> Now, After 32000 folder creation I am not able to create more folders than
> that. Well Its not like I want to create 32000 database's in it (Which I
> wanted to earlier :-P).
> for example - I want to create 10 databases but 5 in
> /var/lib/mysql/data/d1 to d5
> and othe 5 in /var/lib/mysql/data/d6 to d10.
> but I want to access all the databases that is d1-d10.
> as I ca change the database location after 5 databases but not able to
> access old five which I have created in old location.
> Please let me know if anymore information is needed on this. I am really
> looking for the solution. Please Help me.
> Thanks and Regards,
> Manasi Save
> Artificial Machines Pvt Ltd.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: