Also I forgot to mention that I have gone through the innodb option of innodb_data_file_path but I can just specify it as :
innodb_data_file_path=ibdata1:2048M:autoextend:max:1024M;ibdata1:2048M:autoextend:max:1024M; But not as : innodb_data_file_path=/var/lib/mysql/data/ibdata1:2048M:autoextend:max:1024M;/var/lib/mysql/data1/ibdata1:2048M:autoextend:max:1024M; Is there any wayout for this? Thanks and Regards, Manasi Save Artificial Machines Pvt Ltd. > 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: > http://lists.mysql.com/mysql?unsub=manasi.s...@artificialmachines.com > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
